My Christmas Gift Spreadsheet

It might be a little late to use this year, but a couple people have asked for my Christmas spreadsheet, so I thought I’d finally post it. Just click here to download: Christmas Gifts Record

I have a master template that I keep safe, and then each year, I open the file and Save As: Christmas Record (Insert Year). Insert each person’s name in the upper left green area. Change the Gift Budget and Stking Budget to fit your needs. The Amount Left to Spend at the bottom will change accordingly.

Here’s what the spreadsheet looks like.

Screen Shot 2016-12-22 at 9.44.27 PM

On the right, I have a key reminding me how to color-code each gift. If I know ahead of time what I want to buy, I put it on the list and highlight the cell in yellow. If I buy something online but it hasn’t arrived yet, I color it orange. If the item is in my possession but I haven’t wrapped it yet, I color it blue. And when it’s been wrapped, I change it to purple.

When I’ve bought everything for a specific person, I change the top light green row to dark green, even if I still have wrapping to do. And when everything’s wrapped and ready to go, I change ALL the rows for that person to red.

The total will add up automatically, and you’ll also be able to see at a glance how much is left in your budget to spend.

I also use the numbers of the items to keep track of the actual gifts. Ever been cleaning out your closet in May and found a few stocking gifts? I have. But that was in the past, BCR (Before Christmas Record).

Now, as I wrap, I put the number of the item on the gift tag – just small, in the bottom corner. For stocking gifts, I write the person’s initials and the gift number on the bottom of the gift. Then when I put the presents under the tree or int he stocking, I can make sure I have everything and nothing’s hidden in the closet or my sock drawer.

Yes, I’m anal. Yes, I buy a lot of gifts. I actually shop all year round, so I can take advantage of sales and clearances racks and get the most bang for my buck. Next week, I’ll start my Christmas Record 2017. Maybe I’m crazy, but I love, love, love giving presents! Hope this helps you next year!

Leave a Reply

Your email address will not be published. Required fields are marked *