Should the Amazon deposit be coded to sales?

No. The deposit is net of fees, refunds, ads, and reserve movement. Coding it to sales understates revenue, hides every fee, and makes gross margin meaningless. Record the settlement in full, then match the deposit against it.

Where does the reserve belong in QuickBooks?

In the Amazon clearing account. Anything Amazon has earned for you but not yet paid stays as a balance in that account, which is why the clearing balance should equal your unpaid Amazon balance at any point in time.

What do we do when a settlement period crosses month-end?

Split it by date. The portion earned in the closing month is accrued into that month; the rest goes to the next. Skipping the split shifts a week of sales, fees, and refunds into the wrong period every single month.

Do we still need to reconcile if A2X or ConnectBooks posts the entries?

Yes. The tool creates the summary entry; you still confirm the clearing account clears, the deposit matches, and nothing is stuck. That two-minute check is what turns automation into a reconciliation.

Why is our Amazon clearing account never zero?

Usually one of four things: an in-flight settlement, an unrecorded reserve, a deposit matched directly to sales instead of to the clearing account, or duplicate entries from a period that got imported twice.

Bottom Line / Amazon

Reconciling Amazon settlements in QuickBooks Online

Most Amazon books go wrong in the same place: someone codes the deposit to sales and moves on. This is the sequence we use instead — the one Ben ran as Controller at JoyJolt, a DTC brand selling across Amazon, Shopify, and 15+ channels on GoFlow. It isn't complicated. It just has to happen in order, every month.

First, the mental model

Amazon isn't a customer paying you for orders. Amazon is holding your money and taking its cut along the way. A settlement is a statement of what happened during a period: sales, refunds, a stack of fees, ad spend, and a reserve. The deposit is just the leftover. So the accounting has to record the statement first and treat the deposit as a transfer.

Once you accept that, everything below follows — and your gross margin starts describing the business instead of the payout calendar.

The sequence

Create one Amazon clearing account

An "other current asset" account that represents money Amazon owes you. Every settlement posts into it; every deposit comes out of it. If it drifts, you have a real signal instead of a mystery.

Build the fee accounts you actually want to watch

Referral fees, FBA fulfillment, storage, long-term storage, inbound placement, advertising, and refund administration each deserve their own expense account. One "Amazon fees" account will hide a fee increase for months.

Record the settlement gross

Gross product sales, shipping income, promotional discounts, refunds, and each fee category as separate lines — with the net landing in the clearing account. The entry should read like the settlement report, because it is the settlement report.

Split the settlement at month-end

When a period spans the close, allocate by date and accrue the closing month's share. This is the single most common reason an Amazon P&L looks fine and still isn't right.

Match the deposit, don't re-enter it

In the bank feed, match the Amazon deposit to the clearing account — never to sales. If your bank rules currently auto-categorize Amazon deposits to income, turn that rule off first.

Handle reimbursements and removals separately

Reimbursements for lost or damaged units are matched to the inventory they relate to, not swept into other income. Removals and disposals reduce inventory. Unresolved items stay on a list you can act on.

Tie inventory and COGS to units, not to cash

Cost of goods should follow units sold at a landed cost that includes freight, duty, and inbound handling — not the timing of supplier payments. Otherwise margin swings with your purchasing calendar.

Prove the clearing account before you close

The remaining balance should equal what Amazon still owes you: in-flight settlement plus reserve. When it does, the month is genuinely reconciled — that's the check we run every close.

Where it breaks in practice

Bank rules fighting the process. An auto-categorization rule sends Amazon deposits to income while your settlement entries also post revenue. Now revenue is double-counted and the clearing account never clears.
Refunds in the wrong month. The refund is deducted from a later payout, so it lands in the month the cash left rather than the month the sale reversed.
Ads treated as a fee. Advertising deducted inside a settlement belongs in ad spend, not buried with fulfillment fees — otherwise you can't see marketing efficiency at all.
Reserve ignored. A held reserve is still your money. Leaving it out of the clearing account makes the account look broken when nothing is wrong.
Duplicated imports. Re-importing a period after a correction leaves two summary entries. Always prove the clearing balance after any re-sync.

If you'd rather not hand-build the settlement entry, a tool will do it for you — we compared the two we see most in A2X vs ConnectBooks. Either way, the reconciliation step stays yours.

FAQ

Questions about Amazon settlements

Should the Amazon deposit be coded to sales?: No. The deposit is net of fees, refunds, ads, and reserve movement. Coding it to sales understates revenue, hides every fee, and makes gross margin meaningless. Record the settlement in full, then match the deposit against it.
Where does the reserve belong in QuickBooks?: In the Amazon clearing account. Anything Amazon has earned for you but not yet paid stays as a balance in that account, which is why the clearing balance should equal your unpaid Amazon balance at any point in time.
What do we do when a settlement period crosses month-end?: Split it by date. The portion earned in the closing month is accrued into that month; the rest goes to the next. Skipping the split shifts a week of sales, fees, and refunds into the wrong period every single month.
Do we still need to reconcile if A2X or ConnectBooks posts the entries?: Yes. The tool creates the summary entry; you still confirm the clearing account clears, the deposit matches, and nothing is stuck. That two-minute check is what turns automation into a reconciliation.
Why is our Amazon clearing account never zero?: Usually one of four things: an in-flight settlement, an unrecorded reserve, a deposit matched directly to sales instead of to the clearing account, or duplicate entries from a period that got imported twice.

$500 value

Get a free books review.
Find out what's costing you.

Send your last month of books. We'll audit five key areas and send a 1-page findings report within 5 business days. No card, no pitch.

★★★★★

Claim my free review

Trusted by Shopify & Amazon sellers · Reply within 1 business day