eCommerce Payment Reconciliation: PKC’s Guide for Businesses

With multiple marketplaces, payment gateways, refunds, and compliance needs, eCommerce payment reconciliation can get very tricky. 

Here’s your essential guide to what reconciliation means, why it is a must for Indian sellers, and the best practices to avoid revenue leakage while staying compliant.

What is eCommerce Payment Reconciliation & Why It’s Important in India?

eCommerce payment reconciliation is the systematic process of verifying that the payments received from online sales channels accurately match a business’s internal records, after accounting for fees, taxes, refunds, and other adjustments. 

It ensures that every rupee the ecommerce business earns through digital transactions is correctly settled into their bank account.

Example: 

A customer places an order for ₹2,500 shoes on an eCommerce website. 

They pay via UPI through Razorpay. Razorpay deducts a ₹50 transaction fee and ₹9 GST, transferring ₹2,441 to our account after a T+2 settlement delay. 

The accounting team then reconciles the payment to ensure the deductions are accurate and match the expected amount. Once verified, the order is confirmed and fulfillment proceeds.

Key Activities in the Reconciliation Process:

• Centralizing data from various sources (marketplaces, gateways, banks).
• Matching transactions across sales, gateway reports, and bank statements.
• Accounting for variables like GST on transaction fees, returns, discounts, and delivery charges.
• Resolving discrepancies such as failed transactions, underpayments, or unprocessed refunds.
• Automating the workflow with reconciliation software to improve accuracy and efficiency.

Why eCommerce Payment Reconciliation is Important in India

For online businesses, especially those operating across multiple platforms and channels, payment reconciliation is important for the following reasons: 

Ensures Financial Accuracy and Prevents Revenue Leakage

Small transaction-level discrepancies, if unnoticed, can accumulate into significant revenue losses. Regular reconciliation helps:

• Detect missing or delayed payments
• Identify incorrect fee deductions or GST miscalculations
• Recover uncredited or short-settled funds

Simplifies GST Compliance and Tax Filings

Under tax laws, payment gateways levy GST on their service charges. Reconciliation ensures:

• Proper accounting of Input Tax Credit (ITC) on gateway fees
• Alignment between sales records and GSTR-1 returns
• Easier cross-verification with GSTR-2A/2B data

Improves Cash Flow Visibility and Planning

With accurate reconciliation, businesses can:

• Monitor settlement timelines (T+1/T+2 cycles)
• Forecast cash inflows more reliably
• Manage inventory and vendor payments confidently

Reduces Chargebacks, Disputes, and Customer Complaints

By reconciling regularly, businesses can:

• Ensure timely processing of refunds
• Quickly identify and resolve payment issues
• Maintain transparent communication with customers

Supports Multi-Channel Growth

Operating across Amazon, Flipkart, Myntra, and a D2C website often means dealing with different payment cycles, commission structures, and settlement processes. Reconciliation allows for:

• Unified financial reporting
• Marketplace-wise revenue tracking
• Scalable financial operations

Builds Trust with Investors, Auditors, and Partners

Accurate and transparent reconciliation strengthens your financial credibility, which is crucial for:

• Fundraising and investor due diligence
• Audit readiness and regulatory compliance
• Stronger vendor and payment partner relationships

Types of Payment Data to Reconcile in Ecommerce 

Let’s now take a look at the essential types of payment data to reconcile for eCommerce businesses:

Sales and Order Data (What You Sold)

This is your business’s internal record of all transactions, serving as the foundation for reconciliation.

It matches what you expected to earn with what was actually processed and settled.

Covers:

• Order ID / Transaction Reference
• Transaction date and time
• Customer details (email or masked ID)
• Product SKUs and quantities
• Gross order value (before any deductions)
• Payment method (e.g., UPI, card, net banking, wallet, COD)
• Order status (paid, shipped, cancelled, refunded)

Payment Gateway Data (What Was Processed)

Payment gateways like Razorpay, Paytm PG, Cashfree, Stripe, etc.,  handle customer payments and deduct processing fees before settlement.

The purpose of reconciliation is to identify discrepancies like fee overcharges, failed transactions, or delayed settlements.

Covers:

• Gateway Transaction ID
• Order ID (for internal mapping)
• Amount processed (gross and net)
• Merchant Discount Rate (MDR)
• GST on fees
• Net amount settled
• Transaction status (success, failed, refunded, disputed)
• Settlement date and batch ID

Bank Statement Data (What You Received)

This is the final and most authoritative source, what actually arrived in your bank account. It confirms that real-world cash inflows match with processed transactions and payouts.

Covers:

