Banking formats (CAMT053/MT940/CODA)

Improve reconciliation: Import Payvision CAMT053/MT940/CODA reports straight into your accounting package

Individual transactions processed by Payvision will appear on your bank account as a single sum. As such, they will not be presented individually, and you cannot automatically link them to the invoices recorded when the orders were placed in your webshop.
As a solution, Payvision supports the daily download report, either in an CAMT053, MT940 or CODA format. This report contains all the transactions that have occurred on your Payvision account (i.e. all transactions that happened in your webshop and other transactions such as chargebacks, refunds, transaction costs, etc.). Almost every accounting package supports the upload of these digital statements to help with your reconciliation.

Improve clarity: Payvision as a suspense account

You can record the cash flows from Payvision clearly in your records by making a suspense account (a general ledger number on the balance sheet). You can then import the CAMT053/MT940/ CODA file for this suspense account and all transactions will be automatically recorded in the suspense account. In addition, a payment can be linked to an outstanding item, as a result of which the outstanding invoice will be removed from the outstanding debtor amounts.

Invoice

An invoice will be generated every month. The invoice includes the processing costs, chargebacks, invoice adjustments and other expenses settled through the invoice. These items will also only be reported in the CAMT053/MT940/CODA in case you receive a net settlement. In this case, you can record this invoice with Payvision as the contra-account. In all other cases you can match the invoice directly to your payment of the invoice from your bank account.

Reporting in CAMT053/MT940/CODA format

Once in the Portal, go to “Financials,” and then “Reports.” Select the period you want to generate a report for. Pick a date in the past to prevent the report being incomplete (the latest day that can be included is yesterday). Select the report format (CAMT053, CODA, MT940) you want and click on “Download your report.”

Hit “Save” and then go to your accounting package to upload the file.

Specific codes used in CAMT053

The following Transaction codes and Bank Transaction Codes (BkTxCd) will be used in the CAMT053 format.

Transaction

Transaction code

Bank Transaction Code (BkTxCd)

Sale transaction – iDeal iDEAL (credit)

00106

PMNT RCDT DMCT

Sale transaction – all other payment methods (credit)

00100

PMNT RCDT ESCT

Transaction fees (debit) – only applicable with net settlement

09001

PMNT MDOP CHRG

Payout (debit)

02500

PMNT ICCN ESCT

Monthly invoice (credit/debit) – only applicable with net settlement

09001

PMNT MDOP CHRG

All other transactions (credit) – e.g. refunds, chargebacks, Payvision manual corrections Payvision, etc.

00100

PMNT RCDT ESCT

All other transactions (debit) – e.g. refunds, chargebacks, Payvision manual corrections Payvision, etc.

00100

PMNT ICDT ESCT

Specific codes used in MT940

The following Transaction codes and SWIFT transaction codes will be used in for the MT940 format:

Transaction

Transaction code

SWIFT transaction code (61.6)

All credit transactions

00000

NMSC

All debit transactions

00000

NMSC

Specific codes used in CODA

The following CODA transaction codes in records 2.1 and 3.1 will be used for the CODA format:

Transaction

CODA transaction code

All credit transactions (MSC)

30890000

All debit transactions (MSC)

30390000

Fields for reconciliation in the CAMT/MT940/CODA

You can use the following fields for automatic reconciliation:

Payvision ID: (CAMT.053: EndToEndId, MT940: In tag 86, in CODA: Customer reference record 2.2 pos 64-98 )

E-commerce transactions: In this field you’ll find the ID as generated by Payvision. In the Reporting portal, you can use it to search for a specific transaction. Example: 8ac9a4a86fd7d448016fe9ad2c494032

Payout transactions: In this field you’ll find the ID that Payvision creates during the payout. This number is shown in the reference on your bank account. This number is always the one following “ACNL-” Example: 099159224

Point-of-sale transactions: In this field you’ll find the following values linked together: Authorization code TID TransactionDate (YYMMDD). Example: E8T0J5T9320200128

The contents of the Unstructured field (Ustrd/USTD)(CAMT)/(MT940)/CODA (Customer reference record 2.1,2.2, 2.3): several fields are included:

