ISO 20022 cash management

Cash management processes use ISO 20022 camt.053.001.02 messages according to the CGI (Common Global Implementation).

BankRec produces a camt.053.001.002 bank statement with Australian transactions.

File validation

camt.053.001.02 files are compliant with the v2 XML schema on ISO 200200 Bank to Customer messages (CGI compliant version).

camt.053.001.02

The structure of a camt.053.001.02 file is:

• Many accounts can be present in one file.
• There will be one header for each statement containing date/time, balances and BSB/Account details.
• A statement can have any number of transaction records, each containing the details of a transaction.
• Most transactions are single amounts or a bulked amount of other composite transactions (e.g. a total BPAY settlement). These are called bulked transactions.
• Some transactions can be broken down into individual sub-transactions (e.g. individual BPAY payments). These are called debulked transactions and will also contain the bulked settlement amount.

• One block at the 'Group Level'.
  • One 'Message Identification'
  • One 'Created Date Time'
  • One 'Additional Information'
• One or more blocks at the 'Statement Level' (for each account)
  • One 'Account Information'
  • Three 'Balances' (opening, closing and available)
  • One 'Transaction Summary'
• Zero or more blocks at the 'Transaction Level'
  • One 'Transaction Header'
  • One or more 'Transaction Details'

Important: Please refer to the v2 XML schema on ISO 200200 Bank to Customer messages (CGI compliant version).

Group level

<BkToCstmrStmt>
    <GrpHdr>
      <MsgId>6438754992</MsgId>
      <CreDtTm>2017-12-06T01:19:25</CreDtTm>
      <AddtlInf>EODY</AddtlInf>
    </GrpHdr>
    ...
</BkToCstmrStmt>

• The MsgId is a unique number created for every camt.053.001.02 statement file. Use this combined with the statement level sequence number (if you have multiple accounts per file) to ensure you do not process the same file twice.
• CreDtTm is the time stamp showing when the file was generated.
• AddtlInf identifies the type of statement file. EODY indicates that it is an end-of-day statement.

Statement level

<Stmt>
    <Id>0320011234562017-12-06T01:19:25</Id>
    <ElctrncSeqNb>142</ElctrncSeqNb>
    <CreDtTm>2017-12-06T01:19:25</CreDtTm>
    <FrToDt>
        <FrDtTm>2017-12-05T00:00:00</FrDtTm>
        <ToDtTm>2017-12-05T23:59:59</ToDtTm>
    </FrToDt>
    <Acct></Acct>
    <Bal></Bal>
    ...
</Stmt>

• The Id comprises of the BSB and account number and the time stamp.
• CreDtTm is the time stamp showing when the statement was generated.
• The from and to time stamps indicate the period that the transactions in the statement represent.

Account information

<Acct>
    <Id>
      <Othr>
        <Id>032001123456</Id>
      </Othr>
    </Id>
    <Ccy>AUD</Ccy>
    <Svcr>
      <FinInstnId>
        <BIC>WPACAU2S</BIC>
      </FinInstnId>
    </Svcr>
</Acct>

• The Id is the BSB and account number.
• The Ccy field identifies the currency of the amounts presented in the file.
• The BIC field is the Swift code of the institution that produced the file.

Balances

<Bal>
    <Tp>
      <CdOrPrtry>
        <Cd>OPBD</Cd>
      </CdOrPrtry>
    </Tp>
    <Amt Ccy="AUD">7484527.35</Amt>
    <CdtDbtInd>CRDT</CdtDbtInd>
    <Dt>
      <Dt>2017-12-05</Dt>
    </Dt>
</Bal>

• There will be 3 Balance records for each statement. They represent the opening balance (Cd = OPBD), closing balance (Cd = CLDB) and available balance (Cd = CLAV).
• The Amt field holds the value of the specified balance type.
• The Dt field identifies the date that the balance refers to.

Transaction summary

<TxsSummry>
    <TtlNtries>
        <NbOfNtries>687</NbOfNtries>
        <Sum>13563249.33</Sum>
        <TtlNetNtryAmt>10898261.33</TtlNetNtryAmt>
        <CdtDbtInd>DBIT</CdtDbtInd>
    </TtlNtries>
    <TtlCdtNtries>
        <NbOfNtries>279</NbOfNtries>
        <Sum>1332494.00</Sum>
    </TtlCdtNtries>
    <TtlDbtNtries>
        <NbOfNtries>414</NbOfNtries>
        <Sum>12230755.33</Sum>
    </TtlDbtNtries>
