Amazon Seller Statement Converter: Convert Settlement and Payout Reports to Excel and CSV

Upload an Amazon settlement report, payment summary, or disbursement statement in PDF and get a clean Excel (.xlsx) or CSV file with the date, order, sales, Amazon fees, and refunds in their own columns, ready for bookkeeping, payout reconciliation, and tax prep.

Excel and CSV output
Splits sales, fees, and refunds
Encrypted in transit and at rest
Free to start, no credit card

PDF, JPG, PNG, BMP, HEIC, TIFF

Upload your bank statement

Extract:
|
|

Why convert an Amazon settlement report to a spreadsheet

Amazon pays sellers by settlement period, bundling every order, fee, refund, and reimbursement into one disbursement and sending the net to your bank a few days later. By the time it lands, the deposit has already had referral fees, FBA fees, shipping, refunds, and taxes taken out, so the figure on your bank statement never matches your gross sales. The settlement report holds the breakdown, but Amazon delivers it as a tab-delimited flat file or a date-range summary that often reaches a bookkeeper as a saved PDF. This converter reads that report into one row per line so you can see sales, the fee, and the refund separately, tie each Amazon disbursement to the deposit on your bank statement, and post the numbers to your books without retyping them.

Sales, fees, and refunds split out

Each line arrives with its sale amount, the Amazon referral and FBA fees, and any refund in their own columns, so you can total fees for the period and post net revenue without manual math.

Disbursements tied to deposits

Each Amazon disbursement is a settlement period netted of fees and refunds. Converted rows let you match that payout against the deposit on your bank statement and the orders behind it.

Ready to reconcile

Orders, fees, refunds, reimbursements, and adjustments are preserved line by line, so the export ties out to the totals on your Amazon settlement report.

How to convert an Amazon settlement report to Excel

Four steps, no software to install.

1

Get the report

In Seller Central open Payments, then Payments, then All Statements, and download the settlement period you need. A date-range summary report or a saved disbursement statement works too.

2

Upload it here

Drop the PDF into the converter at the top of this page. Password-protected files are detected the moment you upload them.

3

Review the table

The lines are read into rows. Check the preview and choose the columns you want to keep, such as date, order ID, sales, fees, and refunds.

4

Export Excel or CSV

Download a clean .xlsx or .csv file, ready for QuickBooks, Xero, NetSuite, or your own spreadsheet.

Who uses the Amazon seller statement converter

FBA and FBM sellers

Pull a settlement period or a full year of Amazon disbursements into Excel with fees and refunds separated, so you can see real net revenue and have clean records ready at tax time.

Ecommerce bookkeepers

Convert a client's Amazon settlement PDFs into import-ready files when you only get the report, not their Seller Central login, and keep every fee on its own line.

Accountants and CPAs

Convert Amazon reports into structured data for year-end close, sales tax, and reconciliation, with sales, fees, and refunds kept on separate lines.

Multi-channel sellers and agencies

Convert settlement reports from several Amazon marketplaces or stores into the same column layout, so you can roll them up and reconcile each one against its bank deposits.

Built for real Amazon documents

An Amazon settlement report carries far more than a list of sales. Orders bring money in, referral and FBA fees come off, refunds and reimbursements move money in both directions, and each settlement period sweeps the net to your bank. The flat file packs prices into a handful of generic amount columns that are hard to read, and the summary version is built around totals. The converter keeps that detail intact so nothing has to be re-entered.

  • Order sales and product charges across the settlement period
  • Amazon referral fees and FBA fulfillment fees split out from each line
  • Refunds, returns, and FBA reimbursements kept on their own rows
  • Disbursements to your bank, with the settlement total
  • Advertising charges, storage fees, and other adjustments

Output you can use anywhere

Export to Excel (.xlsx) for analysis or CSV for clean imports. The CSV maps neatly into accounting tools, so you can bring Amazon activity straight into your books. If you keep QuickBooks Desktop, you can take that CSV one step further and turn it into a QBO file with a CSV to QBO converter.

Excel .xlsx CSV QuickBooks-ready Xero-ready NetSuite-ready Google Sheets

Amazon seller statement converter FAQ

How do I convert an Amazon settlement report to Excel?

Open Seller Central, go to Payments, then Payments, then All Statements, and download the settlement period you want. Upload that file to the converter at the top of this page. It reads each line into rows and lets you export a clean Excel (.xlsx) or CSV file. The whole process takes about a minute per document and needs no software install.

Where do I find my Amazon settlement report?

In Seller Central, open the Payments menu and choose Payments, then the All Statements tab. Each settlement period lists the orders, fees, refunds, and the disbursement to your bank, and you can download it as a flat file, an XML file, or a date-range summary. Settlement reports stay available for the past 90 days, so save older periods as PDFs before they roll off.

Why does my Amazon payout not match my sales?

An Amazon disbursement is your gross sales for a settlement period minus referral fees, FBA fees, shipping, advertising, and refunds, plus any reimbursements. Refunds and reimbursements can also fall in a different settlement period from the original sale. That is why the deposit on your bank statement is lower than your sales. Converting the report shows each piece on its own line so the math is clear.

Amazon already exports a flat file. Why convert the PDF?

Amazon's flat file is tab-delimited and packs every price into a few generic amount columns, so it needs a pivot template before it reads cleanly. Bookkeepers also often receive only a saved settlement statement or a date-range summary as a PDF. Converting the PDF flattens it into one clear row per line with sales, fees, and refunds separated, so you can reconcile and import without asking for the Seller Central login.

Does Amazon provide a monthly statement?

Amazon does not issue a single monthly statement. Instead it produces a settlement report for each payment period, usually every two weeks, plus date-range summary and transaction reports you can pull for any window. Each of these documents converts here into clean spreadsheet rows you can reconcile against your bank deposits and import into your accounting software.

How do I match an Amazon disbursement to my bank deposit?

Each Amazon deposit on your bank statement is a settlement period netted of fees, refunds, and reimbursements. Convert the settlement report here to see every order and adjustment in that period in its own row. Total the net column and it equals the deposit, so you can reconcile the bank line to the underlying Amazon orders in seconds rather than guessing what the lump sum covers.

Is my Amazon data secure when I convert it?

Files are encrypted in transit and at rest while they are processed, and the conversion runs without sharing your data with third parties. You stay in control of the file and the resulting export. Because it works straight from the report, you never have to hand over your Seller Central login or grant anyone access to your account.