How to Keep an Office Supply Inventory: A Practical Guide
Every office has a cupboard, drawer, or storeroom full of supplies, paper, toner, pens, cleaning products, printer cartridges. Without a list, you discover you’re out of something at the worst possible moment, or you order three boxes of something you already had sitting on a shelf. An Office Supply Inventory Sheet is that list: one place that shows what you stock, how much you have, and when it’s time to reorder.
It works best for consumables, things that get used up and replaced. It is not for equipment you keep for years (that’s what the Asset Register is for), and it’s not for IT kit like laptops and phones (that’s the IT Asset Tag List). Keep this sheet focused on the things you buy over and over.
When to Use This
Start an inventory sheet as soon as buying supplies becomes a recurring task rather than a one-off errand, typically once you have more than a desk drawer full. The person who does the ordering needs it most, but anyone who takes items from the store should be able to read it.
Use it to answer three questions: what do we have, how much is left, and what needs ordering this week. If you’re guessing at any of those, the sheet isn’t doing its job. It also gives you spending visibility, add up a quarter’s worth of orders and you’ll quickly spot the items that are quietly eating your budget, which is the first step to negotiating better prices or switching brands.
How to Fill It Out
Section 1: Item details. List every consumable you keep in stock. Give each item a clear, specific name, “A4 copy paper 80gsm” beats “paper”, and “black toner cartridge for HP LaserJet Pro” beats “toner”. Add a category (stationery, cleaning, kitchen, printer consumables) so the list stays scannable as it grows, and set a unit of measure for each item. Pick one unit per item and stick to it, boxes, reams, bottles, packs. Mixing units (“2 boxes” in one row, “48 rolls” in another) makes the quantities meaningless.
Section 2: Current stock. Record how much you have right now of each item. Do a proper physical count when you first set up the sheet, don’t copy figures from old order records, which rarely match reality. Note the date of the count on the sheet so anyone reading it knows how fresh the numbers are. From then on, subtract what gets taken and add what gets delivered.
Section 3: Minimum and reorder levels. For each item, set a minimum level, the point at which you must place an order. Base it on two things: how fast you use the item, and how long your supplier takes to deliver. If you use one toner cartridge a month and delivery takes two weeks, your minimum should be at least one, preferably two. This is the most valuable column on the sheet; without it, reordering is guesswork and you’ll swing between stockouts and over-ordering.
Section 4: Storage location. Note where each item is kept, “storeroom shelf B”, “kitchen cupboard”. This sounds trivial until someone new takes over ordering and spends an hour hunting for the spare cartridges. If you store the same item in two places, list both, and note which location is the backup.
Section 5: Cost and supplier. Record the unit cost and your usual supplier for each item. You don’t need full accounting detail, just enough to compare prices when a supplier raises theirs, and to estimate the total value of stock on hand. Update the costs when prices change; stale costs give you a false picture of what the supplies budget is really buying.
Common Mistakes
1. Never updating it. The classic failure: the sheet is perfect the day it’s made and fiction within a month. Every item taken from the store and every delivery received must change the numbers. If updating feels like too much work, simplify the sheet rather than abandoning it, a short list that’s current beats a detailed one that’s wrong.
2. No minimum levels. A list of current quantities without reorder points is just a snapshot. It tells you what you have today but never tells you to act. Set the minimums, then check the sheet on a fixed day each week for anything at or below them, and place one consolidated order.
3. Inconsistent units. Counting paper in reams one week and sheets the next, or mixing “bottles” and “litres” for cleaning products, quietly corrupts the whole sheet. Choose the unit when you set the item up and never change it mid-year.
4. One person owns everything. If only the office manager knows the sheet exists, supplies get taken without being recorded and the counts drift. Put the sheet where the people who take items can see it, and make updating it part of the routine rather than a favour, a simple sign-out note next to the store works.
Who Needs to Sign Off
The office manager or administrator owns the sheet day to day, they set it up, keep it current, and place the orders. The budget holder (often that person’s line manager, or finance) should approve the minimum levels and any bulk purchases, since those commit spending. If supplies are shared across departments, agree in advance who can request new items be added to the list, so the sheet doesn’t become a free-for-all.
How Often to Review and Update
Update the quantities every time stock moves in or out. Do a full physical count monthly for fast-moving items (paper, toner, kitchen supplies) and quarterly for everything else, then reconcile the sheet against what you actually find. Review the minimum levels twice a year, usage patterns change, suppliers change, and a reorder point set two years ago is probably wrong by now.
Download the free Office Supply Inventory Sheet template.