Live data from Hacker News

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

lalitm.com

21–30 of 94 posts

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

#21
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…

Interesting! You might want to try Tabula in that case. For that type of "obfuscated" PDFs I've come across, it does well, it's just a lot slower to run than pdf2text.

It appears Tabula also gets the substituted content instead.

What I'm seeing is that for example, POS is substituted to & !ë on every line in every file, etc. I can see by comparing to the rendered PDF for other common text (like my name, the local supermarket, etc) that those all seem to be 1:1 substitutions too.

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

#22
post #15
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 used YNAB since back when they used to just sell the software and maintained a subscription for a little while. I will say that their approach to budgeting has changed the entire way of how I look at money, and even though I have switched to GNU Cash, I have essentially replicated the envelope method there (it requires four entries per transaction instead of the standard two). For anyone who wants to use this envel…

I've been using YNAB 4 (aka YNAB Classic on Android) for some time. I got a new phone, and the phone app finally won't run on the new phone. YNAB 4 is also quite buggy on my Arch based setup (someone maintains a package on AUR using Wine). So I think it's finally time to move on, which I think I'm doing this year.

My only issue with Buckets is that the YNAB importer doesn't take into account that YNAB will take your overspending and take it from your next month's income. I have some bad habits that means I was really using YNAB as more of a financial tracker than an actually budget system. That's my own fault though. The envelope in question comes out to $-10k... That's all my own fault though. It just means I have to massage it into Bucket's system, or start a new budget.

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

#24
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?

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.

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

#25
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?

It's not really a checksum. It can sometimes function as one (everything should sum to zero, if it doesn't then you have a math error), but since most records you make will just have two entries (spent $25 on groceries, remove $25 from checking account) the everything-sums-to-zero feature isn't going to catch math mistakes most of the time, because there is no math to be done on most entries. Rather, the fact that everything sums to zero helps you track things later on.

To explain that, I'll rephrase, in my own words, the restaurant example from the article, because that was a good example of the concept. Let's say you went to a restaurant with two friends and decided to split the $90 bill three ways, but your friends didn't have $30 in cash on them at the time. You put the whole $90 on your credit card, and your friends paid you back $30 each the next week: one on Monday, and one on Wednesday.

In single-entry accounting you might have written the following transactions:

  Thursday Jan 1st: $90 restaurant (credit card)
  Monday Jan 5th: $30 repaid from Alice (cash) 
  Wednesday Jan 7th: $30 repaid from Bob (cash)
Thing is, there's nothing to link those transactions together. If you look at these entries three years later, you'll probably be left scratching your head as to why Alice paid you back $30: there's no $30 transaction, so the $90 restaurant transaction won't jump out at you as the reason why Alice paid you back.

But with double-entry bookkeeping, you'd write that as follows:

Thursday Jan 1st:

  -$90 restaurant (credit card) 
  +$30 my share of the restaurant bill (expenses)
  +$30 Alice's share of the restaurant bill (money owed to me)
  +$30 Bob's share of the restaurant bill (money owed to me)
Monday Jan 5th:

  -$30 Alice's share of the restaurant bill (money owed to me)
  +$30 cash received (cash)
Wednesday Jan 7th:

  -$30 Bob's share of the restaurant bill (money owed to me)
  +$30 cash received (cash)
It's not always obvious when you're new to double-entry accounting which entries should be positive or negative, but if you remember the "must add to zero" rule you'll be more likely to get it right. Money flowing into an account is positive, money flowing out of an account is negative. For credit cards, the money flows "out of" your credit card and into the restaurant's ownership, so the sign should be negative. When you pay the credit card bill later, the sign will be positive on the credit card account (and negative on your checking account, thus again adding to zero) because money is flowing out of your checking account and into your credit card account.

Now, look at that double-entry accounting. When you look at the Wednesday Jan 5th entry, and you see that Alice paid you back $30, you'll start searching for a $30 transaction earlier, and you'll pretty quickly find the January 1st and figure out that she owed you $30 because you had paid her share of the restaurant bill on the 1st. And even if the amounts don't line up (let's say she paid you $20 on Jan 5th and $10 on Jan 12th), there's still a "money Alice owes me" category which has a +$30 entry on the 1st, then -$20 on the 5th and -$10 on the 12th, all of which makes it pretty easy to figure out what Alice is paying you back for.

So by recording each entry in at least two places (it's not always exactly two places, e.g. the January 1st expense is recorded in four places total), you get more linkage between the items and it becomes a lot easier to see why the money was going out or coming in.

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

#26

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.

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

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

#27

Earlier quoted context omitted.

Thank you for taking the time to reply - thank you! I have question on a more personal front - please feel no obligation to reply. What impact has having such clear visibility into your accounts had on your relationship with your wife? It feels like it would be a great catalyst for communication, trust and building things if shared finances was a key part of the relationship. I think this part was the most inspiratio…

Happy to answer :) > What impact has having such clear visibility into your accounts had on your relationship with your wife? That's a great question. Thankfully when it comes to finances we are very aligned in our habits and goals. So we find it very natural to be open because we know that we're both going to be aligned. Where we differ heavily though is how much we are willing to really getting onto the nitty gritt…

I love that, thank you for sharing.

Would you consider a follow up blog post about how you structure and approach your monthly finance sessions? I understand that it would be well outside of your topics of software engineering, performance and open-source, but I find that the human component of our industry is often missing. An insight into how someone has successfully navigated that would be a wonderful read.

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

#28

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.

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

#29

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.

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 don't penny-pinch, but we still keep some of the grad school "do I really need this?" mentality.

Our normal spending is somewhere under 1/2 of our take-home (including mortgage), so we just don't worry about it and keep saving. It helps that we don't have fancy tastes. It's a nice stress free way of saving and we don't have to get neurotic about tracking every penny either.

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

#30

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.

Accounts (in the accounting sense) are unitless, and refer to whatever meaning we ascribe to them, so we can transfer value from $ to shares, or USD to GBP or whatever.

Lalit describes this I think really well in his article

https://lalitm.com/post/one-number-i-trust/#chapter-4-invest...

Post reply on HN