In Amazon Seller Central, open Reports, then Payments, then Date Range Reports. Choose the Summary or Transaction view, set your start and end dates, generate the report and download it as CSV or Excel. For reconciliation, use the Transaction view, then match it against the settlement statements and your bank credits. Menu names change, so confirm them in your account.
Date Range Report vs settlement report: which one you need
Amazon gives sellers two broad ways to look at money. The settlement report follows Amazon's own payout cycles and shows what was bundled into each disbursement. The Date Range Report follows the calendar period you pick and groups transactions by their transaction date.
For reconciliation you usually need both. The Date Range Report answers "what happened in April?". The settlement answers "what was paid out, and when?". Differences between the two are where most unexplained gaps hide.
- Use the Date Range Report for month-end books, return and fee analysis, and sales-to-revenue checks.
- Use the settlement report to match individual bank credits.
Steps to download the Amazon date range report
Amazon changes menu labels from time to time, so treat this as the usual path and confirm it in your own Seller Central account.
- Log in to Seller Central with a user who has access to payments and reports.
- Open the Reports menu and select Payments.
- Go to the Date Range Reports tab.
- Click to generate a new report and choose the report type: Summary or Transaction.
- Set the start and end dates. Use a full calendar month for month-end work.
- Submit the request and wait for the status to show as ready.
- Download the file as CSV or Excel and save it with a clear name, such as the month and report type.
If you cannot see the Payments option, check your user permissions with the account owner.
Summary or Transaction view: what to pick
The Summary view rolls amounts up into categories such as sales, refunds and fees. It is quick for a management view and a first sanity check.
The Transaction view lists line-level entries: order IDs, transaction types, amounts and fee components. This is the one you need to trace a specific order, check a deduction, or investigate a refund.
A good habit is to download both for the same period. Check that the Transaction view totals agree with the Summary before you start any matching. If they do not, you probably have a date or filter problem, not a payment problem.
Matching the report to settlements and bank credits
Once downloaded, work in three layers: report to settlement, settlement to bank, and fees to your agreed terms.
| Check | Compare | What a gap usually means |
|---|---|---|
| Sales and refunds | Report totals vs your order and return data | Missing returns, cancelled orders, timing |
| Net payable | Report net vs settlement statement | Transactions falling in a different period |
| Bank credit | Settlement net vs bank statement | Reserves, carry-forwards, adjustments |
| Fees | Fee lines vs your seller agreement and rate card | Wrong category, wrong slab, extra charges |
Do not assume any fee or tax rate from memory. Take the rates from your seller agreement, the current fee schedule shown in Seller Central, and your tax adviser for GST and TCS treatment. Confirm the latest terms before raising a dispute.
The Flipkart equivalent
Flipkart's Seller Hub has its own payment and settlement reports, usually under the payments section, with order-level downloads for settled and pending items. Names and filters differ from Amazon, and they change, so check the options in your own Seller Hub.
The method stays the same: pull a calendar-period report, pull the settlement-level report, and tie both to the bank. Keep the files for each marketplace in separate, consistently named folders so month-end does not turn into a file hunt.
Common mistakes and when to automate
- Comparing different periods. A calendar-month report will not equal one settlement cycle.
- Ignoring time zone and cut-off. Orders near midnight on month-end can slip across periods.
- Filtering out transaction types. Refunds, adjustments and reimbursements need to stay in.
- Skipping the fee check. Fees that look normal in total can still be wrong per order.
Doing this monthly in spreadsheets works for a small catalogue. As volumes grow, tools such as MarketplaceMetrics by Fundle can reconcile sales and settlements, check commissions and fees against agreed terms, and track returns and recovery cases. Myntra Excel reports are reviewed today, and Amazon and other marketplaces can be discussed as a scope question.
Worked example
Illustrative example only. These figures are not real data or typical rates.
Suppose the Transaction view for April shows:
- Product sales: ₹1,00,000
- Refunds: -₹8,000
- Fees and charges: -₹18,500
- Other adjustments: -₹2,500
Net for the period is ₹1,00,000 - ₹8,000 - ₹18,500 - ₹2,500 = ₹71,000.
Your bank statement shows settlement credits of ₹68,000 relating to these orders. The gap is ₹3,000. Check whether some April transactions fall into a settlement paid in May, whether a reserve or carry-forward was applied, and whether a separate adjustment was made. Only after these checks should you treat the ₹3,000 as a recoverable shortfall and raise it with Amazon.
Questions and answers
Where is the Date Range Report in Amazon Seller Central?
It is usually under Reports, then Payments, then the Date Range Reports tab. Amazon renames menus occasionally, so if you cannot find it, search for payments reports in Seller Central or check that your user role has payments access.
Can I download a Date Range Report for any period?
You can choose a start and end date, but Amazon may limit how far back or how long a range can be. If a large range fails, download it month by month and combine the files. Check current limits in Seller Central.
Why does my Date Range Report total not match my settlement?
The report groups by transaction date, while a settlement covers Amazon's payout cycle. Transactions near period edges, reserves, carry-forwards and later adjustments cause differences. Reconcile report to settlement first, then settlement to the bank credit.
Should I use the Summary or Transaction view for reconciliation?
Use the Transaction view for reconciliation because it shows line-level entries you can trace to orders, refunds and fees. Use the Summary view as a quick cross-check that totals agree before you begin matching individual lines.