Contact us

Thousands of Marketplace Orders. Nothing Matched. Until Now.

How Wisecor Helped a Multi-Marketplace Ecommerce Brand Match Every Order to Every Rupee

For an online seller, every order should end as a clear entry in the books: a sale, a payout, a fee, a refund or a tax credit. For this multi-marketplace brand, that link had broken. Orders, settlement reports, commissions, returns and TCS sat in separate files, so payouts rarely matched sales and money leaked unnoticed. Wisecor stepped in to build an order-level reconciliation process, match every settlement to the books, raise claims for short payments and give the finance team a clean, reliable monthly close.

Order-level reconciliation model: every order ID matched with its payout, fees, returns and tax deductions

Returns and refund tracker: every return, cancellation and refund followed until it is closed

Clean ledger entries: consistent monthly accounting entries for sales, fees, refunds and TCS

Client

A fast-growing consumer brand selling on multiple online marketplaces and its own website, handling thousands of orders every month.

Scope of work

Order-to-settlement reconciliation for every marketplace Matching payouts to bank receipts Review of commissions, shipping, fulfilment and other marketplace fees Tracking of returns, cancellations and refunds TCS and GST reconciliation with marketplace data Identification and filing of claims for short or missed payments Accounting entries and ledger clean-up Monthly reconciliation reports for management

Geographical Area

India. Sales across pan-India marketplaces, with settlements received in multiple bank accounts

Industry Area

Ecommerce / D2C retail. A high-volume, multi-channel business where margins depend on every fee and refund being right.

Client Challenges

  • Thousands of orders a month with no order-level matching
  • Marketplace payouts that did not match sales in the books
  • Commissions and fees deducted without clear verification
  • Returns and refunds that were never fully tracked
  • TCS credits not matched with GST returns
  • Short payments and missed claims going unnoticed
  • Data scattered across portals, spreadsheets and bank statements
  • Month-end close delayed by manual reconciliation

Wisecor Solution: A More Structured Approach to Marketplace Reconciliation

What we reviewed. We started by mapping the full order journey on each marketplace, from order and dispatch to return, settlement and bank credit. We compared sales registers, settlement reports, fee invoices, TCS statements and bank receipts to find where the gaps were coming from.

What we changed. We set up an order-level reconciliation model that matches every order ID with its payout, fees, returns and tax deductions. Exceptions such as excess fees, unpaid orders and lost returns were flagged and raised as claims with the marketplace. TCS was reconciled with GST data, and the books were updated with clean, consistent entries every month.

The result. The finance team now has one clear view of what was sold, what was received and what is still pending. Leakages are caught early, claims are followed up on time and month-end closing no longer waits on manual matching.

Outcome

  • Order-level matching across all marketplaces
  • Payouts reconciled with sales and bank receipts every month
  • Marketplace fees verified against agreed rates
  • Returns, cancellations and refunds fully tracked
  • TCS credits matched with GST records
  • Short payments identified and raised as claims
  • Faster, cleaner month-end close

Impact

  • Revenue leakages identified and recovered through claims
  • Clear visibility of true margins per channel
  • Better cash flow planning with accurate receivables from marketplaces
  • Reliable data for GST filings and audits
  • Less manual work for the in-house finance team
  • Stronger control over marketplace partnerships
  • Confident decisions on pricing and channel growth

 

Key Takeaway

When every order matches, every rupee is accounted for.

Selling on multiple marketplaces brings scale, but it also brings complex settlements, hidden fees and easy-to-miss leakages. A structured reconciliation process turns scattered data into clear numbers. Wisecor’s ecommerce reconciliation service helps online businesses match orders, payouts, fees and taxes, recover what is owed and close their books with confidence.