Reconciliation file details
Contis creates a reconciliation file at the end of the business day containing all authorisation records posted to the client’s URL that day. The file is put into the SFTP folder to be picked up.
Clients can verify all authorisations of specific day(s) and settle accordingly using this daily reconciliation file on that basis.
The reconciliation file will be a tab separated .csv file.
Filename format: [SchemeCode]_Auth_[ddMMyyyyHHmmss].csv
File availability time: Every day between 02h00 to 03h00 (UK time). Time is configurable.
The file can be configured as follows:
- Maximum of 5000 records in one file
- One reconciliation file every day (according to file schedule)
Clients must contact Contis to configure the file.
Sample reconciliation File
[ClientCode]_Auth_23012018180030.csv]
Fields in reconciliation file
| RESPONSEINFO FIELDS | NOTATION | TYPE | SIZE | DESCRIPTION |
| CardID | M | integer | Card ID value that is sent in the authorisation. | |
| AuthorizationID | M | integer | Unique ID for authorisation that is sent in the authorisation request. | |
| AuthorizationAmount | M | integer | Authorised Amount value that is sent in the authorisation request. Amount is in minor unit. For Example: Value = 11.20, then AuthorizationAmount field value = 1120 (i.e., 11.20*100) | |
| AcceptorNameLocation | M | string | 64 | Name and Location of acceptor that is sent in the authorisation. |
| AcceptorCountryCode | M | integer | Acceptor’s Country Code value that is sent in the authorisation. | |
| AuthorizationType | M | string | 2 | Authorisation Type value that is sent in the authorisation. |
| IsApproved | M | bool | Final decision on the authorisation, Its Value = 1 (i.e. true) or 0 (i.e. false). | |
| IsSTIP | M | bool | If the authorisation was not made in the agreed time scale, then the value will either be 1 (i.e. true), or 0 (i.e. false). | |
| AcceptorID | M | string | 15 | Acceptor identifier that is sent in the authorization. |
| MerchantCategoryCode | M | integer | Merchant category code value that is sent in authorization | |
| IsAuthorizationRequested | M | bool | Whether authorization was requested real time to client or not | |
| DeclineReason | O | string | 500 | Why particular authorization was declined. This field will be blank in case authorization is approved |