A real settlement reconciliation
The exact worksheet decomposing one Amazon settlement into sales, fees, refunds, and reserve, tied to the deposit.
QuickBooks Amazon reconciliation
Amazon does not pay you per order — it disburses a net settlement, and that deposit hides your real sales behind referral fees, FBA fees, refunds, and reserves. Reconciliation means decomposing each settlement back into its parts in QuickBooks so the payout ties to gross sales, every fee is visible, and nothing is a mystery. We set that up, tie every settlement to the deposit, and keep it current.
QuickBooks Amazon reconciliation means taking each net payout Amazon deposits into your bank and breaking it back into the real transactions behind it — product sales, the fees Amazon deducted, the refunds it returned to buyers, and any reserve it held — so the deposit ties to what you actually sold. It is a specific discipline because Amazon pays differently from a normal customer: not one order at a time, but a lump settlement that already has everything netted out of it.
Most Amazon seller files we see are not broken because the owner did anything foolish — they are broken because a settlement deposit is easy to post as a single line and impossible to trust once you do. Book the payout as "sales" and your revenue reads far too low, because every fee Amazon took vanished into that one number, and none of your selling costs are anywhere in the books. This is the ecommerce version of a discipline that applies to every payment processor, and it is one channel of a full QuickBooks for ecommerce setup. When months of settlements have already been posted as lumps, untangling them is a focused QuickBooks cleanup — the same craft, pointed at Amazon's books.
An Amazon settlement report is the itemized statement behind each disbursement — the detailed record of every transaction Amazon rolled into the money it sent you. Amazon disburses on a recurring settlement cycle rather than per order, so each report covers a closed period and nets to exactly one deposit. That report, not the bank line, is where the reconciliation starts.
The reason reconciliation takes real work is the number of distinct line types packed into one settlement. A single report typically carries product sales (what buyers paid for your items), referral fees (Amazon's per-sale commission, which varies by category), FBA fulfillment fees (the per-unit charge to pick, pack, and ship, which varies by size and weight), FBA storage fees (the ongoing charge to warehouse inventory), refunds returned to buyers, reimbursements Amazon credits back for lost or damaged units, and a reserve Amazon may hold or release. We name these categories factually and do not quote fee rates, because they differ by product and change over time — what is constant is that each type has to land in its own account. The deposit is simply the arithmetic of all of them: sales, minus every fee and refund, plus or minus the reserve movement, equals the net Amazon wired.
The gap between what you sold and what Amazon deposited is the whole reason this reconciliation exists — the deposit is a net figure with fees and refunds already subtracted and a reserve possibly withheld, so it is structurally smaller than gross sales and never equal to it. The job is to account for every dollar of that gap rather than let it disappear into a lump entry.
Settlement decomposition
Reconciled properly, that gap stops being a mystery and becomes a set of readable costs. You can see what referral fees are taking out of each dollar, what fulfillment is really costing, how much came back as refunds, and how much is temporarily held in reserve. None of it requires trusting a number — the settlement report is the evidence, and the reconciliation is the arithmetic that proves the deposit. It is the same principle as a bank reconciliation, where every item on the statement must be accounted for before the balance ties; here the settlement report plays the role of the statement.
Amazon's fees are recorded as expenses in their own accounts, not netted invisibly against sales, so you can actually read what selling on Amazon costs you. The two families of fee behave differently and belong in different places: the referral fee is a commission on the sale, while FBA fees are the cost of fulfillment and storage.
The referral fee is what Amazon charges for the sale itself — a percentage that varies by product category — and it belongs in a selling-fee expense account so your commission cost is visible on the profit-and-loss. FBA fulfillment fees are the per-unit charges to pick, pack, and ship an order, and FBA storage fees are the recurring cost of keeping inventory in Amazon's warehouses; both are fulfillment costs and belong grouped as such, separate from the referral commission. Keeping these apart is what turns the payout gap into management information: a seller who can see fulfillment cost as its own line can decide what to send to FBA and what to fulfill another way. We do not quote the rates — they differ by item and change — but we make sure each fee type Amazon reports lands in the account that makes it readable.
Refunds, reimbursements, and reserves are the three items sellers most often lose track of, and each has a correct place in the reconciliation. A refund reduces revenue, a reimbursement adds it back, and a reserve is money held rather than lost — get those three straight and the settlement ties.
A refund is money Amazon returned to a buyer, and it belongs as a contra-revenue reduction against sales, not as an expense and never ignored — booked correctly, your net sales tell the truth about what you kept. A reimbursement is the opposite: a credit Amazon issues when a unit is lost or damaged in its network, and it has to be recorded so it is not mistaken for a sale. The reserve is the one that confuses most sellers, because it makes a deposit smaller for a reason that has nothing to do with sales: Amazon holds an amount back as a buffer and releases it in a later settlement. Recorded as a receivable — money Amazon owes you — the reserve explains the shortfall in one period and clears when the next settlement releases it, so both periods reconcile instead of leaving a permanent unexplained gap. When those movements have gone unrecorded for months, straightening them is exactly the kind of focused work a QuickBooks cleanup exists to do.
A settlement ties back to gross sales when every component on the report is posted and the arithmetic closes: sales, minus referral fees, minus FBA fees, minus refunds, plus or minus the reserve movement, equals the net deposit on the bank statement. That equation is the proof — when it balances to the penny, the reconciliation is done and the deposit is trustworthy.
In practice we build one summarized entry per settlement that carries each line type to its account, then confirm the net matches the deposit that actually cleared the bank. Gross sales sit in income at full value; the fees sit as expenses; refunds reduce revenue; the reserve sits as a receivable until released. Because the entry is built from the settlement report, it reconciles against the bank the same way every period — the first one takes the setup, and each one after follows the same shape. This is the identical discipline behind every payout reconciliation, whether the money comes from Amazon, a card processor, or another marketplace; the line names change, the method does not. You can read the standard we hold every reconciliation to on our methodology page.
How it goes
Whether you need a one-time catch-up or ongoing monthly work, the shape is the same: a free review, a pass to set up the settlement decomposition, reconciliation of each payout to the bank, and a handback. Sellers who are months behind start with a catch-up; sellers who are current move straight to a clean monthly rhythm.
Day 0
Read-only look at the file: how settlements are posting today, which fees are missing, and how far behind the books are.
Week 1
Accounts built for sales, referral fees, FBA fees, refunds, and reserves; the settlement entry structured once.
Weeks 1–2
Each settlement decomposed and tied to its deposit; reserves recorded as receivables; refunds and reimbursements sorted.
Ongoing
A file that ties, a written summary of what changed, and either a handback or ongoing monthly bookkeeping.
What changes
A file that decomposes each settlement tells the truth about sales, fees, and reserves; a file that posts the net deposit as one line hides all three. Here is the difference line by line.
| Settlement decomposed | Posted as a lump | |
|---|---|---|
| Gross sales recorded at full value | — | |
| Referral fees visible as an expense | — | |
| FBA fulfillment and storage fees separated | — | |
| Refunds reduce revenue correctly | — | |
| Reserves recorded as a receivable | — | |
| Marketplace-facilitator tax kept as pass-through | — | |
| Net payout ties to the bank deposit | — | |
| Verdict | A file you and your CPA can trust | Understated revenue nobody can act on |
What it costs
Real ranges depend on settlement volume, channels, and how far behind the books are. The floors shown are published starting points; a free review sets your scope.
| Engagement | Typical range | Timeline | What's included |
|---|---|---|---|
| Amazon catch-up / cleanup | From $1,500 | 2–4 weeks | Decompose past settlements, restore missing fees and refunds, rebuild the accounts, reconcile to the bank. |
| Monthly bookkeeping | From $400/mo | Ongoing | Each settlement decomposed and tied, reserves tracked, fees and refunds kept current, one marketplace. |
| Multi-channel | From $1,500 | Scoped | Amazon plus other marketplaces or a storefront consolidated into one reconciled file. |
| Get your range after a free review | |||
Amazon catch-up / cleanup
Monthly bookkeeping
Multi-channel
One senior specialist sets up and reconciles your file from a documented plan — not an offshore pool learning what a settlement report is on your books. Every Amazon seller we take on gets the same mechanics applied deliberately: settlements decomposed, fees made visible, reserves tracked, net payouts tied to the deposit.
Our discipline is verification, not assertion. We tie each settlement to the deposit and show you the arithmetic, rather than telling you it balances. Access stays minimal — read-only access to your file or reports you export, or a screen-share you control, never your Amazon Seller Central admin credentials or your banking logins. And we stay in our lane: we keep the books accurately and consistently and hand your CPA a file that already ties, but we do not file returns, set positions on marketplace-facilitator or income tax, or give tax advice. That line is deliberate, and being honest about where our job ends is part of doing it well. You can read the full method on our methodology page.
Skip us when your file already works. If each settlement already decomposes into sales, fees, refunds, and reserves, your net payouts already tie to the bank, and your profit-and-loss already shows full gross sales with fulfillment cost visible, there is nothing here for us to fix — and no reason to pay someone to reconcile a file that already ties.
Skip us, too, when what you actually need is a different professional. If you need last year's return prepared, a position on where you owe sales tax, or advice on nexus, that is your CPA's work, not ours. If your volume is low enough that a single monthly summary entry keeps you square and you are comfortable in QuickBooks, you may be able to maintain it yourself with a cleanup checklist and no invoice from anyone. We will tell you which case you are in during the free review, even when the honest answer is that you do not need us.
You don't have to take our word for it. Here is the evidence you can check — the deliverable you receive, the method we use to prove a settlement ties, and our response commitment.
The exact worksheet decomposing one Amazon settlement into sales, fees, refunds, and reserve, tied to the deposit.
Each settlement decomposed and reconciled to the deposit, every fee traced to its account. Read the discipline we apply.
Read the full methodA real specialist replies within one business day, in writing.
Remote-first, nationwide
Mon–Sat · 8am–6pm CT
We work entirely remote — secure read-only access to your file or exported reports, screen-share whenever you want to watch, and every reconciliation documented in writing.
Because a payout is never the same number as your sales. Amazon takes referral fees, FBA fulfillment and storage fees, refunds it returned to buyers, and any reserve it holds back — all before it wires you the net. If you post the deposit as a single lump of income, your books show far less revenue than you actually made and none of the fees you actually paid. Reconciliation splits the settlement into those parts so the net payout ties back to gross sales.
It is the itemized statement Amazon produces for each disbursement — the detail behind the money that lands in your bank. It lists the transactions in that period as line types: product sales, referral fees, FBA fees, refunds and reimbursements, and any reserve adjustment, netting to the amount deposited. The settlement report is the source document for the reconciliation the way a bank statement is for a bank reconciliation: everything on it has to be accounted for before the deposit ties.
Amazon disburses on a recurring settlement cycle rather than per order — for many sellers that is roughly every two weeks, though the cadence and any reserve terms are set by Amazon and can differ by account. The reconciliation does not depend on the exact schedule: whatever the cycle, each settlement is a closed period with its own report, and we tie that period's activity to that period's deposit. We describe the mechanics structurally and do not assert a fixed schedule for your specific account.
Usually no, and usually you should not want to. For most sellers the right unit of reconciliation is the settlement, not the order: one summarized entry per settlement period that captures sales, each fee type, refunds, and the reserve, tying to the one deposit. Order-level detail belongs in Amazon's reports and can be summarized in; duplicating thousands of individual orders into QuickBooks bloats the file without making the deposit tie any better. We map to the level that reconciles cleanly for your volume.
As expenses, not as a reduction hidden inside sales. FBA fulfillment fees and monthly storage fees are costs Amazon charges you to pick, pack, ship, and warehouse — so they belong in fee or fulfillment expense accounts where you can actually see what fulfillment costs you. Referral fees, the commission Amazon takes per sale, are a separate selling-fee expense. Grouping them by type is what lets you read what Amazon really costs your business, instead of a mystery gap between sales and payout.
In most U.S. states Amazon collects and remits sales tax on your behalf as a marketplace facilitator, which changes how it should appear in your books — it is a pass-through Amazon handles, not revenue you keep and not a liability you remit for those sales. Recording it as income overstates your revenue. We keep marketplace-facilitator tax coded as the pass-through it is, and where your filing obligations are in question, that position is set with your CPA. We make QuickBooks reflect it; we do not decide the tax position.
We structure the books so your product costs post to cost-of-goods-sold rather than being buried in general expenses, so gross margin is readable against sales. How precise inventory tracking gets depends on your operation and your systems — perpetual inventory through an integration, or periodic cost adjustments layered on purchases. The reconciliation focus of this page is the settlement-to-deposit tie; the inventory and COGS structure is part of the broader ecommerce bookkeeping we set up alongside it.
A reserve is money Amazon holds back from a payout — an amount it keeps as a buffer against refunds and chargebacks and releases in a later settlement. It matters for reconciliation because it explains part of the gap between what you sold and what was deposited: the missing amount is not lost, it is held. Recorded correctly, a reserve sits as a receivable — money owed to you by Amazon — and clears when the later settlement releases it, so both periods still tie.
Yes, and with Amazon that is often where we start. Sellers fall behind because the settlement detail is relentless and a lump deposit is easy to post and impossible to trust, so months of payouts pile up unreconciled. A catch-up decomposes each of those past settlements, restores the fees and refunds that were never recorded, and rebuilds the accounts so the picture is real. Once the file is current, keeping each new settlement tied is light, repeatable work. The free review tells you how far behind you actually are.
No. We keep the books — decomposing settlements, recording fees and refunds, reconciling payouts to deposits — so the file is accurate and current. Your CPA sets tax positions, handles sales-tax and income-tax filings, and gives tax advice. Clean, reconciled Amazon books make their work faster and cheaper; they do not replace it. We work alongside your CPA, not instead of them.
It depends on your settlement volume, how many marketplaces or channels you sell across, how far behind the books are, and whether you need a one-time catch-up or ongoing monthly work. We set a fixed scope and a fixed fee after a free review rather than quoting a number that has to change later. The floors on this page are published starting points; the review sets your real range.
Amazon is one channel of the same craft. See QuickBooks for ecommerce for multi-channel bookkeeping, the standard bank reconciliation this method mirrors, and the full QuickBooks cleanup an Amazon catch-up is part of. Browse every industry we work in.