Blog · Board and management reporting · Industrial distributors
ERP dashboard examples connect purchasing, stock movements and finance using the same reporting period. Work through a distributor's reconciled inventory, purchasing and payables views, then see what changes when a receipt arrives early.
ERP dashboard examples are most useful when purchasing, inventory and finance tell a consistent story from the same exports. Show what was ordered, what arrived, what remains in stock and what the company earned, with the reconciliation beside the measures.
An operations director wants to know whether purchasing is building useful stock or tying up money. The controller wants to know whether the inventory valuation and gross profit agree with the ledger. Those questions belong in a shared review because a receipt can raise inventory and supplier liabilities without changing sales.
Use a fictional Ohio industrial distributor, Lake Erie Components, for September 2026. Its review covers one legal entity, USD transactions and the same month-end cutoff throughout. The example assumes no returns, transfers, inventory adjustments or unmatched receipts. Receipts are invoiced in the same month at the same inventory cost.
Those assumptions make the arithmetic visible. In an actual review, add separate lines for events the business has rather than forcing them into purchases or sales. Follow the existing reconciliation method when an export fails to tie to its controlling balance.
The first layout is a product-family inventory bridge. The second places purchasing and payables beside it. Neither requires changing the ERP configuration; both begin with files the teams already export.
Bring an opening inventory valuation, a goods-receipt register, the inventory issue costs attached to sales and the net sales register. Preserve item codes so the product-family assignments remain consistent across files. Each source retains its own transaction identifier.
The following table is the complete aggregated example. Inventory and receipts use carrying cost; sales use net selling value. Gross profit is sales less cost of goods sold, abbreviated COGS.
| Product family | Opening inventory (USD) | Receipts at cost (USD) | COGS (USD) | Net sales (USD) | Closing inventory (USD) | Gross profit (USD) |
|---|---|---|---|---|---|---|
| Bearings | 120,000 | 90,000 | 110,000 | 160,000 | 100,000 | 50,000 |
| Valves | 80,000 | 50,000 | 60,000 | 100,000 | 70,000 | 40,000 |
| Safety supplies | 40,000 | 60,000 | 50,000 | 80,000 | 50,000 | 30,000 |
| Total | 240,000 | 200,000 | 220,000 | 340,000 | 220,000 | 120,000 |
Closing inventory = Opening inventory + Receipts at cost - COGS
Gross profit = Net sales - COGS
For bearings, closing inventory is 120,000 + 90,000 - 110,000 = $100,000. Gross profit is 160,000 - 110,000 = $50,000. Across all families, 240,000 + 200,000 - 220,000 = $220,000 of closing inventory, and 340,000 - 220,000 = $120,000 of gross profit.
Gross margin is 120,000 / 340,000 = 35.29%, rounded to two decimal places. Keep the detailed margin method in the gross profit margin guide; here the purpose is to connect the financial result to stock movements.
Do not value remaining inventory at selling price. The Census Bureau's manufacturing definitions distinguish shipment selling values from inventory valued at cost. Although its survey covers manufacturers, the distinction also helps readers understand why sales dollars and inventory dollars cannot be substituted in this bridge.
For this distributor, receipt costs already include the applicable acquisition charges. The IRS explanation of purchased merchandise cost includes invoice cost after appropriate discounts plus transportation and other acquisition charges. The controller should use the company's approved inventory valuation consistently across the exports.
Next, bring the purchase-order register, receipt register, supplier invoice register, payment register and opening supplier balances. The purchasing view below covers a single September order cohort: every order was placed in September, with no opening commitment or cancellation. The payables bridge covers the entire entity for September.
| View | Source inputs (USD) | Calculation | Result (USD) |
|---|---|---|---|
| Purchasing | Orders placed 230,000; receipts 200,000 | 230,000 - 200,000 | 30,000 open commitment |
| Inventory | Opening 240,000; receipts 200,000; COGS 220,000 | 240,000 + 200,000 - 220,000 | 220,000 closing stock |
| Payables | Opening 100,000; supplier invoices 200,000; payments 180,000 | 100,000 + 200,000 - 180,000 | 120,000 closing liability |
These results answer different questions. The $30,000 is ordered merchandise still outstanding. The $220,000 is inventory on the books. The $120,000 is the amount owed to suppliers. Adding the figures would create a meaningless total because they are different business states and can overlap.
Keep the distinctions in purchase-order, invoice and paid spend available to anyone interpreting the purchasing panel. A supplier invoice can relate to goods received earlier; payment can settle an older invoice. The equality between receipts and invoices in this example is an explicit simplifying assumption.
Check each panel independently. The closing inventory must equal the inventory valuation and the inventory control account. Net sales and COGS must tie to the income statement for the included scope. Closing payables must equal the supplier subledger and its ledger control balance. Open commitments must agree with outstanding quantities valued on the same purchase-order basis.
Suppose an additional bearings receipt costing $20,000 arrives in September rather than October. It belongs to the existing purchase-order cohort and is invoiced immediately. Sales, issue costs, orders placed and cash payments stay as originally shown.
| Measure | Original (USD) | After earlier receipt (USD) | Calculation after change |
|---|---|---|---|
| Bearings receipts | 90,000 | 110,000 | 90,000 + 20,000 |
| Bearings closing inventory | 100,000 | 120,000 | 120,000 + 110,000 - 110,000 |
| Total receipts and supplier invoices | 200,000 | 220,000 | 200,000 + 20,000 |
| Total closing inventory | 220,000 | 240,000 | 240,000 + 220,000 - 220,000 |
| Open purchase commitment | 30,000 | 10,000 | 230,000 - 220,000 |
| Closing payables | 120,000 | 140,000 | 100,000 + 220,000 - 180,000 |
| Gross profit | 120,000 | 120,000 | 340,000 - 220,000 |
Purchasing looks more complete, but inventory and payables both rise. Gross profit and cash payments do not move. The operations director should ask whether the earlier receipt protects customer service or merely brings the funding requirement forward. A lower open-order figure alone cannot answer that question.
Have purchasing own the outstanding-order explanation, operations own stock movements and finance own the ledger tie. Resolve differences before using the review to change buying behavior.
Bring a sample of your own purchase-order, receipt, inventory and finance exports to Covirage as files. Covirage maps the columns, and its tools compute and check the figures; the external AI model explains the result with every figure traced to its rows. Create a free Covirage account, then set up your business and bring the exports behind your review.
See Covirage for industrial distributors for the industry context.
Include measures that answer a shared business question across purchasing, inventory and finance. Useful fields are open purchase commitments, goods received, inventory at cost, revenue, cost of goods sold and supplier balances. Give every measure an owner, a reporting period and a source total.
They may measure different events. A purchase order records a commitment, a receipt records goods arriving, an invoice records the supplier liability, and payment settles that liability. Differences require an explanation of timing, scope and valuation before anyone treats them as errors.
An open purchase order is a commitment rather than proof of inventory ownership. Keep commitments separate from the inventory valuation. Goods in transit and consigned goods need the company's ownership and accounting rules applied before they enter the stock balance.