Skip to content
Monthly Expense Report cover: a sample sheet with spent this month, biggest expense and food share and a bar chart, beside the Dashboard and Expenses tabs

Monthly Expense Report

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 report is for people who review their spending once a month and want to compare it with the months before. The Expenses tab lists each November purchase with its date, description, category and amount. The Dashboard totals the month, names the largest expense and shows each category's share in a bar chart. The Months tab is a grid of categories against September, October and November, with totals for each row and column.

Replace the sample entries with your own, then type the category totals for each earlier month into the grid. The grid holds figures you enter, so it does not change when the Expenses tab does. Copy each category's Spent figure from the Dashboard into the matching row at month end, and check the category names match the list on the Expenses tab.

Useful for

  • Reviewing one month's spending on the first of the next month
  • Comparing this month with the last two
  • Finding the category that keeps growing

What's included

  • 4 tabs: Dashboard, Expenses, Months, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Expenses: a table
  • Months: a grid
  • 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 Expenses 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 extend the grid beyond the twelve months shown?

Add a column to the right of the last month on the Months tab and type its name in the header. Then enter the category totals for that month. The totals row and column add up automatically, so nothing else needs changing.

Why does the Dashboard total differ from the grid?

The Dashboard only counts the rows on the Expenses tab, which holds the current month. The Months tab keeps the figures you typed for each month, so it can show a different total. Compare the two after you finish a month.

Can I report on expenses for a whole year?

Yes. Make a column for each month, from January to December, and fill it in as each month closes. Use the totals row to see the year in one figure, and the largest category will stand out quickly.

  • #expense-tracker
  • #monthly-expense-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…