Bank import

Introduction

The bank import function is a concept to import bank account statements previously extracted from online banking and create payment entries on the basis of received transactions. This is useful to cross-check payments of sales invoices.

Usage

• Go to the respective online banking and download a csv extract of the bank transactions
• Open the bank import and select the bank type (used for the parser) and which account the extract is from (for corrct accounting).
• Select the local file and click 'Parse'

Notes:

• Make sure that the name of the customer is identical to the one the bank reports. This is used to link the payment to a customer party. If no customer with a specific name is found, Guest is applied.
• When using auto submit: make sure that the year where the booking occurs is listed as Fiscal Year and is not yet disabled.

Supported banks (csv)

The following bank statement extracts are supported (feel free to contribute for more)

Bank	Unique ID	End-to-end reference	Supported	Recommended
UBS	✔️	✔️	✔️	✔️
ZKB	✔️	✔️	✔️	✔️
Raiffeisen	❌	✔️	✔️	⭕
Credit Suisse	❌	❌	✔️	❌
Migrosbank	❌	❌	✔️	❌
Volksbank	❌	❌	✔️	⭕
Sparkasse	❌	❌	✔️	⭕
Any (templated)	?	?	?	?

Supported banks (CAMT)

As CAMT is a standardised format (ISO 20022), technically any bank is supported. The following banks are tested

Bank	Tested
ZKB	✔️
Raiffeisen	✔️
Migrosbank	✔️
Postfinance	✔️

CSV templating

With the csv templating function, any bank csv can be modeled and imported using the bank import.