</TxsSummry>

Transaction level

Transaction header

 <Ntry>
    <NtryRef>477595609</NtryRef>
    <Amt Ccy="AUD">667.35</Amt>
    <CdtDbtInd>DBIT</CdtDbtInd>
    <Sts>BOOK</Sts>
    <BookgDt>
        <Dt>2018-01-03</Dt>
    </BookgDt>
    <ValDt>
        <Dt>2018-01-03</Dt>
    </ValDt>
    <BkTxCd>
        <Domn>
            <Cd>PMNT</Cd>
            <Fmly>
                <Cd>ICHQ</Cd>
                <SubFmlyCd>BCHQ</SubFmlyCd>
            </Fmly>
        </Domn>
        <Prtry>
            <Cd>013</Cd>
            <Issr>Westpac Australia</Issr>
        </Prtry>
    </BkTxCd>
    <NtryDtls>
        ...
    </NtryDtls>
</Ntry>

• The NtryRef field is a unique number that identifies the bulk settlement for a transaction.
• The Amt represents the bulk settlement amount.
• The CdtDbtInd identifies whether the transaction is a credit or a debit.
• The two dates represent the date that the transaction was completed and the date that the funds are available.
• The BkTxCd block contains the Domain, Family and Sub Family codes that identify the transaction. It also contains the traditional bank transaction code for the transaction.

Transaction details

<NtryDtls>
    <TxDtls>
        <Refs>
            <InstrId>BI00007747</InstrId>
            <EndToEndId>292</EndToEndId>
            <TxId>2086196006</TxId>
        </Refs>
        <AmtDtls>
            <TxAmt>
                <Amt Ccy="AUD">667.35</Amt>
            </TxAmt>
        </AmtDtls>
        <BkTxCd>
            <Domn>
                <Cd>PMNT</Cd>
                <Fmly>
                    <Cd>ICHQ</Cd>
                    <SubFmlyCd>BCHQ</SubFmlyCd>
                </Fmly>
            </Domn>
            <Prtry>
                <Cd>013</Cd>
                <Issr>Westpac Australia</Issr>
            </Prtry>
        </BkTxCd>
        <AddtlTxInf>WESTPAC PPS - (CHEQUE PORTION)</AddtlTxInf>
    </TxDtls>
</NtryDtls>

• The InstrId and EndToEndId fields contain reference data that was passed to the bank by the customer when initiating the transaction. Note that the EndToEndId is typically passed through the banking system from the initiating payment file. The InstrId or PmtInfId is held at Westpac for statement enhancement.
• The Amt contains the amount of the particular transaction.
• The BkTxCd block contains the Domain, Family and Sub Family codes that identify the sub-transaction. It also contains the traditional bank transaction code for the transaction.
• The AddtlTxInf field usually contains the transaction narrative that would appear on the customers' bank statement.

Identifying transactions

The below table lists common types of transactions that may appear in the camt.053.001.02 bank statement file. This table uses the transaction code and domain properties to identify the transaction type.

Enrichment support

If you receive a data-enriched (debulked or enriched) statement, there will be some modifications to the TxDtls element in the camt.053.001.02 file.

Debulked receivables enrichment

For debulked receivables enrichment, the following modifications will be performed to the TxDtls element of the camt.053.001.02 file:

• Each TxDtls element that previously represented a bulk settlement will be replaced with multiple TxDtls elements that represent multiple individual payments that formed part of the bulk settlement.
• TxDtls/Refs/MsgId: This element will be populated with the Message Id from the Payment Batch if available, otherwise omitted.
• TxDtls/Refs/PmtInfId: This element be populated with the Payment Information Id from the Payment Batch if available, otherwise omitted.
• TxDtls/Refs/TxId: This element will be populated with a unique, BankRec-generated transaction identifier.
• TxDtls/RltdPties/Dbtr/Nm: This element will be populated with the Debtor Name from the transaction.
• TxDtls/Refs/AcctSvcrRef: This element will be omitted.
• TxDtls/BkTxCd/Domn/Fmly/SubFmlyCd: The value of this element will change to reflect the type of transaction (payment or refund).

