Salon Inventory Spreadsheet: Setup and Stock Control

How-to basics · Updated November 21, 2026

A salon inventory spreadsheet is a simple way to track what products you have, where they are, and when to reorder. Start with one row per product and location, using columns for SKU, product name, category, unit, quantity on hand, minimum stock, and reorder quantity; add a transaction log if you need a history of receipts and usage.

What a salon inventory spreadsheet tracks

A useful sheet covers both retail products sold to clients and professional products used to provide services. These are different kinds of stock: retail items leave the salon through a sale, while back-bar products are consumed during appointments. Separating the categories helps you understand where stock goes and avoid treating a product used at the shampoo station as a retail sale.

Depending on the salon, inventory may include shampoo, conditioner, color, developer, styling products, gloves, foils, disposables, and retail merchandise. You do not need to record every small supply if the time required would outweigh the benefit. Begin with items that are expensive, frequently used, easy to run out of, or important to keep available for appointments.

A spreadsheet is a recordkeeping tool, not an inventory system that automatically knows what is in a cupboard. Its figures are only as reliable as the transactions entered and the physical counts used to correct them. That distinction matters: a spreadsheet can show that a product should be in stock while a damaged, misplaced, or unrecorded item has made the actual count different.

Choose a workbook structure

For a small salon, a single inventory worksheet may be enough. Use one row for each product at each storage location. If the same shampoo is kept in retail shelving and in the back room, separate rows or location records prevent one area’s count from concealing a shortage in another.

A more controlled workbook can use separate tabs for the inventory list, stock movements, and suppliers. Keep the inventory list as the current summary. In the movement log, record each receipt, sale, product use, return, damage, or count correction on its own line, with a date and a person responsible. This creates a trail for investigating differences instead of relying on someone to remember why a quantity changed.

  • Inventory: the product details, location, current quantity, minimum level, and reorder information.
  • Movements: dated increases and decreases in stock, including the reason and quantity.
  • Suppliers: vendor name, contact details, product or brand supplied, and ordering notes.

Keep the workbook uncomplicated at first. A salon with a few dozen frequently monitored items may not need the same level of detail as a multi-location business with many brands and storage areas. Add fields only when they answer a practical question, such as “Which supplier carries this?” or “How much is available for color services?”

Recommended columns for the inventory list

Use clear headings in the first row and keep each column to one type of information. A practical starting layout is:

  • SKU or product code: a unique identifier. If there is no supplier code, assign a consistent internal code rather than using the product name as the only identifier.
  • Product name and brand: enough detail to distinguish similar sizes, shades, or formulations.
  • Category: for example, retail, back-bar, color, disposable, or cleaning supply.
  • Location: such as retail shelf, color room, or stock cupboard.
  • Unit: bottle, box, tube, roll, or another countable unit. Keep the unit consistent for that item.
  • Quantity on hand: the current counted amount.
  • Minimum stock: the threshold at which staff should consider ordering.
  • Reorder quantity or target: the amount to buy or the desired quantity after replenishment.
  • Supplier, last counted date, and notes: useful context for ordering and checking the record.

Be precise about what a quantity means. If a box contains 100 foils, decide whether the inventory unit is one box or one foil and use that choice consistently. For liquids, a salon might count unopened containers rather than estimate partial bottles; if partial contents matter, define a repeatable measurement method. Mixing cases, bottles, and individual units in the same quantity column makes totals misleading.

Build the sheet in Excel

In Microsoft Excel for Microsoft 365 on Windows, enter the headings and sample products, select the range, and choose Insert > Table. Confirm that the table has headers. Excel tables provide filter buttons and extend formatting and formulas as rows are added. Give the table a descriptive name using Table Design > Table Name, such as Inventory. On Mac, the Insert tab also includes the Table command; the exact ribbon arrangement can differ slightly. In Excel for the web, use Insert > Table.

Freeze the headings so they remain visible while scrolling: choose View > Freeze Panes > Freeze Top Row. Use filters to show one category, location, or supplier at a time. Apply consistent date formats to count dates and avoid merging cells in the data range, because merged cells can interfere with sorting and filtering.

Use data validation where it prevents predictable entry errors. For example, a drop-down list for category or location can keep “Back bar,” “Back-bar,” and “Backbar” from becoming three separate filter values. In Excel, select the cells and choose Data > Data Validation. A simple list is usually easier to maintain than a complicated workbook with many dependent lists.

Calculate stock and reorder signals

For a basic inventory sheet, put Opening stock in column F, Received in G, Used or sold in H, Adjustments in I, and On hand in J. Enter a positive adjustment for stock added during a correction and a negative adjustment for stock removed. With those headings and the first product on row 2, enter this in J2:

=F2+G2-H2+I2

For example, opening stock of 8 bottles, 6 received, 5 used, and an adjustment of -1 gives 8 + 6 – 5 – 1 = 8 bottles on hand. Copy the formula down the column, or enter it in an Excel table so the calculated column can fill as new rows are added. If you record every movement in a separate log, use that log as the source of receipts and usage rather than entering the same activity in two places.

To flag products at or below their minimum, assume On hand is in J and Minimum stock is in K. In L2, enter:

=IF(J2<=K2,"REORDER","OK")

