Anyone else addicted to Excel spreadsheets?

auntie_brenda

The 3 I use the most often are:
'bank account' - set up with all income and all regular outgoings, plus a regular housekeeping amount. I then update this on a [STRIKE]obsessively frequently [/STRIKE]often basis. I don't pay attention on a day to day basis to how much I have in there, I concenrate on how much is in on the day before pay day. Interestingly, I was very well off when I set it up, until I put the DD's in :rolleyes: .

'debt repayment' - I record every penny I pay and when, and it automatically works out the % paid back, plus a graph that plots monthly payments, total paid and total left to pay (looking forward to cross over day :T ).

'mortgage spreadsheet' - this calculates interest daily and takes into account my monthly payments. I update with exact figure from mortgage co every month (usually I'm within a £ or 2). What a exciting day that is!!!!!! It also shows when I will have paid it off :eek: , and a recent addition is the hourly interest (goes up from 49p to 50p during the month ).

Does this make my financially astute and well organised or just sad???????

notanothergreyhair

charlotte664 wrote: »

Oh crumbs! I have one spreadsheet.

Well, one, but with 17 odd pages to it......

- Main page is a replica of my bank statement with a forecast to September 2007
- Savings spreadsheet showing what category my savings are allocated to
- breakdown of salary (net/gross/tax etc), average over year to keep me up to date with tax credit estimates.
- Breakdown of freebies - tesco points, pigsback etc
- Meter readings
- Seperate rent and council tax payments/owing
- list of debts and owings
- list of debts with own snowball mock up
- list of urgent things ie. passport numbers and mobile EMI numbers.

The whole family life is on it! I also save a copy of the file and keep it n the safe - we would be lost if the PC went down!

I do not have EVER any bank account numbers on it though. Or personal stuff like DOB etc. Incase the PC was stolen. (Although the file is passworded!)

This sounds awesome, much better than any of my efforts; any chance of a copy? (personal info excluded, of course)

Dr_Hook

sloppy_saver wrote: »

'learned' dumbass

From Oxford dictionary online:

learn

• verb (past and past part. learned or chiefly Brit. learnt) 1 acquire knowledge of or skill in (something) through study or experience or by being taught. 2 become aware of by information or from observation. 3 memorize. 4 archaic or informal teach.

dumbass :rolleyes:

I'm addicted to my own snowballing spreadsheet which is linked to an income & expenditure sheet so I can see how any overpayments knock months off my debt free date. I've become obsessed with changing that date!

ezzauk

i luv speadsheets, it makes it so much easier to see what your doing with your money, the first time i did one i couldnt beleave how much money i was wasting on junk.

SuSu1871

I've been using a spreadsheet for years - I create one at the start of each year listing - month by month - all direct debits, standing orders, rent, bills, birthdays, car tax, etc. (it also helps me to remember my nephews and nieces birthdays as I have nine of them!)

I check my bank account every day and delete the SO/DD/whatever from the spreadsheet when the money comes out of my account. Without creating complicated formulae I have a pretty accurate idea of how much money I have in my account and how much is "spoken for".

Anything extra that goes into my account (quidco, flatmate's share of bill DDs, expenses) goes into my savings account. I never knew I'd enjoy money management so much!

MUSTBEFUNNY_2

Hi All,

I LOVE:lovethoug my spread sheet too! I've been recording all my spending now for 4 years. I log on to my bank account and update my sheet everyday and I also record all my cash spending. It's like going to a confessional! There is no running away from facing up to my spending. I now have average spend figures which I try to beat (so average monthly spend on food, clothes, gas, etc) and variances year on year. I suppose it's like a little business "MUST BE FUNNY LTD" .....and I need to keep it solvent;)

Timmne

I have a spreadsh!t for everything - if it doesn't warrant a spreadsh!t I'm not interested!