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.