Medical Services Template


The Medical Services template combines some of the key metrics medical services businesses should focus on. These metrics are split across the Medical Services Financial Metrics and Medical Services Patient Metrics pages in Spotlight. To make the most of the template, you will need to:

  • Source non-financial data
  • Assign specific report codes to key accounts
  • Evaluate the formulas and customise using the formula builder if necessary. Some businesses may measure these metrics differently due to seasonality, setup of accounts or other factors.

Non-financial data required

Most medical services metrics require financial and non-financial data. Therefore, you will need to collate and enter the following non-financial information into Spotlight:

  • Time - Billable
  • Time - Non-billable
  • Total Customers (Patients)
  • New Customers (Patients)
  • Customer Satisfaction
  • Sales - Cancellations
  • Sales - Referrals

You can manually enter the data into the non-financial tab under Customise Data.

Assign specific report codes to key accounts

Most report codes needed for the template are automatically assigned by Spotlight. However, for the metrics to calculate correctly you may need to assign some report codes manually. To do this, open Customise Data and locate the following accounts, then to assign the specified report code click the report code button:

  • Direct wages - EXP.COS.WAG (Expenses > Cost of goods sold > Direct wages)
  • Wages and salaries - EXP.WAG (Expenses > Wages and Salaries)
  • Income Tax Expense - EXP.TAX (Expenses > Income Tax Expense)

Medical Services Financial Metrics page

Direct Costs % to Revenue

Medical Services Financial Metrics Direct Costs to Revenue3

Formula: Direct Wages / Trading Revenue * 100
Report codes used: EXP.COS.WAG, REV.TRA

Top Ten OPEX

Medical Services Financial Metrics Top Ten OPEX2

Formula: Expenses - Cost of Goods Sold - Wages and Salaries - Income Tax Expense
Report codes used: EXP, EXP.COS, EXP.WAG, EXP.TAX

Overhead Burden Per Hour

Medical Services Financial Metrics Overhead Burden Per Hour

Formula: (Expenses - Cost of Goods Sold - Income Tax Expense) / Time
Report codes used: EXP, EXP.COS, EXP.TAX, TIM

Effective Hourly Rate

Medical Services Financial Metrics Effective Hourly Rate

Formula: Trading Revenue / Time
Report codes used: REV.TRA, TIM

Medical Services Patient Metrics page


Screen Shot 2018 10 16 at 12.40.28 AM


  • Existing: Total Customers - New Customers
  • New - New Customers

Report codes used: CUS.TOT, CUS.NEW

Patient Satisfaction

Medical Services Patient Metrics Patient Satisfaction

Formula: Customer Satisfaction
Report codes used: OPR.CSR


Medical Services Patient Metrics Non Attendance

Formula: Sales - Cancellations
Report codes used: SAL.CAN


Medical Services Patient Metrics Referrals

Formula: Sales - Referrals
Report codes used: SAL.REF

Still need help?
Get in touch!