Skip to content
Developer

Bank transactions as CSV

You import bank transactions from a CSV file that is not in CAMT format.

Format
CSV (comma or semicolon), UTF-8
Access rights
Administrator, write access to payments
Example files
Bank_Umsaetze_beispiel_technisch.csv (technical column names)
Bank_Umsaetze_beispiel_anwender.csv (German column names)

In short: For bank exports that are not in CAMT format, vynst takes over the transactions if the file has the right columns. Duplicate bookings are recognised and skipped.

What you need this for

Your online banking exports the transactions as CSV, but not in CAMT format. With this import, the transactions still arrive in vynst.

Before you start

  • Rights: Administrator with write access for payments.
  • Beforehand: If your export is in CAMT CSV format (Sparkasse), please use the import “Bank statement CAMT as CSV” (Kontoauszug CAMT als CSV).

Prepare the file

  • File name: The name must contain .csv and at least one of these words: Bank, Zahlungen, Transaktionen (upper or lower case does not matter). AFS_BANK_TRANSACTION_ also works.
  • Header row: The following columns must be present, even if individual cells are empty:
Column in the header row Also recognised as
Buchungstag Buchdatum
Valutadatum Valuta
Betrag
Verwendungszweck Zweck
Buchungstext Buchungste
Beguenstigter/Zahlungspflichtiger Name
Kontonummer/IBAN Kto/IBAN A
BIC (SWIFT-Code) BLZ/BIC AG
Glaeubiger ID Gläubiger-
Kundenreferenz (End-to-End) Ende-zu-En
Sammlerreferenz Sammler-ID
  • Important: None of these columns may be the last column of the header row. Each name must be followed by a separator.
  • Separator: Comma or semicolon. If Buchungstag or Buchdatum is written with a comma in the header row, comma applies, otherwise semicolon.
  • Date: 01.03.2026 or 2026-03-01.
  • Amounts: 1.234,56 with a comma as decimal separator.

Columns used for the import

Column Required Content
Buchungstag yes Date of the booking.
Betrag yes Amount.
SH-Kennzei no Indicator S or - makes the amount negative, H or + makes it positive. Other values cause an error.
Verwendungszweck yes Name of the booking. If the column is empty, Verwendungszweck 1 to Verwendungszweck 14 are combined.
Beguenstigter/Zahlungspflichtiger or Name yes Name of the counterparty.
Kontonummer/IBAN yes IBAN of the counterparty.
Mandatsreferenz no SEPA mandate.
Buchungstext no Internal description.
Kundenreferenz (End-to-End) no Identifier for duplicate checking.
Sammlerreferenz no Collective reference.
Währung no Currency. Also: Waehrung, Währungskürzel.

Example

Buchungstag;Valutadatum;Buchungstext;Verwendungszweck;Glaeubiger ID;Kundenreferenz (End-to-End);Sammlerreferenz;Beguenstigter/Zahlungspflichtiger;Kontonummer/IBAN;BIC (SWIFT-Code);Betrag;Waehrung;Mandatsreferenz;SH-Kennzei
01.09.2026;01.09.2026;LASTSCHRIFT;Beitrag 09/2026 Hartmann;DE98ZZZ09999999999;E2E-2026-0005;;Familie Hartmann;DE02120300000000202051;;12,50;EUR;M-1001;H
15.09.2026;15.09.2026;UEBERWEISUNG;Kursgebuehr Yoga 09/2026;;E2E-2026-0006;;Anna Beispiel;DE02500105170137075030;;8,00;EUR;;H
20.09.2026;20.09.2026;UEBERWEISUNG;Erstattung Kursgebuehr;;E2E-2026-0007;;Lena Hartmann;DE02120300000000202051;;5,00;EUR;;S

Example files: Bank_Umsaetze_beispiel_technisch.csv with the technical column names, Bank_Umsaetze_beispiel_anwender.csv with the German column names. The rows show the content of the technical file.

How to proceed

  1. Download the export from online banking and check the header row (columns as in the table above).
  2. Billing → Bank imports → Add (Abrechnung → Bank-Importe → Hinzufügen), select the file.
  3. Check the log.
  4. The assignment then runs in the background.

Good to know

  • vynst recognises bookings that have already been imported and skips them.
  • If the indicator S or H is set, write the amount without an additional minus or plus sign. Otherwise the sign is reversed twice and the amount becomes 0.
  • Each file creates a new group in the list of bank imports.

When something does not work

Message in the log Meaning What to do
Error: skipped missing Buchungstag The row has no booking date. LINE-DATA appears below it. Check the row.
Error: skipped missing IBAN or Betrag IBAN or amount is missing. Check the row.
Error: skipped missing Zahlungspflichtiger Name of the counterparty is missing. Check the row.
Error: skipped missing Verwendungszweck Payment reference is missing. Check the row.
Error: skipped unknown Betrag prefix The indicator is neither S, H, - nor +. Correct the indicator.
Error: skipped duplicate The booking already exists. Nothing to do.
Error: skipped empty line Empty row. Nothing to do.
Error: less then one line No data row. Check the file.
FAILED: No matching processor found. A required column is missing from the header row or is the last column. Check the header row against the list above.

See also