Salon Inventory Spreadsheet: How to Create One Step by Step

How-to basics · Updated November 21, 2026

Create a salon inventory spreadsheet in Microsoft Excel by listing each product on a separate row, recording its stock movements, and calculating the quantity on hand with a formula. Add reorder levels, supplier details, and a regular counting routine so the sheet shows what to replenish and helps prevent shortages or over-ordering.

Why a salon needs an inventory system

A salon may stock retail products for clients, professional-use products for services, and everyday supplies such as gloves or foil. These items have different purposes and usage patterns, but they all tie up money and take space. A basic spreadsheet gives the salon a consistent record of what it has, where items come from, and when stock needs attention.

The spreadsheet is useful only if its quantities stay current. It does not automatically know what was used during a color service or sold at reception. Staff have to record purchases, sales, product use, returns, and damage. For a small salon, a shared workbook and a short weekly count may be enough. A larger or busier salon may need point-of-sale or inventory software that can track transactions automatically.

Keep inventory quantities separate from financial or tax records. A stock-value column can help with an internal estimate, but it is not a substitute for accounting advice or the salon’s formal bookkeeping system.

Decide what to track before building the sheet

Start by deciding which items belong in the workbook. Include products the salon wants to count and replenish, not every object in the building. Separate retail stock from back-bar supplies if they are managed differently. For example, a shampoo bottle sold to a client and a large salon-use container may have the same brand name but different package sizes, costs, and reorder needs.

Choose a consistent counting unit for each product. Count individual retail bottles as bottles, gloves as boxes, and color as tubes or another unit the salon can reliably measure. Avoid mixing units for the same item: an on-hand quantity of “3” is not meaningful if one person means bottles and another means cases.

  • Retail products: shampoos, conditioners, styling products, and other items sold to clients.
  • Service products: color, developer, treatments, and other supplies used during appointments.
  • Operating supplies: capes, gloves, towels, disinfectant, and disposable items, if the salon wants to monitor them.

Set up useful columns and product records

Use one row per distinct product and package size. A unique SKU or internal product code makes similar products easier to distinguish; if a supplier has no SKU, the salon can assign a consistent code. Avoid relying on product names alone, since color variants and different bottle sizes can look similar in a long list.

A practical starting layout is shown below. Put these headings in row 1, then enter one product per row beginning in row 2:

  • A: SKU — a unique identifier.
  • B: Product — brand, name, shade or variant, and size as needed.
  • C: Category — retail, back bar, or supplies.
  • D: Unit — bottle, tube, box, or another consistent count unit.
  • E: Opening stock — counted quantity at the start of the tracking period.
  • F: Received — quantity received during the period.
  • G: Used or sold — quantity that left usable stock through services or sales.
  • H: Damaged or discarded — unusable quantity removed from stock.
  • I: On hand — calculated available quantity.
  • J: Reorder at — the minimum level that should trigger a replenishment review.
  • K: Unit cost — the salon’s recorded cost per counting unit.
  • L: Stock value — an internal estimate based on on-hand quantity and unit cost.
  • M: Supplier — supplier name or purchasing source.

Other useful fields include storage location, last-count date, product status, and notes. Add them when they solve a real tracking need. Too many required fields can make updates slow and discourage staff from entering transactions.

Create the workbook in Excel

  1. Open a blank workbook and rename the first worksheet Inventory. Add the column headings in the first row.
  2. Enter known products and complete an initial physical count. Record the count in Opening stock, not in a formula column. If tracking begins on a particular date, note that date in a cell above the table or in a separate notes sheet.
  3. Select the headings and product rows, then choose Insert > Table. Confirm that My table has headers is selected. Tables make it easier to filter and sort records, and they generally extend when new rows are added.
  4. Use clear number formats: quantities as numbers, costs and values as currency, and dates as dates. Freeze the heading row with View > Freeze Panes > Freeze Top Row so the headings remain visible while scrolling.
  5. Save the workbook in a location the staff who maintain it can access. If several people need to update it, agree on one shared copy rather than letting separate versions circulate by email.

In Excel for Microsoft 365 on Windows, the ribbon paths above apply. Excel for Mac also has Insert > Table and a Freeze Panes command on the View tab, though the ribbon layout can differ by window size and update. Excel for the web has similar table tools but may display commands in a more compact ribbon.

Calculate stock on hand and estimated value

Use stock-movement columns to calculate a current quantity rather than typing over the result. In the layout above, the on-hand quantity equals opening stock plus receipts, minus product used or sold, minus damaged or discarded units.

With Opening stock in E, Received in F, Used or sold in G, Damaged or discarded in H, and the first product on row 2, enter this in I2: =E2+F2-G2-H2. For example, 12 opening units plus 6 received, minus 5 used or sold and 1 discarded, returns 12 units on hand. Copy the formula down the column; in an Excel table, the formula may fill the calculated column automatically.

For a simple internal estimate, multiply on-hand quantity by unit cost. With On hand in I and Unit cost in K, and the first product on row 2, enter this in L2: =I2*K2. If the example product has 12 units on hand at a recorded unit cost of $8.50, the result is $102.00. This is a basic estimate, not a complete accounting valuation method.

