Short answer: count packaging supplies in a declared unit at a declared location and time. Keep sealed packs, open packs, loose pieces and partly used rolls in separate fields. Convert only quantities whose conversion basis is known. Mark an uncounted or estimated amount explicitly, record any movement during the count, and send differences for review before treating the result as an approved stock figure.
This worksheet is for Australian ecommerce teams counting packaging they already hold. It is not an incoming-delivery check, a reorder calculation or a financial valuation. It does not require changing quantities in an online store while the physical count is being performed.
1. Decide what one row represents
Start each row with the item reference, variant or agreed specification and storage location. If two supplies have different pack quantities, dimensions or uses, keep them on different rows even when their names are similar. A combined entry such as "labels" is not a reliable comparison with a record for one particular label stock.
Write the counting unit beside both the observed amount and the reference amount. Pieces, packs, cartons and rolls describe different things. A quantity without a unit forces the reviewer to guess what the number means.
Shopify's stock-count guidance describes checking physically counted stock at a location against recorded quantities, with a review stage before adjustments. The paper worksheet here keeps observation and review separate. It does not assume a particular app or that every packing consumable is a sellable product in your store.
2. Set the count time and account for movement
Record when the count starts, which locations it covers and who is counting. Decide how the team will record material taken from or added to those locations during the exercise. Without a defined time and movement record, two correct observations can refer to different moments.
For a small packing area, assign a count sequence and make it clear which shelves or containers have already been checked. If packing continues, keep movements traceable to the affected row. Do not silently recount a location while another person is adding the same supplies to their total.
Use the business's normal process for coordinating the count. This worksheet does not tell a team to stop customer orders or disable checkout. It asks for a declared count boundary so the result can be interpreted.
3. Separate sealed packs from loose units
Use separate columns for sealed packs, the confirmed units per pack and individually counted loose units. Note how the pack quantity was established. Counting a sealed pack and assuming its contents is different from independently counting every piece inside it.
In a clearly hypothetical example, three packs with a confirmed quantity of 50 sleeves per pack plus 17 counted loose sleeves represent 167 sleeves. The calculation is 3 x 50 + 17. This is a worksheet example, not the pack size of a Boxy product. If the pack quantity is unresolved, preserve the observation as three packs and 17 loose sleeves; do not invent a combined piece total.
Keep opened packs identifiable so they are not counted once as a full pack and again as loose contents. If a bundle or carton contains mixed items, resolve the item rows rather than assigning one conversion factor to the whole container.
4. Keep partial rolls and estimates visible
A partly used tape or label roll is not automatically one full replacement roll. Record full rolls and partial rolls separately. State whether the reference figure is intended to count rolls, individual labels or another declared unit.
Do not infer remaining tape length or labels from the outside appearance alone. If your approved counting method uses an estimate, label the value as estimated and retain the method and date. Otherwise, leave the unknown remainder unresolved. Neither an unknown amount nor a shelf that has not been counted should be entered as a confirmed zero.
The label-roll measurement worksheet addresses physical fit fields. Those measurements are not a remaining-stock calculation. Similarly, a product's original stated pack quantity does not tell you how many units remain in an opened pack.
5. Separate observed stock from approved-use stock
Record supplies awaiting a condition check or other decision separately from supplies cleared for normal packing. Physical presence and approval for a particular use are separate observations. Keep the unresolved item reference and reason attached to the count.
Do not decide product suitability from this worksheet. Follow the relevant supplier instructions and the business's review process. Preserve what was actually observed, the extent of the check and the person responsible for the next decision.
If a delivery is still being received, do not quietly absorb it into a completed shelf count. The receiving record and the count's movement record should explain when it became part of the counted location.
A reusable packaging stocktake sheet
Use one row group per item and location. Keep evidence, observation, conversion and approval as separate fields.
| Field | Record | Review question |
|---|---|---|
| Item and location | Reference, specification, variant and shelf or container | Does the row describe the same item as the reference record? |
| Count boundary | Start and finish time, counter and locations included | Are movements during the count accounted for? |
| Sealed packs | Pack count, confirmed units per pack and evidence | Is the conversion basis confirmed rather than assumed? |
| Loose units | Individually counted pieces or contents of open packs | Have open packs been excluded from full-pack totals? |
| Rolls and estimates | Full rolls, partial rolls and separately labelled estimates | Are unknown values distinct from confirmed zero? |
| Difference and review | Same-unit reference, observation, recount and reviewer decision | Is any approved adjustment traceable to the evidence? |
Compare like with like before closing the count
Compare the same item, location, unit and time boundary. If one record is in packs and the observation is in pieces, resolve the conversion before calling the difference a shortage or surplus. Check movement records and accidental double counts before deciding what explains a mismatch.
Keep the first observation and any recount together. An amended result should identify what changed and who reviewed it. Follow the business's authorised approval process for any system adjustment; the counting sheet is evidence for that decision, not automatic permission to change a live quantity.
The packing-station checklist owns the wider bench organisation task. Use the current Boxy Packaging catalogue for an exact listing reference when relevant, while retaining the specification and pack unit associated with the supplies you actually hold. Do not substitute a new listing's pack size for an older stock record without checking.
