Track Consumable Stock Without Counting Every Item Every Day

The last roll of packing labels disappears halfway through the afternoon. There were no label sales at the till, and yesterday's stock figure looked comfortable.

Someone took a roll to the dispatch bench. Someone else opened another for a returns job. Both were doing ordinary work. Neither action reached the stock record.

This is the awkward part of consumable inventory: supplies can leave the shelf without creating a sale. Packing bags, cleaning products and materials used during a workshop need a different recording habit from products sold to customers.

I would start by fixing that habit, not by asking someone to count the entire cupboard more often.

The missing record between two counts

In an inventory-management discussion, an operator setting up supplies and equipment asked: "Is there an easier way than to just keep counting what supplies are left over?"

The difficulty was not identifying the items. It was finding out what staff had used. That is one business's account, not evidence that every shop has the same problem. It is a useful distinction: a stock list tells you what you hold, but it cannot tell you about movements nobody records.

A separate, older salon discussion about supplies inventory describes supplies moving into treatment rooms and a paper-based recording process. The setting differs from a shop, but the operating question is recognisable. What happens between replenishing the shelf and checking it again?

The goal is a balance you can explain, supported by physical checks. It is not an impressive-looking number that everybody quietly distrusts.

Start with ten supplies worth knowing about

Do one baseline count for a small, deliberately chosen list. Ten items is a useful starting exercise, not a universal rule.

Choose supplies whose absence interrupts work, whose cost makes unexplained use worth investigating, or whose delivery time makes a last-minute order difficult. A specialist packing insert may deserve closer attention than an inexpensive, easily replaced cleaning cloth.

Keep reusable equipment separate. A label printer has a location and may need maintenance. A roll of labels has a quantity that falls as it is used. Treating both as the same kind of stock creates unnecessary confusion.

For each supply, agree four things:

• The item and unit being counted.
• The place where the quantity is held.
• The event that changes the balance.
• The person or role responsible for recording that event.

Record the baseline date. If the cupboard contains 200 bags on Monday, a delivery entered on Tuesday must not also be included in Monday's opening balance.

Choose a unit staff can use consistently

"We have six" means very little if one person means six boxes and another means six individual rolls.

Pick a practical base unit for each item. Bags might be counted individually. Sealed label rolls might be counted by roll. A liquid used in a service may need a volume measurement, provided the team has a realistic way to record it.

Write pack sizes explicitly. If a delivery is five packs of 20 bags, the receipt is 100 bags when bags are your base unit. Keep the supplier's pack description too, so someone can verify the conversion later. Check a changed pack size rather than assuming every delivery remains identical.

Sortly's consumables guide describes quantity or volume tracking with a chosen unit and reductions as supplies are used. That is one vendor's supported approach, not evidence that every inventory tool has the same unit handling.

If your chosen software cannot support the unit you need, maintain an explicit conversion or usage record. Do not hide the mismatch behind a quantity field.

Decide whether you record an issue or actual use

Taking supplies out of a stockroom and consuming them are not always the same event.

Suppose 80 bags move to the packing station. If 30 remain unused there, the business has not consumed all 80. It has changed where the bags are held.

There are two workable approaches:

Track both locations. Record the movement from stockroom to packing station as a transfer. Record use against the packing station's balance. This gives a fuller stock picture but requires another location to be maintained.

Track stockroom issues only. Record supplies leaving the stockroom as issued, and use that balance to replenish the stockroom. This is simpler, but it does not measure actual business-wide consumption. Count what remains in work areas before interpreting issues as usage.

Choose one approach deliberately. Do not subtract an issue and then subtract use again from the same balance. Do not quietly call everything issued "waste" either.

That distinction matters when deciding whether you need to order more. Supplies sitting beside the packing bench may still be usable, even though they have left the cupboard.

Worked example: 300 bags become 245, not 165

This is an illustrative record, not a customer result or a demonstration of a particular software feature. It assumes both the stockroom and packing station are tracked.

The closing total is 300 minus 50 used minus five damaged: 245 bags.

The transfers change the locations, not the business-wide total. If someone also deducted the original 80-bag transfer as consumption, the record would incorrectly show 165.

A useful movement log includes the date, item, quantity, unit, movement type, origin or destination, recorder and a short explanation when needed. "Adjustment minus 80" is much harder to interpret later than "transfer to packing station, 80 bags".

Make recording fit the work

A process that requires a busy assistant to stop and log every bag may be accurate on paper and abandoned by Friday.

Choose a sensible recording point. For packing supplies, that could be replenishing the bench and returning unused packs. For a workshop, it could be preparing a measured batch for a session and recording the remaining usable material afterwards.

Keep estimates visible as estimates. If a recipe, printer or job sheet suggests how much material was used, compare that estimate with physical stock before treating it as exact consumption. Do not assume your POS automatically deducts workshop ingredients or materials.

For cheap, predictable supplies, a marked minimum level and scheduled replenishment round may be enough. More valuable or critical items may justify more frequent recording. The control should be proportionate to the consequence of getting it wrong.

Give the update a clear owner without turning every discrepancy into an accusation. A missed receipt, wrong pack size and genuine damage can all produce an unexplained shortage. Check the process before blaming the person who last touched the shelf.

If identification is still unreliable, start with the separate barcode inventory guide. A scan can help identify the right item, but it does not decide whether the action was a transfer, use or correction.

Keep counts as a check, not the whole system

Select a rotating sample for physical checks. Count critical or fast-moving supplies more often, and adjust the schedule when discrepancies persist. There is no honest universal promise that every business can safely stop daily checks.

When the shelf and record disagree, first look for a missed receipt, unrecorded issue, incorrect unit, duplicate entry or stock left in another work area. Record the investigation and the correction. Repeatedly overwriting the balance without an explanation removes the clues you need to improve it.

Shopify's inventory-adjustment documentation distinguishes setting a quantity from adjusting it by a change, with reason and history controls. The practical lesson is to know whether you are entering a new counted balance or recording a movement. Do not use those interchangeably.

A spreadsheet can support a small operation if responsibility, concurrent updates and corrections are clear. Software becomes more useful as the team, locations and number of movements grow. Either way, a reliable record needs a recording habit.

Replenish from a balance you understand

A low-stock alert can be working correctly and still arrive too late if staff use never reaches the recorded balance.

Before ordering, check usable stock across the relevant locations, deliveries already on their way, expected use before the next delivery and an appropriate buffer. Keep damaged stock separate from stock available for work.

For the buying decision itself, use the reorder, hold or discount guide. This article solves the earlier problem: making the consumption record useful enough to inform that decision.

What I would check in an EzyCarto demonstration

At EzyCarto, our inventory capabilities include stock visibility, movement logs, barcode-supported product management and configurable low-stock alerts. Those can support a clearer stock picture, but general inventory features are not proof of automatic consumable deductions, unit conversion or bills of materials.

I would ask to work through one supply, two locations, a receipt, a transfer, actual use and a correction. Establish which actions the configured system supports, who can record them and whether an additional usage log is needed. Check the final balance against the example rather than accepting a feature name as the answer.

You can review EzyCarto's inventory capabilities, or request a demonstration using one of your own supplies workflows. Bring its pack size, where staff keep it and how they use it. That is enough to make the discussion concrete.

Start small. A record the team maintains for ten important supplies is more useful than a perfect template nobody updates.