How to Fix QuickBooks Reconciliation Discrepancies: 7 Common Errors & Fixes
The definitive forensic bookkeeping framework for tracking down beginning balance shifts, digit transpositions with the Rule of 9, and elusive penny variances.
When QuickBooks shows a non-zero difference (even $0.05 or $12.40), clicking Finish creates an entry in an account called Reconciliation Discrepancies. This is an immediate red flag for tax CPAs, lenders, and IRS auditors because it signals unverified mathematical errors in your general ledger.
1. The 7 Most Common Causes of Reconciliation Discrepancies
If the opening balance on your screen does not match the statement opening balance, someone unlocked a transaction reconciled in a prior month, altered the dollar amount, or deleted it from the register.
A transaction was recorded manually as an Expense or Check, but when the bank feed downloaded the same cleared transaction, a user clicked Add instead of Match, causing the transaction to be counted twice.
Typing fingers swapped adjacent numbers. This always produces a difference that is a multiple of 9 ($452 - $425 = $27; 27 / 9 = 3).
A customer refund or merchant fee was accidentally entered in the Deposit column instead of the Expense column. This produces a difference exactly two times (2x) the transaction amount.
A physical check issued six months ago was checked off on the screen even though it never cleared on the official paper bank statement.
Entering a $15.00 monthly maintenance fee in the initial reconciliation start modal, but also checking off the $15.00 line item already imported in the bank transactions list.
A debit card swipe on Friday, October 31st at 11:30 PM posted to the bank feed in October, but posted to the official monthly bank PDF on November 1st.
2. The Forensic Mathematical Detective Toolkit
When staring at an unexplained difference, use these 3 mathematical diagnostic tests before manually checking every single line item:
Take your difference and divide by 9. If the remainder is zero, you are dealing with a transposition error. Look for entries where digits like 38 vs 83 ($45 / 9 = 5) or 19 vs 91 ($72 / 9 = 8) were typed.
Take the difference and divide by 2. If the difference is $240.00, look specifically for a transaction of $120.00. It was entered as a deposit instead of an expense (or vice versa).
Filter your reconciliation screen by the exact dollar discrepancy amount. Often, a single missing deposit or expense equals the exact penny difference on screen.
3. How to Pull the Reconciliation Discrepancy Report in QBO
QuickBooks Online maintains an internal audit log tracking every change made to previously reconciled transactions:
- Navigate to Gear Icon > Audit Log or open the Reconciliation screen.
- If the beginning balance is off, an alert box will state: "Your beginning balance is off by $X.XX. We can help you fix it."
- Click We can help you fix it to open the dedicated Reconciliation Discrepancy Report.
- Review the columns: Change Type (Unreconciled in register, Amount changed, Deleted), Amount in QuickBooks, and Original Reconciled Amount.
- Click Edit on the flagged line to restore the original reconciled dollar amount or re-apply the cleared status (
R).
Verify Statement Checksums in Your Browser
Use our free Bank Statement Checksum Verifier to prove that Beginning Balance + Inflows - Outflows equals Ending Balance to the exact penny: