Inventory Spreadsheet | Stock Tracker with Reorder Alerts | Small Business Inventory Management | Stock In and Out | Google Sheets & Excel

Know what you have, what is selling and what to reorder before you run out with this Inventory and Stock Tracker spreadsheet for small businesses.

WHAT'S INSIDE

• Start Here: business name, year and days of sales to average

• Dashboard: stock value, what to reorder, sales and profit by month

• Products: SKU, cost, price, reorder point, lead time, on hand and status

• Stock In: every purchase or batch you make

• Stock Out: every sale, use or damaged item

• Help & FAQ: quick answers

FEATURES

✔ On hand quantity updates automatically

✔ Status: OK, Reorder or Out of stock

✔ Days of stock left based on recent sales

✔ Supplier lead time considered in reorder alerts

✔ Total stock value at cost

✔ Sales and profit by month

✔ 400 products, 2,000 stock-in and 3,000 stock-out rows ready

HOW IT WORKS

1. Download the file and open it in Google Sheets or Excel (the PDF guide shows how).

2. Add your products once with starting quantity and reorder point.

3. Log Stock In and Stock Out. Statuses and the Dashboard update themselves.

YOU WILL RECEIVE

✔ 1 .xlsx template file (blank, ready to use)

✔ 1 DEMO file with sample data, so you can see how it works

✔ 1 PDF guide: how to open it in Google Sheets (free) or Excel

PLEASE NOTE

✔ Digital product. Nothing physical will be shipped.

✔ Works in Google Sheets (free Google account) and Microsoft Excel 2016 or newer / Microsoft 365.

✔ Not compatible with Apple Numbers.

✔ Due to the digital nature, no returns. Message us for any help!

✔ For personal or own-business use only (no resale or sharing of the file).

Questions? Message us anytime — Rafael & Martha, TidyCents. A real person answers every message.