Tax and GST

Marketplace seller settlement reports: a monthly download routine

A monthly routine for marketplace seller settlement reports: download settlement and commission reports, store by month and match them to bank credits.

Editorial illustration for Marketplace seller settlement reports: a monthly download routine

Download your marketplace settlement and commission reports on a fixed day each month, save them in a folder named for the month, and compare each report's net amount with the credits on your bank statement. Doing it monthly keeps the reports from piling up, and any gap between the two is spotted while the details are still fresh.

Which reports should you download each month?

Every marketplace labels its reports differently, so look in your seller account for the ones that cover these four things, and check the help pages if the names are unfamiliar. Some portals keep older reports available only for a limited time, so find out how long yours does.

  • The settlement or payment report, showing what was paid out and when.
  • The commission and fee report, showing what was charged per order or per period.
  • The returns and refunds report, showing what was reversed.
  • Any adjustment or penalty statement.
  • The tax invoices or statements the marketplace issues for its own fees, if your account provides them.

What does the calendar look like?

WhenWhat to do
First three days of the monthDownload last month's settlement, fee and returns reports
Same daySave them in a folder named with the month and year; rename files with the date range
Within a weekMatch the totals with the bank credits and fill the reconciliation row
Every MondayGlance at pending payouts and returns in the seller account
Quarter endArchive the quarter's folder and back it up

Name every file with what it is and the period it covers, such as 2026-10 settlement report 01 to 31 Oct. Marketplace-generated names are rarely clear, and a folder of unclear names is almost as hard to use as no folder.

How do you match the reports to the bank?

Use one reconciliation row per month, with columns for sales, fees, returns, net per the report, bank credits received, and the difference. A worked example with made-up numbers: sales ₹52,000, commission and fees ₹7,800 and returns ₹4,200. The net per the report is ₹52,000 minus ₹7,800 minus ₹4,200, which is ₹40,000.

Your bank statement shows two credits in that period: ₹25,000 and ₹14,500, totalling ₹39,500. The difference is ₹40,000 minus ₹39,500, or ₹500. Do not hide it. Look at the report for an adjustment, a held amount or a later settlement date, and write what you find. If nothing explains it, write to the marketplace's seller support with the report and the dates.

In a sheet, the check is a single formula: =C2-D2-E2 for net, where C is sales, D is fees and E is returns; and =F2-G2 for the difference between the net and the bank credits. These formulas work in Excel and Google Sheets.

What should you keep for your CA?

Keep the monthly reports, the reconciliation sheet and the bank statements for the same months. How marketplace fees, returns and any tax collected by the marketplace are treated is for your CA to decide, and rules and limits change, so confirm the current position with your CA or the official source.

What if you sell on more than one marketplace?

Use the same layout for each, in a separate folder per marketplace, and one reconciliation sheet with a tab each. Resist the urge to merge them early. Their reports use different names for similar things, and mixing the columns makes errors hard to trace.

A short checklist

  1. Set a recurring reminder for the first of the month.
  2. Download the reports and save them with clear names.
  3. Fill the reconciliation row and explain any gap.
  4. Raise a ticket with seller support for any gap you cannot explain.
  5. Back the folder up, and tell your CA where it is.

For your own costs, such as packaging and storage, SpendixAI can take a bank or card statement and receipts, which leaves the settlement sheet focused on the marketplace.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports