The Holiday Gift Planner is a clever Google spreadsheet to help you budget, organize, and track all of your holiday giving based on your actual spending.
It’s perfect for Christmas and Hanukkah, but you can also use the Holiday Gift Planner spreadsheet to track charitable giving over the year, plan a wedding registry, even plan school shopping for a large family.
The Gift Planner Template includes several sections:
- A budget where you set your total projected holiday budget.
- A list of recipients with targets for how much you want to spend on them.
- A per-recipient gift list with each item’s price and status (wrapped, shipped, etc).
- A per-recipient tracker showing how much you’ve spent so far, and what you have left.
How the Holiday Gift Planner Template Works
The Holiday Gift Planner Spreadsheet is designed for Google Sheets powered by Tiller Money.
Tiller automatically imports your daily credit and debit card transactions into Google Sheets. As you buy gifts, those transactions will appear in your transaction history sheet.
As you tag each gift transaction with the gift recipient’s name, the total spent on them will auto-update in the “Spent” column of the Gift Planner. You can also see how much is left for each person in the “Budget Available” column.
Read detailed instructions in the How To Use the Holiday Gift Planner post in the Tiller Money Community.
How to Install the Holiday Gift Planner Spreadsheet
The Holiday Gift Planner Spreadsheet is installed via the free Tiller Labs Add-on for Google Sheets. The add-on also includes over a dozen other templates and tools.
Tiller Labs tools and templates work best with spreadsheets powered by Tiller Money. (And by the way, a Tiller Money subscription is a great gift for everyone on your list.)
Here’s a link to a view-only version of the spreadsheet if you want to check it out.
This template is a Tiller Labs project.
Tiller Labs builds templates, tools, and workflows for spreadsheets powered by Tiller Money Feeds. About the Tiller Labs Add-on →
Ask questions and get inspired in the Tiller Money Community
Need help with a Tiller Labs project, or want to know more about how it works? Visit the Tiller Labs category of the Tiller Money Community, where you can get help from the Tiller team and spreadsheet enthusiasts around the world.
Designed for the Tiller Money Feeds Add-on
This template is designed to work with the Tiller Money Feeds Add-on for Google Sheets.
How to Sign up for Tiller Money
Start a free 30-day trial of Tiller Money. Your first 30 days is completely free, your card isn’t charged until the end of your trial, and you can cancel anytime.
Works with AutoCat
This template is compatible with AutoCat for Google Sheets, which can automatically categorize transactions for you. Learn about AutoCat →