Excel inventory workbooks that check every row
Record stock in, stock out and balances in Excel. Every row is checked: a row with a mistake is shown with the reason and left out of the balances, so your stock figures stay right.
- No macros or add-ins
- Excel 2016 or later
- Works offline
- One-time price
- Simple: available nowFree download, no sign-up.
- Custom: previewChoose your parts and see your workbook. Online ordering opens soon.
- Advanced: betaSee what it contains. Not sold online yet.
New: an inventory system built from your answers
Tell us how your business works (warehouse, shop, food production, pharmacy, manufacturing) and pick what you need. Your workbook gets only those pages, forms and reports, with everything recorded properly underneath, so you can switch more on later without losing anything.
- Receiving, issues, transfers, returns, adjustments and stock counts with printable forms
- Batches and expiry, material requests, production, day close
- Sales with prices, receipts, tax and margin
- Dashboard with key figures, charts and alerts
The preview shows your answers and the pages of your workbook. Online payment is not open yet; nothing is charged.
Simple Inventory
For one store or stock room that wants clean stock records today.
- Items, stock in, stock out and a balance for every item
- OK, LOW, OUT and NEGATIVE status per item
- Dashboard: key figures, an item card with a 12-month chart, items by status and store activity
- Data Checks: every row checked, doubled rows flagged
One location · up to 1,000 items · 5,000 stock in and 5,000 stock out rows.
Download free (blank) Download the sampleVersion 1.5.0, .xlsx, about 1.3 MB. The sample has made-up practice data.
Custom Inventory Generator
For businesses with several stores or sites, or that reorder and track usage.
- Everything in Simple, with your business name on it, plus a Stock Register (opening, stock in, stock out and closing for any day or period) and stock value from your unit costs
- Choose the parts you need: several locations (2 to 20) with your codes, transfers between them, a reorder list with order quantities, monthly usage per item
- Your own units, categories and stock in / stock out types in the dropdowns
- Generated from your choices: the file holds only the sheets you picked
Up to 1,000 items, 5,000 rows per sheet and 20 locations. Transfers need several locations.
Configure and preview Tell me when ordering opensThe preview shows your choices and the sheets of your workbook. Online payment is not open yet; nothing is charged.
Advanced Inventory System
For warehouses that need receiving, requests, batches, counts and printable forms.
- Item, location and batch masters, opening stock and one transaction ledger
- Goods receiving (GRN), material requests and issues, transfers, returns, adjustments, production receipts and consumption
- Stock counts and reconciliation, batch and expiry tracking, damaged stock report
- Five consumption reports and 18 printable forms and reports
- Generated with your business name, stock start date, negative-stock rule and near-expiry window
Beta. Reports cover the first 200 items and 12 locations (expiry report: 300 batches); Data Checks warns when you have more. Parts cannot be switched off.
See what it contains Tell me when it opensNot sold online yet. Still being tested.
How it works
- Choose a product.
Simple is free. Custom and Advanced are generated for you. - Configure and preview.
Enter your business name and choices. We check them and show the sheets your workbook will have. - Pay and download. Opens soon
After payment your workbook is generated at once, with a private download link.
Which one do I need?
| Feature | Simple | Custom | Advanced (beta) |
|---|---|---|---|
| Items, stock in, stock out, balances | Yes | Yes | Yes |
| Every row checked; LOW, OUT, NEGATIVE | Yes | Yes | Yes |
| Dashboard | Yes | Yes | Yes, configurable |
| Your business name and lists | No | Yes | Business name and settings |
| Several locations and transfers | No | Optional, 2 to 20 | Yes (reports: 12) |
| Reorder list with order quantities | No | Optional | No |
| Monthly usage per item | No | Optional | Five consumption reports |
| Receiving, requests, batches, expiry, counts, forms | No | No | Yes |
| Size | 1,000 items | 1,000 items | Reports: 200 items |
| Price | Free | $19 | $39 (beta) |
| Today | Download | Preview; ordering opens soon | Beta; not sold online yet |
Available now
- Simple workbook: free download
- Custom and Advanced: configure your workbook and see its sheets
- A list to be told when online ordering opens
Planned, not available yet
- Online payment and instant download of Custom and Advanced
- Importing your existing Excel records online
- Advanced out of beta
Already have records in old Excel files?
The Import Tool (beta, $15) is a separate offline workbook for the Advanced workbook. It checks old records row by row and prepares clean blocks that you paste in yourself. Nothing is uploaded, and old monthly totals stay monthly totals: they are never split into made-up daily entries. It is not sold online yet.
Tell me when ordering opens
Leave your e-mail and we write to you once when Custom or Advanced can be ordered online. This is not an order and nothing is charged.
Good to know
Do I need macros or add-ins?
No. The workbooks use normal Excel formulas only, and need no internet connection. Built for Excel 2016 or later.
Has it been tested in Microsoft Excel?
Every workbook is recalculated in LibreOffice and compared with independent calculations. Checking in Microsoft Excel is still in progress.
What happens with a wrong row?
It stays visible with the reason (for example a missing date, an unknown item code or a quantity of 0) and is not counted, so the balances stay right. Stock below 0 is shown as NEGATIVE; Excel cannot block it without macros.
Can I get a refund?
Yes. Not satisfied with a paid workbook? Tell us within 14 days and the price is refunded.
Can I share the file?
One purchase is for one business or one person. Please do not resell or share paid files. Keep a dated backup copy; the workbooks come without warranty.