Welcome to today’s daily kōrero!
Anyone can make the thread, first in first served. If you are here on a day and there’s no daily thread, feel free to create it!
Anyway, it’s just a chance to talk about your day, what you have planned, what you have done, etc.
So, how’s it going?
I have been busy lately, my partner and I decided we needed to do a better job at knowing where our money is going…so we have started to compile a budget.
I am writing a script to process the CSV files from the bank and turn them into a Beancount ledger. After a bit of trial and error, I decided to not use the built in methods for processing files, as I wanted more automation.
My script uses Python/Pandas/SQLite to process the incoming files and automatically code each transaction into categories. From these processed files (95% done); I will produce the ledger format that Beancount wants.
Nice! I use Excel and a VBA script to categorised things. It’s pretty much a VLOOKUP but done with VBA for speed, flexibility, and customizing.
That’s cool. We usually do one that covers a year but I just use exel.
Started with spreadsheets… Then I discovered beancount
Maybe I should look into that…
I’m getting close. My import scripts have a little massaging left, the auto allocation to groups it pretty much done.