ANS-1377 · FINANCIAL REPORTING
How Can EBITDA Be Used as a Custom KPI in NetSuite Scorecards?
Implement EBITDA as a custom KPI within NetSuite scorecards for enhanced financial analysis.
Short answer
To track EBITDA as a custom KPI in NetSuite scorecards, create a custom saved search for expenses, specifically excluding tax, amortization, and depreciation. This filtered expense search becomes a custom KPI. Then, define a KPI formula in your scorecard as: Revenue – COGS – Custom KPI (Expenses w/o TDA).
Scenario
Organizations often require specific financial metrics like EBITDA for performance analysis. NetSuite users may seek to integrate Earnings Before Interest, Tax, Amortization, and Depreciation (EBITDA) directly into their KPI scorecards for streamlined reporting and monitoring.
Solution
To implement EBITDA as a custom KPI in a NetSuite scorecard, follow these steps:
Create a custom saved search for expenses. This search must be configured to exclude tax, amortization, and depreciation expenses.
Designate this custom saved search as a custom KPI within the NetSuite scorecard.
On the KPI scorecard, create a KPI formula for EBITDA using the following structure:
Revenue – COGS – Custom KPI (Expenses w/o TDA)This approach allows for the effective tracking of EBITDA directly within NetSuite's analytical tools.
Expert NetSuite Support
Need help with this NetSuite issue?
Financial Reporting consulting and configuration support