spreadsheet help 23 July 2011 at 8:34PM in Mortgage-free wannabe 4 replies 602 views

didabuf

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

Hurdler

A couple of ideas for you to mull over ...
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 ...

david_hellier

I have an excel sheet with a budget on one tab and a spending diary on the others. If you or anyone PMs me with an email address, I'll attach it.

Lois_E

A spreadsheet is just a list - but it gets the computer to do the sums for you!

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.

didabuf

thanks for your help,
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