An e-commerce company processing ₹3 crore per month in card transactions receives monthly chargeback deductions of ₹8–15 lakh in settlement statements. The chargebacks are for transactions 30–90 days old. The finance team’s process: match each chargeback deduction to the original transaction in the order management system, reverse the revenue, issue a GST credit note, and update the settlement reconciliation.
Without a systematic matching process, this takes 3–4 days per month. With a structured reconciliation workflow, it takes 4 hours.
How Chargebacks Appear in Settlement Statements
Payment gateways do not send a separate notification for each chargeback — they deduct the chargeback amount from the next available settlement. The settlement statement will show:
- Gross collections: Total payments processed in the settlement period
- Refunds issued: Refunds initiated by the merchant during the period
- Chargebacks: Deductions for customer-initiated disputes (may include transactions from 1–4 months prior)
- Chargeback fees: Processing fees charged per dispute
- MDR: Merchant discount rate deductions
- Net settlement: Amount actually credited to the merchant’s bank account
| Component | Example (monthly) |
|---|---|
| Gross collections | ₹85,00,000 |
| Refunds | −₹2,50,000 |
| Chargebacks | −₹3,80,000 |
| Chargeback fees (38 × ₹1,500) | −₹57,000 |
| MDR (1.8%) | −₹1,43,100 |
| Net settlement | ₹77,69,900 |
The bank statement shows a credit of ₹77,69,900. The reconciliation must account for all five components.
Matching Chargebacks to Original Transactions
Chargebacks listed in the settlement statement typically include:
- Transaction date (original)
- Transaction amount
- Order ID or merchant reference
- Reason code (why the dispute was raised)
The matching process:
- Extract chargeback list from the settlement statement
- Match each chargeback to the original transaction using Order ID or transaction reference
- If the original transaction was in a prior accounting period, create a cross-period reversal entry
- If the original transaction cannot be matched (due to reference data loss), flag for investigation
Unmatched chargebacks — where the original transaction cannot be identified — are a data quality issue. Common causes: the order ID in the settlement statement does not match the format in the order management system, or the chargeback is for a transaction that was already refunded by the merchant.
Revenue Reversal for Chargebacks
When a chargeback is matched to an original transaction, the revenue recognised must be reversed:
Original transaction (e.g., October):
- Dr. Bank / Settlement receivable ₹5,900
- Cr. Revenue ₹5,000
- Cr. GST payable ₹900
Chargeback received (e.g., January):
- Dr. Chargeback expense ₹5,000
- Dr. GST adjustment ₹900
- Cr. Settlement payable ₹5,900
The GST adjustment requires a credit note to be issued in January — even though the original invoice was raised in October. The credit note in January offsets the October GST liability in the current period’s GSTR-1.
Rolling Reserve Reconciliation
When chargeback ratios are elevated, gateways impose a rolling reserve — a percentage of daily settlements withheld for a period (typically 90–180 days) to cover potential future chargebacks. A 5% rolling reserve on a ₹3 crore monthly settlement withholds ₹15 lakh per month.
Rolling reserve reconciliation:
- Track the reserve balance: Total withheld minus total released
- Match releases to original withholding dates: Funds held in January should be released in April (for 90-day reserve)
- Reconcile the reserve balance to the gateway’s statement: The gateway provides a monthly reserve statement showing the balance
Unreconciled rolling reserves are understated receivables — a common source of cash position distortion for high-volume merchants.
Chargeback Dispute Response in Reconciliation Workflow
Not all chargebacks are valid. Merchants can dispute chargebacks by providing evidence (delivery proof, communication records, signed acknowledgements) through the gateway’s dispute resolution portal.
From a reconciliation perspective:
- Won disputes: The chargeback deduction is reversed in the next settlement — must be matched to the original chargeback deduction
- Lost disputes: The chargeback expense remains; the revenue reversal stands
The reconciliation system must track disputed chargebacks separately from accepted ones, and match the reversal when a dispute is won — preventing double-counting of chargeback expense.
Reconciliation software India that parses gateway settlement statements — including chargeback lines, chargeback fees, and rolling reserve movements — and matches them to original transactions in the order management system eliminates the most labour-intensive part of payment gateway reconciliation.
Payment gateway reconciliation software that handles the cross-period matching (current-period chargeback against prior-period transaction) and generates the corresponding revenue reversal entries automatically ensures P&L accuracy without manual journal entry creation.
The Reserve Bank of India publishes chargeback dispute resolution guidelines for payment system participants — which define the maximum dispute timelines that determine how far back chargebacks can reach in the reconciliation.