- Joined
- Nov 13, 2019
I do this and think it is very much worth the effort. I manually track my spending with a custom spreadsheet on Google Sheets. Having easy access to the info means I'm more likely to use it to inform my purchasing decisions and also more likely to update it regularly, as I spend on things.Do you do this through excel?
Maybe I'm just retarded, but I have a hard time using Mint or YNAB like a lot of milennials do. Though my budget isn't exactly complicated, it is a weakness of mine and I need to improve my tracking.
I have a summary "at a glance" sheet and 12 sheets to cover each month. Spending gets logged here based on budget cagegories I define. Each receipt is a line item and I place the individual items into the appropriate category with the sum of that line equaling the receipt total. I can see if I am close to exceeding my monthly budget and can make decisions based on that. Like if it's worth waiting longer, skipping altogether, or dipping into discretionary savings. I don't include things like monthly bills, just purchases and non-recurring expenses. The reward for spending less than my budget is that, after paying all my bills and leaving a buffer in the checking account, I get to add that surplus to my savings, a portion of which is specifically for me to spend on things that aren't budgeted for.
At the end of the year I can assess if my budget needs to change or if my allocation of that budget needs to change based on that data. Then I start a new one for the next year, leaving the old ones there in case I need to see how my spending is changing over time or maybe see how much a trip I took cost me last time verses this time.
It was very helpful when I was starting out on my own and needed to acquire a bunch of stuff and start paying off debts. It kept me second guessing any purchases and delaying things until later dates. At this stage though, my actual necessary expenses are pretty low so it's mostly just informational and a way to check when I'm going a bit overboard on discretionary spending.
There are existing excel sheets designed for this but since budgeting is pretty different for each person. I think it's better to just build something for your specific needs from scratch and reference other people's work for inspiration.