Artist Tax Spreadsheet 2026 | Art Business Bookkeeping, Etsy & Art Fair Sales Tracker, 1099-K, Mileage, Expenses | Excel Google Sheets

Artist tax and sales tracker for 2026: cost of goods per piece, Etsy, art fair and commission sales, fees, 1099-K check, mileage. Excel and Google Sheets.

WHAT YOU GET (instant digital download)
- Pieces & Costs (300 rows): materials, framing, printing and packaging per original, print run or commission; unit cost, units sold, cost of goods sold and cost still on hand
- Sales Log (500 rows): date, piece, channel (Etsy, own website, art fair, commission, gallery / consignment), paid via, quantity, price, shipping, sales tax collected, who remits the tax (marketplace or you), refunds
- Fees & Expenses (400 rows): platform selling fees, payment processing, ads, postage, software, supplies, insurance and more, each mapped to a Schedule C line
- Art Fairs (50 shows): booth, jury, display, lodging, parking and other costs, with sales, sales tax and mileage pulled in and the net from each show
- 1099-K Recon: per processor (Etsy Payments, Square, PayPal, Stripe / Shopify, Venmo): 1099-K boxes, your records, the federal over-$20,000-and-over-200-transactions check, and gross to refunds, fees, labels and marketplace tax to net, compared with bank deposits
- Mileage (300 trips) at 72.5 cents (Jan.-Jun.) and 76 cents (Jul.-Dec.) by trip date, and a Home Studio worksheet (simplified method, $5 per sq ft, 300 sq ft cap, profit limit)
- Quarterly Set-Aside by IRS period with the 2026 due dates, a Schedule C Summary (lines 1-31 with an SE tax estimate) and Artist Rules with official sources, 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
Painters, illustrators, printmakers, ceramicists and other artists who sell on Etsy, on their own site, at art fairs, through galleries or by commission, and want clean numbers for Schedule C. Built by an accounting firm in New Jersey.

DETAILS
Cash-basis view: gross receipts = item sales + shipping charged; sales tax collected is kept out of income. Cost of goods sold uses the cost of each unit sold. Schedule C line numbers follow the 2025 form (the latest released). SE tax estimate: 15.3% on 92.35% of net profit, Social Security part capped at the $184,500 wage base. Two copies: Example (a sample New Jersey illustrator, entries marked "Sample — delete") and blank.

Important: you enter the numbers from your own statements and receipts; the tracker organizes them and estimates, it does not file your return. Sales tax registration and what is taxable differ by state. Ask your preparer about inventory methods and which costs go where.

Last reviewed Oct. 25, 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, Square, PayPal, Stripe, Shopify or Venmo.

Want help with your art business taxes? MFA works with artists on bookkeeping, Schedule C returns and quarterly estimates. 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.