Email or username:

Password:

Forgot your password?
Gosha

There are few things I dislike more than banking apps, so I wrote this script to take CSV exports from these, normalise the transaction data, and store it in a sqlite file for fun & profit. #babashka #clojure

github.com/goshatch/money

8 comments
Swift

@gosha this is how new banking apps are born πŸ™ˆ

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.

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.

Gosha

@aynish Nice, yours has automatic fetching? I’m not that advanced yet πŸ˜„

ΰ€…ΰ€¨ΰ₯€ΰ€Ά

@gosha hahaha, well semi automated, i didnt run X11 in docker so i kick it off once a week, but it logs in, downloads, and then imports automatically for all my accounts

Go Up