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

At the specified time, 2C2P will drop a CSV file in the SFTP server. The file name follows the format Reconcile2c2p_A_v2.1_MID_CURRENCY_yyyy-MM-dd_HHmmss.csv
The merchant must get the file from the SFTP Server.
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_v2.1_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.

2C2P2023102301,6,H,test,0,23/10/2023,test,23/10/2023,000000,00/00/00,000000,702702000000000,00000000000000000000,00000000000000000000,000,000,000,572.00,0.00,0.00,17.16,1.19,,,,,,,0.51,554.16,0.00,SGD,000000,0,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0.0,0.0
2C2P2023102301,1,D,test,0,23/10/2023,test,20/10/2023,102619,20/10/2023,000000,702702000000000,234r23r23r,,001,VI,FIRST DATA CORPORATIONS,1.00000,0.00000,0.00000,0.03000,0.00000,2C2P-231020-0023,21/10/2023,0.66000,0.04000,0.70000,,0.00090,0.97090,0.00000,SGD,478170,05,411111XXXXXX1111,,,,,,3.00,,USA,VI,8076932,2C2P SG Test B,,Customer,Payment for 234r23r23r,,0.00,,,,,0.00,,,,,,,,,7315705,0.00000,0.00000
2C2P2023102301,2,D,test,0,23/10/2023,test,20/10/2023,101800,20/10/2023,000000,702702000000000,998899,,001,VI,FIRST DATA CORPORATIONS,10.00000,0.00000,0.00000,0.30000,0.02000,2C2P-231020-0023,21/10/2023,0.66000,0.04000,0.70000,,0.00900,9.68900,0.00000,SGD,319581,05,411111XXXXXX1111,,,,,,3.00,,USA,VI,8076907,2C2P SG Test B,,Customer,Payment,,0.00,,,,,0.00,,,,,,,,,7315689,0.00000,0.00000
2C2P2023102301,3,D,test,0,23/10/2023,test,20/10/2023,150350,20/10/2023,000000,702702000000000,acxasd123,,001,VI,FIRST DATA CORPORATIONS,10.00000,0.00000,0.00000,0.30000,0.02000,2C2P-231020-0023,21/10/2023,0.66000,0.04000,0.70000,,0.00900,9.68900,0.00000,SGD,627247,05,411111XXXXXX1111,,,,,,3.00,,USA,VI,8078188,2C2P SG Test B,,Customer,Payment for acxasd123,,0.00,,,,,0.00,,,,,,,,,7316638,0.00000,0.00000

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 type codes 001 = Credit and debit cards / Wallets 002 = Cash payment channels 003 = Direct debit 004 = Others 005 = Refund 006 = Installment Payment 007 = Loyalty Payment 008 = Chargeback ~~009 = Chargeback Reversal~~ 010 = Other Charges 011 = Authorize Charges 012 = Void Charges 013 = Sale/Capture Interchange Charges 014 = Refund Interchange Charges 015 = Chargeback Interchange Charges
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_1	AN 150	O	Reference number, booking number, tracking number or order number for merchant use.
user_defined_2	AN 150	O	Reference number, booking number, tracking number or order number for merchant use.
user_defined_3	AN 150	O	Reference number, booking number, tracking number or order number for merchant
user_defined_4	AN 150	O	Reference number, booking number, tracking number or order number for merchant use.
user_defined_5	AN 150	O	Reference number, booking number, tracking number or order number for merchant use.
MDR	N 5	M	Full Payment MDR in percentage (%)
refund_note	AN 250	O	Refund / Chargeback notes
Issuer country	AN 3	O	Card Issuer Country
CARD_BRAND	AN 30	O	Refer to *Payment Channel Matrix Table*
TxnID	N 10	O	Txn ID in PGW and 123
Merchant_Name	AN 300	O	Merchant's name in 2C2P records
Ref ID	AN 20	O	QR Payment = QR Ref ID
Cardholder name	AN 150	O	Cardholder's name
Product Description	AN 250	O	Product description
Promotion Code	AN 50	O	Merchant's Promotion Code
Acquirer Discount	N 15	O	Discount given to cardholder by acquirer
Acquirer Discount Currency	AN 3	O	Currency of Discount given to cardholder by acquirer
MCP Amount	N 15	O	Cardholder's paid amount
MCP Currency	AN 3	O	Cardholder's paid currency
MCP Exchange Rate	N 15	O	Cardholder's paid currency to merchant currency
EWT Amount	N 15	O	EWT Amount if applicable
Custom Data 1	AN 150	O	Custom dataset from 2C2P
Custom Data 2	AN 150	O	Custom dataset from 2C2P
Redeemed Points	N 15	O	Redeemed points
Redeemed Points Amount	N 15	O	Points amount
Redeemed Voucher Name	AN 50	O	Voucher code redeemed
Redeemed Voucher Quantity	N 15	O	Number of vouchers redeemed
Redeemed Voucher Amount	N 15	O	Total redeemed voucher amount
Payment Type Name	AN 50	O	Payment Type Description
Backend Reference No	AN 50	O	Internal Reference No
Refund Chargeback Fee	N 15	O	Refund Chargeback fee
Refund Chargeback VAT	N 15	O	Refund Chargeback VAT amount

Reconcile Report

👍
Connect using SFTP

How to get the report

🚧
File Format Specification

📘
Data Attribute Reference

Data Parameters

👍
Sample File

👍Connect using SFTP

How to get the report

🚧File Format Specification

📘Data Attribute Reference

Data Parameters

👍Sample File

👍
Connect using SFTP

🚧
File Format Specification

📘
Data Attribute Reference

👍
Sample File