Your Chart of Accounts Has 200 Accounts. It Should Have 30.

A company I worked with ran its operations out of dozens of locations. Every location had its own stack of accounts in QuickBooks. So did every piece of equipment sitting inside them. Buy a four hundred dollar piece of gear for one site and it got its own account, its own name, and a permanent line on the balance sheet.

When I asked the owner about it, he said he wanted to see everything. I can appreciate the instinct he had. More detail sounds like the best way to have a handle on the numbers.

What he ended up with was a chart of accounts acting like an inventory log. QuickBooks was tracking equipment site by site and item by item, which is not what it was built to do.

And equipment at those locations turned over constantly. Things got moved, swapped, replaced, hauled off. Almost none of that made its way back to finance. So accounts sat on the books for gear that was long gone, and gear that showed up last spring wasn't in there at all.

By the time I got into the file, the chart of accounts was around two hundred lines. The balance sheet ran over six pages, and the P&L wasn't much better. Nobody could pull up either one and come away knowing how the month had gone.

He could see everything. Most of it was already wrong.

Why a long list stops being information

Every account on your list is a question your reports answer for you every month. One equipment account asks what you spent on equipment. Forty of them, one per machine, ask forty questions nobody had. You get forty answers anyway.

So the line you actually came for sits buried in thirty-nine you don't need. That's the cost people expect.

The one they don't expect is upkeep. Every account on that list is something somebody has to maintain, and the people who know when a machine gets moved or breaks or goes to the dump usually don't work anywhere near your accounting file. When that news doesn't make it back, the account keeps right on reporting. It just reports on a version of the business that stopped existing a while ago.

Detail you can't keep current is worse than no detail, because you'll believe it.

What I ask before I touch the list

When an owner hands me a file like that, I don't start deleting. I start asking.

Tell me about the business. What do you need to see every month to know how it went? What are you deciding off these numbers, whether you can hire, what to charge, whether there's room to take a distribution? Who else reads these reports, and what are they looking for when they do? And what have you gone looking for in the last year that you couldn't find?

That last question is usually the one that pays. The thing an owner went hunting for and couldn't turn up tells me exactly what the reports were never built to answer.

Most owners need fifteen or twenty lines on a P&L and a balance sheet they can take in on one screen. Everything past that is detail, and detail belongs somewhere, just not on the face of the report.

Where I start

I know this sounds like a chart of accounts problem rather than a balance sheet problem. I still start on the balance sheet, because that's where a bloated list does its quietest damage, and I read it one account at a time.

I'm looking for assets listed one by one, several of them sold or scrapped years ago and still sitting there at full value. Loans that were paid off and never closed out. Two versions of the same bank or credit card account, usually left behind when a feed got disconnected and reconnected. Opening balance equity still carrying a balance, which means something got entered when the file was set up and nobody ever sorted out where it belonged.

Then the P&L, which is where duplicates breed fastest. "Bank Fees," "Bank Charges," and "Service Charges," all active, all collecting transactions. Three versions of the same expense category because three different people each added the one they had in mind. Accounts the bank feed created on its own when it didn't recognize something, and nobody cleaned up after.

None of that came from one bad decision. It grew one reasonable addition at a time, and pruning it was never anybody's job.

A chart of accounts tends to grow on its own, and pruning it takes thoughtful effort.

What a clean structure looks like

For most service businesses, a working chart of accounts runs somewhere around thirty accounts. A few bank and credit card accounts. Fixed assets in a handful of groups: equipment, vehicles, furniture, leasehold improvements. One line for the group, not one line per machine. Loans and credit lines. Equity. Then revenue split the way you actually think about your business, and expense categories broad enough to stay steady month over month.

Thirty isn't a rule. It's roughly where a service business lands once the list reflects the decisions you make. Yours might be twenty-five. It might be forty.

If it's over a hundred, then we've got some pruning to do. There are two common ways I cut things down.

Class tracking

QuickBooks lets you tag a transaction with a class, which is a second label riding alongside the account. That's how we got location-level detail for that company without forty copies of every account. One "Supplies" account, tagged by location. Your P&L collapses down to a single clean column, and on the months you want the breakdown, you open it up by location.

A sub-ledger in a spreadsheet

A fixed asset register is just a spreadsheet. Every piece of equipment, what it cost, when you put it in service, where it lives.

Then the part that makes it worth keeping: how long you're depreciating it over, what you've depreciated so far, and what it's worth on the books today. That's what turns a list of equipment into a real depreciation schedule. Without those columns you have an inventory count. With them you can tie the whole spreadsheet back to two lines in your chart of accounts, equipment and accumulated depreciation, and prove the total. It's also what your tax preparer is going to ask you for at year end, and having it ready is a much better January than reconstructing it from receipts.

The spreadsheet isn't the part that fixes anything. The schedule is. One person can own one file and keep it current. Nobody can keep two hundred accounts current off changes in the field that never get reported. Decide who updates it and how often before you build it, or you'll just trade one problem for another.

Those two moves took that company from around two hundred accounts to a P&L and a balance sheet that each fit on one page.

That's what I think business financials ought to look like. One page. If your reports don't fit on one page you'll skim them, and skimming is how things get missed. The detail doesn't go away. It sits underneath, ready for the month you have a question that needs it.

How to consolidate without losing history

Two ways to shrink the list, and they don't behave the same.

Making an account inactive hides it from the list and from new transactions and leaves its history exactly where it is. Prior-period reports don't move. If the account still carries a balance, QuickBooks won't fully hide it until you clear that balance, which is a built-in safeguard to keep your numbers accurate.

Merging folds one account's entire history into another, across every period you've ever reported on. Merge "Bank Charges" into "Bank Fees" and last year's reports quietly rewrite themselves to match. For genuine duplicates that's usually what you want. It's also close to impossible to undo, so it isn't a Friday afternoon job.

Throughout this process, it's important to take your time. I've written down the ideal structure on paper before I ever touch the live file. Order matters a lot here. Reconcile every bank, credit card, and liability account first. That makes sure stray balances don't get mixed in where they don't belong. Then merge the true duplicates, and make the leftovers inactive. Rushing a restructure on a live, unreconciled file is a surefire way to lose a week and gain a lot of grey hair.

An owner who can read their own reports makes better calls. That's most of the reason this is worth doing.

Check your own file this week

1. Count the accounts in your chart of accounts. QuickBooks will show you the total. Write the number down.
2. Search the list for "fee," "misc," "other," and "ask my accountant." Anywhere two accounts mean the same thing, you've found your first merge.
3. Sort by balance and find the accounts with no activity in the last twelve months. Those are your candidates to make inactive.
4. Open last month's P&L and read it top to bottom. Every time you hit a line and think "I don't know what's in there" or "I don't need this," mark it.

If that took you more than twenty minutes, mark that too.

If the file fights back

Most of this you can do yourself. An afternoon and a willingness to make a few decisions will get you most of the way there.

If you get in and it fights you, balances that won't clear, a merge you aren't sure about, a shape you can't quite picture, that's worth talking through before you start deleting. Send me a note and tell me what your file looks like, and I'll tell you whether it's an afternoon or a project.