An inventory and purchase order template gives you a consistent way to track stock and request replenishment. Use the inventory section to record what you have; use the purchase order section to tell a supplier what you are ordering, in what quantity, and where it should be delivered.
What an Inventory Record and Purchase Order Do
An inventory record describes items a business currently holds or manages. Depending on the operation, it may include products for sale, raw materials, packaging, spare parts, or supplies. The record helps answer practical questions: What is in stock? Where is it stored? When was it last counted? Does the quantity need checking or replenishing?
A purchase order (PO) is a document a buyer sends to a supplier to describe a proposed purchase. It typically identifies the buyer and supplier, lists the requested goods or services, and states quantities, prices, delivery details, and other agreed terms. A PO is not the same as an inventory count: it records an order, not proof that goods have arrived or been checked.
The two documents work best together but serve different moments in the process. Inventory helps identify a need; a PO communicates the request; receiving records what actually arrived; and the inventory record is then updated to reflect the accepted quantity. Keeping these stages distinct makes it easier to trace a mismatch instead of treating an order as stock before it is on hand.
How the Records Work Together
Consider a small shop that sells reusable bottles. Its inventory sheet shows 18 bottles on hand and a reorder point of 20. A staff member checks the count, confirms the shortfall is real, and prepares a PO for 36 bottles. The PO includes the item description and requested quantity. When the shipment arrives, the receiver compares the delivery with the order and records the quantity received. If all 36 are accepted, the inventory record can be updated from 18 to 54, with the receipt date and relevant reference noted.
If only 34 arrive, the records should not quietly treat the order as complete. The receiver can document 34 as received, note the two-unit difference, and follow up with the supplier according to the business’s usual process. The inventory count reflects what is physically accepted, while the PO and receiving notes preserve what was requested and what happened. This distinction is useful for returns, backorders, damaged items, and partial deliveries as well as simple stock control.
A template does not automatically calculate a reorder quantity or verify a supplier’s terms. It provides a repeatable structure for people to enter, review, and retain information. Any formulas added to a spreadsheet should be checked against the way the business counts and receives stock.
Inventory and Purchase Order Template
Copy the blank tables into a document or spreadsheet and add rows as needed. Use one inventory row per item and one PO line per distinct item or service. Leave fields blank when they do not apply, or mark them “N/A” so a reviewer can tell the field was considered.
| Blank Inventory Record | |||||||
|---|---|---|---|---|---|---|---|
| Item or SKU | Description | Storage location | Unit | Quantity on hand | Reorder point | Count date | Counted by |
| Blank Purchase Order | |
|---|---|
| PO number | |
| Order date | |
| Buyer name and contact | |
| Supplier name and contact | |
| Ship-to address | |
| Requested delivery date | |
| Payment or delivery terms | |
| Authorized by | |
| Item or SKU | Description | Quantity | Unit | Unit price | Line amount |
|---|---|---|---|---|---|
| Subtotal, shipping, tax or other applicable charges, and total | |||||
Sample — fictional details: Inventory row: RB-01 | Reusable bottle, blue | Shelf A2 | each | 18 | 20 | 2026-04-12 | Jamie Lee. PO: PO-1042, dated 2026-04-12, from North Shore Supply to Cedar Lane Goods, ship to 14 Sample Street, requested delivery 2026-04-26. Line: RB-01, reusable bottle, blue, 36 each. The names, address, dates, and quantities are illustrative only.
How to Fill In the Inventory Section
Choose a clear identifier for each stock item. It might be an internal SKU, a part number, or another label already used in the business. Avoid relying on a vague description such as “blue bottle” if several similar products exist. A useful description adds distinguishing details, such as size, model, material, or color, without replacing the identifier.
Record the unit consistently. “Each,” “box,” and “case” are not interchangeable if a case contains multiple pieces. If stock is counted in one unit but purchased in another, note the conversion clearly—for example, one case equals 12 individual units—so people do not mistakenly compare unlike quantities. A storage location can be a shelf, room, bin, or other locator that makes a physical count practical.
Quantity on hand should mean the quantity your process defines as available or physically present; make that definition clear if reserved, damaged, or quarantined items are handled separately. Record the count date and the person who performed it. The reorder point is a trigger for review, not necessarily the number to buy. A business may choose an order quantity based on supplier pack sizes, expected demand, lead time, storage capacity, or other operating requirements.
How to Prepare a Purchase Order
Assign each PO a unique number using a consistent sequence or naming method. The number makes it easier to discuss the order, match paperwork, and search records later. Include the order date and enough buyer and supplier contact information to identify the parties and resolve questions. Check that the ship-to address is the location that should receive the goods, not simply the buyer’s billing address.
Each line should describe one item or service, with its identifier, quantity, unit, and price if applicable. State the requested delivery date or delivery window when timing matters. Include any relevant instructions, such as a delivery location within a site or a reference the receiver will need. If the purchase has agreed payment, shipping, or other terms, record them accurately and consistently with the arrangement. A template should not be used to invent terms that have not been agreed.
Before sending, check arithmetic and compare the order against the request that prompted it. Confirm that the person approving the purchase has done so under the business’s internal process. Keep the final PO and any supplier confirmation together. When the delivery comes in, use a separate receiving record or notes to capture the date, quantity accepted, and any differences; do not change the original PO in a way that hides what was first ordered.
Choosing Fields and Setting Up the Template
A useful template is detailed enough to prevent ambiguity but not so complicated that staff avoid using it. Start with the fields needed to identify an item, count it, place an order, and check receipt. Add specialized fields only where they support a real workflow. For example, a business handling lots with different expiry dates may need a lot or batch field, while a simple office-supply list may not.
- For inventory: consider item identifier, clear description, unit, location, quantity, count date, and counter. Add reorder point or status only if someone will maintain and use it.
- For purchase orders: consider a unique number, date, supplier, buyer, delivery location, requested date, line descriptions, quantities, units, prices, and approval details appropriate to the process.
- For receiving: consider a receipt date, quantity received, condition or discrepancy note, and the related PO number. These fields can live on a separate log if combining them would make the PO hard to read.
- For shared use: label units and date formats plainly, protect formulas if a spreadsheet uses them, and define who can create, approve, and update records.
It can help to keep one controlled blank master and make working copies from it, rather than allowing multiple versions with different column names to circulate. If the template is printed, leave enough space for handwriting and make sure the table is readable on the chosen page size. For a spreadsheet, use one row per item or PO line and avoid merged cells in the working data area, because they can make sorting and filtering harder.
Common Problems and Ways to Prevent Them
One common mistake is treating an order quantity as if it were available inventory. Until a delivery is received and checked, it is more accurate to record it as ordered or expected, not on hand. Another is counting the same stock in inconsistent units, such as comparing individual pieces with cartons. A short note defining the unit and conversion can prevent a large apparent discrepancy.
Descriptions that are too broad can lead to the wrong product being ordered. Include the identifier and distinguishing details, and ask the supplier to clarify if a description or unit is uncertain before the order is finalized. Missing PO numbers also make it harder to connect an invoice, delivery, and internal request. A unique number on each order is a simple reference even when a business uses only a paper filing system.
Other problems arise when people update records without noting why or when. Preserve the original order details and add dated receiving or correction notes instead of silently overwriting history. Make periodic counts according to the business’s needs, investigate material differences, and correct the record only after checking likely causes such as a missed receipt, a return, a damaged item, or a data-entry error. If legal, tax, or other professional requirements affect how records must be kept, ask a qualified professional about the situation.
Paper, Spreadsheet, or Separate Forms?
A printed form is straightforward when orders are infrequent, several people need to sign by hand, or the process happens where a computer is not convenient. Its limitations are also practical: calculations must be checked manually, handwriting can be hard to read, and finding old records depends on a reliable filing method. Use legible entries and retain copies according to the business’s recordkeeping practice.
A spreadsheet can make it easier to add rows, sort items, and use basic calculations, but it depends on careful setup and access control. A formula can be wrong, a cell can be overwritten, and two people may edit separate copies. Keep a clear master, label formula fields, and review totals rather than assuming the sheet is correct. A purchase order and an inventory list may be separate tabs or files; what matters is that their identifiers and references make it easy to connect related records.
Separate inventory, PO, and receiving forms can be clearer than one oversized sheet because each document records a different event. A very small operation may prefer a combined workbook or printed packet, provided it distinguishes stock counted, stock ordered, and stock received. Choose the simplest format that supports accurate entries, review, and retrieval.
Frequently Asked Questions
What is the difference between an inventory sheet and a purchase order?
An inventory sheet records stock information, such as item, location, and quantity on hand. A purchase order documents a request to a supplier for specified goods or services. One describes stock status; the other describes an intended purchase.
Can I use one template for inventory and purchase orders?
You can keep both forms in one workbook or printable packet, but keep their fields and purposes distinct. Inventory rows track stock and counts; PO fields identify a supplier order. Separate sections help prevent an item that has merely been ordered from being mistaken for stock already received.
What should an inventory template include?
At minimum, include an item identifier, description, unit, quantity, and a count date. A storage location and the counter’s name make physical checks easier. A reorder point can be useful when someone is responsible for reviewing it, but it is not essential for every list.
Does a purchase order prove that goods were received?
No. A PO records what the buyer requested; it does not prove delivery or acceptance. Record receipt separately by checking the shipment and noting what arrived, when it arrived, and any shortage, damage, or other discrepancy.
Should the purchase order show prices and a total?
Include prices and a total when they are part of the buyer’s process and the information is known and agreed. Check units, quantities, and arithmetic, and make sure any listed terms match the arrangement. If a price or term is uncertain, confirm it before treating the document as final.
How often should inventory be counted?
There is no single schedule that suits every organization. Set a frequency based on how quickly stock changes, the importance of the items, and the time available for reliable counts. Whatever schedule is used, record the count date and investigate meaningful differences rather than simply replacing the previous number.