Blog
Hospital Dashboards: Bed Occupancy, Length of Stay and Revenue
A plain guide for hospital directors to the dashboards that matter: bed occupancy, length of stay and revenue per department, and how to build them.
- mid
- hospital
The short answer
A useful hospital dashboard is not a wall of charts. For most Indonesian private hospitals, three numbers carry most of the weight: bed occupancy, length of stay and revenue (and cost) per department. Get those three right, from clean and timely data, and a director can see in a few minutes where capacity is tight, where patients are staying longer than expected, and which departments actually earn their keep.
The hard part is rarely the chart. It is agreeing on definitions, getting data out of separate systems, and making sure everyone trusts the numbers. This article covers what each metric means, what goes wrong, and when it is worth getting help.
Bed occupancy: how full are we?
Bed occupancy (BOR in Indonesian hospital reporting) describes the share of available beds that are in use over a period. The common calculation is occupied bed-days divided by available bed-days, multiplied by 100. Some sources describe it simply as beds used divided by beds available, so always write down which version your hospital uses.
In Indonesian practice you will often see a “good” range of roughly 60 to 85 percent cited in hospital-management references. We could not trace it to a primary document, and some studies quote different reference values. Treat it as a rule of thumb, not a target, and set your own range based on hospital type and case mix.
What to watch for:
- What counts as an available bed. Beds closed for renovation, isolation or staffing shortages should be handled consistently. Otherwise occupancy looks better or worse than reality.
- Ward-level detail. A hospital-wide 70 percent can hide a full ICU and an empty VIP wing. Break it down by ward and class.
- Timing. A midnight census and a daily average tell different stories. Pick one and stick to it.
Length of stay: how long do patients remain?
Average length of stay (ALOS) is the average number of days inpatients spend in the hospital. Two common ways to calculate it exist: total inpatient days divided by discharges, or average occupied beds times days in the period divided by discharges, with deaths counted alongside discharges (this second form is the one used in the NHS Wales data dictionary). Again, the point is to pick one definition and document it.
A few practical notes:
- A single hospital-wide ALOS is a blunt tool. Compare like with like: stays by department, by doctor group or by type of case, rather than one blended number.
- ALOS interacts with occupancy. If stays get longer and admissions stay the same, occupancy rises. Looking at the two together explains more than either alone.
- Long stays have many causes, including administrative delays such as slow discharge paperwork, pending billing approval or waiting on results. A dashboard can show where the delay is. Deciding whether a stay is clinically appropriate is a medical judgement, not something a dashboard should decide.
Related indicators often reported alongside these two are turnover interval (TOI, how long a bed sits empty between patients) and bed turnover (BTO, how many patients use a bed per year). Indonesian hospital-management references list all four together, with reference ranges that vary by source, so check before you set targets.
Revenue per department: who earns what?
This is where many hospitals struggle, because it needs data from billing, pharmacy, inventory and sometimes payroll, not just the clinical side.
A meaningful view includes:
- Revenue by department (outpatient, inpatient, emergency, laboratory, radiology, pharmacy, procedures).
- Revenue by payer type, such as self-pay, private insurance and corporate accounts, because collection speed and discount patterns differ.
- Direct costs against that revenue where you can, so you see contribution and not just billing volume.
- Receivables ageing, because revenue that is billed but not collected is not cash.
Revenue-only dashboards can mislead. A department with high billing but heavy consumable costs, discounts or slow-paying payers may contribute less than a smaller, cleaner one. If you can only build one extra thing, make it contribution per department rather than gross revenue.
What usually goes wrong
- Different definitions in different heads. Finance, nursing and management each calculate occupancy slightly differently, and meetings turn into arguments about numbers.
- Manual spreadsheets. Someone compiles figures from three systems every month. The numbers are late, and errors creep in.
- Data entry gaps. Admission and discharge times entered late or not at all will quietly corrupt both occupancy and ALOS.
- Too many metrics. Thirty KPIs means none are acted on. Start with a handful and add only when someone will use the answer.
- No owner. If nobody is responsible for each number, nobody fixes it when it looks wrong.
Where the data lives, and the Odoo question
Dashboards are only as good as the systems feeding them. Bed and admission data typically sits in the hospital management system, while finance, purchasing, inventory and HR often sit in an accounting or ERP platform.
If you use or are considering Odoo for the business side, its analytic accounting feature is designed for tracking costs and revenue along dimensions such as projects or departments. Odoo’s documentation notes that you would set up an analytic plan for departments, create an account per department, and assign costs and revenue to them, optionally by percentage. That maps reasonably well to department-level contribution reporting. It does not, by itself, know about beds or admissions; that data has to come from the hospital system.
So the realistic setup is often two parts: a hospital management system for beds, admissions and clinical-operational flow, and Odoo for finance, procurement, inventory and HR, with the two connected so one dashboard can draw on both. Whether you buy ready-made, build custom or combine the two depends on how different your workflows are and how much reporting flexibility you need. Our own clinic and hospital management systems exist for this reason, and the hospital product can integrate with Odoo.
Practical steps
- Write down one-line definitions for each metric and get sign-off from finance, nursing and management.
- Start with five to eight indicators, each with a named owner.
- Decide the refresh rhythm: daily for occupancy, weekly or monthly for department revenue.
- Check data entry discipline before building anything fancy.
- Pilot with one or two wards or departments before rolling out.
- Make sure access is restricted sensibly. Revenue and patient-level data should not be visible to everyone. Under Indonesia’s personal data protection law (UU PDP, Law No. 27 of 2022), health data deserves careful handling; this is general information, not legal advice, so check the primary text with your counsel.
When to get help
Consider outside help if your numbers come from three or more systems, if management disputes the figures every month, or if building a dashboard keeps being postponed because nobody has time to compile the data. A short scoping exercise to agree definitions and map data sources often saves more than the dashboard itself costs.
If you want to talk it through, Teknologia Solutions is happy to have a no-charge conversation about your reporting needs and what a sensible first dashboard would look like for your hospital.
Sources: NHS Wales Data Dictionary, Average Length of Stay; Medminutes, BOR, LOS dan ALOS Rumah Sakit; Odoo 18 documentation, Analytic accounting. Reference ranges for hospital indicators vary between sources and this article is general information. Please verify definitions, targets and legal points against primary sources.