ERP systems can generate an overwhelming number of reports. Most implementations start by configuring every report the system can produce, and most of those reports are never opened after the first month.
The more useful question isn't "what can ERP report on?" It's "what decisions do we actually make, and what data do we need to make them better?"
Start with five reports that get reviewed every week. Build from there.
Essential KPIs from Day One
Gross Margin by Product or Service
This is the single most important financial metric for most businesses, and it's often not tracked at the product level until an ERP is in place. For a more detailed view of ERP financial reporting in detail, including how the reporting layer connects to your chart of accounts, that post goes deeper on the finance side.
Gross margin = revenue minus cost of goods sold or direct cost of service delivery. Tracked at the product or service category level, it tells you which parts of your business are actually profitable. A product that generates 30% gross margin requires a very different pricing and volume strategy than one generating 8%.
Many businesses discover when they first run this report that 20-30% of their product line is barely breaking even or actually losing money — subsidized by the strong performers. That discovery is worth the entire ERP investment.
Accounts Receivable Aging
AR aging answers one question: who owes you money, and how overdue is it?
The standard format shows outstanding receivables in buckets: current (not yet due), 1-30 days overdue, 31-60 days overdue, 61-90 days, and over 90 days. The longer something sits in the 61-90 or over-90 bucket, the less likely you are to collect it.
This report should be reviewed at least weekly. It drives the collections conversation: which customers need a phone call? Which accounts are approaching a point where you should stop extending credit? Which are so overdue that they need to be escalated?
For Indonesian B2B businesses where bank transfer is the standard payment method and terms of Net 30 or Net 45 are common, AR aging is the single most actionable weekly report you can have.
Inventory Turnover
Inventory turnover measures how many times your average stock converts to sales in a given period. A business with Rp 500 million in average inventory and Rp 3 billion in annual cost of goods sold has an inventory turnover of 6 — roughly every two months.
High turnover is generally good — it means your capital isn't sitting idle in a warehouse. Very low turnover for specific SKUs signals products that aren't selling. This is where slow-moving and dead stock analysis comes from.
Tracked per product category (or per SKU for businesses with a manageable product count), inventory turnover identifies where you're tying up working capital unnecessarily and where you might be understocking relative to demand.
Payables Aging
The mirror of AR aging. Payables aging shows what you owe to suppliers and how it's categorized by due date.
Two uses: first, making sure you don't accidentally miss payment terms and incur late fees or damage supplier relationships. Second, identifying opportunities to accelerate payment in exchange for early payment discounts — if a supplier offers 2% discount for payment within 10 days on Net 30 terms, that's an annualized return of roughly 36% on that cash. It's almost always worth taking.
For businesses with multiple active suppliers on different payment terms, this report is the weekly cash management tool.
Daily or Weekly Revenue vs. Target
Simple but essential. Are you tracking ahead of or behind plan for the period? If you're behind, is it a volume problem (fewer transactions) or a price problem (average transaction value is down)?
This report requires you to have a plan to compare against — which is an argument for ERP's budgeting functionality. Once you have targets entered into the system, actual-vs-budget variance reports generate automatically.
Adding KPIs as Your Business Grows
Once the core five are being reviewed consistently and acted on, you can layer in more sophisticated metrics.
Customer profitability is the evolution of gross margin analysis. It asks: after accounting for all the time and resources we spend serving this customer — sales calls, customized pricing, returns handling, customer service hours — how profitable is the relationship? Some customers that generate high revenue are actually unprofitable once service cost is included. This analysis changes sales and account management priorities significantly.
Sales pipeline velocity (for businesses with a sales team): how fast do leads convert to customers? What's the average deal size by stage? Where in the pipeline do deals most often stall? Pipeline metrics require CRM data, but if your ERP includes CRM functionality or integrates with one, this becomes trackable.
Employee utilization (for service businesses): what percentage of each team member's billed hours are revenue-generating versus internal overhead? This is the fundamental efficiency metric for consulting firms, agencies, and contractors. It determines whether your headcount matches your revenue and where capacity constraints are emerging.
Cost per order or cost per delivery (for logistics and distribution): the fully loaded cost to fulfill one customer order. As volume grows, this metric drives decisions about fulfillment process improvement, minimum order values, and delivery area profitability.
The Most Common Reporting Mistake
Setting up 40 reports that nobody reads is worse than having no reports at all. It creates the illusion of management visibility without the reality.
The best-run ERP implementations I've seen have three to five reports that are reviewed on a fixed schedule by specific people, with a defined action that follows from what they see. The AR aging is reviewed Monday by the finance manager, who then contacts overdue customers. The inventory report is reviewed Thursday by the purchasing manager, who then raises purchase orders for items below reorder point.
The cadence matters as much as the reports themselves. Visibility without routine is just noise.
What Your Business Type Actually Needs
Manufacturing: Focus on production efficiency metrics (planned vs. actual output, machine downtime), raw material consumption variance (theoretical vs. actual), and quality rejection rates alongside the core financial KPIs.
Retail: Sales per store, inventory turnover per category, and shrinkage (difference between system stock and physical count) are the operational metrics that matter most.
Trading/distribution: Margin by product and customer, fill rate (what percentage of orders do you fulfill completely and on time?), and supplier delivery performance.
Services: Utilization, project profitability, and AR aging are the critical three. Revenue per employee is also a useful benchmark for capacity planning.
The right KPI set reflects how your business actually makes and loses money. Start from that understanding, pick the metrics that are most connected to your key decisions, and build the reporting habit before adding complexity.
CERIS designs ERP reporting around the decisions your team actually needs to make. See what we build or get in touch to talk through what that looks like for your business.
