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 theSFTP 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 TypeMandatory attributes
- A: Alphabet
- AN: Alphanumeric
- C: Characters
- B: Boolean
- D: Decimal
- N: Numeric
- 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.00000Parameter | 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) |
TRANSACTION_DATE | AN 10 | M | Transaction date [format : DD/MM/YYYY] |
TRANSACTION_TIME | AN 6 | M | Transaction time [format : HHMMSS] |
SETTLEMENT_DATE | AN 10 | M | Settlement date [format : DD/MM/YYYY] |
SETTLEMENT_TIME | AN 6 | M | Settlement time [format : HHMMSS] |
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 |
ORDERID_INVOICENO / ORDER_ID | AN 20 | M | Unique merchant order number
Applicable only to HSBC Reconcile Report |
MERCHANT_INVOICE_NO / INVOICE_NO | AN 50 | M | Merchant Invoice Number |
PAYMENT_TYPE | AN 3 | M | Payment type codes 001 = Credit and debit cards / Wallets Added 008 in Version 1.9 |
PAYMENT_CHANNEL / | AN 30 | M | Refer to Payment Channel Matrix Table In version 2.3 onwards, |
AGENT_CODE / | AN 30 | M | Refer to Agent Code In version 2.3 onwards, |
AMOUNT | N 15 | M | Amount in 2-decimal value
|
DISCOUNT | N 15 | M | Discount amount (Always 0) |
TRANSACTION_FEE | N 15 | M | Transaction fee, if needed |
SERVICE_FEE | N 15 | M | Service fee charged to Merchant (MDR) |
COMMISSION_FEE | N 15 | M | Service fee charged to Merchant (MDR) |
VAT_SERVICE_FEE | N 15 | M | Commission Vat Amount |
COM_VAT_AMOUNT | N 15 | M | Commission Vat Amount |
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)
|
TOTAL_SERVICE_FEE_AMOUNT / | N 15 | M | Tax Invoice COM Amount from Tax Invoice issued to merchant |
TOTAL_VAT_AMOUNT / | N 15 | M | Tax Invoice VAT Amount from Tax Invoice VAT issued to merchant |
TOTAL_DEDUCT_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) |
TOTAL_PAYIN_AMOUNT / 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) |
CURRENCY_CODE / CurrencyCode | AN 3 | M | ISO 4217 Currency Code |
APPROVAL_CODE / approval_code | AN 10 | M | Authorization code from issuing bank
|
ECI / eci | AN 2 | M | ECI value
|
MASKED_PAN_OR_PAYMENT_REF_CODE | AN 20 | M / O | (Optional) First 6 and last 4 digits of the credit 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 |
TRANSACTION_ID / TxnID | N 10 | O | Txn ID in PGW and 123 |
MERCHANT_NAME / Merchant_Name | AN 300 | O | Merchant's name in 2C2P records |
QR_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_EXRATE | N 15 | O | Cardholder's paid currency to merchant currency |
EWT_AMOUNT | N 15 | O | EWT Amount if applicable |
CUSTOM_DATA_ONE | AN 150 | O | Custom dataset from 2C2P |
CUSTOM_DATA_TWO | AN 150 | O | Custom dataset from 2C2P |
REDEEMED_POINTS | N 15 | O | Redeemed points |
REDEEMPOINTS_AMOUNT | N 15 | O | Points amount |
VOUCHERDESCRIPTION | AN 255 | O | Description of voucher |
REDEEMVOUCHERAMOUNT | N 15 | O | Total redeemed voucher amount |
REDEEMEDVOUCHERSCOUNT | N 15 | O | Number of vouchers redeemed |
PAYMENTTYPE_NAME | AN 50 | O | Payment Type Name |
BACKEND_REFERENCE | 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 |
CARDTYPE | AN 15 | O | Type of Card |
CARDLEVEL | AN 15 | O | Level of Card |
AGENT_CHANNEL_CODE | AN 50 | O | Refer to Payment Channel Matrix Table |
Updated 10 days ago