• Credit date
• Amount received
• UTR/Reference number
• Sender details (gateway/marketplace name)
• Any reversal or failed credit entries

Marketplace Settlement Reports (If You Sell on Platforms like Amazon, Flipkart, Myntra)

Marketplaces operate their own fee and settlement models, usually on a T+X cycle (e.g., T+7 days).

These ensure marketplaces are crediting the correct net revenue and accounting for all deductions transparently.

Covers:

• Total sales per period
• Marketplace fees and commissions
• Shipping/delivery charges
• Refunds and returns
• Promotional discounts (marketplace vs. seller-funded)
• TDS and TCS deductions under Indian tax laws
• Final settlement amount

Refunds and Return Data

Returns are common in eCommerce, especially in high-return categories like fashion and electronics. 

Reconciliation helps prevent revenue leakage and ensures customer refunds are processed and tracked correctly across all systems.

Covers:

• Refund ID
• Refund initiation and completion dates
• Mode of refund (bank, wallet, UPI reversal)
• Amount refunded
• Gateway or bank debit entry
• Associated order ID

Chargebacks and Disputes

Chargebacks occur when a customer disputes a transaction with their bank or card issuer.

 Helps resolve disputes, prevent fraudulent chargebacks, and recover losses where possible.

Covers:

• Chargeback ID
• Order ID / Transaction reference
• Amount reversed
• Reason for dispute
• Associated fees or penalties
• Date of debit from your account

Tax and GST Data

Indirect tax compliance is tightly integrated with payments, especially due to GST and TDS/TCS rules.

It  ensures compliance with Indian GST laws and minimizes audit risks or penalties.

Covers:

• GST collected on sales
• GST on gateway/service provider fees
• TDS and TCS entries on marketplace settlements
• Input Tax Credit (ITC) eligibility and claim
• GSTIN of marketplace/gateway provider
• Invoice matching with GSTR-1, GSTR-2A/2B

Discounts, Promotions, and Adjustments

Discounts can be marketplace-funded, seller-funded, or split—each impacting net revenue differently.

Ensures marketing and promotional spend is accurately tracked and does not distort financial reporting.

Covers:

• Coupon codes applied
• Seller vs. marketplace-funded promotions
• Cashback offers
• Wallet credits
• Post-order adjustments

COD (Cash on Delivery) Payments

COD transactions involve delayed cash inflow via courier or logistics partners, making reconciliation essential.

 Tracks actual cash collected and credited, ensuring no gaps in COD revenue.

Covers:

• COD order ID
• Amount collected by courier
• Courier settlement report
• Bank credit confirmation
• Reconciliation with undelivered or RTO (Return to Origin) orders

Miscellaneous Adjustments and Operational Fees

Occasionally, platforms or gateways charge operational or administrative fees.

 Ensures accurate profit calculations and recognition of all expense lines.

Examples:

• Penalties (for order cancellations, SLA breaches)
• Dispute resolution fees
• Platform subscription or SaaS fees
• Shipping partner reconciliations

Step-by-Step Process of Payment Reconciliation in eCommerce

For ecommerce businesses, here’s a quick look at how payment reconciliation is to be done:

Gather All Transaction Data

Start by collecting data from all sources involved in a sale:

• Sales Channels: Order data from platforms like Shopify, Meesho, WooCommerce, Amazon, Flipkart, etc.
• Payment Gateways: Reports from Razorpay, Paytm PG, PayU, Stripe, etc.
• Marketplace Settlement Reports: If you sell via Amazon, Flipkart, etc.
• Bank Statements: Business bank account records for actual credits and debits.
• Refund Logs: Records of returns and chargebacks.
• Tax Reports: GST collected, TCS/TDS deducted, etc.

Stick to a defined reconciliation period, daily, weekly, or monthly, depending on your order volume.

Match Orders with Payment Gateway Transactions

Compare each order ID with gateway data to confirm:

• Payment was successfully processed
• Gateway fees and GST on MDR were correctly applied
• The net payable amount aligns with your expected value

Flag:

• Orders marked “Paid” but not appearing in the gateway report
• Mismatched transaction amounts
• Transactions showing “Failed” or “Refunded” that were marked as successful in your OMS

Reconcile Gateway Settlements with Bank Credits

Now verify that the settled amount from gateways (post deductions) has been actually credited to your bank.

Match using:

• Settlement ID (from payment gateway)
• UTR number (from bank)
• Amount and Date

Flag any delayed settlements, mismatched net credit amount or missing UTR references

Match Marketplace Reports with Bank Credits

If you sell on marketplaces, download payout and settlement reports from Amazon, Flipkart, Meesho, etc.

Confirm:

