Spreadsheet budgeting


(Richard) #21

Far too kind :joy::joy:


(Edward Shepard) #22

Edward from Tiller here. Thanks @Tom-H for mentioning our templates. It’s great to read what people like (and don’t like) about spreadsheets for managing money. I love seeing the custom spreadsheets people have built to serve their specific financial goals and situation. I recently wrote a mega post about the unique benefits of using spreadsheets to manage money here. I’m not currently a Monzo customer, but I follow the platform closely and am interested in trying it in the future.


#23

Thank you for the reply Edward

Why have you not taken the plunge?

Being able to see all your transaction live means you can keep your spreadsheet as up to date as possible

I wondered if you ever conisdered working with Monzo to auto fill a spreadsheet?


(Tom) #24

Our spreadsheet is relatively straight forward.

A list of our bills (basically all our Direct Debits) and their payment dates, then a list of everything non-bill related, like Groceries, Petrol, Days Out etc.

I’ve set up a really basic calculation to add all the expenses together, and then subtract from our incoming funds.

It’s not perfect, but it does a good job of focussing us on what necessary spends we have coming up. I get paid weekly, so we update it weekly, which means we’re always pretty on top of it.

Ideally, when Monzo releases it’s Weekly summary option, we can look to transition over to that.


(Tom Halloran) #25

Hey @EShepard, welcome to the forum! Tiller looks cool, I guess it’s only in the states though at the moment right, any plans to come to the UK?


(Edward Shepard) #26

Tiller currently only directly supports US-based institutions, but we do have many UK-based customers. We’re working on expanding UK support in the year ahead. I don’t currently use Monzo as I’m based in US but it really looks fantastic.


#27

Well best of luck in the US and when you do move to the UK hopefully you will team up with Monzo


#28

Oooh, mine hasn’t been used since August because Monzo covers so many basics now, but this is the latest version I used for over 2 years. I think this was version 3 or 4 though :thinking:

Split into Car / Set DDs / variable DDs / non essential DDs / saving / credit card payments

59


(Justin) #29

For me it’s fairly simple using the 50/30/20 rule
50% is for essentials
30% is for spending
20% is savings


(Colin Robinson) #30

Reminds me of what me da said to me many yeas ago, 1/3 to your ma for looking after you, 1/3 to you for spending, and 1/3 to savings so when you leave home you’ll have something.


#31

Hi! Great thread!
I’m importing my monzo transactions to a google sheet with IFTTT. Does anyone who uses it know a more automatic way to calculate the daily spending?
Is there is a way to readjust the future daily allowance based on how much budget is left that’d be great! At the moment I’m doing all this manually:

  • I set up monthly budget for monzo

  • Set myself a daily allowance (X for each weekday and Y for each weekend days).

  • If I exceed my daily allowance then I recalculate and adjust (I do this weekly)

I would love to learn how to set up an excel file so it re-calculates and adjusts this for me!
Thanks :slight_smile:


#32

Interesting idea @IsabelM. Here are some thoughts on how to build such a spreadsheet in Excel.

  1. You will need a series of 12 cells that hold the count of weekdays and the count of weekend days for each month.

  2. You need to decide if your daily unspent budget goes to the other weekdays if it’s left over from a weekday spend or weekend balance if its from an unspent weekend spend. Or, do you see it being spread over the rest of the days of the week? Seems counterintuitive but you need to know this to build the s/sheet properly.

  3. What would you want to happen to budget overspend and any budget left over at the end of a month?

I’m sure more will come to mind with a Hob Knob and a cuppa.

R-


#33

OK, let me see

  1. Hmm… I was thinking that any overspend or unspent budget automatically readjusts the days ahead - that way if I go over the budget one day it has a small impact on the overall month, rather that just allowing me to keep on spending as planned (eg. if my weekday budget is £10/weekday and £20sat/sunday so if on Tuesday I spend £30 I will be left with £7.14/day and £14.28sat/sunday for the remainder of the week).

  2. So far I’m just considering this on an isolated month. It’d be nice to see how much I went over or how much I saved but that’s just against the overall budget so it’s fine.

Hope it makes sense! Thanks @RogerB


#34

It will be some s/sheet that’s for sure. I did have another thought over tea.

Do you see public holidays (Friday/Monday) and your personal holidays (perhaps 7 straight days) having a different budget than their normal allocation?

R-


(Stefano) #35

I do apologise if this seems brutal, and please prove me wrong, but is all this really worth the effort? If this spreadsheet is something you need to look at every day, isn’t it easier to just look at your daily spending in app and see how you’re doing? How is knowing that you have, say, an adjusted £7.14/day left for the following 3 weekdays going to be helpful in a practical way? When you go so granular, you’re bound to have to adjust budgets all the time, effectively defeating the point of having a budget in the first place – Maybe it’s just that daily budgets never made sense to me, but it sounds like an overly complicated approach?


#36

The way I use it is to estimate my incomings and outgoings over a year.
So somethings are fixed like salary and rent and most bills.
So I have been doing it for a few years so I have a rough estimate for my spends on things.

So then I take that yearly budget and use it to estimate what I should be spending on things like food or meals out or drinks. The stuff that is easier to change if it looks like I might lose money over the year