! Advertisements ! ⁈

These sections are reserved for advertisements. While our in-house advertising system is under development, Third party Ad-sense will be displayed here. For more information, please refer to our “Advertisements” insight.

Go to Index or search here


Payment Gateway Settlement Reconciliation for MSMEs: How to Match Gateway Deposits to Orders and Keep Your Books Accurate

⬟ Intro :

A small MSME online clothing store in Bengaluru, Karnataka found a Rs. 1.7 lakh unexplained gap at year-end. Total Razorpay deposits: Rs. 36.9 lakh. Total orders processed: Rs. 38.6 lakh. The CA ran the gateway reconciliation. Razorpay had deducted: Rs. 76,400 in MDR/TDR fees, Rs. 14,200 in GST on those fees, Rs. 18,600 in refunds, and Rs. 6,300 in chargebacks. Total deductions: Rs. 1,15,500. The remaining Rs. 54,500 was a timing difference: last-week-of-March orders not yet settled to the bank. Every deduction needed a separate accounting entry. None had been recorded. Revenue was understated, MDR fees unrecorded, refunds not matched to invoices, and GST on sales over-reported in GSTR-1.

For an e-commerce MSME, the payment gateway settlement report is the bridge between the order management system and the bank account. Without reconciling this report, the business cannot know its true revenue, cannot correctly record gateway charges as expenses, cannot account for refunds and chargebacks accurately, and cannot produce a reliable GST reconciliation. Gateway reconciliation errors compound over time. A mismatch left uncorrected for three months becomes a significant accounting problem at year-end. Regular monthly reconciliation, which takes under an hour once the process is set up, prevents this accumulation.

This article covers how payment gateway settlements work, what causes the gap between order value and bank credit, how to reconcile the gateway settlement report with accounting entries, and how to handle refunds, chargebacks, and MDR fees in the accounts.

⬟ 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.


⬟ How Desi Ustad Can Help You :

Download last month's settlement report from the payment gateway dashboard right now. In the downloaded CSV, sum the following columns: gross collections, MDR/TDR deducted, GST on MDR, refunds, and chargebacks. Verify that gross collections minus all deductions equals the net settlement amount. Then check whether the net settlement in the report matches what was actually credited to the bank account (accounting for the T+1/T+2 timing lag for end-of-month orders). If there is an unexplained difference, that is the starting point for the reconciliation. If the numbers reconcile, the task is to ensure each component is correctly recorded in Tally or the accounting software with separate entries for revenue, gateway charges, input credit, and refund adjustments.

Register your business with our online directory or join our bidding platform.

Frequently Asked Questions (FAQs)

Q1: What is MDR and how is it different from TDR?

A1: The rates applied vary by payment method and are set in the merchant agreement with the gateway. UPI transactions up to Rs. 2,000 are zero MDR under an RBI mandate that has been in effect since January 2020. For higher-value UPI transactions, rates range from 0.25% to 0.40% depending on the gateway and merchant category. Credit card rates are typically 1.5% to 2.5%, with premium credit cards (Amex, Diners) often attracting higher rates. Debit cards range from 0.4% to 1.0% for RuPay and 0.9% to 1.8% for Visa/Mastercard. Net banking rates are typically 1.5% to

Q2: How should an MSME record MDR charges in Tally for GST purposes?

