Step-by-step guide

How to download your
three Amazon reports.

You'll need three reports from Amazon Seller Central plus your bank statement. Total time: about 4 minutes if you know where to click. Below, exactly where to click.

On this page
  1. Before you start - login + permissions
  2. Report 1 - All Orders (PO Report)
  3. Report 2 - Settlement Report
  4. Report 3 - Bank Statement
  5. Pick your TDS rate (1% vs 2%)
  6. Run the scan
  7. Troubleshooting
Before you start

Make sure you have access

  • You need Admin or Finance role on the Seller Central account. Sub-users with limited permissions can't download settlement reports.
  • You need login access to sellercentral.amazon.in - not Amazon.com Seller Central. India-specific reports only come from the .in marketplace.
  • Your bank statement should cover the same period as your Settlement Report (the dates Amazon credited payouts to you).
💡 If you have multiple seller accounts (e.g. Soultheory + Chemistors), you'll run a separate scan for each. Pro Annual lets you re-scan unlimited times for 12 months.
Report 1 of 3

All Orders Report (PO Report)

This is the source of truth for what was sold - every order, every SKU, the prices Amazon committed to. We compare each row here against the Settlement Report.

  1. 01
    Log in to Seller Central
    Visit https://sellercentral.amazon.in and sign in.
  2. 02
    Navigate to Reports → Fulfillment
    In the top nav, click Reports → Fulfillment.
  3. 03
    Find "All Orders"
    In the left sidebar under Sales, click "All Orders". You'll see a date range picker and a Download button.
  4. 04
    Pick your date range
    Use the same date range you'll use for the Settlement Report below - typically the last 30, 60, or 90 days. Match exactly so the Order IDs line up.
  5. 05
    Click "Request" then download
    Amazon prepares the report in 1–10 minutes (longer for big sellers). When ready, you'll see a "Download" link. Save the .txt or .csv file.
  6. 06
    Rename for clarity (optional)
    Rename to e.g. "PO_Mar2026.txt" so you don't mix it up with the others.
What we check from this file
Order ID, SKU, ordered quantity, item price, ship date, fulfillment center.
Report 2 of 3

Settlement Report

This is what Amazon actually paid. Every credit, every deduction (TDS, commission, fees, returns), one settlement cycle at a time. The discrepancy between PO and Settlement is where the missing money lives.

  1. 01
    Reports → Payments
    In the top nav, click Reports → Payments.
  2. 02
    Settlement Reports tab
    Pick the "Settlement Reports" tab (sometimes called "All Statements" depending on Seller Central version).
  3. 03
    Pick a date range
    Settlements are generated every 7 or 14 days. Pick the cycle(s) matching your PO Report period. You may need to download multiple settlement files if your PO range covers 2-3 cycles.
  4. 04
    Download as CSV (or "Flat File V2")
    For each settlement, click "Download Flat File V2" or just "Download Report". Save the .csv - do NOT save as PDF or Excel from the dashboard view.
  5. 05
    If multiple files: combine them
    If you downloaded 2-3 settlement files, you can combine them into one .csv (just paste the rows). Or upload them one at a time and we'll handle each scan.
What we check from this file
Order ID, settlement amount, deduction reasons, fee codes, settlement date, TDS amount.
Common mistake
Don't download the "Statement Summary" or PDF. We need the raw line-item CSV. If you only see a 5-line summary, you're looking at the wrong file.
Report 3 of 3

Bank Statement

We use this to confirm the amount Amazon actually credited to your bank matches the settlement. Catches the rare case of a settlement showing ₹X paid out, but only ₹Y arriving in your account.

  1. 01
    Log in to your bank's net banking
    Whichever bank Amazon credits your payouts to.
  2. 02
    Download statement for the same period
    Match the date range to your Settlement Report. Most banks let you export as CSV, Excel, or PDF.
  3. 03
    CSV or Excel preferred
    PDF works as a fallback but CSV is faster and more reliable. Most banks (HDFC, ICICI, Axis, SBI, Kotak) export CSV from the statement page.
  4. 04
    Filter to "Amazon" credits if you want
    Optional - you can pre-filter the statement to only Amazon-related transactions before export. Makes the file smaller and faster to upload.
What we check from this file
Date, credit amount, narration containing "AMZN" or "Amazon".
One toggle to set

Pick your TDS rate

On the tool page, there's a TDS toggle: Individual (1%) or Company / LLP / Partnership (2%). Picking the wrong one will throw off the math.

  • Individual (1%): If your PAN is registered as an individual proprietor.
  • Company / LLP / Partnership (2%): If your PAN is registered as a Pvt Ltd, LLP, OPC, or Partnership firm.
💡 When in doubt, check your last GST return or TDS Certificate (Form 16A) - it tells you the rate Amazon is deducting at.
Final step

Run the scan

Head to the tool page, drop in all three files, set the TDS rate, and hit Run. The Free Scanner shows your total + the top 3 line items. If the number is worth ₹1,999, unlock the full report (every line, every ticket, Excel export).

Open the tool
Stuck somewhere?

Troubleshooting

The PO Report download is stuck at 'Pending' for hours.
That happens when Amazon's report queue is busy (typically end of month). Try a smaller date range first, or download in the morning IST when load is lower.
My Settlement Report shows fewer rows than my PO Report.
Normal - settlements lag orders by 7–30 days. Adjust your PO date range to end a week before your settlement end-date to make them line up.
The Settlement file is .txt, not .csv. Will it work?
Yes. Amazon's "Flat File V2" is a tab-separated .txt that our parser handles. Upload it as-is.
My bank statement is a PDF.
Try to export as CSV first - every major Indian bank supports it. If you can't, email the PDF to support@paiseback.in and we'll convert it for you (free, takes a few minutes).
I have multiple Amazon seller accounts. Can I scan them all together?
Run one scan per account. Don't combine reports across accounts - Order IDs collide and the math breaks. Pro Annual covers unlimited re-scans.
What if my Settlement Report has FBA + FBM mixed?
Works fine. Our parser auto-detects format differences and reconciles both correctly.
The tool says 'file format not recognized'.
Most likely you opened the .csv in Excel and saved it back as .xlsx with formula formatting. Re-download fresh from Seller Central without opening it locally.
← HomeRun scan →PrivacyTermssupport@paiseback.in