A Step-by-Step Guide to NetSuite KPIs (And How to Use Them)

You didn’t invest in NetSuite just to admire its dashboards. You want real, actionable NetSuite KPIs without needing a PhD in data science to understand them. And even more importantly, you need them to reflect what is really happening behind the scenes.

So let’s talk NetSuite KPIs.

Not the 127 metrics clogging up your reports. Just the ones that actually move the needle for manufacturers like you. Whether you’re running lean or scaling fast, here are the NetSuite KPIs you should be tracking and how to turn them into decisions that drive profit.

What Are KPIs in NetSuite, Really?

NetSuite KPIs (Key Performance Indicators) are customizable metrics that give you a snapshot of how your business is performing. They’re usually displayed in your dashboard and can be tailored by role—CFO, Controller, Operations Manager, even Sales.

Pro Tip: Dashboards aren’t one-size-fits-all. Let sales chase leads, not ledger lines, and keep finance focused on cash flow, not cold calls. Everyone wins (and you limit your team’s click-rage).

But just because NetSuite can track something doesn’t mean you need to. The best KPIs are the ones that tie directly to your business goals. That’s why lean KPI tracking can really make a difference. If you use NetSuite, here are the top KPIs to track:

The Top 7 NetSuite KPIs

1. Inventory Turnover Ratio

Why it matters: Tells you how efficiently you’re moving inventory.

Inventory Turnover Formula: COGS ÷ Average Inventory

Low turnover = dead stock. High turnover = tight cash flow control.

This NetSuite KPI is your canary in the coal mine for supply chain issues and overproduction. And ultimately, let’s you know when to reorder. Tracking this will help you keep supply chain costs low.

Reorder point = (Lead Time x Demand / Time) + Average Inventory

2. Gross Margin by Product Line

Why it matters: Helps you double down on what’s working—and ditch what’s not.

Pro Tip: Unlock line-level margin insights in NetSuite

“We’ve got KPIs in NetSuite but no one looks at them.”

That’s what a COO told me during a discovery call.

It’s a familiar story: You go live on NetSuite. The dashboards look impressive. There’s a flood of data… and no one trusts it. Because here’s the reality: out-of-the-box KPIs aren’t built for the complexity of high-volume wholesale or inventory-heavy ecomm businesses.


What to do instead? Break KPIs down by SKU or product family in NetSuite’s saved searches. If you’re running a low-margin product because “it brings in volume,” check that logic against your actual numbers.

Break this down by SKU or product family in NetSuite’s saved searches. If you’re running a low-margin product because “it brings in volume,” check that logic against your actual numbers.

To get granular with your profitability, start by enabling the Gross Profit feature in NetSuite. Then, tap into the Revenue and Gross Margin dashboard card, either by using custom fields or the Trend-Based Item Gross Margin option.

This setup gives you two major advantages:

1. Say goodbye to guesswork: Future-focused forecasting, letting you project margins by product based on real performance trends.
2. Line-item visibility into gross profit and margin percentages, so you can see exactly which products are pulling their weight. (See example below: Jackets doing pretty well with 58.11% meanwhile shirts only have a 39.76% profit margin).

3. Work Order Completion Rate

Your shop floor might be busy, but is it efficient? The Work Order Completion Rate is a NetSuite KPI that gives you a quick reality check. It measures how many work orders were actually completed compared to how many were started during a specific time period. Think of it as your production follow-through score.

Work Order Completion Rate = (Completed Work Orders ÷ Initiated Work Orders) × 100

Why it matters: A real-time measure of your shop floor’s efficiency.

This tells you whether your production team is meeting demand or falling behind. Bonus: tie it into your NetSuite Manufacturing WIP reports for even deeper insight.

Here’s how to calculate it in NetSuite:

1. Choose Your Time Frame
   Decide whether you’re analyzing by month, quarter, or year—whatever makes sense for your operations cycle.
2. Count Completed Work Orders
   Use a saved search or report to find all work orders marked as “Completed” during that time frame.
3. Count Initiated Work Orders
   Find all work orders that were created (initiated) during the same period.
4. Do the Math
   Divide the number of completed work orders by the number initiated.
5. Convert to a Percentage
   Multiply the result by 100 to get your completion rate.

4. Cash Conversion Cycle (CCC)

Why it matters: It’s the heartbeat of your manufacturing cash flow. The formula for your cash conversion cycle is:

CCC = Days Inventory Outstanding + Days Sales Outstanding − Days Payables Outstanding.

Why NetSuite excels at this KPI: If your CCC creeping upward, NetSuite can help pinpoint whether the issue is in production, sales, or vendor payments.

How to Display the Cash Conversion Cycle (CCC) in Your NetSuite Dashboard

Tracking your Cash Conversion Cycle is essential for managing liquidity—especially in a manufacturing or eCommerce environment where cash flow can get tangled in inventory and receivables. NetSuite gives you several ways to bring this KPI front and center.

Here’s how to visualize your CCC directly in your dashboard:

Option 1: Use the Balance Sheet Trending Report

1. Go to: Financials > Balance Sheet Trending
2. Open the Cash Cycle Dashboard within this section.
3. Customize your view by selecting the appropriate version, subsidiary, and currency.

This built-in dashboard helps you track revenue trends, working capital movement, and your CCC over time. It’s great for high-level insights into your business’s cash flow dynamics and key financial drivers.

Option 2: Build a Custom Report Snapshot

1. Start with a base report—like the Cash Flow Statement or any custom financial report.
2. Use the Report Builder to add in the CCC metric or formula (Days Inventory Outstanding + Days Sales Outstanding − Days Payables Outstanding).
3. Once customized, create a snapshot of the report.
4. Add the snapshot to your dashboard as a portlet.
5. Customize the layout and display options so it fits neatly into your dashboard view.

