Amazon Settlement Reconciliation: The Real Method | Korven
GUIDE · E-COMMERCE ACCOUNTING

Amazon Settlement Reconciliation.

Written by Ahmed Jaffri, Co-Founder, Operations and E-commerce · Published · Updated

Amazon does not pay you your revenue. It pays you what is left after it takes its cut. Settlement reconciliation is the process of breaking that payout back into its real parts, so your books show what you actually sold and what it actually cost, instead of one blended number that is wrong in every direction.

Get this wrong and every number downstream is wrong: revenue, margin, advertising, tax. Most generalist bookkeepers get it wrong, because they have never sold on Amazon and do not know the deposit is net. Proper ecommerce accounting treats the settlement, not the deposit, as the source of truth.

What Amazon actually deposits

Say $41,280 lands in your bank for a two-week period. A bookkeeper sees a deposit and books it as revenue. Done. That single decision poisons everything.

Because behind that $41,280 sits something like this:

Line on the settlement report Amount
Gross product sales$68,400
Refunds returned to customers-$3,150
Referral fees (~15%) Amazon's commission-$10,260
FBA fulfillment fees pick, pack, ship-$7,890
Monthly storage-$1,240
Sponsored Products spend your ad spend, deducted here-$4,980
Promotional rebates-$620
FBA reimbursements recovery, not revenue+$1,020
Net deposit to your bank $41,280

Illustrative. A real settlement has 20+ line types.

Your real revenue was $68,400, with $28,140 of costs against it. Not "$41,280 of revenue and no costs." Reconciliation is pulling that report apart and posting each line where it belongs, in the period it belongs.

Why booking the deposit as revenue breaks everything

Revenue is understated by 40%. Lenders, buyers and the IRS all care about your top line. Reporting $41k when you sold $68k misstates the business.

Your ad spend disappears. Sponsored Products is deducted inside the settlement, before the deposit. Book only the net and your advertising never appears on the P&L at all. You cannot see whether ads are profitable, because the cost is invisible. TACOS becomes impossible to compute.

Your margins are fiction. COGS gets matched against a number that is not sales, so every margin figure is meaningless.

The reserve wrecks your timing. Amazon holds part of your money in an unavailable balance. Sales land in one period, cash in another. Book on cash and you get a phantom profit month followed by a phantom loss month. This is the single biggest reason Amazon cash-basis books cannot be trusted.

Reimbursements are not revenue. They are Amazon repaying you for inventory it lost. Booked as income, they inflate revenue and hide that stock went missing.

How to reconcile it, step by step

1. Pull the settlement report. Seller Central, Reports, Payments, All Statements. Download the flat file for the period, not the summary.

2. Group every line by type. Sales, refunds, referral fees, FBA fees, storage, advertising, reimbursements, and the long tail of adjustments. The flat file gives you a transaction-type column. Sum each type.

3. Post each group to its own account. Gross sales to revenue. Each fee type to its own expense line. Advertising to its own line so it shows on the P&L. Refunds against revenue. Reimbursements against the inventory loss they offset.

4. Book the reserve as a movement, not income. The amount held moves to an unavailable-balance asset account. When it releases next period, it moves back. Your revenue is recognised when the sale happens, not when the cash clears.

5. Reconcile the total to the bank. The sum of every posted line must equal the deposit that hit your bank. If it does not tie out to the penny, you have missed a transaction type. Do not move on until it ties.

Manual or software

You can do all of this by hand from the flat file, and for a small catalog it is worth doing once so you understand every line you will ever see. At volume it is tedious and easy to get wrong.

A tool such as A2X maps settlement lines straight into QuickBooks or Xero and saves hours. But a tool pointed at a badly built chart of accounts just produces wrong numbers faster. The method is what matters. The software only automates a method you already understand.

Why a generalist bookkeeper gets this wrong

Nothing here is exotic to someone who has sold on Amazon. All of it is invisible to someone who has not. A bookkeeper who has only handled service businesses sees a bank deposit and books it as revenue, because for their other clients that is correct. For an Amazon seller it is the first domino in a chain of wrong numbers.

This is the core of what e-commerce accounting actually requires: knowing that the deposit is net, that the reserve exists, that ad spend hides inside the settlement, and that reimbursements are not sales. It is not harder accounting. It is accounting done by someone who knows where Amazon buried the money. If you are searching for an accountant for Amazon sellers, this is the specific skill to test for: ask them what the reserve is, and whether the deposit is gross or net. Amazon bookkeeping done right starts there.

Questions, Answered.

What is Amazon settlement reconciliation?+
Amazon settlement reconciliation is the process of breaking down each Amazon payout into the individual transactions behind it, then posting each one to the correct account. Amazon does not pay you your sales. It pays you what is left after referral fees, FBA fees, refunds, storage and advertising are taken out. Reconciliation separates the payout back into its real parts so your books show actual revenue and actual costs, not one blended deposit.
Why can't I just record the Amazon deposit as revenue?+
Because the deposit is net, not gross. A period with $68,400 in sales might deposit around $41,000 after Amazon's cuts. Book the $41,000 as revenue and you have understated sales by roughly 40 percent, and your advertising spend has vanished entirely, because it was deducted before the deposit ever reached your bank. You then cannot calculate margin, cannot calculate TACOS, and cannot tell whether your ads make money.
How often does Amazon settle?+
Amazon closes a settlement period roughly every 14 days and pays one net figure for the whole period. That single number can contain more than 20 different transaction types. The 14-day cycle also rarely lines up with your calendar month, which is one of the main reasons cash-basis Amazon books are unreliable.
What is the Amazon reserve and why does it matter?+
Amazon holds part of your money in an unavailable balance, called the reserve, against potential returns and claims. It is your money, but it is not in your bank yet. Because of the reserve, the sale happens in one period and the cash arrives in another. If you book on a cash basis you will report a phantom good month followed by a phantom bad one. Reconciliation on an accrual basis fixes this.
Are FBA reimbursements revenue?+
No. A reimbursement is Amazon repaying you for inventory it lost or damaged. It is the recovery of a loss Amazon caused, not a sale. Booked as revenue it inflates your income and hides the fact that inventory went missing. It should offset the original loss, not sit in your sales line.
Do I need software or can I reconcile manually?+
You can reconcile manually from the settlement report, and for a small catalog it is worth doing at least once so you understand every line. At volume it becomes tedious and error-prone, and a tool such as A2X that maps settlement lines into QuickBooks or Xero saves hours and reduces mistakes. The method matters more than the tool. A tool applied to the wrong chart of accounts just produces wrong numbers faster.
What is the single most common error you see?+
Booking the net deposit as revenue and stopping there. It is the default behaviour of a generalist bookkeeper who has never sold on Amazon, and it poisons every number downstream: revenue, margin, ad performance and tax. The second most common is treating the reserve as if it does not exist, which makes cash flow impossible to forecast.
Most sellers book the deposit and stop.

We reconcile every settlement to the line, so you see real revenue, real margin, and whether your ads actually make money. Free audit before you pay a dollar.

Get Your Free Audit →