Chart of Accounts Cleanup: The Half-Day Fix (2026)

Two service businesses can bill the same $640,000, spend the same money, and post the same net income, and only one of them can tell you where the margin went. The difference is almost never the bookkeeping software. It is the chart of accounts underneath it.

A chart of accounts cleanup is the least glamorous project in small business finance and one of the highest return. It takes about half a day. By the end of this post you will know what belongs in a chart of accounts, how to split direct costs from overhead so gross margin becomes real, how to size the account list, and the six mistakes that quietly make every report you run useless.

What a chart of accounts actually is

Your chart of accounts is the list of buckets your accounting system sorts every dollar into. Five types: assets, liabilities, equity, income, and expenses. Every transaction lands in one of them, and every report you pull is just those buckets added up and arranged.

That is why a bad chart of accounts cannot be fixed downstream. If your bookkeeper has been coding software subscriptions, client travel, and merchant processing fees all into one account called Office Expense, no dashboard and no advisor can recover the detail. The information was destroyed at entry. A chart of accounts cleanup is how you stop destroying it.

Most charts of accounts drift rather than get designed. You start with the software template, add an account every time something does not obviously fit, delete nothing, and three years later nine accounts carry most of the spending and one of them is called Miscellaneous.

The structure that makes a profit and loss statement readable

A usable chart of accounts is built around two subtractions:

Revenue less Cost of Goods Sold equals Gross Profit. Gross Profit less Operating Expenses equals Operating Income.

Everything else is detail. Get those two lines right and your P&L starts answering questions instead of raising them.

Revenue. Split by how you sell, not by client. Two to five income accounts is usually right: recurring versus project, or service versus product. If you cannot see which stream is growing, you cannot decide where your next hire goes.

Cost of Goods Sold. Costs that exist only because you delivered the work. Subcontractors, billable wages, materials, job specific software, merchant fees on client payments. The test: if revenue went to zero next month, would this cost go away? If yes, it is COGS.

Operating expenses. The cost of being open regardless of volume. Rent, insurance, administrative payroll, general software, professional fees, marketing. These stay whether you close one deal or forty.

Worked example: the same P&L, before and after

A consulting firm closes 2026 with these numbers, as the books currently show them:

• Revenue (one account): $640,000
• Payroll: $172,000
• Contract labor: $118,000
• Office expense: $96,400
• Rent: $42,000
• Miscellaneous: $41,200
• Insurance: $11,400
• Professional fees: $9,800

Total expenses are $490,800, so net income is $640,000 less $490,800, or $149,200. That is the entire story the current chart of accounts can tell. Net margin is 23.3 percent and nothing else is knowable.

Now the cleanup. Payroll splits into $104,000 of billable staff and $68,000 of administrative staff. Office expense splits into $14,600 of project specific software and $81,800 of general overhead. Miscellaneous breaks into software and subscriptions of $18,300, travel of $9,700, bank and merchant fees of $7,400, and dues and education of $5,800.

Cost of goods sold is now contract labor of $118,000, billable payroll of $104,000, and project software of $14,600, for a total of $236,600.

• Gross profit: $640,000 less $236,600, or $403,400
• Gross margin: $403,400 divided by $640,000, or 63.0 percent
• Operating expenses: $68,000 administrative payroll, $81,800 general overhead, $42,000 rent, $18,300 software, $11,400 insurance, $9,800 professional fees, $9,700 travel, $7,400 bank and merchant fees, $5,800 dues and education, for a total of $254,200

Operating income: $403,400 less $254,200, or $149,200.

Net income did not move by a dollar. That is the point. The cleanup changed what you can see: a 63.0 percent gross margin you can now defend or fix, and $7,400 a year in merchant fees you did not know you were paying. Both are pricing inputs, and ignoring them is one of the pricing mistakes that costs small businesses thousands.

How many accounts is the right number

There is no universal count, and anyone who gives you one is guessing. Most small service businesses run well on 30 to 60 active expense accounts. Product businesses with inventory and multiple channels usually need more, often 60 to 100. Below about 25 you lose the detail that drives decisions. Above about 100, accounts stop being used consistently, which is worse than not having them.

