Calculates your monthly total expenses and income by scanning your bank account transactions.
Takes as input a transaction file generated by your bank app.
Up until now all tools that help you calculate your monthly expenses require you to collect and enter them into some sort of expense calculator. This requires a lot of effort and is error prone. This script extracts the information directly from your bank account transactions. It will work well even if you have multiple bank accounts, investments and credit cards. The only condition is that all your expenses eventually land in your current account. This is the case for most people.
Contributers are welcome to add support for various banks file formats.
Run as follows in Windows Terminal:
python expenseCalculator.py Current Account_29052022_0749.xlsx
You can run it in Windows cmd, but it does not support languages other than English. however, Windows Powershell supports other languages. See testScriptForPowerShell.ps1 for examples.
Requires Python 3.8 or above.
Libraries that may need installing:
python.exe -m pip install --upgrade pip
python.exe -m pip install -r requirements.txt
or
pip install pandas
pip install openpyxl
pip install matplotlib
pip install parse
For pdf statements only:
pip install tabula-py
Also install Java from
Windows: https://www.java.com/download/ie_manual.jsp
Linux: sudo apt install default-jre