Free download · Excel · 26 sheets
MDS 3.0 Audit Prep Worksheet
Excel template that maps every MDS 3.0 section to a coordinator checklist. Used by 200+ skilled-nursing facilities for quarterly submission prep.
Setup: ~30 min · Per-quarter use: ongoing
MDS coordinators tell us they spend 40-60 hours per quarter chasing the same data points across multiple systems. This worksheet centralises the chase.
Each tab corresponds to an MDS 3.0 section (Section A through Section Z) with a pre-built data-pull checklist, source-system column, and review-status indicator.
Drop in your own facility's data sources (where vitals live, where ADL scoring lives, etc.) and the worksheet becomes your repeatable quarterly playbook.
What's inside
- Section A-Z prep tabs (one per MDS section)
- Data-source mapping template (where each value lives)
- Review-status tracking with conditional formatting
- Coordinator-handoff workflow
- Late-submission penalty calculator
- Quarterly-cadence Gantt chart
Built for
MDS CoordinatorsDirectors of NursingQAPI Teams