How to Record Marketplace Receivables and Unsettled Payouts

What a marketplace receivable actually is

A marketplace receivable is the amount the marketplace owes you for sales you have already recognised but not yet received in your bank account. It is not the same as gross sales. By the time money arrives, the marketplace will have deducted commission, fees, returns and tax collected or deducted at source.

So the receivable is really a running balance: sales recognised, less returns, less deductions, less cash received. If you book only the bank credit as revenue, your sales are understated and your unsettled payouts are invisible. If you book gross sales and never adjust for deductions, your receivable is overstated.

Revenue recognition timing (on dispatch, on delivery, or after the return window) is an accounting policy decision. Agree it with your chartered accountant and apply it consistently across marketplaces.

Set up the right ledger structure

Before posting anything, create accounts that let you see each component separately.

• Marketplace receivable (one per marketplace): the control account that holds the unsettled balance.
• Sales and sales returns: kept separate so return rates stay visible.
• Output GST: as per your invoices and credit notes.
• Commission and fee expense accounts: split commission, fixed or closing fees, shipping or logistics fees, and ad or promotion charges if they appear in settlements.
• TCS and TDS receivable accounts: for tax collected or deducted by the marketplace, which you claim later.
• Marketplace disputes or recoverable account: for claims you are pursuing, such as lost shipments or wrong deductions.

Confirm the treatment of GST on fees and the TCS and TDS provisions with your tax adviser. Rates and rules change, so check the latest notifications and your seller agreement rather than relying on a fixed percentage.

Post the core entries step by step

1. On sale: debit Marketplace Receivable for the invoice value; credit Sales and Output GST.
2. On return or cancellation after invoicing: debit Sales Returns and Output GST; credit Marketplace Receivable. Match this to the credit note you issue.
3. On settlement: debit Bank for the amount received, debit Commission and Fee accounts, debit TCS and TDS receivable for amounts withheld; credit Marketplace Receivable for the total of those debits.
4. On adjustments: post penalties, reversals, reimbursements and recoveries exactly as the settlement report shows them, each to its own account.

Always post from the settlement report line items, not from the bank statement alone. A single bank credit usually bundles dozens of orders, fees and adjustments, and the bank line cannot tell you which is which.

Calculate unsettled payouts at month-end

The unsettled payout for a marketplace is:

Opening receivable + sales recognised − returns and credit notes − fees and deductions − cash received = closing receivable.

Two timing issues cause most confusion:

• Sales in transit: orders invoiced in the month but not yet in any settlement. These belong in the receivable.
• Settlements for earlier orders: payouts received this month for last month's sales reduce the opening balance, not this month's sales.

Where fees or deductions relate to the month but the settlement report arrives after close, accrue them based on available data, and reverse or true up when the final report is available. Ask your accountant how to document the estimate.

Reconcile the balance and chase differences

A receivable balance is only useful if it agrees with the marketplace's view. Each month, tie your closing balance to the settlement reports and the seller panel, then list every difference by type: unrecorded returns, fee mismatches, delayed payouts, and deductions you cannot explain.

Check deductions against your agreed terms, such as the seller agreement and current rate card, instead of assuming they are right. Age the unsettled items, because anything well beyond the marketplace's stated settlement cycle needs a query or a claim. Disputed amounts should move to a recoverable account with a reference and owner.

Doing this in spreadsheets works at low volume but gets slow as orders grow. 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, while other marketplaces are a scope discussion.

Mistakes that distort your books

• Booking net settlement as revenue and losing gross sales, fees and returns visibility.
• Using one clearing account for all marketplaces, so no balance can be tied to a report.
• Ignoring TCS and TDS until return filing, then finding mismatches.
• Writing off short payments without a claim or approval.
• Posting returns only when the refund settles, not when the credit note is issued.