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-06-10 14:59:34importbank_import_batch #62anonymous
2026-06-10 14:59:17importbank_import_batch #61anonymous
2026-06-10 14:59:02importbank_import_batch #60anonymous
2026-06-10 14:58:32importbank_import_batch #59anonymous
2026-06-10 14:57:16importbank_import_batch #58anonymous
2026-06-10 14:56:01importbank_import_batch #57anonymous
2026-06-10 14:55:41importbank_import_batch #56anonymous
2026-06-10 14:55:09importbank_import_batch #55anonymous
2026-06-10 14:54:43importbank_import_batch #54anonymous
2026-06-10 14:52:21importbank_import_batch #53anonymous
2026-06-10 14:52:02importbank_import_batch #52anonymous
2026-06-10 14:51:25importbank_import_batch #51anonymous
2026-06-10 14:51:00importbank_import_batch #50anonymous
2026-06-10 14:50:47importbank_import_batch #49anonymous
2026-06-10 14:50:02importbank_import_batch #48anonymous
2026-06-10 14:49:00importbank_import_batch #47anonymous
2026-06-10 14:44:50importbank_import_batch #46anonymous
2026-06-10 14:44:32importbank_import_batch #45anonymous
2026-06-10 14:44:13importbank_import_batch #44anonymous
2026-06-10 14:43:56importbank_import_batch #43anonymous
2026-06-10 14:43:19importbank_import_batch #42anonymous
2026-06-10 14:42:44importbank_import_batch #41anonymous
2026-06-10 14:42:34importbank_import_batch #40anonymous
2026-06-10 14:42:24importbank_import_batch #39anonymous
2026-05-08 19:01:40importbank_import_batch #38anonymous

Errors

WhenSeveritySourceMessage
2026-07-09 07:22:37page_okbank_import.phpRequest completed successfully
2026-07-09 07:21:57page_okbank.phpRequest completed successfully
2026-07-09 07:21:15api_okbank_data.phpRequest completed successfully
2026-07-01 16:22:28page_okbank.phpRequest completed successfully
2026-06-12 19:31:42api_okbank_data.phpRequest completed successfully
2026-06-12 18:33:56page_okbank_report_categories.phpRequest completed successfully
2026-06-12 14:48:37page_okbank_transactions.phpRequest completed successfully
2026-06-12 14:48:36page_okbank_reports.phpRequest completed successfully
2026-06-12 14:48:34page_okbank_transactions.phpRequest completed successfully
2026-06-12 14:48:27page_okbank_transactions.phpRequest completed successfully
2026-06-12 14:48:05page_okbank_report_categories.phpRequest completed successfully
2026-06-12 14:48:04page_okbank_report_categories.phpRequest completed successfully
2026-06-12 14:48:03page_okbank_report_categories.phpRequest completed successfully
2026-06-12 14:48:02page_okbank_report_categories.phpRequest completed successfully
2026-06-12 14:48:02page_okbank_report_categories.phpRequest completed successfully
2026-06-12 14:48:01page_okbank_report_categories.phpRequest completed successfully
2026-06-12 14:48:00page_okbank_report_categories.phpRequest completed successfully
2026-06-12 14:47:59page_okbank_report_categories.phpRequest completed successfully
2026-06-12 14:47:58page_okbank_report_categories.phpRequest completed successfully
2026-06-12 14:47:57page_okbank_report_categories.phpRequest completed successfully
2026-06-12 14:47:56page_okbank_report_categories.phpRequest completed successfully
2026-06-12 14:47:55page_okbank_report_categories.phpRequest completed successfully
2026-06-12 14:47:54page_okbank_report_categories.phpRequest completed successfully
2026-06-12 14:47:54page_okbank_report_categories.phpRequest completed successfully
2026-06-12 14:47:53page_okbank_report_categories.phpRequest completed successfully
Open Full Activity Log