UK marketplace · Finance and Accounting role · read-only requests
1. Test the connection
Verifies Login with Amazon credentials and permission to call the current Finances API.
2. Search a past order
Returns the complete available financial transaction history, including later rebates and adjustments.
3. Prepare from Amazon API
The app bulk-downloads transactions from the ledger’s earliest purchase date through today, matches order + SKU/ASIN, fills J–T, and writes the corrected net-fee formula in U.
The default workbook was not found. Upload an .xlsx file below.
The original workbook is never overwritten. Review the audit sheets in every exported file.
Alternative: prepare from settlement reports
No API credentials are required. Upload every Amazon Flat File V2 Settlement Report covering the ledger period and later adjustments. Duplicate report files are ignored.
Settlement reports combine UK VAT into fee totals. The export applies a documented 20% VAT split and flags SKU-less multi-item adjustments for review.