-
[ltr]
[font="Google Sans Text", sans-serif]A QuickBooks reconciliation discrepancy report is a built-in diagnostic tool that highlights any transactions from past reconciliations that have been modified, deleted, or changed, which helps you pinpoint why your accounts are failing to balance.
[font="Google Sans Text", sans-serif][font="Google Sans", sans-serif]What Is a QuickBooks Reconciliation Discrepancy Report?[/font]
[/font]
Trying to balance your accounts at the end of the month only to find that your numbers don't match can be incredibly frustrating. One of the hidden culprits behind an off-balance ledger is a change made to a transaction that was already successfully reconciled in a previous period.
When someone edits, deletes, or un-clears a past transaction, it alters your beginning balance and throws off your current work. The QuickBooks reconciliation discrepancy report is specifically designed to hunt down these exact changes so you can fix them quickly and get your books back in order.
[font="Google Sans", sans-serif]How to Run a Discrepancy Report in QuickBooks[/font]
Finding these hidden changes doesn't have to be a guessing game. Depending on whether you are using QuickBooks Online or QuickBooks Desktop, the steps to pull this report are straightforward.
[font="Google Sans", sans-serif]Running the Report in QuickBooks Online[/font]
[/font]- [font="Google Sans Text", sans-serif]Navigate to the Reports menu from the left-hand sidebar.
[/font] - [font="Google Sans Text", sans-serif]In the search bar, type Reconciliation Discrepancy.
[/font] - [font="Google Sans Text", sans-serif]Select the correct bank or credit card account from the drop-down menu and choose your preferred date range.
[/font] - [font="Google Sans Text", sans-serif]Click Run Report to view any transactions that have been altered after a previous reconciliation was closed.
[/font]
[/font]- [font="Google Sans Text", sans-serif]Go to the top menu bar and select Reports.
[/font] - [font="Google Sans Text", sans-serif]Hover over Banking, then click on Reconciliation Discrepancy.
[/font] - [font="Google Sans Text", sans-serif]Choose the specific account you want to inspect from the account list and click OK.
[/font] - [font="Google Sans Text", sans-serif]Review the generated list to see if any past transactions show modified amounts, dates, or status changes.
[/font]
Once you have generated your report, you will see a list of transactions that deviate from their original reconciled state. Here is how to handle what you find:
[/font]- [font="Google Sans Text", sans-serif]Check for Edited Amounts: If a transaction's value was changed, click on it to open the transaction details, review your bank statements, and correct the amount back to what originally cleared.
[/font] - [font="Google Sans Text", sans-serif]Identify Deleted Entries: If a past entry was completely deleted, you will need to re-create the transaction and properly mark it or link it to the correct period.
[/font] - [font="Google Sans Text", sans-serif]Look at the Audit Log: If the discrepancy report doesn't catch everything, check your QuickBooks Audit Log to see who made changes to past transactions and when those edits occurred.
[/font]
If you have reviewed your discrepancy reports, checked your audit logs, and attempted to correct past entries, but your accounts still refuse to balance or your beginning balance remains incorrect, your company file may be suffering from multiple compounding historical errors.
If persistent reconciliation discrepancies are holding up your month-end close and you need immediate, reliable assistance, you can call support at 1-855-739-9879 to speak with a specialist who can help audit and resolve complex balancing issues.
[font="Google Sans", sans-serif]Frequently Asked Questions[/font]
[font="Google Sans", sans-serif]Why is the discrepancy report blank even though my account won't balance?[/font]
A blank discrepancy report simply means no transactions from past closed reconciliations were modified or deleted. Your current out-of-balance issue is likely stemming from an un-cleared entry, a data entry typo, or an incorrect beginning balance in your current open reconciliation period.
[font="Google Sans", sans-serif]Can editing a past transaction change my current beginning balance?[/font]
Yes. Every time you edit, delete, or un-check a transaction that was included in a previous month's reconciliation, QuickBooks automatically shifts your beginning balance for the next period, creating an immediate mismatch.
[font="Google Sans", sans-serif]Is it safe to change a transaction flagged in the discrepancy report?[/font]
Generally yes, provided you cross-reference your actual bank statements to ensure you are restoring the transaction to its true historical amount that originally cleared your bank account.
[font="Google Sans", sans-serif]Conclusion[/font]
A QuickBooks reconciliation discrepancy report is an invaluable tool for tracking down hidden ledger edits and keeping your financial statements accurate. By running this report, identifying modified entries, and correcting past errors, you can restore balance to your accounts and ensure your monthly reconciliations go smoothly.[/font][/ltr] - [font="Google Sans Text", sans-serif]Navigate to the Reports menu from the left-hand sidebar.
Sign in or register to take part in discussions.
Polyphone needs you!
Polyphone is free but there are costs associated with its website and development. A small donation will help a lot.
Donate
Learn the basics
Try a tutorial
Scroll to
top
top