We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

spreadsheet help

Options
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 13year old triplets, just trying to save the pennies.
I'm a saver not a spender.
Mortgage Free: Dec 23 - Age 38. £112500 gone in 11 1/2 years.

Comments

  • Hurdler
    Hurdler Posts: 1,361 Forumite
    Part of the Furniture 1,000 Posts Combo Breaker Mortgage-free Glee!
    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 2024 #50: Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec = £223.84/£671.61
  • 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
    Lois_E Posts: 2,227 Forumite
    Ninth Anniversary Combo Breaker
    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
  • didabuf
    didabuf Posts: 115 Forumite
    Part of the Furniture 100 Posts
    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 13year old triplets, just trying to save the pennies.
    I'm a saver not a spender.
    Mortgage Free: Dec 23 - Age 38. £112500 gone in 11 1/2 years.
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 350.7K Banking & Borrowing
  • 253K Reduce Debt & Boost Income
  • 453.4K Spending & Discounts
  • 243.7K Work, Benefits & Business
  • 598.5K Mortgages, Homes & Bills
  • 176.8K Life & Family
  • 256.9K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.