Skip to content
The title slide and first slides of the Holiday Savings Tracker template

Holiday Savings 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

December spending feels sudden, but the bills can be spread across the year if you know the numbers. This tracker lets you list each holiday goal on its own row: gifts, a trip home, decor, hosting, giving. Give each a target and the date you need the money and the sheet counts the whole weeks left and divides what remains by them.

Deposits are logged on a separate tab and sorted into goals by a dropdown, so a $60 deposit to the gift fund never lands in the travel fund. The Summary tab compares target and saved in a chart and adds up the weekly deposit across all goals, which tells you the one number to automate. Sample goals total $2,850, and every row can be changed.

Useful for

  • Break a holiday budget into a weekly deposit
  • Keep a gift fund and a travel fund separate
  • See in October whether the December plan is still on track

What's included

  • 4 tabs: Summary, Goals, Deposits, How to use
  • Summary: a dashboard with 5 summary figures
  • Goals: a table
  • Deposits: a table
  • 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 Goals 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

What weekly deposit covers my holiday spending?

Subtract what you have saved from each goal and divide by the weeks left. The Goals tab does this for every goal and the Summary tab adds them into one weekly figure.

When should I start saving for the holidays?

The sooner the lower the weekly amount. Change the Needed by date or the start of your deposits and watch the weekly figure move.

Can I track more than gifts?

Yes. Add rows for travel, decor, food, giving or anything else, and use the matching goal name when you log deposits.

  • #savings-tracker
  • #holiday-savings-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More savings tracker templates

See all 22

Also in Finance

All finance templates
Get this template

Preparing your template…