A2: In Tally Prime, setting up the Gateway Charges ledger under Indirect Expenses with the correct GST treatment (input credit at 18% IGST or 9% CGST plus 9% SGST depending on the gateway's place of supply) ensures that when the ledger is selected in a journal voucher, Tally automatically handles the GST component. The gateway's GSTIN (which must be entered as the supplier GSTIN in the journal voucher) links the input credit to the GSTR-2A reconciliation. Tally will then track whether the gateway's GST credit has been reflected in GSTR-2A during the monthly GST reconciliation. If

Q3: What is the correct GST treatment for online sales refunds?

A3: For e-commerce MSMEs selling through their own website, the credit note is issued directly to the customer. For MSMEs selling on marketplace platforms (Amazon, Flipkart, Meesho), the platform may issue the credit note on the seller's behalf under the TCS (Tax Collected at Source) framework. In this case, the seller must ensure that the credit notes issued by the platform on their behalf are reflected correctly in their GSTR-1 (as seller credit notes) and that the corresponding GST reversal is claimed in GSTR-3B. The monthly gateway reconciliation should include a step that verifies each refund

Q4: What is a chargeback and how should it be accounted for?

A4: The chargeback process in India operates through the RBI's dispute resolution framework and follows the rules of the relevant card network (Visa, Mastercard, RuPay) or payment system (UPI, net banking). For UPI chargebacks, the NPCI dispute resolution mechanism applies. Merchants typically have 7 to 10 business days from receiving the chargeback notification to respond with evidence. Razorpay and PayU provide a dispute management interface in their dashboard where merchants can upload evidence and track dispute status. For accounting: when the chargeback is initiated, debit Chargeback Suspense and credit Gateway Receivable or Bank (reducing the asset).

Q5: Why is there always a difference between the gateway's settlement amount and the bank credit?

A5: The practical test for whether a settlement-to-bank difference is a timing difference or a genuine discrepancy is: does the closing balance of the Gateway Receivable ledger in Tally match the pending settlement amount shown in the gateway dashboard? Razorpay shows pending settlements clearly on the main settlements page. PayU and Cashfree show unsettled balance in their settlement reports. If the Tally Gateway Receivable closing balance matches the gateway's pending settlement balance, the difference between the monthly settlement amount and the bank credit is entirely explained by timing and no further investigation is needed. If the

Q6: How do I find my payment gateway's GSTIN for input tax credit matching?

A6: For major Indian payment gateways: Razorpay's registered entity is Razorpay Software Private Limited with GSTIN 29AAHCR6089J1ZP (Karnataka). PayU's registered entity is PayU Payments Private Limited. Cashfree's registered entity is Cashfree Payments India Private Limited. These GSTINs can change if the gateway updates its registration or operates through multiple entities. Always verify the GSTIN from the current monthly GST invoice rather than from a reference document that may be outdated. When entering the gateway's GSTIN in Tally as a supplier, Tally will track all input credits from that supplier and flag any discrepancy between the credits

Q7: How should an MSME handle gateway settlements when selling through marketplace platforms like Amazon or Flipkart?

A7: Marketplace TCS is a significant reconciliation item for MSME sellers. Under Section 52 of the CGST Act, e-commerce operators (Amazon, Flipkart, Meesho, etc.) must deduct 1% TCS on net taxable supplies made through their platform and remit it to the government. This TCS appears as a deduction in the marketplace settlement and as an input credit available to the seller in their GST portal account. The seller can claim this TCS credit in their GSTR-3B in the month following its deduction, reducing their net GST payable. For income tax purposes, marketplace TCS is available as

Q8: What should an MSME do if the payment gateway settlement amount does not match its own order records?

A8: Failed payments are the most common cause of apparent mismatches. A customer initiates a payment, the order is created in the e-commerce system, but the payment fails at the gateway level (card declined, UPI timeout, insufficient balance). The order exists in the order management system but no money was collected and no settlement will occur. The reconciliation process should routinely exclude failed-payment orders from the expected settlement amount. Most e-commerce platforms generate a payment status field in the order export that distinguishes paid, failed, and pending orders. Using this field to filter the order export

Q9: How does the T+1 and T+2 settlement cycle affect month-end accounting for e-commerce MSMEs?

A9: The T+2 settlement timing can be more complex around public holidays and weekends. The settlement clock typically counts working days, not calendar days. An order processed on a Friday under T+2 settlement may settle on the following Tuesday if Monday is a public holiday. Gateways display expected settlement dates for each transaction in their dashboard. For month-end closing, the most accurate approach is to check the gateway dashboard on the last day of the month and record the Gateway Receivable balance as the sum of all transactions with settlement dates falling in the following month.

Q10: How often should an MSME review its payment gateway merchant agreement rates?

A10: Negotiating MDR rates is more accessible for MSME merchants than many owners realise. Payment gateways compete actively for merchants processing above Rs. 5 to Rs. 10 lakh per month. A simple email to the merchant's account manager citing the current monthly volume and requesting a rate review is typically sufficient to initiate the conversation. Benchmarking the rates against competing gateways is the most effective negotiating leverage. Switching costs between Razorpay, PayU, and Cashfree are relatively low for e-commerce MSMEs using standard platform integrations, which gives merchants genuine leverage in rate negotiations. Even a 0.2% reduction
Please submit any questions via the 'suggestions' window. We are committed to enhancing the user experience by remaining fair, transparent, and user-friendly.



! Advertisements !
! Advertisements ! ⁈

These sections are reserved for advertisements. While our in-house advertising system is under development, Third party Ad-sense will be displayed here. For more information, please refer to our “Advertisements” insight.