142
edits
Changes
Jump to navigation
Jump to search
better API is available
Since it is cumbersome to enter all incoming and outgoing transactions by hand, it was decided that the Bank statements will be automatically parsed and entered from the exported CSV file.
The generated statements are in CSV format, encoded in Windows-1252/Latin-1 (UTF-8 incompatible), delimited by semicolons, Contain 10 8 lines of headers, and multiple sections delimited by empty lines. The section we are interested in ("gebuchte Umsätze;") maps 6 8 columns:
# DateBuchungsdatum, format "DD. MM. YYYY"# Value date ("Wertstellung"), format "DD. MM. YYYY"# TypeUmsatzart, ("Überweisung", "Gutschrift", "Scheckeinreichung", "Lastschrift", "Inh. Scheck")# Reference ("Buchungshinweis"), contains nameBuchungsdetails# Auftraggeber# Empfänger, free text, bank account number etc.# Amount Betrag ("Betrag"€), the amount of money that was moved in the transaction. e.g. format "-25,00 €", positive if incoming# Balance Saldo ("Saldo"€), money available on the account at this point in time. e.g. 451format "123,99 45 €"
