Skip to content
(832) 702-3325 Free books review
(832) 702-3325

Problem · unreconciled books

Unreconciled accounts, explained.

Published range $850–$2,000

Free books review Request a call

Duplicate transactions, ballooning undeposited funds, a balance sheet that double-counts — these are the specific, mechanical errors behind accounts that won't tie out. Here's why duplicates happen, why an unreconciled account can't be trusted, and how reconciling to source fixes the cause instead of guessing.

The statement is the source of truth. We reconcile to it — so duplicates go and real transactions stay.

Reconciled to source Reviewed before delivery
CHECKING CREDIT CARD LOAN MERCHANT Unreconciled · duplicate Reconciled to source 2 of 4 cleared → DUPLICATES OUT · REAL TRANSACTIONS STAY

Quick answer

An unreconciled account means nobody has proven the books match the bank for that period — the balance may be right, but it's unconfirmed, and every report built on it rests on an assumption. Duplicates are created when a feed overlaps manual entry, or when a feed reconnects and re-imports.

What's actually happening

Three errors behind an account that won't tie out.

"Everything's entered twice" can be literally true, and it rarely travels alone. An account that won't reconcile carries some mix of three errors — and because they inflate the books rather than shrink them, the numbers look too good, which is its own kind of dangerous. Here's what's underneath.

Duplicate transactions

Bank feed plus manual entry — the same transaction counted twice. Income and expenses are both overstated, and the reconciliation can't close because the books contain more than the statement does.

Ballooning undeposited funds

Payments recorded as received but never grouped into a deposit pile up, inflating the balance sheet with money that already hit the bank inside a lump deposit recorded separately. More on a messy file →

Accounts simply never reconciled

No one ran the check, so the books and the bank quietly drifted apart and the difference compounded month over month. The specific way it surfaces is a difference that won't close. Where a stubborn difference comes from →

What it costs to leave it

Books that look too good are still wrong.

These three errors push the numbers up, not down — duplicates double income, undeposited funds inflate assets — so the danger is subtler than an obvious error: the books look healthy, and decisions get made on figures that are too high. You price as if a margin is real when it isn't, or read a cash balance that's been counted twice, and the correction lands later as an unwelcome surprise.

And it compounds while you wait. Each unreconciled month sets a wrong starting point for the next, more duplicates accumulate, and the backlog that would have taken a focused pass becomes a multi-account untangle. It's also the first thing a CPA finds at tax time. The six early signs help you catch it before it spreads.

A journal removing two duplicates found against the bank statement: a customer deposit counted twice comes back out of sales and checking, and a supplier charge entered twice comes back out of supplies expense and into checking, so the account agrees with the statement and income and expenses are each counted once. The entry totals $2,768.40 in debits and $2,768.40 in credits.
Figure data as a table
Two duplicates removed against the statement, and what they had inflated
AccountDebitCreditWhy
Sales2,450.00—A customer deposit keyed by hand and imported by the feed
Checking—2,450.00The statement shows one deposit, not two
Checking318.40—The statement shows one supplier payment, not two
Supplies expense—318.40A supplier charge entered twice
Totals2,768.402,768.40Checking agrees with the statement; income and expenses each counted once
Each removal is justified line by line against the statement, which is how the genuine transactions that only looked like copies stay in the books. Illustrative example — not client data. Assumptions stated. Assumptions: One checking account and one statement month with two invented duplicates, each a hand entry the bank feed later imported again; the hand-keyed copies are removed and the feed copies kept.

The fix

Reconcile to the statement — duplicates out, real transactions in.

The fix is reconciliation: we work each account against its statement, so every duplicate is removed with justification, undeposited funds are cleared at the root, and the genuine transactions that only looked like copies are kept. Each change is documented, so the corrected books are defensible. Each reconciliation is checked against its statement.

When the categories and reports are wrong as well, that's a fuller bookkeeping cleanup; if it's a broken QuickBooks file specifically, a QuickBooks cleanup fits. We'll tell you which before any work starts — one fixed fee, in writing.

Reconciliation

Every account tied to source, duplicates removed against the statement. A one-time reconciliation of a single account is one fixed fee in the published $850–$2,000 range; several accounts, or errors across the ledger, are scoped as a cleanup ($1,800–$6,000). See the service →

Full bookkeeping cleanup

When categories and reports are wrong too — reconciliation plus a rebuild. Published range $1,800–$6,000. See the service →

Then a monthly close

A reconciled monthly close keeps duplicates from ever piling up again.

However many accounts have drifted, the free review opens the file, separates duplicates from real transactions, and gives you a fixed fee to reconcile them — before any work starts.

Get a free books review

FAQ · Updated October 2026

The questions owners ask about duplicates and drift.

An unreconciled account is one where nobody has proven the books match the bank for that period. Reconciliation is the check that every transaction in QuickBooks agrees with the statement the bank, card issuer, lender or merchant processor sends, with every difference explained. Until that check is done, the account's balance is unverified — it might be right, but nothing has confirmed it, and any report that uses it is resting on an assumption rather than a fact.
From the bank feed overlapping with manual entry. The feed imports a transaction automatically, and someone also enters the same transaction by hand — from a receipt, an invoice, or habit — so it lands twice. It also happens when a feed is disconnected and reconnected, re-importing transactions already recorded. Duplicates keep an account from reconciling and make income and expenses look overstated, because every doubled transaction inflates two places at once.
The reliable way is to reconcile against the statement: the statement is the source of truth, so any transaction in the books that isn't on it is either a duplicate, a timing item, or an error, and each gets resolved on that basis. Hunting for duplicates by eye in the register has no reference point, so it can miss the ones that matter and risks deleting a real transaction that only looks like a copy. Reconciling to source finds them systematically and tells you which apparent duplicates are actually genuine separate transactions.
Undeposited funds is a holding account for payments you've recorded as received but not yet grouped into a bank deposit. When the deposit step is skipped — payments marked received and never cleared out — the balance only grows, inflating the balance sheet with money that has, in reality, already hit the bank as part of a lump deposit recorded separately. That keeps the account from reconciling, because the lump deposit and the stranded payments count the same money twice; it's cleared by tracing each payment to the actual deposit, not by zeroing the account out.
It can, if it's done by guessing rather than by reconciling. Deleting a transaction that only looks like a duplicate — but is actually a separate, real payment — removes income or an expense that belongs in the books, creating a new error in place of the old one. That's why we work from the statement: every removal is justified against source, so what's deleted is genuinely double-counted and what's kept is genuinely real. The audit trail records each change so it's defensible later.
A one-time reconciliation of a single account is one fixed fee in the published $850–$2,000 range; several accounts, or errors across the ledger, are scoped as a cleanup ($1,800–$6,000). The months left unreconciled and how many duplicates and differences have to be resolved decide where a single account lands. A narrower file-specific fix can fall in the $850–$2,500 QuickBooks cleanup range. To keep it from building up again, ongoing reconciliation is part of monthly bookkeeping from $550 a month.

Related: reconciliation service · bank won't reconcile · a file that's a mess · more bookkeeping problems.

Start with a diagnosis

Clear the duplicates — and tie every account to source.

We open the file, separate genuine transactions from duplicates against the statement, and give you a fixed-fee scope to reconcile every account. No guessing, and the review is free.

Free books review Request a call
Reconciled to source Fixed fee, in writing Scope agreed before work starts