Import DKB transactions

[Daniele Nicolodi]

Hello,

I suspect that on the list there are other DKB customers, thus I would
like do ask advice about the best way to import DKB statements into a
Beancount ledger.

Unless I am missing something (not an very unlikely possibility) it is
possible to download the bank statements only in PDF form. A list of
transactions is CSV form can only be obtained from the web interface,
but there is no easy way to get a CSV file for each PDF statement
without having to match the start and end dates manually.

I usually prefer to import from the bank statements and archive them. In
this case the PDF files are the best choice (I convert them to text with
pdftotext and parse the result). However, in the case of the checking
account, the CSV files contain more information, and the information in
the PDFs is scrambled. For the credit card account, the issue is the
reverse: the PDFs have the complete information but the CSVs have the
payees all scrambled.

Which sources do others use to import transactions into Beancount?

Thank you.

Cheers,
Dan

[Siddhant Goel]

Hi Dan,

I assume by DKB you meant Deutsche Kredit Bank?

If that's the case, I've been importing CSVs for a few years now - for both EC and credit card accounts. I generally tend to ignore the PDF statement files (I download them but use the CSVs instead to import data into the ledger). The beancount-dkb package from PyPI (https://pypi.org/project/beancount-dkb) has worked quite well so far.

You're right that CSV downloads can only be obtained from the web interface. The credit card account exports are certainly sparse as compared to the EC ones, although to be honest I've never ran into scrambled payee information in CSVs. Could it be an encoding issue? Just a guess.

Cheers,

Siddhant