Trial Balance Errors Your Totals Won't Catch


Issue #47

Trial Balance Errors Your Totals Won't Catch

Happy Friday,

Welcome back to Balance Sheet. Every issue follows one real business with a problem hiding in its numbers, walks through what went wrong on the books, and shows you the fix.

Today's issue is about the trial balance, the report that proves your debits equal your credits and very little else. Marisol Ortega runs Brightline Electric, a 12-person commercial electrical contractor in Spokane, and her trial balance matched to the penny at $612,400 on both sides. Her lender still found more than $30,000 in posting errors. Those errors nearly cost her a truck. The fix was a post-trial-balance review built around the five errors a trial balance can't see.

Here's how it started, and what it can teach you before your next loan application or year-end close.

The report that looked perfect

In March, Marisol applied for a $150,000 equipment line to buy two bucket trucks. The bank asked for year-end financials, so her bookkeeper ran the adjusted trial balance, saw both columns agree, and sent the package over.

Matching totals feel like a clean bill of health. Debits on the left, credits on the right, with the same number at the bottom. Everyone at Brightline relaxed.

Two weeks later, the bank's credit analyst called with three questions. Why did repairs expense jump 60% in a year with no major breakdowns? Why were accounts payable lower than the vendor statements in the file? And why did one customer show a $7,250 credit balance?

Each question pointed at a real error. None of them had moved the trial balance by a single cent.

What a trial balance actually tests

A trial balance lists every general ledger account with its ending balance, debits in one column, and credits in the other. Under double-entry bookkeeping, every journal entry posts equal debits and credits, so the two totals should agree.

Total debit balances = Total credit balances

It confirms each entry had two equal sides and that balances were carried over and footed correctly. It checks arithmetic.

It says nothing about whether the right accounts were used, whether the amount matched the source document, or whether a transaction was recorded at all. Any error that hits both columns equally slips straight through.

Accountants run the report three times in each cycle. The unadjusted trial balance comes first, straight from the day-to-day postings. The adjusted trial balance follows once accruals, deferrals, and depreciation are booked, and it feeds the financial statements.

The post-closing trial balance comes last, after revenue and expense accounts are closed to retained earnings. Brightline's bookkeeper had sent the adjusted version, and all three would have shown the same perfect match.

Five common errors that stay invisible

Accountants group these blind spots into five categories. Brightline had four of them.

Error type What happened at Brightline Why the totals still agreed
Error of principle $18,500 van upfit debited to Repairs and Maintenance A debit is still a debit, just in the wrong class of account.
Error of omission $4,300 wire distributor invoice never entered Neither side was recorded.
Error of commission $7,250 payment from Hayes Property credited to Hayes Construction. Total accounts receivable stayed correct.
Error of original entry $5,940 sales invoice keyed as $5,490 on both sides The same wrong figure hit both columns.
Compensating error None found Two equal mistakes on opposite sides cancel out.

The error of principle did the most damage. The shelving, ladder racks, and inverter in that van will serve the business for years, so the cost belongs on the balance sheet as a fixed asset.

Depreciated straight-line over five years, it would have put only $3,700 of expense on this year's income statement. Booking the full $18,500 as repairs understated net income by $14,800 and understated total assets by the same amount.

The surprise in the corrections

Here's the detail that caught Marisol off guard. Hear this out, as you might make the same mistake yourself. Her errors made Brightline look worse than it was.

Add up the effects, and net income was understated by $10,950. The missing invoice pulled profit up by $4,300, the keyed invoice pulled it down by $450, and the van upfit pulled it down by $14,800.

Banks size credit lines on debt service coverage, which compares operating cash flow to annual loan payments. Lower reported profit means a weaker coverage ratio. Marisol's first offer came back at $110,000, enough for one truck.

Fixing each error took a correcting journal entry.

