Your Diabetic Patients Are Overdue for A1C Checks — Here's the Care Gap System That Catches Every One Before Your MIPS Score Tanks
It's 9 AM on a Tuesday. Your office manager is staring at a 14-page printout of 340 diabetic patients, manually checking each chart to see who had an A1C in the last six months. Some results are in the EHR as structured data. Some are scanned PDFs from outside labs. Some are just a Post-it note on the paper chart that says "did labs, results in file." She'll do this for three full days this quarter — 24 hours of labor to identify the care gaps, before anyone even picks up the phone to call a patient. The practice will spend $528 in staff time to discover that 38% of diabetic patients are overdue for A1C. And when MIPS scores come back, the $4,200 quality-measure penalty will arrive right on schedule.
This isn't negligence. It's the gap between what your EHR promises and what it actually delivers. The EHR can generate a list of diabetic patients. It cannot tell you who's overdue when labs live in three different formats across two different systems. So your staff bridges the gap with manual labor — 12 days per year, every year, forever.
The 5 chronic disease quality measures that actually affect your MIPS score
Not every missing lab is a MIPS problem. These five measures drive the bulk of your quality score — and they all have the same tracking requirement: identify overdue patients, contact them, and document the outcome.
| MIPS Measure | NQF # | What's Required | Reporting Period | Benchmark (2026) |
|---|---|---|---|---|
| 1. A1C Control (<9%) | 0059 | Most recent A1C < 9.0% — OR — most recent A1C is missing/not performed (counts as not controlled unless documented exception) | Once per measurement period (typically 12 months) | 75%–85% of patients in control |
| 2. Blood Pressure Control | 0018 | Most recent systolic < 140 mmHg AND diastolic < 90 mmHg | Once per measurement period | 65%–75% |
| 3. Diabetic Eye Exam | 0055 | Retinal or dilated eye exam by eye care professional within measurement year OR negative for retinopathy in prior year | Annually | 55%–70% |
| 4. Nephropathy Screening | — | Urine albumin/creatinine ratio OR 24-hour urine within measurement period, PLUS documentation of ACE/ARB therapy if indicated | Annually | 60%–75% |
| 5. Statin Therapy | — | Patients 40–75 with diabetes are on statin therapy unless contraindicated or documented patient refusal | At least once in measurement period | 70%–80% |
Each measure follows the same logic: numerator (patients who got the test/treatment) ÷ denominator (all eligible patients) = your quality score. The patients dragging your score down aren't the ones with uncontrolled A1C — they're the ones with NO A1C in the system because nobody tracked them down.
The tracking system walkthrough: 3 tabs that replace 12 days of manual work
Build this system once — about 75 minutes — and your quarterly care gap audit goes from 3 days to 2 hours. Here's every tab, every column, and the protocol that keeps it current week to week.
Tab 1: The Patient Registry
Export your EHR's chronic disease patient list once per quarter. Paste it into this tab. The color-coding does the rest.
| Column | What Goes In It | Formula / Tip |
|---|---|---|
| A: Patient Name | Last, First | — |
| B: DOB | MM/DD/YYYY | — |
| C: Primary Diagnosis | Diabetes Type 2, Diabetes Type 1, etc. | Data validation: dropdown list |
| D: Last A1C Date | MM/DD/YYYY | Enter from EHR or outside lab report |
| E: Last A1C Value | e.g., 7.2 | — |
| F: A1C Status | Auto-calculated | =IF(D2="","RED — Never",IF(TODAY()-D2>270,"RED — >9mo",IF(TODAY()-D2>180,"YELLOW — 6-9mo","GREEN — Current"))). Conditional formatting: green/yellow/red fill. |
| G: Last BP Date + Value | e.g., "128/82 on 4/15/26" | — |
| H: BP Status | Auto-calculated | Similar date-gap logic to A1C. Separate conditional formatting for >140/90 flags. |
| I: Last Eye Exam Date | MM/DD/YYYY | From EHR or specialist report |
| J: Eye Exam Status | Auto-calculated | =IF(TODAY()-I2>365,"OVERDUE","Current") |
| K: Last Nephropathy Date | MM/DD/YYYY | — |
| L: Nephropathy Status | Auto-calculated | Same 365-day logic as eye exam |
| M: Statin Status | Dropdown: On Statin, Not On (Contraindicated), Not On (Refused), Not On (No Reason) | Only "Not On (No Reason)" flags as a gap |
| N: Total Gaps | Auto-calculated | =COUNTIF(F2:L2,"*OVERDUE*") + COUNTIF(M2,"Not On (No Reason)") |
| O: Patient Phone | (xxx) xxx-xxxx | — |
| P: Preferred Contact | Dropdown: Phone, Text, Portal Message, Letter | — |
| Q: Patient Status | Dropdown: Active, Deceased, Transferred, Incarcerated, Hospice | Patients marked anything other than "Active" are excluded from denominator. CRITICAL — update this quarterly. |
Tab 2: Care Gap Actions Log
Every patient contact attempt, every outcome. This is your MIPS audit documentation — print it and file it.
| Column | What Goes In It |
|---|---|
| A: Date | When contact was attempted |
| B: Patient Name | From Patient Registry |
| C: Gap Type | Dropdown: A1C, BP, Eye Exam, Nephropathy, Statin |
| D: Contact Method | Dropdown: Phone, Text, Portal, Letter |
| E: Attempt # | 1, 2, or 3 |
| F: Outcome | Dropdown: Scheduled Appt, Declined, Unreachable – Wrong Number, Unreachable – No Answer, Left Voicemail, Patient Deceased, Patient Transferred, Lab Ordered/Results Pending |
| G: Notes | Free text — who you spoke with, which provider they'll see, special instructions |
| H: Follow-Up Needed? | Dropdown: Yes, No — Resolved, No — 3 Attempts Reached |
Tab 3: Quality Dashboard
This tab pulls from the Patient Registry and Actions Log. Update takes 30 seconds — just refresh the pivot tables or formulas. Give this to your practice owner every Monday morning.
- Total diabetic patients: count from Patient Registry (Active only)
- A1C controlled (<9%): patients with Green A1C status ÷ total active patients
- BP controlled (<140/90): same logic
- Eye exam current: same logic
- Nephropathy current: same logic
- Statin appropriate: patients on statin OR with documented exception ÷ total eligible
- Overall quality score: weighted average (MIPS weights each measure differently — check your QPP participation status)
- Patients with 0 gaps: count of patients where Total Gaps (Col N) = 0
- Patients with 3+ gaps: these are your highest-priority outreach targets
- Outreach this month: count of actions logged this month vs target
The 2-hour quarterly care gap audit protocol
Here's the timeline that replaces 3 full days of chart-pulling:
| Time Block | Action | Output |
|---|---|---|
| 8:00–8:15 AM | Run EHR patient list report: all patients with diabetes diagnosis, seen in last 12 months. Export to CSV. | Patient list in spreadsheet |
| 8:15–8:45 AM | Paste into Patient Registry tab. Sort by A1C date (oldest first). Identify RED patients first (never or >9 months), then YELLOW (6–9 months). | Prioritized outreach list |
| 8:45–9:15 AM | Review patient status column — mark any deceased, transferred, or incarcerated patients. Remove from active denominator. | Clean denominator for accurate MIPS reporting |
| 9:15–9:45 AM | Generate the call list: all RED and YELLOW patients, sorted by number of gaps (3+ gaps first). Print or share with the person doing outreach. | Call list — ready for outreach |
| 9:45–10:00 AM | Update the Quality Dashboard. Note the gap from last quarter for each measure. This becomes your MIPS submission documentation. | Dashboard printout for practice owner |
Two hours. Done. The person who used to spend 3 days pulling charts now spends 2 hours running a quarterly report and generating a call list — and the remaining 22 hours go back to billable work.
How to handle outside lab results (the PDF problem)
The single biggest obstacle to EHR care gap modules: outside labs send results as PDFs, not structured data. The EHR module can't read them, so those patients show as "overdue" even when they're not. Here's the workflow that bridges the gap:
- When an outside lab result arrives as a PDF: Open it. Find the A1C value and date. Enter both into the Patient Registry tab (Columns D and E). Add a "†" or highlight the row in light orange to flag "outside lab — verified manually."
- When a patient says "my endocrinologist did my A1C last month": Ask for the endocrinologist's name and the approximate date. Call the endocrinologist's office and request the result. Document the request in the Actions Log (Gap Type = A1C, Outcome = Lab Ordered/Results Pending). Follow up in 7 days if the result hasn't arrived.
- When a patient was seen at an urgent care or ER: The hospital likely ran an A1C or BMP. Request records from the hospital's HIM department — this is the same process as any other medical records request. Log it, track the 30-day HIPAA deadline, and update the Registry when the result arrives.
- The quarterly reconciliation: Before finalizing your MIPS submission, sort the Patient Registry by the "outside lab" flag. Verify each one — did the result actually arrive? If not, mark the patient as "overdue — unable to obtain outside result" and document why. This documentation is your MIPS audit defense.
The patient contact protocol: 3 attempts, then document
Calling an overdue patient isn't a collections call. The framing matters. These are people who need medical care and may not realize they're overdue. Here's the script sequence:
| Attempt | Timing | Method | Script (short version) |
|---|---|---|---|
| 1st Contact | Day 1 — morning (9–11 AM) | Phone | "Hi [Patient], this is [Name] from Dr. [Name]'s office. We were reviewing your chart and noticed it's been [X months] since your last diabetes check. Dr. [Name] wants to make sure everything is on track. Can we get you on the schedule this week? I have Tuesday at 2 or Thursday at 10." |
| 2nd Contact | Day 7 — different time of day (4–6 PM) | Phone | "Hi [Patient], this is [Name] again from Dr. [Name]'s office. I left a message last week about scheduling your diabetes check. I wanted to follow up — these checks are important for keeping everything stable, and Dr. [Name] specifically asked about you. Give us a call at [number] or I can schedule you right now if you have a minute." |
| 3rd Contact | Day 14 | Letter | Formal letter on practice letterhead: "Dear [Patient], we've attempted to reach you by phone to schedule your recommended diabetes follow-up. Regular monitoring is an important part of your care plan. Please contact our office at [number] to schedule at your earliest convenience. If you've received this care elsewhere, please let us know so we can update your records." |
After 3 attempts with no response, mark the patient as "3 Attempts Reached — No Contact" in the Actions Log. Include them in your MIPS denominator as a documented outreach gap. You cannot force a patient to schedule, but you can prove you tried.
How to use care gap data for your MIPS submission
When QPP opens for submission (typically January–March for the prior year), your Quality Dashboard is ready. Here's what to provide:
- Numerator: patients who met the measure (Green status for each measure)
- Denominator: total active patients with the diagnosis (minus documented exclusions)
- Performance rate: numerator ÷ denominator
- Documented exclusions: patients marked Deceased, Transferred, Incarcerated, or Hospice in the Patient Registry. Keep documentation for each — transfer-out letter, obituary, or incarceration record.
- Medical record documentation: the Actions Log is your evidence that outreach was attempted. If audited, you can show that patients received 3 contact attempts with documented outcomes.
Integrating with your practice management system
You don't need an API. You need an export button.
- EHR patient list export: Every major EHR (Epic, Cerner, Athena, eClinicalWorks, AdvancedMD) has a "Patient List" or "Registry" report. Filter by diagnosis code (E11.9 for type 2 diabetes, E10.9 for type 1). Export to CSV. Paste into Tab 1.
- Cleaning the denominator: Sort the Patient Registry by Patient Status quarterly. Patients marked "Deceased" or "Transferred" must be updated in the EHR too — otherwise your EHR denominator and your spreadsheet denominator will drift apart. Assign someone to update both systems on the same day.
- Appointment scheduling: When a patient schedules during outreach, log it in both the spreadsheet (Actions Log) AND the EHR. The EHR appointment is what actually gets them seen. The spreadsheet log is your MIPS documentation that you made the contact.
- Lab result reconciliation: Set a calendar reminder for the 15th of each month: open the Patient Registry, filter for "Lab Ordered/Results Pending" in the last 30 days, and check whether results arrived. If not, follow up with the lab or specialist.
When to upgrade from the spreadsheet
The spreadsheet system works for practices managing fewer than 500 chronic disease patients across 1–5 providers. Beyond that — or if you're experiencing any of these — consider dedicated automation:
- 500+ chronic disease patients. At this volume, the quarterly manual audit stretches from 2 hours to a full day, and weekly outreach tracking becomes a part-time job.
- Multiple value-based contracts. If you're in a Medicare ACO, a commercial shared-savings program, AND MIPS, you have three different measure sets with three different reporting periods. A single spreadsheet can't manage the overlap cleanly.
- Dedicated care coordinator on staff. If you've already hired someone for this role, they need a system that auto-generates the call list, auto-logs contact attempts, and auto-updates the dashboard — not one that requires manual data entry across 500+ rows.
- You've had a MIPS audit or are at risk of one. If your quality scores were flagged for review, you need bulletproof documentation. Custom automation provides timestamped, tamper-proof audit logs that a spreadsheet can't match.
Free The Spreadsheet System
Best for: Practices with <500 chronic disease patients, 1–5 providers, tracking 2–5 quality measures for MIPS.
Setup: 75 minutes. Quarterly maintenance: 2 hours.
Cost: $0. Prevents: $3,000–$8,000/year in MIPS penalties through consistent gap identification.
Custom automation What Jobs Done Labs builds
Best for: Practices with 300–1,000 chronic disease patients, 3–15 providers, participating in MIPS plus at least one other value-based contract.
Setup: 48 hours from kickoff to live. Weekly maintenance: 15 minutes — the system auto-generates the call list, auto-logs contact attempts, and auto-updates the dashboard.
Cost: $2,500–$7,000 one-time build. Pays for itself in: 4–7 months through recovered MIPS incentives + 10–15 hours/week of staff time reclaimed.
Includes: automated overdue-patient alerts across all 5 MIPS measures, patient contact logging with audit trail, denominator management with exclusion tracking, MIPS-ready quarterly reports, and a 30-minute team training call.
Population health platform Health Catalyst, Arcadia, etc.
Best for: Practices with 1,000+ chronic disease patients, 10+ providers, multiple value-based contracts, or hospital-affiliated practices.
Cost: $800–$2,500/month. Setup: 4–12 weeks including EHR integration and data validation.
When it makes sense: When the cost of manual tracking exceeds the platform subscription — typically around 1,500+ chronic disease patients or when you're at risk of losing a value-based contract due to quality scores. Below this threshold, the spreadsheet system or custom automation delivers better ROI.
Frequently Asked Questions
How much does it cost to automate patient care gap tracking?
JobsDone Labs builds custom care gap automation typically in the $2,500–$7,000 range as a one-time build. At the low end, that's a smart spreadsheet with automated overdue-patient alerts and a MIPS-ready dashboard. At the high end, it's a full system that pulls your EHR patient list, flags care gaps across 5 chronic disease measures, auto-generates the call list, and logs every patient contact attempt. The system pays for itself in 4–7 months through recovered MIPS incentives — most small practices lose $3,000–$6,000/year in quality-measure penalties that a tracking system prevents. You can also start with our free care gap template immediately — no cost, no commitment — and upgrade when you're ready.
How long does it take to set up care gap automation?
The free spreadsheet template takes about 45 minutes to set up with your practice's chronic disease patient list — export your EHR report, import into the Patient Registry tab, and you're tracking care gaps same-day. A full custom automation from JobsDone Labs typically takes 48 hours from kickoff to live — we build the system, you review and approve it, and we train your team on a 30-minute call. There's no months-long implementation cycle; you're running recall outreach by the end of the week.
How does the $30K guarantee work for medical practices?
JobsDone Labs guarantees $30K+ in net profit recovery within 90 days of going live, or you pay nothing. For medical practices this typically comes from three sources: recovered MIPS/quality-measure incentives — closing care gaps on A1C, blood pressure, eye exams, nephropathy, and statin therapy can add $3,000–$8,000/year in MIPS payment adjustments; staff time reallocation — the manual quarterly chart audit consumes 12 days/year of office manager time ($2,100+ at $22/hour) that can be redirected to revenue-generating work; and avoided patient attrition — patients who feel forgotten between visits transfer to other practices, costing $2,000–$5,000 per lost patient in lifetime revenue. We document the baseline during your free audit so the improvement is measurable.
What industries does JobsDone Labs serve?
We build automation and tracking systems across seven core industries: healthcare and medical practices, logistics and trucking, manufacturing, home services and trades, professional services, retail and e-commerce, and mortgage and lending. Our healthcare practice serves private medical practices (1–20 providers), dental practices, physical therapy clinics, and behavioral health practices. If your business runs on spreadsheets, email, and manual processes, we can help — regardless of industry.
What's the ROI of care gap automation vs hiring a care coordinator?
Hiring a part-time care coordinator costs $28,000–$40,000/year in salary, benefits, and payroll taxes — and they still need a system to manage 300+ chronic disease patients effectively. The free spreadsheet template cuts the quarterly audit from 12 days to 2 hours at zero cost. A full custom automation from JobsDone Labs (one-time $2,500–$7,000) automates the patient identification, generates the prioritized call list, and logs every contact attempt — saving 10–15 hours per week of staff time plus preventing $3,000–$6,000/year in MIPS penalties. That's roughly $15,000–$25,000/year in combined savings — with a payback period under 5 months. Compared to hiring a care coordinator at $35K/year, the automation pays for itself in the first quarter and doesn't require managing another employee.
Free care gap workflow audit
We'll review your current chronic disease patient list, calculate how many care gaps you're missing, estimate the MIPS penalty you're risking, and give you a 1-page blueprint for closing every gap — free, 15 minutes, no obligation.
Book a free audit →