Live data from Hacker News

10 years of personal finances in plain text files

sgoel.dev

11–20 of 199 posts

Re: 10 years of personal finances in plain text files

#11
post #5

I have 14 years of personal (and 2 years of sole proprietorship) finance data in beancount. I tried all the available personal finance apps there are, from cloud/online offerings to offline apps. Eventually, I settled on beancount because it is the most versatile file format. In addition to tracking finances, I can track stocks, unvested RSU grants, vacation hours, and even personal training I have paid for but yet t…

it's good (even novel) if you're a dev or are used to working with this kind of interface.

But for the vast majority of people (even including devs), this will not be ideal at all and most people don't really care about it being in text files.

What I'm trying to say is that its designed for a very specific niche userbase and I doubt most people will have the same experience as you described after trying every single personal finance app to settle on this.

Re: 10 years of personal finances in plain text files

#12
post #8

Earlier quoted context omitted.

wow, a whole workday a year! People spend more time arguing on the internet in topics of no impact to their lives each year.

I'd still consider that toil (repetitive, manual, automatable work).

the beauty of beancount (and other plain text accounting ledgers) is the ability to automate them. I also have to go over my accounts in my bank app's automatic categorization and revise them every month, as some transactions get mislabeled.

Re: 10 years of personal finances in plain text files

#13
post #2

This seems to be, in effect, advertising for a book about how to use the underlying FOSS software to do this. I would be okay with that as a monetization model, except that the book author despite being a self-described FOSS dev doesn't seem to have anything to do with the project ( https://github.com/beancount/beancount/graphs/contributors ). Ah, not quite true. The author fixed a typo in a docstring once ( https://…

Oh no, someone might make some money off work they did that was related to work a different somebody did! What a travesty! Somebody stop him!

I know money is the root of all evil and all that, but a total aversion to it isn't a very healthy way of interfacing with it at all.

Re: 10 years of personal finances in plain text files

#14
I've been beancount'ing for years now

As we've crossed into the new year I've switched to a similar directory setup as the OP with 1 file per year. Previously I just had one file that was from 2022 which ended up being like 2 million lines of text, which was starting to bog down the emacs plugin.

What I appreciate the most about this approach to personal finances is it just tracks everything. Investments, pensions, RSUs, bank accounts. You could even go as far as accounting for any resource that's modellable, e.g. energy usage in kwh vs. bills. I probably wouldn't go that far though :D

Also you can build a bunch of tooling around it too, with the advent of LLMs my toolset for beancount management has expanded quite significantly. Most recently I got claude to rewrite my transaction rules engine https://djharper.dev/post/2025/08/19/using-llms-to-turn-scri... into something nicer with a UI. This would have taken days to build in the before times, and I probably would not have bothered because it's overkill for 1 user (me)

Re: 10 years of personal finances in plain text files

#15
Having all transactions in bank accounts makes it trivial to regularly export statements and parse them into financial insights.

I made a tool that parses transactions (of my specific bank) into categories based on tx description and a GUI to analyze them in different time frames.

Highly recommend.

Re: 10 years of personal finances in plain text files

#16
beancount is definitely fun. I also jumped on this bandwagon in 2025 and it's been a great archaeology experiment of digging through old emails and trying to find as much data as I can about what the heck this random checking transaction is from 2012.

I think a nice thing about beancount is that given how simple it is you can almost even ignore whole parts of it. In my case I chose to write my own importing tooling essentially without learning at all about the built-in one: https://github.com/Julian/alubia. I had no intention to make that approachable for lots of users not named me (in fact none of my actual importers are present) but it's been very fun to watch my ledger get more and more accurate.

Re: 10 years of personal finances in plain text files

#17

I've been beancount'ing for years now As we've crossed into the new year I've switched to a similar directory setup as the OP with 1 file per year. Previously I just had one file that was from 2022 which ended up being like 2 million lines of text, which was starting to bog down the emacs plugin. What I appreciate the most about this approach to personal finances is it just tracks everything. Investments, pensions, R…

I have my electricity bills tracking into a KWH commodity. It has been... effectively useless :D.

Re: 10 years of personal finances in plain text files

#18
I began with PTA recently. I think the barrier to entry is high because you first need to learn double entry bookkeeping (if you haven't already) and then you need to decide between ledger-cli, hledger, or beancount, with the differentiators being on the margins and with some promise of being able to switch later. The choice really comes down to which tool has the documentation/community that makes the most sense to you at the time.

Then, there's the import workflow: which "accounts" should you start with? How much history do you pull in? How do you set up an automatic importer? Hledger has a DSL. Beancount uses Python. Either way, an OP says, much of your time is spent manually editing text.

And finally, then what? Can I make a budget now? Will this thing do my taxes? Am I more financially responsible? How do I explain this to my spouse? My pension is kind of like a commodity, but I don't know what the unit price is, and I don't sell units, but what's a virtual PnL and what if I only have a quarterly PDF!?

It may sound like I'm ranting, but I have found that realizing I don't know the answers to these questions (or even that they exist) is the true benefit of PTA.

Every year, I'm asked if I want a different pension investment mix or if I want to change my car insurance. Or, I might wonder if I'm getting a good deal on my internet plan or if a new job offer's total comp is actually better. Am I "on track" for "retirement," how long until I have enough for a new roof, am I keeping up with inflation, did I spend too much on gifts this year?

There's immense privilege in not really needing to know the answers to these questions; getting them "wrong" won't really hurt you. But, being familiar with the routine minutiae of your economy by way of counting every cent, is rewarding, enlightening, and empowering—even if it's also finicky and brittle sometimes.

I may have to try beancount again. OP's importers look promisingly robust compared to my hledger scripts.

Post reply on HN