From the same marketplace and the same dates. Save each as CSV, or copy the rows with their header row from a spreadsheet.
1Orders report
Your orders or sales report: order ID, dates, status and order value.
2Payments or settlement report
What the marketplace paid or charged for each order.
Runs in your browser. The reports and the buyer details in them are not uploaded or saved.
Type them from your own rate card, fee invoices and seller agreement. Fees change by category and over time, so none are built in. They are kept in this browser for next time.
Payment cycle
Our suggestion: 3 days. Amazon.in's seller blog says a bank transfer can take 2 to 3 working days to arrive.
Usually today, or the last date your payments report covers.
Fees per order
Copy TCS and TDS from your payment report and check them with your CA. The product GST rate lets them be taken on the price before GST. If your products have different fee rates, check one category at a time, or add an expected payout column to your orders report.
Returns and matching
Our suggestion: ignore up to ₹5 for rounding. Your terms and shop name are saved in this browser; the reports never are.
We matched your column names. Change any that are wrong.
Orders report
Needed. Matched with the payments report.
Used when there is no other date.
Optional. For a cycle from dispatch.
Optional. For a cycle from delivery.
Optional. Delivered, returned, RTO.
Needed for amounts. What the buyer paid.
Optional. Shown in the lists.
Optional. Replaces your terms.
Payments report
Needed. The same ID as in orders.
Needed. Credits plus, debits minus.
Optional. Spots refunds and fees.
Optional. A separate fee column.
Free Marketplace Payment Reconciliation. Runs in your browser, no sign-up. Open the full tool on DigitalSnot →