Free Google Sheets Inventory Tracker
For a business that carries parts, chemicals or supplies on the truck and in the shop, and keeps running out of the one item a job needs.
Open the template · Make a copy · Google Sheet, free, no sign-up
What is inside
| Tab | What it holds |
|---|---|
| Dashboard | Totals and views built from Items, Stock Transactions and Suppliers, no typing needed. |
| Items | Columns Item ID, Item / part name, Category, Stock unit, Default supplier ID, Supplier, Standard unit cost (USD), Reorder level, Target stock and 6 more. |
| Stock Transactions | Columns Transaction ID, Date, Item ID, Item / part, Movement type, Quantity (+), Signed quantity, Supplier ID (optional), Supplier and 4 more. |
| Suppliers | Columns Supplier ID, Supplier name, Contact person, Email, Phone, Lead time (days) and Notes. |
| Settings | Your own dropdown lists (categories and stock units), so the choices match how you work. |
How to fill it in
- List every item once on Items with its unit, cost, reorder level and storage spot.
- Record each delivery, each use on a job and each count fix on Stock Transactions.
- Add suppliers with their lead time, so you know how early to order.
- Watch Suggested order qty and the Dashboard to reorder before anything hits zero.
A tip from the field
Put the job number in the reference column when parts leave stock. Later you can see what each job actually used.
Starter files
Each tab with sample rows comes as a CSV file, handy for importing into another tool or starting fresh.
- Items (6 sample rows)
- Stock Transactions (14 sample rows)
- Suppliers (3 sample rows)
Related templates
- Free Google Sheets Work Order Template
- Free Google Sheets Expense Tracker
- Free Google Sheets Job Tracker
When you outgrow it
Smarfle tracks stock levels and the parts used on each job, with low and out of stock filters. See how it works on smarfle.com.