Skip to content
The title slide and first slides of the Cash on Hand Tracker template

Cash on Hand Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

Cash leaves no trail, so the only record is the one you write. This cash on hand tracker gives each entry a row with a date, what it was, a category, and either money in or money out. A running balance appears on every row, so the envelope total is always one glance away. The Balance tab adds up cash on hand, total in, total out and the largest single spend, then charts cash in against cash out for every category.

The sample log covers about six weeks for a household that uses cash for groceries, fuel and small jobs. Start yours with the amount you hold today as a Starting cash row, so the balance matches the envelope. Count the cash once a week and compare it with the sheet; a gap means an entry is missing. Rows are added at the bottom as the log grows.

Useful for

  • Keep an envelope budget honest
  • Track tips, side-job cash and market sales
  • See which categories take the most cash

What's included

  • 3 tabs: Cash Log, Balance, How to use
  • Cash Log: a table
  • Balance: a dashboard with 4 summary figures
  • 1 chart 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 Cash Log 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

How do I keep a running balance for cash?

Log every amount in or out on its own row. The balance on each row is the sum of everything in up to that row, minus everything out. This sheet calculates it for you as you type.

How often should I count my cash against the tracker?

Once a week works for most households. If the count and the sheet disagree, look for a purchase you did not write down.

Does this work for envelope budgeting?

Yes. Start the log with the amount you put in the envelope, record each spend by category and watch the balance fall. Keep a separate workbook for each envelope if you run several.

  • #tracker
  • #cash-on-hand-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More tracker templates

See all 33

Also in Finance

All finance templates
Get this template

Preparing your template…