A chart of accounts for a small business is the fixed list of names every transaction is filed under: a few for what the business owns and owes, plus short income and expense lists. Most sole owners need fifteen to twenty. Match the expense accounts to your tax form's lines and every bank statement row has an obvious home.
What is a chart of accounts for a small business?
A chart of accounts is the master list of accounts a business records its money in, each with a name, a type and often a number. For a small business, it is the list you choose from every time you categorize a bank statement row. Without it, the same cost gets three different names and no total is reliable.
In accounting software, the chart comes pre-filled, often with dozens of accounts. In a spreadsheet, it is a tab you write yourself. Either way, the chart does the same job: it decides what your reports can tell you. A profit and loss report is only the expense and income accounts, totalled. A tax return is those same totals, copied onto the right lines.
That is why short beats complete. Each account should earn its place by answering a question you will actually ask, such as "what did I spend on software this year?" An account that holds two rows a year answers nothing a broader account could not.
The five account types in a small business chart
Every account in a small business chart belongs to one of five types: assets, liabilities, equity, income and expenses. The first three describe what the business has at a moment in time. The last two describe what happened over a period. A spreadsheet-based business mostly uses the last two, with a few of the first three.
- Assets are things the business owns: the bank account, money clients owe you, equipment.
- Liabilities are what the business owes: a credit card balance, a loan, sales tax collected but not yet paid.
- Equity is the owner's stake: money you put in, money you take out, and profit kept over time.
- Income is money earned from the work: sales, fees, interest.
- Expenses are the costs of earning it: rent, software, supplies, travel.
Numbering by type keeps the list in order. A common pattern gives assets numbers in the 1000s, liabilities 2000s, equity 3000s, income 4000s and expenses 5000s and up. You do not need numbers in a spreadsheet, but they make the list sort the same way every time.
A short chart of accounts matched to Schedule C lines
A short chart of accounts for a US sole proprietor can borrow its expense names from Schedule C, the form that reports business profit. The IRS instructions for Schedule C list the expense lines, from advertising and car expenses through supplies, utilities and wages. One account per line you use keeps tax time to copying totals.
Here is an example chart for a small service business. Use it as a starting point and remove the lines you will never touch.
| No. | Account | Type | Feeds Schedule C line |
|---|---|---|---|
| 1000 | Business checking | Asset | (balance only) |
| 2000 | Business credit card | Liability | (balance only) |
| 2100 | Sales tax payable | Liability | (not on Schedule C) |
| 3000 | Owner contributions | Equity | (not on Schedule C) |
| 3100 | Owner draws | Equity | (not on Schedule C) |
| 4000 | Sales | Income | Line 1, gross receipts |
| 4100 | Interest income | Income | Ask your preparer which line |
| 5000 | Advertising | Expense | Line 8 |
| 5100 | Car and truck | Expense | Line 9 |
| 5200 | Contract labor | Expense | Line 11 |
| 5300 | Insurance | Expense | Line 15 |
| 5400 | Legal and professional | Expense | Line 17 |
| 5500 | Office expense | Expense | Line 18 |
| 5600 | Rent | Expense | Line 20b, other property |
| 5700 | Supplies | Expense | Line 22 |
| 5800 | Travel and meals | Expense | Lines 24a and 24b |
| 5900 | Utilities and phone | Expense | Line 25 |
| 6000 | Bank fees and other | Expense | Line 27b, other expenses |
| 9000 | Transfers between own accounts | Equity (clearing) | (excluded) |
Nineteen accounts, and some businesses need fewer. The Transfers account at the bottom is a clearing account: it holds card payments and moves between your own accounts, and its rows should net to about zero.
Notice that Owner draws is equity, not an expense. The Schedule C instructions say not to include amounts paid to yourself on the wages line. How to pay yourself from your business covers how those transfers look on your statement and how to record them.
Mapping bank statement rows to chart of accounts names
Mapping bank statement rows to chart of accounts names means reading each row's description and choosing the one account it belongs to. Most rows map by payee: the same software company is always software, the same landlord is always rent. A short lookup table of payees and accounts handles those automatically.
Here is an example of how a month's rows map. The rows are invented.
| Statement description (example) | Amount | Account |
|---|---|---|
| STRIPE PAYOUT | 2,310.00 | 4000 Sales |
| GOOGLE ADS | −180.00 | 5000 Advertising |
| SHELL OIL 4471 | −62.30 | 5100 Car and truck |
| UPWORK ESCROW | −450.00 | 5200 Contract labor |
| ZOOM.US | −15.99 | 5500 Office expense |
| CHASE CARD PAYMENT | −640.00 | 9000 Transfers |
| TRANSFER TO SAVINGS PERSONAL | −1,500.00 | 3100 Owner draws |
| VERIZON WIRELESS | −72.00 | 5900 Utilities and phone |
In a spreadsheet, put the payee list on its own tab: one column for a word that appears in the description, one for the account. A lookup formula then fills the account for every row whose description contains a known word, and you handle the rest by hand. After two or three months, the list covers most rows.
Getting the rows into the sheet in the first place is the slow step if you type them. What typing bank statements into Excel really costs puts a number on that. CheapBankConvert, which has not opened yet, is meant to replace the typing with a CSV or Excel file per statement at a one-time price; its homepage lists the early pricing.
Rows that fit two accounts
Some rows could go either way. A phone used for business and personal calls is partly a business expense. A meal with a client is travel and meals, but a lunch alone at your desk is not. Choose by the rule that matches your tax treatment, write the rule down, and apply it the same way every month.
Which accounts can a sole owner leave off the chart?
A sole owner can leave off any account for something the business does not have: inventory, payroll, depreciation schedules, loans and accounts receivable all belong to businesses that hold stock, employ people, own large equipment, borrow or invoice on credit. If none applies, the chart can skip them entirely.
Leaving accounts off also means resisting splits. "Software" does not need separate accounts for design tools, email and storage. "Travel" does not need one account per trip. If you want detail for your own curiosity, use the Notes or Description column, and keep the account itself broad.
One account is worth keeping even when it looks empty: Owner contributions. The month you lend the business your own money to cover a slow patch, it will need a home that is not Sales. Recording that deposit as income would raise your taxable profit for money you already owned.
Chart of accounts sprawl: too many accounts and drifting names
Chart of accounts sprawl happens when accounts are added on the spot while categorizing, until the list holds near-duplicates such as "Supplies", "Office supplies" and "Supplies - office". Totals then split across them, and no single account shows what you really spent. A long chart costs time every month and accuracy at year end.
Name drift is the quieter version. "Phone" becomes "Phone and internet" in May, and the old rows stay under the old name. A report that filters on the new name now misses five months.
Three habits stop both problems:
- Add accounts only on the chart tab, never by typing a new name in a transaction row. A drop-down list from the chart enforces this in a spreadsheet.
- When you rename an account, rename it everywhere at once with find and replace.
- Once a year, look for accounts with fewer than five rows and merge them into a broader one.
Owners who skip these habits for a year often pay someone to untangle the result. What bookkeeping cleanup costs shows the bill that a sprawling chart tends to produce.
Adding an account to the chart without breaking past totals
Add an account to the chart when one expense has grown large enough that you want to watch it on its own, or when a new kind of activity starts, such as hiring a contractor or collecting sales tax. Add it at the start of a month or year, so every period sits cleanly under one set of accounts.
If the new account splits an existing one, decide what happens to past rows. Either move the old rows into the new account so the year is consistent, or leave them and note the date of the split on the chart tab. Mixing the two leaves a year whose totals compare apples with pears.
Give the new account a number in the right range for its type, so it sorts beside its neighbours. Then add any obvious payees for it to your lookup list, so next month's rows find it without help.