How to untangle wrong journal entries in QuickBooks
When a predecessor has posted incorrect or fabricated journal entries across a fiscal year, here is a practical approach to finding, documenting, and fixing the damage in QuickBooks.
When you step into a new accounting role and start digging into the books, discovering a trail of incorrect journal entries (JEs) is an unwelcome but common scenario. Whether the previous bookkeeper misunderstood the software, got lazy, or simply guessed at numbers to force the books to balance, you are now left with the cleanup.
One frequent red flag is the use of “plug” numbers. If an accountant cannot get a payroll entry to balance and simply offsets the difference to an insurance expense or a miscellaneous account, that fabricated amount masks the real problem. Over a full fiscal year, this practice can severely distort your financial statements.
Spotting the fabricated entries
To figure out exactly how deep the problem goes, you need to isolate the damage. Instead of clicking through the register line by line, use the built-in reporting tools to get a bird’s-eye view.
Run a Journal Report (Accountant menu > Journal) or an Audit Trail Report filtered for the fiscal year in question. Look for:
- Round, suspiciously even numbers posted to expense accounts.
- Repeated offsets to a single account (like insurance or miscellaneous expense).
- Entries that lack a clear, descriptive memo.
Documenting before you delete
Before changing or deleting anything, document the errors. If you are cleaning up last year’s books and those numbers have already been used for tax filings or external reporting, you need to know exactly what is changing.
Print or export the incorrect JEs. Note the transaction date, the accounts affected, and the dollar amounts. This gives you a roadmap for your fixes and provides a paper trail if management asks why the financials are shifting.
Fixing the entries in QuickBooks
How you fix the entries depends on whether the fiscal year is still open or has been closed.
If the year is still open: You can simply open the offending journal entry, edit the accounts and amounts to reflect the correct data, and save it.
If the year is closed: Best practice is to leave the original, incorrect entry intact and post a new, reversing journal entry. This negates the impact of the mistake without altering historical records. Date the reversing entry for the current period, or for the first day of the period where the mistake was discovered.
Reconciling the corrected accounts
Once you have corrected the payroll entries—or whatever accounts were used as dumping grounds for plug numbers—you must verify the balances.
Run a Trial Balance and a Profit and Loss report for the affected period. Check that your wage, tax, and benefit accounts now match your actual payroll reports. If the books were previously failing to reconcile because transactions were simply omitted, ensure those missing transactions are now properly recorded so the debits and credits actually match.
Next steps for the cleanup
If you find yourself facing a massive web of fabricated entries spanning multiple accounts, the manual cleanup process can quickly become overwhelming. In QuickBooks Desktop, you can use the Accountant Center tools to help hunt down the discrepancies, or look into dedicated troubleshooting steps if you are working in QuickBooks Online and need to systematically undo and reclassify batches of transactions.