Live data from Hacker News

One Number I Trust: Plain-Text Accounting for a Multi-Currency Household

lalitm.com

31–40 of 94 posts

Re: One Number I Trust: Plain-Text Accounting for a Multi-Currency Household

#31
post #2

Can somebody explain to me the advantage of double-entry bookkeeping? Is it basically just a "checksum" so it's easier to notice when something is off?

Double-entry accounting models the source and destination of funds. If you keep all of your money in one bank account and neither owe anyone or have anyone that owes you, then double-entry accounting is not necessary because you can record just the one side of every transaction – your bank account is the other side.

However, if you have more than one account or debts, or budgets, then it becomes useful to track both sides of a transaction. If you track both sides of a transaction then you can easily answer questions like: 1. how much money do I have in my investment account? 2. how much debt do I have? 3. how much did I spend on recreational social activities?

You can track debts and investments separately, but then you are still making two entries just in two places.

I think many people have few enough debts and investment account that they track these separately, and the third question, budgeting, can be simplified if each vendor is only ever considered for a single budget, for example, all your flights are part of your vacation budget, and you don't care to break out a flight to a career related conference.

Re: One Number I Trust: Plain-Text Accounting for a Multi-Currency Household

#32
post #17

> The key insight is that bank statement PDFs are almost always columnar. Of course, this relies on the PDF having a proper text layer; if your bank sends you scanned images, you’re out of luck (though I’ve yet to encounter one that does). When you convert them to text while preserving the layout, you get something that looks like this: So I decided to try this out with my bank who's export options are (one of the me…

I remember seeing an online shop that did the whole font substitution to prevent web-scraping of their prices.. I think they even changed the substitution between elements so one couldn't just do a single pass replacement and get the original data back..

I guess nowadays it's very cheap to run a headless browser, screenshot the output, and run it through OCR.. hah, to prevent that they'd have to design their webpage as 1 full screen Captcha..

Re: One Number I Trust: Plain-Text Accounting for a Multi-Currency Household

#33
post #17

> The key insight is that bank statement PDFs are almost always columnar. Of course, this relies on the PDF having a proper text layer; if your bank sends you scanned images, you’re out of luck (though I’ve yet to encounter one that does). When you convert them to text while preserving the layout, you get something that looks like this: So I decided to try this out with my bank who's export options are (one of the me…

That's a ridiculously dumb idea on the bank's part.

Print the PDF to an image. Then use OCR. Then import the output from that instead.

Re: One Number I Trust: Plain-Text Accounting for a Multi-Currency Household

#34

Earlier quoted context omitted.

