Convert an 835 file to Excel
Turn X12 835 remittance files into an Excel workbook: payments, claims, service lines, adjustments, denials and patient balances on separate sheets. Nothing is uploaded.
The workbook
Remitgrid Pro builds one .xlsx with real numbers (not text), money formatting and filters on every sheet:
- Payments — one row per check/EFT with claims paid, provider adjustments and the deposit amount.
- Claims — billed, paid, patient responsibility, contractual (CO) and other adjustments, status and balance check.
- Service lines — procedure, modifiers, units, billed, allowed, paid, adjustments and remarks.
- Adjustments — one row per CARC adjustment, claim or line level.
- Denials — a worklist of denied claims and lines with reason and remark codes.
- Patient responsibility — deductible, coinsurance and copay per claim.
- By reason code, By payer and By procedure summaries.
- Provider adjustments (PLB) and Checks (anything that didn't balance).
Prefer CSV? Claims and service-line CSVs are free for files up to 50 claims and open in Excel, Google Sheets or your practice-management import.
Balancing checks on every file
- Each service line: billed − adjustments = paid.
- Each claim: billed − all claim and line adjustments = paid.
- Each payment: sum of claims paid − provider-level adjustments (PLB) = the check or EFT amount in BPR02.
- Envelope: segment counts and control numbers in SE, GE and IEA.
Anything that doesn't add up is marked UNVERIFIED with the exact difference, so you know before you post it.
Private by design
An 835 is full of protected health information — patient names, member IDs, dates of service and procedure codes. Remitgrid reads the file with JavaScript in your browser tab. The contents are never uploaded, logged or stored, and nothing is saved when you close the tab. You can confirm it in your browser's developer tools (Network tab), or disconnect from the internet after the page loads and keep working.
How it works
- Download the 835 (ERA) from your clearinghouse, payer portal or practice-management system.
- Drop it here. Payments, claims and lines appear instantly, with balancing checks and denials flagged.
- Export claims or service lines to CSV, print a readable remit, or (Pro) download the Excel workbook and denials worklist.
FAQ
Is my 835 uploaded?
No. The file is read by JavaScript running in your browser tab; its contents — patient names, member IDs, claims — are never sent over the network or stored. You can verify this in your browser's developer tools (Network tab), or go offline after the page loads.
Is it HIPAA compliant?
Remitgrid never receives, stores or transmits your files, so no PHI reaches us. HIPAA compliance depends on how your organization handles the files and anything you download — use approved devices and storage, and check with your privacy or compliance officer.
Which files work?
X12 835 health care claim payment/advice files (version 005010X221A1 and most older ones), usually named .835, .edi, .txt, .era or .x12. Files with several payments, any delimiters, and with or without line breaks are supported. 837, 277 and 999 files are recognised and politely refused.
What do the balancing checks do?
For every service line, claim and payment, Remitgrid checks that billed − adjustments = paid, and that claims paid − provider-level adjustments = the check or EFT amount. It also checks segment counts and control numbers. Anything that doesn't add up is marked UNVERIFIED.
Are the code descriptions official?
No. They are short plain-English summaries written by Remitgrid. The official CARC and RARC wording is published by X12 at x12.org/codes, and payers apply codes according to their own policies.
What's free?
Viewing any 835 of any size, the balancing checks, denials view and reason summary are free. Claims and service-line CSVs and printing are free for files up to 50 claims. Pro removes the limit, opens many files at once, and adds the Excel workbook, denials worklist, adjustments and patient-balance CSVs.