Skip to content
The title slide and first slides of the Chart of Accounts Template template

Chart of Accounts Template

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
6
Difficulty
Beginner
Updated
November 16, 2026

Every slide (6)

Overview

A new small business needs a list of accounts before the first sale is recorded. This chart of accounts holds 24 sample accounts across assets, liabilities, equity, income and expenses, each with a code, a group and an active or inactive flag. The normal side, debit or credit, fills in from the type you choose, and the opening balance column takes the figure from your bank or last year's books.

The Types tab counts accounts and adds opening balances for each of the five types. The Balances tab compares the debit side with the credit side and charts the result, so a mistake in an opening figure shows as a difference before you record anything. Rename the sample accounts, keep the code ranges that suit you and mark unused ones inactive.

Useful for

  • Set up books for a new LLC or sole proprietorship
  • Give your bookkeeper a tidy, numbered list of accounts
  • Check that opening balances balance before moving from another tool

What's included

  • 4 tabs: Accounts, Types, Balances, How to use
  • Accounts: a table
  • Types: a table
  • Balances: a dashboard with 4 summary figures
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Accounts tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What is a chart of accounts?

It is the numbered list of every account a business uses to sort money: what it owns, owes and earns, and what it spends. Each transaction is posted to accounts from this list.

How many accounts does a small business need?

Most small businesses start with 20 to 40. The sample here has 24. Add an account only when you want to see that figure on its own in a report.

Why do opening balances need to balance?

Debits must equal credits in double entry bookkeeping. The Balances tab shows the difference between the two sides, and it should read zero.

  • #bookkeeping
  • #chart-of-accounts-template
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More bookkeeping templates

See all 6

Also in Finance

All finance templates
Get this template

Preparing your template…