Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

 Annual budget tracker (Google spreadsheet), For your financial planning

views
     
S_SienZ
post Jul 16 2021, 01:21 PM

Getting Started
**
Junior Member
213 posts

Joined: Aug 2013
QUOTE(Takudan @ Jul 15 2021, 10:27 PM)
How do you plan your one-time expenses then? Say... if you think you'd like to buy a new furniture, or travel overseas. Curious to see how everyone else plans their budget.
I find it so hard to wrap my head around this method lol. First it's something that is supposed to track things down to cents, but at the same time you're not. I googled to catch a glimpse of it, I see it has budget by month, but without dates - how are you ensuring you have your money ready at the right times of the month? Say, it's all budgeted to 0, but next month/budget, you have a lot of expenses coming in early but inflow would be at the end of the month? Does your budget sheet tell you how much you need to ready for the next month?
*
Not the guy you replied to, but I use YNAB as well.

I have various categories of discretionary spending like Fun Money and Stuff I forgot to Budget For (this is very important as a residual catch-all), so those categories are used sparingly for big one-offs to annualize the costs. Fun Money includes travel for me, so if I'm allocating RM500 a month for that, I'll be able to spend RM6,000 on travel if I don't spend it anywhere else.

Re: Early-in-the-month expenses, the trick is to always live on last month's salary. Using this trick will also allow you to keep a 5 month emergency fund rather than 6.

This post has been edited by S_SienZ: Jul 16 2021, 01:28 PM
S_SienZ
post Jul 18 2021, 12:06 PM

Getting Started
**
Junior Member
213 posts

Joined: Aug 2013
QUOTE(Takudan @ Jul 18 2021, 03:59 AM)
Oh actually yes, that's exactly what I do too, in this spreadsheet. Ending balance needs to be more than the next month's total expenses, else you get a red alert. Didn't think about that trick part but I guess now I can +1 month when I tell people how many months of savings I have haha.

Well the idea of YNAB as I understand it, is to have every penny working on something, be it your (future) expenses, or investments. Setting aside some placeholder pot of money sounds counterintuitive especially if you set up multiple of them, but then they're not actually being used in that exact category... It's like later on you need to do a mental math that the RM 6000 you're about to spend on the travel, was already paid for by your past 1 year savings into the Fun Pot.

For my method, though, you can plan out your future travel by simply plotting that RM 6000 on June 2022, and then see the summary telling you how your budget would look like, all the way from now to the end of that year (strictly speaking you'd need 2 sheets for this example as of my post now, but yes, there is cross-sheet linking feature already).

So, I'm starting to understand more now why is it so difficult to convince someone to change their ways of managing their finances, if they already have a system: because the process is so different, it's hard to adapt! I definitely would not want to use that app 😂
*
I guess over the years I've developed workarounds for it which like you said formed a system - I prefer an annualized view of costs (in fact I often do this in my head when buying a large ticket item, divide by 12) as it allows me to have a fixed budget every month regardless of one-off purchases, this takes out a lot of decision making fatigue which is valuable to someone who is prone to analysis paralysis like myself. About money not being "used", I usually park those categories of funds in Stashaway Simple (MMF) so that it is technically "working" in the meantime.

 

Change to:
| Lo-Fi Version
0.0167sec    0.45    6 queries    GZIP Disabled
Time is now: 25th November 2025 - 12:51 PM