1099-K reconciliation template
One row per month, a column for the form and columns for your statements. The formulas work out the differences.
A plain CSV file with formulas, about 1 KB. It opens in Excel, Google Sheets and Numbers. No sign-up.
What is in it
| Column | You type | Formula |
|---|---|---|
| A, B: Month and Box | Nothing. January is 5a, December is 5l. | |
| C: Form 1099-K | The box amount for the month | Row 16 adds the twelve boxes |
| D: Statement Sale rows | The month's total of rows whose Type is Sale | |
| E: Sales tax paid by buyer | The month's total of those rows, as a positive number | |
| F: Statements gross | =D-E | |
| G: Difference | =C-F | |
| Row 17: Box 1a | Box 1a from the form | Compared with the twelve boxes and with the statements |
| Rows 21 to 28: gross to deposits | Refunds, fees, ads, labels and deposits for the year | What is left after them, and the gap to deposits |
How to fill it in
- Download the template and open it in Excel, Google Sheets or Numbers.
- Type boxes 5a to 5l from the form into the Form 1099-K column, and box 1a into the Year row.
- For each month, add up the Amount of the Sale rows on that month's statement and type the total.
- For each month, add up the rows titled "Sales tax paid by buyer" and type the total as a positive number.
- Read the Difference column. A month showing 0.00 ties to the cent.
Steps 3 and 4 follow the reason the tool uses: the IRS defines gross without taking off fees, refunded amounts or shipping amounts, and Etsy states that tax it collects from buyers is not reported on the form.
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.
Or skip the typing
The tie-out tool fills the same table from your twelve statement CSVs in one drop, in your browser. A filled-in year is shown in the worked example.
You may share the template and link to this page. For a site of your own there is also a free checker to embed.
Sources, read 10 November 2026: IRS, Instructions for Form 1099-K (revision 12/2026 as shown on the page); Etsy Help, What Do I Need to Know About My 1099-K Tax Form?.
Check your own form. Drop your statement CSVs and type the box amounts. Read in your browser, nothing uploaded.
Open the tie-out toolQuestions
Is the template free?
Yes. It is a plain CSV file with formulas. There is no sign-up and nothing to install.
Why CSV and not XLSX?
A CSV with formulas opens in Excel, Google Sheets and Numbers, and you can read it in a text editor before opening it. Save it in your spreadsheet's own format once you have typed your numbers.