How to Build a Chart of Accounts That Actually Tells You Something

How to Build a Chart of Accounts That Actually Tells You Something

If your bookkeeping feels like it is producing reports you cannot use, the chart of accounts is usually the reason.

The chart of accounts is the list of every category the business uses to classify money movement — every revenue stream, every expense type, every asset and liability. When the bookkeeper records a transaction, they pick an account from this list. Every financial report you will ever see is built from that list.

Most small businesses inherit a default chart of accounts from QuickBooks or Xero, then let it grow messy for years. The result is a P&L with 74 expense categories where nothing rolls up cleanly, or a revenue section that lumps together five different service lines into a single "Sales" bucket. Either way, the reports cannot answer basic management questions.

A well-built chart of accounts is a quiet advantage. Here is how to build one.

What a chart of accounts is supposed to do

A chart of accounts has one job: make it easy to answer the questions you ask about your business.

If you want to know which service line is most profitable, your revenue accounts need to separate them. If you want to know whether your marketing spend is working, your marketing expenses need to distinguish paid media from software from agency fees. If you want to understand gross margin by channel, your COGS needs to break out by channel.

The chart of accounts is the filter through which reality flows into reports. Build it around the decisions you actually want to make.

The five major account types

Every chart of accounts is organized around five types:

**Assets.** What the business owns. Cash, accounts receivable, inventory, equipment, intellectual property.

**Liabilities.** What the business owes. Accounts payable, credit cards, loans, deferred revenue, accrued expenses.

**Equity.** The owners' stake in the business. Contributed capital, retained earnings, distributions.

**Revenue.** Money earned from delivering products or services.

**Expenses.** Money spent to operate the business, usually split between cost of goods sold (direct costs of delivering the product or service) and operating expenses.

The first three live on the balance sheet. The last two produce the P&L. Both reports matter.

Numbering conventions

Most accounting systems use a numbering scheme that groups account types:

• 1000-1999: Assets

• 2000-2999: Liabilities

• 3000-3999: Equity

• 4000-4999: Revenue

• 5000-5999: Cost of goods sold

• 6000-7999: Operating expenses

• 8000-8999: Other income

• 9000-9999: Other expenses

Within each range, use sub-ranges for related accounts. For example, 1000-1099 for cash accounts, 1100-1199 for AR, 1200-1299 for inventory. This makes reports read in a logical order and makes it easy to add new accounts without disrupting the structure.

Principles for building revenue accounts

Revenue is where small businesses most often under-design their chart of accounts. A single "Sales" account is almost never enough.

Think about the dimensions you want to analyze revenue across:

• Service line or product category. If the business sells three distinct things, each should have its own revenue account.

• Channel. Retail, wholesale, DTC, marketplace, and referral should be separable.

• Recurring vs one-time. Subscription revenue and project revenue should be distinct because they behave differently.

• Geography. If taxes or margins vary by region, geography matters.

Avoid the trap of over-splitting, which creates reporting noise. A rough guide: if you would never ask a question that requires separating two revenue streams, keep them combined. If you would, split them.

Classes or tags (in QuickBooks) and tracking categories (in Xero) are the right tool for cross-cutting dimensions like customer or project. Do not create 40 revenue accounts when 4 accounts and a class dimension get you there more cleanly.

Principles for building expense accounts

Expenses deserve the same care. The goal is to make your P&L readable at a glance.

Group operating expenses into functional categories that match how you think about the business:

• Personnel. Wages, contractor payments, benefits, payroll taxes, recruiting.

• Sales and marketing. Paid media, agency fees, software, events, trade spend if separable from COGS.

• Technology. Software subscriptions, hosting, IT services, equipment.

• Occupancy. Rent, utilities, insurance, maintenance.

• Professional services. Legal, accounting, consulting, advisors.

• General and administrative. Office supplies, bank fees, miscellaneous.

Within each category, keep sub-accounts at a useful level of granularity. Under Technology, having "Software Subscriptions" as one line rather than 23 separate software accounts keeps the P&L readable. Use a note or separate tracking if you need vendor-level detail.

Cost of goods sold is different. Here, you want granularity. For a product business, separate raw materials, direct labor, packaging, inbound freight, and 3PL costs. For a service business, separate direct staff costs from subcontractor costs from project-specific expenses. COGS detail is where gross margin analysis lives.

Setting up for channel, class, and location tracking

Most businesses benefit from a single chart of accounts combined with a dimension strategy for the things that cut across accounts.

**Classes or tracking categories.** Use these for business units, channels, or service lines. A transaction can be tagged as "DTC" or "Wholesale" without requiring duplicate expense accounts.

**Locations.** Use for physical locations, warehouses, or operating regions. This is particularly important for multi-location retail, construction companies with regional crews, or service businesses with multiple offices.

**Customers and projects.** Use for project accounting or client-level profitability analysis. A consulting firm that wants to know which clients are profitable should tag every expense entry with the client.

**Tags or custom fields.** Use for ad hoc dimensions that do not warrant a full class structure.

The mistake is trying to make the chart of accounts carry all of these dimensions. A chart of accounts with 400 line items because every channel has its own expense accounts becomes unusable. A chart of accounts with 120 clean line items plus a class dimension for channel gives you everything you need with none of the noise.

Common problems in inherited charts of accounts

When we audit a new client's books, the same problems show up again and again.

**Accounts that duplicate.** Three different software accounts from three different bookkeepers over three years. Clean them up by consolidating and marking the duplicates inactive.

**Accounts that are never used.** Every default QuickBooks chart of accounts comes with 80+ accounts. Most businesses use 40. Deactivate the rest so your reports stay tight.

**Transactions miscoded to the wrong account.** "Professional fees" used for software, "Office supplies" used for marketing expenses. This corrupts every report. Fix historical coding when you can; at minimum, stop the bleeding going forward.

**No COGS separation.** Everything lumped into "Operating Expenses" makes gross margin invisible. Move direct costs into COGS accounts and rebuild at least the trailing 3 months.

**Missing accruals and deferrals.** Prepaid expenses treated as immediate expense, deferred revenue booked as revenue on receipt. These require balance sheet accounts that many charts of accounts are missing.

A simple test

Pull your current P&L. Can you answer these questions by reading it for 30 seconds?

• What was revenue by product line or service line?

• What was gross margin percentage?

• What are the three biggest operating expense categories?

• Is the business profitable month over month?

If any of those answers require a side calculation or a second report, your chart of accounts is not doing its job.

The build-or-rebuild decision

If you are starting a new business, invest a day in building the chart of accounts right. It pays back every month forever.

If you have inherited a mess, you have two options. A full rebuild restructures the chart and recodes historical transactions to match. This is expensive but gives you clean comparable data. An incremental cleanup leaves history alone and builds the new structure going forward, with a note in your reports about the transition point. This is faster but means your year-over-year comparisons have a seam.

Either way, the rebuild is worth doing before you hire your first CFO, before you raise outside capital, or before you try to make data-driven decisions about the business. Numbers built on a bad chart of accounts will mislead you in small ways that compound.

---

*Thryve rebuilds messy chart of accounts for businesses that need their numbers to actually work for them. A Quick Review will tell you whether your chart is earning its keep or quietly costing you clarity.*