E-commerce transactions:

  • The Bank Statement Reference: This reference will be the same for all transactions belonging to the same payout you’ll receive on your bank account. It will start with “ACNL-” followed by a number. The payout you’ll receive will contain the same reference as well. This value won’t appear if the transaction hasn’t been paid out yet.
  • The tracking code as you sent it in the transaction. This can also be used as a transaction reference. The tracking code will not be sent to the consumer.
  • The descriptor which is used for your transactions. Depending on your implementation, the descriptor is either sent by Payvision (static descriptor) or with every transaction (dynamic descriptor). The descriptor will also show up in the bank account statement of the consumer.
    Example: ACNL-097826824, 5e21bdf9-3c5aff, 9769.1137.8947 Catering Prot BV HaarlemTD iDEAL Payvision Test Store

Payout transactions:

  • The Bank Statement Reference: Reference for the payout. This reference will be the same for all transactions belonging to the same payout that you’ll receive on your bank account. It will start with “ACNL-” followed by a number.
    Example: ACNL-097826824

Point-of-sale transactions:

  • The Bank Statement Reference: This reference will be the same for all transactions belonging to the same payout that you’ll receive on your bank account. It will start with “ACNL-” followed by a number. The payout you’ll receive will contain the same reference as well. This value won’t appear if the transaction hasn’t been paid out yet.
  • In this field you’ll find the following values linked together: reference entered in the terminal, Location, TID
    Example: ACNL-097826824 Catering Prot BV HaarlemTD Payvision Test Store, NO_REF, Haarlem, T9320

Examples per file format

CAMT053

Important tags in the file example:

  • <Cd>00106</Cd> - Denotes an iDEAL transaction
  • <EndToEndId>8782306c-6a97-4c78-b491-1a6b778eb5b</EndToEndId> - Payvision's ID for the transaction. Please note that this field has a maximum of 35 characters so longer values will be truncated.
  • <Ustrd>ACNL-097826824, 5e1f1ad8-6dadb2, 6918.1667.1839 Catering Prot BV HaarlemTD iDEAL Payvision Test Store</Ustrd> - Bank Statement Reference, tracking code and the descriptor
  • <Ustrd>ACNL-097826824</Ustrd> - Bank Statement Reference
