This guide is in English for now. The tool itself works in your language.
Marketplace Payout Check › Help › Using it
How to check a marketplace payout file
The tool reads the file in your browser, matches each order with your invoices and tells you what does not add up. It does not know any marketplace’s layout, so you check the columns it chose.
Step by step
- Open the file. Press “Open payout file” and choose the Excel or CSV file from the seller portal. If it has several sheets, choose the sheet with the orders.
- Check “Which column is which”. Look at the column chosen for order id, date, sale value, refund, commission, shipping, fees, TCS, TDS and net payout. Change any that is wrong. For a file with one row per charge choose “Charge type” and “Amount”.
- Type your details. The marketplace name as on your invoices, and the TCS and TDS rates you want to check against (empty = no check).
- Read the tiles and flags. Orders, sales, returns, fees, tax held back and payout; then the orders with no invoice, invoices not in the file, returns with no credit note and payouts that differ from their parts.
- Type what reached the bank. The credit from your bank statement. The tool shows any shortfall.
- Save, Excel or books. Save the check; download the Excel file; or add the payout to your books in the free Nivesh Sahayak App.
Worked example
An order: sale ₹1,000, commission ₹100, shipping ₹60, other fee ₹10, GST on fees ₹30.60, TCS ₹5, TDS ₹1: payout ₹793.40. If the file shows ₹783.40 for that order, the order is flagged: ₹10 was held back that the file does not name. (Made-up figures.)
Rules and dates
TCS under section 52 of the CGST Act was 0.5% and TDS under section 194-O 0.1% when checked on 14 November 2026. Type the current rates yourself; the tool never assumes them.
Common mistakes and how to fix them
- Trusting the columns without looking. Files change. If the sale value and the net payout columns are swapped, every total is wrong.
- No order id on your invoices. Without it orders are matched only by amount and date, and similar orders can be mixed up. Write the order id in the invoice reference.
- Adding the same payout to the books twice. Saved payouts are listed under “Saved payouts”: check there first.
Related help
All help on Marketplace Payout Check · Help for the Nivesh Sahayak App