A Guide to E-Commerce Payment Reconciliation
Master payment reconciliation across Flipkart, Amazon, Meesho, and other marketplaces. Track every rupee, verify settlements, and optimize margins.
Why This Matters for Your Business
In the fast-moving world of online sales, it's easy to focus on growing the order book while overlooking a fundamental question: Where is our money?
Every entrepreneur is also an investor in the business. Looking through an investor's lens reveals two critical gaps most sellers face:
- Visibility gap: Most sellers can't answer "where is our money?" with precise numbers. Returns, cancellations, GST, and marketplace deductions create confusion.
- Margin gap: Without reconciliation, you don't know your true net margin — only what you hoped you'd earn.
What Recarya does: It verifies that every order placed, fulfilled, and recorded has been converted into actual cash in the bank, with every deduction understood and accounted for.
1. What We Earn? – Where is Our Money?
Goal: Locate every rupee the business has rightfully earned and verify it's received in full and on time. Unexplained gaps between sales and bank credits are investor red flags.
To answer this, you must:
- Match marketplace reports: Compare order reports with bank settlements to identify discrepancies.
- Track payment status: Identify orders delivered but not yet paid or awaiting settlement.
- Account for adjustments: Verify refunds, returns, and cancellations are correctly reflected in settlements.
- Find delays: Detect missing or delayed settlements that require follow-up.
2. How We Earn? – The Money Journey
Goal: Understand how money flows from sale to bank account, and why received amounts differ from sale values. This reveals margin leakages you can control.
Once you know where the money is, you must understand how it got there. The money rarely reaches you untouched. Multiple deductions, taxes, and fees reduce it along the way.
Key factors to review:
- Commissions & fees: Marketplace commissions, payment gateway charges, and how they're calculated.
- Tax deductions: TCS/TDS deductions and GST implications on gross sales.
- Other charges: Penalties, chargebacks, storage fees, and logistics deductions.
- Settlement timing: How often settlements occur and how delays impact cash flow.
3. Why It Matters – The Real Impact
Goal: Build investor confidence by proving that reported sales translate to actual cash with zero hidden leakages.
Payment reconciliation is not just bookkeeping—it's a foundation of business credibility. Here's why it matters:
- Financial accuracy: Ensures reported sales are backed by actual bank deposits, not wishful thinking.
- Leak prevention: Reduces hidden losses from duplicate charges, miscalculations, or missed settlements.
- Investor confidence: Clean, reconciled financials signal operational maturity and discipline.
- Better decisions: Accurate margin data enables pricing optimization and realistic forecasts.
Getting Started with Recarya
Payment reconciliation doesn't require complex tools—it requires a clear process:
- Collect data: Export settlement reports from all your marketplaces (Flipkart, Meesho, Amazon, etc.).
- Track timing: Note settlement dates, not order dates. Understand your settlement cycle.
- Decode deductions: List all charges, commissions, and taxes applied by each platform.
- Verify amounts: Match marketplace reports against your bank account. Track any gaps.
- Close loops: Investigate any unmatched amounts and resolve them.
Pro tip: Reconciliation is most effective when done monthly. Don't wait until year-end when hundreds of discrepancies pile up and become hard to trace.
Conclusion
By answering "Where is our money?" and "How do we earn it?" with clarity and precision, you protect margins and strengthen your business position. You move from hoping to knowing—and that shift is powerful.
Recarya helps you see your business through an investor's lens: clear, data-driven, and confident.
Author: CA Maheshwari
Date: 14th August, 2025
