Skip to content
The title slide and first slides of the Fixed and Variable Expenses Tracker template

Fixed and Variable Expenses Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (7)

Overview

Trimming a budget starts with knowing which costs can move. Rent and a loan payment stay the same every month, while groceries and gas rise and fall. This tracker keeps them apart. The Fixed tab lists recurring costs with a yes, maybe or no for whether you could cut them, and the Variable tab logs each purchase with a date and a category.

The Compare tab stacks fixed and variable spending by month in one chart, shows the variable share for each month and the fixed share overall. It also totals the fixed costs marked as cuttable. Sample data runs from January to November for a household with a car payment and a student loan; replace it with your own. Log one calendar year at a time.

Useful for

  • See how much of spending is locked in each month
  • Find subscriptions and plans that could go first
  • Spot months when variable costs spiked

What's included

  • 4 tabs: Compare, Fixed, Variable, How to use
  • Compare: a dashboard with 5 summary figures
  • Fixed: a table
  • Variable: 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 Fixed 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 fixed costs differ from variable ones?

Fixed expenses stay the same each month, such as rent and loan payments. Variable expenses change in size, such as groceries, gas and dining out.

How do I find which expenses I can cut?

Mark each fixed cost Yes, Maybe or No in the Could cut column. The Compare tab totals the Yes rows so you see the saving.

Does the sheet work across two years?

It groups by month name, so keep one calendar year per file. Duplicate the file for each new year.

  • #expense-tracker
  • #fixed-and-variable-expenses-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More expense tracker templates

See all 18

Also in Finance

All finance templates
Get this template

Preparing your template…