If the quantity is 4 and the minimum is 4, the result is REORDER; if the quantity is 5, the result is OK. The threshold is a prompt to review stock, not an automatic order. Lead time, upcoming appointments, supplier availability, and the salon’s purchasing process can affect what should actually be ordered.

If column M is a target quantity after replenishment, and current stock is in J, put this in N2 to calculate the number of units needed to reach that target:

=MAX(0,M2-J2)

With a target of 12 and 8 on hand, the result is 4. If stock is already above the target, the result is 0 rather than a negative order quantity. Use the same unit for the target and on-hand figure; a target of 12 cases cannot be compared meaningfully with a count of individual bottles.

Set reorder levels that fit salon operations

A minimum level should reflect how quickly an item is used and how long it typically takes to obtain, rather than being an arbitrary number copied across every product. A fast-moving color essential with a long supplier lead time may need a higher buffer than a slow-selling retail item that is readily available. Review the level after changes in service demand, supplier delivery patterns, or product range.

Start by observing usage and ordering history. For each priority item, consider:

  • How often it is used or sold, including seasonal changes.
  • How many days ordering and delivery usually take.
  • Whether a substitute is acceptable if the item runs out.
  • Whether the item has a limited shelf life or is likely to become obsolete.
  • Whether the salon has space and budget to hold additional stock.

A reorder alert does not mean every flagged product must be purchased immediately. Check what is already on order, confirm the physical count, and consider whether the product is still part of the salon’s range. This review helps prevent duplicate orders and reduces the risk of accumulating slow-moving products.

Use a repeatable stocktake routine

Choose a regular counting schedule that staff can follow. High-use or high-value items may merit more frequent checks than supplies that change slowly. The right interval depends on the salon’s volume and the consequences of running short; a weekly spot check of essential color products, for example, can complement a broader monthly count.

  1. Pick a consistent time, ideally when stock is not being moved for appointments or deliveries.
  2. Count products by location and unit, and compare the physical count with the sheet.
  3. Investigate large differences: check recent receipts, sales, service use, returns, damage, and whether another location holds the item.
  4. Record a dated adjustment and its reason rather than silently replacing the old quantity.
  5. Review items below their minimum and confirm whether an order is already pending.

For a busy salon, assign responsibility for updating receipts and usage so the process does not depend on everyone remembering to edit the workbook. A movement log is particularly useful when several staff members handle stock. Keep the log factual and brief: a date, SKU, transaction type, quantity, location, and initials may be enough for a small operation.

Common spreadsheet problems and safeguards

The most common issue is stale data. A delivery arrives, a product is opened, or a retail item is sold, but the sheet is not updated. A clear rule about who records each event and when is more useful than adding extra formulas. Another frequent problem is duplicate product rows caused by slightly different names. Unique product codes and consistent naming make searches and counts more reliable.

Keep a backup copy in an approved, access-controlled location and avoid sharing a public link that allows anyone to edit the file. Protecting formulas from accidental edits can help, but worksheet protection is not a substitute for secure storage or a backup. Do not put client records, payment details, or other unnecessary personal information in an inventory workbook.

Inventory records also do not replace product labels, manufacturer directions, or safety data sheets. Follow applicable handling, storage, and disposal instructions for salon products, especially chemical products. Use the spreadsheet to identify and locate stock, not as a substitute for safety information or staff training.

Spreadsheet or salon software?

A spreadsheet can be a sensible starting point when the product list is manageable, one person can maintain it, and the salon mainly needs counts and reorder reminders. It is flexible and familiar, but staff must enter changes consistently. A spreadsheet generally will not know about a retail sale or a service use unless the relevant information is entered or connected to another system.

Salon management or point-of-sale software may be a better fit when inventory needs to connect with retail transactions, multiple locations, purchase orders, or reporting. Compare the actual features and costs of available products rather than assuming every system tracks back-bar usage automatically. Some tools may require manual adjustments or setup to reflect how the salon consumes professional supplies.

A hybrid approach is also possible: use a point-of-sale system for retail sales and a separate, simple count sheet for professional products. The key is to decide which record is authoritative for each kind of stock. Maintaining two competing lists with different quantities creates confusion rather than extra control.

Frequently Asked Questions

What should a salon inventory spreadsheet include?
At minimum, include a unique product code, product name, category, location, unit, quantity on hand, minimum stock, and supplier. Add movement dates and reasons if you want to investigate how quantities change.

How do I calculate salon stock on hand in Excel?
For a simple sheet, add opening stock and receipts, then subtract usage or sales and account for adjustments. Make sure every quantity uses the same unit, and update the source figures when stock moves.

Should retail and back-bar products be tracked separately?
Usually, yes. They leave inventory in different ways: retail products are sold, while back-bar products are used during services. Separate categories or locations make each type easier to count and review.

How often should a salon count inventory?
There is no single interval for every salon. Count fast-moving or essential items more often, and set a broader routine that staff can maintain. Adjust the schedule if repeated discrepancies or stockouts show that checks are too infrequent.

Can a spreadsheet automatically track products used in appointments?
Not on its own. Someone must enter the usage, or the workbook must receive data from a connected system. For many salons, recording usage for selected high-priority products is more practical than trying to log every small amount consumed.

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.