A chart of accounts that matches how the business runs

Most charts of accounts were created on the day the accounting file was set up, from a template, by whoever was available. Years later the company has three locations, four service lines and a chart that lumps everything into a handful of revenue accounts and a long tail of expense accounts named after whoever set them up. The statements are accurate and useless, because they cannot answer the questions the owner asks.

Restructuring the chart is one of the highest-return projects in a growing company, and it is far less disruptive than owners fear. Here is how we do it.

Start from the questions

List the questions the owner and managers ask that the statements cannot answer today. Margin by service line. Profit by location. Cost of the fleet. What the marketing actually costs. Revenue from maintenance plans versus installations. Each question tells you a dimension or an account you need. If nobody will ever ask a question that an account answers, that account does not need to exist.

Involve the people who will code transactions in this conversation. The bookkeeper knows which accounts are confusing and which are used as a dumping ground. The operations manager knows which costs they want to see separately. A chart designed only by the owner and the CPA tends to be elegant and then misused, because the people entering transactions were never shown why the structure matters.

Separate the nature from the dimension

The most common mistake is to build dimensions into the account list, so there is a separate wages account for each location and a separate materials account for each service line. The chart balloons and reporting becomes a manual exercise. Modern accounting platforms used in Canada have tracking categories, classes, departments or projects for this purpose. Use accounts for the nature of the transaction, such as revenue, materials, direct labour, rent, and use the tracking dimension for where it belongs, such as location, service line, product family or job.

With that structure, one report filtered by dimension gives you an income statement by location or by service line with no extra bookkeeping.

Design the revenue and cost of sales sections carefully

Revenue accounts should match how you sell: by service line or product family, not by customer. Cost of sales accounts should match what it costs to deliver that revenue: materials, direct labour, subcontractors, freight, merchant fees, consumables. Keep overhead out of cost of sales entirely, so gross margin on the statements means the same thing as gross margin in your pricing model.

Agree the definition of cost of sales with your CPA so the monthly statements and the year end statements present margin the same way.

Prune the expense accounts

Group operating expenses into a short list of headings that mean something to a manager: people, occupancy, vehicles and equipment, marketing, technology, professional fees, administration. Under each heading keep only the accounts that someone will act on. Merge the rest. Name accounts in plain words. A chart with sixty accounts that are used consistently gives better information than one with three hundred that are not.

Add a small number of balance sheet accounts that growing companies often lack: customer deposits, unbilled revenue, accrued liabilities, and separate accounts for each loan and lease.

Make the change cleanly

• Pick a cut-off, usually the start of a fiscal year or a quarter
• Build a mapping from every old account to its new account and dimension
• Rename, merge or archive accounts in the system rather than deleting them, so history remains intact
• Update templates for invoices, bills, expense claims and payroll so new transactions land correctly
• Write a one-page coding guide with examples and give it to everyone who enters transactions
• Review the first month's coding line by line and correct the habit early

What you get

Within a quarter the monthly statements show margin by service line and profit by location without a spreadsheet. The weekly pack and the dashboard draw from the same structure. Pricing decisions use the same cost of sales definition as the statements. And when a lender, an investor or a buyer asks how the business makes money, the answer comes straight from the accounting system rather than from a reconstruction.

The structure also makes the next system change, such as adding job costing or inventory, far easier, because the dimensions already exist.