13-Month Bereavement Tracking Spreadsheet: Milestone Calls, Scripts, and Anniversary Follow-Up
Why a Spreadsheet Still Matters Even With an EHR
Most hospice agencies have an electronic health record system with bereavement tracking modules. Most of those modules are designed for charting, not for operational scheduling. The EHR captures what happened — the clinical note, the assessment score, the contact documentation. But it rarely provides the forward-looking operational view that a bereavement coordinator needs on Monday morning: who is due for a milestone call this week, who just hit the six-month mark, who has a death anniversary approaching, and whose chart will be flagged in the next audit cycle.
That operational layer — the master view across your entire active caseload — is what a tracking spreadsheet provides. It is not a replacement for the clinical record. It is the scheduling engine that ensures nothing falls through the gap between "we should call this family" and "we documented that we called."
Building the Tracking Spreadsheet
The minimum viable columns for a 13-month bereavement tracking sheet:
| Column | Purpose |
|---|---|
| Patient name | Identification |
| Date of death | Anchor date for all milestones |
| Primary family contact(s) | Name, relationship, phone, email |
| BRAT risk level | Determines follow-up intensity |
| Assigned bereavement counselor | Accountability |
| Initial outreach date (target) | 7–14 days post-death |
| Initial outreach date (actual) | Documentation of completion |
| Month 1, 3, 6, 9, 11, 13 milestones | Target date + completion status for each |
| Anniversary date | One year from date of death |
| 13-month closure date | Formal discharge from bereavement program |
| Declined services? | If yes, date documented and door-open noted |
| Escalation notes | Flagged risk changes, referrals made |
For each milestone column, use conditional formatting: green for completed on time, yellow for overdue by less than a week, red for overdue by more than a week. Review red cells against the individualized plan and agency policy; missed planned contacts can become a survey issue.
Sorting and filtering: Sort by the next upcoming milestone date so your weekly review surfaces the families who need contact soonest. Filter by risk level when you need to prioritize — Level 4 and 5 families should surface first in the "overdue" column.
Milestone Call Scripts That Document Properly
The call itself matters, but the documentation is what surveyors read. Each milestone call should follow a consistent framework that produces a chartable note:
Opening (all calls): "Hello [name], this is [your name] from [hospice agency]. I'm calling to check in with you — it's been [timeframe] since [patient name] passed, and I wanted to see how you're doing."
Assessment questions (tailor to the milestone):
Month 1 call: Focus on immediate adjustment. How are daily routines going? Are you eating and sleeping? Have you connected with family or friends? Is there anything practical — financial paperwork, funeral follow-up — where you feel stuck?
Month 3 call: The social support often thins at this point. Are people still checking in, or has the initial wave of support receded? How are you managing weekends and evenings? Any holidays or significant dates approaching that you're concerned about?
Month 6 call: Look for trajectory. Are things gradually becoming more manageable, or does it feel the same or worse? Have you noticed any changes in your health — sleep, appetite, energy? Have you considered joining a support group or speaking with a counselor?
Month 9–11 calls: Anticipatory distress often builds as the first anniversary approaches. Are you thinking about the anniversary? Do you have a plan for how you want to spend that day? Is there anything our team can do to support you through it?
Anniversary call script: The one-year anniversary call is clinically distinct. Families often experience a resurgence of acute grief around this date, and some who were coping well may suddenly struggle.
"I know today [or this week] marks one year since [patient name] passed. I wanted you to know we've been thinking of you. How has this time been? Some people find the anticipation of the anniversary is actually harder than the day itself — has that been your experience?"
Listen more than you speak. Document the family's emotional state, any new concerns, and whether they need continued support or are ready for the 13-month closure process.
Month 13 closure call: "We're approaching the end of our formal bereavement support period. I want to make sure you feel ready for that transition. How are you doing? Is there anything unresolved that you'd like to address before we close your file?"
If the family is not ready, document that and discuss options — a referral to community grief support, a recommendation for individual counseling, or in some cases, a brief extension with clinical justification.
Free Download
Get the Hospice Worker's Family Bereavement Support Guide — Quick Reference
Everything in this article as a printable checklist — plus action plans and reference guides you can start using today.
Common Tracking Failures
Failure 1: The spreadsheet exists but nobody reviews it weekly. A tracking tool that is updated after the fact — logging calls that already happened — misses its purpose. The weekly review is the mechanism that catches upcoming milestones before they become overdue.
Failure 2: Volunteer bereavement activities are tracked separately. If volunteers handle low-risk mailings or support calls, their activities must appear on the same master sheet or feed into the same tracking system. A parallel volunteer log that nobody reconciles against the clinical record is a gap waiting for a surveyor.
Failure 3: Declined families disappear from the sheet. A family that declines bereavement services still needs a clear record of the offer and response. Follow agency policy on whether and when to re-offer support; keep the declined status visible when a later contact is planned. Remove them from the active caseload only if that matches your workflow, and use a "declined — review at [date]" section when a re-offer is scheduled.
The Hospice Worker's Family Bereavement Support Toolkit includes a pre-built 13-month tracking framework with milestone date auto-calculation, risk-level-specific follow-up schedules, and call documentation templates — the operational layer that connects your clinical care plan to your daily workflow.
Get Your Free Hospice Worker's Family Bereavement Support Guide — Quick Reference
Download the Hospice Worker's Family Bereavement Support Guide — Quick Reference — a printable guide with checklists, scripts, and action plans you can start using today.