fbpx

Holiday Gift Planner Spreadsheet

Plan your holiday gift-giving and track your actual spending per recipient with this clever spreadsheet.

About the Holiday Gift Planner Spreadsheet

Perfect for planning your holiday giving, this spreadsheet template is also great for tracking charitable giving over the year, planning a wedding registry, even planning 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.

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.

How To Install

  1. Install or launch the Tiller Community Solutions add-on
  2. Open the add-on and choose “Gifts” from the tags dropdown on the Explore tab
  3. Click on Holiday Gift Planner
  4. Choose “Add to spreadsheet”

This will add a Holiday Planner sheet to your spreadsheet and a Tag column to your Transactions sheet if one doesn’t already exist.

How To Use the Gift Planner

  • Enter the names of the people you want to give gifts to in Column A under "Recipient (use as the tag in Transactions). You can use just their first names, just their last names, or both first and last names. Whatever you pick, those will be the exact names you will add to the Tags column in the Transaction sheet when one of the purchases for that person appears in the Transaction sheet.
HGP 1
  • When you add a recipient, you can also add a Budget amount for that person. Or, you can wait until you enter the proposed gifts in the Gift List section.
  • In the Gift List section starting in Row 55, enter individual gifts to track. For each gift, you can enter a description, the recipient, a reference or estimated price, the status, a Link to the item online, and notes. You are not required to use any of these columns, but use the ones you think will help organize your holiday purchases.
HGP 2

You can only select a recipient if they have been added to the Recipient List above. One recipient can, of course, have several rows of gifts. Lucky them!

Status options are IdeaPurchasedWrapped , and Shipped.

  • Head back to the top of the sheet. You will see the total amount for each person if you entered Reference prices in the Gift List column. This can help you adjust or add the Budget amount in column B. The total budget will be calculated in B8.
  • As gift transactions start appearing in your Transactions sheet, tag them with the exact Recipient names. The total for each person will appear in the Spent column. You can also see how much budget is left for each person in the Budget Available column, based on your Budget and actual, tagged transactions.
  • The Purchased / Ideas column uses the Gift List and counts gift Purchases and Ideas. For the purposes of this column, every gift is counted as an Idea. All gifts that are in status PurchasedWrapped and Shipped count as Purchased here.
  • In the middle section, you can get a Detailed view for the Recipient you select in B32. This includes actual transactions where they have been tagged and their items in the Gift List` below.

This section has a limit of the last 15 transactions for the selected person.

Webinar Replay

Troubleshooting

If you have a question or need help first search the community to see if someone has already asked and if not click here to quickly post a question about this template in the Google Sheets category.

FAQ

This is a free template built by a member of the Tiller Community. While it’s free for anyone to use, it’s designed for spreadsheets automated by Tiller. Additionally, it’s recommended for use within the Foundation Template.

Tiller is the only automated personal finance service for Google Sheets and Microsoft Excel. Tiller automatically imports your daily spending, income, and balances in your spreadsheets, so you can see all your finances in one place and manage your money, your way. Learn more →

Unless otherwise noted above, this free template is installed with the Tiller Community Solutions add-on for Google Sheets. It's an easy way to browse and install dozens of free, prebuilt sheets for tracking budgets, debt payoff goals, net worth, savings, and more, all from the Google Sheets sidebar.

This template for Excel works best when installed in Tiller’s Foundation Template.

Visit the Tiller Community with any questions about this template.

Notable Replies

  1. I’m setting up the Holiday Planner solution and have run into an issue.

    I’ve applied the Holiday Planner solution to the foundations template. Following the user guide I’ve added a new category for “Vacation”. I’ve then added that tag as a recipient name in the Holiday Planner tab. I then marked a transaction as Vacation.

    This transaction does not appear under the Holiday Planner tab as expected.

    Additionally when I set a budget for the gift it adds that same amount to the spent chart.

  2. Avatar for jono jono says:

    Hi @bonominijl,
    I think you might not be setting up the sheet correctly.

    You say you ‘added a new category for “Vacation”’. But the Holiday Gift Planner doesn’t use the categories at all. It just uses Tags.

    In the Transactions sheet, use the Tag column to track holiday purchases. The tag column keyword that you use use match the recipient name in Column A of the Holiday Gift Planner.

    Give this a try and perhaps re-read the instructions above. Let us know if that solves the issue.

    Best,
    Jon

  3. We’ve closed this topic for replies. If you have a question or need help first search the community to see if someone has already asked and if not click here to quickly post a question about this template in the Get Help > Spreadsheet templates category.

    Be sure to customize the title of your post with keywords about the issue or question so others can easily find the Q&A in search.

  4. Avatar for jono jono says:

    An update was made to the Holiday Gift Planner to fix the formula for the Total Spent.

    The update, version 1.02, is now available in the Tiller Community Solutions add-on.

  5. Avatar for jono jono says:

    Another update to the Holiday Gift Planner was just published.

    You can now select All Transaction dates OR use your custom selected dates for gift transactions.

    Now, you can limit your results to one Holiday Season.

    Use the Tiller Community Solutions add-on to update to Version 1.03.

    Jon

Continue the discussion at community.tillerhq.com

Participants

Avatar for heather Avatar for jono Avatar for bonominijl

Start Your Free Trial

"There isn’t another tool on the market that does what Tiller can do.”
Will Hinton, Google Review October 30, 2023