tutorial 3 min
Reconciliation
This guide covers how to verify your payouts — matching your Sales Disbursement Report against 2c2p or LiquidPay and reconciling reimbursements for CAG Funded Promotional Codes and CR Points.
Payment Service Providers
Download the Sales Disbursement Report from SAP Reports UI.
- Match the reference numbers: In the report, find ProcessorTxnRef (Column F) and match it against the Transaction Reference No. in the LiquidPay or 2c2p portal.
Sales Disbursement Report - ProcessorTxnRef Column
2c2p reference numbers typically start with 1XX; LiquidPay reference numbers typically start with 20XX.
- Check the disbursed amount: The total disbursed to you via 2c2p and LiquidPay appears under
- DisbursementsToTenants (Payment Processor) (Column AX), calculated as: Gross Amount − (Promotion discount + CR Points + Merchant Funded Promotion discount) + Shipping fee paid by customer − Payment Processor Deduction (MDR, inclusive of GST)
ProcessorTxnRef Column 
DisbursementsToTenants Column
- DisbursementsToTenants (Payment Processor) (Column AX), calculated as: Gross Amount − (Promotion discount + CR Points + Merchant Funded Promotion discount) + Shipping fee paid by customer − Payment Processor Deduction (MDR, inclusive of GST)
For steps on downloading 2c2p's or LiquidPay's own settlement report, see Reports.
- Account for refunds: If an order is refunded, iSC refunds the customer via their original payment method, and deducts that amount from your total 2c2p/LiquidPay settlement for the transaction date the refund was processed.
MDR charged on any payment method is non-refundable - except for VISA and MasterCard transactions processed through 2c2p.
CAG Funded Promotional Codes and CR Points
The total reimbursement is the aggregate of:
- Promo Discount Amount
- CR Point Amount
- CR Point Refund Amount
If a customer order is refunded, iSC recovers the previously reimbursed Promotional Code and CR Point value from you, offsetting it against your current period's reimbursement. If the recovery exceeds what's due to you (a net refund), you pay the difference to iSC via Interbank Giro.
Reimbursement Period
| Period | Indicative Settlement Date |
|---|---|
| 1st – 15th of the month | 25th of the same month* |
| 16th – end of month | 10th of the following month* |
Subject to delay due to weekends, public holidays or bank clearance.
Remittance & Invoice References
If you're being reimbursed, your bank remittance advice will show:
- [Store ID]-iSC 2C2P Promo+CR DD-DDMMYY [relevant reimbursement period]
- [Store ID]-iSC LP Promo+CR DD-DDMMYY [relevant reimbursement period]
Reimbursements for transactions fully redeemed by customers through Promotional Codes and/or CR Points (Processor = N/A) will be processed with reimbursements for transactions processed through 2c2p.
If a recovery is being made from you, your invoice will show:
- [Store ID] - Recovery of ISC 2C2P Promotion Codes and Changi Rewards points given to customers due to sales refund for period DD-DDMMYY [relevant reimbursement period]
- [Store ID] - Recovery of ISC LP Promotion Codes and Changi Rewards points given to customers due to sales refund for period DD-DDMMYY [relevant reimbursement period]
Retrieve invoices via EPIC (e-invoicing). No access? Contact the Merchant Service Desk via Okta SSO to get set up.