Turn Amazon settlement data into cleaner books
The Amazon payout that hits your bank is not the whole story. Merchant Ledger separates fees, refunds, reimbursements, reserve activity, and COGS into accounting outputs that reduce cleanup work and make reporting more useful.
How MerchantLedger turns settlements into usable books
Five steps from Amazon settlement activity to cleaner accounting outputs and less month-end cleanup
Bring in settlement data and optional product metadata
Use connected-provider authorization to read settlement reports, financial events, and — when cost or mapping features are enabled — limited product metadata from Seller Central.
Separate the payout into accounting categories
Organize fees, taxes, refunds, reimbursements, and other activity into useful accounting buckets.
Calculate COGS from your product costs
Match order activity to your catalog and calculate Cost of Goods Sold using Average Cost.
Review the accounting-ready output
Check categorized settlement activity and account mappings before it reaches your books.
Post or export cleaner outputs
Send balanced entries to Wave, Xero, or QuickBooks, or export files for manual workflows.
The payout is not the whole accounting story
Amazon deposits roll sales, fees, refunds, reserves, reimbursements, and timing differences into one net number. MerchantLedger separates that activity into cleaner accounting outputs you can review and use.
Before MerchantLedger
1.
Record the bank deposit as if it were the full story
2.
Hide fees, refunds, reimbursements, and reserve movement inside one net number
3.
Rebuild settlement detail in spreadsheets during month-end cleanup
4.
Work from books that are harder to review and explain
With MerchantLedger
Pull in Amazon settlement activity and product data
Separate fees, refunds, reimbursements, reserve activity, and COGS into clearer categories
Review the accounting-ready output before month end
Post or export cleaner books for your accounting workflow
Example accounting output
Illustrative settlement breakdown with provider-neutral account names. Fictional data. Debits = Credits.
| Account | Debit ($) | Credit ($) |
|---|---|---|
| Payment Clearing | 3,876.52 | — |
| Amazon Product Sales | — | 5,210.00 |
| Amazon Shipping Income | — | 180.00 |
| Amazon Referral Fees | 468.90 | — |
| Amazon Fulfillment Fees | 712.45 | — |
| Amazon Storage Fees | 45.20 | — |
| Amazon Refunds | 286.93 | — |
| Cost of Goods Sold | 1,350.00 | — |
| Inventory Asset | — | 1,350.00 |
| Total | 6,740.00 | 6,740.00 |
What MerchantLedger reads to build cleaner books
We read the Amazon data needed for core settlement accounting workflows. Limited product metadata only applies when you enable product-cost or mapping features.
Settlement Reports
We fetch settlement reports so deposits, adjustments, and settlement periods can be translated into accounting activity instead of one net payout.
Financial Events
We read financial event groups including orders, refunds, fees, charges, reimbursements, and reserve-related activity posted to your account.
Product metadata when enabled
If you enable product-cost or catalog mapping workflows, we may access limited SKU, ASIN, and FNSKU metadata so order activity can be matched to products and COGS can be calculated from your Average Cost.
We use this data to classify settlement activity and support accounting outputs. We do not access buyer messages, marketplace passwords, or order-fulfillment controls as part of core settlement accounting workflows.
Read our full security & data practices for more details.
Fits your accounting workflow
Use cleaner accounting outputs in Wave, Xero, QuickBooks, or CSV-based workflows
Wave Financial
Post categorized settlement outputs to your Wave books
Xero
Send settlement outputs to Xero as journal entries or invoices
QuickBooks Online
Post summarized settlement outputs to your QBO books
CSV Export
Export categorized data for manual accounting workflows
Need a different downstream workflow? Let us know.
Security & Privacy by Design
Connected-provider authorization, encrypted credential storage, tenant-scoped access, and clear retention / deletion paths. Read how MerchantLedger handles data, what it does not access, and how you can revoke access or request deletion.
Read Security DetailsFor retention and deletion specifics, see our Privacy Policy.
Need Help?
Questions about month-end handling, setup, or your accounting workflow? We're here to help.