Advanced search

Anyone else have a Christmas gift spreadsheet?

(51 Posts)
2kidsintow Fri 19-Oct-12 00:05:13

Want to know how much I spent on my DDs in 2010?
Or what I bought my Mum in 2009? I can tell you.
I love filling in my spreadsheet. My OH even got carried away and put in some conditional formatting for me that made it turn green if I ticked to box to say the items had arrived at my home.

<sad sack emoticon>

It's been interesting to see how inflation has affected my costs. And I can look back and remember what my kids were REALLY into that year. And it has prevented me buying duplicates of things.

I love my spreadsheet.

AlohaMama Fri 19-Oct-12 02:08:56

Oh a MNetter after my own heart! Of course I have a Christmas spreadsheet! Also includes tab for menu plan and cross-referenced to shopping list. What could be more festive??!

runningforme Fri 19-Oct-12 02:29:02

OMG, I have one of these too! Though I use it more to enter ideas and budgets for each person, along with links to where I can buy said items. I have a column for estimated cost and one for actual cost. As I buy items and enter in the actual cost, it updates to show how much I have spent so far..... I too also have extra tabs for my menu and associated shopping lists grin

Aspiemum2 Fri 19-Oct-12 02:31:35

I don't have one and don't want one - no paper trail so dh can't see how much I've over spent wink

dreamingofanallotment Fri 19-Oct-12 02:44:32

Me! I have a spreadsheet with present ideas, what I'm making, how much it cost, whether I've bought it etc, plus a list of people I've sent Christmas cards to. I'm glad it's not just me! My DH thinks I've finally come over to the dark side (he works with spreadsheets all day every day!)

ettiketti Fri 19-Oct-12 05:20:11


But now I realllly want one and am rubbish at Excel!

VoldemortsNipple Fri 19-Oct-12 05:48:47

I don't have a spreadsheet. But I do have an app on my phone grin

It works basically the same way as runningforme's spreadsheet. It has the added benefit of being portable and is password protected. Perfect for those of us who are less computer illiterate smile

No chance of dh knowing how much I really spend or the dcs rumbling the Christmas lists that used to be stuffed under my pillow. Oh, and it stops me going too over budget too.

Zeeky Fri 19-Oct-12 09:44:28

Me me me! It's the only way I can keep track of who I need to buy for, what I've bought, how much I've spent etc. I also have a sheet which is basically an hour by hour calendar for the run up to Christmas so that I can schedule all the stuff that needs doing and spread it out so that it's do-able instead of slumping in front of the tv every evening and then having a major panic/overload for the 2 days before Christmas

Can you tell I used to be an accountant!!??

rubyrubyruby Fri 19-Oct-12 09:45:40

Message withdrawn at poster's request.

kate2boysandabump Fri 19-Oct-12 09:50:02


I did my first one in 2008 and have had one every year since. One tab for gifts purchased with budget and actual cost, one for gifts received for dc and another for christmas sundries, tree etc.

I also have a word document with my food shopping list and an e-mail with links to send to people who ask what to get the ds's for presents.

I don't care what other people think, my spreadsheet makes me happy smile Glad there are other people around just like me!!!

skyebluezombie Fri 19-Oct-12 09:53:43

I have a cashbook that goes back to 1990! How sad am I?! LOL

I started it because I wanted to know what I gave somebody the year before to make sure that I didnt give them the same thing again....

It also has my Christmas card list in from 1990 too. Its interesting to see how that has changed over the years as my friends have changed.

Im going to put it onto spreadsheet this year, as Im tight on money now that Im a single parent!

daisie4 Fri 19-Oct-12 09:55:15

I really want one - anyone care to share some headings so I can create my own? Or any links to one I can doctor??

babesdontlie Fri 19-Oct-12 09:56:47

oh yes, I have a spreadsheet and its colour coded smile

AlmostAHipster Fri 19-Oct-12 09:59:08

I too have an iPad app [shame cube] smile

Arithmeticulous Fri 19-Oct-12 10:01:58

I have had in the past. I also had a column for RRP and then what I actally paid for it wink

BiddyPop Fri 19-Oct-12 10:08:34

I roll it over every year in January to allow sales purchases be captured, log crafts made and set the new budget for this year. It covers ideas and firm decisions, basic budget, spent to date, final spend, to make, to buy, already have ("have" column changes from listing individual bits bought to Y once complete, and W gets added once they are wrapped). There are formulae to track how much I have left to spend per person, and in the overall budget (and I added an under/over original budget per person column a couple of years back).

It also has crafting ideas, lists of things I've made but not decided who to give to yet etc. And I keep intending to add a sheet of gifts in my stash but that will be a bit of work.

It's saved me embarssment like the year I was on mat leave and never updated it (I keep it in secure personal drive at work so no fear of snoopers), so I ended up giving my DSis a duplicate of something I;d given her 2 years ago jsut a different colour.

enjoyingscience Fri 19-Oct-12 10:10:34

Me! We love the christmas spreadsheet.

It's colour coded, has seperate colours for ideas, bought and wrapped. We also have categories for the things to go in crackers and DSs stocking. <obsessed>. My mum's birthday is boxng day, so she gets two columns, lucky duck.

Weirdly though, the rest of my life is total chaos.

plutocrap Fri 19-Oct-12 10:27:15

YEAH!! Mine is sorted by people, with cards/ecards and presents opposite, as appropriate!

1stMrsF Fri 19-Oct-12 11:05:13

What else would you do?! shock

cherryboomboom Fri 19-Oct-12 12:17:34

Yes me!! I keep all my old ones too so I don't duplicate gifts for people.
Love it and it's the only way I feel organised and can keep track of what's going on. I told my friend about it the other day and she was a bit hmm
I thought I had my spreadsheet all sorted and was quite happy with it, but now reading about some of yours I have envy which is slightly blush

RikersBeard Fri 19-Oct-12 12:21:03

Oh yes, otherwise how on earth do you remember that you bought aunt Lavinia rose bath salts last year and thus to send lavender this year?

And there is nothing so lovely as watching those boxes go from red to amber to green as the big day approaches!

ShotgunNotDoingThePans Fri 19-Oct-12 16:01:44

Okay, so if you're a dinosaur, what's the best app/ready-made spreadsheet to use? Any recommendations?
< Scrunches up Flylady Christmas Planner >

ShotgunNotDoingThePans Fri 19-Oct-12 16:03:51

Sorry that came out wrong - didn't mean to imply you were all dinosaurs - that would be me of course blush.

Scout19075 Fri 19-Oct-12 16:11:21

Yup, of course! And a tab for birthday presents, too.

Finbar Fri 19-Oct-12 16:14:27

I love my spreadsheet too..and my separate list of all present items including those for teachers -- to avoid duplication and to marvel at how little money I have hopefully spent!!

Oooh Scout..a tab for birthday presents - now you're talking!

Join the discussion

Registering is free, easy, and means you can join in the discussion, watch threads, get discounts, win prizes and lots more.

Register now »

Already registered? Log in with: