Reconciliation Procedure-2

Create API

Partner Reconciliation Procedure

Description

Reconciliation is the obligation of the partner, as an effort to monitor and mitigate the risk of financial transactions that occur, which is usually done on H + 1.

Partners who are allowed to go into production, especially for Fund Transfer, Direct Debit and BRIZZI products, must include a reconciliation procedure that is carried out and validated by the BRIAPI team.

There are three data source options that can be used to perform the reconciliation process.

1. Account Statement

Account Statement (current account or mutation info), can be obtained in two ways:

  1. Via transaction history API
  2. Download from CMS application

Some things to note when using Account Statements as data reconciliation sources:

  • Account Statements can be obtained on the same day or the next day. However, there are differences in the remark structure for Fund Transfer transactions, as follows:
    • Example of remark field: REMARK TEST BRIAPI
    • Current account H+0: remark will contain REMARK TEST BRIAPI
    • Current account H+1: remark will contain REMARK TEST BRIAPI WS_OB;<referral number>;<additional information>
    • Additional information obtained from the system includes institution code and bookkeeping tellers
  • Therefore, for FT product partners, it is necessary to include a unique code in the Remark column, to make it easier to identify transactions on H+0.
Please see the Transaction History API documentation for a more detailed explanation.

2. Direct Debit Report

This report is generated specifically for Direct Debit products. Please see the documentation on the Direct Debit product or contact the BRIAPI team to read the report.

3. MT940 file

MT940 is a swift format file that displays the transactions that took place.

BRI will provide MT940 files through two methods:

  1. SFTP (partners will be given a username and password to access the SFTP file)
  2. Sent via Email

Each MT940 file represents 1 transaction. To get this MT940, please contact the BRIAPI team for a more detailed explanation.

MT940 File Specifications

Sample File:

               
            {1:BRI}{2:940SI}{4:
            :20:20161116022517
            :25:042801020365703
            :28C:321
            :60F:C161116IDR1100000
            :61:161116D1469582861NTRF
            :86:GFV844469 0749 TJBB 16112016
            :62F:C161116IDR1100000
            -}

Component

Mandatory

Description

Sample

Statement Date

M

Date mt940 was generated

 :20:20161116022517
  • 20161116022517 follow the format YYYYMMDDHHMMSS

Account Number

M

Account Number, 15 numeric characters

 :25:042801020365703
  • 042801020365703 → account number

Sequence

M

Statement number / sequence number, 3 numeric characters

 :28C:226
  • 226 → sequence number

Opening Balance

M

 Starting Balance, consisting of:
  • Debit / credit balance status
  • Date
  • Currency
  • Total of balance (position)
 :60F:C161116IDR1100000
  • C → debit/credit balance status (D/C)
  • 161116 → 6 numeric characters format YYMMDD
  • IDR → 3 currency characters
  • 1100000 → balance, numeric

Statement Line

M

 Statement Line, consisting of:
  • Date
  • Debit/credit balance status
  • Nominal
  • Transaction code identification
 :61:161116D1469582861NTRF
  • 161116 → 6 numeric characters format YYMMDD
  • D → debet / kredit (D/C)
  • 1469582861 → nominal
  • TRF → transaction code (please see the list of transaction codes below)

Information Account / Header

O

description, a maximum length of 40 characters

 :86:GFV844469 0749 TJBB 16112016
  • GFV844469 0749 TJBB 16112016 → description/remark

Account Header

M

 Final Balance, consisting of:
  • Debit/credit balance status
  • Date
  • Currency
  • Total balance (position)
 :62F:C161116IDR1100000
  • C → Status saldo debet/kredit (D/C)
  • 161116 → 6 numeric characters format YYMMDD
  • IDR → 3 currency characters
  • 1100000 → saldo, numerik

Transaction Code Description

Code

Description

BNK

Securities Related Item - Bank fees

BOE

Bill of exchange

BRF

Brokerage fee

CAR

Securities Related Item - Corporate Actions Related (Should only be used when no specific corporate action event code is available)

CAS

Securities Related Item - Cash in Lieu

CHG

Charges and other expenses

CHK

Cheques

CLR

Cash letters/Cheques remittance

CMI

Cash management item - No detail

CMN

Cash management item - Notional pooling

CMP

Compensation claims

CMS

Cash management item - Sweeping

CMT

Cash management item - Topping

CMZ

Cash management item - Zero balancing

COL

Collections (used when entering a principal amount)

COM

Commission

CPN

Securities related item - Coupon payments

DCR

Documentary credit (used when entering a principal amount)

DDT

Direct Debit Item

DIS

Securities related item - Gains disbursement

DIV

Securities Related Item - Bank fees

EQA

Equivalent amount

EXT

Securities related item - External transfer for own account

FEX

Foreign exchange

INT

Interest

LBX

Lock box

LDP

Loan deposit

MAR

Securities related item - Margin payment/Receipts

MAT

Securities related item - Maturity

MGT

Securities related item - Management fees

MSC

Miscellaneous

NWI

Securities related item - New issues distribution

ODC

Overdraft charge

OPT

Securities related item - Options

PCH

Securities related item - Purchase (including STIF and Time deposits)

POP

Securities related item - Pair-off proceeds

PRN

Securities related item - Principal pay-down/pay-up

REC

Securities related item - Tax reclaim

RED

Securities related item - Redemption/Withdrawal

RIG

Securities related item - Rights

RTI

Returned Item

SAL

Securities related item - Sale (including STIF and Time deposits)