Free inventory software in Excel — the build that works

The key facts

• Excel is free within a Microsoft subscription you may already have — the cheapest legitimate inventory route for one person.
• The build that works: products sheet, append-only movements sheet, derived quantities, protection, monthly count.
• The ceiling: single-user truth, no guardrails, no scanning at the shelf, no management automation — all software capabilities.
• BSimple is the paid alternative: $180/$250/$399 AUD monthly, trial free — and the workbook imports in an afternoon.
• The wider system: inventory management end to end maps the whole record this page sits in.

The build that works in Excel

Sheet 1 — Products. SKU, description, supplier, cost, par level — one row per item, edited deliberately. Sheet 2 — Movements. Date, SKU, direction, quantity, reason, who — append-only, the only sheet that changes in daily use. Derived quantities. On-hand = sum of movements, by formula; typed quantities are how records start lying. Protection on everything except movements. A monthly count with variances investigated and corrections entered as movement rows.

Built that way, Excel is a legitimate inventory record — the same architecture real software uses, hand-rolled. The complete Excel guide walks the build in full, and the Sheets variant trades the file format for built-in sharing.

The honest ceiling for a business

Excel's free-ness buys a record; businesses eventually need management — and that is the ceiling. Sharing: one file means one truth, and second users fork it. Guardrails: selling below zero is a typo away; nothing enforces. The floor: scanning requires a system at the shelf (the scanner gap). Management: reordering, order checking and supplier reconciliation are human filter-running. The stage guide maps when each ceiling arrives.

None of it is solved by downloading a better template — the limits are structural to the medium. The workbook's value is real and bounded; knowing the boundary is what makes it useful.

The paid alternative, stated plainly

We build BSimple, so weigh that: it is the stage above Excel — cloud software (browser-based, shared, live) running the movements architecture the workbook approximates, with guardrails, scan-to-record, reorder drafts, customer portals and invoices pushed to Xero or MYOB (US integrations rolling out). $180/$250/$399 per month AUD, no free tier — stated plainly on a page titled "free", because the ledger has two sides. The workbook imports in an afternoon (the trial runs it beside your live file), and the comparison that decides is at your volume: the hours your current approach costs versus the subscription.

If Excel still fits, stay with it honestly — the free route is real, and this page would rather say so than sell you the upgrade early.