Common Reconciliation Errors That Cost Sellers Lakhs Every Year

Payment reconciliation is the backbone of a profitable e-commerce business. Yet most Indian sellers treat it as an afterthought — something to be dealt with at the end of the month or, worse, at tax filing time. The result? Undetected discrepancies that silently drain lakhs of rupees from your business every year. From missed commission overcharges to unrecovered return refunds, these errors compound over time and can mean the difference between a thriving business and one that barely breaks even.

Error 1: Not Matching Marketplace Settlements with Actual Orders

The most fundamental reconciliation error is failing to match each line item in your marketplace settlement report against your actual order data. Amazon and Flipkart process thousands of transactions per settlement cycle, and discrepancies are more common than sellers realise. Commission rates may be applied incorrectly, weight-based shipping charges may use wrong dimensions, or promotional discounts may not be reflected accurately.

Sellers who rely on simply checking the total settlement amount against their bank deposit are missing the granular errors hidden within. A seller doing Rs 50 lakh monthly revenue with even a 1% reconciliation gap is losing Rs 50,000 every month — that is Rs 6 lakh per year from this single oversight.

Error 2: Ignoring Return and Refund Discrepancies

Returns are a significant pain point for Indian e-commerce sellers, with return rates ranging from 15-30% depending on the category. The reconciliation challenge lies in tracking whether refunds issued to customers are correctly deducted from your settlements, and more importantly, whether you receive the inventory back in sellable condition.

Common issues include refunds processed for orders where the return was never received, double deductions for a single return, and failure to claim reimbursement for items returned in damaged condition. Without systematic tracking, these errors go unnoticed. Sellers handling 500+ returns per month can lose Rs 1-2 lakh annually just from return-related reconciliation gaps.

Error 3: Overlooking GST and TCS Mismatches

TCS (Tax Collected at Source) deductions by marketplaces should match your GST filings perfectly. However, discrepancies arise when marketplaces categorise products under wrong HSN codes, apply incorrect GST rates, or when there are timing differences between order dates and settlement dates that span different filing periods.

Failing to reconcile TCS credits can lead to cash flow losses and compliance issues. If the TCS reflected in your Form 26AS does not match what the marketplace actually deducted, you may either lose legitimate tax credits or face scrutiny during assessments. This is especially problematic for sellers on multiple marketplaces where each platform has its own settlement cycle and TCS reporting format.

Error 4: Manual Spreadsheet Reconciliation

Many sellers still attempt reconciliation using Excel spreadsheets, manually downloading reports from each marketplace and trying to match transactions. This approach is not just time-consuming — it is inherently error-prone. A single missed row, an incorrectly applied VLOOKUP formula, or a formatting inconsistency in dates or order IDs can cascade into significant errors.

As your business grows beyond 100 orders per day, manual reconciliation becomes practically impossible to do accurately. The human error rate in manual data entry is approximately 1-3%, which might sound small but translates to real money at scale. Automated reconciliation tools can process thousands of transactions in minutes with near-perfect accuracy, flagging exceptions for human review rather than requiring line-by-line verification.

Error 5: Not Reconciling Shipping and Weight Charges

For FBM sellers, shipping charges are a major cost component. Marketplaces calculate shipping fees based on volumetric or actual weight, whichever is higher. Errors in weight measurement at the fulfilment centre can result in overcharges that go undetected if you are not actively reconciling shipping invoices against actual product weights.

Similarly, FBA sellers should verify that storage fees, fulfilment fees, and long-term storage surcharges are calculated correctly. Amazon occasionally updates its fee structure, and the transition period can result in incorrect charges. Maintain a master list of your product dimensions and weights, and cross-reference them against marketplace charges at least monthly.