Skip to content
The title slide and first slides of the Handmade Seller Tax Tracker template

Handmade Seller Tax Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Minimal
Difficulty
Beginner
Updated
November 15, 2026

Every slide (5)

Overview

Makers who sell candles, pottery, textiles or jewelry at fairs and online use this handmade seller tax tracker to keep one honest record of the shop. The Sales tab lists each sale with its place, price, shipping charged and fees taken. The Costs tab holds materials, packaging, booth fees and tools with a receipt flag. The Dashboard adds sales, fees and costs into profit before tax and charts which places sold best.

Record fair sales the same evening, because cash is the easiest income to forget. Match each marketplace payout to the fees column so the two agree. Treat the profit figure as a planning number, not a tax return. Share the totals with a tax professional, who can tell you how to handle stock on hand, sales tax and the home space you use.

Useful for

  • Compare craft fair income with online shop income
  • Total materials, packaging and booth fees for the year
  • Hand a clean summary to a tax preparer

What's included

  • 4 tabs: Dashboard, Sales, Costs, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Sales: a table
  • Costs: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Sales tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What records should a craft seller keep for taxes?

Keep a record of every sale, the fees taken, and a receipt for each purchase. A sale list, a cost list and saved receipts cover most of what a preparer asks for. Add payout statements from each platform so totals can be matched.

How do I track craft fair sales paid in cash?

Add a row for each fair day or each batch of sales, with the item, quantity and price. Count the cash box when the fair closes, then check it against the rows so nothing is missed.

Should shipping charged to buyers count as income?

Postage a buyer pays you is usually part of what you received, but treatment can depend on how you account for it. This sheet keeps it in its own column so you can ask a tax professional how to report it.

  • #tax-tracker
  • #handmade-seller-tax-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…