Field mapping when importing SEPA CAMT files

Business Central supports regional Single Euro Payments Area (SEPA) standards for importing SEPA bank statements (CAMT format). Learn more in Use the AMC Banking 365 Fundamentals extension.

The SEPA CAMT standard itself has local variations. Therefore, you might have to modify the generic data exchange definition (represented by the SEPA CAMT code on the Data Exchange Definitions page) to adapt it to a local variation of the standard. The following tables show the element-to-field mapping for tables 81, 273, and 274 in the SEPA CAMT implementation in Business Central.

Learn more in Set Up Data Exchange Definitions for information about creating or adjusting a data exchange definition.

Note

Starting in November 2025, most countries/regions in the European Union (including Switzerland) are mandating the SEPA CAMT.053.001.08 format (based on the updated ISO 20022 XML standard).

To set up a corresponding SEPA CAMT.053.001.08 format in Business Central, open the Bank Import/Export Setup page and choose the Setup/SEPA CAMT 053.001.08 action. Then, you can open a Bank Account Card page for an account and choose SEPA CAMT 053.001.08 in the Bank Statement Import Setup field.

CAMT data mapping to fields in the General Journal table (81)

Element PathMessage ElementData TypeDescriptionNegative-Sign IdentifierField No.Field Name
Stmt/Ntry/AmtAmountDecimalThe amount of money in the cash entry13Amount
Stmt/Ntry/CdtDbtIndCreditDebitIndicatorTextIndicates whether the entry is a credit or a debit entryDBIT13Amount
Stmt/Ntry/BookgDt/DtDateDateThe date when an entry is posted to an account on the account servicer's books5Posting Date
Stmt/Ntry/BookgDt/DtTmDateTimeDateTimeThe date and time when an entry is posted to an account on the account servicer's books5Posting Date
Stmt/Ntry/NtryDtls/TxDtls/RltdPties/Dbtr/NmNameTextThe name of the party that owes an amount of money to the (ultimate) creditor1221Payer Information
Stmt/Ntry/NtryDtls/TxDtls/RmtInf/UstrdUnstructuredTextInformation supplied to enable the matching/reconciliation of an entry with the items that the payment is intended to settle, such as commercial invoices in an accounts-receivable system, in an unstructured form8Description
Stmt/Ntry/AddtlNtryInfAdditionalEntryInformationTextAdditional information about the entry1222Transaction Information

CAMT data mapping to fields in the Bank Acc. Reconciliation table (273)

Element PathMessage ElementData TypeDescriptionNegative-Sign IdentifierField No.Field Name
Stmt/CreDtTmCreationDateTimeDateThe date and time when the message was created3Statement Date
Stmt/Bal/AmtAmountDecimalThe amount resulting from the netted amounts for all debit and credit entries4Statement Ending Balance

CAMT data mapping to fields in the Bank Acc. Reconciliation Line table (274)

Element PathMessage ElementData TypeDescriptionNegative-Sign IdentifierField No.Field Name
Stmt/Ntry/AmtAmountDecimalThe amount of money in the cash entry7Statement Amount
Stmt/Ntry/CdtDbtIndCreditDebitIndicatorTextIndicates whether the entry is a credit or a debit entryDBIT7Statement Amount
Stmt/Ntry/BookgDt/DtDateDateThe date when an entry is posted to an account on the account servicer's books5Transaction Date
Stmt/Ntry/BookgDt/DtTmDateTimeDateTimeThe date and time when an entry is posted to an account on the account servicer's books5Transaction Date
Stmt/Ntry/ValDt/DtDateDateFor a credit entry, the date when assets become available to the account owner. For a debit entry, the date when assets become unavailable to the account owner.12Value Date
Stmt/Ntry/ValDt/DtTmDateTimeDateTimeFor a credit entry, the date and time when assets become available to the account owner. For a debit entry, the date when assets become unavailable to the account owner.12Value Date
Stmt/Ntry/NtryDtls/TxDtls/RltdPties/Dbtr/NmNameTextThe name of the party that owes an amount of money to the (ultimate) creditor15Payer Information
Stmt/Ntry/NtryDtls/TxDtls/RmtInf/UstrdUnstructuredTextInformation supplied to enable the matching/reconciliation of an entry with the items that the payment is intended to settle, such as commercial invoices in an accounts-receivable system, in an unstructured form6Description
Stmt/Ntry/AddtlNtryInfAdditionalEntryInformationTextAdditional information about the entry16Transaction Information

Elements in the Ntry node that are imported into Business Central but aren't mapped to any fields are stored in the Posting Exch. Column Def table. You can view these elements from the Payment Reconciliation Journal, Payment Application, and Bank Acc. Reconciliation pages by choosing the Bank Statement Line Details action. Learn more in Reconcile Payments Using Automatic Application.

Important

In an import of CAMT bank statements, Business Central expects each transaction to be unique, which means that the Transaction ID field that comes from the Stmt/Ntry/NtryDtls/TxDtls/Refs/EndToEndId tag in the CAMT file, must be unique within the open bank account reconciliation. If the information isn't present, Business Central ignores the payment. If an earlier bank reconciliation on the same bank account was posted with the same transaction ID as on the current import, the current transaction won't reconcile automatically but can still be imported.

Set Up Data Exchange
Exchange Data Electronically
Use the AMC Banking 365 Fundamentals extension
Use XML Schemas to Prepare Data Exchange Definitions
Reconcile Payments Using Automatic Application

Find free e-learning modules for Business Central here