Your trial balance balances to the penny — so your books must be right. Unfortunately, that is not what a balanced trial balance means. It means your debits equal your credits, full stop. A duplicate invoice, a bill posted to the wrong account, a loan payment coded entirely to interest, even an entire missing transaction: all of them sail through a balanced trial balance without a ripple. And every one of them is something your CPA will charge you to find at tax time.
A general ledger cleanup is the fix: a systematic hunt for posting errors, done on your schedule instead of your accountant's invoice. Here is how the errors get in, how to find them, and how to correct them without making things worse.
Why a Balanced Trial Balance Proves Less Than You Think
The trial balance is a list of every account's debit or credit total, and its one job is confirming the two sides agree. That check catches exactly one class of problem: unbalanced entries. Everything else — the errors that keep debits equal to credits while misstating reality — passes silently. The most common escapees:
- Entries made twice. A duplicate is balanced by definition, so the trial balance cannot see it. You usually discover it the embarrassing way: a customer rejecting a second invoice, or a vendor getting paid twice.
- Entries never made at all. Something that was never recorded is not on the report. No report can flag what it was never told.
- The right amount in the wrong account. Post office supplies to equipment and both sides still balance. The statements are wrong, but the trial balance is serene.
- Compensating errors. Two mistakes of equal size in opposite directions cancel each other out. Rare, but it happens — and it is the hardest pattern to find by staring at totals.
- Errors of principle. Recording a capital purchase as an immediate expense, or a loan draw as revenue, follows every mechanical rule while violating the accounting one. The books balance; the tax return built on them does not hold up.
The takeaway: treat the trial balance as a starting gate, not a clean bill of health. The real cleanup happens account by account.
The 7 Posting Errors That Dirty Up a General Ledger
Most messy ledgers trace back to a short list of mistake shapes. Learn to recognize them and you will spot them faster every month.
1. The duplicate entry
The same invoice, payment, or journal posted twice — often once by an automated bank feed and once by hand. Watch for doubled revenue around payment-processor payouts and doubled expenses where a bill was entered manually and then imported again. Prevention beats detection: match feed imports against existing entries before posting, and reconcile processor payouts to gross sales rather than booking the net deposit as revenue.
2. The missing entry
Depreciation never recorded, a cash purchase with no receipt entered, an accrual skipped at month-end. Missing entries are invisible on every report, which is why the defense is procedural: keep a checklist of standard recurring entries — depreciation, amortization, accruals, loan interest, prepaid releases — and verify each one posted before you close the month.
3. The wrong-account posting
Supplies coded to equipment, personal spending buried in business meals, a transfer between your own accounts booked as income. Sometimes these announce themselves: an account that has carried a zero balance for a year suddenly shows activity. Otherwise the defense is structural — a clear, consistent chart of accounts plus standard journal templates for every recurring entry, so the correct account is the default rather than a decision.
4. The reversed entry
A debit recorded as a credit or vice versa. Large reversals often flip an account's balance to the wrong sign — a cash account showing a credit balance, a loan showing a debit balance — which is your signal. Any account sitting on the opposite side of its normal balance deserves immediate investigation.
5. The transposed digits and the slide
Typing $1,200 as $2,100 (transposition) or $1,000 as $100 (slide). In computerized systems these usually surface as out-of-balance totals that the software refuses to post, but they still creep in through opening balances, manual trial-balance adjustments, and spreadsheet imports. The classic detection trick still works: if the out-of-balance difference is evenly divisible by 9, suspect a transposition or slide, then scan entries for the digit-swapped amount.
6. The unbalanced entry
Debits that do not equal credits in a single entry. Modern software blocks these at posting, so today they mostly appear in manual books, spreadsheet ledgers, and migrated opening balances. When the column totals disagree, the hunt narrows to entries made outside the normal posting flow.
7. The error of principle
Correct amount, correct arithmetic, wrong accounting treatment — expensing a multi-year asset, netting a refund against revenue instead of recording the return, booking owner draws as salary expense. These never trip a balance check. They surface during reconciliations, ratio reviews, and the P&L reasonableness scan described below.
When the Trial Balance Won't Balance: Finding the Culprit
If your totals do disagree, don't re-check every transaction from scratch. Work the difference itself — its size points at the cause.
Divide the difference by 2. If the result matches a known entry amount, you likely found a one-sided or reversed posting: an amount recorded on the wrong side creates a difference exactly twice its value. A $450 gap with a $225 entry in the suspect batch is no coincidence.
Divide the difference by 9. An evenly divisible result points to a transposition or slide. A $36 difference suggests digits swapped somewhere to the tune of $4 in place value — for example, $195 entered as $159. Scan recent entries for the digit-swapped pair rather than re-adding columns.
Look for the lonely balance. An account that had no balance last month and has one now probably received a misposting. Compare this month's trial balance against last month's line by line; new or sign-flipped balances are suspects first, everything else second.
Check suspense and clearing accounts. Uncleared suspense balances, undeposited funds, and "ask my accountant" accounts are where half-finished work hides. They should trend toward zero — a growing balance means errors are being parked instead of fixed.
Tie the subledgers to the controls. If accounts receivable on the balance sheet doesn't match the AR aging total, or payables don't match the AP detail, the error lives in the gap between them: a direct journal to the control account that bypassed the subledger, a voided transaction that updated one side only, or a timing cutoff. Reconcile each subledger to its control account every month and this class of error gets caught within weeks, not at year-end.
The Account-by-Account GL Cleanup Checklist
A full cleanup walks the balance sheet top to bottom, then sanity-checks the P&L. Work in this order, clearing each account before moving on.
Cash and bank accounts. Reconcile every account, including savings, petty cash, and dormant ones — stale accounts accumulate bank fees and forgotten auto-charges. Every reconciling item needs an explanation and an expected clear date; anything older than 60 days is probably an error, not timing.
Accounts receivable. Tie the AR control balance to the aging detail to the penny, then review the aging itself. Invoices over 90 days past due may be uncollectible and need an allowance or write-off, not indefinite carrying. Look for credit balances — usually an unapplied payment or a refund recorded backwards.
Accounts payable. Tie AP to the vendor detail, then scan for debit balances (overpayments or unrecorded vendor credits) and invoices far past terms that were likely paid but never cleared. Duplicate vendor records — "Acme Inc." and "ACME Incorporated" — are a classic source of double payment.
Undeposited funds and clearing accounts. These are transit lounges, not residences. Every item should clear within days. Anything older than a month is either a duplicate of an already-recorded deposit or a deposit that was never matched — clear it with the actual bank deposit, not a plug journal.
Inventory. Reconcile the book balance to the physical count or perpetual report. Shrinkage, unrecorded write-offs, and freight or labor misclassified out of cost of goods sold all surface here. If you carry inventory, this account deserves its own monthly review, not an annual shrug.
Prepaids and fixed assets. Prepaid insurance, subscriptions, and deposits should amortize down on schedule — a prepaid balance that never moves means the monthly release entry stopped posting. For fixed assets, confirm every addition over your capitalization threshold is on the register with its placed-in-service date, and that depreciation ran this month.
Payroll liabilities. Gross wages, withheld taxes, and employer contributions should reconcile to the payroll reports every period, and liability balances should clear when deposits are remitted. A payroll liability account that grows month after month means payments are being expensed directly instead of relieving the liability — the books show the cost twice.
Loans and credit cards. Tie every loan balance to its lender statement and split each payment between principal and interest; the single most common small-business posting error is coding the whole loan payment to interest expense. Reconcile credit cards to statements and confirm every charge has a receipt or at least a coded purpose.
Equity, draws, and contributions. Owner draws coded as expenses understate profit and overstate deductions; personal expenses run through the business inflate them. Review every equity-account transaction for the period — these accounts have low volume and high consequences.
Suspense and "ask my accountant". Target: zero. Every parked item gets researched and reclassified to its real home. If you use a suspense account during the month, put clearing it on the close checklist so nothing survives past month-end.
The P&L reasonableness scan. Finally, compare this month's profit and loss against last month and the same month last year, line by line. Revenue roughly flat while cost of goods doubled? A familiar expense category suddenly at zero? An account with a balance that has the wrong sign? Variances are questions, not conclusions — but every material variance needs an answer before you call the books clean. A dashboard that puts the balance sheet and P&L side by side, like Fava's reports, turns this scan into a five-minute review instead of a spreadsheet project.
Fix Errors the Right Way: Correcting Entries, Not Deletions
Finding errors is half the job; correcting them without damaging the audit trail is the other half. The rules:
- Never erase, overwrite, or delete. Post a clearly labeled correcting entry — "Correct Feb invoice 1042 duplicate; see JE-2026-031" — with supporting documentation attached. Anyone, including a future auditor, should be able to trace from the error to the fix.
- Reverse and repost when the original is thoroughly wrong. If an entry hit the wrong account, wrong amount, and wrong date, reversing it in full and posting a fresh correct entry is clearer than a net adjustment that nobody can follow.
- Date corrections in the current period. Don't quietly rewrite a closed month. If the error is material to a filed return, that is a conversation with your CPA about amendment — not a backdated journal.
- Get a second pair of eyes on big fixes. Corrections can themselves be wrong. Have your most experienced reviewer approve material correcting entries before posting, especially ones touching revenue, payroll, or tax accounts.
- Lock closed periods. Once a month is reconciled and reviewed, lock it in your software so no new postings — well-meaning or otherwise — can land there. Every stray backdated entry undoes the cleanup you just finished.
Keep It Clean: Six Habits That Prevent the Next Cleanup
A cleanup you do once is a rescue; a cleanup you never need again is a system. Six habits do most of the work:
- Close the month on a deadline. Pick a close date — ten business days after month-end is a solid target — and hit it every month. Errors found within weeks are puzzles; errors found in April are archaeology.
- Run the recurring-entry checklist. Depreciation, accruals, amortizations, loan splits, prepaid releases: the same list, verified posted, every single month.
- Use templates for standard journals. If the correct accounts are pre-filled, wrong-account postings drop sharply. Reserve freeform journals for genuinely unusual items.
- Reconcile early and often. Bank, card, loan, AR, AP — reconciled monthly at minimum, with differences investigated the same week, not "at cleanup time."
- Clear suspense weekly. A suspense account reviewed weekly never grows teeth. One reviewed annually becomes a write-off factory.
- Keep the chart of accounts boring. One account per purpose, plain-English names, no near-duplicate accounts competing for the same transactions. Every redundant account is a future misposting waiting to happen.
Keep Your Ledger Clean All Year
A general ledger cleanup is really two skills: the detective work of finding errors — reading the difference, tying subledgers to controls, scanning for sign flips and stale balances — and the discipline of correcting them with documented entries and locked periods. Do the detective work monthly instead of yearly and the big annual cleanup shrinks to an afternoon.
That discipline is easier when every transaction is readable text you can search, diff, and review line by line. Beancount.io provides plain-text accounting that gives you complete transparency and control over your financial data — no black boxes, no vendor lock-in. Get started for free and see why developers and finance professionals are switching to plain-text accounting.
