spreadsheet help

113 Posts


Hi, im going to be starting a mortgage free thread in the next couple of days but before doing so i wanted to make sure i was on top of all my finances. im pretty good with money and seem to never spend too much but i know i could do better.
ive been reading alot of peoples threads and you all seem to be using spreadsheets to help you along.
My questions is does anyonme have a copy of one i could use to get an idea. im not very good with this sort of things ( can make a hundred lists but not a spreadsheet)
it would be very much appreciated. and like i say ill be back soon to start a thread
thanks
ive been reading alot of peoples threads and you all seem to be using spreadsheets to help you along.
My questions is does anyonme have a copy of one i could use to get an idea. im not very good with this sort of things ( can make a hundred lists but not a spreadsheet)
it would be very much appreciated. and like i say ill be back soon to start a thread
thanks
Mum to 11year old triplets, just trying to save the pennies.
I'm a saver not a spender.
Mortgage: Dec 21 £52,000, dreaming of paying it off in 3 years.
I'm a saver not a spender.
Mortgage: Dec 21 £52,000, dreaming of paying it off in 3 years.
0
This discussion has been closed.
Latest MSE News and Guides
Replies
I have one for my main current account
First page is all the regular outgoings
Second page is the calculations which includes ...
Third page which are ad-hoc outgoings and incomings
One I've just done for my mortgage is a master sheet with my rate and some notes from recent chats to the Woolwich
On the page/tab are columns for date, payment, interest (calculated using the previous day's balance and any payments) and the previous day's balance from the online banking.
Hope that helps ...
I have an excel sheet with 6 pages:
1) Master sheet that tracks money in/out and balance for each account/card/loan/mortgage that I have, and calculates the ultimate value of [(everything I owe the world) - (sum of all my balances)] and draws a graph of how it's changing over time.
2) Mortgage sheet that tracks payments, calculates interest and finds balance.
3) Utilities sheet that tracks usage of water, gas & electricity.
4) Gift aid sheet that tracks gifts to charities and gift aid reclaimed.
5) Spending diary with stacked bar charts of income and spending in categories.
6) List of accounts with account numbers and hints for passwords - very impenetrable hints to anyone but me, I hasten to add.
You probably won't want anything like that amount of detail, since you are clearly not a spreadsheet-geek like me, but it might give you (or anyone else) an idea or two.
lois-e sounds amazing your spreadsheet, i know how to use it but ive never been very good with putting sums in, hopefully one day ill learn though because if it can be anything like yours im sure ill be ok
thanks again
I'm a saver not a spender.
Mortgage: Dec 21 £52,000, dreaming of paying it off in 3 years.