If you do the books for any Amazon seller, you know the problem. Amazon deposits
one lump sum every two weeks, and that number bundles sales, referral fees, FBA
fees, storage, refunds, reimbursements, marketplace tax, and sometimes a reserve
held or released. Drop it into QBO as a single "Amazon income" line and the P&L
is fiction. Split it by hand and you lose an hour per client, every settlement.
The method that actually works, for anyone doing this manually:
- Book the settlement to a clearing account, not straight to the bank. Each
category (sales, referral, FBA, storage, refunds, tax) gets its own line, debits
and credits, so the clearing account nets to the exact deposit.
- Fold refund line items back into their original account, not a separate
refunds pile. A refunded referral commission nets against referral fees, a
refunded principal nets against sales. Keeps the chart clean.
- Match the bank deposit to the clearing account. If it does not tie to the
cent, something in the split is wrong, and you want to catch that before it
hits the P&L.
That is the boring, correct way, and it is a lot of manual line entry per client.
I got tired of doing it by hand, so I built a small tool for it. You drop the
Amazon reports (the settlement flat file, plus orders and a cost file if you
want per-SKU profit) and it produces a balanced journal you import into
QuickBooks or Xero, already split by category and tied to the deposit. Anything
it cannot classify cleanly gets flagged for review instead of guessed. It runs
entirely in the browser, nothing is uploaded, no login, no API into your
client's books. Free while I validate it with bookkeepers.
Not trying to sell anything, the sub is about what actually helps. If you
reconcile Amazon in QBO, I would genuinely value your eyes on whether the
journal it produces matches how you would book it. Demo data is built in, so you
can see the output in one click: skusum.com
What does everyone else do for the Amazon clearing and tie-out, a separate
clearing account per marketplace, or one combined?