Mumsnet has not checked the qualifications of anyone posting here. Free legal advice is available from a Citizen's Advice Bureau, and the Law Society can supply a list of local solicitors.

SPREADSHEETS for : Debt Control, Budgeting, Mortgages etc

(108 Posts)
TalkinPeace Mon 03-Feb-14 19:52:21

The best way to get finances under control is to see what impact decisions will have.
But lots of people do not enjoy writing spreadsheets.
I do.

Credit Cards
If you pay the minimum on a credit card, it will take up to 18 years to pay off.
With a couple of really simple steps, you can clear those debts in a fraction of the time.
Input your numbers here
https://docs.google.com/spreadsheet/ccc?key=0AiZqlQ7-gn07dHRoTXA5Qnlld25UWkw1TEhZZk9IYVE&authkey=CMjc4JEB&authkey=CMjc4JEB#gid=0

Mortgages
Lots of people have mortgages where they are only paying the interest, without fully understanding that this means they are only really renting their home, rather than paying off the loan.
Have a look at the implications here
https://docs.google.com/spreadsheet/ccc?key=0AiZqlQ7-gn07dDN4clg5OXhLMGJWbHZhOEo4UTJINEE#gid=0

Budgeting your income and expenditure
Its easy to firefight rather than plan when life gets tight.
This spreadsheet puts spending by order of necessity so makes it easier to see where you are
https://docs.google.com/spreadsheet/ccc?key=0AiZqlQ7-gn07dFRwOFJENmVzX1RHR05UMGtIYkltcWc&usp=drive_web#gid=0

All of the spreadsheets are a general resource - feel free to download them to your own computer and make use of them.

Please do not damage the master copies - but I do check them every week or so.

If there are any spreadsheets that you would like me to write, ask and I'll see what I can do.

As a slight aside, here is the link to my Ebay Me page all about the tax side of running a small business
members.ebay.co.uk/ws/eBayISAPI.dll?ViewUserPage&userid=talkinpeace

Ta1kinpeece Tue 15-Nov-16 22:05:00

Totally shameless bump for the newcomers to the board

Ta1kinpeece Sun 02-Oct-16 20:16:12

Hi adora
the credit card and mortgage ones are "self driving"
you put your numbers in the boxes at the top, they do the rest

the budget one is harder work, but then budgets are !!

AdoraBell Sun 02-Oct-16 17:51:04

I will try these later, haven't used excel in more 20 years though so might be back for help.

Ta1kinpeece Fri 30-Sep-16 17:39:50

Bump for debtdrowning

Anchovies12 Wed 31-Aug-16 12:53:11

Sorry have sorted it blush laptop was being rubbish!

Thanks again flowers

Anchovies12 Wed 31-Aug-16 12:49:05

Thanks so much for these - finally dragging my head out of the sand!

Just wondering if you could check the link to the credit card spreadsheet. Next step is to face up to the fact I have got a tonne of cc debt that is getting the minimum payment sad

INeedNewShoes Sun 28-Aug-16 16:32:24

Thank you Talkin

I've got records of all my expenditure, but obviously it will stand me in good stead to get them properly spreadsheeted asap.

smile

TaIkinPeace Sun 28-Aug-16 16:28:26

I was asked on another thread about a spreadsheet for small businesses

I can only suggest that you download

VT Cashbook www.vtsoftware.co.uk/cashbook/
as its free
and if your accountant does not know about it, they should

TaIkinPeace Sun 28-Aug-16 15:58:26

IneedNew
I could write you one, but frankly I'd be a fool - as its already here
and is well respected by HMRC, Companies House and all of the Accountancy bodies
and did I mention its free smile
www.vtsoftware.co.uk/cashbook/
Download a copy and take control of your business
even better, it has export functions that work with all of the major tax software (I use Taxcalc)

I'm not a sales rep for them, just a convert !

INeedNewShoes Sun 28-Aug-16 15:51:27

Talkin wow - these are great!

Do you happen to have a spreadsheet that breaks down freelance outgoings into the various relevant categories for calculating tax returns? I think it's things like Travel, Stationery, something about Depreciable Assets etc. that are categories that I should be breaking my outgoings down into...

Gazelda Sun 28-Aug-16 15:47:19

Fabulous! Thank you

TaIkinPeace Sun 28-Aug-16 15:43:20

End of summer bump - the base rate may be low but card rates are not

babyiwantabump Mon 25-Jul-16 15:01:07

Hi
Im trying to use the credit card spreadsheet and have filled in the highlighted boxes but then nothing happens?

am I supposed to do something else?

thanks

TaIkinPeace Wed 20-Jul-16 21:30:45

Hi there :
the links in the OP are always to the current versions.
Its a google drive document that can be used online or downloaded.

I as the author can track who has altered the live one (to check for damage) but if you download they are all yours.

isthistoonosy Wed 20-Jul-16 08:33:31

Hi Do I use the links in the OP to download the newest versions or should I be looking through the thread for the most recent versions?

Thanks by the way TiP

TaIkinPeace Sun 17-Jul-16 18:14:04

Hi Barmaid
Scroll right ... column O has Repayment in it smile

Barmaid101 Sun 17-Jul-16 15:43:04

hi TIP, is the mortgage budget sheet only for interest only mortgages as that is what it says in the top left corner, i am on a repayment mortgage and i cant figure out the sheet. I have downloaded and saved the one in the opening post, and it has interest only mortgage at the top left.
Thanks so much for these resources. I am about to do the budget one

Barmaid101 Sun 17-Jul-16 15:17:41

Just what I have been after! Trying to set up a budget at the mo!

TaIkinPeace Tue 12-Jul-16 15:10:46

yet another shameless bump for those dreading the summer holidays

tropical1 Sat 05-Mar-16 19:58:19

Thank you so much for these TalkinPeace, it made me realize just how long it would take me to pay off my credit card by just paying the minimum.
I've been paying over the minimum every month and it's really making a difference 😊😊

cozietoesie Fri 04-Mar-16 18:30:08

Well done, Talkin. smile

TalkinPeace Fri 04-Mar-16 16:43:16

just bringing the sheets back up to date and up to the top

t875 Wed 27-Jan-16 08:57:45

Bump great idea

BramblePie Tue 19-Jan-16 15:22:11

Thanks!

TalkinPeace Sun 17-Jan-16 16:24:13

Budget sheet amended to have one page working by week, other page by month.
Its free to download to your machine and re-label to your heart's desire

Join the discussion

Join the discussion

Registering is free, easy, and means you can join in the discussion, get discounts, win prizes and lots more.

Register now