this post was submitted on 16 Dec 2023
83 points (96.6% liked)

Ask Lemmy

26756 readers
1909 users here now

A Fediverse community for open-ended, thought provoking questions

Please don't post about US Politics. If you need to do this, try [email protected]


Rules: (interactive)


1) Be nice and; have funDoxxing, trolling, sealioning, racism, and toxicity are not welcomed in AskLemmy. Remember what your mother said: if you can't say something nice, don't say anything at all. In addition, the site-wide Lemmy.world terms of service also apply here. Please familiarize yourself with them


2) All posts must end with a '?'This is sort of like Jeopardy. Please phrase all post titles in the form of a proper question ending with ?


3) No spamPlease do not flood the community with nonsense. Actual suspected spammers will be banned on site. No astroturfing.


4) NSFW is okay, within reasonJust remember to tag posts with either a content warning or a [NSFW] tag. Overtly sexual posts are not allowed, please direct them to either [email protected] or [email protected]. NSFW comments should be restricted to posts tagged [NSFW].


5) This is not a support community.
It is not a place for 'how do I?', type questions. If you have any questions regarding the site itself or would like to report a community, please direct them to Lemmy.world Support or email [email protected]. For other questions check our partnered communities list, or use the search function.


Reminder: The terms of service apply here too.

Partnered Communities:

Tech Support

No Stupid Questions

You Should Know

Reddit

Jokes

Ask Ouija


Logo design credit goes to: tubbadu


founded 1 year ago
MODERATORS
 

What budgeting advice do you recommend? Money management method?

you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 3 points 11 months ago

I have an Excel workbook with three worksheets. One worksheet calculates my paydays out over the next few years, and using Excel formulas a table of paydays per month is calculated. I get paid every two weeks, so some months are 3 pay checks and the rest are 2. If you get paid a fixed amount per month it's easier.

The next sheet has tables for annual, monthly, and weekly expenses. The annual table has a column for month of the year. If I have a quarterly payment, I add it to the annual table four times, each with the correct month.

The final worksheet is a basic revenue less expenses table, one for each calendar year. It lists my income per month for each month, and then lists my monthly expenses, my annual expenses that hit that month, and weekly expenses calculated to reflect the partial weeks. All using formulas do it is easy to extend out to future years.

The worksheet also calculated how much I have left over, and what my savings target is (80% of unbudgeted funds). It's important for the actual costs of each month to be accurate, because averages hide real world things, like in November I have a large amount of renewals including my annual car insurance payment. I will always spend more than I make in November, and knowing that means I'm not panicking with unexpected expenses.

What I've found is that there is an art to budgeting. For example, I budget $100/month for discretionary purchases, plus $20/week to take my kids out for cocoa. You want to be specific enough in the budget that you have fairly few purchases not directly accounted for, with a little bit of latitude that it doesn't become a grind to track purchases.

Over the course of the month any purchase that exceeds the budgeted amount or that doesn't fit a budget category gets tracked on a separate sheet so I can see if I need to rebudget or if there was just a one time thing. Generally speaking, if it is too much work to track your individual purchases, you might be making too many small or impulse purchases that add up.

I also use Excel for my shopping lists to stay focused when I go to the store, and the mobile app easily lets me strike through items as I get them.