Deposits in the Bank but Not in QuickBooks Online: A Catch-Up Plan
Checks deposited by remote capture but never recorded leave QuickBooks Online full of unmatched bank items. Here is how to find and clear the gap.
A pattern keeps reappearing in small finance teams. One person scans incoming checks and sends them to the bank through remote deposit, and nobody records those payments in the accounting software. The bank balance moves, the books stay still, and months later the reconciliation refuses to balance. The fix is unglamorous but reliable: find each stray deposit, record it, and reconcile month by month.
One task, two systems
Remote deposit capture is a bank service. It turns a paper check into an electronic deposit and nothing else. The accounting entry is a separate job, and QuickBooks Online cannot invent it. If a payment is never recorded, the bank feed later shows money arriving with nothing to match it against.
The standard flow has three moves. Record the payment against the customer’s invoice, or enter a sales receipt where no invoice exists. Let those amounts sit in undeposited funds until you know which checks traveled together. Then record the deposit so it lists every check in the batch, and match it against the bank feed.
When someone skips the first two moves, the mismatch hides for weeks. Bank lines arrive in lump sums, and the books have nothing to compare them with.
How do you find deposits that never reached the books?
Work from the bank statements, not from memory. Pull each statement for the affected months and mark every deposit line. For each mark, find the matching entry in the books. In QuickBooks Online, the banking review list and the reconcile screen together show what matched and what never did.
Any statement line with no book entry is a candidate. Identify the payer from the scan image or the remittance advice, then record the payment against that customer’s open invoice. Watch for batched deposits: several checks often travel as one bank line, so the deposit you record must list them all.
There is a side effect worth checking early. Unrecorded payments leave accounts receivable overstated, so customers can appear to owe money they already paid. Fixing the entries repairs the aging report at the same time.
Where should the catch-up begin?
Start with the oldest unreconciled month and finish it before touching the next. Each statement’s closing balance becomes the next one’s opening balance, so working out of order manufactures differences that are not really there.
Clear one month at a time and resist the urge to post one large adjusting entry. A plug number closes the reconciliation but hides which deposits were missed, and it weakens the trail an auditor will want to follow. The work is repetitive but bounded, since most stray deposits take only a few minutes once identified.
A monthly reconciliation is an alarm, and a backlog silences it. If several months are open, block the time on a calendar and treat the cleanup as a project, because it will not shrink on its own.
Should an order confirmation email count as an invoice?
No. A confirmation says an order exists. An invoice demands payment, and the two arrive from different systems that scammers can imitate. Spoofed domains and lookalike layouts are cheap to produce, and a payments desk that bills against whatever lands in the inbox is the target.
Three habits catch most of it. Pay only against a bill tied to a purchase order or contract you recognize. Verify any new vendor, or any change to bank details, by phone using a number already on file, never one printed in the email. Treat urgency as a warning sign rather than a reason to move faster.
Policy cannot name every scam in advance. Document matching is what catches the ones nobody thought to write down.
What stops it from happening again?
Fold the scan and the entry into one checklist: a check is not finished until it is deposited, recorded, and filed. Reconcile the bank’s remote deposit report against the day’s new entries, daily or weekly, so a gap surfaces in days rather than months.
Review totals instead of redoing the work. Comparing the deposited total to the recorded total takes minutes and catches almost everything. Where staffing allows, separate the person who deposits from the person who reviews, since a second pair of eyes is the cheapest control a small team can buy.
Training helps, but verification is what protects you. Trust the checklist, then check it anyway.
A backlog like this rarely clears itself. For files too tangled for a checklist, our team takes on reconciliation catch-up and ledger cleanup directly. Otherwise, open the oldest unreconciled statement today, list its unmatched deposits, and clear them one by one; the first finished month turns the alarm back on.