Free template

Free ABC analysis template

Free ABC inventory analysis spreadsheet.

ABC analysis ranks products by how much money moves through them. A items are the few that make up most of your value, C items are the long tail. Enter units and cost, sort by value, and the sheet assigns the class.

Download the free template (.xlsx)

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

What's in the template

ABC tab

SKU, Product, Units sold (12 months), Unit cost, Annual value, Share of total, Cumulative share, Class

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. Enter 12 months of units sold and the unit cost for each SKU.
  2. Sort the whole table by annual value, largest first. The cumulative share needs this order.
  3. Read the class: A up to 80 percent of value, B to 95 percent, C the rest.
  4. Count A items most often and give them the most safety stock.
  5. Look at C items for dead stock you can discount or drop.

The math

Annual value = units × unit cost
A = top 80% of value, B = next 15%, C = last 5%

Want to check one product quickly? Use the free ABC analysis explained.

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

Why do I have to sort first?

Cumulative share adds up rows from the top, so the class is only right when the biggest values are at the top.

Are 80/95 the right cut-offs?

They're the common default. Change the 0.8 and 0.95 in the Class column if you want a smaller A group.

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