Appendix II: CAMT default settings

These are the default settings delivered with the basic setup for processing CAMT files.

Technical background

Importing CAMT statement files involves a two-step process managed automatically when a CAMT statement file is loaded through the advanced bank statement import screen (BSIIMP):

  1. The statement file is managed by a specific process that parses the XML content of the CAMT file and extracts the relevant set of information from the file (statement header information, transaction details, etc.). The extracted information is transformed in a line-oriented, flat structure and returned to the advanced bank statement import process.
  2. The advanced bank statement import process then parses the received data according to the settings and writes the data into the defined database fields.

The data extraction and transformation performed in step 1 is controlled through the CAMT element mapping. This mapping defines which XML tags need to be considered and how their values are returned. Because this is a sensitive and very technical setup, it is not accessible by default. If you need to make modifications, please contact your Sage business partner to assist you.

For step 2, the format and segment definitions supply the settings used for the final processing of the import. This basically follows the same scheme as with simpler formats like MT940 where no added transformation is needed.

Segment definitions

The default segment configuration below is for CAMT files. Only information from levels 1, 3, and 5 of the CAMT XML structure is relevant for the advanced bank statement import process, therefore we don’t require segments for levels 2 and 4.

Note that CAMT.054 – as opposed to CAMT.053 – does not provide opening and ending balance information because CAMT.054 is not a full bank statement. After import, you will have zero values for these fields.

CAMT053/054 Level 1

This segment defines the statement header information from this section of the CAMT.053 XML structure:

Document.BkToCstmrStmt.Stmt.Bal

It supplies the following values:

  • Opening balance amount
  • Opening balance currency
  • Opening balance sign
  • Opening balance date
  • Ending balance amount
  • Ending balance sign
  • Ending balance date

The imported values are stored in the BSIIMP table.

CAMT053/054 Level 3

This segment defines the individual transaction information in the statement related to the C level in a CAMT message. The information is taken from this section of the CAMT.053 XML structure:

Document.BkToCstmrStmt.Stmt.Ntry

It supplies the following values:

  • Amount in transaction currency
  • Transaction currency
  • Sign
  • Date
  • Account servicer reference (AcctSvcrRef)
  • Additional Entry Information (AddtlNtryInf)

The imported values are stored in the BSIIMPD table.

Transaction information for a single transaction can be given on this level or in addition on level 5 depending on the bank. Batched transactions have the summary information, i.e., total amount, on the C level and typically more detailed information on the D level (BSI segment level 5). Detailed information available on D level takes precedence in the matching process if available.

CAMT053/054 Level 5

This segment defines additional detailed transaction information related to the D level of a CAMT message. D level information is linked to the corresponding C level information of the message:

  • If the C level refers to a single transaction, additional information can be given on the D level (optional).
  • If the D level refers to the total record of a batched transaction, the detailed information for each transaction that is part of the batched transaction can be given on the D level. Providing the details on the D level is a choice and could depend on the agreement with your bank.

The information is taken from this section of the CAMT.053 XML structure:

Document.BkToCstmrStmt.Stmt.Ntry.NtryDtls

It supplies the following values:

  • Remittance reference (EndToEndId)
  • Amount in transaction currency
  • Transaction currency
  • Sign
  • Instructed amount
  • Instructed currency
  • Structured remittance information (ISR, Swiss specific)
  • Unstructured remittance information
  • Additional remittance information
  • Debtor name
  • Debtor account
  • Creditor name
  • Creditor account
  • Additional transaction information
  • Bank transaction code (domain)
  • Bank transaction code (family)
  • Bank transaction code (subfamily)

The imported values are stored in the BSIIMPDS table.

Format definitions

The default format definition for CAMT.053/054 consists of three entries with the before mentioned segment definitions:

  • CAMT053 level 1 / CAMT054 level 1
  • CAMT053 level 3 / CAMT054 level 3
  • CAMT053 level 5 / CAMT054 level 5

All segment operations must be set to Create and the file type format definition must be set to CAMT.