⬟ How Payment Gateway Settlements Work and Why the Bank Credit Is Always Less Than Orders :
When a customer pays for an online order, the money passes through the payment gateway (Razorpay, PayU, Cashfree, CCAvenue, Paytm for Business), which processes the transaction, deducts its fees, and settles the net amount to the merchant's bank on a T+1 or T+2 cycle. The settlement amount is always less than the gross order value. The gap comes from five components: MDR/TDR (Merchant/Transaction Discount Rate): A percentage fee per transaction. Rates by payment method: UPI under Rs. 2,000 is 0% (RBI mandate); UPI above Rs. 2,000 is 0.25% to 0.40%; credit cards 1.5% to 2.5%; debit cards 1.0% to 1.8%; net banking 1.5% to 2.0%. GST on gateway fees: 18% GST on the MDR, deducted from settlement by the gateway and remittable by the merchant as input tax credit. Refunds: Customer returns or cancellations reversed to the customer and deducted from the next settlement. Chargebacks: Customer-disputed transactions deducted pending resolution. Settlement timing: End-of-month orders settling in the next month create a timing difference between orders collected and bank credits in any given period.
A small MSME online gifts store in Hyderabad, Telangana processed 120 orders in October, total order value Rs. 3,60,000. October Razorpay settlement report: Gross collections: Rs. 3,60,000 MDR/TDR deducted: Rs. 5,760 (blended rate approximately 1.6%) GST on MDR (18%): Rs. 1,037 Refunds processed: Rs. 8,400 (4 returns) Chargebacks: Rs. 2,200 (1 disputed transaction) Net settlement to bank: Rs. 3,42,603 Timing difference: Rs. 4,500 (2 orders collected 30-31 Oct, settling 1-2 Nov) Actual bank credit in October: Rs. 3,38,103 Accounting entries required: Revenue recognised: Rs. 3,60,000 (gross order value including refunded orders, to be reconciled with GST invoices) MDR expense: Rs. 5,760 (debit gateway charges, credit settlement receivable) GST input credit: Rs. 1,037 (recoverable from GST portal) Refund adjustment: Rs. 8,400 (reverse revenue, reverse GST on refunded invoices) Chargeback suspense: Rs. 2,200 (pending resolution) Unsettled receivable: Rs. 4,500 (gateway receivable, settles in November)
⬟ Why Gateway Reconciliation Is Not Optional for E-Commerce MSMEs :
Accurate gateway reconciliation produces three specific benefits. The first is correct revenue and expense recording. Booking only the net bank credit understates gross revenue and leaves MDR charges unrecorded. The correct approach is gross order value as revenue and MDR as a business expense. This matters especially for GST: tax is calculated on the full transaction value charged to the customer, not the net bank credit. The second is clean GST reconciliation. GSTR-1 requires all supplies at full invoice value. Refunds and chargebacks not accounted for with credit notes leave the GST return overstating output tax, creating differences between GSTR-1, GSTR-3B, and GSTR-2A that can attract scrutiny. The third is recoverable input tax credit. The 18% GST on gateway MDR is a legitimate input credit appearing in GSTR-2A under the gateway's GSTIN. Missing this can cost an e-commerce MSME Rs. 10,000 to Rs. 50,000 annually on Rs. 50 lakh to Rs. 2.5 crore of online orders.
A small MSME online electronics accessories store in Pune, Maharashtra was processing approximately Rs. 12 lakh per month in orders through Razorpay. The CA set up a monthly reconciliation spreadsheet comparing the Razorpay settlement report (downloaded as a CSV from the Razorpay dashboard) to the accounting entries in Tally. Monthly MDR recovery: approximately Rs. 18,000 in MDR fees correctly recorded as expenses, Rs. 3,240 in input tax credit claimed on gateway GST charges. Annual input credit recovered: Rs. 38,880. Before the reconciliation process was set up, none of this was being claimed. A small MSME D2C skincare brand in Mumbai, Maharashtra was processing orders through Cashfree. The CA noticed that the gateway reconciliation was showing Rs. 22,000 in chargebacks over three months that had been deducted from settlements but not matched to any disputed orders in the CRM. Investigation revealed that three orders had been charged back by customers claiming non-delivery but the orders had in fact been delivered with courier proof. The business successfully contested two of the three chargebacks, recovering Rs. 14,600. Without the reconciliation, the chargeback deductions would have been absorbed silently as unexplained settlement shortfalls.
For small e-commerce MSME owners, gateway reconciliation converts the payment gateway from a black box where orders go in and bank credits come out into a transparent, auditable transaction record. The CA advising an e-commerce MSME benefits from a clean monthly gateway reconciliation because it makes the revenue audit trail complete: every rupee of revenue can be traced from invoice to gateway transaction to bank credit. For GST officers reviewing GSTR-1 and 2A mismatches, a complete gateway reconciliation record demonstrates that all adjustments (refunds, chargebacks, timing differences) have been accounted for correctly.
⬟ How E-Commerce MSMEs Currently Handle Gateway Accounting :
Most small e-commerce MSME owners handle gateway accounting in one of two ways, both of which are incorrect. The most common approach is to book the net bank credit from the gateway as revenue. This underreports gross revenue, leaves gateway fees unrecorded, misses input tax credit on gateway GST, and fails to separately account for refunds and chargebacks. The second approach is to book each order individually as revenue but not reconcile to the gateway settlement report, resulting in gateway fees, refunds, and chargebacks being unrecorded until they are noticed as unexplained bank differences at year-end. A smaller proportion of growth-stage e-commerce MSMEs with monthly CA advisory relationships have implemented structured gateway reconciliation processes, but this remains the minority.
⬟ How Gateway Reconciliation Is Evolving for Indian E-Commerce MSMEs :
Payment gateways are improving their reporting infrastructure. Razorpay's settlement reconciliation reports now provide transaction-level detail including the original order ID, payment method, MDR rate applied, and settlement date, making it significantly easier to match gateway transactions to accounting entries. Cashfree and PayU offer similar detailed settlement CSV exports. Tally integration plugins for major Indian payment gateways are emerging, allowing automatic import of gateway settlement data into Tally ledgers with pre-mapped accounting treatment. For MSMEs processing high order volumes, these integrations reduce manual reconciliation effort significantly. E-commerce platforms including Shopify India and WooCommerce are building gateway reconciliation reports directly into their analytics dashboards.
⬟ The Four-Part Gateway Reconciliation Framework :
Gateway reconciliation has four components to check every month. Gross-to-net settlement check: Start with total gross orders from the order management system. Subtract MDR deductions, GST on MDR, refunds, and chargebacks. The result should equal the gateway's total settlement amount for the month. Any difference is a discrepancy to investigate. Settlement-to-bank check: Gateway settlement amount, adjusted for opening and closing unsettled receivable (T+1/T+2 timing), should equal total bank credits from the gateway in the month. Refund and chargeback accounting: Each refund must be matched to the original invoice with a credit note and GST reversed in GSTR-1. Each chargeback sits in a suspense account: reversed if the merchant wins the dispute, expensed if the merchant loses. Input tax credit capture: GST charged by the gateway on MDR should appear as input credits in GSTR-2A under the gateway's GSTIN. Cross-check total gateway GST deducted in the month against the GSTR-2A input credit amount.
● Step-by-Step Process
Download the monthly settlement report from the gateway dashboard: Razorpay (Accounts and Settings > Settlements > Download CSV), PayU (Reports > Settlement Report), Cashfree (Reports > Settlement). Ensure the report covers the full calendar month. Summarise the CSV: total gross collections, total MDR deductions, total GST on MDR, total refunds, total chargebacks, and net settlement. In Tally, create dedicated ledger accounts: Gateway Charges (Indirect Expenses), Gateway GST Input Credit (Current Assets), Gateway Receivable (Current Assets), Chargeback Suspense (Current Assets). Pass a single journal voucher: debit Revenue at gross order value, credit Gateway Receivable at net settlement, credit Gateway Charges at MDR amount, credit Gateway GST Input Credit at GST on MDR. Reconcile Gateway Receivable: opening balance plus net settlement minus bank credits equals closing balance. Confirm against the unsettled amount visible in the gateway dashboard. For each refund: raise a credit note against the original invoice in Tally, reverse the GST, and note the refund transaction ID from the settlement report. For chargebacks: debit Chargeback Suspense, credit Gateway Receivable. Reverse when won; expense (debit Chargeback Loss) when the dispute is lost. Cross-check gateway GST total in the settlement report against GSTR-2A input credit for the gateway's GSTIN.
● Tools & Resources
Razorpay dashboard: Accounts and Settings > Settlements provides transaction-level settlement CSV with order ID, payment method, MDR rate, and settlement date. PayU: Reports > Settlement Report. Cashfree: Reports > Settlement. All three provide downloadable CSV exports that can be imported into Excel or Google Sheets for reconciliation. Tally Prime supports custom ledger creation for gateway accounts and journal voucher entry for settlement accounting. The gateway's GSTIN (required for GSTR-2A cross-check) is available on the gateway's GST invoice to the merchant, issued monthly.
● Common Mistakes
Booking the net bank credit as revenue is the most common mistake. It understates gross revenue, leaves MDR unrecorded as an expense, and produces incorrect GST output. The correct treatment is gross order value as revenue and MDR as gateway charges expense. The gap between gross revenue and net bank credit is always reconcilable through the settlement report. Not raising credit notes for refunds is the second mistake. A gateway-processed refund reduces the bank credit but creates no automatic accounting entry in Tally. Without a credit note matched to the original invoice, the original revenue and GST remain in the books and GSTR-1 overstates output supplies. Ignoring input tax credit on gateway fees is the third mistake. The 18% GST on MDR is a legitimate input credit in GSTR-2A. An e-commerce MSME that does not claim this credit is overpaying GST every month.
● Challenges and Limitations
Gateway settlement reports from different providers use different formats, column names, and settlement timing conventions. Razorpay, PayU, Cashfree, and CCAvenue each have their own CSV structure, which means the reconciliation template must be adapted to each gateway's report format. MSMEs using multiple gateways face the additional complexity of consolidating settlement data across platforms. High-volume e-commerce businesses with thousands of transactions per month cannot perform transaction-level reconciliation manually. The reconciliation must be done at the summary level (total gross, total MDR, total refunds by category) using pivot tables or automated tools. Transaction-level matching is reserved for exception investigation when totals do not reconcile.
● Examples & Scenarios
A small MSME online home decor store in Jaipur, Rajasthan processes Rs. 8 lakh per month through PayU. The CA set up a Google Sheets template with columns for order date, order ID, gross amount, MDR deducted, GST on MDR, and settlement date. The PayU CSV is pasted monthly and pivot tables summarise totals by payment method. MDR rates are checked against the merchant agreement. In Month 3, the template flagged Rs. 4,200 of MDR overcharges on credit card transactions (2.3% applied versus 2.0% contracted). PayU credited the overcharge the following month. A small MSME subscription box service in Delhi processes recurring payments through Razorpay. The monthly reconciliation matched each subscriber's payment to the Razorpay transaction ID and checked the churn report against refunds in the settlement. One month the process revealed three failed recurring charges totalling Rs. 5,400 that had not been flagged in the CRM: three subscribers were receiving the product without being charged. These were corrected in the next billing cycle.
● Best Practices
Perform gateway reconciliation monthly without exception, not only at year-end. Monthly reconciliation takes thirty to sixty minutes once the process and templates are set up. Year-end reconciliation of twelve months of unreconciled gateway data can take days. Download and store the gateway settlement report on the first working day of each month before the prior month's data is overwritten or archived in the gateway dashboard. Some gateways limit the history accessible without a paid plan. Local storage of monthly reports ensures data is available for any period without dependence on the gateway's data retention policy. Verify the MDR rates applied in the settlement report against the merchant agreement rates for each payment method at least quarterly. Gateways occasionally apply incorrect rates due to system configuration errors. Any overcharge is recoverable if identified promptly.
⬟ Disclaimer :
This content is intended for informational and educational purposes only and does not constitute professional accounting, tax, or financial advice. Payment gateway fee structures, GST treatment of gateway charges, and settlement timelines described are based on general practices of major Indian payment gateways as of the date of this article. Fee rates and policies change. MSME owners should verify current rates with their gateway provider and consult a qualified chartered accountant for gateway accounting guidance specific to their GST registration and business structure.
