this post was submitted on 15 Jul 2023
-2 points (33.3% liked)
Personal Finance
3799 readers
1 users here now
Learn about budgeting, saving, getting out of debt, credit, investing, and retirement planning. Join our community, read the PF Wiki, and get on top of your finances!
Note: This community is not region centric, so if you are posting anything specific to a certain region, kindly specify that in the title (something like [USA], [EU], [AUS] etc.)
founded 1 year ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
I was on a spreadsheet for years and recently started selfhosting Actual and importing transactions automatically through email alerts.
Would you mind elaborating on your import pipeline? I was thinking of using email as a trigger as well, but thought it wouldn't work too well.
No problem. I've got every account set to send me an alert on the lowest monetary value it supports (stupid AMEX with its $10 minimum), and I've got rules in my email to move those alerts into an Actual folder.
Then, I use my transaction fetcher to import the transactions from the email alerts into Actual. I look at Actual periodically to categorize the transactions.
It works pretty well for me at this point. I haven't published the image to DockerHub yet, but i think it's ready for an alpha image. Let me know if you have questions or need help (or want to contribute)!
Thank you, that looks awesome!
Do your institutions send alerts with data in a consumable format? I'm in Canada, land of the shitty bank software and it seems I can only get PDFs from most places. I have one that doesn't even let you download transactions outside of the monthly statement :(
I mean, for a given level of consumable. You can see in the
TransactionFetcher.Readers.*
libraries how I'm parsing the data out of HTML emails, which is less than optimal, but it works, at least until they change email formats and I have to make changes.Your neighbors to the south also have shitty bank software, unfortunately.