A Simple Weekly Inventory Routine for Fragrance Retailers
A weekly reconciliation worksheet for saleable stock, testers, reservations and discrepancies.
Published 2026-10-14 · Fragrentis editorial team
A weekly stock check is most useful when it explains differences, not merely produces a fresh total. A bottle can be received, sold, reserved, opened as a tester or damaged during the same week. If all of those events are treated as generic stock movement, the final number may look tidy while remaining hard to trust.
Use saleable units as the working count Give each product one consistent identifier and define the unit being counted. For a set, decide whether the record tracks complete sets or individual bottles; do not switch between the two midway through a count. Keep testers, damaged items and orders already reserved outside the available-to-sell figure.
Before counting, choose how to handle sales or receipts happening during the check. A brief pause or a clearly recorded cutoff can make reconciliation easier. Record the time and keep later movements visible. Otherwise a physical count and a system figure may refer to different moments without anyone realizing it.
Reconcile movements before changing the balance Use this simple worksheet: opening saleable count, receipts, sales, newly allocated testers, other adjustments, expected closing count and observed closing count. Add a reason and a record reference beside adjustments. Do not erase a difference merely by replacing the expected number with the observed one.
Invented example: opening stock is twelve, receipts add six, sales remove five and a new tester removes one. Expected saleable stock is 12 + 6 − 5 − 1 = 12. If the observed count is eleven, the unexplained difference is one. Check order reservations, receipt records and tester allocations before choosing the appropriate correction.
Turn findings into small actions Review items with a discrepancy, items near a chosen reorder point and items that have remained unchanged for several checks. Keep these categories separate. A discrepancy needs investigation; low available stock needs a purchasing decision; slow movement may need a clearer product explanation or an assortment review.
Finish by recording who completed the check and any action still open. Compare the same fields the following week so the routine becomes easier to review. Avoid treating one busy weekend as a stable demand forecast or one quiet week as proof that an item cannot sell. Consistent records help a small store make proportionate decisions. They also make a customer-facing stock promise easier to support with something more reliable than a quick glance at a shelf.
A Fragrentis editorial publication. Editorial policy and disclosure.