An inventory tag is a numbered slip that goes on a pile of stock during a physical count. The counter writes what it is, where it is, the lot, the unit and how many, and initials it. A second person checks and initials. The tag stays on the pile until its count has been entered. The tags do two things that a clipboard list can't. They show, at a glance down an aisle, what has been counted and what hasn't: a pile with no tag is a pile nobody did. And because they're numbered and issued from a register, every tag has to come back, so a missing number means a count that was written and lost, or a pile that was skipped. That's how a full count proves it was full. Below is what goes on a tag, how the register works, a count for a made-up granola maker, and a file with both.
The short version
- One tag for each item, lot and place.
- Numbered. Issued in blocks to teams, and every number accounted for.
- The counter counts and initials. A second person checks.
- The tag stays on the stock until the count is entered.
- Before you close the count, walk the building looking for anything untagged.
- TaroStack counts on a phone, by lot, and shows what each difference is worth. More below.
What goes on a tag
| Field | Why |
|---|---|
| Tag number | Pre-printed. The control |
| Location | Rack, bay, room: so the pile can be found for a recount |
| Item, and its code | What it is, in the words on your stock list |
| Lot or date | Two lots of one item are two tags |
| Unit | Case, sack, each. The usual cause of a wrong count is the wrong unit |
| Count | The number, written once, no overwriting |
| Counted by, and the time | Who, when |
| Checked by | The second person |
| On hold? | Held stock is counted, and flagged |
| Notes | Damaged, open, part case |
Two-part tags are common: one half stays on the stock, the other is torn off and goes to whoever enters the counts. With a single-part tag, enter from a walk with a tablet, or collect them at the end.
The register
| Tag | Issued to | Location | Item | Lot | Count | Returned? | Entered? |
|---|---|---|---|---|---|---|---|
| 1001 | Team A | Dry store, rack 1 | Rolled oats, 50 lb sack | L-25301 | 14 | Yes | Yes |
| 1002 | Team A | Dry store, rack 1 | Rolled oats, 50 lb sack | L-25322 | 6 | Yes | Yes |
| 1003 | Team A | Dry store, rack 2 | Sliced almonds, 25 lb case | 26-0412 | 9 | Yes | Yes |
| 1004 | Team A | Yes | Void | ||||
| 1005 | Team B | Finished goods, bay 1 | Maple pecan granola, case of 12 | MP-1106 | 42 | Yes | Yes |
| 1007 | Team B | Hold area | Honey almond granola, case of 12 | HA-1030 | 8 | Yes | Yes |
| 1008 | Team B | No |
Three rows there are the reason to keep a register.
1002: a second lot gets its own tag. Twenty sacks of oats in two lots is two piles and two tags. Add them later; don't merge them on the floor.
1004: void. A tag was spoiled. It comes back marked VOID and is logged. It isn't thrown away, because a number that simply disappears looks exactly like a lost count.
1008: missing. At the end, Team B had returned every tag but one. The search found it on a pallet in bay 2 that nobody had counted: the tag had been hung, the count never written. Without the register, that pallet would have been the $4,000.
Running a tagged count
| Step | Who | What |
|---|---|---|
| 1 Before | Count lead | Tidy. Stop receiving and shipping, or draw a line: what arrived before and after. Print tags. Split the building into areas |
| 2 Issue | Count lead | A block of numbers to each team, written in the register |
| 3 Count | Teams of two | One counts and writes, one checks. One tag a pile. Tag where it can be seen |
| 4 Walk | Count lead | Every aisle. Anything without a tag? Anything with two? |
| 5 Collect | Count lead | Every number back: used, void or unused. Chase the gaps |
| 6 Enter | Office | Each tag into the stock record. Tick it in the register |
| 7 Recount | A different person | The big differences, before anyone adjusts anything |
| 8 Close | Owner | Adjustments signed. Tags kept with the year's records |
Count blind. The team doesn't see what the books say. People who know the answer find it.
Recount before you adjust. In the example, the almonds were first counted as 8 cases and recounted as 9: a case had been behind a pillar. A difference is a question first.
Held stock. Count it. It's still yours. Flag it on the tag so it isn't treated as available.
A tagged count is for a full physical inventory: year end, a new system, a sale of the business. For the weekly count of your top twenty items, a count sheet is enough: see inventory count sheet example. The method in full is in how to count inventory, a written procedure in inventory SOP template, and what the count does to the year's figures in inventory turnover example.
Other tags
"Inventory tag" also gets used for two things that aren't count tags.
Bin or shelf tags: permanent labels saying what lives where, with the item code and sometimes the reorder level. Worth having. Ideas are in inventory labeling ideas.
Hold tags: a red tag on stock that mustn't be used or shipped, with the reason, the date and who put it there.
Get the template
Download the inventory tag template. A Tag register with the example count and blank rows, a Tag to print with the ten fields laid out, and a read-me. Print the tag four to a page on card, number them by hand or with a numbering stamp, and punch a hole for string. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
A tagged count is a day's work for the whole team, which is why it happens once a year. For the other 364 days the stock record drifts, and the year-end adjustment arrives as one large, unexplained number. The tags prove the count was complete. They can't tell you when in the year the almonds went missing, or why.
How TaroStack does it
TaroStack makes counting small enough to do often.
Counting on a phone, tablet or printed sheet, by item and lot, with no signal needed in the store room.
It suggests what to count first: what it would cost to be wrong, times how much has happened since anyone looked. Twenty items this week, not everything once a year.
The count shows what a difference is worth before you post it, so the big ones get a recount.
Every correction is a record of who, when and why, and can be undone. The adjustment isn't one number at year end.
Holds and quarantine are counted and kept out of what you can sell.
Barcodes: the phone's camera or a scanner reads a lot label, so the item and lot aren't written by hand.
| The job | Paper tags | In TaroStack |
|---|---|---|
| Was everything counted | The register | What's been counted, and when |
| The lot on each pile | Written by hand | Scanned from the lot label |
| Big differences | Found at entry | Shown, in dollars, at the count |
| Why stock was adjusted | One number in December | Each correction, with its reason |
Counting, lots and holds are on every plan, from $9.99 a month. The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
