Bank import settings

Code (field CODIMPPAR)

Enter a unique code that identifies the import setting.

Company (field CPY)

Enter a company.

Description (field DES)

Enter a description for the format (optional).

Bank (field BAN)

Enter a specific bank to limit this import code to transactions from this bank.

File format (field FILFMT)

Enter a file format to limit this import code to transactions in this format only.

Flow type (field FLOTYP)

Select a flow type to process imported bank statements:

Standard: The imported bank statement is processed within the full flow of the advanced bank statement import. After importing the bank statement file, the transactions are matched to open items or existing payments. For matched open items, payments are generated when validating the statement using the Process bank transactions function.

Reconciliation only: After importing the bank statement file, the transaction data is copied to the Bank reconciliation function (RAPBAN), where you can perform a standard bank reconciliation. There is no further processing within the advanced bank statement import. If you select this flow type, all the fields on the Accounting and Search tabs are disabled.

Post validation transfer: Use this flow type to also transfer the bank statement transactions to the Bank reconciliation function (RAPBAN) for further processing. This option combines the existing flow types Standard and Reconciliation only.

The bank transactions are transferred after matching and validating the statement in the Process bank transactions function (GESBSIMTC).

File format (field FILFMT)

Enter a file format to limit this import code to transactions in this format only.

Preprocessing (field PREPRC)

Use this option to activate a custom processing of the bank import file, for example to reformat the file or remove non-required lines.

Standard script (field TRTSTD)

If you select the Preprocessing checkbox, you need to enter the name of the preprocessing script here.

Payment entry type (field PAYTYP)

Enter a dedicated payment entry type used to generate payments.

Payment attribute underpayment (field CDASHOPAY)

Enter a payment attribute (GESCDA) to generate specific payments for variances, not including discounts.

Payment attribute overpayment (field CDAEXCPAY)

Enter a payment attribute (GESCDA) to generate specific payments for variances.

Suspense account (field ACCUSUSPENSE)

Enter a suspense account.

Transactions not matched to an open item or a general ledger account are posted to this account for manual reconciliation later.

If you selected the Suppress intermediate posting checkbox, no postings are made to a suspense account.

Because the suspense account is used in the payment generation process, an address code needs to be assigned to this account in the Addresses section in Accounts (GESGAC).

Payment attribute suspense account (field CDAACCSUSP)

Enter a dedicated payment attribute for the suspense account. You can only enter a payment attribute with an accounting sign Unspecified.

You cannot use payment attributes with accounting signs Expense or Revenue. The reason for this restriction is that posting to suspense accounts can be revenue or expense and you cannot enter a payment attribute during a bank statement import life cycle.

If the accounting sign is not Unspecified, you receive a blocking message.

The only account structure allowed for the payment attribute is BANK <-> BP. Otherwise, you receive a blocking message.

Discount allowance days (field DEPTOL)

Enter the number of days accepted beyond the calculated discount date.

Example

If you allow a discount deduction when the payment arrives late by one day, enter 1. An automatic discount deduction is taken as if the payment arrived within the discount term.

Maximum amount variance (field AMTVAR)

Enter the maximum accepted variance, not including discounts, applied in the automatic matching. This allows you to automatically process amount variations in the payments.

Amount variance limit (field AMTVARLIM)

This field is active if you entered a variance amount. You can enter a maximum amount in the company currency to limit the variance percentage.

Maximum currency variance (field AMTVATCUR)

Enter the maximum accepted currency variance, applied in the automatic matching. This allows you to automatically process amount variations in the payments resulting from different currency rates between invoice creation and received payment.

This setting is only relevant when there are different currencies for statement and invoice currency.

Suppress intermediate posting (field FLGCLS)

If you select this checkbox, B or C level matches are not posted to an intermediary or Suspense account.

BP number (field BPRNUM)

Select this checkbox to include the business partner number in the rules for the matching process.

BP name (field BPRNAM)

Select this checkbox to include the business partner name in the rules for the matching process.

Note: In the Excluded search term function, you can exclude common terms like the legal forms of a company (e.g., Inc. Ltd. GmbH, S.A.) from the search that would otherwise result in an extended search duration.

BP Bank ID (field BPRBANID)

Select this checkbox to only perform this search if the BP bank ID is given as an IBAN.

Invoice number (field INVNUM)

Select this checkbox to include the invoice number in the rules for the matching process. This is typically selected.

