The Gross column in the payments sales CSV
This is the file Etsy points to for checking the form's total.
Etsy's method
- Shop Manager, Settings, Options.
- Download Data tab, Orders.
- CSV Type: Etsy Payments Sales. Pick the Year and leave Month unselected.
- Download CSV.
- Total the Gross column for the year. Compare with box 1a.
Month by month
To check boxes 5a to 5l, group the Gross column by the month of each row's date. The tool does this if you drop the file in with your statements: it finds the column named Gross or Gross Amount and a date column, and shows the monthly totals next to the statement figures.
Etsy's help page names the file and the Gross column but does not list the other columns, so the tool looks only for those two and ignores the rest.
Statements or payments CSV?
| Payments sales CSV | Monthly statements | |
|---|---|---|
| Downloads for a year | 1 | 12 |
| Named by Etsy for the 1099-K | Yes | No |
| Shows fees, ads, labels, refunds, deposits | No | Yes |
| Explains the gap to your bank | No | Yes |
Sources, read 10 November 2026: Etsy Help, How Is the Total on My 1099-K Calculated?; Etsy Help, What Do I Need to Know About My 1099-K Tax Form?; Etsy Help, How to Download a Spreadsheet of Your Sold Transactions.
Check your own form. Drop your statement CSVs and type the box amounts. Read in your browser, nothing uploaded.
Open the tie-out tool