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] 2 points 1 year ago (1 children)

Money Manager Ex. It saves the file as a SQLite database, which makes it easy to parse. I have a couple python scripts that extract the numbers, and generate a JSON file with numbers, png graphs using matplotlib, and I have another module that takes the generated graphs, numbers, and a latex template, and generate a nice PDF.

For instance, when the script finds a brokerage account, it separates out deposits / withdrawals from actual P/L to calculate true time weighted returns.

Budget-wise, I look at it on a yearly basis. This is important because some significant expenses have an annual frequency (practice insurance, housing insurance, etc), or bi-annual frequency (car insurance...) And some expenses are discrete frequencies throughout the year (vacation, etc....)

It requires more discipline than on a monthly basis, but the reasoning behind it is if we spend more than we earn on a given month, it is not necessarily bad, because it might just be the month we went on vacation, or the month we had our yearly insurance premium. The important goal is to spend less than we earn on average . So over the long run wealth accumulates naturally. Short term deviations are not important as long as our long term lifestyle is aligned with our income.

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

So your python scripts extract from PDF statements? Did you use a pre-made template and customized it or did you program it from scratch? I track monthly by copy pasting/transcribing from the monthly statements - it takes me about an hour a month on a Saturday or Sunday to fill out and then another hour of contemplating spending.

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

The other way around, I use the script to generate a PDF based on the money Manager Ex file (which is in SQLite format).

Fortunately I am able to download a CSV from most financial institutions, so I never have to parse their pdf.

My workflow is

  • download all CSVs and import in money Manager Ex
  • categorize spending within the software, reconcile transactions, etc
  • run the script against the money Manager Ex file to generate a PDF.

I am surprised you have to copy paste from your monthly statements? Is it possible that on your banks portal, deep into the menus you have an option to download as CSV?

[–] [email protected] 0 points 1 year ago

Interesting thanks. Where I'm from banks don't often offer csv export, I will request the feature.