Skip to content
Personal Cash Flow Tracker cover: a sample sheet with money in, money out and net cash flow and a column chart, beside the Dashboard and Money in tabs

Personal Cash Flow Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

This tracker is for individuals and couples who want to watch each month's income and spending side by side. The Money in tab records pay and other income by month and type. The Money out tab records rent, groceries, debt, savings and other payments. The Dashboard shows the totals, net cash flow, a savings rate and a monthly chart.

The sample file covers November 2026 to January 2027, with one freelance payment and a student loan payment. Change the month lists on both data tabs when your months change, and type your real entries over the example ones. Check the net figure for each month before you plan the next one, and move any surplus to savings if you can.

Useful for

  • Seeing whether each month ends with money left over
  • Planning when to save for a large purchase
  • Checking how much income goes to debt

What's included

  • 4 tabs: Dashboard, Money in, Money out, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Money in: a table
  • Money out: a table
  • 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 Money in 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 is the savings rate worked out?

It divides the money paid into the Savings category by the total money in. For example, 300 saved from 4,760 coming in gives a rate of about 6 percent. Log transfers to savings as a Savings payment on the Money out tab.

Why does net cash flow differ from my bank balance?

The sheet only counts what you log. Money that stays in an account, card payments not yet logged, or income you have not entered will change the total. Check the rows against your statements each month.

Can I plan future months?

Yes. Add rows for expected pay and bills with a future month, and they will count in the monthly chart. Mark them clearly in the Source or Paid to text, so you can tell expected figures from actual ones.

  • #expense-tracker
  • #cash-flow-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More expense tracker templates

See all 14

Also in Finance

All finance templates
Get this template

Preparing your template…