How many spreadsheets do you have?

Tom99

Just had a quick look, 385 .xls files.

kerri_gt

I love a good spreadsheet (which is handy as 90% of my work involves Excel)

I've kept a personal monthly spend workbook since 2009-ish, I also keep a household workbook - both of these have monthly budget tabs.

On top of that I have a workbook for Christmas presents where I keep a log per year so I can also see what I've bought people the prev year, and finally I have a workbook for our Xmas dinner planning - again I can then look back to see what we had from where in prev years, what we spent (though I did lose one year where the file became corrupted as I'd just cleared out my receipts :mad:). It also helps me check I don't get to Xmas day as realise I've forgotten something 'essential' like the turkey :rotfl:

I have a separate list of timings for key outgoings / renewals like insurance, which I make a note of the most recent provider, the last provider and turn the text green as each item is paid throughout the year.

Have had various adhoc sheets for major house projects / spends, and things such as annual clothes spends over the years too.

worried_jim

I have just the one to keep track of all my pensions. I set a day aside every October to maintain, update and evaluate.

I have 100's at work though! If you are still at school and are unsure what to study, if you become an excel whizz you will be employed for life!

tempus_fugit

My main spreadsheets:

1. Budget spreadsheet for current year with tabs for each month, linked to previous year's equivalent sheet so that the values all carry forward
2. Retirement/pensions spreadsheet
3. Energy spreadsheet that logs submitted monthly readings with graphs to show usage and how it compares to average usage in previous years.
4. Spreadsheet to log taxes paid to work out what, if any, tax needs to be reclaimed from HMRC.
5. eBay sales spreadsheet.

mumf

Ha ha! Whats a spreadsheet? Computers ain't my bag,so I keep a check on my income and outgoings in an ( old fashioned?) cash book.At a glance,I can see what I have,and no electricity involved.I like simplicity.

pattypan4

none. I have a simpler method, enough in my current account to cover bills like council tax and standing orders and a safety net with 0.2% interest in the same bank. Money goes back and forth between the two. I look at my online bank every morning, you only need one fraudulent transaction to jolt you into doing that

Food etc, just a list on the fridge. I am not nerdy enough to keep track of energy, I am either warm or I am not but prefer to be warm

grunnie

No spreadsheets for me. I use an old envelope one for each month and every receipt goes into this envelope and the shop and amount gets written on the outside. I keep them for 2 years in a pretty bag in my wardrobe so i can check up if i am spending the same or more than last year or the year before. Inspite of prices increasing my spends whether clothes food etc seems to be decreasing.

kerri_gt

tempus_fugit wrote: »

My main spreadsheets:

1. Budget spreadsheet for current year with tabs for each month, linked to previous year's equivalent sheet so that the values all carry forward
2. Retirement/pensions spreadsheet
3. Energy spreadsheet that logs submitted monthly readings with graphs to show usage and how it compares to average usage in previous years.
4. Spreadsheet to log taxes paid to work out what, if any, tax needs to be reclaimed from HMRC.
5. eBay sales spreadsheet.

Ohh, I like the idea of the energy tracking - useful for switching suppliers to see the usage YoY with history (not just the past 12mths)

unrecordings

kerri_gt wrote: »

Ohh, I like the idea of the energy tracking - useful for switching suppliers to see the usage YoY with history (not just the past 12mths)

I've a tab for utilities in my household spreadsheet, and while I'm of a similar mind to other posters (heating is on when it needs to be on), it has proved useful in switching and when I've been incorrectly billed - for the latter noting the number of standing charge days is a good call because for dual fuel accounts the number of days sometimes gets out of sync

khris210

Thank the Lord, I am not alone! We have solar panels and an electric car (smug expression) so I have a multi tabbed SS for panels, grid, oil(no gas) and a summary column. Each year has 12 or so lines (for the months) going down the page. 10 years in this property, so its not too big. I also have an SS for our various savings accounts. Anyway can't stop, the cats just pooped in the garden, so that has to be added to the family sh*t sheet, (joke, tried to add an emoji here, but only got a capital D) Spread sheets keep my life on track, thank you Libre office.