Stop Updating Your Stock by Hand. Log Each Sale Once.
Log a sale, a purchase or a batch once, and the stock count, the low-stock list and the profit per product update from it. So you see what's running low before you sell out. One inventory spreadsheet you own, in Google Sheets and Excel.
- Stock updates from every sale, purchase and batch you log
- See what's running low and what to reorder
- What each product really costs you and earns
- Supplies and finished pieces in one file, with optional recipes and batches
$297$9Instant download • Google Sheets & Excel • Your own file, no account with us • Pay once, no subscription
Google Sheets on any device, or Excel
See the Sheets Before You Buy
Screens from the sample copy, filled with a small maker's example data: products and supplies, sales, the reorder list, stock by place and the dashboard.
Six Things It Does With Each Entry
You type the sale, the purchase or the batch. The tabs behind it do the rest: the count, the cost, the profit and what's running low.
Log a Sale
Stock goes down at that place. The sale carries the item's unit cost and price, so the cost of goods, gross profit and margin fill in for every line.
Log a Purchase or Restock
Stock goes up when the goods arrive. The unit cost carries over, and what you ordered but haven't received yet shows as still to come.
Low-Stock Flags and a Reorder List
Set a reorder level per item. Each one shows in stock, running low or out of stock, and the Reorder List fills itself with a suggested quantity to order.
Make a Batch
Optional Recipes and Batches take the supplies out of stock, add the finished pieces, and work out the cost of one piece from your supply costs.
What Sells and What Sits
Best sellers and slow movers, profit by product and by category, and sales by place, filtered by year, category or place.
Your Own File, Pay Once
No subscription, no price rises, no account with us. It lives in your Google Drive or on your computer, and it's yours to keep.
12 Tabs in Google Sheets and Excel
Start Here and Your Items (3 Tabs)
Start Here (how it works in 3 steps; your business name, currency, year start, categories and places; which tabs to hide), Products & Supplies (one row per product or supply, with its on hand, reorder level, cost and price) and Suppliers (who you buy from and what you spend with each).
Log Each Entry Once (4 Tabs)
Sales, Purchases, Adjustments (corrections after a count, breakage, samples and gifts) and Transfers (moving stock between places). Every row moves the count.
See Where You Stand (3 Tabs)
The Dashboard, the Reorder List and Stock by Place: on hand and stock value for each place, or for all of them.
For What You Make (2 Tabs, Optional)
Recipes (the supplies in one finished piece and the cost of one piece) and Batches (supplies out, finished pieces in). Hide them if you only resell.
Also Included
Each Tab, Up Close
Every tab works in Google Sheets and Excel. Log each sale, purchase or batch once, and the tabs below update from it.
Counts That Come From What You Logged, Not From Memory
Keep track of every product and supply in one table. The on hand number fills itself from every sale, purchase, adjustment, transfer and batch, so the count you see is the count you logged. After a count on the shelf, one adjustment with a reason puts it right.
Reorder List
Every product and supply at or below its reorder level shows up here by itself, with what's on hand, what's already on order, and a suggested quantity that brings it back up to the target level you set. Your usual supplier sits next to it.
Sales
Log a sale with the date, item, quantity and place, and the unit price and unit cost fill in from Products & Supplies (you can overwrite them). Stock goes down at that place, and the cost of goods, gross profit and margin follow for every line: figures for your own tracking, not tax figures.
Purchases and Suppliers
Log what you ordered and what arrived. The unit cost fills in from your stock list, stock goes up when the goods arrive, and open quantities show what's still to come. Suppliers lists who you buy from and what you buy, and your spend with each fills in from Purchases.
Keep Track of Supplies as You Make
For what you make: a recipe lists the supplies and quantities that go into one finished piece, and works out the cost of one piece from your supply costs. Log a batch and the supplies come out of stock while the finished pieces go in, at the place you choose. Both tabs are optional.
Stock You Sell in the Shop, Online and at Markets
Your places come preset as Shop, Online orders and Markets & events, and you can rename them. Move stock to a fair with a transfer, log what sold there, move back what came home, and see what went, what sold and what came back. Totals don't change when stock moves; each place's count does.
See What's Running Low Before You Sell Out
Counts of items running low and out of stock sit at the top of the dashboard, next to sales, cost of goods, gross profit and margin by month. Best sellers and slow movers, profit by product and category, sales by place and spend by supplier, filtered by year, category or place.
Inventory Apps Keep Costing More. Your Own File Doesn't.
Monthly fees that keep going up, screens that change under you, features that move or go, and weeks of setup. A spreadsheet you own works differently.
One honest difference: it doesn't connect to your online shop or your till, and it doesn't scan barcodes. You type or paste each sale as a row, and the stock, cost and profit follow from it.
Already keep a homemade sheet? The formulas here are built and linked across all 12 tabs, so it doesn't turn into the sheet you stop updating.
Four Steps From Your First Item to Your First Reorder
Add your items once. After that, each sale, purchase or batch is one row.
Add Your Items Once
Your products and supplies, each with a reorder level, in Products & Supplies
Log Each Entry
Each sale, purchase or batch as one row
It Updates
Stock, low-stock flags, cost and profit follow from it
Check Before You Reorder
The dashboard and the Reorder List, before you order or make more
Three Reasons to Pick This Tracker
Google Sheets and Excel, both included. Log a sale on your phone at the stall or on your laptop at home.
NO RETYPING EVERY COUNT
Log each sale, purchase or batch once. The on hand count updates in Products & Supplies and in Stock by Place.
LOW STOCK, SEEN IN TIME
Flags against the reorder level you set, and a Reorder List with a suggested quantity, before you sell out.
PAY ONCE, KEEP THE FILE
No subscription, no account with us. The cost and profit of every product, for your own tracking, in a file you keep.
Set It Up in Minutes
Open the sample copy first: it's filled with a small maker's example data, so you can see how every tab works. Then open the clean copy, where Start Here walks you through 3 steps: add your products and supplies, log each sale, purchase or batch, and check the dashboard and the reorder list. No formulas to write.
Printable Market-Day and Stock Count Sheets
Two printable pages for the stall and for a count away from the screen: a market-day tally sheet and a stock count sheet, as a PDF in US Letter and A4. What you write on them goes into Sales and Adjustments afterwards.
Your Own Stock File, Pay Once: $9
One download with everything on this page: 12 tabs in Google Sheets and Excel, a sample copy and a clean copy, plus the printable market-day and stock count sheets. Your own file, paid for once.
- Products & Supplies, Filled In From Every Log
- Sales, Purchases, Adjustments & Transfers
- Reorder List With a Suggested Quantity
- Dashboard, Stock by Place & Suppliers
- Optional Recipes & Batches, Cost per Piece
- Google Sheets and Excel, Both Included
- Printable Market-Day & Stock Count Sheets
Instant digital download • Works with Google Sheets & Excel • One-time payment
This is a digital product with immediate access after purchase. No refunds on the Ultimate Inventory Tracker or any order bump. The optional upgrade offered after checkout is the one exception, with a 90-day money-back guarantee.
On Your Laptop at Home, on Your Phone at the Stall
Instant download, Google Sheets and Excel, reusable year after year. Set it up in your browser on Mac or PC, then log sales in the Google Sheets app on your phone or tablet. The Excel file is made for Microsoft 365.
Questions Before You Buy
The honest answers, including what it doesn't do
Log it once. Stop updating every count by hand.