Google Sheets Chart of Accounts Template and Setup

A Google Sheets chart of accounts template is a structured list of the accounts a business uses to classify its financial activity. Create a sheet with account numbers, names, types, descriptions, and active status; then use the same account numbers consistently in transaction records so totals can be summarized and checked.

What a chart of accounts does

A chart of accounts, often shortened to COA, is the organized index behind a business’s bookkeeping. Each account represents a category for recording money activity, such as checking, accounts payable, sales revenue, or office supplies. The chart itself is not a transaction log: it identifies the categories, while separate records show dates, amounts, and the accounts affected by each transaction.

Accounts are usually grouped into five broad categories: assets, liabilities, equity, revenue, and expenses. These categories help organize information for financial statements. For example, a bank account is an asset; a credit card balance is a liability; owner contributions are equity; product sales are revenue; and rent is an expense. A business may need additional detail within any category, but a longer chart is not automatically a better one.

There is no single account list that suits every organization. A small consulting business may need only a few income and expense accounts, while a retailer may need separate accounts for product sales, shipping income, inventory-related costs, and payment fees. Requirements can also depend on the accounting method, reporting needs, and the advice of a bookkeeper or accountant.

Copyable template columns

Start with one row per account and these practical columns. You can paste the headings into the first row of a blank Google Sheet, then enter your accounts beneath them.

Account number: A unique code used to identify the account, such as 1000 or 4100.
Account name: A clear label, such as Checking Account or Consulting Revenue.
Account type: Asset, liability, equity, revenue, or expense.
Detail category: A more specific grouping if useful, such as cash, current liability, or operating expense.
Description: A short note explaining what belongs in the account and what does not.
Normal balance: Debit or credit, if your bookkeeping process uses this information.
Parent account: The broader account or group, when you want a hierarchy.
Status: Active or inactive, so old accounts can be retained without remaining available for routine use.
Opening balance and effective date: Optional fields for a controlled conversion from another bookkeeping system.

Keep the chart readable by separating account identity from operational notes. For example, place an account’s stable name in the account-name column and explain a special coding rule in its description. Avoid using the description field as a substitute for an account number or changing an account name to record each month’s activity.

Choose account numbers and names

Numbering makes accounts easier to sort and leaves room for future additions. One common approach is to reserve number ranges by major category, such as 1000–1999 for assets, 2000–2999 for liabilities, 3000–3999 for equity, 4000–4999 for revenue, and 5000–8999 for expenses. This is an illustration, not a universal standard. A business can use another scheme, provided it is consistent and clearly documented.

Leave gaps between account numbers when practical. If expenses are numbered 5100, 5200, and 5300, a later account can fit between them without renumbering the entire list. Once account numbers are in use, changing them can complicate comparisons and links to historical records, so plan the structure before importing transactions.

Use names that are specific enough to guide data entry. Office Supplies is more useful than Miscellaneous, and Web Hosting is more informative than Other Expense if the business regularly pays for hosting. At the same time, avoid creating a separate account for every vendor or every small purchase. Vendor details generally belong in transaction records; accounts should represent meaningful categories for reporting.

Build the template in Google Sheets

Open Google Sheets in a web browser and create a blank spreadsheet. Rename the file with a clear label, such as Chart of Accounts, and include the business name if more than one person will use it.
Enter the chosen column headings in row 1. Add a second tab for setup notes, if useful, to explain the numbering scheme, account-type definitions, and who may approve changes.
Enter one account per row. Use a consistent format for account numbers and names, and check that each code is unique. Do not put subtotals or explanatory paragraphs among the account rows if you plan to sort or filter the list.
Make the headings easier to use by selecting View > Freeze > 1 row. To filter the table, select its header and data range, then choose Data > Create a filter. Filters let a user view, for example, only expense accounts without deleting or rearranging the underlying information.
For account-type choices, select the relevant cells and use Data > Data validation to add a dropdown list. Enter the permitted types consistently. A dropdown can reduce spelling variations, but it does not confirm that an account has been classified correctly.
Format the number column consistently and review the finished list for duplicate codes, blank names, and unclear descriptions. Use File > Make a copy to create a separate starting file for another business or a clean version for the next accounting period.

Google Sheets saves changes online as you work, but access still needs attention. Share the file only with people who need it, choose viewer, commenter, or editor access deliberately, and avoid putting sensitive bank details or customer information in a chart that does not need them.

Use the chart with transaction records

A chart of accounts becomes useful when transaction records refer to its account numbers. Keep transactions on a separate tab with fields such as date, reference, account number, description, debit, and credit. For more complex bookkeeping, a transaction can have multiple lines, but the debits and credits for the complete entry must balance under the accounting method being used. A chart alone does not enforce balanced entries or replace bookkeeping software.

