Ask Lemmy
A Fediverse community for open-ended, thought provoking questions
Rules: (interactive)
1) Be nice and; have fun
Doxxing, 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 spam
Please do not flood the community with nonsense. Actual suspected spammers will be banned on site. No astroturfing.
4) NSFW is okay, within reason
Just remember to tag posts with either a content warning or a [NSFW] tag. Overtly sexual posts are not allowed, please direct them to either !asklemmyafterdark@lemmy.world or !asklemmynsfw@lemmynsfw.com.
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 info@lemmy.world. For other questions check our partnered communities list, or use the search function.
Reminder: The terms of service apply here too.
Partnered Communities:
Logo design credit goes to: tubbadu
view the rest of the comments
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.