Chart of Accounts for Small Business: Sample List + Free Template

A chart of accounts is the list of every bucket your business sorts money into: checking, accounts receivable, loans, sales, materials, rent, payroll taxes and so on. Get it right once and every report you run afterwards (profit and loss, balance sheet, tax return) falls out cleanly. Get it wrong and you spend every year-end reclassifying transactions, or paying your accountant to do it.

This guide gives you a sample chart of accounts for a small business, explains how to number and organize it, and includes a free chart of accounts template plus an online builder. Pick your industry and business type, and the builder creates a numbered chart you can edit and download as Excel, or as CSV files laid out for importing into QuickBooks Online or Xero.

Free, no sign-up. Works in Excel, Google Sheets and LibreOffice. Includes 107 suggested accounts for six industries and four business types, automatic checks for duplicate and out-of-range numbers, and ready-to-import QuickBooks Online and Xero sheets.

Free online chart of accounts builder

Choose your industry and business type, tick whether you run payroll or collect sales tax, and the builder lists the accounts that fit. Untick what you don’t need, rename or renumber anything, and add your own accounts at the bottom. You can also click Load example to see the chart for a small construction company. The result can be printed or saved as a PDF, downloaded as Excel, Word or CSV, or exported as an import file for QuickBooks Online or Xero.

1. Your business

Your data stays in your browser. Nothing is sent to our server unless you choose to save it to your account.

2. Review and edit your accounts

Untick accounts you don’t need, rename or renumber any account, and add your own at the bottom. 1000s assets · 2000s liabilities · 3000s equity · 4000s income · 5000s cost of goods sold · 6000–7000s expenses · 8000s other income · 9000s other expenses.

UseNo.Account nameTypeTax line

Add your own accounts

UseNo.Account nameType

3. Your chart of accounts

Accounts by section

Import notes

Chart of accounts

QuickBooks type and detail type follow the QuickBooks Online US list; Xero type follows Xero’s account types. Tax line = Schedule C (Form 1040) line for sole proprietors. Have your accountant review the list before you import it.

Made with the free chart of accounts builder at bookkeepingsheets.com

What is a chart of accounts?

A chart of accounts (often shortened to COA) is the master list of accounts in your general ledger. Every transaction you record lands in at least one of them. Each account has three things:

  • A number, which keeps the list in order and makes accounts quick to find.
  • A name that anyone in the business understands, like “Job materials” rather than “Misc COGS 2”.
  • A type that decides where the account shows up: on the balance sheet (assets, liabilities, equity) or on the income statement (income, cost of goods sold, expenses).

Accounting software sets up a default chart for you, but the defaults are generic. They rarely match how a contractor, a restaurant or a small hotel actually thinks about its money. They also don’t match what your tax preparer needs. A chart built for your business makes the monthly profit and loss readable and the year-end tax work much faster.

The standard numbering system

Most US small businesses use four-digit numbers grouped by account type. The first digit tells you the section:

RangeSectionShows up onExamples
1000–1999AssetsBalance sheetChecking, accounts receivable, inventory, vehicles
2000–2999LiabilitiesBalance sheetAccounts payable, credit cards, sales tax payable, loans
3000–3999EquityBalance sheetOwner’s capital, draws or distributions, retained earnings
4000–4999IncomeIncome statementService revenue, product sales, discounts given
5000–5999Cost of goods soldIncome statementMaterials, subcontractors, food cost, direct labor
6000–7999Operating expensesIncome statementRent, insurance, software, wages, utilities
8000–8999Other incomeIncome statement (below operating profit)Interest income, gain on sale of equipment
9000–9999Other expensesIncome statement (below operating profit)Depreciation, penalties

Leave gaps of 10 between accounts (6000, 6010, 6020…). When you add “Equipment rental” next year, it slots in between its neighbors instead of landing at the end of the list.

Sample chart of accounts for a small business

Here is the core of the example in the builder: Cedar Lane Builders LLC, a small residential contractor taxed as an S corporation that runs payroll. Its full chart has 66 accounts: 14 assets, 10 liabilities, 4 equity, 3 income, 5 cost of goods sold, 26 operating expenses, 2 other income and 2 other expense accounts. The table shows a selection.

