How to Match Marketplace Lump-Sum Settlements

Why one bank credit covers many orders

Marketplaces do not pay order by order. They pool everything eligible in a payout cycle, subtract what you owe them, and transfer a single net amount. Your bank statement therefore shows one line, while your sales records show many.

That single line is the net of several things:

• Sale value of delivered orders that became payable in the cycle
• Commission, fixed fees, shipping and other charges
• Deductions for returns, cancellations and reverse logistics
• Tax amounts collected or withheld at source
• Penalties, ad charges or manual adjustments carried over

You cannot match the credit to any one invoice. You match it to a settlement batch, and then match the batch to orders.

What you need before you start

Gather these for the same payout cycle, otherwise you will chase differences that are only timing.

• Bank statement line with date, amount and UTR or narration
• Settlement report downloaded from the seller panel, at order level
• Order or sales report for the same period
• Returns report, including returns that arrive after the original sale
• Your seller agreement and current rate card, to check what should have been charged

Keep the original files unedited. Do your work on a copy so you can always trace a figure back to its source.

Step-by-step: matching the credit to orders

1. Find the batch. Use the UTR, payout ID or settlement date in the report to identify which batch the bank credit belongs to. If the report shows several batches, match each one separately.
2. Check the batch total. Confirm the net payable in the report equals the bank credit. If not, note the difference before going deeper.
3. List every line. Make one row per order and per adjustment, with columns for sale value, each fee, return deduction, tax deduction and net.
4. Add line nets. The sum of line nets plus unallocated adjustments should equal the batch total.
5. Link lines to your orders. Match by order ID or item ID against your sales report. Flag lines that have no matching order and orders that never appear in any batch.
6. Record the result. Mark each order as settled, partly settled, returned or pending, and store the UTR against it.

Why the totals often do not tie

When the bank credit and report disagree, the cause is usually one of these:

• Cycle cut-off. Orders sit in different batches than you expected because eligibility depends on delivery or return-window dates.
• Late returns. A return deduction lands in a later batch than the original sale.
• Bundled deductions. Ad spend, penalties or compensation are netted into the same payout.
• Tax lines. Amounts withheld at source reduce the credit but belong in your tax records, not in revenue.
• Fee mismatches. A charge differs from the agreed rate card or was applied to the wrong order.
• Split or held payments. Part of a batch is paid separately or held pending a dispute.

Work from the biggest difference down, and resolve timing items before raising any claim.

Handling returns, fees and tax deductions

Treat each category separately so your books show gross sales, charges and cash received clearly.

• Returns: link each deduction to the original order and its sale date, even if it falls in a later month.
• Fees and commission: compare each charge with your agreement and current rate card. Do not assume rates from memory, because they change and vary by category.
• TCS, TDS and GST on fees: take the treatment and rates from your settlement report, the marketplace's tax documents and your tax adviser. Confirm the latest rules before booking entries.

Anything that does not match agreed terms goes into an exceptions list with the order ID, expected amount, charged amount and evidence.

Turning it into a monthly routine

Matching by hand works for a few batches. Once you have several payouts a month, build a fixed routine: download reports on the same day each cycle, match credits first, then clear exceptions, then raise claims within the marketplace's dispute window, which you should check in your agreement.

Tools can take over the repetitive part. MarketplaceMetrics by Fundle reconciles marketplace sales and settlements, checks commissions and fees against agreed terms, and tracks returns and recovery cases. Myntra Excel reports are reviewed today, and other marketplaces are in scope discussion, so confirm coverage for your channels first.