Skip to content
Daily Expense Tracker cover: a sample sheet with spent so far, average per day and biggest day and a bar chart, beside the Dashboard, Log and Daily tabs

Daily Expense 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 suits anyone who wants to see spending day by day rather than month by month. Every purchase on the Log tab gets a date, item, category, payment method and amount. The Daily tab adds up every date, counts the entries and shows how far each day sits under its limit. The Dashboard shows total spending, the average per day and a bar chart of categories, with a doughnut chart of payment methods.

The sample file covers the first twelve days of November, so the totals and charts already have figures to show. Set your own daily limit on each row of the Daily tab, then replace the sample purchases. A day turns red when it goes over, which makes it easy to spot a run of takeout dinners or a costly week. Add rows at the bottom of the Log tab and extend the Daily tab for each new date.

Useful for

  • Keeping a daily limit on eating out and treats
  • Spotting which days overspend and why
  • Checking how much cash versus card you spend

What's included

  • 4 tabs: Dashboard, Log, Daily, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Log: a table
  • Daily: 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 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 set a different limit for each day?

Type the figure into the Daily limit column on the Daily tab. Each row has its own limit, so a weekend can allow more than a weekday. The Left column subtracts the day's total from that limit, and the row turns red when the total is higher.

Can I track spending for a whole year?

Yes. Add the dates to the bottom of the Daily tab and copy the Entries, Total and Left formulas down to match. The Dashboard totals use every row, so the averages and biggest day update as the year goes on.

Why does a row on the Log tab not add up?

Check that the date is a real date rather than text, and that the amount is a number. The Daily totals only count rows whose date matches a row on the Daily tab exactly, so a date typed as text will be left out.

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