These formulas work best when the sheet represents a clear period. If the salon updates only the movement totals and never resets Opening stock, the totals will eventually be misleading. One straightforward approach is to use a new count period each month: count actual stock, enter it as the new opening quantity, and clear or replace the previous period’s receipts and usage. A transaction log is more auditable, but it takes more discipline to maintain.

Add reorder alerts and practical data controls

A reorder level is a prompt to review stock, not a universal rule that a purchase must be made. Set it based on how quickly the product is used, supplier delivery time, storage space, and the consequences of running out. A frequently used developer may need a larger buffer than a slow-moving retail item. Review the threshold after usage patterns or supplier lead times change.

To make low stock easier to spot, select the on-hand data cells and choose Home > Conditional Formatting > Highlight Cells Rules > Less Than. Enter a fixed comparison value only if one threshold applies to every selected item. Because products usually have different reorder levels, a better option is to use Home > Conditional Formatting > New Rule and create a formula-based rule for the selected on-hand range. For example, if the first selected cell is I2 and the reorder level is J2, the rule formula is =I2<=J2. Apply the rule to the corresponding on-hand cells; Excel adjusts the row references for each row. Choose a noticeable format that remains readable when printed.

For categories or units, you can use dropdown lists to reduce inconsistent entries such as “Backbar,” “Back bar,” and “Salon use.” Put approved choices in a small list on a separate worksheet, select the cells to control, then choose Data > Data Validation and set Allow to List. Keep the choices short and maintain the source list when categories change. Data validation helps standardize entries, but it does not replace checking that the selected value is correct.

Keep the count accurate with a routine

Assign responsibility for updating the workbook. A workable process might have the person receiving deliveries enter received quantities, the front desk record retail sales, and a designated staff member record service-product usage or perform a count. The exact roles depend on the salon; the important point is that every stock change has a clear owner and is entered promptly.

  • When an order arrives, compare it with the delivery and record only what was actually received. Note short shipments or damaged goods rather than counting them as usable stock.
  • When items are sold, used, transferred, or discarded, record the quantity in the appropriate movement field or transaction log.
  • Count physical stock on a regular schedule. A salon might check frequently used products weekly and less active items less often, then adjust the schedule based on discrepancies and business needs.
  • Investigate differences between the physical count and the sheet. Check for unrecorded service use, unentered sales, misplaced products, returns, or data-entry mistakes before changing a quantity.

A spreadsheet with a single total movement number is simple, but it does not show when or why each change happened. If accountability matters, add a separate Transactions sheet with date, SKU, movement type, quantity, and staff initials. Keep each movement on its own row and use consistent positive quantities with a movement type such as Received, Used, Sold, or Discarded. This makes it easier to review history, though calculating balances from a log requires more setup than the basic sheet.

Common mistakes and when to use another tool

A frequent mistake is treating a spreadsheet as an automatic inventory system. Unless it is connected to a point-of-sale or other data source, Excel cannot infer that a bottle was sold or that product was used during a service. Another common problem is counting a multi-pack as one unit in one place and several units in another. Write the unit beside the product and train everyone who handles counts to use it consistently.

Do not delete a product row just because it is temporarily out of stock; keeping the record preserves its SKU, supplier, and reorder details. Mark discontinued items inactive or move them to an archive sheet. Also avoid sorting only one column, which can separate quantities from their product records. Sort or filter the entire Excel table so each row stays together.

A workbook is a reasonable alternative to dedicated software when the product list is manageable, updates are infrequent, and one or a few people can maintain it. Consider inventory or salon-management software when the salon needs sales to reduce stock automatically, multiple locations, staff-level transaction history, barcode scanning, purchase-order workflows, or reliable integration with a point-of-sale system. Compare the cost and setup effort with the time spent maintaining the workbook; the best option depends on the salon’s volume and processes.

Frequently Asked Questions

What should a salon inventory spreadsheet include?
A useful starter sheet includes a unique product identifier, product name and size, category, counting unit, opening quantity, receipts, usage or sales, damaged stock, on-hand quantity, reorder level, unit cost, and supplier. Add fields only when someone will keep them up to date.

How often should a salon count inventory?
There is no single schedule that suits every salon. Count fast-moving or costly items more often, and count slower-moving supplies less often if discrepancies remain low. Use count results to adjust the schedule rather than assuming a monthly or weekly count is automatically sufficient.

Can Excel automatically reduce stock when a product is sold?
Not in a basic manually maintained workbook. Someone must enter the sale or usage, or the workbook must be connected to a system that supplies those transactions. A salon’s point-of-sale or inventory software may automate this, depending on its features and setup.

Should retail and back-bar products be on separate sheets?
They can be on one sheet if each row has a clear category and staff can filter the table. Separate sheets may help when the groups have different owners, counting methods, or reorder processes, but duplicate records can create confusion. Choose the structure that makes updates easiest and most consistent.

How do I avoid losing or overwriting inventory data?
Keep one shared workbook in an approved storage location, limit editing access to people who need it, and save periodic backup copies. If you use a transaction log, retain past entries rather than replacing them with a new total. Before major structural changes, save a separate copy so the original records remain available.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.