this post was submitted on 15 Jul 2023
34 points (84.0% liked)

Personal Finance

3748 readers
11 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
 

Do you track your expenses monthly? Annually? Do you have an app or do you use an excel spreadsheet? Any suggested tools?

I use a spreadsheet and track monthly.

you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 3 points 1 year ago (1 children)

I was on a spreadsheet for years and recently started selfhosting Actual and importing transactions automatically through email alerts.

[–] [email protected] 1 points 1 year ago (1 children)

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.

[–] [email protected] 1 points 1 year ago (1 children)

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)!

[–] [email protected] 1 points 1 year ago (1 children)

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 :(

[–] [email protected] 1 points 1 year ago* (last edited 1 year ago)

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.