Every seller has done this sum. You add up the month's sales, look at what actually landed in the bank, and the two numbers refuse to meet. Then the bookkeeping turns into an evening of screenshots: the marketplace dashboard says one thing, the accounting software says another, and the bank deposit matches neither.
This is one of the most common problems sellers and bookkeepers raise, and it is almost never a missing-payment problem. A payout is not a payment for your sales. It is what is left of many sales after the marketplace has taken what it deducts and held what it holds — delivered on the marketplace's schedule, not yours.
What is hiding inside one deposit
- Fees, taken before you see the money. Referral, fulfilment, and processing fees come out of the payout. If you record the deposit as income, your revenue is understated and the fees vanish as an expense.
- Refunds from old orders. A refund issued this week is deducted from the next payout — so a deposit drops because of a sale from last month, not because this week's sales were bad.
- Reserves and holds. Marketplaces hold a portion back against future disputes and release it later, which moves money between months without any sale changing.
- Batched payouts. One deposit covers dozens of orders from several days, and one day's orders can land in two different deposits. Matching deposit-to-order one by one will never line up.
- Timing and cut-offs. Reports run in different timezones and settlement windows, so the last orders of the month routinely arrive in the next month's money.
Put together, the gap between "sales" and "deposit" is not one number to find. It is five or six ordinary numbers stacked on top of each other.
Why recording the deposit as sales breaks the books
It feels tidy — money in, call it income — and it quietly corrupts everything downstream. Revenue is understated by the fees. Refunds disappear into lower sales instead of showing as refunds. Margins per product become impossible to trust, because the costs were netted away before anyone saw them. At tax time, the reported revenue and the bank deposits disagree, and nobody can show the working that connects them.
Line a payout up in this order
- Reconcile at the payout level, not the order level. The deposit is the unit. Take the payout report for that deposit and prove its total equals the bank line first.
- Book gross, not net. Gross sales go in as income; each fee type goes in as its own expense; refunds go in as refunds. The deposit is the difference, not the source.
- Use a clearing account per channel. Orders post gross into the channel's clearing account, fees and refunds post out, and the deposit clears it to the bank. When the clearing account is zero at month end, the channel is reconciled. Whatever is left in it is your exact list of unexplained items.
- Separate the channels. Etsy, Amazon, and eBay each get their own clearing account, so one channel's reserve hold never muddies another channel's numbers.
- Let automation do the splitting. Pulling the payout report apart into sales, fees, refunds, and holds is copying work — the same shape every time. That is the part a workflow should do, and leave the exceptions to you.
What stays with a person
Anything the payout report cannot explain. A fee that does not match the published rate, a refund for an item that was never returned, a reserve that never releases. Those go to a person — and to the marketplace, with the payout report in hand — not into a "miscellaneous" line that hides them forever.
A short weekly pass
Do not wait for month end. Once a week, check that each channel's clearing account is trending to zero and read the leftover list while it is short. A payout gap explained in the week it happened takes minutes. The same gap found three months later takes an evening of screenshots — the one you were trying to avoid.
Your sales number and your bank number will never be the same number. They should always be numbers you can connect, line by line, on demand.
If your payouts and your books never meet, send a request for bookkeeping automation and we will set up the payout-splitting workflow on the channels you sell on.
Related: Automated monthly reports & bank reconciliation and Automating receipts & expense capture.
