Inventory & Stock Tracker - Excel and Google Sheets Template

Always know what's in stock — without expensive software.

The Inventory & Stock Tracker is a ready-to-use workbook for shops, online sellers, small manufacturers and warehouses. List your products once, log every stock movement, and the workbook calculates current stock, stock value and reorder alerts automatically.

What's inside

• Products: item master for up to 500 SKUs, with cost and selling price, margin %, reorder level, reorder qty, opening stock and supplier. Duplicate SKUs are flagged.
• Stock Movements: log up to 3,000 entries (IN, OUT, ADJUST + / ADJUST −). Pick the SKU from a dropdown; product name and value fill in automatically.
• Stock Summary: opening + in − out ± adjustments = current stock for every product, with stock value and a colour-coded status: OK, Reorder or Out of stock.
• Reorder List: only the items that need ordering, with a suggested order quantity and supplier, ready to send.
• Dashboard: total stock value, items to reorder, out-of-stock count, monthly units in vs out chart, and stock value by category.

Why you'll like it

• Works in Microsoft Excel and Google Sheets — no formulas to write, no subscription
• Any currency and any type of business
• Input cells are yellow; formulas are protected so nothing breaks
• Sample data included so you can see how it works, plus a step-by-step Guide sheet

What you get

1 Excel file (.xlsx), instant download after purchase. Open it in Excel, or upload it to Google Drive and open with Google Sheets.

A record-keeping tool. Stock value uses cost price × quantity; confirm the valuation method your accountant requires.

Frequently asked questions

Who is it for?

Retail shops, online sellers, small warehouses and workshops that need to know what is in stock and what to reorder.

How many products and movements?

Up to 500 products and 3,000 stock movements (in, out or adjustment).

Does it warn me when stock is low?

Yes. The Reorder List shows every product at or below its reorder level, with a suggested order quantity.

How is stock valued?

Current stock × cost price, a simple valuation. Confirm with your accountant if you need FIFO or weighted average.

Does it connect to my billing or POS software?

No. It is a standalone workbook. You can paste exported sales data into the Stock Movements sheet.

Can I use it in any currency?

Yes. Set your currency on the Setup sheet.

Does it work in Google Sheets?

Yes. Upload the file to Google Drive and open it with Google Sheets. It also works in Microsoft Excel 2010 or later. No macros, no add-ins and no subscription.

I'm not good at Excel. Can I use it?

Yes. You only type in the yellow cells; every formula is already built and protected. A step-by-step guide sheet is inside the file.

Does it work on mobile?

It opens in the Google Sheets and Excel apps, but a laptop or desktop is much easier for regular work.

Is my data safe?

The file stays on your own computer or Google Drive. We never receive or see your data.

How do I pay and get the file?

Pay by PayPal or card worldwide, or by UPI, card or net banking in India. The download link appears instantly and is also emailed to you.

What if the file doesn't work?

If the file doesn't work as described and we can't fix it within 7 days, you get a full refund. Email us through the store's contact page.