<?xml version="1.0" encoding="utf-16"?>
<Document xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="urn:iso:std:iso:20022:tech:xsd:camt.053.001.02">
  <BkToCstmrStmt>
    <GrpHdr>
      <MsgId>202001DD000000042_2020-01-28T10:23:</MsgId>
      <CreDtTm>2020-01-28T10:23:41+00:00</CreDtTm>
      <MsgRcpt>
        <Nm>PV PSP ACCOUNT</Nm>
        <Id>
          <OrgId>
            <Othr>
              <Id>11223344</Id>
            </Othr>
          </OrgId>
        </Id>
      </MsgRcpt>
    </GrpHdr>
    <Stmt>
      <Id>P200128000000042</Id>
      <ElctrncSeqNb>42</ElctrncSeqNb>
      <CreDtTm>2020-01-28T10:23:41+00:00</CreDtTm>
      <FrToDt>
        <FrDtTm>2020-01-15T00:00:00</FrDtTm>
        <ToDtTm>2020-01-20T23:59:59</ToDtTm>
      </FrToDt>
      <Acct>
        <Id>
          <IBAN>NL63PVNL0000000001</IBAN>
        </Id>
        <Tp>
          <Cd>CACC</Cd>
        </Tp>
        <Ccy>EUR</Ccy>
        <Ownr>
          <Nm>PV PSP ACCOUNT</Nm>
        </Ownr>
        <Svcr>
          <FinInstnId>
            <BIC>PVPVNL2A</BIC>
          </FinInstnId>
        </Svcr>
      </Acct>
      <Bal>
        <Tp>
          <CdOrPrtry>
            <Cd>PRCD</Cd>
          </CdOrPrtry>
        </Tp>
        <Amt Ccy="EUR">0.00</Amt>
        <CdtDbtInd>CRDT</CdtDbtInd>
        <Dt>
          <Dt>2020-01-14</Dt>
        </Dt>
      </Bal>
      <Bal>
        <Tp>
          <CdOrPrtry>
            <Cd>OPBD</Cd>
          </CdOrPrtry>
        </Tp>
        <Amt Ccy="EUR">0.00</Amt>
        <CdtDbtInd>CRDT</CdtDbtInd>
        <Dt>
          <Dt>2020-01-15</Dt>
        </Dt>
      </Bal>
      <Bal>
        <Tp>
          <CdOrPrtry>
            <Cd>CLBD</Cd>
          </CdOrPrtry>
        </Tp>
        <Amt Ccy="EUR">0.10</Amt>
        <CdtDbtInd>CRDT</CdtDbtInd>
        <Dt>
          <Dt>2020-01-20</Dt>
        </Dt>
      </Bal>
      <Bal>
        <Tp>
          <CdOrPrtry>
            <Cd>CLAV</Cd>
          </CdOrPrtry>
        </Tp>
        <Amt Ccy="EUR">0.10</Amt>
        <CdtDbtInd>CRDT</CdtDbtInd>
        <Dt>
          <Dt>2020-01-20</Dt>
        </Dt>
      </Bal>
      <TxsSummry>
        <TtlNtries>
          <NbOfNtries>8</NbOfNtries>
          <Sum>3.10</Sum>
        </TtlNtries>
        <TtlCdtNtries>
          <NbOfNtries>4</NbOfNtries>
          <Sum>1.60</Sum>
        </TtlCdtNtries>
        <TtlDbtNtries>
          <NbOfNtries>4</NbOfNtries>
          <Sum>1.50</Sum>
        </TtlDbtNtries>
      </TxsSummry>
      <Ntry>
        <NtryRef>02109707558200000000000000000000001</NtryRef>
        <Amt Ccy="EUR">1.25</Amt>
        <CdtDbtInd>CRDT</CdtDbtInd>
        <Sts>BOOK</Sts>
        <BookgDt>
          <Dt>2020-01-15</Dt>
        </BookgDt>
        <ValDt>
          <Dt>2020-01-15</Dt>
        </ValDt>
        <AcctSvcrRef>02109707558200000000000000000000001</AcctSvcrRef>
        <BkTxCd>
          <Domn>
            <Cd>PMNT</Cd>
            <Fmly>
              <Cd>RCDT</Cd>
              <SubFmlyCd>DMCT</SubFmlyCd>
            </Fmly>
          </Domn>
          <Prtry>
            <Cd>00106</Cd>     
            <Issr>Payvision</Issr>
          </Prtry>
        </BkTxCd>
        <NtryDtls>
          <TxDtls>
            <Refs>
              <EndToEndId>8782306c-6a97-4c78-b491-1a6b778eb5b</EndToEndId>
            </Refs>
            <RltdPties>
              <Dbtr>
                <Nm>J. Janssen</Nm>
              </Dbtr>
              <DbtrAcct>
                <Id>
                  <IBAN>NL20BUNQ2025381239</IBAN>
                </Id>
                <Tp>
                  <Prtry>General</Prtry>
                </Tp>
              </DbtrAcct>
            </RltdPties>
            <RltdAgts>
              <DbtrAgt>
                <FinInstnId>
                  <BIC>BUNQNL2A</BIC>
                </FinInstnId>
              </DbtrAgt>
            </RltdAgts>
            <RmtInf>
              <Ustrd>ACNL-097826824, 5e1f1ad8-6dadb2, 6918.1667.1839 Catering Prot BV HaarlemTD iDEAL Payvision Test Store</Ustrd>
            </RmtInf>
            <RltdDts>
              <TxDtTm>2020-01-15T14:00:45+01:00</TxDtTm>
            </RltdDts>
          </TxDtls>
        </NtryDtls>
      </Ntry>
      <Ntry>
        <NtryRef>02109707537400000000000000000000002</NtryRef>
        <Amt Ccy="EUR">0.10</Amt>
        <CdtDbtInd>CRDT</CdtDbtInd>
        <Sts>BOOK</Sts>
        <BookgDt>
          <Dt>2020-01-15</Dt>
        </BookgDt>
        <ValDt>
          <Dt>2020-01-15</Dt>
        </ValDt>
        <AcctSvcrRef>02109707537400000000000000000000002</AcctSvcrRef>
        <BkTxCd>
          <Domn>
            <Cd>PMNT</Cd>
            <Fmly>
              <Cd>RCDT</Cd>
              <SubFmlyCd>ESCT</SubFmlyCd>
            </Fmly>
          </Domn>
          <Prtry>
            <Cd>00100</Cd>
            <Issr>Payvision</Issr>
          </Prtry>
        </BkTxCd>
        <NtryDtls>
          <TxDtls>
            <Refs>
              <EndToEndId>071bf18d-9807-4f1c-8f83-9d82cc8e975</EndToEndId>
            </Refs>
            <RltdPties />
            <RltdAgts>
              <DbtrAgt>
                <FinInstnId />
              </DbtrAgt>
            </RltdAgts>
            <RmtInf>
              <Ustrd>ACNL-098289348, 5e1f1c2f-2ff31e, 3130.3956.3464 Catering Prot BV HaarlemTD AMEX</Ustrd>
            </RmtInf>
            <RltdDts>
              <TxDtTm>2020-01-15T14:06:47+01:00</TxDtTm>
            </RltdDts>
          </TxDtls>
        </NtryDtls>
      </Ntry>
      <Ntry>
        <NtryRef>02109707540400000000000000000000003</NtryRef>
        <Amt Ccy="EUR">0.10</Amt>
        <CdtDbtInd>DBIT</CdtDbtInd>
        <Sts>BOOK</Sts>
        <BookgDt>
          <Dt>2020-01-15</Dt>
        </BookgDt>
        <ValDt>
          <Dt>2020-01-15</Dt>
        </ValDt>
        <AcctSvcrRef>02109707540400000000000000000000003</AcctSvcrRef>
        <BkTxCd>
          <Domn>
            <Cd>PMNT</Cd>
            <Fmly>
              <Cd>ICDT</Cd>
              <SubFmlyCd>ESCT</SubFmlyCd>
            </Fmly>
          </Domn>
          <Prtry>
            <Cd>00100</Cd>
            <Issr>Payvision</Issr>
          </Prtry>
        </BkTxCd>
        <NtryDtls>
          <TxDtls>
            <Refs>
              <EndToEndId>b50c9764-c215-436e-8375-5e91a864303</EndToEndId>
            </Refs>
            <RltdPties />
            <RmtInf>
              <Ustrd>ACNL-097826824, TestCAMTRefund1, 5709.8087.0759 Catering Prot BV HaarlemTD AMEX</Ustrd>
            </RmtInf>
            <RltdDts>
              <TxDtTm>2020-01-15T14:37:27+01:00</TxDtTm>
            </RltdDts>
          </TxDtls>
        </NtryDtls>
      </Ntry>
      <Ntry>
        <NtryRef>02109707554500000000000000000000004</NtryRef>
        <Amt Ccy="EUR">0.75</Amt>
        <CdtDbtInd>DBIT</CdtDbtInd>
        <Sts>BOOK</Sts>
        <BookgDt>
          <Dt>2020-01-15</Dt>
        </BookgDt>
        <ValDt>
          <Dt>2020-01-15</Dt>
        </ValDt>
        <AcctSvcrRef>02109707554500000000000000000000004</AcctSvcrRef>
        <BkTxCd>
          <Domn>
            <Cd>PMNT</Cd>
            <Fmly>
              <Cd>ICDT</Cd>
              <SubFmlyCd>ESCT</SubFmlyCd>
            </Fmly>
          </Domn>
          <Prtry>
            <Cd>00100</Cd>
            <Issr>Payvision</Issr>
          </Prtry>
        </BkTxCd>
        <NtryDtls>
          <TxDtls>
            <Refs>
              <EndToEndId>733f0190-5b9e-4ae5-86e9-6221a48c469</EndToEndId>
            </Refs>
            <RltdPties />
            <RmtInf>
              <Ustrd>ACNL-097826824, PartialRefundCamt1, 1582.1574.4072 Catering Prot BV HaarlemTD iDEAL Payvision Test Store</Ustrd>
            </RmtInf>
            <RltdDts>
              <TxDtTm>2020-01-15T16:10:28+01:00</TxDtTm>
            </RltdDts>
          </TxDtls>
        </NtryDtls>
      </Ntry>
      <Ntry>
        <NtryRef>02109707553600000000000000000000005</NtryRef>
        <Amt Ccy="EUR">0.50</Amt>
        <CdtDbtInd>DBIT</CdtDbtInd>
        <Sts>BOOK</Sts>
        <BookgDt>
          <Dt>2020-01-15</Dt>
        </BookgDt>
        <ValDt>
          <Dt>2020-01-15</Dt>
        </ValDt>
        <AcctSvcrRef>02109707553600000000000000000000005</AcctSvcrRef>
        <BkTxCd>
          <Domn>
            <Cd>PMNT</Cd>
            <Fmly>
              <Cd>ICDT</Cd>
              <SubFmlyCd>ESCT</SubFmlyCd>
            </Fmly>
          </Domn>
          <Prtry>
            <Cd>00100</Cd>
            <Issr>Payvision</Issr>
          </Prtry>
        </BkTxCd>
        <NtryDtls>
          <TxDtls>
            <Refs>
              <EndToEndId>7ec1f616-4e96-4adc-9e63-5077a086fbf</EndToEndId>
            </Refs>
            <RltdPties />
            <RmtInf>
              <Ustrd>ACNL-097826824, PartialRefundCamt3, 2138.8254.6813 Catering Prot BV HaarlemTD iDEAL Payvision Test Store</Ustrd>
            </RmtInf>
            <RltdDts>
              <TxDtTm>2020-01-15T16:13:28+01:00</TxDtTm>
            </RltdDts>
          </TxDtls>
        </NtryDtls>
      </Ntry>
      <Ntry>
        <NtryRef>02109724307700000000000000000000006</NtryRef>
        <Amt Ccy="EUR">0.10</Amt>
        <CdtDbtInd>CRDT</CdtDbtInd>
        <Sts>BOOK</Sts>
        <BookgDt>
          <Dt>2020-01-16</Dt>
        </BookgDt>
        <ValDt>
          <Dt>2020-01-16</Dt>
        </ValDt>
        <AcctSvcrRef>02109724307700000000000000000000006</AcctSvcrRef>
        <BkTxCd>
          <Domn>
            <Cd>PMNT</Cd>
            <Fmly>
              <Cd>RCDT</Cd>
              <SubFmlyCd>DMCT</SubFmlyCd>
            </Fmly>
          </Domn>
          <Prtry>
            <Cd>00106</Cd>
            <Issr>Payvision</Issr>
          </Prtry>
        </BkTxCd>
        <NtryDtls>
          <TxDtls>
            <Refs>
              <EndToEndId>51bff832-8db1-4df1-b9ad-c7c9b6c6093</EndToEndId>
            </Refs>
            <RltdPties>
              <Dbtr>
                <Nm>Janssen CONSULTING</Nm>
              </Dbtr>
              <DbtrAcct>
                <Id>
                  <IBAN>NL47RABO0195260112</IBAN>
                </Id>
                <Tp>
                  <Prtry>General</Prtry>
                </Tp>
              </DbtrAcct>
            </RltdPties>
            <RltdAgts>
              <DbtrAgt>
                <FinInstnId>
                  <BIC>RABONL2U</BIC>
                </FinInstnId>
              </DbtrAgt>
            </RltdAgts>
            <RmtInf>
              <Ustrd>ACNL-097826824, 5e203f06-6c3319, 2091.4455.6189 Catering Prot BV HaarlemTD iDEAL Payvision Test Store</Ustrd>
            </RmtInf>
            <RltdDts>
              <TxDtTm>2020-01-16T10:48:00+01:00</TxDtTm>
            </RltdDts>
          </TxDtls>
        </NtryDtls>
      </Ntry>
      <Ntry>
        <NtryRef>02109742224400000000000000000000007</NtryRef>
        <Amt Ccy="EUR">0.15</Amt>
        <CdtDbtInd>CRDT</CdtDbtInd>
        <Sts>BOOK</Sts>
        <BookgDt>
          <Dt>2020-01-17</Dt>
        </BookgDt>
        <ValDt>
          <Dt>2020-01-17</Dt>
        </ValDt>
        <AcctSvcrRef>02109742224400000000000000000000007</AcctSvcrRef>
        <BkTxCd>
          <Domn>
            <Cd>PMNT</Cd>
            <Fmly>
              <Cd>RCDT</Cd>
              <SubFmlyCd>DMCT</SubFmlyCd>
            </Fmly>
          </Domn>
          <Prtry>
            <Cd>00106</Cd>
            <Issr>Payvision</Issr>
          </Prtry>
        </BkTxCd>
        <NtryDtls>
          <TxDtls>
            <Refs>
              <EndToEndId>c84acad0-0140-4179-944c-161266ba407</EndToEndId>
            </Refs>
            <RltdPties>
              <Dbtr>
                <Nm>Janssen CONSULTING</Nm>
              </Dbtr>
              <DbtrAcct>
                <Id>
                  <IBAN>NL47RABO0195260112</IBAN>
                </Id>
                <Tp>
                  <Prtry>General</Prtry>
                </Tp>
              </DbtrAcct>
            </RltdPties>
            <RltdAgts>
              <DbtrAgt>
                <FinInstnId>
                  <BIC>RABONL2U</BIC>
                </FinInstnId>
              </DbtrAgt>
            </RltdAgts>
            <RmtInf>
              <Ustrd>ACNL-097826824, 5e21bdf9-3c5aff, 9769.1137.8947 Catering Prot BV HaarlemTD iDEAL Payvision Test Store</Ustrd>
            </RmtInf>
            <RltdDts>
              <TxDtTm>2020-01-17T14:00:51+01:00</TxDtTm>
            </RltdDts>
          </TxDtls>
        </NtryDtls>
      </Ntry>
      <Ntry>
        <NtryRef>02109782682400000000000000000000008</NtryRef>
        <Amt Ccy="EUR">0.15</Amt>
        <CdtDbtInd>DBIT</CdtDbtInd>
        <Sts>BOOK</Sts>
        <BookgDt>
          <Dt>2020-01-20</Dt>
        </BookgDt>
        <ValDt>
          <Dt>2020-01-20</Dt>
        </ValDt>
        <AcctSvcrRef>02109782682400000000000000000000008</AcctSvcrRef>
        <BkTxCd>
          <Domn>
            <Cd>PMNT</Cd>
            <Fmly>
              <Cd>ICCN</Cd>
              <SubFmlyCd>ESCT</SubFmlyCd>
            </Fmly>
          </Domn>
          <Prtry>
            <Cd>02500</Cd>
            <Issr>Payvision</Issr>
          </Prtry>
        </BkTxCd>
        <NtryDtls>
          <TxDtls>
            <Refs>
              <EndToEndId>097826824</EndToEndId>
            </Refs>
            <RltdPties>
              <Dbtr>
                <Nm>Test Catering Prot BV HaarlemTD</Nm>
              </Dbtr>
              <DbtrAcct>
                <Id>
                  <IBAN>NL91INGB0005190404</IBAN>
                </Id>
                <Tp>
                  <Prtry>General</Prtry>
                </Tp>
              </DbtrAcct>
            </RltdPties>
            <RmtInf>
              <Ustrd>ACNL-097826824</Ustrd>
            </RmtInf>
            <RltdDts>
              <TxDtTm>2020-01-20T04:48:38+01:00</TxDtTm>
            </RltdDts>
          </TxDtls>
        </NtryDtls>
      </Ntry>
    </Stmt>
  </BkToCstmrStmt>