• Gross sales value
• Platform commissions
• TCS/TDS
• Refunds and returns
• Final net payout

Match these settlements to bank credits using payout reference or UTR number

Look out for hidden deductions (e.g., promo costs, shipping penalties) and payouts held due to return window or SLA violations

Reconcile Refunds and Chargebacks

Ensure that all customer-initiated refunds or chargebacks are tracked across systems. Match:

• Refund ID from eCommerce platform
• Gateway refund transaction
• Bank debit entry

Also review reason for refund and mode of refund (gateway reversal, UPI, wallet, COD refund)

Watch for:

• Refund issued but no debit from bank
• Duplicate refunds
• Chargebacks without corresponding order details

Tax (GST, TDS, TCS) Reconciliation

Ensure accurate tax compliance by reconciling:

• GST collected on customer invoices
• TCS (under Sec 52) and TDS (Sec 194-O) deducted by marketplaces
• GST on gateway fees (claimable as ITC)
• Filing reports (GSTR-1, GSTR-3B) vs actual transaction data

Watch for:

• GST mismatch between books and portal
• Missed input credits
• Unaccounted tax deductions

Identify & Investigate Discrepancies

Create a discrepancy log for:

• Missing payments
• Overcharged fees
• Short settlements
• Incorrect tax deductions
• Double entries or unmatched transactions

Investigate by contacting payment gateway support, marketplace seller support or your business bank RM (Relationship Manager)

Make Adjustments in Your Accounting System

Based on the reconciliation findings:

• Adjust journal entries for fee deductions
• Record refunds/chargebacks correctly
• Create provision entries for delayed credits
• Reconcile tax accounts for accurate filing

Use accounting software like Zoho Books, Tally Prime, or ERPs with payment integrations.

Finalize and Tag Reconciled Entries

Once reconciliation is done:

• Mark orders as “Reconciled”
• Close open entries for the period
• Create a reconciliation summary report

Best Practices We Follow At PKC for eCommerce Payment Reconciliation

At PKC Management Consulting, we understand how critical payment reconciliation is for financial control. 

Here’s  the framework we follow  for a strong compliance foundation.

Daily and Periodic Reconciliation

We don’t wait for the month-end. Our team performs daily and weekly reconciliations across all transaction types – orders, refunds, settlements, and fees.

This helps in early detection of discrepancies, smooth cash flow tracking and prevents backlog of unresolved issues

Multi-Channel Data Integration

Most online sellers operate across multiple channels – Amazon, Flipkart, Meesho, Myntra, and more. We consolidate all  in one place for accurate matching and full visibility including:

• Sales orders
• Payment gateway reports
• Settlement summaries
• Bank credits
• Tax data

Tech Use With Human Oversight

We use advanced reconciliation tools, integrated ERPs (like Tally, Xero, Zoho Books), and APIs for:

• Fetching payment data from gateways like Razorpay, Paytm, and Cashfree
• Importing daily bank statements
• Matching sales to settlements automatically

Transparent Fee and Refund Reconciliation

Every rupee matters. We meticulously track:

• Platform commissions and GST on fees
• Gateway MDR and processing charges
• Customer refunds and how they’re routed
• Chargebacks and dispute resolutions

We ensure all deductions are correctly booked, and no revenue is lost.

GST and Regulatory Compliance Alignment

Ecommerce reconciliation is incomplete without tax accuracy. Our approach ensures audit-readiness and stress-free compliance. We handle:

• GST matching: Collected vs. payable
• ITC on payment fees
• Recording TCS/TDS deducted by marketplaces
• Monthly reconciliation for GSTR-1, 3B, and annual returns

Exception Management Framework

Discrepancies are inevitable, especially at scale. We’ve built a structured discrepancy resolution workflow and ensure timely recovery of missing or delayed funds. This includes:

• Real-time exception flagging
• Escalation to relevant stakeholders (banks, gateways, marketplaces)
• SLA-driven follow-ups for issue closure
• Full documentation of all resolutions

Actionable Insight Reports

We provide clients with custom reports showing:

• Payment method efficiency (UPI, Cards, COD, Wallets)
• Refund and chargeback trends
• Cost of payment processing
• Settlement timelines by channel
• Channel-wise net profitability

This data helps leaders optimize operations and improve margins.

Continuous Process Improvement

The  payments and compliance landscape can get complex with UPI changes, RBI mandates, and GST updates.

At PKC, we continuously:

• Benchmark practices against top eCommerce companies
• Update rules based on new gateway features and tax rules
• Reconfigure automation logic for new marketplace policies

We ensure your reconciliation process evolves with your business and the ecosystem.

FAQs on eCommerce Payment Reconciliation