Beauty Inventory Unit Counts: Reconcile Eaches, Packs, and Cases

A beauty inventory spreadsheet can be mathematically correct and still describe the wrong quantity. One team counts bottles, another records retail packs, and the warehouse reports master cases. If all three columns are simply labeled “units,” a buyer may evaluate a different quantity from the one that will actually leave the building.

Before requesting offers, build a quantity bridge between the physical stock and the commercial selling unit. This is a counting exercise, not a product quality assessment. Correct arithmetic does not make damaged, restricted, or unresolved inventory eligible for sale.

Define the unit that a buyer is purchasing

Start with the smallest complete selling unit represented by each manifest line. It might be one individually packaged moisturizer, a sealed two-pack of body wash, or a boxed skincare kit sold as one item. Write that definition in plain language beside the SKU rather than relying on a unit-of-measure abbreviation alone.

A retail two-pack is not necessarily two separately saleable bottles. Individual containers may lack packaging or labeling needed for the intended route. Likewise, a kit containing several products remains one complete kit unless an appropriate, separately reviewed disposition allows its components to be sold individually. Do not inflate the offer quantity by counting both the set and its contents.

Build a conversion ladder from physical stock

For every SKU and packaging configuration, record the number of selling units per inner carton and inner cartons per master case. If there is no inner carton, mark that level as not applicable. Record full cases and loose selling units separately, then calculate the total in the defined selling unit.

For an illustrative arithmetic example, suppose a line contains 18 full master cases, with four inner cartons per case and six individually saleable items per inner carton. That represents 432 items. If the same line also has 11 verified loose items, the physical total is 443. These figures are only a counting illustration, not a real inventory offer.

• State the selling-unit definition and its identifying SKU.
• Record the observed pack configuration, not a remembered standard.
• Show full cases, partial cases, and loose units independently.
• Keep the conversion calculation visible instead of pasting only its result.

Separate configurations that share a product name

Older and newer packaging can contain different case quantities while displaying a similar product description. A warehouse may also hold promotional multipacks beside ordinary retail units. Do not apply one conversion factor to every carton with the same brand or product name.

Create separate manifest lines where the selling unit or case configuration differs. Use a configuration identifier that the warehouse can find on the stock or its location record. Preserve existing batch, condition, and date distinctions; quantity reconciliation should not erase the information already needed for buyer review.

Check partial cases without pretending they are full

Open cartons require an explicit count or an honestly labeled estimate pending inspection. A handwritten “12” might describe the original pack size rather than the remaining contents. If a count has not been checked, retain that uncertainty and identify who will resolve it before a final release quantity is agreed.

Keep non-offered stock out of the available total. Samples removed for review, units on hold, incomplete packs, and stock committed elsewhere need their own reconciliation entries. A useful bridge shows physical counted stock, excluded quantities with reasons, and the resulting quantity proposed for sale. Never make an unexplained adjustment simply to match an accounting balance.

Align the offer, invoice basis, and warehouse instruction

Once the count is reconciled, check that the commercial documents use the same denominator. A price per master case is different from a price per individual item, even when the grand total looks plausible. Specify whether freight dimensions and weights describe a case or a pallet, without using either as a substitute for the item count.

Ask the commercial owner and warehouse contact to review the same version of the manifest. Record the count date, responsible person, conversion basis, and any unresolved exceptions. If stock changes before pickup, issue a revised version and reconcile the difference rather than silently overwriting the agreed quantity.

Release a quantity that can be checked again

The final release sheet should let another person reproduce the count using the case identifiers, loose-unit entries, and stated conversions. Retain both the physical handling quantities and the commercial selling-unit total. That gives the buyer and warehouse a shared basis for investigating a discrepancy without guessing what “units” meant.

Share your reconciled beauty inventory with Offcos, including pack configurations, loose quantities, exclusions, and any checks still outstanding.