This approach gives you complete control over what data appears and how it’s visualized.

Option 3: Add CCC to Your Dashboard Using Portlets

1. On your home dashboard, click “Personalize”.
2. Drag in a portlet—such as Balance Sheet Trending or Cash Flow Report.
3. Hover over the portlet, click the three vertical dots, and select “Set Up”.
4. Configure the portlet to show Cash Conversion Cycle data specifically.

This method is quick and flexible, making it ideal for role-based dashboards.

Pro Tip: Want to go deeper? Set up alerts when your CCC spikes or drops, so your team can respond before cash flow issues snowball. Need help with this? Discover how our NetSuite accounting solutions help.

5. Customer Return Rate

Why it matters: Tells you how your quality control is really performing.

If you track RMA (Return Merchandise Authorizations) in NetSuite, set up a KPI meter for this metric. High returns? Your margin’s not the only thing hurting—so is your reputation.

How to Calculate Customer Return Rate in NetSuite

To determine your customer return rate in NetSuite, you’ll need to analyze both sales and returns, then compute the ratio between them. This involves creating saved searches for sales and return authorizations, grouping data by customer, and applying formulas to calculate return percentages.

Here’s a step-by-step guide:

1. Build the Saved Searches

Sales Data:

• Create a Transaction Saved Search.
• Filter by Transaction Type: Sales Orders and Invoices.
• Include fields: Customer, Item Quantity (or Line Quantity), and Transaction Date (if filtering by period).
• Use a summary type to group results by Customer and sum the quantity sold.

Returns Data:

• Create a second Transaction Saved Search.
• Filter by Transaction Type: Return Authorizations.
• Include fields: Customer, Item Quantity, and Transaction Date.
• Again, group by Customer and use a formula to sum the absolute value of item quantities returned.

2. Calculate Totals per Customer

• In both saved searches, use summary fields or formula columns to get:
  • Total Sales Quantity per customer
  • Total Return Quantity per customer

3. Combine and Calculate Return Rate

You have a couple of options:

• Manually export both saved searches to Excel or Google Sheets, then join by customer and calculate the return rate.
• Or, build a third saved search or custom report in NetSuite using a custom formula field to combine sales and returns data (via summary joins or custom records/scripts if needed).

Customer Return Rate = (# of items returned / # of items sold) x 100

4. Optional: Create a Custom Report

Use NetSuite’s Reporting module to visualize customer return rates:

• Build a Custom Transaction Report or KPI Scorecard.
• Incorporate filters for date range, sales channel, or item category.
• Display return rates by customer, with drill-downs for more detail.

This process gives you clear visibility into customer return behavior and can help inform decisions around product quality, customer satisfaction, and return policies.

6. Budget vs. Actuals (by Department)

Why it matters: Accountability, plain and simple.

NetSuite’s Financial Management module lets you track this down to the GL segment level. When operations overspend or sales underperform, you’ll know immediately—not at the end of Q2.

NetSuite’s standard Budget vs. Actual report includes a series of essential columns designed to give clear financial visibility at a glance. Here’s a detailed breakdown of how each of these rows and columns works, and how they can be used to track and influence performance:

Standard Rows in Budget vs. Actual Report

The rows typically align with the chart of accounts structure, including categories such as:

• Revenue accounts (e.g., Product Sales, Services Revenue)
• Cost of Goods Sold (COGS) (e.g., Raw Materials, Direct Labor)
• Gross Margin
• Operating Expenses (e.g., Marketing, Payroll, Rent)
• EBITDA or Net Income

Each of these rows maps to general ledger accounts that correspond to a specific department, project, or cost center, depending on how the budget was set up.

7. Net Income per FTE (Full-Time Employee)

Why it matters: Efficiency at the human level.

This KPI helps you assess team productivity and forecast hiring needs. Use NetSuite’s workforce reports to benchmark over time.

To calculate net income per FTE in NetSuite, you’ll need to divide the company’s total net income by the total number of full-time equivalent employees (FTEs). The resulting value represents the net income generated for each full-time equivalent employee. 

Net Income per FTE= Net Income / Total # of FTE

Here’s a breakdown of the process:

1. Determine Total Net Income: Net income is the profit remaining after deducting all operating and non-operating costs, including taxes. You can find this value in the income statement within NetSuite. 
2. Calculate Total FTEs: FTEs represent the total number of full-time equivalent employees. To calculate this, you can use the number of hours worked by each employee and the number of hours considered full-time for your organization. For example, if you consider 40 hours a week as full-time, an employee working 30 hours a week would be a 0.75 FTE. 
3.  Use the formula above: divide the total net income by the total number of FTEs. 

How to Actually Use NetSuite KPIs (Instead of Just Staring at Them)

• Automate your dashboards: Don’t make your team pull reports manually. Use saved searches and scheduled reports to keep KPI data flowing.
• Tie NetSuite KPIs to incentives: If your shop manager’s bonus depends on improving Work Order Completion Rate, it won’t be ignored.
• Use role-based dashboards: Your Controller needs different KPIs than your COO. NetSuite lets you customize dashboards for each leader.
• Review monthly, act weekly: KPIs are early warning systems. Don’t wait until quarter-end to react.

Final Thought: Don’t Track More. Track Better.

If you’re overwhelmed by NetSuite’s reporting tools, it’s not your fault. Most finance teams aren’t equipped to customize the system in a way that surfaces what truly matters. Thinking you might need NetSuite Recovery?

That’s where we come in.

At expandCFO, we help manufacturers ditch spreadsheet chaos and get the most out of NetSuite. Whether it’s customizing KPI dashboards, building real-time cash flow insights, or running your entire accounting function—we’ve got you covered.

Learn more about our NetSuite Accounting for Manufacturers