Live data from Hacker News

Ask HN: How do you record your personal finances?

news.ycombinator.com

21–30 of 52 posts

Re: Ask HN: How do you record your personal finances?

#21
After years of trying to find something that works for me I've finally found a stack that works. The big issue I had was that I wanted something that could import my bank statements. I found one of this issues here was that the bank transactions had no id's so I couldn't tag the duplicates. Then I found most banks allow you to export to ofx. This has ids and it has the balance at the end of the statement. So I could auto import and de-duplicate. I started to write my own thing but then I remembered something my boss taught me "Only write software as a last resort". Basically meaning most problems are already solved only write custom software if its really needed. So I looked around and found ledger autosync (I love this tool). Then I use hledger for my actual accounting. I rely heavily on automated transactions and virtual accounts to do an envelop style budget. But its been amazing. I've been thinking about documenting the work flow. If you are interested ask on this comment and I'll put something together.

Ledger likes are not for everyone. I'd actually say they not for most people, but I truly love the simplicity and flexibility. But I'd be using a text based email client if it wasn't for everyone sending html emails, so I'm a bit weird. That said having plain text files that you can manipulate is amazing. I don't know why but with Gnu-cash I was always unsure about using import tools and trashing my db. But with hledger I can try something and just roll back in mercurial if I don't like it. I'm sure I could have made copies of my Gnu-Cash files but I just feel more in control of hledger. Also hledger allows for things like automated transaction that simplify envelope budgeting.

With auto sync and hledger, I've gone from my budget taking 1 - 2 hours a week to 10 - 20mins. No more hunting for that one typo that meant my budget didn't balance with my bank balance.

Hledger has also been fantastic as far as help. I've jumped on IRC a few times for help and bug reports. The lead dev has been amazing. Fixing bugs the same day and offering help on using hledger.

There are some great resources here https://plaintextaccounting.org/

Auto sync is here https://github.com/egh/ledger-autosync Hledger is here http://hledger.org/ How to do envelope budgeting with ledger likes https://frdmtoplay.com/envelope-budgeting-with-ledger/

Re: Ask HN: How do you record your personal finances?

#22

Here's a practical approach that have been working well for our family. Forget about recording your transactions, it is way too tedious. The solution: Use 'jars' for budgeting. Our jars are bank accounts. First we have a main bank account where money comes in. Set all recurring bills (eg. rent, utilities, phone) to direct debit from this account. Let's call this income account. Leave the debit card at home, don't use…

I did this for a very long time and would recommend. But now I have only one account as it lowers my mortgage payments by having all my savings in the one account and that account being my home loan. So now I use hledger. But your way is still way easier. It can get a little hard to track the number of things I do. At present I have 20 something jars.

Re: Ask HN: How do you record your personal finances?

#23

keep it simple. use mint.

This is basically offloading the record keeping to the bank. However, in an environment where the cash transaction is king, using this method has little value.

People still use cash? I don’t think I’ve made a cash purchase in the last 5 years.

Re: Ask HN: How do you record your personal finances?

#25
Start with double-entry accounting on paper, until you don't learn anything new going through the process. Then you'll be in a position to pick an automation system that works with your process.

You'll need two notebooks:

Start with a transaction journal, where you record your purchases -- amount, how you paid, what you bought, etc. For most things, this is as simple as taping the receipt in.

Your account book has one page per account (method of payment or expense category). Once a week, subtotal all the new transactions by account. Make sure the subtotals balance (sum(expenses) = sum(payments)), and add a line to the relevant page in your account book -- Dates of transactions covered (to crossreference with the journal), subtotal amount, running total.

Re: Ask HN: How do you record your personal finances?

#26
I use excel. My goal is to find out my monthly costs of living and how much I spend on extras like holidays and repairs.

Recently I have greatly simplified the process. It helps to have a separate contactless card (eg Revolut), everything spent there goes into the monthly living costs column, I don't care about the details.

Re: Ask HN: How do you record your personal finances?

#27
post #21

After years of trying to find something that works for me I've finally found a stack that works. The big issue I had was that I wanted something that could import my bank statements. I found one of this issues here was that the bank transactions had no id's so I couldn't tag the duplicates. Then I found most banks allow you to export to ofx. This has ids and it has the balance at the end of the statement. So I could…

> Then I found most banks allow you to export to ofx. This has ids and it has the balance at the end of the statement.

Watch out with that. Unless you verify the output format yourself for a few months, don't trust the exported ofx files. I haven't seen one bug-free yet, but I've found: wrong values if memo contains numbers, bad date format (minutes used for month), missing IDs, duplicated IDs, IDs generated with every download, dates changing after processing, and some others.

I processed ofx files from a few banks and in the end reverted to CSVs. They're less broken...

Re: Ask HN: How do you record your personal finances?

#28
I had too many transactions to annotate without going insane. Currently:

- chrome headless downloads CSV with transactions from every bank account and every card

- everything's appended to an airtable database

- script sorts transactions into categories (specific: "local joe" is groceries and generic: "restaurant" is eating out)

- anything not annotated can be done manually later

- another script generated graph using Vega https://vega.github.io/vega/

It took time to set up, but I'd really rather script this than manually tag every $ spent. Also there's no way I'm giving a third party my bank credentials. Common bank APIs can't come soon enough.

Re: Ask HN: How do you record your personal finances?

#30
I have been using buxfer.com so far. What I really like about it is that I need to manually enter only cash transactions. I can link my bank accounts and it will automatically record all credit card & bank transactions - I only need to categorize them. However of late they have been unresponsive to support requests. I wonder if there is even anyone working on the product.
Post reply on HN