Convert a deliberately narrow, de-identified allowed-amount CSV into grouped count, 10th percentile, median and 90th percentile rows. Nothing leaves the browser.把严格限定、已去标识的 allowed-amount CSV 转为分组 count、p10、median 与 p90 行。文件不离开浏览器。
CCN · facility · billing code/system · setting/modifier · payer/plan · service date · total allowed amount · units · source period · negotiated method
V1 does not parse raw 835 files. Supply an equivalent de-identified remittance-derived extract only. Fixed-dollar negotiated charges are excluded from percentile output.
INPUT SHA-256 —
OUTPUT SHA-256
—
TRIGGER
Generate allowed-amount percentiles only when the payer-specific negotiated charge is based on a percentage or algorithm—not a fixed-dollar charge.
OBSERVATIONS
Use de-identified EDI 835 ERA data or an alternative equivalent remittance source. Zero-dollar remittances are excluded.
PERCENTILES
Inclusive percentile position, snapped upward to the next observed amount. CMS specifies the upward snap but does not name the underlying rank formula; this implementation is disclosed and requires automated export.
WINDOW
Declare one continuous source period of 12–15 months ending on or before MRF posting. Inconsistent or short windows block export.
UNITS / ZERO
Total allowed amount is divided by whole-number units, then the unit amount is weighted into the distribution. Zero-dollar remittances are excluded; a zero-only group emits count “0” and blank percentiles.
HANDOFF
The pack is an upstream preflight. Run the resulting MRF through the official CMS Validator and complete hospital review.
Local computation reduces handling risk. Experienced hospital finance and compliance teams still own the context, exceptions and final approval.
Local calculation and export stay free. Payment purchases a human-review workflow, evidence checklist and tracked entitlement; allowed-amount rows still never leave your browser.
Full-file evidence export: grouped output checklist, reconciliation review, receipt review, executive summary and attestation draft checklist.
Operated by TJ NOVA LTD · Registered in England and Wales · Company No. 17308318 · Terms · Refunds · Contact运营主体 TJ NOVA LTD · 注册于英格兰和威尔士 · 公司编号 17308318 · 服务条款 · 退款政策 · 联系我们
Five tracked review entitlements for a 30-day service period plus a change-monitor checklist. No automatic renewal or compliance guarantee.
This tool can assemble a draft evidence section for hospital review. It does not name an attester, set an attestation to true, sign, submit, or represent that an MRF is complete. A hospital CEO, president, or designated senior official must oversee the final hospital process.
Not affiliated with CMS. Not legal advice. No compliance guarantee.
No. The conversion runs on your device. There is a local size limit and no upload step.不会。转换在你的设备上运行，有本地体积上限，没有上传这一步。
No. It is a preflight aid. It does not file anything on your behalf and does not tell you that you are compliant.不算。它是预检辅助，不会代你提交任何材料，也不会告诉你「你已合规」。
Full-file evidence export at $199, or a 30-day monitor pack with five tracked reviews at $149.完整文件证据导出 $199，或 30 天监测包 $99（含五次可追踪重跑）。
The 2026 machine-readable file expectations around allowed amounts and percentile reporting. Always confirm the current requirement against the CMS source we link.2026 年机器可读文件中关于允许金额与分位数报告的要求。请始终以我们链接的 CMS 原文为准核实当前要求。