Templates · Google Sheets
Inventory Tracker
Track what's in stock, log every delivery and sale, and see what to reorder and what your stock is worth, all in one Google Sheet.
- Stock on hand, automatically
- Low stock warnings
- See your stock value
What's inside
- Start HereYour welcome page: a 3-step setup checklist, how the tabs fit together, a guide to every tab with clickable links, and the color legend.
- DashboardYour stock at a glance. Four tiles (items, units on hand, stock value at cost and at retail), a Needs reordering list with out-of-stock items first, your latest stock movements and a chart of what you received against what you used over the last 6 months.
- ItemsEverything you stock, with room for 500 items. Type each item's SKU, name, category, unit cost, sell price, starting quantity and reorder point; what you've received, sold or used, what's on hand, its value and its status (OK, Low stock or Out of stock) fill in.
- Stock MovesEvery change to your stock, with room for 3,000 moves. Log a delivery as In, a sale or use as Out and a stock count correction as Adjust. The item name and the change fill in, and every item's stock on hand updates.
A closer look
Screenshots show the Sample copy with made-up data.
Get set up in minutes
- Open your copy's Start Here tab.
- Items: add each item with its SKU, cost, price, starting quantity and reorder point.
- Stock Moves: log your first delivery or sale.
- Dashboard: bookmark it.
Good to know
- Google Sheets: you need a free Google account. This isn't an Excel file.
- Works in any browser on a computer, tablet or phone. Setup is easiest on a computer.
- Nothing to install: no add-ons, no scripts.
- You get a ready-to-use copy plus a Sample copy filled with example data, and a step-by-step PDF guide.
Ready when you are
You might also like
Small Business Pricing Calculator
Work out what your business needs to earn, turn it into an hourly floor, and price every product or service so it covers your costs, fees and your time.
$7.00View template →
Client Tracker
Keep your clients, jobs and payments in one place, move every job from lead to paid, and see what needs your attention today.
$6.00View template →
Business Mileage Tracker
Log every business drive in seconds and see your miles and mileage deduction by month, purpose and vehicle for the whole tax year.
Coming soonView template →