A simple summary can total transaction debits and credits by account. Suppose a Transactions tab has account numbers in column B, debit amounts in column C, and credit amounts in column D. On a Trial Balance tab, put an account number in A2. With the transaction layout just described, the account code in Trial Balance!A2, and debit amounts in Transactions!C:C, enter this in the debit-total cell:

=SUMIF(Transactions!$B:$B,A2,Transactions!$C:$C)

If account 1000 appears on a transaction row with a debit of 500 and no other debit rows use that code, the formula returns 500. With the same account-number range and account code in Trial Balance!A2, but credit amounts in Transactions!D:D, use this for the credit total:

=SUMIF(Transactions!$B:$B,A2,Transactions!$D:$D)

If no transaction row for account 1000 has a credit, this formula returns 0. These are basic summaries, not a complete accounting system. They do not check every transaction for missing codes, establish opening balances, or determine whether a debit or credit is appropriate. Google Sheets also supports filtering and pivot tables for exploring data, but the report design should match the bookkeeping records behind it.

A small example and how to adapt it

Consider a freelance designer who wants a compact starting structure. The chart might include 1000 Checking Account as an asset, 2000 Credit Card Payable as a liability, 3000 Owner Contributions as equity, 4000 Design Services Revenue as revenue, 5100 Software Expense as an expense, and 5200 Contract Labor as an expense. The owner can add accounts later if separate reporting for subscriptions or payment processing becomes useful.

The key is to apply the chart consistently. If a software subscription is sometimes coded to Software Expense and sometimes to Office Expense, the resulting reports will be less useful even if both accounts are valid. Write a short rule in the description, such as recurring design and productivity software goes to Software Expense, and make sure anyone entering transactions can find that guidance.

Do not treat this sample as a ready-made classification for every business. A company that sells physical products may need inventory and cost-of-goods-sold accounts; a nonprofit or a business with multiple locations may need other reporting dimensions. Ask a qualified accounting professional about setup choices that affect financial statements, tax reporting, or conversion from existing books.

Keep the chart accurate and manageable

Review the chart when the business changes, rather than adding accounts impulsively after every unusual purchase. Before adding one, ask whether the information will support a recurring decision or a required report, whether an existing account already covers it, and whether the description can remove ambiguity. Too few accounts can hide meaningful differences; too many can make coding slow and inconsistent.

Use an inactive status for accounts that should no longer receive new transactions, instead of deleting accounts with historical activity. Deleting or renumbering an account may break a connection to past records or make old reports harder to interpret. Keep a dated note of significant changes, including the reason and effective date, especially if the sheet is used by multiple people.

Periodically check for duplicate account numbers, misspelled types, transactions using codes absent from the chart, and inactive accounts receiving new entries. Google Sheets dropdowns and filters can help with these checks, but someone still needs to review exceptions. Protecting the heading row or limiting edit access may reduce accidental changes; access controls do not guarantee that the chart is correct or constitute a formal audit trail.

When Sheets is enough and when to use another tool

Google Sheets can be a practical low-cost starting point for a simple chart that one person maintains or a small team reviews. It is flexible, easy to share, and can be adapted without learning a specialized accounting interface. However, the chart is only one part of accounting. A spreadsheet may require manual work for transaction entry, reconciliations, permissions, audit history, financial statements, and backups.

Dedicated accounting software may be a better fit when several people enter transactions, the business needs bank feeds or invoicing, reporting must be repeatable, or there is a need for stronger controls and an integrated ledger. A template in Microsoft Excel can also store a similar list, but menu names, sharing behavior, and collaboration features differ. If the goal is bookkeeping rather than simply maintaining an account index, compare the complete workflow and export options before choosing a spreadsheet as the main system.

Frequently Asked Questions

Does Google Sheets have a chart of accounts template?
Google Sheets can store a chart of accounts, but a blank spreadsheet is enough to build one using the columns above. Templates available to an individual user can vary, so check the template options shown in your account rather than assuming a particular accounting template is included.

What accounts should a small business include?
Most charts organize accounts under assets, liabilities, equity, revenue, and expenses. The detail depends on the business: a service provider may need service revenue and operating expenses, while a retailer may also need inventory-related accounts. Choose categories that support the records and reports the business actually uses.

How many accounts should a chart of accounts have?
There is no ideal fixed number. Include enough accounts to classify activity clearly and produce useful reports, but avoid splitting categories unless the distinction matters. A small business can begin with a short list and add accounts when a recurring reporting need justifies them.

Should I delete an account I no longer use?
Usually, mark it inactive rather than deleting it if it has historical transactions. Retaining the account helps preserve the meaning of past records. Check with the person responsible for the books before changing accounts linked to an existing accounting system.

Can a Google Sheets chart of accounts replace accounting software?
Not by itself. The chart is a list of categories, not a complete ledger, reconciliation process, or financial reporting control system. A spreadsheet may suit a simple workflow, but consider dedicated software or professional guidance as transaction volume and control needs grow.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.