DengiOnline

2017-07-29 03:29:17

Automatic reconciliation

Reconciliation is used to validate the interaction between Partners and GSG. It is performed on the basis of daily registers received from the Partners.

Each register includes all successful payments for the previous day and is formed not later than by 12 pm Moscow time (UTC + 04:00).

To include a Partner into the reconciliation mechanism it is necessary to arrange sending daily registers to verify@dengionline.com.

Mail structure

The mail subject is derived from the "project_id date" template, where:

  • project_id is the Project ID in the GSG system;
  • date is the date for which the report is generated in YYYY-MM-DD format.

The register should be attached to the mail. The register filename should match the subject of the mail.

Register file

  • The register is a CSV file.
  • It contains a UTF-8 data.
  • Columns are separated using the ";" sign. If the data in the register contains the ";" sign it is necessary to screen each occurrence with double quotes around it.
  • Line break is used for separating lines.
  • All values are displayed with an accuracy of 2 decimal places, the fractional part is separated by a dot (ex. 34.00).
  • The first line of the register file contains column headers: 
ID;TxnId;Time;Account;Amount;Currency

Detailed description of headers:

Parameter

Description

Format

ID

Unique payment number in the Project system

integer

TxnId

Transaction ID (txn_id) in the project system 

string (255)

Time

Time of the transaction

YYYY-MM-DD HH:MM:SS (according to the project timezone)

Account

Payee account ID, such as card number

integer / string

Amount

Payment amount

integer / double (4)

integers separated by fractional point; no separator between hundreds and thousands is used

Currency

Payment currency ID

integer

ISO 4217 number-3

Register example

ID;TxnId;Time;Account;Amount;Currency 
23334;le3l4k5jfld;2014-07-01 12:20:34;dol-team;10234.43;643 
23335;le3334j4f22;2014-07-01 13:22:32;dol;34.00;980