Which Amazon Seller Central Reports Do You Need for Accounting?
The Seller Central reports accountants use (settlement, date range, Inventory Ledger, reimbursements, returns, 1099-K), what each answers and when to pull it.
For accounting, an Amazon seller needs five core Seller Central reports: the settlement report (to post transactions and match each deposit), Date Range Reports (for calendar-month and annual totals), the Inventory Ledger (for unit-level inventory and COGS), the Reimbursements report, and FBA customer returns. Supporting reports cover storage, removals, the 1099-K and advertising.
A note on menus. Seller Central’s navigation changes often. The locations below are approximate, so if a path doesn’t match, search for the report name in Seller Central’s menu search.
Start with the question, then pick the report
| Accounting question | Report to use | Typical location |
|---|---|---|
| What makes up this bank deposit? | Settlement report (flat file) | Payments → Statement view / All statements |
| What were total sales, fees and refunds for the calendar month or year? | Date Range Reports – Summary and Transaction | Payments → Reports Repository |
| What’s being held back, and when will it be released? | Statement view reserve section; Transaction view (deferred transactions) | Payments |
| How many units did Amazon receive, ship, lose, find, return or dispose of? | Inventory Ledger | Reports → Fulfillment |
| What did Amazon reimburse, and for which events? | Reimbursements | Reports → Fulfillment |
| Which returned units came back sellable? | FBA customer returns | Reports → Fulfillment |
| Why was storage so high this month? | Monthly storage fees (and aged inventory surcharge reports) | Reports → Fulfillment |
| What did removals and disposals cost, and where did the units go? | Removal order detail; Removal shipment detail | Reports → Fulfillment |
| What does Amazon report to the IRS as gross payments? | Form 1099-K | Reports → Tax Document Library |
| What sales tax did Amazon collect, by state? | Sales tax reports in the Tax Document Library | Reports → Tax Document Library |
| What did advertising cost this month? | Billing history / invoices | Amazon Ads console → Billing |
The core five, in detail
1. Settlement report: the backbone
| What it is | Every transaction in one settlement period: orders, refunds, fees, advertising deducted, reimbursements and reserve movements. The flat-file version has one row per transaction component. |
| Ties to | Exactly one disbursement to your bank |
| Use it for | Posting the period to your Amazon clearing account and matching the deposit |
| Watch out for | Settlements that cross month-end (split by date on the accrual basis); negative settlements; new transaction types that haven’t been mapped |
| Frequency | Every settlement, usually about every two weeks |
Connectors such as A2X and Link My Books read this data automatically, but you or your bookkeeper should still be able to open the raw file when a number looks wrong. The settlement reconciliation worked example walks through one line by line.
2. Date Range Reports: the calendar view
| What it is | A report for any date range you choose. The Summary version is a PDF of totals by category, and the Transaction version is a CSV of individual transactions. |
| Ties to | Nothing directly. It cuts across settlements. |
| Use it for | Checking that monthly totals in your books agree with Amazon (sales, refunds, fees), and preparing annual figures for tax and the 1099-K reconciliation |
| Watch out for | Differences from your books caused by settlement timing, deferred transactions or how promotions and taxes are grouped. Investigate large ones; small timing differences are normal. |
| Frequency | Monthly and annually |
3. Inventory Ledger: units are the truth
| What it is | Unit movements for FBA inventory by SKU and fulfillment center: starting balance, receipts, customer shipments, customer returns, vendor returns (removals), found, lost, damaged, disposed and other adjustments, and ending balance. Summary and detailed views are available. |
| Use it for | Calculating units sold for COGS; reconciling FBA inventory to your books monthly; supporting year-end ending inventory; identifying lost and damaged units for reimbursement checks |
| Watch out for | Lost-then-found units that net to zero over time; unsellable units still counted in ending balances; multi-channel fulfillment shipments that need tagging to the right channel |
| Frequency | Monthly, plus a December 31 snapshot each year |
The ledger shows units, not dollars. You apply your landed cost to the units; see the Amazon COGS calculation guide.
4. Reimbursements report
| What it is | Each reimbursement with its reason (for example lost or damaged in the warehouse, or customer return not received), the quantity, the amount paid and any replacement units |
| Use it for | Matching reimbursement lines in settlements to inventory events; spotting reversals; documenting what Amazon has and hasn’t paid |
| Watch out for | Reimbursements paid as replacement inventory rather than cash; reversals in later periods |
| Frequency | Monthly |
Claim windows and valuation rules are set out in Amazon’s FBA inventory reimbursement policy. The accounting for each scenario is in the refunds and reimbursements guide.
5. FBA customer returns
| What it is | Each customer return with its disposition (sellable, customer damaged, defective, carrier damaged and so on) |
| Use it for | Deciding which returned units go back into inventory at cost and which stay in COGS as losses; tracking return rate by SKU |
| Watch out for | Refunds without returns, which won’t appear here, and returns that arrive in a later month than the refund |
| Frequency | Monthly |
Supporting reports
| Report | What it gives you | Accounting use |
|---|---|---|
| Statement view and Transaction view | Live view of the current, unclosed settlement; deferred (reserved) transactions | Estimating the month-end clearing balance; tracking reserve release dates (reserve guide) |
| Amazon Fulfilled Shipments | Order-level FBA shipment detail, including ship-from and ship-to locations | Sales-by-state analysis; investigating specific orders |
| Monthly storage fees / aged inventory surcharge reports | Storage charges by ASIN with volume and rate | Accruing storage at month-end; finding the SKUs that drive storage cost |
| Removal order detail / Removal shipment detail | Removal and disposal orders, fees, and units shipped back or destroyed | Writing off disposed units; tracking returned stock into your warehouse or 3PL |
| Fee Preview | Estimated referral and fulfillment fees per SKU at current dimensions | Catching dimension or size-tier errors before they cost months of overcharges (FBA fees guide) |
| Tax Document Library | Form 1099-K (when issued) and sales tax reports | 1099-K reconciliation; checking marketplace facilitator collections |
| Amazon Ads billing history / invoices | Ad charges by billing event and payment method | Reconciling ad expense (PPC accounting) |
Why reports disagree with each other (and which one wins)
Different reports measure the same activity at different moments and on different bases. Mismatches are normal. What matters is knowing which report is authoritative for each purpose.
| Mismatch | Why it happens | Authoritative for the books |
|---|---|---|
| Settlement total vs. Date Range Report for the same month | Settlements cross month-end; deferred transactions are released later | Settlements, split by transaction date |
| Units sold in Business Reports vs. the Inventory Ledger | Ordered units vs. shipped units; cancellations; multi-channel fulfillment | Inventory Ledger |
| Reimbursements report vs. reimbursement lines in settlements | A reimbursement can be approved in one period and paid in a later settlement; replacement units carry no cash | Settlement for cash; Reimbursements report for units |
| Storage fee report vs. storage charged in a settlement | The fee report covers a calendar month; the charge posts in a later settlement | Settlement for the charge; fee report for the accrual and SKU detail |
| Ad console spend vs. ad deductions in settlements | Billing thresholds and timing; card or invoice billing outside the settlement | Billing history and invoices, reconciled to the books |
| 1099-K gross vs. net sales in the books | Different definitions (gross payments vs. net revenue) | Your books, with a documented reconciliation |
When a difference doesn’t fit one of these explanations, investigate it. That usually means a missed settlement, a mapping error or a report pulled for the wrong marketplace.
The report that doesn’t belong in your books
Business Reports (Sales and Traffic, Detail Page Sales and Traffic) show ordered product sales, sessions, page views and conversion. They measure customer activity when the order is placed, before refunds, cancellations and fee adjustments, and on a different basis from settlements. They are very useful for marketing and inventory planning. Do not use them as a revenue source for accounting or tax, and do not expect them to match your P&L.
Form 1099-K: Amazon’s number vs. yours
If Amazon issues you a Form 1099-K, it reports gross payment transactions processed for you. That figure is not your taxable income, and it usually won’t match your net sales. It can include amounts such as sales tax collected or shipping, depending on how Amazon calculates it, and it is before refunds and fees. The IRS explains how to handle the form on its Understanding your Form 1099-K page. Reconcile it to your books every year using Date Range Report totals; see Amazon 1099-K reconciliation.
Your monthly report pack
Download these after month-end and save them in a folder named by year and month:
- All settlement reports (flat file) for settlements closing in the month
- Date Range Report – Summary (PDF) and Transaction (CSV) for the calendar month
- Inventory Ledger, summary view for the month (and detailed view if you reconcile by event)
- Reimbursements report for the month
- FBA customer returns for the month
- Monthly storage fee report
- Removal order and removal shipment detail, if there were any removals
- Amazon Ads billing history or invoices for each ad account
- December only: Inventory Ledger snapshot as of December 31, and full-year Date Range Report
Why archive? These reports are the records that support the income, COGS and deductions on your tax return. The IRS expects you to keep supporting records; see IRS recordkeeping guidance. Not every Seller Central report stays available indefinitely, and if your account is ever suspended or closed, access can be cut off. A local or cloud archive avoids both problems.
This pack is part of the monthly close in the Amazon seller bookkeeping checklist.
Access and permissions
Give your bookkeeper or accountant their own Seller Central user with permissions limited to the reports and payments views they need. Do not share your owner login. Separate users keep an audit trail and let you remove access cleanly.
Let someone else pull the pack
If downloading and reconciling these reports every month is the part that keeps slipping, our Amazon bookkeeping service pulls the full report pack, reconciles it to your books and archives it with your monthly financials.
Questions sellers ask
What is the difference between a settlement report and a Date Range Report?
A settlement report covers one settlement period and ties to one deposit, so use it to post transactions and reconcile the bank. A Date Range Report covers whatever dates you choose, such as a calendar month or year, so use it to check monthly totals and prepare annual summaries.
Can my bookkeeper get these reports without my Amazon password?
Yes. Seller Central lets the account owner add users with their own logins and specific permissions. Give your bookkeeper their own user account with access limited to the reports they need, rather than sharing your credentials.
Why doesn't Business Reports' ordered product sales match my books?
Business Reports show ordered sales when the order is placed, before cancellations, refunds and promotions, and they serve a different purpose. Your books record sales from settlement data when they are recognized. Use Business Reports for traffic and conversion analysis only.