If you sell physical products and you're still tracking stock in a messy
spreadsheet — or in your head — this is the upgrade.
The Apex Inventory Tracker is a workbook built by someone who has spent 15+
years counting real warehouse floors. It does the job of the expensive
inventory apps for a one-time $19: no subscription, no logins, no learning
curve. Open it, delete the example rows, and start typing.
Dashboard — your numbers at a glance: total SKUs, low stock, out of
stock, units on hand, inventory value, overdue inbound, and lot counts.
Stock by SKU — your live stock list. Set a reorder point per item and
the Status column flags LOW STOCK and OUT OF STOCK for you, in color.
SKU Master — the one clean list of every product and variant, with a
duplicate check that turns red if a part number appears twice, and a
Lot-tracked? flag for parts that carry lot numbers.
Inbound Shipments — what's coming, from whom, and when. Statuses show
ON TRACK, DUE SOON, OVERDUE, or RECEIVED. Fill in a lot number when a
shipment carries one; leave it blank when it doesn't.
Lot Tracking — one row per lot: lot number, part number, quantity,
bin, date received, and expiration date when the part has one. Statuses
show AVAILABLE, EXPIRING SOON, EXPIRED, or USED UP. Parts without lots
simply don't get rows here.
Yellow cells are where you type. Gray cells calculate themselves. Nothing
to install, nothing to subscribe to. Works in Microsoft Excel and Google
Sheets (File → Import in Sheets).
Small Shopify, Etsy, and Amazon sellers, makers, breweries, distilleries,
machine shops, and small manufacturers — anyone with physical stock and
no patience for another monthly fee.
It is not inventory software, it does not connect to your store or your
ERP, and it will not count your floor for you. It is a sharp, honest
spreadsheet that makes the counting you already do much harder to get
wrong.
Instant download. Buy once, use forever.
Questions?
sales@apexassistantsolutions.com