Source document number (field SRCDOC)

Select this checkbox to include the source document number in the rules for the matching process. If the Invoice number checkbox is selected, you should clear this option because it increases the run time for the matching process.

Amount (field AMT)

Select this checkbox to carry out additional searches by amount.

A matching amount (including discount if applicable) is always an implicit decision criteria for an A or B matching level.

ISR reference number (field BVRREFNUM)

When this checkbox is selected, a Swiss ISR reference number can be used as matching criteria. This search applies to the import of Swiss CAMT bank statements only. The search is carried out on the subdetail (entry detail) level of CAMT.053/054 bank statement transactions only.

Use search term list (field USESEALIS)

This field controls the use of the search term list. Search terms can be used if fixed identifications (like BP name or transaction text) should be used to match the transaction to a specific general ledgeror BP account.

Select one of the following:

• No: Do not use the search term list.
• First pass: Use the search term list before the standard search process.
• Second pass: Use the search term list after the standard search process; only C matches are considered.

Merge description field (field MRGDESFLG)

This field controls if the various text strings from the import are merged internally for search purposes or not. This can help identify search terms that have been distributed over several fields within the file.

Select one of the following:

• No: Do not merge during search.
• Always: Merge for all search runs.
• Second pass: Perform a second search run with merged fields to improve results.

From BP (field BPRSTR)

This field is available if the All BPs checkbox is not selected.

To BP (field BPREND)

This field is available if the All BPs checkbox is not selected.

BP Type (field FIELDLABEL)

This field is available if the All BP type checkbox is not selected.

Customer category (field CATBPC)

This field is available if the All categories checkbox is not selected.

Supplier category (field CATBPS)

This field is available if the All categories checkbox is not selected.

Minimum search term length (field SEAEXDLEN)

You can enter a minimum length for search terms to improve the search efficiency. Shorter search terms are not considered by the matching process.

Use excluded search term list (field SEAEXD)

Payment reference (field PAYREF)

Select this checkbox to search by payment reference. The bank transaction reference must be stored in [BSIIMPD] PAYREF (bank import segment settings). Matching then compares this reference against the payment references stored in either the [PAYMENTD] NUM or REF fields.

If you select this option and a match is found, no other BP criteria are considered even if they are selected.

If the bank returns these references through the bank statement file, you should consider these as very precise matching criteria and use these matches.

BP bank account number (field BPRBANID)

Select this checkbox for an additional search for possible BP accounts in the list of bank IDs if the BP bank ID is given as an IBAN.

BP number (field BPRNUM)

Select this checkbox to include the business partner number in the rules for the matching process.

BP name (field BPRNAM)

Select this checkbox to include the business partner name in the rules for the matching process.

Note: In the Excluded search term function, you can exclude common terms like the legal forms of a company (e.g., Inc. Ltd. GmbH, S.A.) from the search that would otherwise result in an extended search duration.

Amount (field AMT)

Select this checkbox to search based on the payment amount. If other search criteria are selected, like BP bank account number, they limit the search by amount.

Days (field DAYSBACK)

Merge description field (field MRGDESFLG)

This field controls if the various text strings from the import are merged internally for search purposes or not. This can help identify search terms that have been distributed over several fields within the file.

Select one of the following:

• No: Do not merge during search.
• Always: Merge for all search runs.
• Second pass: Perform a second search run with merged fields to improve results.

From BP (field BPRSTR)

This field is available if the All BPs checkbox is not selected.

To BP (field BPREND)

This field is available if the All BPs checkbox is not selected.

BP Type (field FIELDLABEL)

This field is available if the All BP type checkbox is not selected.

Customer category (field CATBPC)

This field is available if the All categories checkbox is not selected.

Supplier category (field CATBPS)

This field is available if the All categories checkbox is not selected.

Minimum search term length (field SEAEXDLEN)

You can enter a minimum length for search terms to improve the search efficiency. Shorter search terms are not considered by the matching process.

Use excluded search term list (field SEAEXD)

File import (field FYPIMP)

Select one of the following:

• Client
• Server

Import volume (field IMPVOL)

This field is available if the Server checkbox is selected.

Move file after import (field MOVAFTIMP)

Select this checkbox to move the file to the location entered in the Move to volume field.

Move to volume (field MOVVOL)

This field is available if the Move file after import checkbox is selected.

Rename file after import (field RENAFTIMP)