This is a real, working import — pick an agency and a .xlsx file below and it's parsed live in your browser (nothing uploads anywhere). Built from your sample file's exact "Hours" sheet: identity columns (name, County, Medicaid #, Waiver Type, Provider) are forward-filled from each person's first row, and people are matched by Medicaid Number.

Note: if you're viewing this inside Claude's in-app preview, the live parsing may not run — open the file directly in your web browser (double-click it in your folder) to try the real upload.

Drop in the eMBS flat file you're about to submit. Every line is checked against DODD's eMBS error rules and the agency's PAWS roster, and the result is saved under Billing File Validator by date range:
• File — 75-byte lines, no blank lines, file name (m + contract #, 40 characters max, no special characters, never reused).
• Dates — valid service and invoice dates, nothing billed before it happened, the 350-day filing limit, overtime on Sundays.
• Recipient — 12-digit Medicaid #, last name / initial format and match to PAWS, person on the roster.
• PAWS — the service code's roll-up (e.g. APC → A22) is authorized, the date is inside the span, units and dollars remaining.
• Limits & conflicts — duplicates, 96 units/day (HPC and 15-minute codes), 32 on-call units, daily codes = 1 unit, Shared Living / Respite / Remote Support / Adult Day conflicts, staff size vs code, group size, county, rate, other-source fields.
• EVV — flags EVV-required HPC lines that no EVV check covers yet (errors 66/67 deny claims from 10/01/2025).

Export visits from Sandata (Reports → Export Visits) for the billing week and upload the CSV. Add that week's eMBS billing file to also compare billed units against EVV. The result is saved and the agency sees the visits they need to fix on their dashboard.

Parses DODD's invoice/payment report (e.g. an INVCFLAT file) and sums the actual amount paid. To find the right billing entry to attach it to, tell us which agency and which billing period this invoice is for — matching is done by agency + exact billing period, not by anything inside the invoice file itself.

This creates a real invite. The person opens the portal's sign-in page, clicks "First time here?", enters this exact email, and sets their own password — Zenith never sees or sets it.

Creates a real invite for this agency. The person opens the portal's sign-in page, clicks "First time here?", enters this exact email, and sets their own password.

In production, this button opens Stripe's secure hosted form (or embedded Payment Element) — card/bank details go directly to Stripe and never touch Zenith's servers.