ISO20022 Payment in D365FO for Norway – Part 9 (Import Camt.053 file)

Camt.053 Account statement (Camt.053.001.02 – BankToCustomerStatement; Norwegian: bankkontoutdrag) is an electronic service that bank delivers to corporations for automatically reconciling bank transactions in D365FO. Camt053 can be imported in D365FO and perform automatic reconciliation process.

Bank account statement varies depending on the format of electronic bank statements:

Format	Description	ER config	Type
ISO20022	A single standardized approach used by all financial standard initiatives.	Camt.053 format	XML file
MT940	Message Type 940 file is a detailed standard SWIFT statement providing information about account transactions.	MT940 format	Text file
BAI2	Standardized set of codes for cash management that is formulated by Bank Administration Institute.	BAI2 format	Text file

These electronics configurations can be imported via Microsoft repositories. In order to import the configurations navigate to organization administration > Workspaces > Electronics reporting:

Choose ‘Microsoft’ and click on ‘Repositories’:

Choose ‘Global’ and click on “Open” to access to the repositories.

Search for the configuration and import the actual ones by clicking on “Import”:

Once you have imported the bank statement configuration, you need to activate the company with bank statement format (Cash and bank management > Setup > Advanced bank reconciliation > Bank statement format):

Then you can configure the bank account to apply advanced bank reconciliation:

You can get the bank statement from bank manually via nettbank or via integration. A Camt053 file includes following parts:

<GrpHdr>: GroupHeader: Message root, identifying message type and bank account information.
<Stmt>: Reports on booked entries, including transaction and balances for an account.
- <Id>: Unique identification, as assigned by Bank.
- <CreDtTm>: Date and time at which the message was created.
- <FrToDt>: From-To date for the bank statement.
- <Bal>: Balance.
  - OPBD: Opening balance
  - CLBD: Closing balance
  - FWAV: Forward available balance (If available, it will be reported).
  - CLAV: Closing available balance If available, it will be reported).
- <Ntry>
  - <NtryRef>: Entry reference
  - <Amt Ccy=”NOK”>: Amount and Currency
  - <CdtDbtInd>: Credit debit indicator. CRDT code for credit and DBIT code for debit.
  - <Sts>: Status. BOOK code will be used as booked transaction.
  - <BookgDt>: Booking date.
  - <AcctSvcrRef>: Account servicer reference (If available, it will be reported).
  - <BkTxCd>: Bank transaction code. ISO transaction codes are used (e.g., AUTT).
  - <NtryDtls>: Entry details, set of elements used to provide details on the entry.
    - <TxDtls>: Transactions detail.
      - <Refs>: References.
        <AcctSvcrRef>: Account servicer reference.
        <PmtInfId>: Payment information identification. If available or will be reported as provided in pain.001 file.
        <InstrId>: Instruction identification. If available or will be reported as provided in pain.001 file.
        <EndToEndId>: End to end identification. If available or will be reported as provided in pain.001 file.
    - <AmtDtls>: Amount details.
    - <RmtInf>: Remittance information (<Ustrd> or <Strd>).

You can import bank statement from Cash and bank management > Bank statement reconciliation > Bank statements:

Import statement for multiple bank accounts in all legal entities (Yes/No): This function can be usedto import a single bank statement for a single bank account (XML file) or multiple bank accounts (zip file).

Bank account: If you have set ‘Import statement for multiple ..” to “NO”, you need to specify a bank account associated to the bank statement. Once the ‘Import statement for multiple ..” is set to “Yes”, this field will be deactivated/grayed.

Statement format: Specify a statement format, such as Camt053.

Bank statement file import: Click Browse, and upload your electronic bank statement file.

Reconcile after import (Yes/No): This functionality automates matching of transactions by creating a new bank reconciliation and worksheet applying default matching rule.

You can run this process via batch job also. Once you click on ‘OK’, the cam053 file will be imported. Then you need to validate the statement.

Transactions that are marked as “New” on the worksheet are posted on the Bank statement page.

Then navigate to Cash and bank management > Bank account reconciliation > Bank reconciliation and click on “New” an choose the bank account. Last statement ID will be populated, click on “Worksheet” to check/match reconciliation.

You can match the ‘BANK STATEMENT TRANSACTIONS’ to ‘BANK TRANSACTIONS’ manually or via running the “ Run matching rules” function.

Then you can mark the worksheet as reconciled and post the bank statement.

Reconciled transactions can be found on Cash and bank management > Bank accounts > Bank accounts > Reconciled transactions.

To facilitate this process, you can import Advanced bank reconciliation statement formats (BAI2, MT940 and Camt.053) on Microsoft repositories, that are designed specifically for this purpose.