Reconciling NHS Compass Schedules in Your Dental Practice Accounts

NHS revenue is the largest single income stream for most mixed UK dental practices, and it is also the income stream most often left unreconciled month by month. The NHS Business Services Authority pays a contracted monthly sum, with adjustments for superannuation, clawback, and other items, while NHS Compass reports the underlying UDA delivery, FP17 claim status, and orthodontic activity that supports the payment. The two views need to be brought together against the practice accounting ledger every month if the principal is to know, in real time, whether the contract is being delivered and whether the bank receipts match the work being done.

This piece walks the data sources, the reconciliation steps, the common variances, and the controls that catch problems before year end. The hub pillar NHS vs private revenue accounting sets the wider context, and the sister piece on tracking Units of Dental Activity goes deeper on the UDA performance side of the same monthly review.

What NHS Compass actually reports

NHS Compass is the online service the NHS BSA provides to practices, contract holders, performers, and authorised users. For a dental contract holder it reports UDA delivery by performer and by month, FP17 claims submitted and their status, ortho UOA delivery where applicable, and the underlying detail that feeds the BSA pay statement. The reports are typically available a month or two after the activity, which is why a careful monthly reconciliation rather than a year-end one is the only way to catch issues while there is still time to recover.

Compass is the source of truth for performer-level activity. The BSA pay statement is the source of truth for the cash received. The accounting ledger is the source of truth for what the practice has recognised as revenue. The reconciliation is the discipline of bringing those three together each month and explaining every gap.

The three data sources for the reconciliation

Step one: agree the contract monthly value to the pay statement

The starting point is the headline contract value paid monthly. The annual contract value is divided into twelve monthly instalments by the BSA, with the gross figure shown on the pay statement before deductions. The reconciliation confirms that the gross monthly figure shown on the statement matches the contracted twelfth of the annual value, that the bank receipt agrees to the net of the statement, and that any one-off adjustments (a contract variation, a backdated change, a midyear reprice) have been processed correctly.

Step two: explain every deduction on the pay statement

The net BSA payment is the gross contract twelfth less a series of deductions. The common deductions are NHS superannuation contributions for the contract holder and each performer, a levy or charge specific to certain contract types, and any clawback or recovery from a prior period. Each deduction has to be traced to its source: superannuation against the performer's NHS pension contributions for the period, clawback against the underdelivery notice or the prior-year reconciliation. Lumping the deductions together and treating the net figure as monthly NHS income hides the detail that the practice needs to manage the contract.

It is also where common posting errors arise. Superannuation deducted by the BSA is the performer's pension contribution, not a practice expense; treating it as a practice cost overstates expenses and understates the performer's NHS earnings. A small bookkeeping discipline here saves a large query at year end.

Step three: tie Compass UDA delivery to the cumulative contract position

Each month, the Compass UDA delivery for the period should be added to the cumulative year-to-date delivery and compared to the contract pro-rata. A contract of 12,000 UDAs and a delivery month that brings the year-to-date to month seven of the year should sit close to seven twelfths of the annual figure. A material gap, in either direction, should prompt management action: a planning conversation with the performer if delivery is lagging, a cash-flow plan if overdelivery is heading toward the cap with limited credit available.

Year-end clawback for underdelivery is one of the most painful financial events for a practice. It is also one of the most preventable, in that the monthly Compass review tells the principal months in advance whether the contract is on track. The reconciliation is not a finance exercise alone; it is a clinical and operational signal that drives the rota, the recall system, and the management of associate productivity through the year.

Step four: reconcile FP17 claim status

FP17 claims sit in different states in Compass: submitted, validated, paid, rejected, returned for query. A claim that has been submitted but rejected does not generate UDA credit or payment. A claim returned for query needs a clinician or practice manager to address the query inside the BSA's response window. The monthly reconciliation should include a review of the FP17 status summary and a workflow for any items that are not in the paid state.

A backlog of rejected or returned FP17 claims is one of the quiet ways UDA delivery slips. The clinical work has been done; the recognition is held up by an administrative point. Clearing the queue monthly is the only way to prevent the backlog from becoming the year-end gap.

Step five: post to the ledger with the right cut-off

NHS revenue is recognised in the accounting ledger on the accrual basis as the activity is delivered, not when the BSA cash is received. The cleanest treatment is to recognise the contracted monthly twelfth of NHS revenue each month, adjust for any over or under delivery indicated by the cumulative Compass position, and post the BSA cash receipt to a control account that is reconciled to the recognised revenue. At year end, the control account closes against the year-end clawback or overdelivery uplift, and the revenue figure in the accounts reflects what the practice actually delivered rather than what the BSA happened to pay in the financial year.

For practices reporting on the cash basis, the timing differs, but the discipline of distinguishing the cash receipt from the activity remains useful for management purposes even where the statutory accounts follow a cash measurement.

Common variances and what they usually mean

• Net BSA cash is less than the contract twelfth: usually a higher superannuation deduction following a pay change.
• Cumulative UDA delivery lags pro-rata by more than a few percent at midyear: rota or productivity issue worth raising now.
• A persistent number of FP17 claims sit in rejected status: administrative workflow issue, not a delivery issue.
• Compass delivery exceeds pro-rata significantly: contract is heading toward the cap; clinical capacity needs managing.
• A clawback line appears unexpectedly on the pay statement: open the supporting Compass notice and trace to source.
• Performer NHS earnings on Compass do not match the practice's associate pay calculation: usually a percentage-of-UDA-rate change applied at the wrong cut-off.

Why the reconciliation is harder than it sounds

The reports lag, the formats differ between the Compass screens and the BSA statement PDFs, the deductions interact with one another, and the underlying contract data sits across several systems. A practice manager spending a focused half day each month on the reconciliation is doing real work, and the value of that work shows up in the absence of year-end surprises. Treating the reconciliation as a chore to be skipped when busy is exactly how the year-end clawback arrives unannounced.

Mid-year contract reconciliation

In addition to the monthly review, the BSA produces a mid-year contract reconciliation that summarises delivery against the contracted level and indicates the expected year-end position based on the run rate. The mid-year position is the natural management point at which to take recovery action if delivery is lagging: a temporary uplift in associate sessions, an open-day-style recall push, or a frank conversation with a performer who has fallen behind on personal UDA delivery. Leaving the response until the year-end notice arrives compresses the available time and forces harsher decisions.

Practical controls that protect the reconciliation

• A standing monthly diary entry for the reconciliation in the practice manager's calendar.
• A control account in the accounting software for BSA payments and deductions, with monthly clear-down.
• A monthly performer schedule of Compass UDA delivery shared with each performer.
• A simple workflow for FP17 claims in rejected or returned status, with a named owner.
• A documented method for recognising NHS revenue (contracted twelfth or actual delivery) consistent year on year.
• A year-end checklist that ties the recognised revenue to the BSA year-end statement and Compass year-end position.

When to seek specialist help

A new contract holder, a contract variation, a performer change, a clawback notice, or the first sign of a material delivery gap are all triggers for specialist advice. A dental accountant who has reconciled hundreds of contracts can read a BSA statement and a Compass report in minutes, spot the line that does not look right, and tell the principal whether the practice is in trouble or whether the variance is normal noise. The cost of the conversation is consistently lower than the cost of the surprise.

How an accountant adds value here

A specialist dental accountant sets up the control account structure, codes the BSA statement deductions correctly each month, supports the practice manager on the FP17 status workflow, and signs off the year-end reconciliation against statutory accounts. For a principal whose attention belongs in the surgery rather than the spreadsheet, the value is a monthly reassurance that the largest income stream is on track and a year-end position with no surprises.