Here is my explanation for "software people who understand databases". The structure of the explanation will be as follows: 1. Explain how you would do simple accounting with a database 2. Point out which indices you'd create for performance 3. Show how the "double entry" part of double entry accounting is about the indices 1. The way you'd do accounting in a database is with two tables: One table for accounts (e.g.…

How are investments modeled in this system? e.g I buy $100 of an index fund which can fluctuate in value.

Not an accountant, so if I get it wrong someone please correct me. But index fund shares are an asset: something you own. So is your car, your house (if you own it), and your computer. When you buy an asset, you paid a certain price for it. When you sell it, you pay a different price. Until you sell it, though, you don't actually have the money, so it hardly matters what its value is until you sell it. If you buy $100 of an index fund and a year later it has grown by 10%, you don't actually have $110 yet until you sell it. So you just track that you have a certain number of shares of the fund. Let's say each share sells for exactly $20 when you bought them, so you have exactly 5 shares. Later the share price is $22, but you don't have $110 yet, you still have exactly 5 shares. When you sell them, then you'll have $110.

So you record two entries:

January 1st, 2025:

  -$100 checking account
  +5 shares VFINX at $20 ea
January 1st, 2026:

  -5 shares VFINX at $22 ea
  +$110 checking account
At this point you have "realized" ("made real") $10 of profit from this asset. You bought it for $100 and sold it for $110, so the IRS wants you to pay taxes on the $10 profit you made. (This is capital gains tax). Until you sold them, some people would consider you to have $10 profit in "unrealized capital gains", but you did not actually have that profit until you sold the shares. This is important to remember, because if you start counting on that $10 profit but then the share price drops because the economy took a hit, suddenly you don't have $110 worth of shares, you have $90 worth of shares, and you'll make a loss if you sell them now. (This is one of the reasons why only the economically illiterate would propose a tax on "unrealized capital gains": that means taxing people for income they have not actually received, but merely could theoretically receive. Which is both immoral and stupid.)

Hope this explanation helps a little. And as I said, if I got something wrong, please correct me and explain how I was wrong; I'm not an accountant. I understand the basic principles, but it's entirely possible I was off on some detail or other.

Re: One Number I Trust: Plain-Text Accounting for a Multi-Currency Household

#35
post #3

I get that people on here don't like subscriptions, and I understand why, but I've been using You Need a Budget for well over a decade, and it is probably the last subscription I'd ever give up. The automatic import of expenses is so valuable for my family and keeping track of how much we've spent and how much we have left for the month. We used the fixed-cost version for years beyond when it was officially supported…

I'm a huge fan of YNAB. It's a morning routine to log in (really, the tab is always up) and reconcile accounts. The zero-based budgeting method, while not requiring YNAB, is beautifully represented in the software. I'm sure I could use some free software to accomplish the basic tasks but having an associated app my spouse can review for quick decision making is very valuable.

It's made budgeting a tool to accomplish savings, wealth growth, and expense smoothing rather than simply a survival strategy. When you have to deliberately shift funds out of one category to cover another, you really consider the relative priorities.

Re: One Number I Trust: Plain-Text Accounting for a Multi-Currency Household

#36
post #9
post #3

I get that people on here don't like subscriptions, and I understand why, but I've been using You Need a Budget for well over a decade, and it is probably the last subscription I'd ever give up. The automatic import of expenses is so valuable for my family and keeping track of how much we've spent and how much we have left for the month. We used the fixed-cost version for years beyond when it was officially supported…

I dont mind paying for a personal finance tool, but I feel like most of them are made for an average consumer who spends in one currency and needs budgeting. I operate in at least 3 currencies, don’t care about budgeting, and need support for tracking stocks and automatic currency conversions. The only tools that were able to provide that were GnuCash and PTAs like beancount. My point is, there is a big segment of pe…

Are the currency conversions automatic, do they fetch the rate of whatever service you're using? E.g. converting USD to EUR on Wise on 28 Dec 2025 surely gets you a different amount compared to doing it on Revolut, or paying EUR with your card (which is USD-denominated), and on Jan 2 2026 the rates are also different..

I was travelling in the Nordics (they had 4 currencies back then, and they still do!) and wanted to have some precision what cash I exchanged with what rate...

Re: One Number I Trust: Plain-Text Accounting for a Multi-Currency Household

#37
post #9
post #3

I get that people on here don't like subscriptions, and I understand why, but I've been using You Need a Budget for well over a decade, and it is probably the last subscription I'd ever give up. The automatic import of expenses is so valuable for my family and keeping track of how much we've spent and how much we have left for the month. We used the fixed-cost version for years beyond when it was officially supported…

I dont mind paying for a personal finance tool, but I feel like most of them are made for an average consumer who spends in one currency and needs budgeting. I operate in at least 3 currencies, don’t care about budgeting, and need support for tracking stocks and automatic currency conversions. The only tools that were able to provide that were GnuCash and PTAs like beancount. My point is, there is a big segment of pe…

I also use GnuCash for a moderately complex set of accounts with many income sources in multiple currencies. Works pretty awesome.

Re: One Number I Trust: Plain-Text Accounting for a Multi-Currency Household

#38

I used to do this during my first real job and was tracking every sandwich I bought, then one of the senior engineers told me to stop wasting time with it and make more money, and then I was enlightened.

Not that a sandwich will make much difference but you have to remember that employers like their staff to be indebted, it makes them compliant.

It is not really binary.

I hate budgeting and still save around half my salary.

Though I do realize that this is a different game for some people, where some need it more than others.

Re: One Number I Trust: Plain-Text Accounting for a Multi-Currency Household

#39

Earlier quoted context omitted.

Agreed this style of making money may have made sense when the world was more Sane but there’s no way to penny pinch yourself into a house in 2026

25 years ago when my wife and I were poor grad students we had to do this. I tracked everything religiously and she cut coupons for the grocery store. We were generally positive about $100/month at best. Tracking it allowed us to not go negative. As soon as we got real jobs with a real income, we didn't waste time with that. Our philosophy now is to just make sure that we spend well under our means and not track. We…

It probably worth at some level not totally losing track of various subscriptions or routine daily purchases. Won’t buy you a house but can be a few thousand a year.

Re: One Number I Trust: Plain-Text Accounting for a Multi-Currency Household

#40

I really enjoyed reading this, and it is inspirational as it is something I have wanted to do for a long time. And as a software developer, it really appeals to me. How do you think it compares time-wise to using existing accounting software? Was the time investment worth it to get the control and visibility you now have?

> How do you think it compares time-wise to using existing accounting software? Author here. I tried various consumer budgeting apps before I ended up building my own (and then going to Beancount). The main problem with every one of the apps I tried is that they don't handle investments well. 99% of my money is invested and having net worth figures which are wildly wrong because the app is only tracking bank accounts…

> The main problem with every one of the apps I tried is that they don't handle investments well.

Could you expand what were you looking for with respect to investments that was lacking?

I use GnuCash for many investment accounts (in multiple currencies) and haven't run into any limitation, it can show me the true net worth graph.

Post reply on HN