The problem. Orders sit in one place, stock counts in another, and customer prices in a third. It is hard to see which orders are late, how much you really have available, or what to reorder before you run out.
What this does. You keep one list of products, one of trade customers, one of orders and their lines, and one of stock movements. The workbook works out each customer's tier price, each order's total and days late, and each product's stock on hand, available stock and stock value at cost, then counts them on a dashboard.
What you can do with it
- See outstanding orders, overdue orders and orders due soon, with their value, by status as a table and a chart.
- See stock on hand, stock available after open orders, and stock value at cost, by category.
- See which products are at or below the reorder level you typed.
- Price each order line from the customer's price tier, with an override or a line discount when you need one.
- Check each customer's open order value against a credit limit you typed. It is a prompt for you: nothing is blocked.
- Choose your industry (food and beverage, packaging and supplies, or retail) to load suitable lists, then edit them to suit you.
- Keep your records in a clear structure: a Data Dictionary explains every column, and six export sheets repeat your records under plain field names.
How it works
- Enter your business name, choose your industry, and type your price tiers and due-soon window.
- Add your suppliers, products and trade customers.
- Add your orders and their lines, and record stock coming in, going out and corrections.
- Check the dashboard and the outstanding orders each day.
Who it is for. Sole traders, small wholesalers and small teams who take trade orders and hold stock, and want to see late orders, stock and reorders at a glance.
Who it is not for. Businesses that need accounting, invoicing or warehouse software. This is a spreadsheet: it does not take payments, raise invoices, send alerts, or connect to accounting software, couriers or any other system.
What you need. Microsoft Excel 2016 or later. It was tested in Excel for Windows. No macros, no add-ins and no subscription.
Good to know
- Orders do not change stock by themselves. When you send the goods, record an Out movement on the Stock movements sheet, then set the order to Dispatched.
- A product is flagged for reorder when its stock on hand is at or below the reorder level you typed.
- Nothing connects to accounting software or couriers. You type your records in.
- 1,000 order rows, 2,000 order lines, 2,500 stock movements and 500 products are ready, and you can add more by dragging the last row down.
- Price tiers, the due-soon window and reorder levels are your own numbers, typed in the workbook. Nothing is a built-in rule.
- No tax is added or worked out. Amounts are in whatever currency you use.
- An example copy with a made-up business shows every sheet working before you start.
- Nothing is locked or password protected.
- Use this template to capture and improve your business data now. In future you can automate with AI.
- General information only. It is not accounting, tax, legal or financial advice.