</Document>

MT940

Important lines in the file example:

  • .../8782306c-6a97-4c78-b491-1a6b778eb5b7//... - Payvision's ID for the transaction
  • ad8-6dadb2, 6918.1667.1839 Catering Prot BV HaarlemTD iDEAL Payvision Test Store/ - Tracking code and the descriptor
  • ...//ACNL-097826824/ - Bank Statement Reference
{1:F01INGBNL2ABXXX0000000000}{2:I940INGBNL2AXXXXN}{4:
:20:P200203000000060
:25:NL63PVNL0000000001EUR
:28C:00000
:60F:C200115EUR0,00
:61:2001150115C1,25NTRFNONREF//5e1f1ad8-6dadb2
/TRCD/00000/
:86:/EREF/8782306c-6a97-4c78-b491-1a6b778eb5b7//CNTP/NL20BUNQ2025
381239/BUNQNL2A/J.P. Janssen///REMI/USTD//ACNL-097826824, 5e1f1
ad8-6dadb2, 6918.1667.1839 Catering Prot BV HaarlemTD iDEAL Payvi
sion Test Store/
:61:2001150115C0,10NTRFNONREF//5e1f1c2f-2ff31e
/TRCD/00000/
:86:/EREF/071bf18d-9807-4f1c-8f83-9d82cc8e975c//REMI/USTD//ACNL-0
98289348, 5e1f1c2f-2ff31e, 3130.3956.3464 Catering Prot BV Haarle
mTD AMEX/
:61:2001150115D0,10NTRFNONREF//TestCAMTRefund1
/TRCD/00000/
:86:/EREF/b50c9764-c215-436e-8375-5e91a8643034//REMI/USTD//ACNL-0
97826824, TestCAMTRefund1, 5709.8087.0759 Catering Prot BV Haarle
mTD AMEX/
:61:2001150115D0,75NTRFNONREF//PartialRefundC
/TRCD/00000/
:86:/EREF/733f0190-5b9e-4ae5-86e9-6221a48c4697//REMI/USTD//ACNL-0
97826824, PartialRefundCamt1, 1582.1574.4072 Catering Prot BV Haa
rlemTD iDEAL Payvision Test Store/
:61:2001150115D0,50NTRFNONREF//PartialRefundC
/TRCD/00000/
:86:/EREF/7ec1f616-4e96-4adc-9e63-5077a086fbfd//REMI/USTD//ACNL-0
97826824, PartialRefundCamt3, 2138.8254.6813 Catering Prot BV Haa
rlemTD iDEAL Payvision Test Store/
:61:2001160116C0,10NTRFNONREF//5e203f06-6c3319
/TRCD/00000/
:86:/EREF/51bff832-8db1-4df1-b9ad-c7c9b6c60931//CNTP/NL47RABO0195
260112/RABONL2U/Janssen CONSULTING///REMI/USTD//ACNL-097826824,
 5e203f06-6c3319, 2091.4455.6189 Catering Prot BV HaarlemTD iDEAL
 Payvision Test Store/
:61:2001170117C0,15NTRFNONREF//5e21bdf9-3c5aff
/TRCD/00000/
:86:/EREF/c84acad0-0140-4179-944c-161266ba4074//CNTP/NL47RABO0195
260112/RABONL2U/Janssen CONSULTING///REMI/USTD//ACNL-097826824,
 5e21bdf9-3c5aff, 9769.1137.8947 Catering Prot BV HaarlemTD iDEAL
 Payvision Test Store/
:61:2001200120D0,15NTRFACNL-097826824//ACNL-097826824
/TRCD/00000/
:86:/EREF/097826824//CNTP/NL91INGB0005190404/INGBNL2A/Test Cateri
ng Prot BV HaarlemTD///REMI/USTD//ACNL-097826824/
:62F:C200120EUR0,10
:64:C200120EUR0,10
:86:/SUM/4/4/1.50/1.60
-}

