Top summary
Direct answer: Reconcile Amazon by treating each settlement as a clearing-account cycle: record gross order activity, separately classify fees, refunds, reimbursements, reserves, and transfers, then prove that the settlement closing balance equals the deposit or documented amount still in transit.
- Do not post the bank deposit as sales; it is a net transfer from an Amazon clearing account.
- Use settlement-period activity for payout proof and order-period activity for revenue cutoff.
- Finish only when every settlement transfer has a bank match or a dated in-transit explanation.
Who is this workflow for, and what decision should it complete?
This workflow is for an ecommerce founder or finance operator who sells through Amazon Seller Central and sees three different numbers: order sales, the settlement statement, and the bank deposit. The decision is whether the month can close with a defensible Amazon balance or whether a named exception still needs an owner. It applies to seller-fulfilled and FBA orders, but it is about money movement rather than physical FBA inventory.
The most important operating judgment is to separate two clocks. Amazon groups money into settlement periods, while accounting normally recognizes activity in reporting periods. A settlement may include sales from the prior month, refunds for older orders, reserve movements, and a transfer that reaches the bank after cutoff. Trying to force all of that into the bank-deposit date creates false revenue and hides liabilities.
What is the settlement-to-bank reconciliation map?
Create an Amazon clearing account for each legal entity and currency. Post order and adjustment activity into that account, then clear it when Amazon transfers cash. The core map is:
Opening Amazon clearing balance + gross sales and other credits - refunds - Amazon fees - chargebacks and other debits +/- reserve movements - transfers initiated = closing Amazon clearing balance.
| Settlement component | Book destination | Control evidence |
|---|---|---|
| Product and shipping sales | Revenue or deferred revenue under the entity's policy | Order transaction detail |
| Refunds and concessions | Sales returns plus inventory/COGS adjustment where applicable | Refund event and original order |
| Referral, fulfilment, storage and service fees | Separate expense accounts | Fee-type detail |
| Reserve withheld or released | Restricted receivable or clearing sub-account | Reserve movement and status |
| Transfer to bank | Clearing account to bank | Settlement transfer ID and bank line |
| Reimbursements | Mapped by cause, not automatically revenue | Reimbursement event and case |
This mapping is the first original-value component: it prevents a net deposit from erasing the economic events inside it.
Which difference should I investigate first?
Use a risk-based anomaly triage order rather than scanning thousands of lines. First, match the transfer amount and value date to the bank. A settlement ending on the last day of the month may be a normal deposit in transit. Second, compare the settlement statement total to the sum of exported transaction lines; a broken export range or excluded transaction type often explains a control-total gap. Third, isolate reserve movements, because they are commonly mistaken for fees. Fourth, review refunds and chargebacks that lack an original-order link. Fifth, examine reimbursements and manual adjustments, where classification risk is highest.
Assign risk levels. Green items have a documented timing resolution within the next bank statement. Amber items have valid Amazon IDs but unclear accounting classification. Red items have no source event, duplicate posting, unexpected legal entity or currency, or remain unresolved after the next settlement. This triage ladder is the second original-value component and gives the reviewer a repeatable investigation order.
Worked hypothetical example: one settlement crossing month-end
Hypothetical example—not a customer result. Assume a US home-accessories seller has an opening Amazon clearing balance of $4,800, representing sales earned but not yet transferred. During a 14-day settlement it records $96,000 of gross product and shipping sales, $7,200 of refunds, $24,600 of fulfilment, referral, storage and other fees, a $3,500 new reserve hold, a $1,400 reserve release, and a $600 lost-chargeback debit. Amazon initiates a $66,300 transfer on 31 August, and the bank receives it on 2 September.
| Bridge line | Amount |
|---|---|
| Opening clearing balance | $4,800 |
| Gross sales credits | +$96,000 |
| Refunds | -$7,200 |
| Fees | -$24,600 |
| New reserve | -$3,500 |
| Reserve release | +$1,400 |
| Chargeback | -$600 |
| Transfer initiated | -$66,300 |
| Computed closing clearing balance | $0 |
The August books record the transfer from Amazon clearing to cash in transit on 31 August, not as new sales. On 2 September, cash in transit moves to bank. Interpretation: the bank deposit is $29,700 below gross sales because it includes refunds, fees, reserve movements, a chargeback, and the opening balance. Limits: the example assumes one currency, one entity, no VAT or sales-tax liability split, and a settlement export that captures all event types.
What data is required, and what does the monthly close look like?
- Download the settlement statement and transaction-level detail for every settlement touching the month.
- Export order, refund, reimbursement and fee details using consistent timezone and currency settings.
- Load each event once into the Amazon clearing ledger using transaction IDs as deduplication keys.
- Run the clearing equation by settlement and by currency.
- Match every initiated transfer to the bank or cash-in-transit account.
- Reconcile month-end revenue cutoff separately from payout timing.
- File an exception log showing amount, cause, owner, next action and due date.
Common failures include booking deposits directly to sales, netting fees against revenue, treating reserves as expenses, mixing two Amazon marketplaces or entities in one control account, importing the same adjustment from two reports, and closing a settlement while its transfer remains unmatched without an in-transit schedule.
Definition of done: every settlement control total ties to its event detail; each transfer matches the bank or cash in transit; the clearing balance is supported by named open settlements or reserves; and unresolved red exceptions are escalated rather than written off.
When does this method need professional review?
Escalate when the seller operates multiple legal entities, uses multi-currency settlements, has material sales-tax or VAT liabilities embedded in reports, sells as both principal and agent, factors receivables, or cannot reproduce prior-period balances. Revenue recognition, indirect tax, and foreign-exchange treatment may require a qualified accountant or tax adviser. Caigeek can take the settlement exports, order detail and bank feed as inputs and return a reconciled clearing ledger, settlement bridge and exception register; legal and tax conclusions remain with qualified professionals.
For reviewer handoff, retain the raw exports unchanged, the import mapping version, settlement IDs, bank statement, journal-entry batch, and signed exception log. A spreadsheet that shows only the final tie is not enough: the reviewer must be able to trace a sampled bank dollar back through the transfer, settlement component, transaction event, and original order. Preserve timezone and currency fields because silent conversions can move events across cutoff and make an otherwise correct reconciliation appear wrong.
Self-check before sign-off
- The first paragraph directly answers the title question.
- All calculations can be reproduced from named source data.
- The hypothetical example is labeled and not presented as a customer result.
- Timing items are separated from income and expenses.
- Every unresolved exception has an owner and next action.
- Legal, tax and professional-advice limits are visible.
Sources and last updated
Last updated: 14 August 2026. Operational references reviewed for this article:
The latest user instruction waived live query-signal research for this run. The article therefore avoids claims about search volume and does not present its title as a measured ranking opportunity.
FAQ
Why is my Amazon deposit less than my sales?
Because Amazon deposits are net settlements containing fees, refunds, reserve movements, chargebacks and timing differences. Reconcile the components instead of treating the deposit as revenue.
Should Amazon reserves be recorded as an expense?
Usually no. A reserve is generally cash or a receivable temporarily withheld. Track it separately until released or validly applied.
Can I reconcile Amazon only from the bank feed?
No. The bank feed proves the transfer but not the sales, fees, refunds and adjustments inside the settlement.
What is the definition of a completed Amazon reconciliation?
Settlement totals tie to transaction detail, transfers tie to bank or cash in transit, and the remaining clearing balance has a documented composition.