Fintrix Consulting LLC

Bookkeeping

How to design a chart of accounts that gives useful reports

November 18, 2026 · 10 min read

← All articles
Black binders with colored index tabs stacked beside a calculator and a potted plant on a white desk
Photo via Pexels

Quick answer

Start from the reports you want, not from the software's default list. Split income the way you sell, put the costs of delivering that income above gross profit, keep expense accounts close to the lines your tax return uses, and use classes (not extra accounts) for departments and service lines. Most small businesses end up with 30 to 60 active accounts, each with a one-line rule for what goes in it.

You ask your bookkeeper a simple question: "Are the project jobs actually making money?" The answer comes back as a shrug and a promise to "pull something together." The data exists. Every invoice and every contractor bill is in the system. It just went into accounts that can't answer the question.

That's what a chart of accounts decides. It's the list of buckets every transaction lands in, and your profit and loss, balance sheet, budget and tax return are all built from those buckets. If the buckets are wrong, no amount of careful bookkeeping fixes the reports.

Why do most charts of accounts produce useless reports?

Because nobody designed them. QuickBooks Online and Xero hand you a default list built to fit everyone, so it fits nobody especially well. Then accounts get added whenever a transaction didn't seem to fit: "Software 2", "Misc expense", "Contractor - Dave". Three years later you have 140 accounts, a dozen doing the same job, and a P&L nobody reads past the first page.

The symptoms are familiar. All revenue sits in one "Sales" account. Contractors who deliver client work sit next to the office cleaner, so there's no real gross margin. "Miscellaneous" is one of your five biggest expense lines. Every transaction is recorded; the structure just can't tell you anything.

What should drive the design?

The questions you ask every month. Before you add or delete anything, write them down. For most owners it's something like:

  1. How much did we earn from each way we sell?
  2. What did it cost to deliver that work, and what's left?
  3. What does it cost to keep the lights on?
  4. How much do customers owe us, and how much do we owe?
  5. What will my CPA need at tax time?

Questions 1 and 2 decide your income and direct cost accounts, 3 your expense accounts, 4 the balance sheet, and 5 checks all of it. An account that answers none of them probably doesn't need to exist.

What does a well-built chart of accounts look like?

Every chart has the same building blocks: assets, liabilities, equity, income and expenses. What separates a useful one is how you divide income and expenses, and whether direct costs are kept apart from overhead.

QuickBooks Online lets you turn on account numbers (Settings, then Account and settings, then the Advanced tab, then Edit in the Chart of accounts section, and turn on "Enable account numbers"). Intuit suggests a GAAP-style layout, which is a sensible default:

Number rangeSectionExamples
10000 to 19999AssetsOperating bank account, accounts receivable, prepaid expenses, equipment
20000 to 29999LiabilitiesCredit cards, accounts payable, payroll liabilities, sales tax payable, loans
30000 to 39999EquityOwner contributions, draws or distributions, retained earnings
40000 to 49999IncomeOne account per way you sell: retainers, projects, products, rebilled costs
50000 to 59999Cost of goods sold or job costsDirect labor, contractors on client work, materials
60000 to 69999Operating expensesRent, software, marketing, admin salaries, insurance
70000 to 89999Other income and other expensesInterest earned, interest paid, gains or losses on selling equipment

Leave gaps between numbers (40100, 40200, 40300) so you can add accounts later without renumbering.

How should you split income and direct costs?

This is where most of the value is.

Income: one account per revenue stream that behaves differently. Recurring retainers and one-off projects behave differently. Money you collect and pass straight through (rebilled ad spend, shipping charged to customers) behaves very differently and should never be mixed with your real fees. Three to six income accounts is plenty for most small businesses.

Direct costs: anything you spend because you delivered the work goes above the gross profit line, in cost of goods sold. Contractors on client work, materials, the people who do billable work, platform fees on each sale. Office rent doesn't change when you take on one more client, so it stays below the line.

That split is what makes gross margin a real number. Without it, you can't tell a pricing problem from an overhead problem. Our guide on how to read a profit and loss statement shows how the sections fit together on the finished report.

A worked example: the agency that thought every job paid the same

Say you run a 14-person digital marketing agency with $1,800,000 of revenue last year. Your chart has one income account called "Sales", and pay, contractors and media costs sit in one long list of expenses.

You redesign the chart with three income accounts (Retainers, Projects, Rebilled ad spend), move the costs of delivering client work into cost of goods sold, and turn on classes so each direct cost is tagged to the service line it served. After reclassifying the year:

Service lineRevenueDirect costsGross profitGross margin
Retainers$1,080,000$540,000$540,00050%
Projects$540,000$378,000$162,00030%
Rebilled ad spend$180,000$171,000$9,0005%
Total$1,800,000$1,089,000$711,00039.5%

Revenue and gross profit by service line

Same agency, same year, after the chart of accounts was redesigned

  • Revenue
  • Gross profit
$0$500k$1M$1.5MRetainers · Revenue: $1,080,000Retainers · Gross profit: $540,000Projects · Revenue: $540,000Projects · Gross profit: $162,000Rebilled ad spend · Revenue: $180,000Rebilled ad spend · Gross profit: $9,000RetainersProjectsRebilled ad spend

Hypothetical example. Total gross profit: 540,000 + 162,000 + 9,000 = 711,000 on 1,800,000 of revenue (39.5%).

Show the numbers
 RevenueGross profit
Retainers$1,080,000$540,000
Projects$540,000$162,000
Rebilled ad spend$180,000$9,000

The blended 39.5% looked fine. Underneath it, projects earn 30% while retainers earn 50%, and $180,000 of rebilled ad spend was inflating revenue while adding only $9,000 of profit. That's three decisions in plain sight (reprice projects, push clients toward retainers, stop counting pass-through money as growth) that the old chart hid.

