A marketplace sales audit checklist for statutory auditors should cover five areas: agreement and fee terms, sales-to-settlement reconciliation, commission and fee validation, returns and cut-off testing, and tax statement matching (GST TCS and income-tax TDS). Obtain marketplace reports directly, tie them to the ledger and bank, and document every unreconciled balance with an explanation and age.
Start with the commercial terms and the accounting model
Before testing numbers, understand how the brand sells. Is it a seller of its own inventory on the marketplace, or are goods supplied under a different arrangement? The model decides who raises the invoice, when control passes and what the brand records as revenue, so confirm it against the contract.
- Seller agreement and rate card: obtain the signed version and every later amendment. Commission, fixed fees, shipping fees, return fees and payment terms all come from here.
- Revenue policy: check that the brand recognises revenue consistently with the applicable accounting standard, and that the policy covers returns and discounts.
- Fee changes during the year: marketplaces revise terms. Do not assume a rate. Confirm the latest terms from the agreement and the marketplace's published notices.
Collect the right evidence set
Ask management for marketplace-generated reports, not spreadsheets rebuilt by the finance team. Reports downloaded directly from the seller panel carry more audit weight.
- Order-level sales report for the full year, including cancelled and returned orders.
- Settlement or payment reports with the deduction breakup per order or per cycle.
- Returns, RTO and claim reports, including any compensation for lost or damaged goods.
- Marketplace invoices for commission, fees and advertising, with GST details.
- Bank statements for the receiving account.
- Tax statements: GST TCS credit details and income-tax TDS entries as they appear on the portals.
Reconcile sales to settlements to bank
The core test is a three-way tie-out: ledger sales, marketplace sales and settlements, and bank credits. Differences are normal because of timing, but each one should be explained.
- Match gross sales per ledger to the marketplace order report. Investigate orders booked but absent in the report, and the reverse.
- Match settlements per marketplace reports to bank credits. Note any credits that cannot be linked to a settlement cycle.
- Prepare a bridge: sales, less returns, less commission and fees, less tax deductions, equals expected receipt, compared with actual receipt.
- Age the marketplace receivable. Old balances often hide disputed deductions, unclaimed returns or write-offs not yet booked.
Validate commissions, fees and deductions
Expense testing is where leakage shows up. Select a sample of orders across categories and months, then recompute charges using the agreed terms.
- Recompute commission and fees on the sample using the rate card from the agreement. Do not use rates from memory or from another brand.
- Check that fee GST is booked correctly and that input credit claimed matches the marketplace invoices.
- Look for deductions with no contractual basis, such as unexplained penalties, duplicate charges or fees on cancelled orders.
- Confirm whether advertising and promotion charges are netted in settlements or billed separately, and that both are expensed in the right period.
Test returns, cancellations and year-end cut-off
Returns are the most common source of overstated revenue in ecommerce audits. Check them in both directions.
- Post year-end returns: review returns and credit notes in April and the weeks after for sales booked before 31 March. Decide whether a provision is needed under the brand's policy.
- Provision method: ask how the returns provision was derived, and test it against actual return data from the marketplace report.
- Cut-off: compare dispatch or delivery dates with the revenue booking date for the last and first few days of the year.
- Recoverable claims: check whether lost, damaged or wrongly returned goods have claims raised, and whether any recovery is recognised only when it is virtually certain.
Match tax statements and flag disclosures
Marketplace operators deduct or collect taxes on behalf of sellers. Compare what was deducted in settlements with what appears on the tax portals.
- Compare GST TCS shown in settlement reports with the credit reflected in the brand's electronic cash ledger, and check that it has been used or carried forward properly.
- Compare TDS deducted by the marketplace with Form 26AS or AIS entries, and note differences for follow-up.
- Reconcile reported turnover in GST returns with books. Explain differences arising from returns, timing or cancelled orders.
- Applicable rates and thresholds change. Confirm current provisions with the tax adviser rather than relying on older audit files.
Tools such as MarketplaceMetrics by Fundle can pre-build the sales, settlement, fee-check and returns trail, which shortens sampling, though the auditor still needs to review source reports.
Worked example
Illustrative example only. A brand's ledger shows sales for one settlement period. The auditor builds this bridge from marketplace reports:
| Line | Amount (₹, illustrative) |
|---|---|
| Gross sales per order report | 10,00,000 |
| Less: returns credited | 1,50,000 |
| Less: commission and fees per settlement report | 1,20,000 |
| Less: TCS per statement | 8,000 |
| Less: TDS per statement | 6,000 |
| Expected receipt | 7,16,000 |
| Actual bank credit | 7,02,000 |
| Unexplained difference | 14,000 |
The auditor would trace the ₹14,000 to items such as penalties, ad charges, unmatched return deductions or timing, and ask management to document each one. Unresolved items stay in the receivable ageing and are considered for provisioning.
Questions and answers
What is the first thing a statutory auditor should check in a marketplace seller audit?
Start with the signed seller agreement, amendments and rate card, plus the revenue recognition policy. These define fees, payment terms and the accounting model. Every later test, from commission recomputation to cut-off, depends on knowing the agreed terms.
Which marketplace reports should auditors ask for?
Ask for order-level sales, settlement or payment reports with deduction breakups, returns and claims reports, fee invoices, and tax statements. Insist on reports downloaded from the seller panel rather than management-prepared summaries, since system-generated reports offer stronger audit evidence.
How should returns after year-end be treated?
Review returns and credit notes received after 31 March for sales booked before it. Compare them against the brand's provisioning method and actual return data. Where the policy requires it, adjust revenue or raise a provision, and document the basis.
Can I rely on the marketplace's commission rates from memory or older files?
No. Fee structures change by category, period and agreement. Take rates from the signed agreement, rate card or latest marketplace notice, and confirm the terms in force for the audit period before recomputing any charge.
