I will create an excel inventory tracker with low stock alerts
About this Gig
Do you track your shops stock in a notebook or a messy sheet? I will set up a clean Excel inventory tracker so you can always see what you have, what is running low and what to reorder.
WHAT YOU GET
- Items sheet to list your products with a reorder level for each
- Stock In and Stock Out sheets to record every purchase and sale
- Current stock that updates by itself
- Automatic status: OK, REORDER or OUT OF STOCK
- A dashboard with totals and a reorder list
- Room to add your own columns
WHO IT IS FOR
Small shops, home businesses, online sellers and anyone who handles stock and wants a simple system without paid software.
HOW IT WORKS
Send me your product list and what you would like to track. I will customize the file with your items and categories and send it ready to use, with a short guide on how to enter data.
PLEASE NOTE
This is an Excel template and tracker. It does not connect to billing software or generate invoices.
Message me before ordering if you want something specific added.
Platform:
Excel
Development technology:
Excel
Expertise:
Formulas
•
Dashboard
•
Charts
•
Data validation
My Portfolio
FAQ
Will this work in Google Sheets?
The file is built for Microsoft Excel. It may open in Google Sheets, but some features like the dashboard charts and drop-downs can look different, so I recommend using Excel.
Can I add my own columns?
Yes. You can add extra columns to the Items sheet, such as supplier, location or barcode. The main stock calculations will keep working as long as you add new columns beside the existing ones and don’t delete them.
How many products can it handle?
The standard file handles up to 200 products and about 1,000 stock entries. If you need more, message me before ordering and I will let you know if it can be extended.
Does it create invoices or connect to billing software?
No. This is an Excel tracker for stock levels, low stock alerts and a reorder list. It does not generate invoices or connect to other software.

