Amazon settlement vs 1099-K: how to reconcile before tax season

Your Amazon 1099-K won't match your books or your bank: it reports gross dollars, includes the sales tax Amazon collected for you, and is dated by shipment date, not by what landed in your account. None of that is an error — you just have to reconcile it.

The good news: you don't need your CPA to do it, and you don't need to guess. Your settlement reports already contain almost every number you need. Below is what each document is really measuring, the five reasons they drift apart, and a worksheet you can run in about half an hour.

Why doesn't my Amazon 1099-K match my bank deposits?

Because they answer two different questions. Your bank shows net cash that arrived (after fees, refunds, and Amazon holding part of it back). The 1099-K shows gross transaction volume that Amazon processed on your behalf during the calendar year — before a single fee or refund is subtracted, and timed to when orders shipped, not when the money paid out.

So a 1099-K of $84,000 sitting next to bank deposits of $58,000 is normal. The gap is fees, refunds, sales tax pass-through, and timing. Your job at tax time isn't to make the two numbers equal — it's to explain the difference well enough that the gross on your return ties back to the 1099-K, and your deductions account for the rest.

What does the 1099-K actually report?

Form 1099-K is an information return that payment processors and marketplaces file with the IRS. Box 1a is gross amount of payment transactions for the year. For Amazon specifically, Box 1a includes:

• Product sales (Principal) — gross, before any fees
• Shipping you charged buyers
• Gift wrap and other buyer-paid charges
• Sales tax Amazon collected under marketplace-facilitator rules — yes, even though you never touched that money and Amazon remitted it to the states for you

That last one trips up almost everyone. Amazon is unusual here: most marketplaces (eBay and Etsy, for example) leave marketplace-facilitator tax out of Box 1a, but Amazon folds it in. Amazon does break the tax totals out separately further down the form (look past page 1), and you'll want those figures for the worksheet below.

What the 1099-K does not do:

• It does not subtract refunds. A $49.99 sale you fully refunded still counts $49.99 in Box 1a.
• It does not subtract Amazon fees, FBA fees, storage, or advertising.
• It does not reflect reimbursements, adjustments, or chargebacks the way your settlement does.

In short: 1099-K Box 1a is the biggest number in your whole Amazon picture, and it's gross on purpose.

One thing the old advice gets wrong: the threshold

You may have read that Amazon issues a 1099-K at $600. That was the planned federal rule, and it was reversed. The One Big Beautiful Bill Act, signed in July 2025, restored the federal 1099-K threshold to $20,000 in gross payments and 200+ transactions — the old pre-2022 numbers — and did so retroactively. So at the federal level the $600 phase-in never actually took effect.

The catch: several states set their own, lower thresholds (some as low as $600). If you're registered in one of those, you may get a 1099-K even if you're well under the federal floor. Don't assume "I'm small, so I won't get one." Check whether you did before you file.

What does a settlement report measure instead?

Your Flat File V2 settlement report is the opposite document. It's transaction-level and net. Every two weeks (or whenever Amazon settles your account), it lists each Principal, fee, refund, reimbursement, and tax line, and the bottom of it ties to an actual deposit. If you've never been able to read one, the glossary of every amount-type breaks down what each row means.

Three things about settlement reports matter for reconciliation:

• They show fees, refunds, and reimbursements as their own rows — so you can total them, which the 1099-K never lets you do.
• They show marketplace-facilitator sales tax as a separate, distinct line (MarketplaceFacilitatorTax-Principal and -Shipping). It is neither revenue you earned nor a fee you paid — Amazon collected it and sent it to the state. Treat it as a pass-through.
• Under Amazon's 2026 changes, the settlement and date-range reports now flag each amount with a transaction status and release date — effectively Released (hit your bank) or Deferred (Amazon is still holding it under DD+7 or your account-level reserve). That Released/Deferred split is what makes year-end timing reconcilable at all — more on that next.

What are the five reasons they never match?

Almost every dollar of the gap falls into one of these five buckets.

1. Refunds. The 1099-K counts gross sales and ignores refunds entirely. Your settlements net them out. If you refunded $4,000 across the year, that alone is a $4,000 gap before anything else.

2. Marketplace-facilitator sales tax. Amazon's 1099-K includes the sales tax it collected and remitted. You never earned it and you don't owe income tax on it. You back it out as a write-in adjustment (commonly labeled "Marketplace Facilitator Sales Tax Collected"). The exact figure is on your settlements and on page 2 of the 1099-K.

