Reconciliation Reports
Reconciliation Reports
2C2P provides daily reconciliation reports to help merchants reconcile payment transactions. Reports are delivered via SFTP in CSV format with comprehensive transaction-level data including amounts, fees, taxes, and payment details.
Report Types
- IPP Reconciliation Report - Installment Payment Plan transactions with term details, interest rates, and monthly payment breakdowns
- Non-IPP Reconciliation Report - Full payment transactions including credit cards, debit cards, e-wallets, and alternative payment methods
Both reports follow the same file structure and field definitions, with IPP-specific fields populated only for installment transactions.
How It Works
SFTP Delivery
Reconciliation reports are automatically generated and delivered to your designated SFTP server daily. You do not need to request reports - they are pushed automatically at the scheduled settlement time.
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.
- Request Path : /input ( For File Pickup )
- Response Path : /output ( For File Drop )
File Information Time Reconciliation report file drop Before 4:00AM GMT+7 SimpleAuthorization file pickup 5:00AM GMT+7 SimpleAuthorization file drop Before 6:00AM GMT+7 OfflineAuthorization file pickup 2:00PM GMT+7 OfflineAuthorization file drop Before 6:00AM GMT+7 (next day) Tokenization/Refund file pickup 2:00AM GMT+7 Tokenization/Refund file drop Before 3:00AM GMT+7 Quickpay/Promocode file pickup Every hour Quickpay/Promocode file drop Within the next hour
File Naming Convention
Reconciliation report filenames follow a standardized format:
Reconcile2c2p_B_v2.4_MID_CURRENCY_yyyy-MM-dd_HHmmss.csvExample:
Reconcile2c2p_B_v2.4_JT_THB_2024-06-22_153136_all.csv
Reconcile2c2p_B_v2.4_JT_THB_2024-06-22_153136_ipp.csv
Reconcile2c2p_B_v2.4_JT_THB_2024-06-22_153136_nonIpp.csv| Component | Description |
|---|---|
Reconcile2c2p_B_v2.4 | Report identifier and version |
MID | Merchant ID (e.g., JT) |
CURRENCY | Settlement currency (e.g., THB, SGD, MYR) |
yyyy-MM-dd_HHmmss | Generation timestamp |
_all / _ipp / _nonIpp | Report type suffix |
File Format Specification
| Property | Value |
|---|---|
| Format | CSV (Comma-Separated Values) |
| Parameter Delimiter | Comma (,) |
| Record Delimiter | Line Break (\n) |
Report Structure
Reconciliation reports contain two record types:
Header Record (TYPE_TABLE = H)
Summary line containing merchant bank account details, pay-in date, and aggregate totals.
2C2P2023102301,2,H,test,0,12/10/2023,test,23/10/2023,000000,00/00/00,000000,702702000000000,00000000000000000000,00000000000000000000,000,000,000,4020.00,0.00,0.00,0.00,0.00,,,,,,,0.00,4020.00,0.00,SGD,000000,0,0,,,,,,,1340.00,,,,0.00,0.00,0.00,,,,,,,,,,,,,,,,,,,,,,,,,Detail Records (TYPE_TABLE = D)
Transaction-level data for each payment, refund, or chargeback. Each row includes payment details, fees, taxes, and settlement information.
2C2P2023102301,1,D,test,0,12/10/2023,test,11/10/2023,130643,11/10/2023,000000,702702000000000,rT1qtTw8siLut3MWQajjxPtLE,,006,VI,BANCO DAVIVIENDA S.A.,2010.00,0.00,0.00,0.00,0.00,
2C2P2310110037,11/10/2023,1.65,0.10,1.75,,0.00,2010.00,0.00,SGD,368938,05,491647XXXXXX8295,36050,SHOPIFY,,,,0.00,670.00,M,3,0.00,0.00,0.00,0.00,,,,COL,VI,8041222,2C2P SG Test B,,Chow Sum,Payment for rT1qtTw8siLut3MWQajjxPtLE,,0.00,,,,,0.00,,,,,,,,Download and Process Reports
- Connect to SFTP server using credentials provided by 2C2P
- Download the report file from
/outputpath - Parse the CSV using your preferred tool
- Reconcile transactions against your internal records
Data Parameters
The reconciliation report contains the following fields. For detailed field definitions, data types, and mandatory/optional status:
- IPP Reconciliation Report Fields - Complete field reference with IPP-specific parameters
- Non-IPP Reconciliation Report Fields - Complete field reference for full-payment transactions
Report Version History
| Version | Release Date | Key Changes |
|---|---|---|
| v2.4 | 2026 | Added Payment Type 016 (Loyalty Refund) for automatic loyalty refund adjustment handling |
| v2.3 | 2026 | Added AGENT_CHANNEL_CODE (column 85); renamed PAYMENT_CHANNEL → CHANNEL_CODE, PAYMENT_AGENT_SERVICE → AGENT_CODE |
| v2.2 | 2026 | Added CARDTYPE, CARDLEVEL fields (columns 83-84) |
| v2.1 | 2026 | Added BACKEND_REFERENCE, REFUND_CHARGEBACK_FEE, REFUND_CHARGEBACK_VAT (columns 80-82); amount precision increased to 5 decimal places |
| v2.0 | 2025 | Added BACKEND_REFERENCE, REFUND_CHARGEBACK_FEE, REFUND_CHARGEBACK_VAT |
| v1.8 | 2025 | Added loyalty/voucher fields: REDEEMED_POINTS, REDEEM_POINTS_AMOUNT, VOUCHER_DESCRIPTION, REDEEM_VOUCHER_AMOUNT, REDEEMED_VOUCHERS_COUNT, PAYMENT_TYPE_NAME |
| v1.7 | 2025 | Added EWT_AMOUNT, CUSTOM_DATA_ONE, CUSTOM_DATA_TWO |
| v1.6 | 2025 | Added MCP fields: ACQUIRER_DISCOUNT, ACQUIRER_DISCOUNT_CURRENCY, MCP_AMOUNT, MCP_CURRENCY, MCP_EXRATE |
| v1.5 | 2024 | Added QR_REF_ID, CARDHOLDER_NAME, PRODUCT_DESCRIPTION, PROMOTION_CODE |
| v1.3 | 2024 | Added TRANSACTION_ID, MERCHANT_NAME |
| v1.2 | 2024 | Added CARD_BRAND |
| v1.1 | 2024 | Added ISSUER_COUNTRY |
Related Documentation
- Batch Services Overview - Introduction to 2C2P batch processing
- Payment Channel Matrix - Reference for PAYMENT_CHANNEL and CARD_BRAND values
- Agent Code Reference - Reference for AGENT_CODE values
- Authorize Batch Report - Daily authorization summary report
- Refund Batch Report - Daily refund processing report
Need Help?
Contact 2C2P Technical Support at [email protected] for:
- SFTP account setup or credential resets
- Report delivery issues or missing files
- Field clarifications or reconciliation discrepancies