Know what’s low.
Plan your next order.
Try a stock workflow for a fictional detailing business. Adjust opening stock, receipts or usage and see the balances, stock value and reorder plan change.
Stock inputs & calculated balances
Edit the yellow fields. Swipe the table sideways on a phone.
| Product / unit | Opening | Received | Used | Reorder at | Target | Unit cost (R) | On hand | Status |
|---|
On hand = opening + received − used. Reorder when on hand ≤ reorder point, then order enough to reach the target. Negative balances, blanks or a target below the reorder point need correction before totals are shown.
Stock value by product
On-hand quantity × the current unit cost you enter. A simple planning valuation, not a weighted-average or accounting inventory valuation.
Your reorder plan
- Estimated order cost
Excludes VAT, delivery, supplier minimum orders and price changes.
What could a custom workbook include?
Your own product list, pack sizes, stock rules, supplier fields and dashboard measures. A connected Excel workbook could link entries, calculations and summary charts. Live stock synchronisation, multi-user permissions, supplier integrations and automatic ordering are separate requirements.
A sample of connected spreadsheet work
This shows the kind of stock workflow we can scope in the R1,690 Linked Business Workbook. A broader business dashboard with additional measures or workflows starts with the R3,490 Dashboard package, subject to its stated limits.
Compare spreadsheet packages ↗