Skip to content
The title slide and first slides of the Gift Budget Tracker template

Gift Budget Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

Gift spending is easy to lose across birthdays, holidays and weddings. The People tab lists everyone you buy for with a yearly budget; it adds up the planned and spent gifts and shows what is left, flagging anyone whose plan is over budget. The Occasions tab is the gift list itself: person, occasion, gift idea, planned and spent amounts, the gift date and a status from Idea to Given.

The Spent tab totals the budget, plan, spending and the amount left, then compares planned and spent by occasion and budget against spent by person in two charts. Sample entries include a wedding registry gift, a teacher thank-you and holiday ideas, one of which shows an over-budget flag to show the flag in action.

Useful for

  • Hold holiday spending to a set total
  • See which people take most of the budget
  • Keep a list of ideas and what was bought

What's included

  • 4 tabs: People, Occasions, Spent, How to use
  • People: a table
  • Occasions: a table
  • Spent: a dashboard with 4 summary figures
  • 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 People 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 gift budget?

Decide a total for the year, then divide it among the people you buy for. Enter the amount for each on the People tab and watch the left column as you spend.

What counts toward the spent amount?

Count the gift, wrapping, shipping and cards. The sheet adds whatever you enter in the Spent column of each gift.

Can I track gifts for the whole year?

Yes. Add rows with dates for birthdays and holidays through the year, and the Spent tab groups them by occasion.

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

More budget templates

See all 61

Also in Holidays

All holidays templates
Get this template

Preparing your template…