Inventory
On-hand, committed and available stock per location, with cover expressed in days rather than units — so a low number reads as urgent on its own.
Velocity ERP · Operations
Three spreadsheets,
Three spreadsheets,
one source of truth.
Stock, orders, purchasing and invoicing in one record — so the shortfall shows up before it becomes a missed delivery, not after.
| Item | On hand | Committed | Cover |
|---|---|---|---|
| Pallet wrap 500mm | 1,840 | 920 | 18d |
| Euro pallet | 612 | 590 | 2d |
| Strapping 12mm | 4,200 | 1,100 | 31d |
| Corner board | 88 | 240 | short |
| Edge protector | 2,310 | 480 | 44d |
Two items need a purchase order this week
action
Why teams move
Spreadsheets don't fail loudly.
They drift. Stock lives in one file, orders in another, invoices in the accounts inbox — and four people each hold a slightly different version of the truth.
You sell stock you don't have.
Committed quantities live in the orders file, not the stock file. Nothing reconciles them until someone goes to pick the order.
Invoices go out wrong, or late.
What shipped and what was billed are maintained separately, so a correction in one place quietly never reaches the other.
Nobody can say who changed what.
A number moves, the margin moves with it, and the only record is a file called final_v3_USE_THIS.xlsx.
What's inside
Four modules, one record underneath.
Every module reads and writes the same data. There is no nightly sync, because there is nothing to sync.
Orders
Quotes through to fulfilment, with stock committed the moment an order is confirmed instead of when someone remembers to update a column.
Invoicing
Invoices raised from what actually shipped, so billing and dispatch can't disagree. Credit notes trace back to the line that caused them.
Purchasing
Reorder points calculated from real consumption, with draft purchase orders raised before cover runs out rather than after a stockout.
Audit trail
Every change carries who, what, when and the previous value. Disputes get resolved by looking, not by remembering.
Roles & access
Warehouse, sales and finance each see what they need. Cost prices and margin stay visible only to the people who should see them.
Getting on it
Your spreadsheets are the migration plan.
We import what you already have rather than asking you to re-enter three years of history into a blank system.
- We start from your files. Stock lists, order history and the supplier sheet, imported as they are.
- You run both for a month. Nobody switches off the spreadsheet until the numbers agree.
- Your data stays yours. Exportable in full, at any time, in a format you can actually open.
| Source file | Rows | Matched | State |
|---|---|---|---|
| stock_master.xlsx | 1,412 | 1,412 | clean |
| orders_2025.xlsx | 8,904 | 8,904 | clean |
| suppliers.csv | 214 | 209 | 5 to map |
| price_list_v7.xlsx | 1,180 | 1,180 | clean |
Nothing is written until you approve the mapping
dry run
See it against your own numbers.
Send us a stock list and an order export. We'll load them into a sandbox and walk you through your own operation rather than a demo dataset.