Author Topic: Tracking expenses with Beancount  (Read 1327 times)

lutorm

  • Pencil Stache
  • ****
  • Posts: 831
  • Location: About the middle of Sweden
Tracking expenses with Beancount
« on: May 16, 2022, 01:21:49 AM »
We half-ass manually went back and added up our expenses for about six months a few years ago, determined there were no surprises and never did it again. Since then we've had two kids, merged our finances, about tripled our net worth, and set a FIRE date for next year. The upcoming FIRE date made it more urgent to actually verify that our expenses still were what we thought they were, so I've been meaning to figure out how to do this. This weekend it was time. I read up on various approaches to expense tracking (Mint, gnucash, etc) and given my profession as a programmer and my visceral dislike of having to hand over our complete economical picture to a third party, I settled on "beancount" (https://github.com/beancount/beancount.)

I'd never heard of beancount before, but I find it really cool. The approach is that all your financial info live in plaintext files that you can edit and generate however you want. Over the weekend I've written importers that can ingest the files exported from our banks, plus from Amazon and Paypal, and generate transaction information. With that set up, it was pretty quick work to import the YTD info and go through and classify expenses, and I can now generate plots like the attached showing where the money goes. It should take an hour or two to process and classify additional activity every quarter or so.

Beancount can also handle tracking brokerage info, like keeping track of cost basis for share lots, etc, but this is much more difficult to import correctly and I don't feel much need to since we have it all in Fidelity and it's pretty easy to see what's going on. The expense side is much more spread out.

Anyway, I searched the forum and didn't see any mention of it so I thought I would point it out if anyone's interested.

oneday

  • CMTO 2023 Attendees
  • Walrus Stache
  • *
  • Posts: 9046
  • Age: 49
  • Location: SF Bay Area, USA
  • only good pies and no bad pies -mspym
Re: Tracking expenses with Beancount
« Reply #1 on: May 16, 2022, 11:04:23 AM »
Is this something a non-programmer could do?

lutorm

  • Pencil Stache
  • ****
  • Posts: 831
  • Location: About the middle of Sweden
Re: Tracking expenses with Beancount
« Reply #2 on: May 16, 2022, 12:25:50 PM »
Is this something a non-programmer could do?
In principle, yes, since all the inputs are just plain-text files. But unless your finances are extremely simple, it would be pretty tedious to manually transcribe the transactions.

A non-programmer can also learn how to become one and how to write some python. ;-) It's pretty simple, but I'm so far away from knowing what hurdles a total novice may encounter that I'm not a good judge of how hard it might be.

If you don't enjoy tinkering with some simple programming, it's probably not worth it.

oneday

  • CMTO 2023 Attendees
  • Walrus Stache
  • *
  • Posts: 9046
  • Age: 49
  • Location: SF Bay Area, USA
  • only good pies and no bad pies -mspym
Re: Tracking expenses with Beancount
« Reply #3 on: May 16, 2022, 10:48:49 PM »
Hm, I think now is not the time for me personally to tackle that. Maybe in FIRE :)