- Category
- Consumables
- Current quantity
- 4
- Minimum quantity
- 3
- Storage location
- Break room
- Order status
- Not set
- Assignee
- Not set
TemplatesWork & projects · Inventory tracker
Inventory and supplies
When you count supplies and stock for an office, shop or club and reorder anything that drops below its minimum
What's inside · Table 3 · Checklist 3
Preview · a new document starts like this
Inventory and supplies
- Review date
- Not set
- Assignee
- Not set
- Monthly supplies budget
- Not set
Change the inventory list to your items and set a minimum quantity for each.
Inventory list
One line per item. When the current quantity drops below the minimum, set the order status to ‘Need to order’.
Inventory list
| Item | Category | Current quantity | Minimum quantity | Storage location | Order status | Assignee |
|---|---|---|---|---|---|---|
| Wet wipes | Consumables | 4 | 3 | Break room | Not set | Not set |
| Bottled water | Food & beverages | 10 | 6 | Break room | Not set | Not set |
| Copy paper | Office supplies | 3 | 2 | Storage shelf 1 | Not set | Not set |
| Printer toner | Office supplies | 1 | 1 | Drawer by the printer | Not set | Not set |
- Category
- Food & beverages
- Current quantity
- 10
- Minimum quantity
- 6
- Storage location
- Break room
- Order status
- Not set
- Assignee
- Not set
- Category
- Office supplies
- Current quantity
- 3
- Minimum quantity
- 2
- Storage location
- Storage shelf 1
- Order status
- Not set
- Assignee
- Not set
- Category
- Office supplies
- Current quantity
- 1
- Minimum quantity
- 1
- Storage location
- Drawer by the printer
- Order status
- Not set
- Assignee
- Not set
Order log
Add a line for each order and check it off when it arrives. Delete the example line before you use it.
| DateDate | Item | QuantityNumber | AmountNumber | ReceivedCheckbox |
|---|---|---|---|---|
| Empty | (Example) Copy paper | 5 | Empty | Unchecked |
- Date
- Empty
- Item
- (Example) Copy paper
- Quantity
- 5
- Amount
- Empty
- Received
- Unchecked
Check schedule
Decide how often to count each category.
| Category | FrequencyLabels | AssigneeAssignee | Last checkDate |
|---|---|---|---|
| Consumables | Weekly | Empty | Empty |
| Office supplies | Monthly | Empty | Empty |
| Equipment | Quarterly | Empty | Empty |
- Category
- Consumables
- Frequency
- Weekly
- Assignee
- Empty
- Last check
- Empty
- Category
- Office supplies
- Frequency
- Monthly
- Assignee
- Empty
- Last check
- Empty
- Category
- Equipment
- Frequency
- Quarterly
- Assignee
- Empty
- Last check
- Empty
☐
Set a minimum quantity for each item.
☐
Deleted the example line in the order log.
☐
Set a check schedule and owner for each category.