01
The beginning balance is wrong
If a previous reconciliation was changed or the opening balance was entered incorrectly, the current reconciliation can carry forward a difference.
QuickBooks • Bank Reconciliation
Why Is My QuickBooks Bank Reconciliation Off?
A reconciliation difference does not always mean your entire bookkeeping file is wrong. Most mismatches come from a specific transaction, date, beginning balance, or prior-period change. The goal is to find the cause before changing the numbers.
Beginning Balance
Missing Transactions
Duplicate Transactions
Prior Changes
Reconciliation status
Find the difference
✓
Statement ending balance
$28,640.00
Cleared in QuickBooks
$28,490.00
Difference
$150.00
Start by checking the beginning balance, dates, and transaction list.
Answer first
Most reconciliation problems are traceable
When QuickBooks will not reconcile, the most useful question is: “What changed between the bank statement and the QuickBooks register?” Common causes include missing bank activity, duplicate entries, wrong dates, incorrect amounts, stale outstanding checks, bank fees or interest that were never entered, and changes to transactions that were already reconciled.
Avoid forcing the reconciliation with an unexplained adjustment. A clean reconciliation should reflect what actually happened in the bank account.
Common causes
10 reasons your QuickBooks reconciliation is off
Work through these from the simplest checks to the historical ones. The right fix depends on the actual transaction that created the difference.
02
A bank transaction is missing
A check, ACH, deposit, card transaction, fee, or transfer may exist on the bank statement but not in QuickBooks.
03
A transaction was entered twice
Duplicate imports or manual entries can make the QuickBooks cleared amount larger or smaller than the bank statement activity.
04
The amount is wrong
Even a small data-entry error can create an exact reconciliation difference. Compare the actual bank amount to the amount recorded in QuickBooks.
05
The transaction date is wrong
A transaction recorded in the wrong period may exist in QuickBooks but not appear in the reconciliation you are currently completing.
06
Bank fees or interest were never recorded
Monthly service fees, wire fees, or interest can be visible on the bank statement without a matching QuickBooks entry.
07
A transfer was recorded incorrectly
Transfers between business accounts can be duplicated, omitted, or entered as income or expense instead of as a transfer.
08
An old outstanding item is no longer valid
Old checks, deposits, or other uncleared activity can remain on the books long after the underlying transaction should have been resolved.
09
A reconciled transaction was edited
Editing the date, amount, account, or other important details of a previously reconciled transaction can affect later reconciliation work.
10
A prior reconciliation was undone or altered
A historical reconciliation change can move the starting point for later months. When the difference is large or persistent, trace the reconciliation history before posting adjustments.
Decision tree
What to investigate based on the size of the difference
The amount can give you a clue, but it does not prove the cause. Use it to prioritize your search rather than to guess the correction.
≈
Tiny or exact-looking difference
Look for a small data-entry error, service fee, interest amount, or rounding-related issue.
1+
Difference equals a known transaction
Search for a missing or duplicated transaction for exactly that amount before changing any prior-period entries.
↺
Difference appeared after a prior month was already reconciled
Investigate edits, deleted transactions, changed dates, or altered prior reconciliations.
!
Large, old, or unexplained difference
Stop and review the historical register, reconciliation reports, and supporting bank statements before making a correction.
Avoid common cleanup mistakes
Fix the transaction, not just the reconciliation screen
✓
Do trace the source
Compare the bank statement to the QuickBooks register and identify the exact missing, duplicate, edited, or incorrectly dated transaction.
×
Don't force a plug
An unexplained adjustment may make the reconciliation equal zero while leaving the accounting records incomplete or misleading.
✓
Do document material fixes
Keep a record of what was changed, why, the bank statement reference, and any supporting documentation.
×
Don't casually undo old reconciliations
Historical reconciliation changes can affect later periods. Understand the cause before changing prior-period records.
Better monthly process
A clean reconciliation workflow for small businesses
01
Collect
Use the complete monthly bank statement, including the correct ending date.
02
Compare
Compare statement activity to the QuickBooks register.
03
Investigate
Find missing, duplicate, incorrect, or stale items.
04
Correct
Fix the underlying transaction and preserve an audit trail.
05
Confirm
Finish only when the reconciliation difference is resolved and the records make sense.
Warning signs
Your reconciliation may need deeper cleanup
A one-time error is different from a recurring bookkeeping problem. Look deeper when the same account never reconciles cleanly or old outstanding items continue month after month.
Same difference repeats
The exact amount appears in multiple periods.
Old uncleared items pile up
Outstanding transactions remain unresolved for long periods.
Beginning balance keeps changing
Prior-period activity may have been edited or altered.
Bank and books rarely agree
The file may need a wider bookkeeping review beyond one reconciliation.
Related Accountrise guides
Keep your QuickBooks books accurate from month to month
FAQ
QuickBooks reconciliation questions
Why is my QuickBooks bank reconciliation off?
Common causes include an incorrect beginning balance, missing or duplicate transactions, wrong amounts or dates, unrecorded bank fees or interest, old outstanding items, and changes to transactions that were previously reconciled.
What should I check first when QuickBooks will not reconcile?
Confirm the statement ending date and balance, verify the beginning balance, then compare the bank statement to the QuickBooks transaction list for missing, duplicate, or incorrectly dated items.
Should I undo a previous QuickBooks reconciliation?
Do not undo it automatically. First identify what changed and whether the underlying transaction can be corrected without disturbing accurate historical reconciliations.
How often should a small business reconcile its bank account?
Monthly is a common baseline. Higher-volume businesses or businesses that need tighter cash visibility may choose a more frequent review.
Need help with QuickBooks?
Stop carrying reconciliation problems into the next month.
Accountrise helps small businesses reconcile bank accounts, clean up historical bookkeeping issues, investigate differences, and keep QuickBooks ready for monthly reporting and tax preparation.
Starting at $10/hour. Final pricing depends on scope, transaction volume, complexity, and engagement requirements.