spreadsheet help

didabufdidabuf Forumite
113 Posts
Part of the Furniture 100 Posts
Forumite
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
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.

Replies

  • HurdlerHurdler Forumite
    1.3K Posts
    Part of the Furniture 1,000 Posts Combo Breaker Mortgage-free Glee!
    Forumite
    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 ...
    • Mortgage @ March 2008: £194,965 ; Lightbulb Moment: July 2011: £164,926; End Date: March 2033
    • MORTGAGE FREE: September 2015
    • MSE 1p Savings Challenge 2023 #70: Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec = £55.66/£667.95
  • 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_ELois_E Forumite
    2.2K Posts
    Ninth Anniversary Combo Breaker
    Forumite
    A spreadsheet is just a list - but it gets the computer to do the sums for you! :D

    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.
    Starting again 13/4/19
    Home loan 1: £21,102.50 Home loan 2: £7,698.99
    Total owed: £28,801.49
  • didabufdidabuf Forumite
    113 Posts
    Part of the Furniture 100 Posts
    Forumite
    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
    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.
This discussion has been closed.
Latest MSE News and Guides

Boost your Nectar points

Get up to £25 in bonus points

MSE News

Ask an Expert: Scams

Watch MSE Katie's answers to your questions

MSE Forum

Hot Diamonds 40% off code

Including already-reduced outlet stock

MSE Deals