Bank import settings

Use this function to define settings used for bank transaction imports and automatic matching. Alternatively, you have the option to send data to the Bank statement reconciliation function (RAPBAN) where you can complete the matching process by selecting Reconciliation only for the flow type.

The codes you define here are important in determining how transactions are imported, matched to open items, and how payments are generated using the Bank transaction management function (BSIIMP).

You can create multiple codes per company for different sites, banks, formats, etc. The settings on the Search criteria tab directly control the automatic matching process.

It is strongly recommended to create dedicated payment entry types to use when defining import settings on the Accounting tab.
(missing or bad snippet)

Prerequisites

Refer to the documentation on Implementation.

Actions

Select Create to define new settings.

General tab

These fields define the company for the bank statement import. You can enter a bank and/or a file format to link a setting to those criteria if you want to use specific settings for a certain bank file format.

Accounting tab

This fields in this section determine the payment generation settings. Matches to existing payments do not generate a new payment

It is strongly recommended to use dedicated payment entry types for the bank statement import so settings can be made independent from other entry types.

This only applies if you select a Standard flow type.

Recommended settings for Payment entry types:

General tab

  • Sign: Unspecified
  • Default payment attribute to be used later for payments. This attribute must be set up with Accounting sign = Payment sign and Account structure: Bank <-> BP.

Entry tab

  • Select the following checkboxes: Bank, Reference, Header description, Line description, Payment method, and Value date.
  • Do not select the Entry batch checkbox.
  • Do not add fields to the Extra fields grid.

Steps tab

  • Select the Remittances checkbox if payments should be posted automatically.
  • Do not enter any bank file generation settings.
  • Group entry: STEP 1
  • No intermediate posting, no notes P/R risk closing
  • If you are in Germany or Austria, the Payment grouping and Discount grouping field settings under Bank posting are mandatory. You need to select Payment from the drop-down menu for each field. This is particularly important for Germany when transferring data via the DATEV export interface.

Search criteria tab

Other tab

The fields in this section determine how import files are handled.

Action panel

These actions are available when you display a single record.

Create

Select Create to define a new import setting.

Excel

Select Excel to export the current list to an Excel document.

 

Tables used

The following tables are implemented by the function:

Table

Table description

BSIIMPPAR [BSIIP]

Bank import settings