Inventory & COGS Tracker

About the Inventory & COGS Tracker

Running out of stock loses sales; overstocking ties up cash — this tracker helps you get it right. Record every product with its quantity, cost and price, and the tracker shows your stock value, flags items that need reordering, and calculates your gross profit on sales. No more guessing what to reorder or whether a product actually makes money.

The dashboard shows your number of products, total stock value, units in stock, low-stock items, sales revenue and gross profit, plus stock value by category. It is built for e-commerce and Etsy sellers who want to manage inventory properly and understand their true cost of goods, without expensive inventory software.

Built in Excel and Google Sheets with automatic reorder alerts and sample data, it works on any device. Pair it with our [Etsy Profit Calculator](#/product/etsy-profit-calculator) to price every product for profit.

Who it's for

What's included

• Track stock, cost and price for every product
• Automatic low-stock reorder alerts
• Dashboard: stock value, revenue and gross profit
• Stock value by category breakdown
• Colour-coded reorder status; sample data included
• Works in Excel and Google Sheets, on any device

How to download & use it

1. Check your email. The moment your payment goes through, we email your files to the address you enter at checkout. They usually arrive within a minute or two — if not, check your spam or promotions folder.
2. Download your files. Open the email and click the download button. Your files save straight to your device — nothing is posted, it is all instant and digital. Keep the email so you can re-download any time.
3. Open it. Open the file in Microsoft Excel, or upload it to Google Sheets (in Google Drive: New → File upload, then open with Google Sheets). It works on desktop, tablet and mobile.
4. Make it yours. Type into the highlighted input cells — everything else calculates automatically. Most files include a "Start Here" tab and sample data to guide you.

Need a hand? Every purchase includes free email support and free updates for life. If a file ever will not open, reply to your receipt and we will sort it.

Frequently asked questions

Does it alert me to low stock?

Yes — set a reorder level and items are flagged automatically when they run low.

Does it calculate profit?

Yes — it works out gross profit on sales using your cost and price.

Related searches

Instant digital download. Nothing is shipped. Files are delivered to your email the moment you buy, and you can re-download them any time. Single-business licence.