No.Account nameTypeQuickBooks detail typeXero type
1000Checking accountAssetCheckingBank
1100Accounts receivableAssetAccounts Receivable (A/R)System account
1250Retainage receivableAssetRetainageCurrent Asset
1520VehiclesAssetVehiclesFixed Asset
2000Accounts payableLiabilityAccounts Payable (A/P)System account
2300Payroll taxes payableLiabilityPayroll Tax PayableCurrent Liability
2700Loans payableLiabilityNotes PayableNon-current Liability
3000Common stockEquityCommon StockEquity
3100Shareholder distributionsEquityOwner’s EquityEquity
4000Contract revenueIncomeService/Fee IncomeRevenue
5000Job materialsCost of goods soldSupplies & Materials – COGSDirect Costs
5010SubcontractorsCost of goods soldOther Costs of Services – COSDirect Costs
6300InsuranceExpenseInsuranceExpense
6800Wages and salariesExpensePayroll ExpensesExpense
6810Officer compensationExpensePayroll ExpensesExpense
9000Depreciation expenseOther expenseDepreciationDepreciation

Change one setting and the chart changes with it. Switch the same company to a sole proprietorship and the equity section becomes Owner’s capital and Owner’s draws, and the shareholder loan and officer compensation accounts drop out. Pick “Restaurant / food service” and you get food, beverage and alcohol sales and costs, tips payable, gift cards and delivery app commissions instead of retainage and job materials.

What’s inside the Excel template

  • Setup: business name, industry (professional services, construction, retail and e-commerce, restaurant, hotel and lodging, or general), business type (sole proprietor, partnership or multi-member LLC, S corporation, C corporation), and whether you run payroll and collect sales tax.
  • Chart of Accounts: the master list of 107 accounts with number, name, type, QuickBooks type and detail type, Xero type, tax line, description and the industries each account applies to. The Included column turns Yes or No from your Setup answers. A Use? column lets you force any account in or out, and 30 empty rows let you add your own.
  • Check column: flags missing numbers, duplicate numbers, duplicate names and numbers outside the range for the account’s type (for example, an expense numbered 4500).
  • Summary: accounts and issues by section, rows on each import sheet, and a “Ready to import” status.
  • QuickBooks Import and Xero Import: only your included accounts, sorted by number, with the column headings each program expects.

How to use the template

  1. Open the Setup sheet and answer the five questions. Blue text on a yellow background marks the cells you fill in.
  2. Go to Chart of Accounts. Filter the Included column to Yes to see your chart. Rename accounts to words your team uses, and set Use? to No for anything you’ll never touch.
  3. Add accounts you need in the empty rows at the bottom: a separate account for each bank account, credit card and loan, for example. Give each one a number in the right range.
  4. Fix anything the Check column flags, until the Summary sheet says Ready to import.
  5. Copy the QuickBooks Import or Xero Import sheet into a new workbook, delete the empty rows under the list, and save it. Or use the online builder above, which downloads clean CSV files directly.

Importing your chart into QuickBooks Online or Xero

QuickBooks Online. First turn on account numbers (Settings, then Account and settings, Advanced, Chart of accounts). Then go to Settings, Import data, Chart of accounts and upload the file. The columns are Account Number, Account Name, Type, Detail Type. QuickBooks lets you map columns and fix any type it doesn’t recognize before it imports. Retained Earnings is left out of the file because every QuickBooks company already has one. On Simple Start, Essentials and Plus you can have up to 250 active accounts; Advanced has no limit, according to Intuit’s usage limits page.

Xero. Go to Accounting, Chart of accounts, Import. The file uses Xero’s headings (*Code, *Name, *Type, *Tax Code, Description, Dashboard, Expense Claims, Enable Payments). Accounts Receivable, Accounts Payable, Sales Tax and Retained Earnings are system accounts that Xero creates for you, so they’re left out of the file; edit Xero’s versions afterwards to give them your numbers. Bank and credit card accounts come in as type Bank, and Xero asks for their account details after the import. Every account gets the tax rate Tax Exempt, since US sales tax is usually set on invoice lines.

Not sure which program to use yet? Our Excel vs. QuickBooks vs. Xero calculator compares the real cost of each, including your time. If you’re staying in a spreadsheet, the same chart works as the category list in our small business bookkeeping spreadsheet.

How the builder decides which accounts you get

