Reconcile Report

To generate Reconcile reports for full payments, refer to the guide below.

πŸ‘

Connect using SFTP

  • IP Address : 52.76.184.174
  • Port : 22
  • Username : The merchant must fill in the SFTP setup form and send the request to support team. An account will be created for merchant to access 2c2p SFTP in demo and production environment.
  • Response Path : /output
  • Drop time for response file: Everyday Before 4.00AM GMT+7

Β 

How to get the report


  1. At the specified time, 2C2P will drop a CSV file in the SFTP server. The file name follows the format Reconcile2c2p_A_v1.8_MID_CURRENCY_yyyy-MM-dd_HHmmss.csv
  2. The merchant must get the file from the SFTP Server.
  3. For more information on the report's contents, refer to Data Parameters below.

Β 

🚧

File Format Specification

  • File name format: Reconcile2c2p_A_v1.8_MID_CURRENCY_yyyy-MM-dd_HHmmss.csv
    - Reconcile2c2p_A_v1.8_JT_THB_2017-07-18_153136.ext
  • Parameter delimiter: comma "," for CSV Format
  • Record delimiter: line break

πŸ“˜

Data Attribute Reference

Data Type

  • A: Alphabet
  • AN: Alphanumeric
  • C: Characters
  • B: Boolean
  • D: Decimal
  • N: Numeric

Mandatory attributes

  • M: Mandatory
  • C: Conditional
  • O: Optional

Β 

Data Parameters


πŸ‘

Sample File

Download sample csv file here.

2C2P2022041301,3,H,test,0,13/04/2022,test,13/04/2022,000000,00/00/00,000000,702702000000000,00000000000000000000,00000000000000000000,000,000,000,2300.00,0.00,0.00,41.00,2.87,,,,,,,1.23,2257.36,0.00,SGD,000000,0,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
2C2P2022041301,1,D,test,0,13/04/2022,test,30/03/2022,152954,30/03/2022,000000,702702000000000,NEWUI0046,,001,VI,BANK,1000.00,0.00,0.00,30.00,2.10,2C2P-220330-0003,31/03/2022,41.00,2.87,43.87,,0.90,968.80,0.00,SGD,545296,05,411111XXXXXX1111,,,,,,3.00,,USA,VI,4782930,2C2P SG Test B,,test,Test Payment,,0.00,,,,,0.00,,,,,,,,
2C2P2022041301,2,D,test,0,13/04/2022,test,30/03/2022,153129,30/03/2022,000000,702702000000000,BE-001,,001,VI,BANK,300.00,0.00,0.00,9.00,0.63,2C2P-220330-0003,31/03/2022,41.00,2.87,43.87,,0.27,290.64,0.00,SGD,067336,05,411111XXXXXX1111,natalie buying 2 prods,,,,,3.00,,USA,VI,4782942,2C2P SG Test B,,Natalie Chan,Payment for beauty prods,,0.00,,,,,0.00,,,,,,,,

Parameter

Data Type

Mandatory

Description

BATCH_NO

AN 20

M

2C2P+YYMMDD (Payin BATCH NO)+NN

LINE_NO

N 5

M

H = Total Line No. , D= Line number

TYPE_TABLE

AN 1

M

H=Header, D=Detail

BANK_CODE

AN 25

M

Bank Swift Code

ACCOUNT_NO

AN 25

M

Merchant Bank Account Number

PAYIN_DATE

AN 10

M

DD/MM/YYYY

VAT_NO

AN 25

M

0107536000633 (Merchant Tax Registation No)

ORDER_DATE

AN 10

M

Customer order date [format : DD/MM/YYYY]

ORDER_TIME

AN 6

M

Customer order time [format : HHMMSS]

PAYMENT_DATE

AN 10

M

Customer pay date [format : DD/MM/YYYY]

PAYMENT_TIME

AN 6

M

Customer pay time [format : HHMMSS]

MERCHANT_ID

AN 15

M

Merchant ID defined by 2C2P

ORDER_ID

AN 20

M

Unique merchant order number

  • Example: 00000000010000091203
  • Note: The same order number may appear in the file for different payment methods. For instance, 1 line item for Loyalty and 1 line item for Card Payment

INVOICE_NO

AN 50

M

Merchant Invoice Number

PAYMENT_TYPE

