Google Sheets Inventory Template: Build a Simple Tracker

Yes. You can make a practical Google Sheets inventory template with columns for each item, its location, quantities received and issued, a reorder point, and formulas that calculate stock on hand and flag items to replenish. Start with a blank sheet, add the headers and formulas below, then share it with the people who update stock.

What a Google Sheets inventory template can track

A spreadsheet is useful for a small shop, office, workshop, classroom, or household when the main need is to see what is available and what may need ordering. A basic tracker can show item names, unique stock-keeping units (SKUs), categories, storage locations, quantities, reorder thresholds, and estimated stock value. It can also provide a shared list that staff can update in a browser.

There is no single layout that fits every inventory process. A list that works for stationery stored in one cupboard may not be enough for a business with multiple warehouses, batches, expiry dates, or serialized equipment. The template described here is a simple stock snapshot: it calculates a current quantity from an opening count plus receipts minus issues. It is not, by itself, a permanent transaction history or a full inventory-management system.

Set up the columns

Create a new Google Sheet and use row 1 for headings. One workable layout is:

A: SKU or item ID
B: Item name
C: Category
D: Storage location
E: Opening quantity
F: Quantity received during the period
G: Quantity issued or sold during the period
H: Current quantity
I: Reorder point
J: Stock status
K: Unit cost
L: Estimated inventory value

Use a distinct SKU for each item variant that must be counted separately. For example, a blue notebook and a red notebook should have different IDs if their quantities are managed separately. A location such as “Shelf B2” is more useful than a broad description such as “back room” when people need to find the item. Keep one item per row, and avoid merged cells in the data area because they interfere with sorting and filtering.

Add formulas for stock, status, and value

With SKU in A, opening quantity in E, receipts in F, issues in G, and current quantity in H, enter the following formula in H2. It adds received units to the opening count and subtracts units issued:

With quantities in E2:G2 and the result in H2, enter =E2+F2-G2. If the opening quantity is 24, 10 units arrive, and 7 are issued, the result is 27.

With SKU in A, current quantity in H, reorder point in I, and status in J, enter this in J2 to keep unused rows blank and flag stock at or below its threshold:

With those columns in the stated positions, enter =IF(A2="","",IF(H2<=I2,"REORDER","OK")). If H2 is 27 and I2 is 8, the result is OK; if H2 is 8 or less, the result is REORDER.

With SKU in A, current quantity in H, unit cost in K, and estimated value in L, enter this in L2:

With those columns in the stated positions, enter =IF(A2="","",H2*K2). At 27 units and a unit cost of 4.50, the result is 121.50. Format column L as currency using Format > Number > Currency, and choose a suitable currency for your records. This is a simple estimate based on the unit cost entered; it does not determine accounting value or include other costs.

After entering a formula in row 2, copy it down the column using the fill handle or copy and paste. Check a few rows by hand before relying on the results. A total can help summarize the list: with current quantities in H2:H1000, place =SUM(H2:H1000) in a separate summary cell. It adds the numeric quantities in that range; it is meaningful as a total only when combining those units makes sense.

Build and format the sheet

Open Google Sheets in a web browser and create a blank spreadsheet. Name it clearly, such as “Office Supplies Inventory.”
Enter the headings in row 1 and add one item per row beneath them. Put the formulas in H2, J2, and L2, then fill them down as needed.
Freeze the heading row with View > Freeze > 1 row. This keeps labels visible while scrolling.
Enable sorting and filtering with Data > Create a filter. Filter by category, location, or status to find relevant items without rearranging the underlying list manually.
Make quantities and costs easy to scan. Use number formats appropriate to the data, and avoid typing units such as “pcs” into quantity cells; keep the number numeric and put the unit in a separate heading or column if needed.

To make low-stock items stand out, select the status range, for example J2:J, and choose Format > Conditional formatting. Set a rule that formats cells containing the text “REORDER,” then choose a fill color. This is a visual cue, not an automatic purchase order: someone still needs to review the item and decide what to buy.

Keep quantities accurate

The formulas are only as reliable as the entries they use. Agree on what counts as an “issue”: a sale, internal use, transfer out, damaged item, or some combination. Record receipts and issues consistently, and reconcile the sheet against a physical count on a regular schedule. If the inventory is shared, assign responsibility for updates so that a delivery is not entered twice or missed altogether.

For the simple layout above, receipts and issues are period totals. When you begin a new tracking period, update the opening quantity to the actual count and reset the period’s receipt and issue figures. Do not erase those figures if you need them for an audit or to understand past changes; save a dated copy or use a transaction log instead. Entering a negative number to represent an issue can also work mathematically, but it is less clear to users than keeping receipts and issues in separate columns.

