QuickBooks Reconciliation Discrepancy: 9 Warning Signs

A QuickBooks reconciliation discrepancy means the account cannot reproduce the external statement for the same ending date and balance. The cause is usually a missing, duplicate, changed, deleted, misdated, or misposted transaction, not a random software number.

Do not begin by forcing the current reconciliation to zero. Find the earliest period whose ending balance no longer agrees with the next period’s beginning balance, preserve the reports, and trace the affected transaction. The nine signs below help you decide whether the problem is in the current statement or in previously reconciled history.

What a reconciliation proves

Reconciliation compares a specific account in QuickBooks with an external statement for a defined ending date. The opening balance should connect to the previous completed reconciliation. The statement ending balance and date should be entered correctly. Cleared transactions should then reproduce the statement balance, with the QuickBooks difference at zero.

Bank-feed connection is not reconciliation. A feed delivers transaction data. Reconciliation tests whether the complete account agrees with independent evidence. The QuickBooks duplicate-transaction guide explains why feed and posted activity must be separated.

Nine warning signs of a QuickBooks reconciliation discrepancy

1. The beginning balance changed. A transaction marked reconciled in an earlier period may have been edited, deleted, unreconciled, or moved to another account.
2. The current difference will not reach zero. The ending balance, date, or transaction population may be wrong.
3. Old transactions remain uncleared. They may be duplicates, voided checks, entries posted to the wrong account, or legitimate outstanding items that need evidence.
4. Deposits do not match the statement. Several customer payments may need to be grouped into the actual bank deposit through Undeposited Funds.
5. The same amount appears twice. A manual entry and an added bank-feed transaction may represent one event.
6. A reconciliation adjustment account keeps growing. Repeated plugs are replacing investigation rather than documenting a rare supported correction.
7. The reconciliation report changes after completion. Closed-period activity may have been edited or deleted.
8. QuickBooks cash differs from the bank by an old round amount. An opening-balance entry, duplicate transfer, or stale check may be involved.
9. The books reconcile, but the financial statements still look wrong. The bank can reconcile even when transactions are classified to the wrong income, expense, asset, liability, or owner account.

Find the first affected period

Start with the most recent reconciliation report that you know was correct. Compare its ending balance with the beginning balance of the next period. If they differ, review changes to previously reconciled transactions before investigating the current month.

Run the reconciliation discrepancy or audit-history tools available in your current QuickBooks product. Then inspect the date, amount, payee, account, reconciliation status, and user activity for each changed item. Product menus change, so use current Intuit instructions for the exact edition you use.

A controlled correction process

1. Save the statement, prior reconciliation report, current discrepancy report, and relevant audit history.
2. Confirm the statement account, ending date, and ending balance.
3. Identify missing, duplicate, changed, deleted, or misdated transactions.
4. Trace each candidate to invoices, bills, deposits, checks, payroll, processor reports, or transfers.
5. Correct the source transaction when possible, preserving notes and approval.
6. Reconcile the affected period forward, not only the current month.
7. Review the P&L, balance sheet, receivables, payables, payroll liabilities, and tax accounts after the correction.

If a prior period is closed or a filed tax return may be affected, stop and coordinate the accounting correction with the tax preparer. Editing history without that review can create a new mismatch between books and filings.

The beginning balance that breaks the month

Assume the June reconciliation was completed at $84,250. In August, the July reconciliation opens at $81,250. The $3,000 difference is illustrative. Audit history shows that a June customer deposit was later deleted when someone tried to remove a duplicate bank-feed item.

The correct fix is not an August expense or income adjustment. The reviewer determines which June entry represented the real deposit, restores or corrects the source transaction, verifies the customer and revenue effect, and reruns the June and July reconciliations. The supporting file explains what changed and why.

Why the adjustment button is risky

Intuit allows a reconciliation adjustment in limited circumstances and describes it as a last resort. An adjustment creates a transaction that makes the reconciliation balance. It does not prove that the underlying income, expense, customer, vendor, loan, or payroll record is correct.

A small bank fee that was never entered may have a clear source. A recurring unexplained difference is different. Treat material or repeated discrepancies as a cleanup issue, not a speed bump at the end of the close.

Prevent the discrepancy from returning

Limit who can edit closed periods, require support for deletions and voids, review audit history, and use a documented bank-feed matching process. Record transfers once, group deposits to match the bank, and reconcile every bank and card account through the statement date.

Finish with a balance-sheet review. The broader QuickBooks cleanup workflow should include loans, payroll liabilities, receivables, payables, clearing accounts, and owner activity, not only cash.

Document the final resolution

When the discrepancy is fixed, record the affected account, statement date, cause, transactions changed, reviewer, and new reconciliation difference. Save the ending reconciliation report with the statement. If a prior period changed, notify the person responsible for financial or tax reporting so the correction is not discovered again during year-end work.

Use three tests before changing a reconciled transaction

First, test existence. Match the QuickBooks entry to bank evidence and to its source, such as an invoice, bill, payroll report, processor settlement, check, or transfer. Second, test completeness. Search for the other side of the event and confirm that one real transaction was not split, grouped, or imported twice. Third, test period and account. A legitimate payment in the wrong bank account or date can break one reconciliation and distort another.

Record the old value, proposed value, reason, source, affected reconciliation, and reviewer before making a correction. If the entry touches a closed year or a filed return, coordinate the accounting change before editing history. A clean QuickBooks bank reconciliation statement should remain reproducible after the fix.

This control prevents a common cleanup failure: correcting the visible difference while creating a new customer, vendor, payroll, loan, or tax error elsewhere. The bank can reach zero even when the accounting classification is still wrong, so rerun the relevant financial and subsidiary reports after the account reconciles.

Educational information only. Tax, payroll, and compliance rules change and may vary by jurisdiction. Confirm the current requirements for your facts with the appropriate agency or a qualified professional.

If prior-period changes or unexplained adjustments keep breaking the close, Steady can trace and document them through its cleanup and catch-up bookkeeping service.