Report this item to Etsy

Reseller Year-End Tax Kit 2026 | Inventory Count Sheet, Cost of Goods Sold, 1099-K Reconciliation for Online Sellers | Excel & Google Sheets

NowPrice:$3.49

Original Price: $6.98

Loading

50% off

•

Sale ends on November 20

Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Designed by MFASZ
  • Digital download
  • Digital file type(s): 1 PDF, 2 other files

Reseller year-end kit: inventory count sheet, cost of goods sold (Schedule C Part III) and 1099-K vs. platform vs. bank reconciliation. Excel + Sheets.

WHAT YOU GET (instant digital download)
- Inventory Count (500 rows): SKU, description, category, location, condition, quantity, unit cost, extended cost and value used, with an optional lower-of-cost-or-market column; prints as a count sheet
- Purchases & Costs: month-by-month inventory purchases, freight in, items taken for personal use, labor, materials and other costs (Schedule C lines 36-39)
- COGS: Schedule C Part III lines 33-42 (2025 numbering) with checks for line 35 vs. last year’s line 41, ending inventory above line 40 and missing unit costs, plus a gross profit and margin snapshot
- Platform Recon: one column each for Etsy, eBay, Amazon, Poshmark, Mercari, Shopify and two spares: 1099-K boxes 1a, 3 and 4, the platform’s annual report, expected vs. reported payouts, bank deposits with year-end timing items, a 1099-K walk and the Schedule C amounts (lines 1, 2, 8, 10, 27b)
- Sales Tax: marketplace-remitted vs. self-collected tax by platform and a log of your own state filings with what is still owed
- Year-End Checklist (19 tasks), one-page Summary and Reseller Rules (1099-K facts from irs.gov, COGS, counting, sales tax, records), plus a PDF guide

HOW IT WORKS
1. Download the files from your Etsy purchase page right after checkout.
2. Open the .xlsx in Excel, or upload it to Google Drive and open with Google Sheets. No macros, nothing to install.
3. Start on the "Start here" tab, then type in the yellow cells. Grey cells are formulas and recalculate for you. The workbook comes in two copies: an Example with sample entries marked "Sample — delete" so you can see how it works, and a blank copy for you.

WHO IT IS FOR
Resellers and online sellers on Etsy, eBay, Amazon, Poshmark, Mercari or their own Shopify store who hold inventory and need year-end numbers for Schedule C. Pairs with MFA’s Online Seller Bookkeeping Sheet; also works on its own.

DETAILS
Cash-basis view: gross receipts = item sales + shipping charged; sales tax collected is kept out of income; platform fees go to line 10, ads to line 8, shipping labels to line 27b. Works alone or as an add-on to MFA’s Online Seller Bookkeeping Sheet. Two copies: Example (a sample reseller on five platforms, entries marked "Sample — delete") and blank.

Important: you supply the numbers from your own platform reports, 1099-Ks and bank statements; report names and layouts differ by platform. Inventory valuation methods and damaged-goods rules: confirm with your preparer. Schedule C line numbers follow the 2025 form.

Last reviewed Oct. 23, 2026. Uses 2026 IRS figures with sources listed in the workbook.

General information, not tax, legal or accounting advice. MFA is not affiliated with the IRS, Etsy, eBay, Amazon, Poshmark, Mercari or Shopify.

Want your shop’s books closed and your Schedule C prepared? MFA provides bookkeeping and tax preparation for online sellers. Visit mfa-advisory.com or call (347) 205-4468.

This is a digital product: no physical item will be shipped. Because files are delivered instantly, all sales are final. If a file won't open, message us and we'll fix it.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 23, 2026