Banking

Amazon order export (ZIP)

Upload the “Your Orders” / replacement export ZIP from Amazon. Retail order lines, digital orders, refunds, and replacement ID pairs load into lookup tables. Bank transactions are matched when descriptions include an Amazon order id (e.g. 111-5348495-8893821), a digital id (D01-…), or a statement code (P…) you map in amazon_statement_ref.

Bank Home Import CSV Transactions Rules

Amazon

Current import

Re-importing replaces all order lines and replacement pairs from the last ZIP (statement ref maps are kept).

Order lines4475
Distinct orders3477
Replacement pairs232
Bank tx linked0
P-code pending747

Upload

Amazon export ZIP

Use the same format as your “Replacement Orders.zip” archive: CSV files at the top level (Order History, Digital Content Orders, Replacement Orders, Refund Details, etc.). Folders under Media are ignored.

Server upload limits: upload_max_filesize = 256M, post_max_size = 264M. Both must be larger than your ZIP.

Use after adding rows to amazon_statement_ref (map statement P-code → Amazon order id) or importing new bank transactions.

Statement P-codes

Card charge references

Charges sometimes show a code like P934200E0EHMBF09S instead of an order id. Add mappings in MySQL (phpMyAdmin or CLI):

INSERT INTO amazon_statement_ref (ref_code, order_id, notes) VALUES
('P934200E0EHMBF09S', '113-1234567-8901234', 'optional note')
ON DUPLICATE KEY UPDATE order_id = VALUES(order_id), notes = VALUES(notes);

Then run Re-run link only. Rules can still match on description text for the P-code without a map.

Activity Log

Recent Bank Transactions and Errors

Transactions

WhenActionEntityBy
2026-05-08 19:01:40importbank_import_batch #38anonymous
2026-05-08 19:00:49importbank_import_batch #37anonymous
2026-05-08 19:00:36importbank_import_batch #36anonymous
2026-05-08 19:00:13importbank_import_batch #35anonymous
2026-05-08 18:59:37importbank_import_batch #34anonymous
2026-05-08 18:59:21importbank_import_batch #33anonymous
2026-05-08 18:59:08importbank_import_batch #32anonymous
2026-05-08 18:58:47importbank_import_batch #31anonymous
2026-05-08 18:57:52importbank_import_batch #30anonymous
2026-05-08 18:57:43importbank_import_batch #29anonymous
2026-05-08 18:57:30importbank_import_batch #28anonymous
2026-05-08 18:57:06importbank_import_batch #27anonymous
2026-05-08 18:56:18importbank_import_batch #26anonymous
2026-05-08 18:56:02importbank_import_batch #25anonymous
2026-05-08 18:55:28importbank_import_batch #24anonymous
2026-05-08 18:55:12importbank_import_batch #23anonymous
2026-05-08 18:52:05importbank_import_batch #22anonymous
2026-05-08 18:51:50importbank_import_batch #21anonymous
2026-05-08 18:51:17importbank_import_batch #20anonymous
2026-05-03 15:27:11report_category_applybank_transaction #46anonymous
2026-05-03 15:27:11createbank_classification_rule #52anonymous
2026-05-03 15:26:35report_category_applybank_transaction #4405anonymous
2026-05-03 15:26:35createbank_classification_rule #51anonymous
2026-05-03 15:26:11report_category_applybank_transaction #4415anonymous
2026-05-03 15:26:11createbank_classification_rule #50anonymous

Errors

WhenSeveritySourceMessage
2026-05-09 20:51:31page_okbank_reports.phpRequest completed successfully
2026-05-09 20:51:20page_okbank_transactions.phpRequest completed successfully
2026-05-09 20:51:20page_okbank_transactions.phpRequest completed successfully
2026-05-09 20:51:20page_okbank_transactions.phpRequest completed successfully
2026-05-09 20:51:20page_okbank_transactions.phpRequest completed successfully
2026-05-09 20:51:20page_okbank_transactions.phpRequest completed successfully
2026-05-09 20:51:19page_okbank_transactions.phpRequest completed successfully
2026-05-09 20:51:19page_okbank_transactions.phpRequest completed successfully
2026-05-09 20:51:19page_okbank_transactions.phpRequest completed successfully
2026-05-09 20:51:19page_okbank_transactions.phpRequest completed successfully
2026-05-09 20:51:19page_okbank_transactions.phpRequest completed successfully
2026-05-09 20:51:18page_okbank_transactions.phpRequest completed successfully
2026-05-09 20:51:18page_okbank_transactions.phpRequest completed successfully
2026-05-09 20:51:18page_okbank_transactions.phpRequest completed successfully
2026-05-09 20:51:18page_okbank_transactions.phpRequest completed successfully
2026-05-09 20:51:18page_okbank_transactions.phpRequest completed successfully
2026-05-09 20:51:18page_okbank_transactions.phpRequest completed successfully
2026-05-09 20:51:18page_okbank_transactions.phpRequest completed successfully
2026-05-09 20:51:18page_okbank_transactions.phpRequest completed successfully
2026-05-09 20:51:17page_okbank_transactions.phpRequest completed successfully
2026-05-09 20:51:17page_okbank_transactions.phpRequest completed successfully
2026-05-09 20:51:17page_okbank_transactions.phpRequest completed successfully
2026-05-09 20:51:17page_okbank_transactions.phpRequest completed successfully
2026-05-09 20:51:16page_okbank_transactions.phpRequest completed successfully
2026-05-09 20:51:16page_okbank_transactions.phpRequest completed successfully
Open Full Activity Log