835 ERA Remittance Processor

Parse ANSI X12 835 v5010 files into a multi-tab Excel workbook for revenue cycle analysis.

🔒 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 Highland's intranet, in a SharePoint document library, or keep it as a local .html file the RC team double-clicks.

📊 Live preview before download

Six stat cards show 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.

⬇

Drop 835 or PDF remit files here

or click to browse · raw 835 EDI (.835, .edi, .txt, .era) or paper remit PDFs · multiple files OK

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.

Parse warnings

Files

Reconciliation: BPR − (Σ CLP04 − Σ PLB)

$0.00

Payer Summary

Payer	Claims	Denied	Billed	Paid	Realization

Aging by Payer

Payer	0-30 days	31-60 days	61-90 days	91+ days	Total at Risk

Output workbook tabs: Summary · Remittances · Claims · Services · Adjustments · PLB Adjustments · Payer Summary · Denial Reasons pivot. Reconciliation should equal $0.00 on a balanced 835. Status code 22 = reversal; PLB positive = recoupment, negative = additional pay.