Staging preview — not indexed. Highlighted items are unverified claims awaiting firm confirmation.
Draft — pending CPA review (draft). This page is excluded from the production build until a named, credentialed reviewer approves it.

Amazon Seller Accounting

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.

Sources

  1. IRS: Recordkeeping for small businesses
  2. IRS: Understanding your Form 1099-K
  3. Amazon Seller Central: FBA inventory reimbursement policy
  4. Amazon Seller Central: Selling on Amazon fee schedule
  5. Amazon Ads: Update on advertiser payments

Talk to an ecommerce CPA about your numbers

A free 15-minute discovery call. We’ll look at where your books stand, what’s holding your margins back, and what to fix first — no obligation.

Call nowBook a call