Find what's behind a QuickBooks reconciliation difference
Enter the two balances from your reconcile screen. Optionally paste your uncleared transactions (straight from QuickBooks, one per line) and the tool checks which of them likely explain the difference. Everything runs in your browser; nothing is uploaded.
The usual causes, in order of likelihood
- Unchecked transactions. A cleared transaction sitting unticked on the reconcile screen. The single-amount match above finds these fast.
- Bank feed duplicates. A feed disconnect plus a manual import often books the same transaction twice. Sort the register by amount to spot pairs.
- Edited or deleted reconciled transactions. This shifts the beginning balance. In QuickBooks, run the Reconciliation Discrepancy report (Reports, then search "reconciliation discrepancy") to see what changed.
- Wrong-sign entries. A deposit recorded as a payment moves the difference by exactly double the amount.
- Transactions dated outside the statement period. Check a few days either side of the statement dates.
- Typos and transpositions. A difference divisible by 9 is the classic tell.
Common questions
The six usual causes, in order of likelihood: an unchecked cleared transaction, a bank feed duplicate, an edited or deleted previously-reconciled transaction, a deposit or payment entered with the wrong sign, a transaction dated outside the statement period, or a typo. This tool checks your uncleared amounts against the difference to narrow it to a specific transaction or combination.
A transaction that was already reconciled has since been edited, deleted, or unreconciled, so the starting point moved. Run QuickBooks' built-in Reconciliation Discrepancy report to see exactly which transactions changed, then restore or re-mark them.
Swapping two adjacent digits in a number always changes it by a multiple of 9. If your difference divides evenly by 9, compare entered amounts digit by digit against the statement before hunting for missing transactions.
No. The tool is plain arithmetic running in your browser. Nothing you type or paste leaves your device, and there is no signup.