Reconciling Your Etsy 1099-K to What Actually Hit Your Bank

Two numbers, both correct, and they still don’t match.

Your Etsy 1099-K reports one figure. Your bank statement, added up for the same year, reports another. If you’re expecting them to be the same, the gap looks like an error — Etsy’s, your bank’s, or your own. It usually isn’t. The two numbers are measuring different things: one is gross payment volume before anything comes out, the other is what actually landed in your account after everything did. Reconciling them isn’t correcting a mistake. It’s walking, line by line, through everything that separates the two — so that by the end, nothing about the difference is a mystery.

This matters for more than tidiness. If a preparer, or the IRS, ever asks why your bank deposits don’t match your 1099-K, “I’m not sure” is a bad answer to be giving about your own books. A worked reconciliation is the good one.

One note before the steps: this covers Etsy specifically, but the same shape of gap shows up for any marketplace that issues a 1099-K — the platform’s reported gross and your bank’s recorded deposits are never going to be the same number, and the difference is always made of the same handful of things.

Why the threshold changed, and why it doesn’t change any of this

Following the One Big Beautiful Bill Act, federal law now requires a 1099-K only when a platform pays you more than $20,000 and across more than 200 transactions in a year — not the lower figures that were enacted and then repeatedly delayed in earlier years. Both tests have to be met, and they are measured per platform. The IRS states the current rule on its Understanding your Form 1099-K (opens in new tab) page; nine states and the District of Columbia set lower thresholds of their own, which the 1099-K glossary entry lists. If your Etsy shop is under both federal numbers and your state’s, you may not get a form at all this year — the free 1099-K threshold tracker will tell you which way you fall.

That changes whether you receive a piece of paper. It changes nothing about what you owe. Income from selling on Etsy is taxable whether or not a 1099-K arrives, and the eight steps below are worth doing on your own records even in a year with no form — the reconciliation is what tells you your numbers are right, not the form.

Before you start

Pull these three things together first; every step below works against one of them.

• Etsy’s monthly statement CSVs for every month of the year — the monthly statements, not the per-order export.
• Your bank or payout account statements for the same year.
• Somewhere to do the arithmetic — a blank spreadsheet is enough, or the Sales-Tax & 1099-K Reconciliation Workbook.

The eight steps

Work them in order — each one hands its result to the next. A fully worked example, with figures, follows step eight.

1. Download the right reports, not the order list

Start in Shop Manager, then Settings, then Options, then Download Data. Pull the monthly statement CSV for every month of the year — not the per-order export. Etsy reorganizes its interface and its help pages from time to time, so if that path has moved, search Etsy’s own Help Center (opens in new tab) for “download data” rather than working from a stale menu path. The order list is organized around individual sales; the statement is organized around settlement, which is the level everything else in this reconciliation operates at. Working from the wrong export is a common reason people give up on reconciling at all: the numbers just won’t line up, because they were never going to.

2. Write down Box 1a exactly as printed

Take the figure from Box 1a and record it as-is. Don’t net anything out of it yet, and don’t round it. Box 1a is gross payment volume — for an Etsy shop that generally means item price plus buyer-paid shipping and gift wrap — reported before a single fee, refund, or discount comes back out. Treat it as your starting point, not as a number that’s already close to right.

3. Total what you actually banked

Set the 1099-K aside for a moment and go to your bank statements. Add up every Etsy payout that actually reached your account during the year, reading the number from the bank side rather than from anything Etsy reports about itself. This is the other end of the bridge you’re building — an independently sourced figure that the remaining steps will connect back to Box 1a.

4. Subtract refunds and cancellations

Total every refund and cancellation you issued in the year, and subtract it from Box 1a. This step catches people because it feels like it should be automatic — surely a refunded sale doesn’t count as income? — but the form doesn’t work that way. The 1099-K reports the year’s gross as it was originally processed, refunds and all, so you have to remove them yourself.

5. Subtract every fee bucket separately

Pull each fee category off your monthly statements and subtract it as its own line: transaction fees, listing fees, payment processing fees, Etsy Ads and Offsite Ads fees, and shipping labels bought through Etsy. Check your own statement for what you were actually charged rather than assuming a rate — fee structures and what applies to a given shop can vary, and the only reliable source is the statement in front of you. Keep the buckets separate even though it’s more line items to track, because Schedule C wants them on different lines later, and un-combining a single lump-sum “fees” figure after the fact is a worse job than tracking them separately from the start.

6. Handle the sales tax

