Live data from Hacker News

10 years of personal finances in plain text files

sgoel.dev

131–140 of 199 posts

Re: 10 years of personal finances in plain text files

#131
I have been recording every txn with GnuCash for the last 8 years. I reached a point where I started writing scripts on top to support my multi-currency setup.

Then Claude became a thing, and I thought what if I use Hledger and let Claude manage my books ? I was reluctant to migrate years of txns, so I started with an opening balance.

This has been the highest leverage usage of Claude for me. I drop everything: bank statements, invoices, etc and ask Claude to make entries. When it makes a mistake, I add a new rule for future. Privacy issues aside, I cannot go back to traditional tools.

Re: 10 years of personal finances in plain text files

#132
I've been using MoneyMoney for over 12 years now (started Nov. 2013) on Mac and have never regretted it. I am automatically importing from all my bank accounts, including all statements and even track my portfolio with it. It can automatically categorize every transaction (basically string matching with OR clauses) and doing this consistently for years gave me pretty good insights on my spending behavior over time. It's a pity that they don't have a iOS app though.

Re: 10 years of personal finances in plain text files

#133
post #76

I started decades ago using Quicken. Then had to re-enter all my data when a new version came out and support for the old version was EOLed. So I switched to GNU Cash and re-entered everything again. Then there were migration issues with GNU Cash. Finally I discovered PTA. I chose hledger (because of possible performance issues with beancount). I learned double-entry bookkeeping (it's pretty simple, honestly). I writ…

I can't seem to ween myself off of reliance on Quicken. I really want to, and I hate that I am tied to Intuit software. I hate that every transaction I've made since 2000 is stored in a proprietary binary blob. But I can't find an alternative that has cracked the killer feature: Syncing with each of my online accounts. I like to track every expense and every transfer down to the penny, and then update from the bank's…

Have you tried [0] Tiller Finance?

[0] https://tiller.com/

Re: 10 years of personal finances in plain text files

#134
I never found efficiency. For five months I imported and categorized my transactions - from payroll through food. I definitely had reports being generated (using hledger) but the amount of time I invested and the ROI wasn’t there.

Had it been 5m a week, maybe I could’ve done it. But it was 3h/wk - finding transactions, transcoding them with scripts I was maintaining, and breaking down the costs with my wife to understand if Costco purchases were “groceries” or “home”.

I nailed the micro and failed the macro. With two kids, and no desire to invest 150h a year into this, there’s no way I can get this to work.

I imagine AI would be great at:

1. Maintaining scripts to extract and normalize various financial artifacts (PDFs, CSVs, XLSXs) into text files

2. Helping draw insights

But manual effort of:

1. Collecting from various banks, paystubs and investment accounts

2. Ensuring flows net to zero and make sense

Is Too Much Work.

Re: 10 years of personal finances in plain text files

#135
post #6

> 30-45 minutes every single month That's 6–9 hours every year! 5 years: 30–45 hours 10 years: 60–90 hours

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

Arguing is fun though

Re: 10 years of personal finances in plain text files

#136

Earlier quoted context omitted.

FYI, Mint shutdown as a service in early 2024. https://www.cnbc.com/2023/11/07/budgeting-app-mint-is-shutti...

Mint's value to me was destroyed long before 2024; its originally-reliable backend was swapped out for a third-party one (plaid?) and half my accounts couldn't sync -- making it useless. YMMV, but IME Monarch seems like the current best option in this space...

> IME Monarch seems like the current best option in this space...

Monarch is just horribly overpriced. I'm not opposed to paying for a SaaS or anything, but Monarch is much too expensive for what it is. Empower (used to be called Personal Capital) is free and what I use instead of Mint. In fairness, the only thing that I really ever used Mint for was to see my net worth and account balances.

Re: 10 years of personal finances in plain text files

#137
post #76

I started decades ago using Quicken. Then had to re-enter all my data when a new version came out and support for the old version was EOLed. So I switched to GNU Cash and re-entered everything again. Then there were migration issues with GNU Cash. Finally I discovered PTA. I chose hledger (because of possible performance issues with beancount). I learned double-entry bookkeeping (it's pretty simple, honestly). I writ…

I can't seem to ween myself off of reliance on Quicken. I really want to, and I hate that I am tied to Intuit software. I hate that every transaction I've made since 2000 is stored in a proprietary binary blob. But I can't find an alternative that has cracked the killer feature: Syncing with each of my online accounts. I like to track every expense and every transfer down to the penny, and then update from the bank's…

I use MoneyDance, which does automatic bank sync, is double-entry (although you can make single-entry transactions if you try hard enough), and is a program rather than a web service. It’s got some rough edges, but it meets my needs well enough. I haven’t looked into how hard it would be to read its data files if I wanted to migrate away.

Re: 10 years of personal finances in plain text files

#138

Do folks any recommendations for automation around banking? We use a sort of "envelope system" across many accounts, and it would be helpful to have some timing to help automatically move and rebalance funds across the accounts. My bank has some very limited options to move specific amounts of money on a weekly schedule, but I'm looking for something more powerful then that. Should I look at like ~Stripe~ Plaid or so…

Accounts don't have to be physically "real" with your Bank. That's one of the insights of the "envelope system" that isn't always obvious.

One of the benefits to specifically using a double-entry system (including most of the PTA space) is that it makes it easier to build your "envelopes" as hierarchical sub-accounts. Instead of having just Assets:Checking you could have Assets:Checking:Grocery and Assets:Checking:General and Assets:Checking:Entertainment and so forth. The Assets:Checking sum of all of Assets:Checking:* will still reflect your total checking balance for situations when you need to know that information, but the sub-accounts in your double-entry system become your "envelopes" to check on your budget spending and to transfer between.

Automating your budgets can be just a matter of when you get your Income:Salary transaction you split it appropriately between the various Assets:Checking:* sub-accounts you want. You could automate other transfers between them as necessary as well.

You can also automate things like verifying your Expenses:Grocery account always takes funds from Assets:Checking:Grocery rather than any other "envelope" account when paid for by your debit card. (With Credit Cards potentially needing a different level of automation, and maybe a bunch more Liabilities:* sub-accounts.)

Your bank won't have any idea of those sub-accounts and nothing will physically prevent you from overspending those sub-accounts, of course, but also you can automate warnings for that and you would have visibility of that in your sub-accounts "going negative" when you spend too much from the same envelope.

Re: 10 years of personal finances in plain text files

#140
post #54

I've tried to track personal finances several times, but it only started to work when I've discovered the idea (from https://github.com/adept/full-fledged-hledger ) that you need to treat the whole PTA story more like a project compilation: - Everything is managed by build system that is able to track dependencies - Inputs from financial institutions are kept in the repo as is - Those inputs are converted by your scr…

Why is the parent teacher association involved in personal finances?

I’m fairly certain it’s Percutaneous Transluminal Angioplasty
Post reply on HN