Correction Debit Credit
Reclassify the upfit. Vehicles and Equipment
$18,500
Repairs and Maintenance
$18,500
Record depreciation Depreciation Expense $3,700 Accumulated Depreciation
$3,700
Post the missing invoice. Materials Expense $4,300 Accounts Payable: $4,300
Move the customer payment. AR, Hayes Construction,
$7,250
AR, Hayes Property, $7,250
Fix the keyed invoice. Accounts Receivable: $450 Sales Revenue $450

Now, if you look closely at the table, you will see that every correction has an equal debit and credit, which is exactly why the original mistakes never disturbed the totals.

What a trial balance does catch

The report still earns its place. It flags one-sided postings, an entry posted twice on the same side, a balance dropped into the wrong column, and footing mistakes.

When your totals disagree, accountants reach for two quick tests. Divide the difference by 9. If it divides evenly, look for a transposition in a single account, like $540 written as $450. Then divide the difference by 2. If the result matches an account balance, that balance probably sits in the wrong column.

Transposition test: Difference ÷ 9 = whole number

Wrong-column test: Difference ÷ 2 = a balance in the ledger

The review that comes after the balance

Brightline's bookkeeper now treats a balanced trial balance as the starting line. The month-end close adds four checks.

  1. Reconcile every bank and credit card account to its statement.
  2. Tie the AR and AP subledgers to their control accounts, customer by customer and vendor by vendor.
  3. Scan every expense over $2,500 and ask whether the item will still be working for the business next year. If it will, it probably belongs on the balance sheet.
  4. Compare each account to the prior period and investigate any move above 20%.

The fourth check would have caught the repairs spike in about four minutes. The subledger tie would have surfaced the Hayes mix-up the same afternoon.

Back to the bucket trucks

After the corrections, Brightline's restated net income rose by $10,950 and total assets rose by $14,800. The analyst reran the coverage ratio, and the line was approved at the full $150,000. Marisol bought both trucks in May.

So the next time your trial balance matches, take it as permission to start the review. The reconciliations and period comparisons are where real errors show up, usually in the accounts nobody thought to question.

Feedback

​Subscribe to participate in polls.

If you have specific feedback or anything interesting you’d like to share, please let us know by replying to this email.

P.S. That missing $4,300 invoice had three small characters printed at the bottom: 2/10 net 30. Friday's issue explains why paying it 20 days early can beat a bank loan.

600 1st Ave, Ste 330 PMB 92768, Seattle, WA 98104-2246

​Unsubscribe · Preferences​
​

Balance Sheet

Balance Sheet is a practical accounting and business finance newsletter that helps students, young professionals, founders, freelancers, and small business owners understand the numbers behind smart business decisions.

Read more from Balance Sheet
Allowance for Doubtful Accounts, Step-By-Step

Issue #49 Allowance for Doubtful Accounts, Step-By-Step Happy Friday, Welcome back to Balance Sheet. Every issue follows one real business with a problem hiding in its numbers, walks through what went wrong on the books, and shows you the fix. Today's issue is about the allowance for doubtful accounts, the line on the balance sheet where accountants admit some customers won't pay. Danielle Okafor runs Keystone Staffing, a light-industrial staffing agency in Tulsa, and her largest client, a...

2/10 Net 30 & The Math Of Paying Early

Issue #48 2/10 Net 30 & The Math Of Paying Early Happy Monday, Welcome back to Balance Sheet. Every issue follows one real business with a problem hiding in its numbers, walks through what went wrong on the books, and shows you the fix. Today's issue is about 2/10 net 30, the early payment discount printed on millions of vendor invoices. Tomas Becker runs Redline Collision, a 9-bay auto body shop in Sacramento, and he buys about $42,000 a month in paint, clear coat, and replacement parts on...

Days Sales Outstanding and the $112,000 wait

Issue #46 Days Sales Outstanding and the $112,000 wait Happy Monday, Welcome back to Balance Sheet. Every issue follows one real business with a problem hiding in its numbers, walks through what went wrong on the books, and shows you the fix. Today's issue is about days sales outstanding, the number that tells you how long customers take to pay you. Marisol Ortega runs a commercial cleaning company in Raleigh, North Carolina, and $112,000 of her cash was sitting in her customers' bank...