Free template

Free inventory count sheet

Free stock take template for Excel and Google Sheets.

Use it for a full stock take or a quick cycle count. Paste in what Shopify says you have, count the shelf, and the sheet shows the difference in units, percent and dollars, so you know which counts to re-check before you adjust stock.

Download the free template (.xlsx)

Works in Excel, Google Sheets (File, Import, Upload) and Apple Numbers. No email required.

What's in the template

Count tab

SKU, Product, Location / bin, System qty, Counted qty, Variance (units), Variance %, Unit cost, Variance value, Counted by, Notes

White cells are inputs. Green cells are formulas, so don't type over them. Sample rows are included so you can see how it works. Delete them and add your own.

How to use it

  1. Export your inventory from Shopify admin (Products, Export) and paste SKU, title and quantity into the sheet.
  2. Pause receiving and, if you can, fulfillment while you count, so the numbers don't move.
  3. Count each bin and type the counted quantity. Leave a cell blank until it's counted.
  4. Sort by variance value. Recount anything large before changing stock in Shopify.
  5. Update Shopify to the counted numbers and save the sheet as your count record.

The math

Variance = counted − system
Variance value = variance × unit cost

Want to check one product quickly? Use the free inventory how-to guides.

Skip the spreadsheet

Spreadsheets work until you have more products than time. SteadyShelf connects to your Shopify store, works out daily sales for every product, shows what to reorder and when for each supplier, and drafts the purchase order for you. $29/month flat, unlimited products and suppliers, 30-day free trial.

SteadyShelf is launching on the Shopify App Store. Join early access to get the install link first.

More free templates

All free inventory templates · Free purchase order generator

FAQ

How often should I count inventory?

Most small stores do a full count once or twice a year and cycle count their best-sellers monthly. Fast movers drift the most, so count them more often.

What's an acceptable variance?

Many stores aim for under 1 to 2 percent of units across the count. Any single SKU with a big dollar variance is worth a recount regardless of the percentage.

Let SteadyShelf do this math for every SKU

Order-by dates per supplier, seasonal forecasts and draft POs for your Shopify store. $29/month after a 30-day free trial.

Get early access