The test is not the count. It is whether an account would change a decision. If you would never act differently based on its balance, merge it. If you have wanted a number and could not find it, add one. Run that test as part of your quarterly financial review and the list stays honest.

One more sizing rule: your expense accounts should map cleanly to the Schedule C or 1120S categories your accountant uses. Year end then gets faster and cheaper, because nobody has to reverse engineer your coding in March.

6 mistakes that make a chart of accounts useless

1. A Miscellaneous account with real money in it. Miscellaneous is where coding decisions go to die. Once a few thousand dollars lands there, the ability to analyze it is gone. Fix: cap it. If Miscellaneous exceeds one percent of total expenses, open the detail, create the accounts those transactions belong in, and recode.
2. No separation between direct costs and overhead. Without a COGS section there is no gross margin, and without gross margin you cannot price, evaluate a client, or tell a volume problem from a margin problem. Fix: run the revenue-goes-to-zero test and move the costs that would disappear into COGS.
3. Accounts named after vendors instead of functions. An account called Amazon tells you nothing, because Amazon sells you office supplies, equipment, and shipping materials. Fix: name accounts for what the money bought, never for who you bought it from.
4. Owner draws and loan principal sitting in expenses. This is the single most common error we see, and it understates profit while overstating cost. Fix: move draws to an equity account and split loan payments so interest hits the P&L and principal reduces the loan balance on the balance sheet. This is one of the bookkeeping mistakes that get expensive at tax time.
5. Duplicate accounts that split the same spending. Software, Subscriptions, and Dues and Software all exist, each holding part of the same category, so no single balance is true. Fix: pick one canonical name per category and merge the rest. Merge rather than delete, because merging is reversible and deleting is not always.
6. A structure nobody maintains afterward. A clean account list degrades within two quarters without a rule for additions. Fix: write down who can add an account and what question a new one has to answer. One person, one rule, reviewed quarterly.

A note on 2026 vehicle expenses

One timing detail to build in this year. The IRS set two business standard mileage rates for 2026: 72.5 cents per mile from January 1 through June 30, and 76 cents from July 1 through December 31, per the IRS standard mileage rates page.

A single annual mileage total is therefore not enough. Drive 4,000 business miles in the first half and 5,200 in the second, and the deduction is 4,000 times $0.725, or $2,900, plus 5,200 times $0.76, or $3,952, for $6,852. Applying the higher rate to all 9,200 miles gives $6,992 and overstates the deduction by $140. Log miles by period, not by year.

The half-day cleanup checklist

1. Export your account list and your last twelve months of profit and loss by account into one spreadsheet, side by side.
2. Sort expense accounts by annual dollars and draw a line after the ones making up 90 percent of spending. Those are the ones that matter.
3. Open any Miscellaneous or Other account and list the actual transactions inside it.
4. Run the revenue-goes-to-zero test on every expense account and tag each one COGS or operating.
5. Circle every duplicate name and pick one canonical account per category.
6. Confirm owner draws sit in equity and that loan payments are split between interest and principal.
7. Merge the duplicates, create the accounts your Miscellaneous detail revealed, and recode the current year so comparisons still work.
8. Write the one page rule for who adds accounts, and set a quarterly calendar reminder to review it.

Where this fits

This is foundation work. It adds no revenue by itself, but almost every other financial improvement depends on it. You cannot find the profit leaks draining your business when the leaks are pooled in one account, and you cannot get useful advice from anyone, including a fractional CFO, until the structure can carry a question.

We rebuild charts of accounts as part of our fractional CFO work, and our spreadsheet templates include the before and after mapping sheet we use to do it. If you want a second set of eyes on your account list before you start merging, book a free 20-minute consult and bring the export.

Half a day of unglamorous work buys you a year of reports you can trust. There are not many trades that good in small business finance.

Simply Spreadsheets helps real estate investors and small business owners make confident decisions with clean, reliable numbers. Founded by Erin Onsager, a fractional CFO with more than 20 years of finance experience, the firm builds custom spreadsheets, financial models, and analysis that turn raw data into clear answers.