I love my Christmas shopping spreadsheet.

[2kidsintow]

Not only does it help keep me organised and keep an eye on how much I've spent, but it also lets me see what I've bought in previous years so I don't buy the same thing for someone twice!

The favourite thing for me, however, is that I can look back and be reminded of the things my DDs loved at certain ages. I started my spreadsheet in 09 when DD2 was only 5.

[Mattissy]

I think I love you!!! I'm an excel geek, mine goes back to 2004, lol.

I have a birthdays and other events spreadsheet too. In fact I pretty much have a spreadsheet for every part of my life!

[ExcuseTypos]

What a fantastic idea! I'm going to start one this year.

Thank you

[raisah]

Is it just a tracking spreadsheet or one with formulae in that calculates expenditure? If it's the latter, than I am seriously impressed and you should train to be an accountant!

[phoebechicken]

I love mine too! I can see that I've always blown the budget ;)

[OurMrsReynolds]

Oooh I want to do this!

[Chocotrekkie]

This is why I love mumsnet - I thought it was just me who did this !!

Mine is colour coded too - budget for each person and then red if over, green if under and orange if on budget. Last years was very red :(

[WhispersOfWickedness]

Ooo, I might start that this year
I can see how it would be useful to make sure you didn't repeat presents!

[OurMrsReynolds]

Oooh how did you do that Chocotrekkie?

I have made a simple one, with colums for name, present, ordered, arrived, wrapped and gifted

If its ordered etc the line goes green, not ordered is red. I have included prices too and using autosum realised I have spent alot more than I thought already

[Mattissy]

Ha ha, mine us conditionally formatted with where it is in the full process, idea through to wrapped and whether in budget etc.
I also have macros built in so I can make it into shopping lists etc.

When I said I was an excel geek, I meant it!! Lol

[AnythingNotEverything]

We do this! It's brilliant for not buying repeat presents year in year out, and you can keep track of what's arrived from the internet.

We upload a copy to Dropbox so we can see it when we're out of the house too.

[maybe3x]

That sounds fab, I have a notebook with it all in but am having spreadsheet envy

[2kidsintow]

Mine has some formatting. I have 2 tabs per year, one for the large family I buy gifts for and one for the DDs and DHs presents.

It is set up to calculate how much I've spent on each person and display the total under their name. I have a drop down box that lets me say y or n to whether it's been delivered or brought home and it turns green when I choose y. :)

It also totals the amount spent on the family and carries over that amount to the DDs page. There it shows how much has been spent on each DD and then a final total. :) :)