Clearing Account vs Bank Deposit Reconciliation

Review payout support behind a clearing-account balance and match expected net payouts to bank deposits before accounting handoff.

Try with sample files | View sample report

Problem statement

A clearing account is a temporary accounting bridge, while the bank deposit is the final cash movement. They may not match at a single point in time when payouts group transactions, deductions cross periods, or deposits are still in transit.

Numeric example

Line item	Amount
Gross sales moved to clearing	$5,000.00
Processor fees	-$145.00
Refunds in payout cycle	-$300.00
Expected bank deposit	$4,555.00
Open clearing balance	$0.00

Why the numbers do not match

The clearing account may contain gross sales, fees, refunds, reserves, and adjustments while the bank only shows the final net deposit.
One payout can combine activity from several sales days into one bank movement.
A payout may be recorded before the deposit appears in the bank export.
Refunds, disputes, or reserve movements can affect a later payout cycle.
Unresolved source rows can leave a clearing balance even when a bank deposit has already arrived.

What files to export

Clearing-account activity with entries, dates, references, and balances for the review period.
Processor payout export with payout IDs, gross activity, deductions, status, and net amounts.
Bank statement export with final deposit dates, amounts, and descriptions.
Orders or invoice export when payout support does not contain enough source references.

Manual workflow

Choose one payout cycle and identify the entries moved into the clearing account.
Separate gross activity, refunds, fees, reserves, and other supported adjustments.
Calculate the expected net payout from the exported payout support.
Match the expected net payout to the bank deposit by amount, date, and reference.
Keep timing items and unsupported differences open instead of clearing them by assumption.
Use the reviewed report as support for the accounting handoff or clearing entry.

Common mistakes

Assuming the clearing-account balance must equal one bank row at every point in time.
Posting an unexplained difference as a fee without supporting export evidence.
Mixing several payout cycles into one clearing-account review.
Treating an accounting entry as proof that the underlying payout and bank rows match.

How Reconcile Locally helps

Keeps payout, bank, order, and invoice exports visible in one local review workflow.
Separates supported matches from amount differences and possible grouped payments.
Produces a review-ready report before clearing or posting decisions are made.
Works from exported files without connecting the bank or uploading raw financial files to a server.

What still needs manual review

Reconcile Locally reviews exported evidence; it does not create, approve, or post clearing-account entries.
Cross-period, multi-currency, reserve, and grouped-payout cases may need another export.
Final accounting classification and posting remain decisions for a qualified reviewer.

Content review and sources

Written and reviewed by the Reconcile Locally product team. Last reviewed June 7, 2026.

Guidance is checked against current product behavior and first-party documentation where available. Reconciliation results still require human review.

Frequently asked questions

Should the clearing account equal the bank deposit?

Not necessarily at every point in time. Review one payout cycle at a time and account for supported fees, refunds, reserves, grouped activity, and deposits still in transit.

Does a remaining clearing balance mean there is an error?

No. It can reflect timing, an unresolved source row, a reserve, or another supported adjustment. Keep the balance in review until the exported files explain it.

Can Reconcile Locally post the clearing entry?

No. It prepares a local review report from exported files. Posting and approving accounting entries remain separate human workflows.

What should I review next if the clearing balance comes from Shopify and Stripe?

Move next into the Shopify, Stripe, and QuickBooks workflow when you need to connect order-level Shopify detail, Stripe payout support, and the accounting-side bank review in one path.