Analyze .csv from your DKB bank account with Python Pandas.
This is NOT an official tool by Deutsche Kreditbank AG (DKB). It is simply provided-as-is without any warranties, liabilities, etc.
Adapted by GollyTicker. Originally created by blazer82.
- view your balance over the entire exported CSV time-range - or over the last N months
- view pie charts of your expenses and income
- find out your largest expenses to optimise them
- categorise transactions with heuristics (e.g. miete, card_payment, investment, etc.)
- what are the biggest positions within each category?
- privacy: everything is computed locally and offline on our computer. no servers or companies you need to trust
- security: it simply uses the CSV you exported. it cannot access your account in any way.
Select the largest time period on your main Girokonto (3 years) and export it all to CSV.
NOTE: There is a bug (?) in the DKB webinterface where the CSV only returns at most 500 bookings - regardless of how long of a time period you pick. I've contacted them and asked them to fix this.
The notebook may need updating, if the CSV format by DKB has changed.
In that case, please update the code and create a pull request to change it here for everyone.
This tool was shortly discussed on this Reddit thread. If anyone wants to extens the code and perhaps automate the extraction of the CSV from the bank, then this thread contains relevant information.