AN 3

M

Payment channel codes

  • 001 = Credit and debit cards
  • 002 = Cash payment channels
  • 003 = Direct debit
  • 004 = Others
  • 005 = Refund
  • 006 = Installment Payment
  • 007 = Loyalty Payment
  • 008 = Chargeback

PAYMENT_CHANNEL

AN 30

M

Refer to Payment Channel Matrix Table

AGENT_CODE

AN 30

M

Refer to Agent Code

AMOUNT

N 15

M

Amount in 2-decimal value

  • Example: 1000.00

DISCOUNT

N 15

M

Discount amount (Always 0)

TRANSACTION_FEE

N 15

M

Transaction fee, if needed

COMMISSION_FEE

N 15

M

Service fee charged to Merchant (MDR)

COM_VAT_AMOUNT

N 15

M

Commission Vat Amount (7 % of Commission Fee)

TAX Invoice No

AN 50

M

Tax invoice number which 2C2P issues to merchant on daily settlement

TAX Invoice Date

AN 10

M

Issuance date of tax Invoice (Pay-in date)

  • In DD/MM/YYYY format

TAX Invoice COM Amount

N 15

M

Tax Invoice COM Amount from Tax Invoice issued to merchant

TAX Invoice VAT Amount

N 15

M

Tax Invoice VAT Amount from Tax Invoice VAT issued to merchant

TAX Invoice SUM Amount

N 15

M

Tax Invoice Sum Amount = TAX Invoice Com Amount + TAX Invoice VAT Amount

WHT_NO

AN 50

O

WHT Number (Blank)

WHT_AMOUNT

N 15

M

Withholding Tax Amount (3% of ServiceFee)

PAYIN_AMOUNT

N 15

M

Total Payin Amount (Include Refund) (Amount - Commission Fee - COM_VAT_Amount + WHT Amount - EWT Amount)

SHIPPING_FEE

N 15

M

Shipping cost charged by Merchant (Always 0)

CurrencyCode

AN 3

M

ISO 4217 Currency Code

approval_code

AN 10

M

Authorization code from issuing bank

  • This field is only applicable when the customer pays with credit or debit card

eci

AN 2

M

ECI value

  • This field is only applicable when the customer pays with credit or debit card

masked_pan/Payment Ref Code

AN 20

M / O

(Optional) First 6 and last 4 digits of the credit card.

  • Example: 444321XXXXXX3212
  • This field is only applicable when the customer pays with credit or debit card
user_defined_1AN 150OReference number, booking number, tracking number or order number for merchant use.
user_defined_2AN 150OReference number, booking number, tracking number or order number for merchant use.
user_defined_3AN 150OReference number, booking number, tracking number or order number for merchant
user_defined_4AN 150OReference number, booking number, tracking number or order number for merchant use.
user_defined_5AN 150OReference number, booking number, tracking number or order number for merchant use.
MDRN 5MFull Payment MDR in percentage (%)
refund_noteAN 250ORefund / Chargeback notes
Issuer countryAN 3OCard Issuer Country
CARD_BRANDAN 30ORefer to Payment Channel Matrix Table
TxnIDN 10OTxn ID in PGW and 123
Merchant_NameAN 300OMerchant's name in 2C2P records
Ref IDAN 20OQR Payment = QR Ref ID
Cardholder nameAN 150OCardholder's name
Product DescriptionAN 250OProduct description
Promotion CodeAN 50OMerchant's Promotion Code
Acquirer DiscountN 15ODiscount given to cardholder by acquirer
Acquirer Discount CurrencyAN 3OCurrency of Discount given to cardholder by acquirer
MCP AmountN 15OCardholder's paid amount
MCP CurrencyAN 3OCardholder's paid currency
MCP Exchange RateN 15OCardholder's paid currency to merchant currency
EWT AmountN 15OEWT Amount if applicable
Custom Data 1AN 150OCustom dataset from 2C2P
Custom Data 2AN 150OCustom dataset from 2C2P
Redeemed PointsN 15ORedeemed points
Redeemed Points AmountN 15OPoints amount
Redeemed Voucher NameAN 50OVoucher code redeemed
Redeemed Voucher QuantityN 15ONumber of vouchers redeemed
Redeemed Voucher AmountN 15OTotal redeemed voucher amount