Accounts or classes: which should you use?

A simple rule: accounts describe what the money is. Classes describe where it belongs.

"Software" is an account. Which department uses it is a class. If you create an account for every combination ("Rent - Store A", "Rent - Store B"), your chart doubles each time you open a location.

In QuickBooks Online, class tracking is available on the Plus and Advanced plans: Settings, then Account and settings, then Advanced, then Categories, and switch on "Track classes". Xero offers tracking categories for the same purpose. Then you can run the P&L by class without touching the chart.

Accounts vs classes

What it is

Use an account when

  • It's a different kind of cost or income (software vs travel)
  • Your CPA needs it as a separate tax line
  • It's a balance you reconcile (a bank, a card, a loan)

Where it belongs

Use a class when

  • You want the same cost split by department, service line or site
  • The split changes as the business changes
  • You'd otherwise create one account per department

How do tax returns fit into the design?

Your CPA maps every expense account to a line on your return. Keep your accounts close to those lines and the mapping is quick and hard to get wrong.

For a sole proprietor or single-member LLC filing Schedule C, Part II lists the categories the IRS wants: contract labor, insurance, legal and professional services, office expense, rent or lease, repairs, supplies, taxes and licenses, travel, meals, utilities, wages and so on. Anything else goes in Part V, where the instructions say to list the type and amount of each expense separately. A $30,000 "Miscellaneous" account turns into a phone call with your CPA.

Two splits are worth making from day one: meals separate from travel (business meals are generally only partly deductible), and equipment on the balance sheet rather than buried in "Office supplies", so your CPA can apply the depreciation rules. Corporations and partnerships use different forms; ask your CPA which lines they map to.

How many accounts should you have?

Our honest view: most small businesses land between 30 and 60 active accounts. A new service business can start nearer 25; one with inventory, several bank accounts and loans will need more. Past about 80, accounts are usually doing a class's job.

Fewer isn't automatically better, though: aim for a P&L that fits on one page and still shows the numbers you care about. Starting from scratch? Our free chart of accounts generator builds a starting list for your type of business.

How do you redesign a chart you already use?

Carefully, and ideally at the start of a fiscal year so the before and after don't share a year.

Chart of accounts redesign

1. Plan on paper

  • Draft the new chart in a spreadsheet, with a one-line rule for each account
  • Map every old account to its new home
  • Show the draft to your CPA

2. Make the changes

  • Rename and renumber the accounts you're keeping, and add new ones
  • Repoint bank rules, products and services, and recurring transactions
  • Reclassify the current year if you want clean comparisons

3. Retire old accounts

  • Bring each old balance sheet account to zero first
  • Make unused accounts inactive (QuickBooks Online doesn't let you delete them)
  • Check that totals didn't change, only where amounts sit

One QuickBooks Online trap: when you make an account inactive, its transactions stay put, but if a balance sheet account still has a balance, QuickBooks posts an automatic adjustment that lands in Opening Balance Equity. That's how a tidy-up creates a new mess. QuickBooks also won't make an account inactive while it has subaccounts, is linked to products or services, or is used by a recurring transaction. If your file has bigger problems than the chart, see our guide to resetting a messy QuickBooks Online file.

Common mistakes

Keeping the default chart forever. It was a starting point. Half the accounts are unused and the other half don't match how you sell.

An account for every vendor. "Contractor - Dave" and "Contractor - Priya" belong in one Contractors account; the vendor name is already on every transaction.

Mixing pass-through money with real income. Rebilled expenses and sales tax you collect aren't your revenue. Lumping them in makes growth look better and margins worse.

Redesigning mid-year without reclassifying. Six months in old accounts and six in new ones gives you a year where nothing compares. Reclassify the earlier months or wait for the new year.

No written rules. Two people categorizing the same bill two ways is how a good chart decays. A one-page posting guide fixes most of it.

When to get help

For a simple service business setting up books for the first time, a starting template and an hour of thought will get you most of the way.

Get help when you're redesigning a chart with years of history behind it, when the business has inventory, several entities or locations, or when a lender, investor or buyer is about to look at your numbers. At Fintrix Consulting your books stay in your own QuickBooks Online or Xero file, and a reviewed close tells you quickly whether the structure is working. You can see how our bookkeeping works or talk it through with us.

Frequently asked questions

What is a chart of accounts?

It's the list of every account your business records transactions in: bank accounts, credit cards, loans, equity, income and expenses. Your financial statements are built directly from it. See our glossary entry.

Can I change my chart of accounts in the middle of the year?

You can, but plan it. Renaming an account changes it for past periods too. Moving costs to a new account only affects new transactions unless you also reclassify earlier months. Talk to your CPA first if the change straddles a tax year.

Is cost of goods sold only for businesses that sell products?

No. Service businesses have direct costs too: the contractors and staff who deliver client work, subcontracted jobs, software used per client. Putting them above gross profit tells you what each dollar of revenue really costs to deliver.

The bottom line

A chart of accounts decides which questions your books can answer. Build it from the questions you ask every month, split income the way you sell, keep direct costs above gross profit, and let classes handle departments and locations. Write the rules down, and your reports stay useful long after the person who set them up has moved on.

This article is general information, not advice for your situation. Rules change and details matter, so talk to us or your CPA before acting on it.

Have a question about this article?

Ask us. A real person will reply by email within one business day. Your question isn’t published.

Protected by reCAPTCHA. Google’s Privacy Policy and Terms apply.

Ready for books you can trust?

Book a free 30-minute consultation. We'll review where your finances stand today and show you exactly how we'd help.