835 / 837 Revenue Cycle Processor
Drop 835 remittance and 837 claim files for an instant payments & denials dashboard, a prioritized denial work queue with appeal guidance, and a multi-tab Excel workbook.
Drop 835, 837, or PDF remit files here
or click to browse · 835 ERA / 837P claim EDI (.835, .837, .edi, .txt, .era) or paper remit PDFs · file type auto-detected · multiple files OK
๐ PHI never leaves this machine
Files
Parse warnings
Payments & denials dashboard
Total payments, billed charges, net realization, denial rate and at-risk dollars, payer summary, and top denial reasons — the moment your files parse.
Denial work queue & aging
Every denied, reversed, and short-paid claim becomes a work item with CARC/RARC context, recommended appeal steps, status tracking, and timely-filing aging.
Excel workbook & reconciliation
One-click multi-tab workbook (claims, services, adjustments, PLB, pivots) plus 837-billed vs. 835-paid reconciliation matched on patient account number.
Security & privacy — how PHI stays local
Browser-local = PHI-safe
Files never leave the browser. The
FileReader API reads them into memory, parsing happens in JS, ExcelJS builds the workbook client-side, and the download is triggered from a local Blob URL. Nothing touches a server. Host this on HaloRemit's intranet, in a SharePoint document library, or keep it as a local .html file the RC team double-clicks.
Live preview before download
The dashboard shows total payment, claim count with denial rate, billed charges, net realization (green >50% · amber 30โ50% · red below), and net PLB direction. The reconciliation bar shows BPR vs ฮฃ(CLP04) โ ฮฃ(PLB) with the math broken out โ green if balanced, amber if pennies off, red if it's a real problem. The payer-summary table sorts by paid dollars so your biggest payer's realization rate is the first thing you see.
File format support — what you get vs. what you lose
Full fidelity
Raw 835 EDI (.835, .edi, .txt, .era)
Complete X12 v5010 structure. Every CLP, CAS, SVC, PLB, NM1, REF, DTM, LQ segment. Includes: RARC remark codes, qualifier-distinguished dates (statement vs. service), filing indicators, facility type, DRG, MIA inpatient adjudication, crossover info, EFT trace number for bank reassociation.
Pattern-extracted
PDF paper remits (Aetna Better Health WV)
Captures: patient name, account #, ICN, claim status, service dates, revenue + procedure codes, modifiers, charges, allowed, paid, CARC adjustments, per-claim adjustment totals.
Loses: RARC remark codes (the "why" behind a CARC), DTM qualifier context, filing indicator, facility type, MIA inpatient detail, crossover info, EFT trace for bank-side reassociation, and any segment-level qualifiers that disambiguate similar fields. Other payer PDF layouts not yet supported.
Loses: RARC remark codes (the "why" behind a CARC), DTM qualifier context, filing indicator, facility type, MIA inpatient detail, crossover info, EFT trace for bank-side reassociation, and any segment-level qualifiers that disambiguate similar fields. Other payer PDF layouts not yet supported.
Parse warnings
Payments
Denials
Reconciliation: BPR โ (ฮฃ CLP04 โ ฮฃ PLB)
$0.00
Payer Summary
| Payer | Claims | Denied | Billed | Paid | Realization |
|---|
Top Denial Reasons
Aging by Payer
| Payer | 0-30 days | 31-60 days | 61-90 days | 91+ days | Total at Risk |
|---|
837 Billed vs 835 Paid · matched on patient account number
| Account # | Patient | Payer | Billed (837) | Charge (835) | Paid | Pt Resp | Adjust | Billed โ Paid | Status |
|---|
Output workbook tabs: Summary · Remittances · Claims · Services · Adjustments · PLB Adjustments · Payer Summary · Denial Reasons pivot · 837 Claims · 837 Service Lines · Reconciliation (when an 837 is loaded).
Reconciliation should equal $0.00 on a balanced 835. Billed-vs-Paid matches 837 CLM01 to 835 CLP01 (patient account number). Status code 22 = reversal; PLB positive = recoupment, negative = additional pay.