NHS QUESTIONS

How Is Hospital Bed Occupancy Calculated in NHS Reports?

To calculate bed occupancy, divide the number of beds in use by the number of available beds and multiply by 100. At a morning huddle, 22 of 24 beds are in use. That’s 91.7%.

For the quarterly NHS England return, add up occupied and available bed days across the quarter before dividing. The huddle tells you what’s happening that morning. The quarterly figure shows how much of the available capacity was used over the period.

  
Start with the two counts

Check which beds are available

Start with the beds open for the service you’re reporting on. The available count includes beds already in use as well as empty beds that are open and staffed. In the huddle example, all 24 beds are open. Of those, 22 are occupied and two are empty.

For the quarterly Bed Availability and Occupancy return (KH03), NHS England counts eligible staffed, consultant-led beds for NHS patients. Closed beds are excluded, even if they could reopen at short notice. The KH03 definitions set out which beds to include.

Match the group of beds

Use occupied and available counts for the same group. KH03 collects available bed days by sector, such as general and acute. An empty bed in that sector may be available to several specialties.

  
Check the time

Why the huddle and the return can differ

Take another count on the same ward that night. At midnight, 20 of its 24 open beds are occupied, giving 83.3%. The morning huddle showed 91.7%. Both figures describe that ward at different times.

The national Urgent and Emergency Care Daily Situation Report (SitRep) uses an 8am snapshot for general and acute beds. For wards open overnight, KH03 counts an occupied bed day when the bed is occupied at midnight. If your own huddle runs at another time, label your figure with the time it actually represents.

Day-only wards use a different rule

In KH03, a day-only bed counts as occupied for that day if it was used for care. If two patients use that same bed during the day, it still contributes one occupied bed day.

  
Add up the bed days

Calculate occupancy across the reporting period

Now take two nights on the example ward. On the first night, all 24 beds are available and 20 are occupied at midnight. On the second night, four beds are closed, leaving 20 available, and 18 are occupied at midnight.

Two nights on the same ward
NightOccupied bed daysAvailable bed days
First2024
Second1820
Total3844

Divide 38 occupied bed days by 44 available bed days and multiply by 100. That gives 86.4% for the two nights. For the quarterly return, apply the same calculation to the full quarter. Add the bed days before you calculate the percentage. If you average the two nightly percentages, you get 86.7%. That gives the 20-bed night as much weight as the 24-bed night. Use 38 occupied bed days out of 44 available for the period.

Keep the counts beside the rate

When capacity changes, the percentage can move even if the occupied count falls. With both counts visible, the team can see what changed.

  
Make the figure easy to read

Show what each percentage describes

On an operational dashboard, label the huddle snapshot with the ward or site, the count time and the two figures behind the percentage. On a quarterly view, show the sector, bed type and dates covered. A reader should be able to tell what they’re comparing without opening a separate report.

If you use IntelliFront BI, an approved reporting dataset can supply separate views for the huddle snapshot and the longer trend. Keep the date and time of the bed count visible alongside any dashboard refresh time, so the team knows which figures it is looking at.

What to check when two figures differ
  • Do both figures cover the same ward, site or sector?
  • Do they include the same types of beds?
  • Do they describe the same point in time or reporting period?
  • Were any beds closed, or are any counts missing?

Flag missing counts

If either count is missing or the available count is zero, flag the reason and leave the percentage blank. Zero occupancy means the beds were available and none were in use.

  
Your next step

Try the calculation with one ward

Take a recent huddle count and a midnight count for the same ward. Recalculate each percentage from the two counts. If the figures differ, check whether bed availability, occupancy or both changed between counts.

If you’re evaluating IntelliFront BI, use the guide to plan how to show the counts behind each percentage. The NHS pharmacy reporting evaluation shows how to test a reporting figure against a source record your team knows.

Download the IntelliFront BI Internal Evaluation Guide

Contributors:

Christian Ofori-Boateng

Christian Ofori-Boateng

CEO, ChristianSteven Software