Straight out of the box NetSuite’s dashboard can seem a little lacking compared to some of its competitors. Start digging beneath the surface though and you’ll find some very compelling features that, once configured, can provide a wealth of useful and accessible metrics for both management and functional users.
The NetSuite KPI Scorecard is a special dashboard portlet that allows detailed comparisons of various financial and operational metrics. Comparisons can be made across months, periods or years and variances can be viewed in a number of different formats. There is a long list of standard KPIs to select from and if you have more specific needs, custom scorecards can also be created.
Without having to configure anything you even have predefined Scorecards that include popular measures already defined and ready to use.
Below is an example of the Financial Ratios Scorecard that gives a headline view of the organization’s financial position and operating efficiency.
Enabling The NetSuite KPI Scorecard feature
The NetSuite KPI Scorecards feature is standard and available in most environments. It may, however, need enabling.
- Navigate to Setup > Company > Enable Features.
- Under the Analytics subtab mark the KPI Scorecards checkbox.
- Click Save.
Enabling the feature allows users to view a configured scorecard on their dashboard. All users can add the scorecard portlet and select from the pre-saved options.
The feature being enabled is not sufficient set up to begin creating new scorecards. The Administrator role will automatically be able setup KPI Scorecards but other roles will need to have the permission assigned.
Edit the relevant role and navigate to the Setup menu under the Permissions subtab. Add the permission KPI Scorecard at Level Full.
Adding a Standard KPI Scorecard
Adding a standard predefined KPI Scorecard requires little to no configuration at all and will still provide incredibly useful management information.
First, you need to add the relevant portlet by opening the Personalize menu from your dashboard.
From your Home dashboard, click the Personalize link at the top right of the screen. This will open a configuration bar containing all the available portlets in your environment.
Locate and select the KPI Scorecard tile.
Locate the newly added KPI Scorecard portlet. Hover over the three dots at the top right-hand corner and click Set Up. This will open a pop up set up menu. From this menu you simply select the Scorecard name and click Save.
The other options available in the Set Up menu are as follows
- Restrict To – Allows you to filter the results displayed on the scorecard to show only Your Team or only Your Own records and transactions.
- Orientation – Choose whether you want your rows or columns as the KPIs.
- Show Trend Graph Icon – Displays an optional View Graph icon that links to a pop up trend graph for each KPI.
- Show Date Row – Displays optional date ranges below the range name. This provides greater clarity than ‘This Period’ or ‘Period Before Last’
Creating a Custom KPI Scorecard
To get the most out of NetSuite KPI Scorecard portlet you will probably want to create your own custom Scorecard.
A lot of thought can go into each line of your Scorecard to really get the most useful data specific to your organization. There are many components to consider so you may run through a number of iterations but each time you should use the following steps to ensure nothing is missed.
- Navigate to Customization > Centers and Tabs > KPI Scorecards > New.
- Enter a custom ID and a Name for your Scorecard. Optionally, you can also enter a more detailed description of what this Scorecard is going to be displaying.
- Navigate to the table under Content : KPIs.
- On the first row select your primary metric under the KPI column. This could either be one of the 60 preset KPIs or a custom one created by you as a saved search.
- In the Compare Value To field you can optionally select a secondary metric to compare your primary to. If you choose this option, you will then need to select a value in the Comparison Type column to define how you want these two numbers to be compared.
- If you have a relevant KPI above this one on the list, you can choose to compare the two by selecting the Compare With Previous checkbox. You will, again, need to select the Comparison Type for this option also.
- When comparing two KPIs the standard name given to that line can sometimes be somewhat unwieldy. You can use the final column to rename the row with something shorter and more intuitive.
- Once you have all your KPIs set in the KPIs tab you can move over to the Date Ranges subtab. Here you will configure the date ranges to report on that will make up the columns of your Scorecard.
- Select your primary date range in the Range column.
- As with the KPIs, you can then choose to compare this range with another.
|For example, you may choose to show a Column for the current month, a column for the previous month and then a column showing the variance.
- Lastly you can navigate to Content : Highlighting to set rules for highlighting
- Select the relevant KPI in the first column. Or, if you want all KPIs to be affected, leave the selection as All.
- Use the Highlight If, Threshold and Date Range columns to create the rules.
- Use the Image, Text Color and Background Color columns to set the format
- Save your Scorecard
Adding a Custom KPI Scorecard
Once you have created your custom Scorecard you need to add it to your dashboard portlet.
Hover over the three dots at the top right-hand corner of the portlet and click Set Up. In the popup window select your Scorecard name from the dropdown and click Save.
Starting to discover how to get the most out of NetSuite dashboards? The following articles will help –