Use data validation to reduce inconsistent entries. For example, you can make a dropdown list for categories or locations by selecting the relevant cells and choosing Data > Data validation. The exact controls can change as Google updates its interface, but the rule should limit entries to the categories your team actually uses. Protect formula columns from accidental edits if appropriate, while ensuring collaborators who maintain the sheet can still enter the source quantities.

Choose a reorder point thoughtfully

A reorder point is a trigger for review, not a guarantee that stock will last until the next delivery. A basic threshold may be enough for inexpensive items with predictable use. For a frequently used product, consider how quickly it is consumed and how long replenishment usually takes. A threshold that is too low can lead to shortages; one that is too high can tie up space and money in excess stock.

For example, suppose a team usually uses 3 printer cartridges per week and a supplier takes about 2 weeks to deliver. A reorder threshold of 6 represents roughly two weeks of typical use, but it leaves no allowance for demand spikes or delivery delays. A team might choose a higher buffer based on its own experience. This example is a planning illustration, not a universal rule: usage and supplier lead times differ, and the sheet’s REORDER flag does not calculate either one.

When a transaction log is a better design

If you need to know who changed a quantity, when it changed, and why, a single row per item with period totals is not enough. Create a second tab called “Transactions” with one row for every receipt, issue, return, or adjustment. Useful fields include date, SKU, movement type, quantity, reference, and person recording it. Keeping each event as a separate row preserves a history and makes it easier to investigate a discrepancy.

A transaction-based design needs more careful formulas or reporting to calculate current stock by SKU, and it must handle corrections and transfers consistently. Avoid casually overwriting old entries: record a correcting adjustment with a reason so that the history remains understandable. For a simple list with occasional updates, the snapshot template is easier to maintain. For frequent movements, multiple locations, or traceability requirements, a transaction log or dedicated inventory software is usually a more suitable starting point.

Sharing, permissions, and limitations

Google Sheets allows collaborators to work in the same online file, but sharing settings matter. Use the Share button to invite specific people or choose an appropriate link-access setting. Give edit access only to people who need to change the inventory, and consider view-only access for readers. Google Sheets has version history, which can help identify or restore earlier changes, but it is not a substitute for a deliberate recordkeeping process or a separate backup when the data is important.

A spreadsheet can become fragile as the process grows. Common warning signs include duplicate SKUs, inconsistent item names, formulas overwritten by hand, concurrent edits that are hard to reconcile, and a need to track lots, serial numbers, expiry dates, or several locations. It also will not automatically know that a physical item has moved unless someone records that movement. Keep a clean, restricted source of truth and define who updates it.

Templates, cost, and alternatives

You can build the layout in a blank sheet or look through the Google Sheets template gallery for a suitable starting point; available templates can vary by account and over time. A third-party template may include extra tabs or styling, but inspect its formulas, permissions, and assumptions before entering business data. To preserve a copy of a shared template, use File > Make a copy.

Google Sheets is available at no charge with a personal Google account, while organizations may use it through paid Google Workspace plans; plan features and pricing can change. The spreadsheet itself does not charge per inventory item, but the real cost is the time needed to enter, check, and maintain reliable data. If staff need barcode scanning, point-of-sale integration, automatic purchase workflows, multi-location controls, or robust audit trails, compare inventory software rather than assuming a larger spreadsheet will solve every problem. Excel can also handle a similar tabular tracker, but the instructions and collaboration features differ; this guide’s menu paths are for Sheets in a browser.

Frequently Asked Questions

Does Google Sheets have an inventory template?
You can check the template gallery for a relevant starting point, though the selection may vary and there is no one layout that suits every inventory. You can also create the simple tracker above in a blank spreadsheet or make a copy of a template shared with you.

How do I calculate inventory in Google Sheets?
For a basic stock snapshot, add the opening quantity and receipts, then subtract issues. The formula in this guide assumes those values are in E2, F2, and G2, with the result in H2. A transaction log requires a different summary approach.

Can I use this template for multiple locations?
Yes, add a location column and use a consistent location name for each item record. If the same SKU is stored in several places, use a separate row for each SKU-location combination so the quantity and reorder point are clear for each location.

Can several people update the inventory at once?
They can collaborate in the same Google Sheet if you share it with suitable permissions. Agree on who records receipts and issues, and protect formula cells where appropriate to reduce accidental changes.

When should I move from a spreadsheet to inventory software?
Consider a dedicated system when you need dependable transaction histories, barcode workflows, automatic integrations, detailed location tracking, or controls that are difficult to maintain in a shared sheet. The right point depends on the cost of errors and the complexity of your process.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.