Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceAccounting & BookkeepingBookkeepingChart of Accounts

SpreadsheetBookkeepingFree

Chart of Accounts

A numbered, ready-to-edit account list for a small business with types, statement mapping and active flags.

Shown with sample data

Colour

Chart of Accounts

A numbered, ready-to-edit account list for a small business with types, statement mapping and active flags.

Accounts
18
Active
18
Entries by type
  • Asset5
  • Expense5
  • Liability3
  • Equity2
  • Income2
  • Cost of sales1

How to use it

  1. 1Delete accounts you will not use and rename the rest in your own words.
  2. 2Keep numbers in their block so reports stay in order.
  3. 3Mark old accounts Inactive instead of deleting them once they have history.
  4. 4Export to CSV to import into your software.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

Set up your books on a sound structure. This chart of accounts uses the standard numbering blocks (1000s assets to 6000s expenses) with each account mapped to the balance sheet or the income statement, ready to trim for your business and import into accounting software.

Who it’s for

  • Setting up accounting software
  • Standardising across entities
  • Cleaning up an overgrown account list

What’s included

  • Accounts sheet: Your account list.
  • Summary by Type sheet: The number of entries for each type, calculated from the Accounts sheet.

How to use it

  1. 1Delete accounts you will not use and rename the rest in your own words.
  2. 2Keep numbers in their block so reports stay in order.
  3. 3Mark old accounts Inactive instead of deleting them once they have history.
  4. 4Export to CSV to import into your software.
Related searcheschart of accountsaccount codesbookkeeping setupaccounting structuresmall business accounting

Details

Format
Spreadsheet
Category
Bookkeeping
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetBookkeepingFree

Chart of Accounts

A numbered, ready-to-edit account list for a small business with types, statement mapping and active flags.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Bookkeeping
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More bookkeeping templates

View all
General Ledger2 sheets

Total debits

$19,020

Total credits

$19,020

Out of balance

$0

ABCD
1Entry no.DateAccountDescription
2J-001Nov 1BankOwner investment
3J-001Nov 1Owner equityOwner investment
4J-002Nov 2EquipmentLaptop and printer
5J-002Nov 2BankLaptop and printer
Journal
SpreadsheetBookkeeping

General Ledger

A double-entry journal with account totals, a running check that debits equal credits and balances by account type.

10 min setupPreview
Sales Journal (Sales Day Book)3 sheets

Net sales

$14,177

Sales tax collected

$940

Total receivable raised

$15,117

Gross invoiced by customer
$6,440
$4,522
$1,641
$1,314
$1,200
Juniper & CoHarbor LogisticsCedar HealthBluepeak RetailAtlas Freight
SpreadsheetBookkeeping

Sales Journal (Sales Day Book)

Record every credit sale once, then post the totals: receivables, sales by account and sales tax, with a balance check.

10 min setupPreview
Cash Book3 sheets

Cash in hand

$514

Bank balance

$3,954

Receipts (excl. contra)

$3,439

ABCD
1DateDetailsCategoryCash in
2Nov 2Till takingsCash sales$1,287
3Nov 2Takings bankedContra (cash to bank)$0.00
4Nov 3Shop rent, NovemberRent$0.00
5Nov 4Cedar Café: catering orderCustomer receipts$0.00
Cash book
SpreadsheetBookkeeping

Cash Book

A two-column cash book for cash and bank with running balances, analysis by category and a cash count check.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