Practice Financial Dashboard

A one-page practice dashboard built on clean definitions: revenue per professional, utilisation, collection rate, overheads and profit per partner, refreshed monthly and reviewed with the partners so every red number gets an owner.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Then open the Marketplace in the app, search for Practice Financial Dashboard, and click Install. It goes into your own files, and works offline from then on.

Before you start: this plan is general information to help you organise decisions about money. It is not financial, investment, tax or legal advice, and it does not recommend any product, investment or deal. Rules differ between countries, so check decisions that matter with a qualified, licensed adviser in yours. Investing and trading can lose money, and raising or managing other people's money is regulated in most countries.

What it installs.

1

Pillar

1

Area

50

Projects

200

Starter tasks

🔑 Professional Practice Ownership

Practice Financial Dashboard

Watching the numbers of a practice: revenue per professional, utilisation, collection rate, overheads, profit per partner and a monthly review.

  1. Chart of accounts mapped to dashboard lines
  2. Choosing the twelve practice KPIs
  3. Source data inventory for every KPI
  4. Twelve-month KPI baseline
  5. Revenue attribution rules by professional and service
  6. Capacity hours for each professional
  7. Overhead classification into fixed, variable and people costs
  8. Market cost of the owner's professional work
  9. Choosing the dashboard tool
  10. First one-page practice dashboard
  11. Monthly dashboard refresh after the close
  12. Monthly partners' financial review
  13. Monday flash report
  14. Budget versus actual variance tracking
  15. Rolling twelve-month revenue forecast
  16. Quarterly KPI targets review
  17. Data quality checks before each refresh
  18. Annual budget built from dashboard drivers
  19. Quarterly overhead line review
  20. KPI action log with named owners
  21. Reading a practice profit and loss statement
  22. Utilisation, realisation and collection chain
  23. Contribution margin by service line
  24. Break-even revenue and fixed cost cover
  25. Cash basis versus accrual basis in practice numbers
  26. Spreadsheet skills for maintaining the dashboard
  27. Presenting the numbers to partners
  28. Leading indicators for future revenue
  29. Traffic light thresholds for every KPI
  30. Automating data feeds into the dashboard
  31. Profit per partner reporting
  32. Cost per appointment or chargeable hour
  33. Staff cost ratio target
  34. Service line keep, reprice or drop decision
  35. Pruning measures nobody uses
  36. Dashboard access and confidentiality rules
  37. Year-end dashboard review and annual summary
  38. Lender and covenant reporting pack
  39. Financial briefing for the partner retreat
  40. Dashboard walk-through with the external accountant
  41. Mid-year reforecast
  42. Five-number dashboard for a sole practitioner
  43. Clinic dashboard for room, chair and appointment use
  44. Fee earner dashboard for law and accounting firms
  45. Project margin dashboard for design and engineering studios
  46. First-year dashboard for a new practice
  47. Multi-site comparison dashboard
  48. Benchmarking against peer practice surveys
  49. Unit economics of the next professional hire
  50. Driver-based model and scenario planning

Where it starts.

Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.

Chart of accounts mapped to dashboard lines

Most practice ledgers grew one nominal code at a time, so wages for professionals sit beside reception pay and lab fees are mixed into general supplies.

First tasks

  • Export the latest trial balance from the accounting system
  • Draft a list of no more than ten dashboard lines for the practice
  • Assign every nominal code to one dashboard line in a mapping tab
  • Review the mixed codes with the bookkeeper and agree how to split them

Choosing the twelve practice KPIs

A dashboard with forty numbers gets glanced at and ignored; one with twelve gets discussed. Choosing a fixed set that covers volume, price, capacity, cash and cost, such as revenue per professional, utilisation, collection rate, overhead ratio and profit per partner, gives the partners a shared language before any spreadsheet is built.

First tasks

  • Ask each partner which three numbers they check first when worried
  • Group the suggestions into volume, price, capacity, cash and cost
  • Write a one-line definition and formula for each shortlisted KPI
  • Put the final twelve to the partners for sign-off

Source data inventory for every KPI

Each KPI draws on a different system: fees from the accounting package, hours or appointments from the practice software, headcount from payroll, receipts from the bank. Listing where each input lives, who can export it and when it is final stops the monthly refresh from stalling while someone hunts for a report.

First tasks

  • List every input each of the twelve KPIs needs
  • Find the report in each system that produces that input
  • Agree with each data owner the day their figure is final
  • Note the inputs no system captures and propose a fix for each

Make it yours.

Install Practice Financial Dashboard, then tell Aurum the date you're aiming for. It checks whether the plan fits the weeks you actually have.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Blueprints are general information to help you organise your own work. They are not medical, financial, legal or other professional advice. See the Terms.