Profit Charts

Gross Profit Percentage

Explanation

Represents the percentage of total sales revenue that the company retains, after incurring the direct costs associated with producing goods and services. 

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 the gross profit percentage over the period against a 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, 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 percentage of revenue 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 the net operating profit percentage this year to the net operating profit percentage 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 chart.

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 percentage of profit growth over the period.

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 six months.

Formula

Trading Revenue - (Expenses - Income tax Expense) 

Report Codes Used

REV.TRA, EXP and EXP.TAX

Profit

Explanation

Shows a comparison of profit and revenue received, to view how much of revenue is being consumed by expenses.

Formula

  • Revenue: Trading Revenue
  • Profit: Trading Revenue - Expenses + Tax Expense

Report codes used

REV.TRA, EXP, EXP.TAX

Profit Progress - Against Budget

Explanation

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

Formula

  • Gross Profit: Trading Revenue - Cost of Sales
  • Net Profit: Trading Revenue - Expenses + Tax Expense

Report codes used

REV.TRA, EXP.COS, EXP, EXP.TAX

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 growing.

Formula

  • Gross Profit: Trading Revenue - Cost of Sales
  • Net Profit: Trading Revenue - Expenses + Tax Expense

Report codes used

REV.TRA, EXP.COS, EXP, EXP.TAX

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