Free Excel download β’ Edit online β’ Save & share with Drive β’ Export to PDF
An Inventory Control Sheet is a structured tracking form that records the quantity, movement, and value of every stock item a business holds at a given location. It captures opening balances, goods received, goods issued, and closing balances across a defined period, alongside reorder thresholds and unit valuations. Businesses use it to know exactly what they have on hand at any moment, identify when to reorder, and reconcile physical counts against recorded quantities to catch discrepancies before they become costly.
Without a maintained inventory control sheet, stockouts and over-ordering happen by instinct rather than by data β and both are expensive. A stockout costs a retail sale or halts a production run; excess stock ties up cash and storage space. The sheet also provides the audit trail that accountants need to calculate accurate cost of goods sold and closing inventory values at year-end. Businesses that rely on informal counts or memory consistently underestimate shrinkage, miss supplier short-shipments, and carry phantom stock that shows on paper but not on the shelf. This template gives you a ready-to-use starting point in minutes, structured to cover every field that matters for day-to-day stock control without requiring dedicated inventory software.
| If your situation is⦠| Use this template |
|---|---|
| Tracking raw materials consumed during manufacturing | Raw Materials Inventory Sheet |
| Conducting a periodic full physical count of all stock | Physical Inventory Count Sheet |
| Logging finished goods ready for sale or shipment | Finished Goods Inventory Log |
| Tracking consumable office or maintenance supplies | Office Supply Inventory Sheet |
| Managing equipment and fixed-asset records | Asset Register |
| Recording stock movements between warehouse locations | Stock Transfer Log |
| Valuing closing inventory for year-end financial statements | Inventory Valuation Sheet |
Why it matters: Copying a prior period's closing balance without counting creates a false baseline. Any existing discrepancy is locked in and grows with each subsequent period.
Fix: Conduct a physical count at the start of every new tracking period and confirm the opening balance matches the count before recording any transactions.
Why it matters: Recording receipts in cases and issues in individual units without converting distorts the closing balance, triggering false stockouts or phantom surplus.
Fix: Choose one unit of measure per item at setup and enforce it for every entry. Add a conversion note to the item row if the supplier delivers in a different unit.
Why it matters: Unrecorded samples, staff consumption, or testing quantities accumulate quickly. A busy retail location can lose several percentage points of margin to unlogged shrinkage over a quarter.
Fix: Create a standard process β a sign-out slip or a daily summary entry β for any non-sale removal of stock, no matter how small.
Why it matters: Using a price from six months ago overstates or understates inventory value on the balance sheet and produces inaccurate gross margin calculations.
Fix: Update unit costs whenever a new purchase order is confirmed and add the effective date of the price to the sheet so auditors can trace the source.
Enter each stock item's name, unique SKU code, and the unit of measure you will use consistently throughout the sheet. One row per distinct item or variant.
π‘ Pull your item list from your existing purchase orders or supplier price lists to ensure SKU codes match exactly.
Physically count stock on hand and enter the confirmed quantity as the opening balance. Date the count so the period is clear.
π‘ Do not carry forward a number from a previous sheet without a physical count β unverified balances compound errors over time.
Each time stock arrives, enter the quantity received, the date, and the purchase order or delivery note number in the receipts column.
π‘ Count goods against the delivery note at the point of receipt, not after they have been put away, to catch short shipments immediately.
Every time stock leaves the location β for a sale, production run, or transfer β log the quantity, date, and the relevant sales order or work order number.
π‘ For high-turnover items, batch-record issues at the end of each shift rather than in real time to keep the process manageable.
Set the closing balance as opening balance plus received minus issued. If using a spreadsheet version, lock this cell to a formula so it cannot be overridden manually.
π‘ Add a conditional highlight that flags any closing balance below the reorder point in red so action items are immediately visible.
Add the current unit cost for each item and multiply by the closing balance to get the total inventory value per line. Sum all lines for the period-end inventory value.
π‘ Update unit costs at least quarterly or whenever you receive a supplier price change, not just at year-end.
At the end of each period, physically count stock and compare it to the sheet's closing balance. Record any variances in the notes column with a reason and the name of the person who verified the count.
π‘ A variance above 2% of total inventory value warrants an investigation into the root cause before it is simply written off.
An inventory control sheet is a structured form used to track the quantity, movement, and value of stock items over a defined period. It records opening balances, goods received, goods issued, closing balances, and reorder thresholds for every item in a business's inventory. It is used by retailers, warehouses, manufacturers, and food-service operators to prevent stockouts and over-ordering.
At minimum: item name and SKU, unit of measure, opening balance, quantities received and issued with dates and reference numbers, closing balance, reorder point, reorder quantity, unit cost, total value, and a notes field for adjustments. Missing the reorder point column means the sheet tracks history but does not prompt action.
For high-turnover businesses β retail, food service, e-commerce β update the sheet every day or every shift. For lower-volume operations, a weekly update with a monthly physical count reconciliation is typically sufficient. The key rule is that no receipt or issue goes unrecorded for more than one business day.
An inventory control sheet records what you currently have and what has moved in or out. A purchase order is the document you send to a supplier to request new stock. The two work together: when the closing balance on the control sheet hits the reorder point, you raise a purchase order. The purchase order number is then referenced in the receipts column when the goods arrive.
For businesses with fewer than 50β100 SKUs and moderate transaction volumes, a well-maintained spreadsheet or Word-based sheet works reliably and costs nothing beyond the time to maintain it. Once you exceed roughly 200 SKUs, process multiple daily receipts and shipments, or need real-time integration with sales channels, dedicated inventory management software becomes more practical than a manual sheet.
Multiply your average daily usage by your supplier's lead time in days, then add a safety stock buffer for demand variability. For example, if you use 20 units per day and your supplier takes 5 days to deliver, your base reorder point is 100 units. Adding a 2-day safety buffer raises it to 140 units. Review reorder points quarterly as usage patterns change.
Shrinkage is caused by theft, damage, spoilage, supplier short shipments, or recording errors. The control sheet identifies shrinkage when the calculated closing balance exceeds the physical count at reconciliation. Regular reconciliation β weekly rather than annual β catches discrepancies while the cause is still traceable and before losses accumulate to a material level.
FIFO (first in, first out) is the most common method and is required for perishable goods. It values closing inventory at the most recent costs, which typically reflects current market value most accurately. FIFO is also the method most widely accepted under IFRS and US GAAP. Whichever method you choose, apply it consistently across all items and document it for your accountant at year-end.
A purchase order is sent to a supplier to request new stock; it triggers a transaction. An inventory control sheet records what happens after that transaction β the receipt of goods and their subsequent movement. The two documents work in sequence: the control sheet signals when to raise a purchase order, and the purchase order number is logged on the sheet when goods arrive.
A stock requisition form is a request from a department or team to withdraw items from a central store. An inventory control sheet is the master record that logs those withdrawals along with all other movements. The requisition form generates the 'issued' entry on the control sheet.
An asset register tracks fixed assets β equipment, vehicles, furniture β over their useful lives, including depreciation. An inventory control sheet tracks consumable or resalable stock items that turn over regularly. Fixed assets belong on the asset register; stock items belong on the inventory control sheet.
An expense report records employee out-of-pocket spending for reimbursement. An inventory control sheet records the physical movement and valuation of stock. Where inventory is purchased and consumed without passing through a purchase order β office supplies, for example β both documents may be used in parallel, but they serve different control purposes.
Daily reconciliation of point-of-sale movements against physical shelf counts, with shrinkage tracking by category.
Perishable item tracking with expiry dates noted alongside quantities, supporting FIFO rotation and spoilage write-offs.
Raw material consumption per production run recorded against works orders, enabling accurate cost-of-goods-sold calculations.
Medical supply and consumable tracking with lot numbers and expiry dates recorded to meet regulatory traceability requirements.
| Path | Best for | Cost | Time |
|---|---|---|---|
| Use the template | Small businesses, retailers, and operators with up to 100β200 SKUs managing stock manually | Free | 15 minutes to set up; 5β15 minutes per day to maintain |
| Template + professional review | Businesses integrating the sheet with an accounting system or setting up customized reorder logic | $50β$200 (bookkeeper or operations consultant review) | 2β4 hours |
| Custom drafted | High-SKU operations, multi-location inventory, or businesses requiring ERP or WMS integration | $500β$3,000+ (inventory software setup or custom spreadsheet build) | 1β4 weeks |
This document is one of 3,000+ business & legal templates included in Business in a Box.
Access over 3,000+ business and legal templates for any business task, project or initiative.
Customize your ready-made business document template and save it in the cloud.
Share your files and folders with your team. Create a space of seamless collaboration.
"Fantastic value! I'm not sure how I'd do without it. It's worth its weight in gold and paid back for itself many times."
"I have been using Business in a Box for years. It has been the most useful source of templates I have encountered. I recommend it to anyone."
"It has been a life saver so many times I have lost count. Business in a Box has saved me so much time and as you know, time is money."
Stop downloading documents. Start operating with clarity. Business in a Box gives you the Business Operating System used by over 250,000 companies worldwide to structure, run, and grow their business.
Start freeΒ Β·Β No credit card required