Each of the 107 accounts carries tags: ALL for accounts every business needs, an industry code, a business type code, PAY for payroll accounts, or TAX for sales tax. An account is included when any of its tags matches your answers, unless you override it.

  • Every business gets checking, savings, accounts receivable and payable, a credit card, prepaid expenses, fixed assets and accumulated depreciation, a line of credit and loans, retained earnings, and the core expenses: advertising, bank and merchant fees, insurance, interest, legal and professional fees, office supplies, software, repairs, supplies, taxes and licenses, meals, utilities and phone.
  • Business type sets the equity section. Sole proprietors get owner’s capital and draws; partnerships get one capital account per partner plus distributions and guaranteed payments; S corporations get common stock, paid-in capital, shareholder distributions, a shareholder loan account and officer compensation; C corporations get dividends paid instead of distributions.
  • Payroll adds payroll taxes payable, accrued wages, employee advances, wages, employer payroll taxes, workers’ compensation, benefits and retirement contributions.
  • Sales tax adds a sales tax payable account. Sales tax you collect is a liability you owe the state, never income.

The Tax line column shows the Schedule C (Form 1040) line for each expense, for example line 8 for advertising, line 17 for legal and professional services, line 24b for deductible business meals and line 26 for wages. Line 27b is “other expenses”. Partnerships and corporations file Form 1065, 1120-S or 1120, which use different line numbers, so your tax preparer maps those.

Common mistakes

  • Too many accounts. A 200-line chart for a five-person company means nobody codes transactions the same way twice. Start with 40 to 80 accounts, and use classes, locations, projects or tracking categories for detail such as which job or which store.
  • Too few accounts. One “Expenses” account with everything in it can’t produce a tax return. At minimum, split expenses the way your tax form does.
  • Owner draws as an expense. Money a sole proprietor or partner takes out is equity, not an expense. Only S and C corporations pay owners through payroll (officer compensation).
  • Sales tax as income. Sales tax collected goes to a liability account and leaves when you pay the state.
  • Loans as income. Loan proceeds are a liability. Only the interest you pay is an expense; the principal reduces the loan balance.
  • Renumbering every year. Keep numbers stable so this year’s reports compare with last year’s. Make old accounts inactive rather than reusing their numbers.
  • A “Miscellaneous” account that grows. If anything in Misc. is more than about 1% of expenses, it deserves its own account.

Industry notes

Contractors need retainage receivable and payable, and over- and under-billing accounts if they use percentage of completion. Job costs (materials, subcontractors, direct labor, equipment rental, permits) go above gross profit in cost of goods sold, so you can see job margin. Our job cost tracking spreadsheet and construction draw schedule template use the same structure.

Restaurants split food, beverage and alcohol on both the sales and cost side, so they can compute food and pour cost percentages. They also track tips payable and gift cards outstanding as liabilities. The daily cash report template feeds these accounts every night.

Hotels separate room revenue from other revenue so they can compute ADR and RevPAR (try our RevPAR calculator), and they hold lodging tax collected from guests as a liability.

Retailers and online sellers need inventory, cost of goods sold, shipping charged and paid, and marketplace fees for Amazon, Etsy or Shopify as their own expense lines.

Frequently asked questions

How many accounts should a small business have?

Most small businesses do well with 40 to 80 active accounts. The builder’s starting charts range from about 40 accounts (a sole-proprietor service business with no payroll) to the mid-60s (a contractor taxed as an S corporation with payroll). Add accounts when you need a number on a report, not before.

Do I have to use account numbers?

No. QuickBooks Online and Xero work without numbers in the account list. But numbers keep the chart in a logical order, make reports easier to read, and make it much easier to talk with your accountant about account 6400 instead of “the professional fees one”.

What’s the difference between cost of goods sold and expenses?

Cost of goods sold covers costs that rise and fall directly with each sale or job: products, materials, subcontractors, direct labor. Operating expenses (rent, insurance, software, office wages) stay roughly the same whether you sell more or less. Sales minus cost of goods sold is gross profit.

Can I change my chart of accounts later?

Yes, and most businesses do. Renaming or renumbering an account updates its history. To retire an account, move its balance and make it inactive rather than deleting it. Big changes are easiest at the start of a fiscal year.

Does the template work in Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. The dropdowns, checks and import sheets carry over.

This guide and template are for general information. They aren’t accounting, tax or legal advice, and we’re not affiliated with Intuit or Xero. Account types, import formats and tax forms change; check them in your software and with your tax preparer. Have a qualified accountant review your chart of accounts before you rely on it.