Rowtie Not affiliated with Etsy. Not tax advice.

Rowtie / How to reconcile a 1099-K with monthly statements

How to reconcile a 1099-K with monthly statements

Reconcile means showing, month by month, that the form and your own records add up to the same number.

By hand

  1. Get the form. Shop Manager, Finances, Legal and tax information, pick the tax year, Download 1099-K.
  2. Get the statements. Shop Manager, Finances, Monthly statements, View all monthly statements. Pick the year and month, select Generate CSV, and use the link in the email. Repeat for each month.
  3. For each month, add up the Amount of every row whose Type is Sale.
  4. Take off every row titled "Sales tax paid by buyer". Etsy says tax it collects from buyers is not on the form.
  5. Do not take off refunds, fees, ads or shipping labels. The form does not.
  6. Compare with the month's box. January is 5a, December is 5l. The twelve boxes add up to box 1a.

Etsy's own method uses a different file: the Etsy Payments Sales CSV (Settings, Options, Download Data), totalling its Gross column for the year. The tool accepts that file too and compares both.

There is no published specification for the statement file. The row names here are the ones the tool reads. A row with a name it does not know is listed as "not recognised" and left out of the gross, never guessed.

Sources, read 10 November 2026: Etsy Help, What Do I Need to Know About My 1099-K Tax Form?; Etsy Help, How Is the Total on My 1099-K Calculated?; Etsy Help, How to Calculate Your Etsy Payments Deposit Amount; Etsy Help, How to Download a Spreadsheet of Your Sold Transactions; IRS, Instructions for Form 1099-K (revision 12/2026 as shown on the page).

Or drop the files here

One drop takes all twelve. The browser does steps 3 to 6 and marks the months that do not tie.

1. Monthly statement CSVsNo statements yet
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
or drop all twelve here.
Monthly boxes 5a to 5l (for the month-by-month check)

Tip: paste all twelve amounts into January to fill the row. Labels such as 5a or Jan in the pasted text are read as the box, not the amount.

Statements are read in your browser. Nothing is uploaded.

Questions

Which months go in which box?

Boxes 5a to 5l are January to December in order. The IRS instructions say each holds the gross amount of reportable payment transactions for that month.

What if one month is off but the year matches?

Then the difference is timing between months: a sale dated one side of month-end on the statement and the other side on the form.

Related

Sent without your name or address. Do not include personal details.