Email or username:

Password:

Forgot your password?
Top-level
BΓ¨r Kessels 🐝 🚐 πŸ„ 🌱

@gosha In the unlikely case that you arent aware of it: plaintextaccounting.org/

I've been doing my accounting on hledger first years now beancount. For over a decade total. Collected a *load of ugly bash scripts, queries, aliases and other stuff over the years.

Guess sqlite is almost as versatile as plain text. But for me the "killer app" has been how well copilot helps when editing my ledger in vim. Makes sense: it's a lot of patterns and repetition. HTH.

2 comments
Gosha

@berkes thank you, I was completely unaware of this movement! I will have to look into it.

My original idea was to preformat things for export into a spreadsheet, but then I thought that SQLite is the way, maybe pushing it one step further and doing plaintext is even better. Let’s see!

BΓ¨r Kessels 🐝 🚐 πŸ„ 🌱

@gosha If it helps, some of my hacks/tools use postgres. It's not the single source of truth then, but makes some concepts easier.

E.g. my investments now have quarterly "price" entries: so a chart of "net worth over time" will be very coarse. Adding daily prices helps, and putting it in a prices.ledger that gets included makes it somewhat manageable. But if I need hourly pricing, which I rarely need, I'll copy it into a postgres db.

Go Up