Back to Blog
Budget Management8 min readFebruary 18, 2026

How to Track Spending Against PPD Budgets in Real-Time

Per-patient-day budgets are the financial backbone of skilled nursing and assisted living operations. Here's a practical guide to tracking PPD spending in real-time — and why census fluctuations make static spreadsheets dangerously unreliable.

Why PPD Budgeting Is Uniquely Complex in Long-Term Care

Every business has a budget. But long-term care facilities have a budget that moves.

Per-patient-day (PPD) budgeting links your spending directly to occupancy — how much you're allowed to spend per day, per resident, across every department. When census drops from 95 to 78 residents in a single month, your supply budget doesn't just stay the same. It should flex downward. And when census rises, it should give you permission to spend more to meet resident needs.

This is fundamentally different from how most industries budget. In hospitality, in manufacturing, in retail — budgets are set annually and tracked against fixed targets. In long-term care, your budget is a moving target tied to a number that changes every single day.

Most facilities manage this with spreadsheets. And most facilities are consistently flying blind as a result.


The Problem With Static Spreadsheets

Here's what happens at the typical skilled nursing facility at month-end:

The administrator or controller pulls spending reports from the accounting system, calculates the average census for the month, and checks whether each department came in over or under their PPD target.

If they're over, there's a conversation. Maybe a correction for next month. Maybe not.

The problem: that conversation is happening 30 days too late. By the time the month-end report surfaces the variance, the overspending has already happened. There's nothing to be done except absorb the cost and hope next month is better.

Static spreadsheet budgeting is lagging. It tells you what already happened. What long-term care administrators actually need is a system that tells them what's happening right now — and alerts them before they blow through their PPD limits.


What Real-Time PPD Tracking Actually Looks Like

Real-time PPD tracking has three core components:

1. Live Census Integration

Your PPD budget is meaningless without an accurate, current census figure. The best procurement platforms integrate directly with your EHR system — PointClickCare, MatrixCare — and pull the daily census automatically. No manual entry. No lag.

When census drops on Monday, the system knows. When three new residents admit on Thursday, it updates. Your daily spending limits recalculate automatically, based on actual occupancy data, not last month's average.

2. Real-Time Purchase Tracking

Every purchase request, purchase order, and approved invoice should feed directly into your PPD tracker as it happens. Not at month-end. Not when the invoice is paid. When the purchase is made.

This means when the dietary manager submits a food order on Tuesday afternoon, your PPD tracker shows you immediately: where you are against the food PPD target for this month, with this census, with this many days remaining in the period.

If the order would push you over your PPD limit, the system can flag it before it's approved — not after it's paid.

3. Alerts and Thresholds

The value of real-time data multiplies when it's paired with proactive alerts. Set a threshold — say, 80% of PPD budget consumed by day 20 of the month — and the system notifies the department head and the administrator automatically. No one has to check a dashboard. The warning comes to them.

This shifts the entire procurement conversation from reactive to proactive. Instead of explaining why the dietary department overspent last month, the administrator and dietary manager are having a conversation on day 20 about how to manage the remaining spend through day 30.


Department-by-Department PPD Targets

PPD tracking works differently across departments. Here's how sophisticated LTC operators typically set it up:

Dietary / Food Service

  • Typically the largest PPD category (often $8–12 PPD depending on care model)
  • Tracks meal ingredients, supplements, enteral nutrition, disposables
  • Census sensitivity is high — food costs scale almost directly with resident count

Nursing Supplies

  • Includes wound care, incontinence supplies, gloves, PPE
  • Acuity-adjusted facilities may weight nursing PPD by resident care level
  • Census sensitivity is high but acuity matters more than raw headcount

Housekeeping and Laundry

  • More fixed than variable — some supplies don't scale linearly with census
  • Usually smaller PPD target but easier to control

Activities and Recreation

  • Smaller budget but important for quality ratings
  • Census sensitivity is moderate

Maintenance

  • Mostly fixed costs — equipment, small repairs
  • Less census-sensitive, but still tracked per PPD for consistency

Ancillary Charges

  • Medical supplies charged to residents — oxygen, therapy supplies
  • These may be directly billable; procurement system should flag chargeable items

Building Your PPD Tracking System

If you're starting from scratch, here's the practical path:

Step 1: Establish your PPD targets by department

Work with your administrator and controller to set monthly PPD targets for each department. Use last year's actual spend (normalized for census) as a baseline. Benchmark against industry averages: AHCA publishes cost data by facility type that can validate whether your targets are reasonable.

Step 2: Integrate your census data

If you're managing census manually, even a simple daily census log is better than using monthly averages. Ideally, connect your EHR directly to your procurement system so census updates flow automatically.

Step 3: Require all purchases to flow through the system

PPD tracking only works if it sees all the spending. Maverick purchasing — staff buying off-system — destroys your visibility. This means getting buy-in from department heads that all purchases, without exception, go through the procurement platform.

Step 4: Set alert thresholds

Don't wait for month-end reports. Set alerts at 70% and 90% of PPD budget for each department, so variances surface in real time.

Step 5: Review weekly, not monthly

A weekly 15-minute review of PPD status by department — ideally Monday mornings — catches problems with three weeks left in the month instead of zero.


The Technology Question

Can you do all of this in Excel? Technically, yes. Practically, no.

Manual census tracking, manual purchase entry, manual variance calculation, manual alert monitoring — the labor cost of maintaining a real-time PPD tracker in spreadsheets almost certainly exceeds the cost of a proper procurement platform. And the spreadsheet breaks down the moment a department head goes on vacation or the census data doesn't get updated for three days.

Modern LTC procurement platforms like Adelpo do all of this automatically: live PointClickCare and MatrixCare integration, real-time spend tracking against PPD targets, automated alerts, and department-level dashboards that give every manager visibility into their own budget without requiring a call to the controller.


The Bottom Line

Long-term care facilities that implement real-time PPD tracking consistently report the same outcome: they stop being surprised by month-end variances and start managing proactively. For most facilities, that shift from reactive to proactive budget management is worth $20,000–$60,000 per year in avoided overspend.

The data has always existed. The question is whether you're seeing it in time to act on it.

If you'd like to see how Adelpo's live census integration and real-time PPD dashboards work in practice, book a 15-minute demo with our team.

Ready to See Adelpo in Action?

Book a 15-minute demo and we'll show you how Adelpo can reduce costs and automate procurement at your facility.

Book a Free Demo