FQHC HRSA UDS Cost Report, Medicaid PPS Rate Rebasing & 340B Duplicate-Discount Audit — Calculator, Excel Workpaper & API (BI-13)
Evaluates HRSA UDS Table 8A Step-Down Facility & Admin Cost Allocation; 42 U.S.C. Sec. 1396a(bb) Medicaid PPS MEI Indexing & Change-in-Scope Rebasing; 42 U.S.C. Sec. 256b(a)(5)(A)-(B) 340B Duplicate-Discount & Diversion Audit; 42 U.S.C. Sec. 1396a(bb)(5) Medicaid MCO Supplemental Wraparound Settlement. Submit: Direct Clinical Cost (USD), Allowable Facility Admin (USD), Non Reimbursable Excluded (USD), Billable Clinical Visits. Excel Tabs: Table 8A Financial Costs, Table 9D Patient Revenue, Table 9E Other Revenue, OPAIS 340B NDC Crosswalk. Calibrated across all 57 US States, Washington, D.C., US Territories, and Federal IRC § 11 baselines in sub-millisecond deterministic Python & NumPy CPU execution.
Official Statutory & Regulatory Workpaper Title: HRSA Section 330 UDS Tables 8A/9D, 42 U.S.C. 1396a(bb) PPS Rebasing & 42 U.S.C. 256b 340B Audit Filing
Official Agency Form / Workpaper Standard: HRSA UDS Tables 8A, 9D & 9E / CMS Form 224-14 / OPAIS 340B Audit
Governing Accounting, Tax & Statutory Authorities: 42 U.S.C. § 254b (HRSA Health Center Program Compliance Manual Chapters 15–18); 42 U.S.C. § 256b (340B Drug Pricing Program); 45 CFR Part 75 (Uniform Guidance); 29 DCMR Chapter 45 (D.C. FQHC PPS & APM Rules)
Common Practitioner & Search Aliases: FQHC UDS Table 8A Cost Allocation, Medicaid PPS Change in Scope Rebasing, 340B Duplicate Discount Audit, MCO Wraparound Payment Calculator, Community Health Center Grant Audit
Interactive FQHC HRSA UDS Cost Report, Medicaid PPS Rate Rebasing & 340B Duplicate-Discount Audit Calculator (BI-13)
Enter your trial-balance, schedule, or contract numbers below to verify headline statutory outputs in real time across 57 US jurisdictions (zero data stored).
Optional: Paste Advanced Custom Schedule / Array Overrides (JSON)
Computed Headline Statutory & Financial KPIs
Download 5-Tab Formula-Linked Excel Workpaper (.xlsx) — $19.00
Includes 5 formatted CPA/analyst tabs compiled from your exact inputs: 01_Executive_Summary, 02_Statutory_Rules (4 rules), 03_Workpaper_Schedule (5 rows + =SUM/=AVERAGE formulas), 04_Scenario_Sensitivity (=C-B variance formulas), and 05_Compliance_Audit_Flags (3 threshold gates).
1. Deterministic Statutory & Regulatory Laws Executed
Unlike prompt-only LLM skills that approximate multi-period schedules in token space, BI-13 executes exact pure-Python and NumPy statutory rules in volatile container RAM:
- (1) HRSA UDS Table 8A Step-Down Facility & Admin Cost Allocation [42 U.S.C. Sec. 254b (HRSA BPHC UDS Manual Table 8A) & 45 CFR Sec. 75.405]
- (2) 42 U.S.C. Sec. 1396a(bb) Medicaid PPS MEI Indexing & Change-in-Scope Rebasing [42 U.S.C. Sec. 1396a(bb)(2)-(3) Medicaid FQHC Prospective Payment System]
- (3) 42 U.S.C. Sec. 256b(a)(5)(A)-(B) 340B Duplicate-Discount & Diversion Audit [42 U.S.C. Sec. 256b(a)(5)(A)-(B) Public Health Service Act Section 340B]
- (4) 42 U.S.C. Sec. 1396a(bb)(5) Medicaid MCO Supplemental Wraparound Settlement [42 U.S.C. Sec. 1396a(bb)(5) Quarterly State Supplemental FQHC Wraparound Rule]
2. Input Schema & Workpaper Output Schedules
Structured Input Datasets (structured_inputs)
| Input Slot | Dataset / Trial-Balance Schedule | Accepted Format |
|---|---|---|
FILE-1 | Annual HRSA Uniform Data System (UDS) Report (Tables 3A-9E) & Medicare/Medicaid FQHC Cost Reports (CMS-224-14) | Structured JSON object/array or CSV text |
FILE-2 | 24-Month Encounter-Level Billing & Sliding-Fee Discount Schedule (SFDS) Verification Log | Structured JSON object/array or CSV text |
FILE-3 | 340B Split-Billing Software Export, Contract-Pharmacy Dispensing Claims & NDC/Medicaid Exclusion Logs | Structured JSON object/array or CSV text |
FILE-4 | Federal Notice of Award (NoA) Grant Budget, 45 CFR Part 75 Fund-Accounting Trial Balance & OPAIS Registration | Structured JSON object/array or CSV text |
Deterministic Output Workpaper Schedules
| Workpaper Schedule | Computed Output Schedule & Tie-Out |
|---|---|
| Schedule 1 | Table 8A Financial Costs |
| Schedule 2 | Table 9D Patient Revenue |
| Schedule 3 | Table 9E Other Revenue |
| Schedule 4 | OPAIS 340B NDC Crosswalk |
| Schedule 5 | Contract Pharmacy Dispensing Audit |
| Schedule 6 | Medicare FQHC PPS Reconciliation |
3. Quick Integration — REST API (cURL) & AI Agent MCP
A. Direct HTTP / REST API Call
curl -X POST "https://quantledger-73-engine-financial-and-statutory-api.p.rapidapi.com/v1/suites/BI-13/compute" \
-H "Content-Type: application/json" \
-H "X-RapidAPI-Key: YOUR_RAPIDAPI_KEY" \
-H "X-RapidAPI-Host: quantledger-73-engine-financial-and-statutory-api.p.rapidapi.com" \
-d '{
"jurisdiction": "NY",
"naics_or_sic": "541211",
"structured_inputs": {}
}'
B. Model Context Protocol (MCP) Tool Call
// Tool call inside Claude Desktop, Cursor, VS Code Copilot, LangGraph, or CrewAI:
execute_institutional_math_engine({
"engine_code": "BI-13",
"jurisdiction": "DE",
"naics_or_sic": "541211",
"structured_inputs": {}
})