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.
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:
| Range | Section | Shows up on | Examples |
|---|---|---|---|
| 1000–1999 | Assets | Balance sheet | Checking, accounts receivable, inventory, vehicles |
| 2000–2999 | Liabilities | Balance sheet | Accounts payable, credit cards, sales tax payable, loans |
| 3000–3999 | Equity | Balance sheet | Owner’s capital, draws or distributions, retained earnings |
| 4000–4999 | Income | Income statement | Service revenue, product sales, discounts given |
| 5000–5999 | Cost of goods sold | Income statement | Materials, subcontractors, food cost, direct labor |
| 6000–7999 | Operating expenses | Income statement | Rent, insurance, software, wages, utilities |
| 8000–8999 | Other income | Income statement (below operating profit) | Interest income, gain on sale of equipment |
| 9000–9999 | Other expenses | Income 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 name | Type | QuickBooks detail type | Xero type |
|---|---|---|---|---|
| 1000 | Checking account | Asset | Checking | Bank |
| 1100 | Accounts receivable | Asset | Accounts Receivable (A/R) | System account |
| 1250 | Retainage receivable | Asset | Retainage | Current Asset |
| 1520 | Vehicles | Asset | Vehicles | Fixed Asset |
| 2000 | Accounts payable | Liability | Accounts Payable (A/P) | System account |
| 2300 | Payroll taxes payable | Liability | Payroll Tax Payable | Current Liability |
| 2700 | Loans payable | Liability | Notes Payable | Non-current Liability |
| 3000 | Common stock | Equity | Common Stock | Equity |
| 3100 | Shareholder distributions | Equity | Owner’s Equity | Equity |
| 4000 | Contract revenue | Income | Service/Fee Income | Revenue |
| 5000 | Job materials | Cost of goods sold | Supplies & Materials – COGS | Direct Costs |
| 5010 | Subcontractors | Cost of goods sold | Other Costs of Services – COS | Direct Costs |
| 6300 | Insurance | Expense | Insurance | Expense |
| 6800 | Wages and salaries | Expense | Payroll Expenses | Expense |
| 6810 | Officer compensation | Expense | Payroll Expenses | Expense |
| 9000 | Depreciation expense | Other expense | Depreciation | Depreciation |
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
- Open the Setup sheet and answer the five questions. Blue text on a yellow background marks the cells you fill in.
- 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.
- 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.
- Fix anything the Check column flags, until the Summary sheet says Ready to import.
- 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.
Related calculators and templates
- Sales Tax Calculator: Price Plus Tax & Total With Tax
- Excel vs. QuickBooks vs. Xero: When Should a Small Business Switch?
- How to Do Bookkeeping in Excel
- Small Business Bookkeeping Spreadsheet
- Income and Expense Tracker for Self-Employed
- Job Cost Tracking Spreadsheet
- Monthly Bank Reconciliation Template
- Intercompany Reconciliation Template & Sample (Multiple Entities)
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.