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

SpreadsheetBookkeepingFree

Cash Book

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

Shown with sample data

Colour

Cash Book

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

Cash in hand
$513.75
Bank balance
$3,954
Receipts (excl. contra)
$3,439
Payments (excl. contra)
$7,642
Cash count difference
$0
Counted minus book; should be zero
Bank balance through the period
Nov 2, 2026Nov 15, 2026

Latest: $3,953.55

Payments by category
  • Wages$2,860
  • Contra (cash to bank)$2,500
  • Rent$2,400
  • Supplier payments$1,185.40
  • Owner drawings$800
  • Utilities$312.80
  • Bank charges$48.60
  • Other$35

How to use it

  1. 1On Settings, enter the opening cash in hand and bank balance for the period and the cash you count at the end.
  2. 2Record each receipt or payment in date order in the Cash or Bank columns with a reference and analysis category.
  3. 3Record a cash banking as Cash out and Bank in with the category Contra (cash to bank), so both balances stay right.
  4. 4Check the running balances against your bank statement and the till count.
  5. 5Use the Analysis sheet totals to post receipts and payments to the general ledger.

In this workbook

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

About this template

The cash book is the record of every receipt and payment through the till and the bank. Each line goes in the cash or bank column, with contra entries for money moved between them; the book keeps running balances for both, analyses receipts and payments by category for posting to the ledger, and checks the cash balance against your physical count.

Who it’s for

  • Shops, cafés and market traders that take cash
  • Clubs, charities and associations
  • Learning the two-column cash book

What’s included

  • Cash book sheet: Every receipt and payment through cash and bank, in date order.
  • Analysis sheet: Receipts and payments by category for posting to the ledger.
  • Settings sheet: Opening balances and the closing cash count.

How to use it

  1. 1On Settings, enter the opening cash in hand and bank balance for the period and the cash you count at the end.
  2. 2Record each receipt or payment in date order in the Cash or Bank columns with a reference and analysis category.
  3. 3Record a cash banking as Cash out and Bank in with the category Contra (cash to bank), so both balances stay right.
  4. 4Check the running balances against your bank statement and the till count.
  5. 5Use the Analysis sheet totals to post receipts and payments to the general ledger.

Tips

  • A cash balance can never go below zero. If it does, a receipt is missing or a payment has gone in the wrong column.
  • Bank cash takings intact and pay expenses from the bank or petty cash. It makes the cash book far easier to check.
  • Reconcile the bank column to the statement every month.

Questions

What is a two-column cash book?

A cash book with separate columns for cash and bank, each with receipts and payments. Some versions add a discount column (three-column cash book); here discounts can be recorded as their own category.

What is a contra entry?

A transfer between cash and bank, such as banking the day’s takings. It is recorded on both sides (cash out, bank in), so it does not change total funds.

Is the cash book part of the double-entry system?

Yes. In many systems the cash book is both a book of prime entry and the ledger account for cash and bank. The category totals are posted to the other side in the general ledger.

Related searchescash bookcash book templatetwo column cash bookcash receipts and payments journalcash book excelbookkeeping cash book

Details

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

Download a copy

Downloads need a free account.

SpreadsheetBookkeepingFree

Cash Book

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

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
3
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
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

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