This december I decided to give YNAB [1] a try.
I was skeptical at first, but now I'm a convert. They have a lot of material on how to budget in a very simple way. But I think the moment their system clicked for me was when I noticed I was using Categories "wrong". Let me give an example.
Say my wife and I go out for dinner and movies. Previously, my expenses would look like:
Transportation - $20
Cinema - $40
Restaurant - $60
The categories are directly tied to what was purchased. That made sense, but this is focusing on the wrong level IMHO. It's not what was purchased, but why? With YNAB, my expenses look like:
Date Night - $120
The important isn't where the money was spent, but the reason you spent it. Paying a taxi to go to work is different than paying a taxi to go on a date.
This seemingly simple difference changed the way I view my budget. The categories are meaningful for me, and not just the standard "Groceries", "Transportation", "Rent", etc.
I have been using it just for one month, but I love it! I highly recommend you to give it a try.
That said, making that viable has involved a slowly-evolving ecosystem of supporting tools. For example, I wrote a set of libraries that leverage the free Plaid tier ( https://plaid.com/ ) to automatically fetch bank and credit card transactions, and apply them to the ledger journal. I also wrote a script that takes a schedule and projects out future transactions to the journal, so I can define recurring transactions and view their impact on accounts projected into the future.
The combination of this means that viewing my current reality is easy, and viewing the impact of known future expenses (largely recurring bills/obligations) is easy. That’s been the single largest factor in enabling my long-term money management, because it’s given me confidence in the numbers, which has let me tune things like automatic 401k payments and automatic transfers to savings. I can move the maximum amount of money into long-term-storage because I always have a clear picture of “how much money do I need to keep out to account for my bills/expenses”
Turns out this idea is pretty powerful in personal budgeting too. I have a Google Sheets document with these columns (item + months):
Item|1|2|3|4..|11|12|Year
And I split the item categories into Income, Expenses, and Once-off expenses. I put all my recurring inflows into income, recurring outflows into Expenses, and Once-offs is a free form where I enter non-recurring purchases like a new computer or such.
On top of each month column I carry over the previous month's net income, then add income minus expenses minus once-off expenses. This is "cash flow". The goal is to aim to be cash-flow positive every month, and also to maximize the year-end net income -- which then gets invested or carried over to next year.
It then becomes a game to try to optimize the year end net income by doing course corrections every month, while maintaining a non-negative monthly net income.
(incidentally this is also how many businesses are run; well the conservative ones anyway)
Categories would be housing(includes utilities), transport, food, children(or pets or parents or ‘others’, if any), fun, medical/emergency(if not covered), taxes and insurance, savings.
You will see that some are fixed and some can be variable. You can only trim those that are variable.
Automatic transfers for the fixed and recurring expenses.(these can have a fixed ceiling. Like for utilities or gas etc).
For the variables like food and fun, assign different credit cards to them. That way you can track exactly how much you spend on food and when you change your behavior, you can figure out if it’s working for you and even make changes in the short term.
What I notice she does is some sort of 'envelope' method, where she has many envelopes, and for every bill she puts the amount needed, in cash, in the envelope. This way you know you have all your bills paid and anything left in your accounts you can use to invest or have fun with. When it comes time to pay a bill, you can either pay it with the cash, deposit it into your account and write a check or put it in before you pay online/phone or however you pay your bills.
She can re-use the same envelope for each month on reoccurring bills, and have some for special events/budgets or a vacation fund envelope. Birthday funds, Christmas etc.
I think physically seeing the bill money separated out of the accounts really helps you know how much left over you have every month to play with.
- Works on the phone and on the computer.
- The data can be synced to a server which stores it encrypted by your password.
- Cheap or single payment.
While some comments are suggesting YNAB and it looks great, $12 is a bit expensive for a personal budget app, also, they encrypt their data on their servers instead of encrypting it with our password before uploading the data.
budgetwithbuckets.com also looks promising, I like the unlimited free trial and it's single payment model, but it doesn't have mobile apps, which makes not much difference than storing the data on excel.
https://www.personalcapital.com/
https://www.reddit.com/r/personalfinance/comments/4gdlu9/how...
https://i.imgur.com/u0ocDRI.png
The best tools and processes are the ones you'll stick to.
There are, of course, a few free options that do a lot of the same things, but YNAB has been working for me for a long time and is well worth the money.
The project isn't quite where I want it to be, but it's getting close. The next thing to improve is support for banks that only allow users to download an N month window of transactions. Probably I will save each download to a timestamped file then merge them in-memory before the next stage in the pipeline. The source code for all of this is here: github.com/tmerr/bank_wrangler. I don't expect it to be useful for anyone else verbatim but it might give you some ideas or something to fork from. Disclaimer: banks might not be happy about web scraping / using undocumented APIs, so don't mindlessly fetch data without understanding that risk.
Maybe once a month or a quarter, I'll look at my savings and redistribute to investments or splurge on something nice.
All of that said, I really don't spend a lot of money. My biggest expense is that I buy lunch 5 days a week. I don't buy a lot of other things... so I guess this works for me.
If you want to know more about how all of this works, I recommend "I Will Teach You To Be Rich" by Ramit Sethi. It's pretty easy to read and walks you through all of the above. Worth more than it's $10 or whatever.
I make a spreadsheet called 'Budget YYYY', typically some time between October and December I make the next year's version, and then these for each month.
The control panel tracks income, where it goes, what was budgeted and what was actually spent.
The Credit Card Balance sheets I use twice a month to get all balances, prompt me to review all statements, and mark all of that off. It’s self-contained and doesn’t impact the rest of the budget.
Income this period gets money added in when I get it.
For spending, I track a couple of categories:
- Yearly / Bi-Annual Bills: Anything that happens not monthly. Domain registrations, car insurance, etc.
- Variable recurring bills: things that I have to pay, but don’t know how much they will be. Electric bill, water bill, etc. I rough-estimate these, and the longer I’ve lived at a place the more accurate I get.
- Static Recurring Bills: Things that are the same every month. Rent, subscription services,
- Grocery Expenses: Anything related to grocery shopping for food / household supplies.
- Restaurants: I explicitly break restaurants out into its own category to better let me see how much money I spend eating out, this is new this year.
- Travel Expenses: When I travel for work, I track things here, and then track the reimbursement.
- Other: Random spending money.
Then for savings I have boxes for:
Savings Account Deposits: I keep a number of savings account set aside for specific purposes, I record deposits into them here.
Savings Account Withdrawls: If I’m using extra money this month for something, I add it as income, and then debt it as a savings account withdrawl. For example, Christmas I made a withdrawal for money from savings, then added it as income, then recording the items bought under “Other”.
Thinking of giving up and just using GnuCash on desktop now.
PocketSmith holds my personal budget. It takes some getting used to and dedicated time to learn, but it’s been well worth it to me. YNAB was too simplistic for my needs, however it may be just the right fit for someone else.
