hamvocke / dkb2homebank

Convert DKB account CSV files to a Homebank compatible CSV format

dkb2homebank

This script converts CSV account reports from Deutsche Kreditbank (DKB) to a CSV format that can be imported by the personal finance software Homebank.

You can find further instructions on my blog.

How to run the script

The script can convert several kinds of CSV export formats you want to convert. Currently supported are:

• DKB Cash (as of the legacy web portal)
• DKB Visa (as of the legacy web portal)
• DKB Giro (as of the new web portal introduced in 2023)
• DKB Visa (as of the new web portal introduced in 2023)
• DKB Tagesgeld (as of the new web portal introduced in 2023)

I recommend generating CSV files via the new web portal.

To convert a CSV file generated from the DKB portal run:

./dkb2homebank.py yourCsvFile.csv

You can also choose an alternative path for your output file, if the standard in the working directory doesn't do it for you. Use --output-file or -o for that:

./dkb2homebank.py yourCsvFile.csv --output-file ~/Documents/Finances/import_to_homebank.csv

Importing into Homebank

Import the converted CSV file into Homebank by going to File -> Import and selecting the output file you got when running your script.

Note: If Homebank tells you that your CSV file is invalid, go to Settings -> Import/Export and make sure that the Delimiter is set to semicolon and try importing again.

Requirements

To run this script, you need Python 3.4 or higher. I've verified that the exported CSV can be imported successfully on Homebank 5.0.0 and above.

Run the tests

I have included a (admittedly very small) set of tests to help a little bit during development. These tests use Python's unittest module and can be executed using:

./dkb2homebankTest.py

You can also test the script manually by using the provided testfiles:

./dkb2homebank.py testfiles/cash.csv
./dkb2homebank.py testfiles/visa.csv
./dkb2homebank.py testfiles/giro.csv
./dkb2homebank.py testfiles/visaNew.csv