Bookkeeping · Cleanups & Fixes · Brief · Pro level
Books run on journal entries: why the reports lie and how to unwind it
When sales, payments, and payroll are posted as manual journal entries instead of source transactions, subledgers stop matching the ledger and every customer-level report is wrong. Here is the diagnosis and the unwind strategy.
A ledger can be perfectly balanced and thoroughly wrong. When sales are posted as monthly journal entries to Accounts receivable, payroll as one lump JE, and deposits as JEs to cash, the trial balance ties — but the subledgers underneath it are empty or estranged. Every report that reads transaction detail rather than account totals — agings, customer statements, sales tax liability, 1099 totals — is now fiction.
Symptom
The AR aging doesn't equal the AR line on the balance sheet; neither does AP. Customer statements are unusable. Sales tax reports don't match what was filed. The journal-entry list is long, rhythmic — the same accounts, every month — and the entries cite no invoices or bills. Often this arrives with an inherited file, or after an owner "kept it simple" from a spreadsheet, a variant of the migration cleanup problem.
Why it happens
Habit and haste. Accountants trained on trial balances treat the JE as the universal tool; owners find one entry faster than twelve invoices. And software permits it: nothing stops a journal entry from debiting a control account directly. The JE is the right tool for adjustments — depreciation, accruals, corrections — and the wrong tool for anything that has a customer, vendor, employee, or tax authority attached, because those reports are built from source-transaction detail the JE never creates.
The fix
- Size the damage. For each control account — AR, AP, payroll liabilities, sales tax payable, undeposited funds — compare the subledger report to the ledger balance and note the gap.
- Pick a clean-start date. Usually the start of the current fiscal year, or the month after the last filed return. Prior filed periods get verified, not rebuilt.
- Rebuild forward from source documents. Enter real invoices, bills, payments, and payroll runs from the clean-start date, working from bank statements, the invoice system, and payroll reports.
- Reverse the overlapping journal entries so nothing is double-counted. Reverse — don't delete — so the audit trail survives:
| Account | Debit | Credit |
|---|---|---|
| Sales revenue | 38,400 | |
| Accounts receivable | 38,400 |
The rebuilt invoices now carry April's sales; the reversal removes the duplicate JE amount from the control account.
- Prove each control account. Aging equals balance sheet, payroll liabilities tie to filings, sales tax payable ties to returns.
- Re-reconcile the bank for the rebuilt months per the complete bank reconciliation — the rebuild isn't done until cash proves.
How to prevent it
- A written rule: journal entries never touch AR, AP, payroll liabilities, sales tax, or undeposited funds. Adjustments to those balances go through source transactions or dedicated adjustment tools.
- Monthly tie-outs of every subledger to its control account, as part of the close.
- JE review: every manual entry carries a memo and a document; a reviewer scans the JE list monthly. Books with heavy, undocumented JE traffic are also a classic engagement warning sign — see client red flags.
What to do next
- Tie each subledger to its control account today and measure the gaps.
- Set the clean-start date; rebuild forward from source documents, reversing overlapped JEs.
- Adopt the no-JE-to-control-accounts rule and add subledger tie-outs to the monthly close.
Frequently asked questions
- Why is it bad to record everything with journal entries?
- Manual journal entries bypass the subledgers. A JE to Accounts receivable moves the control account but touches no customer or invoice, so agings, customer statements, sales tax reports, and 1099 totals all drift from the ledger. The trial balance can look perfect while every operational report built on transaction detail is wrong.
- How do I tell if books rely too heavily on journal entries?
- Compare the AR and AP agings to their balance sheet control accounts — differences usually mean JEs hit the control accounts directly. Then list journal entries by count and account: recurring JEs to AR, AP, payroll liabilities, sales tax, or undeposited funds, especially monthly lump sums, are the signature of journal-entry bookkeeping.
- How do you fix books that were kept with journal entries?
- Pick a clean-start date, rebuild activity from that date using source transactions — invoices, bills, payments, payroll runs — then reverse the overlapping journal entries so balances aren't doubled, and prove each control account against its subledger. Historic periods already filed are usually left as-is with balances verified, not rebuilt.