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.
In today's issue, we talk about the chart of accounts. It is the list of categories every transaction in your books gets sorted into. Owen Pratt runs a pool service and repair company in Sacramento, California, and his reports said the repair side of the business lost $18,000 last year. He had already drafted an email to shut it down and let two technicians go. The fix was a rebuilt chart of accounts that tracked revenue and direct costs by service line.
Here's how it started and what it can teach you before you cut a product or service based on a report.
212 accounts and one line called Sales
Blue Oak Pool Co. services 540 residential pools on weekly routes and handles pump, filter, and heater repairs on the side. Last year it brought in $1.12 million, with $760,000 from maintenance and $360,000 from repairs.
The QuickBooks file was seven years old. Three bookkeepers had worked in it, and each one added accounts whenever something didn't seem to fit.
In January, it held 212 accounts. All revenue sat in one account called "Sales."
Chemical purchases were spread across "Chlorine," "Chlorine bulk," "Pool chemicals," and "Chemicals & supplies." A "Misc expense" account held $41,300.
To see which side made money, Owen's office manager exported the P&L to a spreadsheet and split it by hand. Anything coded to "Parts & materials" went to repairs.
| Service line |
Revenue |
Direct
costs |
Gross profit |
| Maintenance |
$760,000 |
$402,000 |
$358,000 |
| Repairs |
$360,000 |
$378,000 |
-$18,000 |
Repairs already caused most of the scheduling headaches. Losing money on top of that made the decision feel easy.
What the $18,000 loss really was
His CPA, Grace Liu, asked for the detail behind "Parts & Materials" before Owen sent anything. The account held $214,000 of purchases. Of that, $96,000 was bulk chlorine, acid, and stabilizer for the maintenance routes. A former bookkeeper had coded that supplier's invoices there because the same vendor also sold pumps and filters.
Every transaction was real, and every total on the P&L was correct. The transactions sat in the wrong account, and the report built on that account inherited the error.
Gross margin % = (Revenue - Direct costs) ÷ Revenue × 100
Repairs: ($360,000 - $282,000) ÷ $360,000 × 100 = 21.7%
Maintenance: ($760,000 - $498,000) ÷ $760,000 × 100 = 34.5%
The P&L never looked wrong
Company-wide gross profit came to $340,000 in both versions. The top-line report had no error to find. The problem only surfaced when Owen asked a question his chart of accounts wasn't prepared to answer.
The correction also hurt the side Owen trusted. He believed his maintenance routes earned a 47.1% margin. They earned 34.5%, and he had priced the last two rounds of new routes against the wrong number.
What a chart of accounts actually does
The chart of accounts is the master list of every account in your general ledger. Each transaction gets coded to one of them, and every report you run (the P&L, the balance sheet, a margin analysis, your tax return) adds those accounts up in a different way. A weak structure produces weak reports even when every entry is accurate.
A clean chart follows the order of the financial statements, with a number range for each account type.
Anyone who sees account 5200 knows it's a direct cost before reading the name.
How Grace rebuilt it
Revenue split into 4100 Maintenance revenue and 4200 Repair revenue. Direct costs mirrored that split, with 5100 Maintenance chemicals, 5150 Maintenance labor, 5200 Repair parts, and 5250 Repair labor. When revenue and cost of goods sold follow the same structure, gross margin by service line comes straight off the P&L with no spreadsheet in between.
The four chemical accounts became one. "Misc expense" closed, and every item in the $41,300 got a proper home. Anything that doesn't fit an existing account now goes to Grace as a question.
Owen asked for a separate account for each commercial client. Grace used QuickBooks classes for that, which let him filter by customer while the chart stayed short.
She archived 131 unused accounts. Archiving hides them from the coding list and keeps their history, so last year's reports still run. Deleting them would have broken every prior-year comparison. The active chart went from 212 accounts to 81, numbered in steps of 50, so new accounts slot into order later.
The new structure started on January 1, and Grace mapped the prior year into it so both years compare line by line.
Signs your chart needs a cleanup
Open your chart of accounts and count. A small service business can run cleanly on 60 to 100 accounts, and a count above 150 usually means duplicates. Look for pairs that describe the same thing, like "Bank charges" and "Bank fees."
Check the balance in anything called Misc, Other, or Ask my accountant, because a four-figure total there means the structure has gaps. Then try to pull gross margin for each thing you sell straight from the P&L.
If that takes a spreadsheet, your revenue and cost of goods sold aren't split the same way, and the answer depends on whoever built the spreadsheet.
One owner for new accounts
Only Grace and the office manager can add an account now, and each one needs a one-line reason. Three bookkeepers each adding a handful of accounts over seven years is exactly how Blue Oak reached 212.
The email Owen never sent
The repair division stayed, and so did both technicians. Owen raised maintenance route prices by $12 a month across all 540 pools, which added $77,760 a year.
The numbers had been in his books the whole time. The chart of accounts decided which questions they could answer.
During the cleanup, Grace found $54,000 of Owen's personal transfers coded to "Officer wages," an account his single-member LLC had no use for. How founders should pay themselves is Friday's issue.
