Staging preview — not indexed. Highlighted items are unverified claims awaiting firm confirmation.
Draft — pending CPA review (draft). This page is excluded from the production build until a named, credentialed reviewer approves it.

Amazon Seller Accounting

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.

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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.
  7. Check the sales tax account. Collected and withheld marketplace facilitator tax should net to zero for the period.
  8. 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.
  9. 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.
  10. 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.
  11. 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.

Sources

  1. Amazon Seller Central: Selling on Amazon fee schedule
  2. Amazon Seller Central: FBA inventory reimbursement policy
  3. IRS: Recordkeeping for small businesses
  4. IRS Publication 538, Accounting Periods and Methods
  5. IRS Publication 334, Tax Guide for Small Business

Talk to an ecommerce CPA about your numbers

A free 15-minute discovery call. We’ll look at where your books stand, what’s holding your margins back, and what to fix first — no obligation.

Call nowBook a call