CODA

Important lines in the file example:

  • 0000000000001250150120030890000ACNL-097826824, 5e1f1ad8-6dadb2, 6918.1667.1839 Cater15012000001 0 2200010000ing Prot BV HaarlemTD iDEAL Payvision Test Store/ 8782306c-6a97-4c78-b491-1a6b778eb5bBUNQNL2A - Bank Statement Reference (ACNL-097826824), tracking code and the descriptor
  • 8782306c-6a97-4c78-b491-1a6b778eb5bBUNQNL2A 1 0 - Contains Payvision's ID (8782306c-6a97-4c78-b491-1a6b778eb5b)
  • 3100080000ACNL-097826824 - The bank statement reference ACNL-097826824 is mentioned here
0000003022000005                  PV PSP ACCOUNT            PVPVNL2A   00000000000 00000P200203000000042                       2
    13000NL63PVNL0000000001                EUR0000000000000000150120PV PSP ACCOUNT            PSP Account                        000
    2100010000NONREF               0000000000001250150120030890000ACNL-097826824, 5e1f1ad8-6dadb2, 6918.1667.1839 Cater15012000001 0
    2200010000ing Prot BV HaarlemTD iDEAL Payvision Test Store/    8782306c-6a97-4c78-b491-1a6b778eb5bBUNQNL2A                   1 0
    2300010000NL20BUNQ2025381239                EURJ.P. PIETERSEN                                                                0 1
    3100010000NONREF               030890001001J.P. PIETERSEN                                                                    0 0
    2100020000NONREF               0000000000000100150120030890000ACNL-098289348, 5e1f1c2f-2ff31e, 3130.3956.3464 Cater15012000001 0
    2200020000ing Prot BV HaarlemTD AMEX/                          071bf18d-9807-4f1c-8f83-9d82cc8e975                           0 1
    3100020000NONREF               030890001001                                                                                  0 0
    2100030000NONREF               1000000000000100150120030390000ACNL-097826824, TestCAMTRefund1, 5709.8087.0759 Cater15012000001 0
    2200030000ing Prot BV HaarlemTD AMEX/                          b50c9764-c215-436e-8375-5e91a864303                           0 1
    3100030000NONREF               030390001001                                                                                  0 0
    2100040000NONREF               1000000000000750150120030390000ACNL-097826824, PartialRefundCamt1, 1582.1574.4072 Ca15012000001 0
    2200040000tering Prot BV HaarlemTD iDEAL Payvision Test Store/ 733f0190-5b9e-4ae5-86e9-6221a48c469                           0 1
    3100040000NONREF               030390001001                                                                                  0 0
    2100050000NONREF               1000000000000500150120030390000ACNL-097826824, PartialRefundCamt3, 2138.8254.6813 Ca15012000001 0
    2200050000tering Prot BV HaarlemTD iDEAL Payvision Test Store/ 7ec1f616-4e96-4adc-9e63-5077a086fbf                           0 1
    3100050000NONREF               030390001001                                                                                  0 0
    2100060000NONREF               0000000000000100160120030890000ACNL-097826824, 5e203f06-6c3319, 2091.4455.6189 Cater16012000001 0
    2200060000ing Prot BV HaarlemTD iDEAL Payvision Test Store/    51bff832-8db1-4df1-b9ad-c7c9b6c6093RABONL2U                   1 0
    2300060000NL47RABO0195260112                EURPIETERSEN CONSULTING                                                          0 1
    3100060000NONREF               030890001001PIETERSEN CONSULTING                                                              0 0
    2100070000NONREF               0000000000000150170120030890000ACNL-097826824, 5e21bdf9-3c5aff, 9769.1137.8947 Cater17012000001 0
    2200070000ing Prot BV HaarlemTD iDEAL Payvision Test Store/    c84acad0-0140-4179-944c-161266ba407RABONL2U                   1 0
    2300070000NL47RABO0195260112                EURPIETERSEN CONSULTING                                                          0 1
    3100070000NONREF               030890001001PIETERSEN CONSULTING                                                              0 0
    2100080000ACNL-097826824       1000000000000150200120030390000ACNL-097826824/                                      20012000001 0
    2200080000                                                     097826824                          INGBNL2A                   1 0
    2300080000NL91INGB0005190404                EURTest Catering Prot BV HaarlemTD                                               0 1
    3100080000ACNL-097826824       030390001001Test Catering Prot BV HaarlemTD                                                   0 0
    8000NL63PVNL0000000001                EUR0000000000000000150120                                                                0
    4 00010000                      /SUM/4/4/1.50/1.60                                                                             0
    9               000030000000000001500000000000001600                                                                           2