Net Profit Margin
The widget is a financial profitability metric that shows the percentage of revenue that remains as profit after all expenses are deducted. High margins, such as 20%, indicate efficient conversion of revenue to profit and strong pricing power. Low margins, such as 3%, reflect high operational costs or competitive pressure. The widget shows a line chart in which the horizontal axis shows the time period or analytical dimension and the vertical axis represents the net profit margin percentage. You can filter data based on these fields:
- Period
- Year
- Ledger Analysis
Query logic
Net Profit Margin = Net Income / Revenue
The widget retrieves account balances from SunSystems Cloud to calculate the net income-to-revenue ratio across selected analysis codes, analytical dimensions or time periods.
The widget retrieves all account balances that are associated with the selected analysis codes. Revenue and costs are aggregated based on the configured time frame and grouping dimensions. The net profit margin is calculated for the aggregated data.