← All prebuilt solutions
Industry

Dental & Veterinary Practice KPIs

Clinicians, utilisation, NHS UDAs, plans, costs, EBITDA and an illustrative valuation for dental and veterinary practices

£20

Secure checkout. Your download link is sent as soon as payment clears.

Dental & Veterinary Practice KPIs

Overview

A practice's profit depends on a handful of numbers: how full each clinician's book is, what each clinical hour earns, what clinicians, nurses, labs and materials cost as a share of income – and, for NHS dental practices, whether the contract will be delivered. This workbook brings those numbers together. You record each clinician's month on the Activity Log, enter income and costs, and the workbook works out clinician pay and contribution, utilisation, fees per hour, new and returning patients, failed appointments, NHS UDA delivery and clawback risk, plan income, EBITDA, EBITDA per surgery and an illustrative valuation.

Price
£20
Who it’s for
Industry
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Clinicians

Pay terms and year-to-date fees, UDAs, utilisation, cost, net contribution, fees per hour, patients, failed appointments and status. What you do: keep the yellow columns up to date.

Clinicians
Activity Log

Step 2

Activity Log

One row per clinician per month – the source of all productivity figures and clinician pay. What you do: add rows each month.

Step 3

Income

Income by stream each month, plus NHS and plan income brought in. What you do: enter the six fee-paying streams.

Income
NHS Contract

Step 4

NHS Contract

Contract value, UDA value, courses by band, cumulative UDAs v target, year-end projection, clawback and patient charges. What you do: enter band counts monthly (dental only).

Who it is for

Made for people like you

  • Example – text
  • Dental practice owners and managers – NHS contract tracking (UDAs by band, year-end projection, clawback risk), associate pay and private / plan income in one place.
  • Veterinary practice owners and clinical directors – Consult, procedure, medicine and pet health plan income with vet and nurse productivity and payroll %.
  • Practice groups and buyers – Comparable KPIs, EBITDA per surgery and an EBITDA-multiple valuation with the usual buyer adjustments.
  • Accountants and advisers – A monthly management pack that ties clinician activity to the practice P&L.

Quick start

Up and running in minutes

  1. Example – text
  1. Setup – Choose Dental or Veterinary, enter the financial year start (1 April for NHS dental), the reporting month, the tax year, the number of surgeries or consulting rooms, opening hours and your targets. Check the income stream names and clinician roles.
  2. Clinicians – List every clinician with their role, room and pay terms – associate %, lab fee share and NHS UDA rate for associates, salary for salaried staff, hourly rate for hourly-paid hygienists or locums, or 'Owner (no pay)'.
  3. Activity Log – Each month add one row per clinician: clinical hours, hours booked, appointments, patients seen, new patients, failed appointments, fees generated, NHS UDAs and lab fees – from your practice management software reports.
  4. Income and Costs – Enter the month's income by stream and the practice costs. Clinician pay, lab fees and plan costs are brought in automatically.
  5. NHS Contract (dental) – Enter the contract value and UDA target once, then each month's courses of treatment by band.
  6. Plans – Enter plan fees and charges once, then the number of members at each month end.
  7. Read the results – Move the reporting month on Setup and read the Dashboard, Performance and NHS Contract sheets. Use Valuation when planning a sale, purchase or investment.

Key features

  • Practice type selector – dental or veterinary – that relabels income streams, plans and reports; up to 25 clinicians on associate %, salary, hourly or owner terms.
  • Monthly activity log for every clinician: hours, bookings, patients, new patients, failed appointments, fees, NHS UDAs and lab fees – with utilisation, fees per hour, pay and net contribution.
  • NHS dental contract tracker: UDA value, courses by band, cumulative delivery, year-end projection, 96% clawback risk and patient charges; membership or pet health plan income.
  • Monthly income, costs, EBITDA and KPIs against targets – materials & lab %, payroll %, room utilisation, EBITDA per surgery – and an illustrative EBITDA-multiple valuation.

What’s included

  • Dashboard – Everything at a glance
  • Setup – Practice type, targets, streams, roles
  • Clinicians – Pay terms and year-to-date KPIs
  • Activity Log – Monthly activity by clinician
  • Income – Income by stream
  • NHS Contract – UDAs, projection and clawback
  • Plans – Membership / pet health plans
  • Costs – Practice costs by month
  • Performance – Monthly P&L and KPIs v targets
  • Valuation – Illustrative value from EBITDA
  • Tax Rates – Employer NI and pension rates
  • Guide – How to use this workbook

How buying works

Your file is only released once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your download link arrives as soon as payment clears.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions