This is not a generic form pulled from a search result. It was built from real clinical and caregiving experience, tested against the actual situation you are facing, whether that is a visit, a chart, or a hard conversation. Download it and start using it right away. There is no software to install and no training required first. Use it exactly as it is, or adjust it to fit how your team or your family already works. Either way, you get a clear, ready-made tool instead of one more thing to build from scratch.

Then, five months after the cap year ends, a letter shows up from your Medicare Administrative Contractor. It says you owe money back. Sometimes a lot of money. And here's the part that stings: the payments you're refunding already went to payroll, rent, supplies, and medications months ago.

That's the Medicare aggregate cap. It isn't a penalty for bad care. It's a limit on total payments for the year, and by the time you find out you're over it, the money is already spent.

For hospices with a bookkeeper but no CFO, that timing gap is the whole problem. Nobody's job is to watch this number every month. So nobody does, until the letter arrives.

There's more hiding in the cap than most agencies realize. It isn't a per-patient limit, even though it looks like one. A hospice can have three patients on service for 700 days each and still be fine, if enough short-stay patients balance it out. Owners who think that patients make the wrong calls.

Your beneficiary count isn't your census, either. Two different counting methods, streamlined and proportional, can produce very different numbers for the same agency. Most small hospices don't know which one they're on.

And even if you pass the aggregate cap, you can still owe money on the inpatient cap. It's a separate 20 percent limit on GIP and respite days, and most trackers ignore it completely.

The Medicare Payment Advisory Commission has reported that about 18.6 percent of hospices exceeded the aggregate cap in 2020, up from 12.5 percent in 2015. That number has been climbing. If your referrals lean toward long, slow declines, dementia especially, you're carrying more of this risk than you may realize, even while giving excellent care.

Here's what changes when you catch it early instead of late. Picture an agency that's entered seven months of data: October through April. Thirty-eight beneficiaries. $1,690,000 in Medicare payments. The Dashboard runs the projection and shows 122.9 percent utilization and an estimated year-end repayment of about $540,600 if nothing changes.

That's a hard number to see. But it arrives in May, not February 2028. The owner still has five months. Enough time to set aside roughly $108,000 a month, broaden referral sources, and tighten recertification reviews, instead of finding out after the money's gone and the check is due.

That early warning is the entire point of the Hospice Medicare Aggregate Cap Tracking Spreadsheet and Guide.

You get a ten-tab workbook, in Excel or Google Sheets, no macros, so it won't get flagged by your agency's security filters. You enter payments once a month from your remittance advice, and level-of-care days once a month from your billing system. About ten minutes total. The workbook does the rest: beneficiary counts under either method, your cap utilization, your projected year-end position, your dollars of headroom, and your inpatient cap percentage, all color-coded green, yellow, or red, with an alert when you cross your threshold.

You also get a plain-language guide that walks through the whole cap in words you don't need a cost report background to follow: what counts as a Medicare payment, how the two counting methods differ, what to do when you're over, and a full checklist for your year-end filing, including the deadline calculated and ready to go.

Two things we'll tell you straight, because the truth matters more than a smooth sales pitch. This workbook gives you a management estimate. Your MAC's calculation governs, and it may differ from yours. And the workbook can't automatically pull your claims data. You have to enter payments and days every month, or the early warning disappears.

That's the honest deal. Ten minutes a month, in exchange for months of runway instead of a surprise bill you can't plan for.

If you're the owner or administrator carrying this number in the back of your mind, or the bookkeeper who's been asked to "keep an eye on the cap" without a real way to do it, this was built for you.

Click the Buy button on this page to have immediate access to the digital files.