Amazon Settlement Report Reconciliation: A Worked Example
How to reconcile an Amazon settlement report to your bank deposit and books, with a full worked two-week example, journal entries and a step-by-step workflow.
To reconcile an Amazon settlement report, record every line of the settlement in an Amazon clearing account: gross sales, promotions, refunds, each fee type, reimbursements, and reserve held or released. The clearing account should then net to the exact bank deposit. When the deposit clears, the clearing account returns to zero. Revenue, profit and cash all come out right because nothing was netted away.
This guide works through one complete two-week settlement, from the raw settlement lines to the journal entries to a bridge that explains why the deposit, the revenue and the profit are three different numbers. If you want to know why recording the deposit as sales is wrong, you can see the reason in the arithmetic below.
What an Amazon settlement report actually is
Amazon pays sellers in settlement periods, which usually last about two weeks, although some accounts can request payment more often. At the end of each period, Amazon nets everything that happened in your seller account and sends the balance to your bank. That payment is the disbursement, also called the deposit or transfer. The settlement report lists every transaction behind it. In Seller Central it is under Payments, as the statement for each period, and the downloadable flat-file version has one row per transaction.
A few terms are used throughout this guide:
| Term | What it means in your books |
|---|---|
| Gross sales (product sales / principal) | What customers paid for the item before promotions and before tax. This is revenue. |
| Promotional rebates | Discounts you funded, such as coupons and promotions. This is contra-revenue, which reduces sales. |
| Marketplace facilitator tax | Sales tax Amazon collects and remits on your behalf. It is shown as collected and then withheld, and it nets to zero. |
| Referral fee | Amazon’s per-item commission. The rate depends on category; see Amazon’s fee schedule. |
| FBA fulfillment fee | The per-unit fee to pick, pack and ship FBA orders. It depends on size tier and weight. |
| Monthly inventory storage fee | Fee for space occupied in fulfillment centers. It is usually charged after the month it relates to. |
| Inbound placement service fee | Fee for Amazon’s placement of your inbound shipments across its network. |
| Refund administration fee | Amount Amazon keeps from the referral fee it credits back when you refund a customer. |
| Reimbursement | Money Amazon pays you for FBA inventory that was lost or damaged, or for customer returns that were not returned. |
| Reserve | Funds Amazon holds back from the current deposit, mainly the delivery-date-based reserve and any Account Level Reserve. They are released in a later settlement. |
| Clearing account | A temporary balance-sheet account that collects all settlement lines. It should equal the deposit, then return to zero. |
The illustrative settlement: March 3 to March 17
Illustrative example. The seller, figures and fee amounts below are invented to show the mechanics. They do not represent a real client, and they are not current Amazon fee rates. For current rates, use Amazon’s fee schedule.
A single-brand FBA seller has a settlement period of March 3 to March 17, 2026, and the deposit arrives two days later. The seller ships 520 units at a landed cost of $9.40 each. Customers return 31 units, and 22 of those go back to sellable inventory. Amazon reimburses the seller for 12 units lost in a fulfillment center. Sponsored Products charges are deducted from the seller balance rather than charged to a card.
The settlement lines, grouped
| Group | Settlement line | Amount ($) |
|---|---|---|
| Sales | Product sales (principal) | 18,400.00 |
| Sales | Promotional rebates | (920.00) |
| Tax | Sales tax collected (marketplace facilitator) | 1,196.00 |
| Tax | Marketplace facilitator tax withheld | (1,196.00) |
| Selling fees | Referral fees | (2,622.00) |
| Selling fees | Subscription fee (Professional plan) | (39.99) |
| FBA fees | FBA fulfillment fees | (2,288.00) |
| FBA fees | Monthly inventory storage fee (February) | (310.40) |
| FBA fees | Inbound placement service fee | (184.50) |
| Advertising | Cost of advertising (Sponsored Products) | (1,850.00) |
| Refunds | Refunded principal | (1,150.00) |
| Refunds | Referral fee credited back on refunds | 138.00 |
| Refunds | Refund administration fee | (27.60) |
| Refunds | Returns processing fee | (46.50) |
| Reimbursements | FBA inventory reimbursement – lost in warehouse (12 units) | 212.40 |
| Reserve | Previous reserve amount balance (released) | 3,480.00 |
| Reserve | Current reserve amount (held) | (3,915.00) |
| Total | Deposit to bank | 8,876.41 |
Settlement reports do not group lines this neatly. You will see transaction types such as Order, Refund, Service Fee, Adjustment and reserve rows, each with sub-lines. Grouping them like this is the first part of the work.
Totals by group
| Group | Net ($) |
|---|---|
| Sales after promotions | 17,480.00 |
| Sales tax (net) | 0.00 |
| Selling and FBA fees | (5,444.89) |
| Advertising | (1,850.00) |
| Refunds, net of fee credits | (1,086.10) |
| Reimbursements | 212.40 |
| Reserve movement (net increase in amount held) | (435.00) |
| Deposit | 8,876.41 |
Deposit vs. revenue vs. profit: three different numbers
The same two weeks produce three figures, and each one answers a different question.
| Number | Amount ($) | Question it answers |
|---|---|---|
| Deposit (cash received) | 8,876.41 | How much cash landed in the bank? |
| Net revenue | 16,330.00 | How much did we actually sell, after promotions and refunds? |
| Profit for the period (before overhead) | 4,517.41 | How much did we earn after product cost, Amazon costs and ads? |
A seller who books the deposit as “sales” understates revenue by more than 45% in this example. That seller also cannot see fee creep, refund trends or how much is sitting in reserve.
How the revenue figure is built
| Line | Amount ($) |
|---|---|
| Gross product sales | 18,400.00 |
| Less: promotional rebates | (920.00) |
| Less: refunds to customers | (1,150.00) |
| Net revenue | 16,330.00 |
How the profit figure is built
Cost of goods sold (COGS) does not appear anywhere in the settlement, because Amazon does not know what you paid for your products. You add it from your own inventory records. For how landed cost is built up, see our guide to calculating Amazon COGS.
| Line | Amount ($) |
|---|---|
| Net revenue | 16,330.00 |
| COGS: 520 units shipped × $9.40 | (4,888.00) |
| Add back: 22 returned units restocked × $9.40 | 206.80 |
| Lost inventory written off: 12 units × $9.40 | (112.80) |
| Gross profit | 11,536.00 |
| Referral fees, net (2,622.00 − 138.00 credited + 27.60 refund admin fee) | (2,511.60) |
| FBA fulfillment fees | (2,288.00) |
| Monthly inventory storage fee | (310.40) |
| Inbound placement service fee | (184.50) |
| Returns processing fee | (46.50) |
| Subscription fee | (39.99) |
| Advertising | (1,850.00) |
| FBA inventory reimbursement income | 212.40 |
| Profit for the period, before overhead | 4,517.41 |
The nine returned units that were not resellable stay in COGS in this example, because their cost was already expensed when they shipped. If they are later removed and liquidated, any proceeds are booked when received.
The bridge from profit to deposit
| Line | Amount ($) |
|---|---|
| Profit for the period | 4,517.41 |
| Add: COGS, net (a non-cash expense in this settlement) | 4,794.00 |
| Less: increase in Amazon reserve (3,915.00 held − 3,480.00 released) | (435.00) |
| Equals: bank deposit | 8,876.41 |
If your bridge does not tie, then either a settlement line was missed or a line was posted to the wrong account. That is the whole point of reconciling. In practice the bridge also picks up timing items such as accrued expenses and inventory purchases paid from the bank, but the logic stays the same.
Journal entries for the settlement
Most sellers record settlements through a connector such as A2X or Link My Books, which posts a summary journal or invoice per settlement into QuickBooks Online or Xero. Whether the entry is automated or manual, the accounting underneath is the same. Here is the full entry for the illustrative settlement.
Entry 1: record the settlement (dated at settlement close, or split by date; see below)
| Account | Debit ($) | Credit ($) |
|---|---|---|
| Amazon clearing (settlement receivable) | 8,876.41 | |
| Amazon reserve balance (asset): current reserve held | 3,915.00 | |
| Amazon reserve balance (asset): previous reserve released | 3,480.00 | |
| Amazon sales – product | 18,400.00 | |
| Promotions and discounts (contra-revenue) | 920.00 | |
| Refunds (contra-revenue) | 1,150.00 | |
| Marketplace facilitator tax – collected | 1,196.00 | |
| Marketplace facilitator tax – withheld by Amazon | 1,196.00 | |
| Amazon referral fees | 2,622.00 | |
| Amazon referral fees – credited on refunds | 138.00 | |
| Amazon refund administration fees | 27.60 | |
| FBA fulfillment fees | 2,288.00 | |
| FBA storage fees | 310.40 | |
| FBA inbound placement fees | 184.50 | |
| FBA returns processing fees | 46.50 | |
| Amazon subscription fee | 39.99 | |
| Advertising – Amazon Sponsored Products | 1,850.00 | |
| FBA inventory reimbursements (other income) | 212.40 | |
| Totals | 23,426.40 | 23,426.40 |
Entry 2: record the deposit (dated when the bank receives it)
| Account | Debit ($) | Credit ($) |
|---|---|---|
| Business checking | 8,876.41 | |
| Amazon clearing | 8,876.41 |
After this entry, the clearing account is back at zero for this settlement.
Entry 3: record cost of goods sold and inventory movements
| Account | Debit ($) | Credit ($) |
|---|---|---|
| COGS – Amazon product cost | 4,888.00 | |
| Inventory asset | 4,888.00 | |
| Inventory asset (22 returned units restocked) | 206.80 | |
| COGS – Amazon product cost | 206.80 | |
| COGS – lost and damaged inventory | 112.80 | |
| Inventory asset (12 units lost) | 112.80 |
Some firms post COGS per settlement and others post it once at month-end from an inventory system. Either works, as long as the units match what Amazon’s Inventory Ledger reports and the method is consistent.
Account choices worth noting
- Reserve as a separate asset. Keeping the reserve outside the clearing account lets you check, each period, that the reserve balance in your books matches what Seller Central shows as held. See how to account for the Amazon reserve balance.
- Tax lines to the same account. If collected and withheld tax both post to one marketplace-facilitator account, that account should always net to zero. A nonzero balance points to tax Amazon did not remit, which happens in some non-facilitator situations, and that needs review.
- Reimbursements. This example shows reimbursements as other income alongside a separate inventory write-off. Some firms net the reimbursement against the inventory loss instead. Pick one approach with your accountant and apply it consistently. The refunds and reimbursements guide covers each scenario.
Step-by-step: the settlement reconciliation workflow
Use this sequence for every settlement. A seller paid every two weeks reconciles about 26 settlements a year per marketplace.
- Download the settlement. In Seller Central, go to Payments and open the statement for the closed period. Download the flat-file (transaction-level) version, not just the summary. Save it with the settlement ID and dates in the file name. The IRS expects you to keep records that support the income and deductions on your return; see IRS recordkeeping guidance.
- Confirm the beginning and ending totals. Check that the report’s total equals the amount Seller Central says was transferred. If a transfer failed or was split, note it.
- Group every line. Map each transaction type and amount description to an account in your chart of accounts. Any new or unfamiliar line, such as a new fee name, is a flag to research before you post it. Amazon adds and renames fees from time to time. A standard Amazon chart of accounts makes this mapping repeatable.
- Post the settlement to clearing. Record Entry 1, either manually or by approving the connector’s summary. Check that debits equal credits and that the clearing debit equals the expected deposit.
- Match the bank deposit. When the deposit lands, match it against the clearing account; do not categorize it as income. The clearing balance for that settlement should go to zero.
- Tie out the reserve. Compare your reserve asset account to the reserve amounts on the statement. The “current reserve amount” on this settlement should equal your reserve balance after posting.
- Check the sales tax account. Collected and withheld marketplace facilitator tax should net to zero for the period.
- Post COGS from unit counts. Use units shipped, units returned to sellable stock, and units lost, damaged or disposed, priced at your inventory cost. Cross-check units against Amazon’s Inventory Ledger report.
- Review the reimbursements. List the reimbursement lines and match them to lost, damaged or customer-return events. Note any eligible events that have not been reimbursed so you can file claims within Amazon’s time limits; see the FBA inventory reimbursement policy.
- Run the bridge. Profit, plus non-cash COGS, minus the reserve increase, should equal the deposit. If it does not, look for the specific line that went astray before you adjust anything.
- Lock the period. Once all settlements for the month are reconciled and the month is closed, lock the period in your accounting software so that later edits cannot quietly change reported numbers.
When a settlement crosses month-end
Settlement periods ignore the calendar. A settlement running March 24 to April 7 contains March and April activity. If you post it all on April 7, March revenue and expenses are understated and April’s are overstated.
Illustrative example. The March 24 to April 7 settlement totals $9,200 in product sales, of which $5,100 is dated March 24 to 31. On the accrual basis, $5,100 of sales and the related fees, refunds and advertising lines belong in March. The deposit is still one bank transaction on April 9.
There are two common ways to handle this:
| Approach | How it works | Best for |
|---|---|---|
| Split by transaction date | Post two entries from one settlement: one dated March 31 for March-dated lines and one dated April 7 for the rest. Both go to the same clearing account, so the combined total still matches the single deposit. | Accrual-basis books and monthly reporting to lenders or investors. Connector tools can automate this. |
| Post at settlement close | Post the whole settlement on its closing date. | Very small sellers on the cash basis, where the timing distortion is immaterial. Confirm with your tax adviser. |
Under the split approach, the clearing account carries a balance at March 31, equal to the March-dated portion that has not yet been paid out. That is correct: it is money Amazon owes you at month-end. For the choice between cash and accrual methods, see cash vs. accrual accounting for ecommerce and IRS Publication 538.
The same timing issue affects the monthly inventory storage fee. In the example, February’s storage fee posted in a March settlement. If you report on the accrual basis, accrue it in February using the storage fee report, then reverse the accrual when the charge posts.
Common reconciliation differences and where to look
| Symptom | Likely cause | Where to look |
|---|---|---|
| Clearing balance doesn’t go to zero after the deposit | A line was not posted, or the deposit was split or failed | Settlement total vs. bank; Seller Central transfer status |
| Deposit is lower than expected but fees look normal | Reserve held increased | Reserve lines on the statement |
| Big unexplained debit | Advertising charged to the seller balance, or a fee charged at account level | Cost of advertising lines; service fee lines |
| Sales tax account has a balance | Tax collected in a jurisdiction where you, not Amazon, must remit, or a mapping error | Tax lines by state; marketplace facilitator rules |
| Negative settlement | Fees, refunds or reserve exceeded sales | Card charges on file; carry-forward to the next settlement |
| Units in COGS don’t match units shipped | Multi-channel fulfillment orders, removals or replacements counted inconsistently | Inventory Ledger; removal and replacement order reports |
| Reimbursement appears with no matching lost unit | Reimbursement for a customer return not received, or a reversal of an earlier reimbursement | Reimbursements report; customer returns report |
Who should do this, and how often
The general rule is to reconcile every settlement as it closes and to close the month within a few weeks of month-end. There are exceptions. A very small seller with few transactions may reconcile monthly. A seller on several marketplaces or channels needs each one reconciled to its own clearing account; the multichannel bookkeeping guide covers that setup. If you have months or years of deposits booked as sales, rebuilding from the settlement reports is a cleanup project and should be scoped as one.
If you would rather have every settlement reconciled, every month closed and the bridge tied out for you, our Amazon bookkeeping service does this as a monthly routine. It also produces a clean file that your tax preparer, lender or eventual buyer can rely on.
Questions sellers ask
Why doesn't my Amazon deposit match my sales in Seller Central?
The deposit is what remains after Amazon deducts referral fees, FBA fees, advertising, refunds and other charges, and after it adds or holds back reserve amounts. Sales in Seller Central are gross. You get from one to the other by booking every line of the settlement, not just the deposit.
Should I reconcile by settlement period or by calendar month?
Reconcile cash by settlement, because each settlement ties to one bank deposit. Report by calendar month. If you report on the accrual basis, split any settlement that crosses month-end by transaction date. Connector tools such as A2X can do this split automatically.
Where does sales tax collected by Amazon go?
In marketplace facilitator states, Amazon collects the tax and remits it. The settlement shows tax collected and an equal amount withheld, so the two net to zero. Record both lines to a single clearing or liability account so that your sales are not overstated.
What if my settlement has a negative balance?
When fees, refunds and reserves exceed sales, Amazon may charge the card on file or carry the shortfall forward to the next settlement. Book the settlement in full as usual. The clearing account then shows a receivable from you to Amazon rather than from Amazon to you, and it clears when the charge or the next settlement posts.