Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

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

views
     
polarzbearz
post Jul 10 2021, 11:45 AM

Gracie
*******
Senior Member
4,816 posts

Joined: Apr 2007


QUOTE(TOS @ Jun 1 2021, 01:51 PM)
You can befriend polarbearz soon! biggrin.gif
*
QUOTE(Takudan @ Jun 1 2021, 08:31 PM)
Omg, it's almost like I'm shadowing her footsteps HAHA. And I was totally going to ask, why Excel and not Google spreadsheet, and she answered it in her blog lol.

I was wondering if there's possibility of linking to hers but... Honestly mine is more on general management and much less details on the investment portion, there won't be anything worth porting. Two very different spreadsheets serving very different purposes, both grew from very docile creature to a monstrous blob full of dirty codes in the background.
*
Just saw this post by chance!! Didn't get the @tag notification tongue.gif tongue.gif

Must say this is indeed a very comprehensive personal finance tracker, covering almost all the important aspects to manage ones' personal finance. Mine is all over the place as I use different app/sheets for different purpose laugh.gif sweat.gif

» Click to show Spoiler - click again to hide... «

polarzbearz
post Jul 13 2021, 11:22 PM

Gracie
*******
Senior Member
4,816 posts

Joined: Apr 2007


QUOTE(Takudan @ Jul 11 2021, 12:45 PM)
Thank you! Soooo what's stopping you trying out the sheet? I'd love to hear what you have to see what more I can add onto the sheet.

lol for me, the scripts ain't so bad, but what's scary is the cell formulas that I have to cram everything into that one multi-line text box that doesn't have easy indentations, especially conditional formatting that can fit a whole formula in it but they only give you a single line text box to work with. sweat.gif
*
I'm personally a huge fan of YNAB hence sticking with it for now tongue.gif
Huge fan of zero-based budgeting.
polarzbearz
post Jul 15 2021, 12:27 PM

Gracie
*******
Senior Member
4,816 posts

Joined: Apr 2007


QUOTE(wongmunkeong @ Jul 15 2021, 08:46 AM)
ohmy.gif U very detailed & hard working  notworthy.gif - zero-based budgeting will kill me  sweat.gif .

personally, i use Excel + "take-out savings for investing & buffer first" simplified budgeting
ie. i just put aside my net monthly income 20% or 80% windfall income (bonus) and use the rest, and if have extras at month end, throw more into savings for investing & buffer
*
tongue.gif my zero based got abit leeway one I track down to maybe ringgit / tens ringgit level and not down to cents level (eg my YNAB can never tie with my bank account balances)

I only use ynab to ensure that my big items & daily living spends are captured (eg salary, needs/wants, etc) as a form of check & balance. Because otherwise I will end up spending everything sweat.gif

 

Change to:
| Lo-Fi Version
0.0165sec    0.30    6 queries    GZIP Disabled
Time is now: 25th November 2025 - 12:59 AM