Saturday, June 16, 2018

Transaction Viewer

I thought it would be interesting to see where my money is going. How much money am I spending on eating out, petrol, clothes, etc. There are a number of services that can do that but they either required too much manual work or they wanted full access to your bank accounts, so I decided to write a small python script myself.

The script loads the account history, which in my case (SEB) comes in an excel-file, and displays the  information in two stacked area charts.


The top one shows incomes over time, in my example data there is only one income, the light blue area. The bottom chart shows expenses over time. You can pan and zoom in the chart, and when hovering over an area details are shown. If you load multiple files at once the script will merge them and remove transactions between the accounts.

You can rename areas by right-clicking them. If you rename two areas to the same name they will be merged. Below I have renamed both "Shell" (pink) and "BP" (light blue/gray) to "Petrol" (light violet). If you rename an area to nothing it will be removed.


Some payments are sporadic, like the green and blue ones, and they kind of screw up the chart if you just want to get an overview of where money is going. To fix this I implemented smoothing. Below is the same chart but with a 12 month sliding average.


The source can be downloaded here.

No comments:

Post a Comment