Most administrators know agency staffing costs more than employed staff. Fewer can say, on any given day, exactly how much more, which units or shifts drive it, or whether the trend is improving. The reason is usually simple: the data lives in two places that never meet. Invoices sit with accounting. Shift schedules and call-offs sit with nursing and staffing coordinators.
Bringing those together does not require an expensive analytics platform. A spreadsheet or a lightweight dashboard tool, fed with consistent data, can show the true cost of contract labor and, more importantly, what is behind it.
Before building anything, decide what you want to know. Good questions for a skilled nursing or senior-living operator include:
How many agency hours did we use last week, by role and by unit or hall?
What is our all-in cost per agency hour, compared with an employed hour?
Which shifts are most often filled by agency staff, such as nights or weekends?
Are agency hours rising or falling over time?
How much of our agency use traces to open positions versus call-offs?
From each agency invoice, capture:
Invoice date and pay period covered.
Role or credential, such as CNA, LPN or RN.
Hours billed, split between regular and overtime or premium rates where the invoice shows them.
Bill rate and total charged.
Any added fees, such as holiday premiums or minimum-shift charges.
From your scheduling or timekeeping system, capture:
The shift date, start and end time, unit, and role.
Whether the shift was filled by employed staff, agency staff or left uncovered.
The reason the shift opened, if recorded: vacancy, call-off, leave or census increase.
Do not worry about perfect data. A consistent export every week beats a perfect one done twice a year.
The trick is a common key. Use pay period, role and unit, if possible. Compare hours billed by the agency with hours the schedule shows as agency-covered. Differences deserve a conversation: they may reveal billing errors, unrecorded shifts or timing differences.
This reconciliation alone often pays for the effort, because it catches duplicate charges and hours that were billed but not worked as scheduled. Treat that as an audit step, not an accusation, and discuss differences with the agency calmly and with documentation.
Keep it to one page that an administrator can read in a minute.
Agency hours and cost this period versus the last few periods. A simple line or bar chart is enough.
All-in cost per hour by role. Include premiums and fees, and compare to the loaded cost of an employed hour, including benefits and payroll taxes.
Agency use by shift type and unit. This shows where the real pressure is.
Reason for opening. If most agency hours come from vacancies, recruiting is the lever. If they come from call-offs, scheduling and retention are.
Open positions and days open. Tie hiring effort to dollars.
A dashboard is only worth building if it changes behavior. Some ways to use it:
Review it in a weekly staffing meeting with the DON, administrator and business office manager.
Set a target, such as reducing agency hours on one unit, and track progress openly.
Evaluate whether a shift differential, a float pool or a pickup bonus for employed staff would cost less than the agency premium.
Use the data in rate negotiations with agencies, and to decide whether to reduce the number of agencies you use.
For example, a facility might discover that most of its agency hours cluster on weekend nights on one hall. That points to a targeted fix, such as an incentive for weekend shifts, rather than a broad hiring push.
Staffing records can include employee names and pay information. Limit who can see detailed data, and consider reporting on role and unit rather than individuals. Keep files in a secured, access-controlled location, not on a shared desktop.
UnityCare IT helps healthcare operators connect scheduling, payroll and accounting exports into simple, reliable dashboards. If your agency spend is a mystery until month-end, a clean data pipeline is usually the first step toward controlling it.
An outsourced IT department with proactive maintenance and one number to call.
Call or text: 405-285-3845
New customers: start@unitycareit.com
Existing customers: support@unitycareit.com
Address: UnityCare Technologies, 2524 N Broadway Ste 554, PMB 947974, Edmond, Oklahoma 73034-4172