The moment I start talking in terms of liabilities, virtual accounts, etc. their eyes light up!
Incidentally, Accounting and Software have a lot in common. They both build and apply abstractions to the "real world" (flipping-bits), in order to give the abstraction-wielder more power and insight.
Can you expand on this slightly? One of my frustrations with personal finance tools that I have tried in the past is that they're really bad at modelling occasional expenses— for example as a low-car family, we only fuel our vehicle once every 4-5 weeks, so some months the "gas budget" goes unused, whereas other months if we take a trip, we'll completely blow the gas budget because we fuel up twice or three times.
I wish it were possible to "smooth" those kinds of expenses into an average daily amount, but also have a way of indicating that a particular chunk of them should actually be extracted from the smoothing and assigned to a different category altogether (eg, the gas used on the trip should go to "vacations", not "vehicle"). A similar thing applies with other bursty things like home repair expenses, where I'd like my Home Depot receipts amortized over a time period that I specify rather than counted right at the moment of purchase.
I also run a janky Python script which imports my various .csv files, detects which is which, and turns them into ledger entries.
So a vacation stop at a gas station would look like this:
2021-01-01 Chevron
Assets:Checking $-100.00
Expenses:Auto:Gas
So lets say I know I spent $40 of that on food, and want to put another $40 into the vacation budget, I modify like so: 2021-01-01 Chevron
Assets:Checking $-100.00
Expenses:Food $40
Expenses:Vacation $40
Expenses:Auto:Gas
And it puts the rest in the gas budget.There are ways to report average expenditures and smooth them out, ways to report how many days between each purchase in a particular category or from a particular merchant, and so on. Want to amortize a particular purchase? No problem, it's a periodic transaction.
ledger-cli can do accounting, really if there's a question about your money or a way you want to keep track of it, it's covered. Several graph libraries can ingest ledger files.
I use YNAB for budgeting and they basically advise what you're requesting - figure out what the "average" is over a given period of time and just budget that amount. Say you contribute $200/mo to an all-encompassing gifts budget, you may only pull from it a few times a year but the money is already earmarked.
Amortizing things doesn't make sense for a home budget - the whole point is to know whether or not you have enough money for x.
I would say it's very hard to budget for bursty things on a monthly cadence. You can have a "virtual account" for this stuff, that fills on months with little activity and drains on months with more activity. But this is kind of complicated and might not be worth it.
I'd try answering the question: what is your goal in budgeting for gas, for example? Is it to keep gas spending under control? Or to understand how much you spend on gas? And if you want to understand, why? Budgeting is a solution to some answers to these questions, but not all of them.
Personally, I find it more useful to track these things, than to budget them, if that makes sense.
For example, I want to know how much I spent on rental cars in 2020, because that impacts our decision to lease a car in 2021.
> a way of indicating that a particular chunk of them should actually be extracted from the smoothing and assigned to a different category altogether
In GNU Ledger, you can apply arbitrary categories to each expense, and you can also "tag" line-items. For example, if you think 80% of your last refill was from a trip, you can do as follows:
20201/01/12 * Chevron
Expenses:Travel:Car:Gas $16.00 ; :vacation:
Expenses:Travel:Car:Gas $4.00 ; :commuting:
Liabilities:CreditCards:AppleCard $-20.00
You can then do queries to see which of your gas came from commuting, and which came from vacation.You can remove vacation from your reports altogether, and you can also focus exclusively on each vacation. You can even tag vacations, if you so choose.
; :vacation:lasvegas2021:
> amortized over a time period that I specify rather than counted right at the moment of purchaseYou can achieve this behavior by specifying "effective dates" for certain purchases.
For example, when I buy plane tickets, I like to amortize the cost of that ticket over each day I'm at my destination (similar to your home depot example).
2020/01/11 * American Airlines
; three-day trip to Colorado
Expenses:Travel:Plane $80.00 ; [=2020/02/01]
Expenses:Travel:Plane $80.00 ; [=2020/02/02]
Expenses:Travel:Plane $80.00 ; [=2020/02/03]
Liabilities:CreditCards:Apple $240.00
The dates in the comment are called "Effective dates". You can ask for reports to be presented with either effective dates or transaction dates, at query-time. Note that the credit card payment's effective date is identical to the transaction date.Let me know if you have any further questions! It's a fun topic.
However, reporting average expenses is easy, and sometimes enough..
I’ll add that it’s also delightfully easy to get started.
As an application, Accounting is kind of like Vim or Excel or other tools with steep learning curves and nirvana at the end of them.
You can start by just tracking one bank account by hand which is easy enough and fun, because you’re still learning how this accounting thing works.
Pretty soon you’ll be tracking your investments, ISOs, taxes, credit card points, and so on as absurdum. You’ll be the person who finds the bug in your employer’s W-2 generator...
It’s a steep time investment, but once you’ve written the automations, it’ll take you maybe 30 minutes each month. And you’ll never experience the feeling of “not being in control” of your finances again.
Some investment brokers will only give you PDFs with tables in them. But there are some pretty amazing libraries for converting these into CSVs, that have worked well for me.
Some people use plaid, but I didn’t like the idea of introducing a middleman-dependency.
What I’ve been doing over time is downloading all of the raw transaction history I can get, and storing it in a git repo. Each month when I “top it off”, I just use git add -p to add only the latest bits. The most annoying part is when they change their CSV format on you (Chase did this recently) and you need to reformat all of your historical data to match.
Now I have a Postfix server setup which accepts the daily transaction summaries they send and makes CSVs out of those. There's still some HTML munging involved but I've found it much easier to let the data come to me than to go out and try to fetch it myself. In my experience financial institutions simply don't have a lot of reliable automation options accessible to the normal consumer.
There's an Open Financial Exchange (OFX) standard that's supposed to be for this, I think. I came across it when someone mentioned the ledger-autosync [1] tool that tries to use it to get your data from your bank automatically. If I understand correctly (no guarantee on that), this automation would work for institutions listed here [2].
[1] https://github.com/egh/ledger-autosync [2] http://www.ofxhome.com/index.php/home/directory/successfulRe...
The submitted page links back to a previous discussion on HN:
https://news.ycombinator.com/item?id=12119050
Funny enough the top comment on that discussion concludes:
> I now focus my efforts on income expansion rather than cost control. Some of you may say, recording costs is not controlling it. In that case, I find accounting, even less useful (once I have arrived at approximate cash outflow). Income expansion, puts me in a different frame, which I find strangely empowering. Even more so than the satisfaction that comes from having controlled costs.
Previous HN submission : https://news.ycombinator.com/item?id=2298471
But almost more importantly: if you're a programmer, it's really very fun! Like, i have my own system where I download my bank statement as a CSV and process it in AWK together with an org-mode table of payees that map each line on the bank statement to an account, which then generates a ledger file. Since it's just you using it, you can make it so it works however you like, and it quite satisfying to see it all come together.
It's also a great way to learn about accounting. Turns out, I really kinda like accounting! It has many of the same pleasures of programming or math, and seeing everything balance is very satisfying. In short: if you're a programmer who feels like they haven't quite got a handle on their finances, I can't recommend plain text accounting highly enough.