If you sell physical products, or keep supplies on hand for a service business, a year-end inventory count tells you what you actually own, what is not selling, and what you need to order before the new year gets busy. It does not have to take a whole weekend. With a little prep, most small shops can count in an afternoon.

This guide is for makers, Etsy and craft sellers, small retail and market vendors, and service businesses that stock supplies, like cleaners and lawn crews.

This is practical record-keeping guidance, not tax or accounting advice. Whether and how you have to report inventory depends on your business and where you live. Ask a tax professional, and use the count to give them clean numbers.

Step 1: Pick the Day and Freeze the Shelf

Choose one day close to the end of the year, ideally after your last big holiday shipping deadline. Before you start:

  • Ship or set aside every order that is already paid for, so you do not count stock that is no longer yours.
  • Pause restocking for the day, so nothing new lands mid-count.
  • Write the count date at the top of your sheet. Every number you record is "as of" that day.

Step 2: Set Up One Simple Count Sheet

Make one list with these columns:

  • Item name (and SKU or size/color, if you use them)
  • Location (shelf, bin, closet, garage)
  • Quantity counted
  • Cost per unit (what you paid, not what you sell it for)
  • Total cost (quantity × cost per unit)

The Small Business Inventory Tracker already has these columns, plus reorder levels, so you can use the same file for the count and for the rest of the year.

Step 3: Count Finished Goods, Then Supplies

Work one shelf or bin at a time, left to right, and do not jump around. Count finished products first, since they are usually the bulk of your value, then raw materials and supplies: blanks, fabric, jars, labels, packaging, and shipping boxes.

Tip: Put a sticky note on each shelf when it is done. If you get interrupted, you know exactly where to pick up, and nothing gets counted twice.

For small parts you have hundreds of, weigh a known batch (say, 50 pieces) and estimate the rest by weight instead of counting one by one.

Step 4: Put a Cost on It

Fill in the cost per unit from your receipts or supplier invoices. For handmade items, use the materials cost for one finished piece. If you already worked that out for pricing, the Handmade Product Pricing Calculator has the number, and our post on how to price what you sell online explains how to find it.

Add up the total cost column. That is the value of what is sitting on your shelves. Record it with the date next to your yearly totals; the Small Business Bookkeeping Spreadsheet has room for it, and our weekly bookkeeping routine keeps the rest of your records current.

Step 5: Sort Into Keep, Push, and Clear

With everything in front of you, sort your items into three groups:

  1. Keep: steady sellers. Set a reorder point, the quantity where you order more, so you do not run out in a busy month.
  2. Push: items that sell slowly but still make money. Give them better photos, a bundle, or a featured spot.
  3. Clear: items that have not sold in a long time. A sale, a bundle, or donating them frees up space and cash for what does sell.

Your Year-End Inventory Checklist

  • Count date chosen, after the last holiday shipping deadline
  • Paid orders shipped or set aside
  • One count sheet with item, location, quantity, and cost
  • Finished goods counted shelf by shelf
  • Supplies and packaging counted
  • Total inventory cost recorded with the date
  • Every item sorted into keep, push, or clear
  • Reorder points set for steady sellers

Make Next Year's Count Easier

If you update your tracker every time you restock or make a batch, next year's count becomes a quick check instead of a full recount. If your shop is growing to the point where someone else helps with stock and orders, The Boss Blueprint is Timothy Kaiserlik's practical book on leading and running a small business.

Closing tip: Put your count day on the calendar now, right after your last holiday shipping deadline, and set up the count sheet this week so it is ready to go.

  • inventory count
  • year-end inventory
  • small business inventory
  • Etsy seller
  • handmade business
  • reorder points
  • record keeping

From Tim’s bookshelf

Go deeper with a book

More like this