Bank reconciliation is the process of proving that the cash in the books matches the cash at the bank, and explaining every difference. When a marketplace pays out in batches, that process splits into two steps rather than one: reconciling the marketplace’s own activity to the ledger, then reconciling the resulting payout to the bank. Sellers who try to do it in a single step end up either reconciling to a number that is missing most of their transactions, or giving up and matching deposits to revenue.
The mechanics are not complicated once the middle step exists. The clearing account is what makes it work.
What a batched payout actually is
A marketplace deposit is a net residual. Gross sales, minus refunds, minus referral fees, minus fulfillment fees, minus storage, minus advertising charged to the account, plus reimbursements, plus or minus movement in a held reserve. One number arrives at the bank; dozens or thousands of events produced it.
Amazon documents the components of its payments reporting and how an account balance is assembled in its Seller Central payments reference. The specifics vary by channel, and the shape does not: a deposit is the end of a calculation, not a transaction in its own right.
This is why deposit level bookkeeping fails. Matching a $35,260 deposit to a $35,260 revenue entry gives a reconciled bank account and a set of books with no fee expense, understated revenue, and no way to see what changed month over month.
The clearing account
The fix is a marketplace clearing account, one per channel, treated as an asset. It functions the way accounts receivable functions for a business that invoices.
Activity posts to the clearing account as it happens. Sales increase it. Fees, refunds, and advertising reduce it. When the payout lands, the deposit is recorded as a transfer from the clearing account to the bank. What remains in the clearing account is money the seller has earned and not yet been paid, which is a real asset with a checkable value.
Two reconciliations then exist, and both are straightforward:
- The bank reconciliation proves that deposits recorded match deposits received. With one or two payouts per channel per fortnight, this takes minutes.
- The clearing account reconciliation proves that the ledger’s view of marketplace activity matches the marketplace’s own reports, and that the closing balance equals what the marketplace says it owes.
The second is the one that finds errors. A clearing account that does not tie out means a transaction type is being mapped incorrectly or dropped, and it names the period where it started.
A worked example
One channel, one settlement period.
Activity posted to the clearing account:
- Product sales: $58,400
- Refunds: $2,310 reduction
- Referral fees: $8,760 reduction
- Fulfillment fees: $6,140 reduction
- Storage: $890 reduction
- Advertising: $3,420 reduction
- Reimbursements: $310 increase
Net movement: $37,190. The payout arrives at $35,260, because the marketplace increased its held reserve by $1,930. The deposit clears $35,260 out of the clearing account to the bank, and $1,930 stays behind as a receivable.
Revenue for the period is $58,400. Fee load is 27.1 percent of gross sales. The bank agrees. The clearing account balance equals the reserve the marketplace reports holding. Four facts, all checkable, none of which exist in books that reconcile deposits to revenue.
Reserves, holds, and the balance that should be there
A nonzero clearing balance is normal, and knowing what it should be is the point of the exercise. It generally comprises three things: activity after the settlement cutoff that has not been paid yet, the held reserve, and amounts in dispute.
A reserve increase is not an expense. The money was earned; the marketplace is holding it. Recording it as a cost creates a phantom loss in one month and a phantom gain in the next when it releases, which is the source of a great deal of unexplained month to month volatility in seller books.
A clearing balance that grows without explanation deserves attention. That pattern means something is posting to the clearing account that never clears, a duplicated settlement, a transaction type mapped to the wrong side, a refund recorded twice. Left alone it becomes a fictitious asset that eventually has to be written off.
Period boundaries
Settlement periods ignore calendar months. A period running from the 26th of one month to the 9th of the next contains activity from both, and the deposit lands in the second.
Allocating each line to the month of the underlying transaction, with the remainder held in the clearing account until the next period closes, keeps monthly revenue comparable. Posting the whole settlement to the month the cash arrived shifts revenue between periods. Across a December boundary that becomes a tax year question rather than a reporting inconvenience.
Doing this at volume
One channel and two payouts a month is a spreadsheet exercise. Five channels, several settlements each, refund activity and multiple currencies is where the manual version breaks, and where sellers move to tooling that maps settlement transaction types into the ledger on a defined schedule. Products built for this, ConnectBooks among them, connect marketplaces such as Amazon, Shopify, Walmart, TikTok Shop, and eBay into QuickBooks Online, QuickBooks Desktop Enterprise, or Xero, with the settlement detail preserved on the way in rather than summarized to a net figure. Approaches differ across the category, and A2X, for instance, is built around summarized settlement journals, which suits accounting practices closing many clients on a repeatable process.
The choice does not change the structure. Clearing account, transaction level posting, two reconciliations. Any tool that cannot produce a clearing balance matching what the marketplace says it owes is not doing the job, whatever it does otherwise.
A monthly checklist
- Post all marketplace activity for the period to the clearing account by transaction type.
- Record each payout as a transfer from the clearing account to the bank.
- Reconcile the bank: deposits recorded against deposits received.
- Reconcile the clearing account: closing balance against the marketplace’s reported balance owed, with reserve and post cutoff activity identified separately.
- Investigate any clearing balance that cannot be explained by those two components.
Step four is the one that gets skipped, and it is the one that catches errors while they are still small. For the general standard on what records a business should retain and why, the Small Business Administration’s guide to managing business finances is a plain summary, and marketplace settlement reports are source documents in that sense. Most of them get less care than a stack of supplier invoices.