Skip to content
Handmade Shop Inventory cover: a sample sheet with products listed, pieces on hand and stock value at cost and a column chart, beside the Dashboard tab

Handmade Shop Inventory

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Style
Bold
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

Makers who sell handmade goods through an online shop or a market stall use this sheet to keep count of finished pieces. The Products tab holds each item along with its SKU, category, on-hand count, make-again level, cost to make, shop price, margin and stock value. The Dashboard totals the range, splits the stock by category and shows how many products need a new batch.

Update the On hand column after every batch and every sale, so the Status column can flag a product once it reaches its make-again level. Set that level to roughly a week of sales for each product, which leaves time to finish a batch before the shelf runs bare. When you change a price, read the Margin column first, because a small rise in the cost to make can shrink it quickly.

Useful for

  • Tracking finished stock across a handmade jewelry or candle range
  • Deciding which products go into the next batch
  • Checking the cost of stock before setting shop prices

What's included

  • 3 tabs: Dashboard, Products, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Products: 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 Products 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

Where does the cost to make a product come from?

Add up the materials, packaging and the share of tools or power used for one finished piece, then enter that total in the Cost to make column. Include any per-sale fees the platform charges if you want the margin to show what you keep.

What number should I use for Make again at?

Start with roughly one week of sales for that product. If a batch takes several days to make, add the sales you expect during those days, so the next batch begins before the shelf runs out.

Can this sheet record my sales too?

It tracks the stock you hold. To log a sale, subtract it from On hand on the same day. For a full sales history, keep a separate order list and copy the weekly totals into the On hand column.

  • #inventory
  • #etsy-shop-inventory
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More inventory templates

See all 19

Also in Business operations

All business operations templates
Get this template

Preparing your template…