How do I reconcile Amazon 1099-K data with my state sales tax filings at scale?

The Amazon 1099-K creates confusion because it looks like a sales document but doesn’t function like one for sales tax purposes. It reports gross proceeds (a federal tax concept) not jurisdictional taxable sales broken out by state. Using it to verify your state filings doesn’t work and shouldn’t be attempted.

The right reconciliation uses Amazon’s transaction-level tax reports. Here’s the process.

Why the 1099-K and your state returns don’t match, and shouldn’t

The 1099-K captures:

• All gross proceeds Amazon processed for you across all states
• Including Amazon-collected tax (which Amazon remits; you don’t owe it)
• Including FBA fulfillment fees Amazon collects from customers and passes through
• Including sales in states where Amazon has marketplace facilitator collection obligations
• Before refunds and returns

Your state sales tax returns capture:

• Transaction-level sales by ship-to state
• Less: marketplace-facilitated amounts (Amazon collected and remitted, you deduct these)
• Less: returns and refunds
• Subject to: the state’s specific taxability rules and your exemption certificate deductions
• Adjusted for: the state’s filing period (not necessarily calendar year)

These will never match, and they shouldn’t. The 1099-K sum across your state returns will be lower than your 1099-K gross by at least the amount Amazon collected and remitted on your behalf.

The right documents for sales tax reconciliation

Amazon reports to use:

1. Transaction-Level Sales Tax report Location: Seller Central → Reports → Tax Document Library → Sales Tax Reports → Transaction-Level Sales Tax Report

This report shows every transaction with:

• Order date and ship date
• Ship-to state, county, city, and zip
• Taxable sale amount
• Tax collected
• Whether Amazon collected and remitted (the “marketplace” flag)

This is the source document for reconciling to your state returns. Pull it for each filing period.

2. Date Range Transaction report Location: Seller Central → Reports → Payments → Transaction View

This captures total proceeds including fees, refunds, and adjustments. Useful for confirming gross proceeds but not for state-level reconciliation.

3. Inventory by State report (for FBA nexus confirmation) Location: Seller Central → Inventory → Manage Inventory → Inventory by State

Not directly a reconciliation document, but relevant for confirming nexus in states where Amazon has placed your FBA inventory.

The reconciliation process

Step 1: Pull the Transaction-Level Sales Tax report for the period

For monthly filers: pull monthly. For quarterly and annual filers: pull for the applicable period. Download as CSV.

Step 2: Aggregate by state

Sum the transaction-level data by ship-to state:

• Total gross sales by state
• Total Amazon-collected tax by state (the marketplace-facilitated portion)
• Total sales from which you need to file (gross less marketplace-facilitated)

For most brands, Amazon collects tax on all Amazon transactions in all states post-marketplace-facilitator law. The “sales from which you need to file” may be $0 for Amazon-only nexus states.

Step 3: Match state-by-state to your returns

For each state return you filed during the period:

• Does the gross sales line match Amazon’s transaction report gross for that state?
• Does the marketplace deduction match Amazon’s collected amount for that state?
• Does the net taxable amount produce the correct liability?

Differences should be explainable, refunds processed, timing differences between order date and ship date, non-Amazon channel sales included in the same return.

Step 4: Layer in non-Amazon channel data

Your state returns include all channels — Amazon, Shopify, Etsy, wholesale, and any other. The Amazon transaction data is one component. Add your direct-channel transaction data to the reconciliation to cover the full return.

A complete state-level reconciliation master file looks like:

Step 5: Reconcile to the 1099-K at year-end

Sum your annual transaction report data across all states. This total should match your 1099-K gross within rounding and timing differences. Document the bridge:

• 1099-K gross proceeds: $X
• Less: refunds and returns: ($X)
• Less: FBA fees passed through: ($X) [if applicable]
• Adjusted gross sales: $X → matches sum of transaction-level report gross

If significant unexplained differences remain, investigate before the state asks. Knowing your own reconciling items protects you if a state’s compliance division contacts you with questions about a 1099-K discrepancy.

Automation options at scale

For brands with large Amazon volume across 30+ states, manual CSV reconciliation each period becomes significant work. AutoFile platforms that integrate directly with Amazon Seller Central pull the transaction-level data automatically and apply the marketplace deduction correctly by state. At mid-market scale, this integration is worth the setup time.

Platforms without direct Amazon integration require either manual CSV import or a middleware tool that formats Amazon’s export into the platform’s expected input format.