Profit Charts

Gross Profit Percentage

Explanation

Represents the % of total sales revenue, that the Company retains, after incurring the direct costs associated with producing the goods and services, sold by the Company. The higher the % the more the Company retains on each dollar of sales to service its other obligations and costs.

Formula

(Trading Revenue - Cost of Goods sold) / Trading revenue * 100

Report Codes Used

REV.TRA and EXP.COS

Gross Profit Percentage (with high and low)

Explanation

Measures the highs and lows of Gross Profit % during the month in regards to the trend line.

Formula

(Trading Revenue - Cost of Goods sold) / Trading revenue * 100

Report Codes Used

REV.TRA and EXP.COS

Net Operating Profit - This Year vs. Budget

Explanation

Shows the net profit at month end compared to the budgeted profit. Allows you to track profit progress during the year.

Formula

Series 1: Trading revenue - (Expenses - Income tax expense)

Series 2: Trading revenue [Budget] - (Expenses [Budget] - Income tax expense [Budget])

Report Codes Used

REV.TRA, EXP and EXP.TAX

 

Net Operating Profit - This Year vs. Last Year

Explanation

Compares month end net profit this year to the same month end net profit as last year.

Formula

Series 1: Trading revenue - (Expenses - Income tax expense)

Series 2: Trading revenue [Last 12 months] - (Expenses [Last 12 months] - Income tax expense [Last 12 months])

Report Codes Used

REV.TRA, EXP and EXP.TAX

Net Operating Profit Percentage

Explanation

Shows the % of selling price that is turned into net profit. A higher profit margin indicates a more profitable company that has better control over its costs.

Formula

(Trading revenue - (Expenses - Income tax expense)) / Trading revenue * 100

Report Codes Used

REV.TRA, EXP and EXP.TAX

Net Operating Profit Percentage - This Year vs. Last Year

Explanation

Compares net operating profit % this year to net operating profit % last year. Allows you to see if your products or services have become more profitable.

Formula

Series 1: (Trading revenue - (Expenses - Income tax expense)) / Trading revenue * 100

Series 2: (Trading revenue [Previous 12 months] - (Expenses [Previous 12 months] - Income tax expense [Previous 12 months])) / Trading revenue [Previous 12 months] * 100

Report Codes Used

REV.TRA, EXP and EXP.TAX

Operating Profit - Last Year

Explanation

Shows last year's operating profit in a line graph

Formula

Trading Revenue [Previous 12 months] - (Expenses [Previous 12 months]  - Income tax Expense [Previous 12 months]) 

Report Codes used

REV.TRA, EXP and EXP.TAX

Operating Profit - This Year

Explanation

Shows the profit made at month end in a line graph.

Formula

Trading Revenue - (Expenses - Income tax Expense) 

Report Codes used

REV.TRA, EXP and EXP.TAX

Operating Profit Growth (%)

Explanation

Measures the % profit growth of the organisation month to month

Formula

((Trading revenue - (Expenses - Income Tax Expense)) / Trading Revenue * 100) - ((Trading revenue - (Expenses - Income tax expense )) / Trading revenue * 100)

Report Codes used

REV.TRA, EXP and EXP.TAX

Operating Profit Trend - Last 18 Months

Explanation

Shows the profit trend over the last 18 months and the projected 6 months

Formula

Trading Revenue - (Expenses - Income tax Expense) 

Report Codes Used

REV.TRA, EXP and EXP.TAX

Profit

Explanation

Comparison of net profit and revenue received. Shows how much of revenue is being consumed by expenses.

Profit Progress - Against Budget

Explanation

Measures the success of achieving Gross Profit and Net Profit against the budget.

Profit Progress - Against Last Year

Explanation

Comparing Gross Profit and Net Profit against the last year results. Shows how your organisation is tracking against last year's results, to see if the organisation is growingt.

Release Notes - Terms of Use - Privacy Policy - Launch Application - Copyright Spotlight Reporting 2019