• Merchant Transaction - Transaction credit relating to debiting a customer credit card
• Merchant Refund - Transaction debit relating to crediting a customer credit card
• EFT Credit - Transaction credit relating to debiting a customer bank account
• EFT Debit - Transaction debit relating to crediting a customer bank account

Debulked payables enrichment

For debulked payables enrichment, the following modifications will be performed to the TxDtls element of the camt.053.001.02 file:

• Each TxDtls element that previously represented a bulk settlement will be replaced with multiple TxDtls elements that represent multiple individual payments that formed part of the bulk settlement.
• TxDtls/Refs/InstrId: This element will be populated with the Instrument Id from the Payables Payment Batch if available, otherwise omitted.
• TxDtls/Refs/EndToEndId: This element will be populated with the End To End Id from the Payables Payment Batch if available, otherwise omitted.
• TxDtls/Refs/TxId: This element will be populated with a unique, BankRec-generated transaction identifier.
• TxDtls/RltdPties/Dbtr/Nm: This element will be populated with the Debtor Name from the transaction.
• TxDtls/Refs/AcctSvcrRef: This element will be omitted.

External entry enrichment

For external entry enrichment (i.e, transactions enriched with information from an external EFT feed), the following modifications will be performed to the TxDtls element of the camt.053.001.02 file:

• TxDtls/Refs/AcctSvcrRef: This element will be omitted.
• TxDtls/Refs/EndToEndId: This element will be populated with the Payment Reference sourced from the external feed.
• TxDtls/Refs/MsgId: This element will be populated with a unique, BankRec-generated transaction identifier.
• TxDtls/Refs/TxId: This element will be populated with a unique, BankRec-generated external transaction identifier.
• TxDtls/RltdPties/Cdtr/Nm: This element will be populated if the transaction is a debit on your statement.
• TxDtls/RltdPties/Dbtr/Nm: This element will be populated if the transaction is a credit on your statement.

For RTGS/OTT transactions, the following modifications will also be performed to the TxDtls element:

• TxDtls/RmtInf: This element will be populated with a Ustrd element, populated with the Payment Detail from the RTGS/OTT transaction.

New Payments Platform (NPP) payments enrichment

For any payments made on the NPP, the following modifications will be performed to the TxDtls element of the camt.053.001.02 file:

• TxDtls/Refs/EndToEndId: This element will be populated with the End To End Id from the NPP transaction if available, otherwise omitted.
• TxDtls/Refs/PmtInfId: This element will be populated with the first 35 characters of the Remitter Description from the NPP transaction.
• TxDtls/Refs/InstrId: This element will be populated with the first 35 characters of the Remitter Description from the NPP transaction.
• TxDtls/Refs/TxId: This element will be populated with the Transaction Id from the NPP transaction if available, otherwise will be populated with the Payment Id from the NPP transaction.
• TxDtls/RltdPties/Cdtr/Nm: This element will be populated with the Beneficiary Name from the NPP transaction.
• TxDtls/RltdPties/Dbtr/Nm: This element will be populated with the Remitter Name from the NPP transaction.
• TxDtls/RltdPties/CtctDtls/Othr: This element will be populated with the PayId Type from the NPP transaction if available, otherwise omitted.
• TxDtls/RltdPties/CtctDtls/EmailAdr: This element will be populated with the PayId from the NPP transaction if available, otherwise omitted.
• TxDtls/RltdDts/TxDtTm: This element will be populated with the Reversal Date from the NPP transaction if the transaction is a reversal, otherwise will be populated with the Debited Date from the NPP transaction.
• TxDtls/RmtInf: This element will be populated with up to two Ustrd elements, populated with the Beneficiary Description from the NPP transaction. These two elements should be concatenated to produce the complete description.
• TxDtls/RtrInf/Rsn/Cd: This element will be populated with the Reversal Reason Code, or the Return Reason Code from the NPP transaction if available, otherwise omitted.
• TxDtls/RtrInf/AddtInf: This element will be populated with the Original Transaction Id from the NPP transaction if the transaction is a return or reversal, otherwise omitted.

If you require further enrichment, you should discuss this during your implementation.

Default file name format

The default file name will be generated as BankStatement_CONFIGCODE_DATE.xml where CONFIGCODE is the configuration code and DATE is the statement date.

Sample files

The following files are intended to be examples only.

NPP sample transactions

Download the NPP sample camt.053.001.02 file.

This file contains examples of all NPP transaction codes, and how they will appear in a standard camt.053.001.02 statement.