State Medicaid Budget Variance Analysis & Reporting
Analyze Medicaid budget variances and generate CMS-compliant monthly reports
What You Can Do
You can quickly identify material budget variances (typically >5% month-over-month or >$500K) across enrollment, fee-for-service claims, managed care capitation, and provider rate adjustments. Claude helps you root-cause each variance, categorize drivers (timing, eligibility changes, rate adjustments), and generate state-compliant narrative documentation for CMS 64 filings and legislative budget reports. This protects state appropriations and prevents mid-year funding crises by turning complex reconciliation work into structured, auditable analysis.
Features
flags deviations >5% or >$500K in absolute terms across enrollment, claims, and capitation categories
systematically attributes variances to enrollment timing, claims processing delays, managed care capitation resets, provider rate changes, or federal payment schedule differences
reconciles variances across FFS claims, managed care capitation payments, enrollment-driven costs, and provider rate adjustments in single workflow
generates state-required explanatory sections with supporting documentation templates for federal reporting
structures variance narratives for CFO reports, appropriations committees, and quarterly budget updates
documents sequential month-over-month patterns to distinguish one-time events from systemic changes
addresses differences between accrual accounting (claims incurred) and cash accounting (state payments) for accurate variance isolation
produces worksheets, summary tables, and supporting narratives formatted for CMS desk reviews and state legislative audits
Example Output
example
What's Included
- SKILL.md instruction file: complete variance analysis methodology, materiality thresholds, and state compliance framework
- Monthly Variance Analysis Template: structured worksheet categorizing variances by enrollment, FFS claims, capitation, and provider rate changes with root-cause fields
- CMS 64 Narrative Section Examples: 5–7 pre-formatted explanatory paragraphs for federal reporting compliance with variance attribution guidance
- Variance Tracking Dashboard Framework: month-over-month comparison table template for CFO reports and legislative budget updates
- Audit Documentation Checklist: checklist ensuring all variance categories are covered, documented, and linked to supporting system reports
- Timing Reconciliation Worksheet: template isolating true spending variances from accrual/cash accounting differences and claims processing delays
Who It's For
- State Medicaid Budget Analysts — daily variance identification and monthly report preparation
- State Health Department Finance Officers — CFO-level budget reconciliation and legislative reporting
- Medicaid Finance Managers — quarterly forecasting and appropriations compliance
- State Legislative Budget Staff — appropriations committee briefings and budget crisis prevention
- CMS Compliance/Audit Liaisons — desk review response and federal reporting documentation
Best For
- Monthly Medicaid expenditure variance analysis and root-cause investigation
- CMS 64 narrative section preparation for federal reporting
- State legislative budget reports and CFO quarterly reconciliation
- Enrollment-driven cost variance isolation and projection
- Claims processing timing reconciliation between accrual and cash accounting
- Managed care capitation rate change documentation
- Audit-ready variance documentation for CMS desk reviews and state legislative audits
You might also like
Prepare comprehensive expert witness reports and testimony that meet Daubert standards for admissibility and withstand cross-examination scrutiny. You'll get structured case analyses integrating psychological assessments, relevant case law citations, and anticipated counterarguments. The skill helps you document your forensic opinions with the legal rigor required in criminal, civil, and family law proceedings.
by skillslib
You can systematically evaluate architectural options by building decision matrices, identifying trade-offs, and documenting design rationale. This skill generates comparison frameworks, risk assessments, and architecture decision records (ADRs) that help you choose between competing approaches based on concrete criteria like performance, scalability, cost, and team capabilities.
by skillslib
You provide a single core insight or perspective, and this skill transforms it into a complete, coordinated thought leadership content suite across every major channel. It generates optimized articles, social threads, email sequences, presentation outlines, and more—all reinforcing the same core message while adapting to each platform's unique audience and format. Every piece maintains strategic consistency while maximizing reach and engagement.
by skillslib
Analyze commercial insurance applications by extracting risk factors, evaluating loss history and industry exposure, and generating structured underwriting recommendations with standardized documentation. You'll reduce review time per application, ensure consistent decision criteria across your team, and maintain compliant audit trails for every underwriting action.
by skillslib
This skill analyzes property damage claims to identify viable subrogation opportunities against third-party defendants. It quantifies recovery potential using liability assessment, damages analysis, and comparable settlement benchmarks—then develops negotiation-backed strategies to maximize your recovery. The skill guides you through intake, documentation, negotiation, and settlement workflows to transform claims into recoveries.
by skillslib
You can design rigorous, reproducible experiments with detailed protocols, optimize your laboratory methodology to improve reliability and efficiency, and systematically troubleshoot experimental failures using structured analysis. This skill integrates statistical planning, equipment specifications, and error analysis into a cohesive experimental framework that accelerates discovery.
by skillslib
You can systematically prepare for bank negotiations by mapping your bargaining position relative to each lender, identifying where banks have pricing flexibility and operational constraints, and developing counteroffers that address both parties' core objectives. The skill helps you structure concession frameworks, prioritize negotiation priorities by facility type, and build relationship leverage through deposit behavior, transaction volumes, and multi-product bundling strategies specific to how banks value corporate relationships.
by skillslib
You can design culturally appropriate survey instruments tailored to international development contexts, analyze mixed-methods data by integrating quantitative findings with qualitative insights, and implement robust data quality management systems for your field operations. Claude helps you create survey templates with adaptive logic, develop validation protocols, and produce data quality reports that highlight issues before analysis begins.
by skillslib