How to Set Up a Chart of Accounts That Actually Makes Sense

I've inherited hundreds of QuickBooks files from clients. The chart of accounts is a mess in at least half of them. Revenue mixed with reimbursements. COGS accounts that should be OpEx. Fifty accounts for expenses that could be five. And my personal favourite: a catch-all account called "Miscellaneous" that holds 30% of all transactions.

Your chart of accounts is the skeleton of your financial reporting. If it's wrong, every report built on top of it is wrong too.

The Five Account Types

Every account falls into one of five categories. Get this right and everything else follows.

Assets: What your business owns. Bank accounts, accounts receivable, equipment, prepaid expenses. These live on your balance sheet.

Liabilities: What your business owes. Accounts payable, credit cards, loans, HST collected, payroll liabilities. Also on the balance sheet.

Equity: What's left for the owners after subtracting liabilities from assets. Retained earnings, owner draws, share capital. Balance sheet.

Revenue: Money earned from your core business activities. Sales, service revenue, consulting fees. P&L.

Expenses: Money spent to operate the business. Split into COGS (direct costs of delivering your service) and operating expenses (overhead). P&L.

The Structure That Works

For a service business doing $500K to $5M in revenue, here's the chart of accounts structure I use with every client.

Revenue (4000-4999)

One account per revenue stream. If you have three service lines, you have three revenue accounts. Don't lump them together. You need to see which services are growing and which aren't. Example: 4010 Consulting Revenue, 4020 Training Revenue, 4030 Retainer Revenue.

COGS (5000-5999)

Direct costs only. Labour (wages for people who deliver the service), subcontractors, materials, and direct project costs. If a cost goes up when you do more work and goes down when you do less, it's COGS. Example: 5010 Direct Labour, 5020 Subcontractors, 5030 Materials, 5040 Project Travel.

Operating Expenses (6000-7999)

Group by category. Payroll and benefits (6000s), facilities (6100s), technology (6200s), marketing (6300s), professional fees (6400s), insurance (6500s), admin (6600s). Within each category, keep 3 to 5 accounts. Not 20. Example: 6010 Salaries - Admin, 6020 Benefits, 6030 Payroll Taxes, 6110 Rent, 6120 Utilities.

Common Mistakes I Fix

Too many accounts. If you have 15 expense accounts with less than $500 per year each, merge them. A P&L with 80 expense line items is useless. Nobody reads it. Target 25 to 35 expense accounts total.

Miscellaneous everything. If your "Miscellaneous" or "Other Expenses" account is more than 5% of total expenses, you're hiding transactions. Break it apart. Every dollar should have a home.

COGS vs. OpEx confusion. Your bookkeeper's salary is OpEx. Your technician's salary is COGS. If direct labour is in operating expenses, your gross margin is inflated and your P&L is lying to you. This is the single most common chart of accounts error I see.

One account for all revenue. "Sales" as a single account tells you nothing. You can't see which services are profitable, which are growing, or where to focus. Break it out.

Duplicate accounts. "Office Supplies" and "Supplies - Office" both exist with transactions in each. QBO makes it easy to create new accounts. Audit quarterly and merge duplicates.

Setting It Up in QuickBooks

1. Start with the default chart. Delete everything you don't need. Most businesses can remove 30 to 50 default accounts.
2. Add your revenue accounts. One per service line or product category.
3. Set up COGS properly. Only direct costs. Everything else goes to OpEx.
4. Create numbered account groups. Use 4000s for revenue, 5000s for COGS, 6000s for OpEx. This keeps your reports organized.
5. Name accounts plainly. "Software Subscriptions" not "Computer and Internet Expenses." You should know exactly what's in each account from the name.

What to Do This Week

1. Print your current chart of accounts. How many active accounts do you have? How many have zero balance?
2. Check your COGS. Is everything in there truly a direct cost? Move anything that isn't.
3. Find your "Miscellaneous." How much is in it? Reclassify those transactions to proper accounts.
4. Merge duplicates. Look for accounts with similar names and merge them in QBO.

The Bottom Line

A clean chart of accounts takes 2 hours to set up and saves you hundreds of hours of confusion over the life of your business. Your P&L and balance sheet are only as good as the accounts behind them. Get the foundation right and every financial decision gets clearer. If your QBO file is a mess and you need help cleaning it up, book a free call.

Next step: run your numbers through the free CFO scorecard.