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 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.


How to install this template

Start your free Tiller trial, set up your Foundation Template, then install this template with the free Tiller Community Solutions add-on for Google Sheets.

Tiller Community Solutions FAQ

Is this template free?

This is a free template created by a member of the Tiller Community. While it's free for anyone to use, it's designed for Google Sheets automated by Tiller. Additionally, it's recommended for use within the Foundation Template.

What is Tiller?

Tiller is the only automated personal finance service for Google Sheets and Excel. Tiller keeps all your daily spending, income, and account balances updated in your spreadsheets, so you can easily see where you stand at a glance and gain powerful insights about your money. Learn more →

Does this template have any dependencies or special requirements?

This template for Google Sheets works best when installed in Tiller's Foundation Template.

Have questions about this template?

Visit the Tiller Community with any questions about this template.

Notable Replies

  1. 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

  2. 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.

  3. 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.

  4. 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

1 more reply

Participants