Skip to content
Grocery Budget Tracker cover: a sample sheet with budgeted, spent and left and a pie chart, beside the Dashboard, Trips and Items tabs

Grocery Budget Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

The Grocery Budget Tracker is for households keeping weekly food shopping on track. The Trips tab records each visit with its date, store and budget, and its spent figure adds up automatically from the Items tab. The Items tab lists each purchase line with its food group, such as produce, meat and fish, dairy and eggs, or frozen. The Dashboard reports the total budget, spending, what is left and the share of spending in each group.

Log items on the Items tab when you unpack, while the receipt is still to hand, and pick the trip name from the list so the totals line up. Group small lines, such as a bag of produce, into a single row to keep the list short. Set each trip budget from your own typical shop, then review the red rows on the Trips tab to see which trips ran over and why.

Useful for

  • Keeping the weekly shop within a set amount
  • Seeing which food group takes the largest share
  • Comparing spending between two stores

What's included

  • 4 tabs: Dashboard, Trips, Items, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Trips: a table
  • Items: 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 Trips 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 log another shopping trip?

Add a row on the Trips tab with a trip name, the date, the store and the budget. Then add that trip's items on the Items tab and pick the same trip name from the list. The spent and left figures for the new trip calculate on their own.

Why does the trip name have to match exactly?

The spent figure adds up every item with the same trip name. A name spelled differently, or one missing from the list, will not be counted. Pick names from the dropdown rather than typing them.

Can I track a month's total instead of each trip?

Yes. Give each trip a month label, such as November, and enter every shop from that month. The Dashboard then compares the month's spending with the combined budget. You can also keep the weekly rows and total them by store.

  • #budget
  • #grocery-budget-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More budget templates

See all 61

Also in Finance

All finance templates
Get this template

Preparing your template…