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
You can evaluate unfamiliar locations objectively against your specific production needs—whether that's crane access, parking capacity, noise restrictions, or permit requirements. The skill generates comprehensive scout reports that compare multiple sites using weighted evaluation matrices, flag deal-breakers early, and document infrastructure limitations so your production team makes informed decisions before committing resources to visits.
by skillslib
You'll design robust SCADA system architectures, configure industrial protocols (Modbus, Profibus, OPC-UA, DNP3), and diagnose connectivity and performance issues across distributed control networks. Get step-by-step configuration guidance, integration workflows, and troubleshooting decision trees tailored to your specific hardware and protocol stack.
by skillslib
You can establish systematic color grading workflows that accelerate project delivery, ensure visual consistency across episodes and projects, and maintain broadcast-quality standards. Claude generates reusable templates, quality control checklists, and grading decision frameworks tailored to your project's color science and deliverable requirements.
by skillslib
You'll create a comprehensive, data-driven career transition plan that reduces risk and accelerates your move to a new role or industry. Get a financial runway analysis, identify exactly which skills you need to acquire, map out realistic timelines, and develop contingency strategies for every scenario. Stop wondering if you can afford to switch jobs, and start executing with confidence.
by skillslib
Generate customized legal documents and client communications automatically from your MyCase case data. This skill extracts case details, client information, and matter status to populate document templates, send email updates, and create batch processing workflows. Reduce manual data entry and standardize your document generation process while maintaining client communication consistency.
by skillslib
You can convert raw ESG metrics and narratives into professionally structured impact reports that satisfy regulatory and investor requirements. The skill automatically verifies alignment with SASB materiality categories, GRI standards, and TCFD recommendations; constructs defensible materiality matrices from stakeholder feedback; standardizes impact metrics to IRIS+ and SDG frameworks; and identifies compliance gaps between your draft and mandatory disclosure requirements.
by skillslib
You can submit detailed vehicle stunt descriptions and receive structured safety analyses that identify hazards, verify compliance with regulations, assess insurance implications, and generate required pre-production documentation. The skill helps you bridge creative vision with practical safety execution by providing risk assessments that studios, insurance companies, and location managers require before production begins.
by skillslib
This skill helps you troubleshoot Wwise integration issues, diagnose audio performance bottlenecks, and generate comprehensive documentation for interactive audio specifications. You'll get step-by-step fixes for common implementation problems, performance optimization strategies, and best practices for audio systems across different game engines and platforms.
by skillslib