Hospice Volunteer Program 5 Percent Requirement Tracking Sheet

Your volunteers have to provide at least 5% of your total patient care hours. Not roughly 5%. Not "we have a great volunteer program, so we're probably fine." Five percent, calculated against paid staff hours, documented, and ready to hand to a surveyor. It's one of the few Conditions of Participation you can fail purely on arithmetic. Your volunteers can be trained, screened, supervised, and genuinely valued by your patients, and you can still walk away with a standard-level deficiency because nobody added up the numbers.

Here's the complication. That requirement was waived during the public health emergency. It came back on January 1, 2024. If your agency paused tracking during the waiver, or never got a clean system running again, you're not alone. But "not alone" doesn't help you in a survey. And even agencies that did keep tracking often trip over a second problem: the 5% ratio and the cost savings documentation are two different regulatory requirements. One is 418.78(e), the pass/fail level-of-activity number. The other is 418.78(d), which requires you to show what position each volunteer occupied, how much time they spent, and what it would have cost you to pay someone to do that work instead. Satisfying one does not satisfy the other. Plenty of agencies find that out the hard way, mid-survey, when a surveyor asks for the document they don't have.

So the question is simple: how do you track this all year, catch a shortfall before December, and walk into a survey with both documents already built — without hand-building a tracking system from scratch or hoping your memory of "we're probably around 5%" holds up under questioning?

Here's the answer. The Hospice Volunteer Program 5 Percent Requirement Tracking Sheet is a 12-tab Excel workbook that performs three related tasks from a single set of entries. First, it logs hours from your volunteers and your paid patient-care staff in two separate logs. Second, it calculates your ratio automatically, month by month and year-to-date, with a stoplight dashboard: green at 5.0% and above, yellow between 4.0% and 4.99%, red below 4.0%. You see a drift coming in March instead of discovering it in your December cost report. Third, it builds both documents a surveyor actually asks for, straight from that same data: your 418.78(e) level-of-activity calculation and your 418.78(d) cost savings report, side by side, so you're never scrambling to reverse-engineer one from the other.

A few things about how it's built matter here too. Every formula tab is password-protected, so a volunteer coordinator entering hours can't accidentally overwrite a calculation. There are no macros, so it won't get flagged or blocked by your agency's or hospital's IT security the way a macro-enabled file often does. It imports cleanly into Google Sheets if that's what your team uses. And it comes with a Quick-Start Guide that walks you through setup, what counts toward the 5% and what doesn't, and three worked examples with real numbers so you're not guessing at how to log your first entry.

This isn't a spreadsheet someone built once and forgot to update for the current regulation. It's built around the actual text of 42 CFR 418.78(d) and (e), and the January 2024 restart that many agencies are still catching up on.

If you're the person who finds out about a volunteer ratio problem during survey prep instead of in January when there was still time to recruit, this is built for you. If you've ever handed a surveyor your hours log and gotten a follow-up question about cost savings you weren't ready for, this is built for you too.

Click the buy button below to get the workbook and the Quick-Start Guide, and start this month's tracking with a system that's already doing the math for you.