We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
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

didabuf
Posts: 115 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
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.
I'm a saver not a spender.
Mortgage Free: Dec 23 - Age 38. £112500 gone in 11 1/2 years.
0
Comments
-
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
0 -
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.0
-
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.Starting again 13/4/19Home loan 1: £21,102.50 Home loan 2: £7,698.99Total owed: £28,801.49
0 -
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 againMum 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.0
This discussion has been closed.
Confirm your email address to Create Threads and Reply

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