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.

Do not enter a bank when using CFONB file formats.

• 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 Reconciliation only, all fields on the Accounting and Search tabs are disabled.

Note: For CFONB file formats, you can only select Standard.

• 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 check box, you're required to enter the name of the preprocessing script here.

• Payment entry type (field PAYTYP)

Enter a dedicated payment entry type (GESTPY) 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 G/L account are posted to this account for manual reconciliation later.

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

Note: 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)

• Discount allowance days (field DEPTOL)

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

Example:

If you allow a discount deduction if 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 check box, B or C level matches are not posted to an intermediary or Suspense account.

Note: If you suppress intermediate posts, you need to manually create payments or journal entries for those transactions.

• 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 G/L or 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.

• BP Bank ID (field BPRBANID)

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

• BP number (field BPRNUM)

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

• BP name (field BPRNAM)

Select this check box 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.

• Invoice number (field INVNUM)

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

• Source document number (field SRCDOC)

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

Note: If this check box is selected, you need to select Source document no. under Search criteria when setting up the Invoice number definition.

• Amount (field AMT)

Select this check box 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/QR reference number (field BVRREFNUM)

When this check box is selected, the search looks for matching Swiss ISR or QR reference numbers. 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.

• Payment reference (field PAYREF)

Select this check box 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 ID (field BPRBANID)

Select this check box 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 check box to include the business partner number in the rules for the matching process.

• BP name (field BPRNAM)

Select this check box 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 check box to search based on the payment amount. If other search criteria are selected, like BP bank ID, they limit the search by amount.

• Days (field DAYSBACK)

Enter a number of days to limit search results to payments not older than the number entered (by accounting date). Use this option to limit the search to the most current payments to avoid accidental matches to old payments.

Entering a value of 0 is not recommended because there would be no limit and could impact performance.

• 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 check box is not selected.

• To BP (field BPREND)

This field is available if the All BPs check box is not selected.

• BP Type (field FIELDLABEL)

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

• Customer category (field CATBPC)

This field is available if the All categories check box is not selected.

• Supplier category (field CATBPS)

This field is available if the All categories check box 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.

Note: The minimum entered here must be shorter than the length of the actual BP and invoice no. definitions in the BP number definition and Invoice number definition functions.

• Use excluded search term list (field SEAEXD)

Select this check box to exclude the terms defined in the Excluded search terms function (BSISEAEXD).

• File import (field FYPIMP)

Select one of the following:

Client

Server

• Import volume (field IMPVOL)

This field is available if the Server check box is selected.

• Move file after import (field MOVAFTIMP)

Select this check box 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 check box is selected.

• Rename file after import (field RENAFTIMP)

Select this check box to rename the file. The file automatically receives a prefix with a status OK or NOK and a timestamp of the import.