Making a List, Checking It Twice

The frenetic pace of the holiday season can put us into a flurry of shopping confusion. Read on for a simple solution to gain control of your gift buying!

Have you ever been out shopping for gifts, braving the holiday crowds, when you spied the perfect plaid scarf for Aunt Betty, made your way to the checkout counter with your prize in hand, only to stop yourself and wonder in puzzlement, “Uh-oh. Wait. Did I give her a plaid scarf last year? Or was that Aunt Dot?” Since you can’t remember and don’t want to risk giving the same gift twice, you get out of the checkout line and go back to the gift drawing board. Ugh!

Solution: Keep an ongoing gift list. 

As I clicked open my own gift list spreadsheet last week to jot down some Christmas ideas, I looked at the tabs along the bottom and realized that I have been keeping a gift spreadsheet since 2005!

[My teenage daughter’s reaction to this news was to sigh, “Of course you have a gift spreadsheet,” accompanied a roll of the eyes.]

But really, it’s an easy thing to do and a great tool for holiday and birthday planning and budgeting, especially if you buy gifts for lots of different people: immediate family, extended family, friends, neighbors, coworkers, teachers, service providers, etc.

If you’re like me, making a spreadsheet helps you organize your thoughts and ideas into tidy rows and columns. However, if the mere mention of the word “spreadsheet” sends you into panic, fear not! You can keep an ongoing gift list with whatever tool you prefer.
Whether you use a spreadsheet, a notes app, or good old-fashioned paper, a gift list will keep you organized and ready for holidays, birthdays, and any-occasion
gift giving.

​Whether you use a spreadsheet, a notes app, or good old-fashioned paper, a gift list will keep you organized and ready for holidays, birthdays, and any-occasion
gift giving.

For a non-spreadsheet digital solution, use a word program (Google docs will allow you to access your notes online from anywhere.) or a list app (I still love Wunderlist but there are other great ones out there.). If you are a paper person, use a page in your planner or designate a little notebook as your Gift Book.
My spreadsheet is pretty simple, consisting of just three columns: name, gift, and amount. You can set up your spreadsheet or notebook the same way.

1. In the first column, list all the people and recipient categories (e.g. “teachers”) to whom you’ll give a gift.
2. In the second column, list the gift or gifts. On my spreadsheet, gift ideas that I’m considering are italicized and once I purchase them I put them in regular font. For a paper list, pencil in ideas then write them in ink after you’ve bought them.
3. The third column lists the total spent on each person/category. This is where a spreadsheet can make things easier by using a function to add numbers.

To keep your list going year after year so you can refer back to past gifts, use a separate spreadsheet tab for each year or a separate page in the notebook for each year.

So this year, streamline your gift-giving by following Santa’s example: make your list and check it twice!

​Spreadsheets don't have to be complex and intimidating, but can be a simple way to organize lists of information, such as my Gift List.

---