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

SpreadsheetBookkeepingFree

General Ledger

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

Shown with sample data

Colour

General Ledger

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

Total debits
$19,020
Total credits
$19,020
Out of balance
$0
Must be zero
Journal lines
12
Total assets
$12,580
Net income
$2,340
Balance by account
  • Owner equity$10,000
  • Bank$9,000
  • Sales$3,780
  • Equipment$1,800
  • Accounts receivable$1,780
  • Rent expense$1,200
  • Accounts payable$240
  • Supplies expense$240

How to use it

  1. 1List your accounts on the Accounts sheet with their type.
  2. 2Post each transaction as two or more lines sharing one entry number.
  3. 3Check the Out of balance figure is zero.
  4. 4Read account balances from the Accounts sheet.

In this workbook

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

About this template

Keep proper books in a spreadsheet. Post each transaction as debit and credit lines against your accounts; the ledger checks that every entry balances, totals each account and rolls the balances up by type, giving you the figures for a trial balance and simple statements.

Who it’s for

  • Very small businesses and clubs
  • Learning double-entry bookkeeping
  • A check on software balances

What’s included

  • Journal sheet: Every debit and credit line.
  • Accounts sheet: Balance of each account.

How to use it

  1. 1List your accounts on the Accounts sheet with their type.
  2. 2Post each transaction as two or more lines sharing one entry number.
  3. 3Check the Out of balance figure is zero.
  4. 4Read account balances from the Accounts sheet.

Questions

Which side increases an account?

Assets and expenses increase with debits; liabilities, equity and income increase with credits.

Related searchesgeneral ledgerjournal entriesdouble entry bookkeepingdebits and creditsbookkeeping template

Details

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

Download a copy

Downloads need a free account.

SpreadsheetBookkeepingFree

General Ledger

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

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
Chart of Accounts2 sheets

Accounts

18

Active

18

ABCD
1NumberAccount nameTypeStatement
21,000Bank: current accountAssetBalance sheet
31,100Accounts receivableAssetBalance sheet
41,200InventoryAssetBalance sheet
51,500EquipmentAssetBalance sheet
Accounts
SpreadsheetBookkeeping

Chart of Accounts

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

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