Expert Solutions 888-463-3385 to fix QuickBooks Reconciliation Issue Easy
A reconciliation issue is any situation where QuickBooks’ register (books) doesn't match the bank/credit-card statement for a statement period — i.e., the reconciliation “Difference” is not $0.00, or QuickBooks flags the account as “not ready to reconcile” because the beginning/ending balance doesn’t match. When this happens you must find the missing/changed/duplicated/edited transaction(s) or make an approved adjusting entry.
QuickBooks
+1
2) Most common root causes (ranked by frequency)
Edited or deleted transactions after prior reconciliation — someone changed a reconciled transaction. QuickBooks has a “Reconciliation Discrepancy” report to identify these.
QuickBooks
Wrong beginning balance (opening balance journal entry or previous reconciliation undone) — QuickBooks will flag the account not ready if the beginning balance is off.
QuickBooks
Missing transactions — a deposit/fee/check not entered, or not yet downloaded/matched from bank feed.
Duplicate transactions — duplicates entered manually or imported twice via bank feeds.
QuickBooks
Bank service charges/interest not recorded — small amounts that change totals.
Date-range or statement date mismatch — transactions posted just outside statement dates.
Journal entries that affect prior reconciliations — e.g., posting to a reconciled period without undoing reconciliation.
QuickBooks
Mistyped amounts (e.g., $1,200 vs $12,00) or foreign currency rounding.
Import/backup/restore issues that alter transaction IDs or values.
3) Reports & tools to run first (official & fast)
Reconciliation Discrepancy Report — shows transactions changed since last reconciliation (who modified; entered/last modified timestamps). Use this first.
QuickBooks
Reconciliation Report — compare what was reconciled previously to current statement.
Missing Checks Report (Desktop) — helps find checks missing from statement.
QuickBooks
Audit Log (QBO) — to see who changed or deleted transactions and when.
Bank Statement & QuickBooks Register side-by-side — line-by-line match.
Undo Last Reconciliation (when appropriate) — QuickBooks Desktop / QBO allow undoing (or undoing back to a date) to fix beginning-balance errors — back up file first.
QuickBooks
+1
4) Step-by-step troubleshooting checklist (practical)
Follow these in order (shortcuts can waste time):
Back up your company file (Desktop) or export a copy (QBO backup/Excel) before making changes.
Confirm statement totals: Confirm bank statement beginning and ending balances and statement dates.
Run Reconciliation Discrepancy Report — look for transactions that were changed or deleted since the last reconciliation. If found, review why they were changed and restore/edit as needed.
QuickBooks
Check beginning balance: If QuickBooks flags the beginning balance, click the alert to view details. If beginning balance is wrong, determine which prior reconciliation or opening balance journal entry caused it.
QuickBooks
Search for duplicates or missing transactions:
Filter register by amount or date.
Run Missing Checks report (Desktop).
Check bank feed for unmatched downloaded transactions.
Check for edited reconciled transactions: If a reconciled transaction was edited (amount/date/account), either revert the edit or undo the reconciliation and re-reconcile.
QuickBooks
Check journal entries that affect the account for the period in question; these can change reconciled totals.
If difference is a small service charge / interest — create/record the bank fee or interest and re-reconcile.
If you can’t locate the cause and you've exhausted checks — enter an adjusting reconciliation journal entry only after documenting and confirming with the client/bookkeeper. Intuit documents procedures for entering an adjusting entry and finishing reconciliation.
QuickBooks
If reconciliations were undone accidentally — follow Intuit steps to undo back to the date needed, then re-reconcile. Always document.
QuickBooks
5) When to use “Undo last reconciliation” vs “adjusting journal entry”
Undo last reconciliation: when the last reconciliation was done incorrectly or transactions that were reconciled were later changed/deleted and the easiest fix is to re-do that period (usually okay for small numbers of periods). Always back up first.
QuickBooks
+1
Adjusting journal entry: when you have exhausted direct fixes and the difference is legitimate (e.g., bank rounding or small fees) and you want to close the period without changing prior reconciled transactions. Use only after review and with supporting explanation; be aware this affects financial statements. Intuit has documented steps for entering an adjusting entry.
QuickBooks
6) Support-team quick responses (copy/paste friendly)
If a customer reports a difference: “Thanks — please send the bank statement PDF for the statement period and tell me the exact beginning and ending balances. I’ll run a Reconciliation Discrepancy report and check for edited/deleted transactions.”
QuickBooks
If they say beginning balance is off: “QuickBooks flags beginning-balance errors when a previous reconciliation was changed. I’ll open the Reconcile screen and the beginning balance alert to see which prior transaction(s) were altered.”
QuickBooks
If they accidentally undid reconciliation: “Undo can change balances back to an earlier state — do not re-reconcile yet. Please provide a backup/export so we can restore if needed.”
QuickBooks
7) Short remediation scripts / actions to run (for power users)
Run Reconciliation Discrepancy → note transaction IDs/dates → revert edits or re-enter deleted transactions exactly as on the bank statement.
QuickBooks
Re-match bank feed transactions by amount & date → exclude duplicates imported twice.
If small leftover difference (< $5), compare fees/interest and consider a documented adjusting entry.
QuickBooks
8) Prevention & best practices
Reconcile monthly (or more frequently) so problems are small.
Restrict who can edit reconciled transactions; use the Audit Log to track changes.
Keep a reconciliation checklist and require notes when undoing or editing reconciled items.
Always match downloaded bank feed transactions rather than entering manual duplicates.
Train staff to avoid back-dating journal entries into previously reconciled periods without approval.
Use a naming/note convention when entering adjustments so they’re traceable.
9) When to escalate to Intuit / external help
If the file is corrupted or you get strange results after an import/restore.
If reconciliations were changed by a user and you can’t reconstruct what was done.
If the Reconciliation Discrepancy report shows many edits and you suspect fraud.
If QuickBooks behaves unexpectedly after undo actions — contact Intuit support or a Certified QuickBooks ProAdvisor. (Intuit docs show steps for many of the fixes and when to contact support.)
QuickBooks
+1
10) Useful official references (open these for step-by-step UI guidance)
Fix issues at the end of a reconciliation (QBO) — Intuit help (updated recently).
QuickBooks
Reconciliation Discrepancy Report — Intuit.
QuickBooks
Fix beginning balance issues — Intuit.
QuickBooks
How to undo/handle accidental undos — Intuit troubleshooting.
QuickBooks
+1
Enter an adjusting entry for reconciliation — Intuit guidance.
QuickBooks
11) Ready-to-use FAQ (for a help article or support script)
Q: “My reconciliation difference is $0.00 but QuickBooks won’t let me finish.”
A: Often caused by beginning-balance mismatch or transactions matched to the wrong account — click the on-screen alert, run the Reconciliation Discrepancy report, and verify beginning/ending balances.
QuickBooks
+1
Q: “I found duplicate transactions after reconciling.”
A: If duplicates were not on the bank statement, delete or exclude them. If duplicates were reconciled, you may need to undo the reconciliation and re-reconcile.
QuickBooks
+1
Q: “Can I just enter a journal entry to make the difference zero?”
A: Only as a last resort and only if you document the reason. Intuit documents how to record an adjusting entry after all other fixes fail.
QuickBooks
12) One-Page Quick Checklist (for print)
Back up file / export statements.
Confirm statement dates & ending balance.
Run Reconciliation Discrepancy report.
QuickBooks
Check for duplicates/missing checks.
QuickBooks
Check Audit Log for edits.
Fix or revert transactions; re-run reconcile.
If unresolved, prepare documented adjusting entry.
QuickBooks
If file shows corruption or unexpected behavior → escalate to Intuit/ProAdvisor. - a 3372.9 m activity route in New York City, New York
Route Location
Start Lat/Lng: (40.725866, -73.991937)
City: New York City
Country Name: the United States
Country Code: US
State Code: NY
State Name: New York
Postal Code:
Route Stats
Activity: Activity
Distance: 3372.9 m
Max Elevation: 52.82 meters
Elevation Gain / Total Ascent: 31.2 meters
Data Source: fitness:RE
Discover more Runs