Payment Gateway Reconciliation for Indian E-commerce: Methods, Software, GST & Best Practices

Reconciling payment gateway settlements is one of the most commonly mishandled accounting tasks for Indian e-commerce businesses. From the clearing account method to GST input tax credit on MDR fees, here’s everything you need to know to get it right.

Why Most Indian E-commerce Businesses Get This Wrong

Payment gateway reconciliation sounds straightforward — but it’s one of the most common sources of accounting errors for Indian e-commerce businesses. The core mistake is recording only the net bank credit as sales, rather than the full gross invoice amount. This understates revenue, hides a deductible expense, and makes GST input tax credit unclaimable. Here’s how to do it correctly.

The Right Method: The Clearing Account Approach

The correct and increasingly standard approach among Indian CAs is the clearing account — also called a suspense account — model. Direct settlement-to-invoice matching simply doesn’t work at scale for three reasons: the bank credit is a batch of many transactions, it arrives days after the sale, and it arrives net of fees, GST, refunds, and chargebacks.

The clearing account solves all three problems. Here’s how the flow works:

Step 1 — Raise the invoice at the full gross value.
Step 2 — When the customer pays, record the money into a payment gateway clearing account — a control asset account representing money the gateway owes you.
Step 3 — The gateway deducts its MDR fee plus 18% GST and remits a net amount one to two business days later.
Step 4 — Match the net bank credit against the clearing account and book the fee and GST as a separate expense.

Any residual balance in the clearing account represents money in transit or an error to investigate.

The Gross vs. Net Split — The Central Error

When a ₹10,000 invoice is paid via Razorpay at 2% plus 18% GST, the customer pays ₹10,000 but you receive ₹9,764. Recording only ₹9,764 as sales is one of the most common e-commerce accounting mistakes — it understates your turnover, which creates GST and income tax exposure, inflates your margins by hiding the fee, and means you can’t claim the ITC on the gateway charges.

The correct ledger structure is: debit Bank for the net received, debit Gateway Charges, debit GST Input on the fee, and credit the Payment Gateway Clearing account for the gross amount.

A Concrete Example: The Zoho Books Method

Zoho Books has a native Razorpay clearing account that is automatically created when you connect the integration. Here’s how the fee-split journal works in practice:

When the invoice is raised, debit Debtors ₹10,000 and credit Sales plus Output GST. When the customer pays, the integration moves ₹10,000 into the Razorpay Clearing account. When Razorpay’s monthly consolidated GST invoice arrives, record an expense of ₹236 to Bank Fees and Charges — tax inclusive, covering ₹200 MDR and ₹36 GST — paid through the Razorpay Clearing account. This captures the ITC. Then pass a manual reversing journal to prevent double-counting the fee. Finally, match the ₹9,764 net NEFT credit against the clearing account during bank reconciliation.

How Each Major Software Platform Handles This

Zoho Books

Zoho Books offers the most seamless native experience. Its Razorpay integration automatically creates a dedicated Razorpay Clearing account in the Banking module. All transactions are fetched and displayed there automatically. The fee-split journal is semi-manual — you must record the expense and pass the reversing journal — but the framework is solid and well-documented in Zoho’s official knowledge base.

TallyPrime

TallyPrime Release 3.0 and above includes built-in Razorpay and PayU integration, allowing you to generate payment links and QR codes directly on invoices. The Payment Reconciliation report imports gateway settlement statements and updates payment status against each invoice. The fee is booked as a separate expense ledger, and Tally’s bank reconciliation handles direct bank charges through the F7 shortcut.

Busy

Busy does not have a deep native clearing account feature equivalent to Zoho’s. Users typically record receipts and a separate fee expense voucher manually, or use Busy Recom — Busy’s e-commerce reconciliation add-on — which matches marketplace and gateway settlement statements, fees, returns, and TCS.

QuickBooks India

QuickBooks India is no longer a live option. Intuit ceased all QuickBooks products and services for Indian customers as of 30 April 2023. Former users have primarily migrated to Zoho Books or TallyPrime.

GST and Input Tax Credit on Gateway Fees

GST on payment gateway and MDR fees is charged at 18% and is claimable as Input Tax Credit for GST-registered businesses. It is not a blocked credit under Section 17(5) of the CGST Act — the same logic that applies to bank charges.

To claim ITC correctly, you need a valid tax invoice from the gateway — Razorpay, Stripe, and others issue consolidated monthly GST e-invoices. The fee must be for business use, the supplier must have remitted the GST so it appears in your GSTR-2B, and your returns must be filed.

A few important nuances to be aware of. Standard UPI bank-to-bank payments have zero MDR and therefore no GST or ITC. The platform fee some gateways charge on UPI does carry 18% GST and is ITC-eligible. GST is not charged on domestic card transactions up to ₹2,000. And your GSTIN must be registered with each gateway for the ITC to appear in GSTR-2B.

Additional Considerations for Marketplace Sellers

If you sell on platforms like Amazon, Flipkart, or Meesho, additional reconciliation layers apply. GST TCS under Section 52 was reduced from 1% to 0.5% of net taxable value from July 2024, and income tax TDS under Section 194-O was reduced from 1% to 0.1% from October 2024 under the Finance Act 2024.

An important distinction — TCS is a receivable, not an expense. Treating it as an expense is a common and costly error that reconciliation tools like Busy Recom specifically flag.

How Often Do Businesses Get This Wrong?

The answer, unfortunately, is often. Approximately 60% of e-commerce vendors report difficulties reconciling payments across platforms. Revenue lost to reconciliation errors and operational leakage is estimated at between 1.5% and 5% of GMV. Around 70% of businesses reconcile only at month-end — leaving errors undetected for weeks. And missing ITC on gateway and bank charge GST is consistently cited as one of the most common and costly errors, largely because these charges don’t appear explicitly on bank statements.

Best Practice: A Three-Stage Approach

Stage 1 — Set up the structure. Create a Payment Gateway Clearing account per gateway, always book gross sales rather than the net bank figure, create dedicated expense ledgers for gateway charges and input GST, and register your GSTIN with each gateway.

Stage 2 — Operate the monthly cycle. Download each gateway’s settlement report and import it into your accounting software. Book the consolidated monthly GST invoice as a fee expense and claim ITC. Reconcile the GST against GSTR-2B before filing GSTR-3B. Match each NEFT credit to the clearing account and investigate any residual balance.

Stage 3 — Scale and automate. Above approximately 500 transactions per month or across multiple gateways, move from month-end to weekly or daily reconciliation and consider automation tools such as AI Accountant, Unicommerce, Ginesys, or the gateway’s own reconciliation dashboards.

A Note on Accuracy

The statistics cited in this guide — including the 60% difficulty rate, the 1.5–5% leakage range, and the 70% month-end reconciliation figure — are sourced from reconciliation software vendors and CA firms rather than independent bodies. Treat them as directional indicators rather than definitive benchmarks. Software features and tax rates also evolve — always verify current rates and platform behaviour before filing.