A month-end close for a multi-marketplace brand means fixing one cut-off date, pulling sales, returns and settlement reports from every marketplace, reconciling them to your ledger and bank, checking fees against agreed terms, listing open returns and claims, reviewing tax data, and signing off with a documented list of unresolved items carried into next month.
1. Fix the cut-off and collect every report
Most close delays come from missing files, not difficult accounting. Decide once whether you cut off on order date, delivery date or settlement date, write it down, and apply it to every marketplace. Mixing bases across channels is a common source of mismatches.
Collect these for each marketplace:
- Sales or order report for the month
- Returns and cancellations report
- Settlement or payout statements with bank credit dates
- Commission, fee and charge breakup
- Tax collected-at-source statements, where applicable
- Ad, storage and logistics invoices
- Your current seller agreement and rate card
2. Reconcile sales and returns by marketplace
Build one summary per marketplace: gross sales, cancellations, returns, net sales. Tie the gross sales figure to what you have booked in your books or ERP. Differences usually come from orders crossing the month boundary, returns booked in a later month, or cancelled orders still showing as sales.
- Total orders and value by status (delivered, returned, cancelled, in transit).
- Compare with your ledger revenue for the channel.
- List order-level differences and tag each as timing, error or unknown.
- Post corrections or accruals for timing items.
3. Match settlements to bank credits
Settlement statements show what the marketplace says it paid. Your bank statement shows what arrived. Match each payout to a bank credit by reference number and amount, then check that the statement ties back to the orders it covers.
- Payouts in the statement but not in the bank: raise with the marketplace.
- Bank credits with no statement: request the missing report.
- Orders delivered but not yet settled: carry as receivable, with expected settlement timing.
The receivable from each marketplace at month-end should be explainable line by line, not just as a balancing figure.
4. Check commissions and fees against agreed terms
Do not assume deductions are correct because they appear in a settlement report. Compare charges with your seller agreement, rate card and any written commercial changes. Fee structures differ by marketplace, category and period, so confirm the latest terms with your account manager or in the seller portal rather than relying on memory.
Sample or fully test:
- Commission by category and price band
- Fixed, shipping, collection or fulfilment fees
- Penalties, chargebacks and adjustments
- Promotional or ad deductions you did not approve
Record each overcharge with order reference, amount and the clause it breaches. This becomes your claim file.
5. Track returns, claims and recoveries
Returns are where cash silently leaks: items returned damaged, wrong items received, returns not credited, or lost-in-transit claims past their window. Claim windows are set by each marketplace, so check the current policy and diarise deadlines.
- List returns initiated but not received or not credited.
- List claims raised, with date, amount and status.
- Flag claims nearing a deadline.
- Decide whether to accrue expected recoveries or hold them off the books until confirmed, as per your accounting policy.
A tool such as MarketplaceMetrics by Fundle can keep these cases in one place, with fee checks against agreed terms, instead of scattered spreadsheets.
6. Review tax data, post journals and sign off
Marketplace reports carry tax-related deductions and collections. Agree these with your GST returns and the statements available on the GST portal, and confirm the treatment of TCS, TDS and any other deductions with your tax adviser. Do not rely on a rate quoted in a blog; use your agreement, the statement and current law.
- Post journals for fees, returns, accruals and adjustments.
- Reconcile marketplace receivable and clearing accounts to zero or to a listed balance.
- Prepare an open-items list with owner and due date.
- Get reviewer sign-off and store the reports used.
Worked example
Illustrative example only. The figures below are made up to show the method, not real fees or rates.
| Line (Marketplace A, one month) | ₹ (illustrative) |
|---|---|
| Net sales after returns | 8,50,000 |
| Less: fees and charges per settlement report | 1,40,000 |
| Less: tax-related deductions per report | 15,000 |
| Less: other adjustments | 10,000 |
| Expected payout | 6,85,000 |
| Actual bank credit | 6,60,000 |
| Unexplained difference | 25,000 |
On review, ₹18,000 is a fee charged above the agreed rate card, so it goes into a claim. The remaining ₹7,000 is an order settled after month-end, so it is carried as a timing receivable. The gap is now fully explained and each item has an action.
Questions and answers
How many days should a marketplace month-end close take?
There is no standard number. It depends on how many marketplaces you sell on, report availability and order volume. Set a target working-day schedule, track where time is lost, usually missing reports and unexplained settlement gaps, and tighten it each month.
Should I close on order date or settlement date?
Choose the basis that matches your accounting policy and apply it consistently across marketplaces. Many brands recognise revenue on delivery and track settlement as a receivable. Confirm the approach with your accountant or auditor so your books stay consistent.
How do I find fees charged against agreed terms?
Take the seller agreement and current rate card, then compare them with fee lines in each settlement report, by category, period and order. Confirm the latest terms with the marketplace. Record every mismatch with order reference, amount and clause for a claim.
Can I close the books if claims are still open?
Yes. Close with an open-items list showing each claim, amount, status and deadline. Whether to accrue expected recoveries depends on your accounting policy and certainty of recovery, so agree the treatment with your finance head or auditor.