Sales tax that Etsy collected from a buyer and remitted to the state on your behalf never passed through your payout — it isn’t revenue, it isn’t an expense, and it isn’t yours to account for either way. Etsy operates as a marketplace facilitator in the states that require it, and generally excludes that collected tax from Box 1a. Generally isn’t always, though, and other payment processors handle this differently — check what your own 1099-K states it covers before assuming the tax line is already handled. If your form turns out to include remitted sales tax inside its gross figure, don’t skip the step: subtract that tax as its own named row in the bridge, exactly like a fee bucket, so the reconciliation still closes and the reason is on the page.

7. Do the timing cut

This is a recurring reason a reconciliation refuses to close. A sale made on December 29 can be reported on that year’s 1099-K but not settle into your bank account until January 3 of the next year — meaning it’s on one year’s form and the following year’s bank statement. You have to move it in both directions:

• Pull out sales you made this year that weren’t paid out until January of next year.
• Pull in sales you made last year that weren’t paid out until January of this year.

Do both, not just one. Doing only the first leaves you thinking the second half of the gap is an error somewhere else.

8. Read the residual and decide

After all seven prior steps, compare what’s left of Box 1a to what you actually banked. A difference of a few dollars is rounding across a year of transactions — note it and move on. For a bigger gap you need a line you’re willing to stop at, and that line is a working tolerance you choose, not an IRS rule or an accounting standard. The band we use in the workbook is: under 0.5% of reported gross, treat it as clean and move on; between 0.5% and roughly 2%, note what you think it is and keep the working, but don’t hold up the filing over it; past roughly 2%, trace it before you file. Set your own band if you prefer — just set it before you start, so you aren’t deciding where the line goes after you’ve already seen the number.

When a residual does need tracing, it’s almost always one of a small number of causes: a month of statements you never downloaded, a refund that didn’t make it into your log, a fee bucket you left at zero, or a payout that crossed the year end and got missed in step seven.

Once the reconciliation closes, keep it with that year’s tax file. The point of doing this work isn’t just to arrive at a clean number today — it’s that the next time you, a preparer, or anyone else needs to know why your bank deposits and your 1099-K don’t match, the answer is already written down.

The bridge, worked end to end

Illustrative figures, not a real shop — the point is the shape, not the numbers:

The fee buckets stay on separate rows for the reason step five gives: they land on different Schedule C lines later, so a single combined figure only has to be pulled apart again. The sales-tax row is $0 here and still earns its place — writing the zero is how you show step six was done rather than forgotten.

At 0.14% this one closes. Had the residual come out at $900 — over 2% of a $42,000 gross — the next move is step seven, not a new spreadsheet.

One thing the bottom line is not: “Expected in the bank” is not a figure you copy onto a tax return. It’s the proof that your gross reconciles to your deposits. On a Schedule C the top of the form still takes a gross figure — gross receipts on Line 1, returns and allowances on Line 2, the net of the two on Line 3 — and your fees come off further down as expenses, where they belong. Deducting the fees here and again as expenses would count them twice.

What to hand a preparer

A tax preparer doesn’t need your whole spreadsheet history. They need the finished bridge: Box 1a, each subtraction named and totaled, the timing cut shown in both directions, and the residual. Handed that, a preparer can usually see in a minute that the numbers reconcile — handed just the 1099-K and a bank statement that don’t match, they have to reconstruct the same eight steps themselves, which costs you time either in their hours or in back-and-forth.

One handling note: your 1099-K carries your Social Security number or EIN, and your bank statements carry your account numbers. Send them the way your preparer asks you to — a client portal, not an email attachment — and redact or mask those identifiers on anything you share more widely. The reconciliation itself is just arithmetic and doesn’t need them.

Doing this by hand versus not

Nothing above requires anything more than a spreadsheet and patience — every step is arithmetic against your own statements. What gets tedious is doing it every year from scratch: rebuilding the fee categories, re-deriving which Schedule C line each one belongs on, and re-checking the timing cut against a fresh set of December and January statements.

The Sales-Tax & 1099-K Reconciliation Workbook runs this exact bridge — Box 1a down to expected deposits, every fee bucket itemized and mapped to its Schedule C line, the timing cut built in, and a dashboard that shows the residual and whether it’s clean or worth tracing. It covers the marketplace side of Schedule C; cost of goods, materials, home office and mileage are not in it, so bring those from wherever you already track them. It’s built for this one job, and it’s a file you own rather than a subscription you renew every filing season.

If you’d rather weigh that against a live system that watches your accounts all year, an owned workbook against monthly bookkeeping software lays out what each one is genuinely better at.