How do you reconcile an Amazon settlement to QuickBooks?
The short answer
Reconcile from the settlement report, never from the deposit. The amount that reaches your bank is what remains after referral fees, fulfillment, storage, advertising, refunds and reserve movements have been deducted, typically 55% to 70% of gross sales. The correct entry recognizes gross sales, then each fee category as its own line, with the deposit as the balancing figure. Booking the deposit as revenue understates sales by roughly a third and hides every fee Amazon charges.
The deposit is net of forty kinds of fees. How to build the settlement entry, handle reserves, split month end, and see true margin by channel.
By Stephen Ninesling, FynScale
How do you reconcile an Amazon settlement to QuickBooks?
You reconcile from the settlement report, never from the deposit. Amazon pays every two weeks and the amount that lands in your bank is what remains after forty or more categories of fees, refunds, reserves and adjustments have been taken out. If you book the deposit as revenue, you understate sales by roughly a third and make every fee Amazon charges invisible. The correct entry recognizes gross sales, then each fee category as its own expense, and ties to the deposit exactly.
By Stephen Ninesling, FynScale
Short answers
Why doesn't my Amazon deposit match my sales? Because the deposit is net. Referral fees, fulfillment fees, storage, advertising, refunds and reserve movements are all deducted before Amazon sends the money.
Where does the real data come from? Seller Central, Reports, Payments, and either the Statement View or the flat file Transaction Report for the settlement period. Not the dashboard sales number.
How far off is the deposit from real revenue? For a typical FBA seller, the deposit lands somewhere between 55% and 70% of gross sales. Under 55% usually means an advertising or reserve issue worth investigating.
Do settlement periods align with calendar months? Almost never. Amazon's fourteen day cycle crosses month end most months, which is why an accrual entry is required at close.
Why is the deposit the wrong number to start from?
Because it is a residual, not a measurement.
An Amazon settlement is closer to a bank statement from a partner who is also your biggest vendor, your fulfillment provider and your advertising platform, and who nets everything owed in both directions before paying the difference. Reading revenue off the deposit is like reading a company's payroll cost off its checking account balance.
Here is what a single fourteen day settlement looks like for a mid sized FBA seller. Gross product sales of $214,000. The amount that reached the bank was $138,600.
| Line | Amount |
|---|---|
| Gross product sales | $214,000 |
| Shipping charged to customers | $4,100 |
| Refunds issued | ($9,800) |
| Referral fees | ($32,100) |
| FBA fulfillment fees | ($21,400) |
| Storage and long term storage | ($3,900) |
| Sponsored Products advertising | ($11,600) |
| Sales tax collected and remitted by Amazon | net zero |
| Reserve balance movement | ($1,300) |
| Promotional rebates | ($1,900) |
| Other adjustments | $2,500 |
| Deposit received | $138,600 |
Booking that $138,600 as sales understates revenue by $75,400 in a two week window. It also means referral fees, fulfillment fees, storage, and every advertising dollar Amazon charged appear nowhere in the profit and loss.
That last part is what makes it dangerous rather than merely untidy. A seller in this position cannot answer the only question that matters on Amazon, which is what a unit actually earns after Amazon takes its share.
What does the correct entry look like?
One journal entry per settlement, built from the settlement report, with the deposit as the balancing figure.
Debits and credits for the settlement above:
- Credit Product sales $214,000
- Credit Shipping income $4,100
- Debit Refunds and allowances $9,800
- Debit Referral fees $32,100
- Debit Fulfillment fees $21,400
- Debit Storage fees $3,900
- Debit Advertising expense $11,600
- Debit Promotional rebates $1,900
- Debit Reserve receivable $1,300
- Credit Other adjustments $2,500
- Debit Bank $138,600
The entry balances to the penny because the settlement report is internally complete. If it does not balance, something was missed rather than misclassified, and the usual culprits are reserve movements and prior period adjustments.
Two structural choices matter here.
Separate the fee categories. It is tempting to lump referral, fulfillment, storage and advertising into a single Amazon fees line. Do not. Referral fee is a percentage of price and moves with pricing decisions. Fulfillment fee moves with product dimensions and weight. Storage moves with how long inventory sits. Advertising is a discretionary spend you control weekly. These are four different levers and combining them removes your ability to pull any of them.
Put fees where they belong. Referral and fulfillment fees are cost of goods sold, because you cannot make the sale without incurring them. Storage is arguably COGS or operating expense depending on how you think about inventory. Advertising is an operating expense. Getting this wrong distorts gross margin, which is the number you use to decide whether a product is worth selling at all.
What is the reserve and why does it never tie?
Amazon holds a portion of your funds as a reserve against future refunds, chargebacks and claims. The balance moves between settlements without any action from you.
Practically, this means the settlement covers a period but the deposit reflects a reserve position at a moment. The two are related but not identical, and the reserve movement is the plug that connects them.
Treat the reserve as a receivable on the balance sheet, not as a reduction of revenue. The money is yours, it is simply being held. When the reserve grows by $1,300 in a period, that is $1,300 of your cash sitting with Amazon, and it belongs on the balance sheet as an asset the same way a deposit with any other counterparty would.
Sellers who net the reserve against sales end up with revenue that jumps around for reasons unrelated to selling anything, which makes trend analysis useless.
How do you handle settlements that cross month end?
Every month, and it is the single most common source of Amazon reporting noise.
A settlement running from the 26th of one month to the 8th of the next contains sales from both. If you post the whole settlement in the month the deposit landed, you have moved roughly a week of sales from one month into another.
At $214,000 per fourteen days, a week is about $107,000. On a business doing $450,000 a month, that is enough to turn a flat month into a growth month or the reverse, entirely as an artifact of Amazon's payment calendar.
The fix is to split the settlement at month end using the transaction level detail, which carries the date of each order. Post the portion belonging to the closing month as an accrual with a receivable for the funds not yet settled, then release it when the settlement arrives.
If that level of precision is more than the business needs, the acceptable shortcut is to be consistent and to disclose it. What is not acceptable is switching methods between months, because then no two months are comparable and nobody can tell which changes are real.
What about sales tax?
Amazon collects and remits sales tax in every marketplace facilitator state, which is now effectively all of them.
That money passes through the settlement in both directions and nets to zero. It is not revenue and it is not an expense. It should not touch the income statement at all.
Where sellers get into trouble is including marketplace facilitator tax in gross sales without a corresponding remittance entry, which inflates revenue by the tax amount. On a $214,000 settlement, that is potentially $15,000 or more of phantom revenue per period.
The other trap is the reverse assumption. Amazon handling marketplace tax does not eliminate the seller's own filing obligations in states where nexus exists from other activity, including inventory stored in Amazon warehouses. That is a nexus question rather than a bookkeeping question, and it is worth answering deliberately rather than assuming the marketplace covered it.
What about multiple channels?
Most sellers are not only on Amazon, and this is where a chart of accounts either earns its keep or fails.
If Amazon, Shopify, wholesale and retail all post to a single Sales account, the business has revenue but no ability to compare channels. And channel comparison is the entire game, because the same unit carries wildly different economics depending on where it sells.
Use classes, locations, or separate income and COGS accounts per channel. Whichever mechanism, the requirement is the same: you should be able to produce a gross margin by channel in under a minute without exporting anything.
A product with 44% margin on Shopify and 19% on Amazon after referral and fulfillment fees is a completely different business decision than the blended 31% that a single sales account will show you.
How long should this take each period?
Once the structure exists, fifteen to twenty minutes per settlement. Pull the report, map the categories to the entry template, confirm it balances to the deposit, post it.
The first one takes considerably longer, because the work is not the entry itself but deciding where each of Amazon's categories belongs and writing that mapping down. Amazon uses dozens of transaction type labels and adds new ones. A documented mapping is what makes every subsequent period mechanical.
The teams that struggle are the ones treating each settlement as a fresh puzzle. The teams that do this well built the map once and now spend their attention on what the numbers say rather than on assembling them.
What does good look like?
You can answer these four questions in a minute, at any time, without opening Seller Central.
What was gross Amazon revenue last month. What percentage of it went to Amazon in total, and how that splits across referral, fulfillment, storage and advertising. What contribution margin each top product delivers after all four. How much of your cash Amazon is currently holding in reserve.
If those answers require an export and an afternoon, the reconciliation is not built. If they are on a report you already look at, the accounting is doing its actual job, which is not to satisfy a filing requirement but to tell you which products deserve more inventory and which ones are quietly funding Amazon.
FynScale is a boutique AI consulting firm for accounting and finance. We work with growing ecommerce, CPG, SaaS, and professional services businesses that have outgrown their bookkeeper but are not ready for a full finance team. AI speed. Human judgment.
fynscale.com