3. Timing — shipment date vs. everything else. This is the big one. Amazon reports on the 1099-K by shipment date. Your Seller Central date-range reports historically used order date, and your bank sees deposit date. An order placed and shipped December 28 lands on this year's 1099-K — but the cash might not settle until mid-January. (Amazon updated its date-range reports in early 2026 to better match the 1099-K, adding transaction-status and release-date columns, which helps going forward; historical years still drift.)

4. Deferred amounts straddling year-end. Because of Released vs. Deferred, money for a December sale can sit in Deferred status at December 31 and release in January. The sale is on this year's 1099-K; the cash shows up next year. Your settlement's Released/Deferred status is how you find and quantify those straddlers.

5. Adjustments and chargebacks across the boundary. A chargeback or goodwill adjustment posted in January against a December order won't be on the December-shipped 1099-K, but will hit a settlement. These are usually small, but they're the reason you reconcile to "within a percent or two," not to the penny.

How do I reconcile my 1099-K to my settlements? (the worksheet)

Work top-down, starting from the biggest number and subtracting your way to taxable revenue. You only need the year's settlement reports and the 1099-K itself.

A few notes that save real time:

• Don't try to make Box 1a equal your bank balance. Box 1a equals your books' gross revenue line (step 5), after you back out tax. Fees and refunds are reported as expenses/contra-revenue, not subtracted from the gross you report.
• The sales tax adjustment (step 2) is the single cleanest win. It's often 6–10% of Box 1a and it's pure pass-through. Backing it out is what closes most of the visible gap.
• Advertising is a separate deduction — don't expect all of it on the settlement. If you pay Amazon Ads by credit card, that spend never appears on your settlement reports at all; pull it from your Amazon Ads invoices. If you're on proceeds-deduction (Amazon nets ad spend out of your payouts), it shows up on the settlement as an AdsPayment-type line. Either way it's a deductible expense, not part of the gross in step 5.
• If you land within 1–2% after step 5, stop. The residual is timing and adjustments, and chasing it to zero costs more than it's worth.

A worked example

Say your 1099-K Box 1a reads $84,302.

• Subtract $5,910 of marketplace-facilitator sales tax (from page 2 / your settlement tax rows) → $78,392
• Subtract $4,455 of gross refunds → $73,937
• Adjust +$2,273 for December-shipped orders that were still Deferred at year-end and settled in January (they belong to this gross year even though the cash came next year) → $76,210 gross product + shipping revenue

That $76,210 is what should match the top line of your books. Your Amazon fees, FBA, and storage — pulled from the settlement fee rows — then come off as deductions on your return, alongside your ad spend (from your Ads invoices, or from the settlement if Amazon deducts it from your proceeds). The bank, meanwhile, deposited something lower again because of Deferred balances and refund timing, and that's fine. Every number is explained.

Can SettlementToExcel do this for me?

It does the tedious part. SettlementToExcel converts each Flat File V2 .txt into a clean 3-tab workbook, and the Summary tab already separates the numbers this worksheet needs: gross revenue, refunds, total fees, reimbursements, the Released-vs-Deferred split, and — since the v1.2.0 parser fix — sales tax shown as its own line, not buried in revenue or fees. Convert each settlement that covers the tax year, then add the Summary tabs together: those column totals drop straight into steps 2 through 6 above.

Be clear-eyed about what it is and isn't, though. SettlementToExcel is a file-in, file-out converter, not a bookkeeping system. It won't auto-sync from Amazon, post journal entries, carry your COGS, or pull your PPC ad invoices — so it doesn't replace your books, and it isn't the 1099-K itself. If you want accrual journal entries pushed into QuickBooks or Xero automatically, that's what an accrual tool like A2X is built for (see our A2X vs Sellerboard vs SettlementToExcel comparison). What this tool gives you is fast, readable totals you can reconcile by hand or hand to your CPA without paying for cleanup hours. If you'd rather build the worksheet yourself, the free settlement template has the same line layout.

The bottom line

Your 1099-K is gross, it includes sales tax, and it's dated by shipment — so it's supposed to be bigger than your bank and different from your books. Reconciling it is mostly subtraction: back out the tax, back out refunds, account for year-end timing, and the gross ties out. Do it in June and it's a calm afternoon. Do it in April and it's a fire drill.

When you're ready, drop your settlement .txt files into the converter — one per settlement for the year — and read the totals straight off the Summary tabs. That's the whole worksheet, already added up.