The KPIs that matter

Days sales outstanding, inventory turns, on-time delivery and the rest, and where to read them.

Baca dalam Bahasa Indonesia

On this page
  1. Rules for good KPIs
  2. Cash and working capital
  3. Profitability
  4. Inventory
  5. Sales and service
  6. Purchasing and suppliers
  7. Production and maintenance
  8. A weekly KPI routine
  9. Checklist

An ERP produces thousands of numbers. A management team needs about a dozen, read every week, with the same definitions every time. A KPI (key performance indicator) is one of those: a measure that tells you whether a part of the business is getting better or worse, and that someone owns.

This article gives the KPIs consultants set up first in a trading or manufacturing company, the formula for each, and where to read or calculate it in Voltrus. Where Voltrus does not show a KPI directly, it says so and shows how to compute it from an export.

Rules for good KPIs

  1. Defined once, in writing. "Inventory turns" means nothing until you agree whether it uses cost or sales value, and average or closing stock.
  2. Owned by one person, who explains the movement each week.
  3. Read as a trend. One month's figure tells you little; twelve months tell you a lot. Record each month's value in a simple table.
  4. Few. If everything is a KPI, nothing is.

Cash and working capital

Working capital is the cash tied up in running the business: receivables plus inventory minus payables. These are usually the first KPIs to improve after an ERP go-live, because the data finally becomes reliable.

KPIFormulaGood direction
DSO (days sales outstanding)Accounts receivable ÷ revenue for the period × days in periodDown
DPO (days payables outstanding)Accounts payable ÷ cost of goods sold for the period × days in periodStable, within agreed terms
DIO (days inventory outstanding)Inventory value ÷ cost of goods sold for the period × days in periodDown
Cash conversion cycleDSO + DIO − DPODown
Overdue receivables %Overdue AR ÷ total ARDown

Worked example, for a quarter of 90 days:

FigureValue
Revenue (quarter)3,000,000,000
Cost of goods sold (quarter)2,100,000,000
Accounts receivable (end)1,200,000,000
Inventory (end)1,400,000,000
Accounts payable (end)700,000,000
DSO = 1,200 ÷ 3,000 × 9036 days
DIO = 1,400 ÷ 2,100 × 9060 days
DPO = 700 ÷ 2,100 × 9030 days
Cash conversion cycle = 36 + 60 − 3066 days

Every rupiah of sales is out of the company's hands for 66 days. Cutting DIO by 15 days frees about 350 million of cash (2,100,000,000 ÷ 90 × 15) without selling anything more.

Profitability

KPIFormulaWhere in Voltrus
Gross margin %(Revenue − COGS) ÷ revenueIncome statement on Financial statements
Operating margin %Operating profit ÷ revenueIncome statement
Margin by department or project(Revenue − expense) ÷ revenue, per cost centre or projectP&L by cost centre or project
Budget varianceActual − budget, per account and cost centreBudget vs actual
Production varianceActual work order cost − standard output valueWork order cost panel; variance account 5-9000 on the statements

Gross margin is only as good as your inventory costing. If the margin jumps around from month to month, check item costs and the variance account before celebrating or panicking. See Inventory valuation and Product costing, WIP and variances.

Inventory

KPIFormulaWhere in Voltrus
Inventory turnsCOGS for 12 months ÷ average inventory valueCOGS from the income statement; inventory from Stock → Valuation (valuation as of any date)
Slow-moving and dead stock valueValue of items with no issue in 90 / 180+ daysStock → Valuation → Slow-moving
Inventory record accuracyCount lines within tolerance ÷ count lines countedPosted stock counts and the Stock → Cycle counting tab
Items below reorder pointCount of items whose on-hand is below the reorder pointDashboard and Stock

Inventory record accuracy is the KPI that decides whether MRP can be trusted. World-class operations run above 95% of count lines within tolerance; below 90%, planners stop believing the system and go back to spreadsheets. Count by ABC class (Voltrus schedules A items 12 times a year, B 4 times, C once) and record accuracy per count.

Sales and service

KPIFormulaHow to get it
On-time delivery (OTD)Order lines shipped on or before the promised date ÷ lines shippedSales order lines carry a promised date and delivery orders a ship date. There is no OTD report yet: export delivery orders and order lines to Excel and compare.
Order backlogValue of confirmed sales orders not yet shippedSales orders filtered to confirmed; Finance → Overview shows open sales orders by age
Quote conversion rateQuotations converted ÷ quotations sentSales quotations filtered by status

Purchasing and suppliers

KPIFormulaHow to get it
Supplier on-time deliveryReceipts on or before the PO expected date ÷ receiptsPOs carry an expected date; compare it with receipt dates in an export. No report on screen yet.
GRNI ageValue of goods received but not billed, older than 30 daysThe month-end checklist flags old Received, not billed items
Open purchase orders by ageCount and value of approved POs not yet receivedFinance → Overview; Dashboard Purchase orders to receive

Production and maintenance

KPIFormulaWhere in Voltrus
Work order schedule adherenceWork orders done by their due date ÷ work orders doneWork orders list (export and compare); Dashboard shows work orders due this week
Production variance %Cost variance ÷ standard output valueWork order cost panel per order
PM compliancePreventive maintenance jobs done by due date ÷ PM jobs dueMaintenance (overdue first); the Dashboard shows overdue maintenance

A weekly KPI routine

  1. Monday morning, each owner updates their figures in one shared sheet (or, better, reads them from the screens above).
  2. Thirty minutes of management meeting: only the KPIs that moved the wrong way, each explained by its owner, each with one action and a date.
  3. Actions are logged as activities on the relevant Voltrus records (the overdue customer, the late supplier's PO), so they are followed up where the work happens.

Checklist

  • Write down the definition and owner of each KPI you adopt.
  • Record twelve months of history as soon as Voltrus has it, to read trends.
  • Schedule the stock-below-reorder and finance journal reports to the people who own those numbers.
  • Review inventory record accuracy before trusting MRP suggestions.

Run it in Voltrus ERP

Everything in these guides is built in: documents that post to the ledger as they happen, Indonesian tax, MRP and costing, with AI agents that propose and people who approve.

See Voltrus ERP