835 to Excel
Turn ERA remittance (835) files into spreadsheets: payments, claims, service lines, adjustments, and provider-level adjustments. Every file is balanced claim by claim before you download it.
Your file never leaves this computer. It is read and processed inside this page, which is built so it cannot make network requests. It keeps working with your internet turned off.
Verification
Payments
Claims
What gets checked
- Envelope control numbers match and segment counts agree with the trailers.
- Each service line: charge minus adjustments equals the amount paid.
- Each claim: charge minus claim and line adjustments equals the claim payment.
- Each payment: the total paid equals the sum of claim payments minus provider-level adjustments.
- A batch with any unreadable file is marked not verified.
How it works
- Choose the file. Drop one or more 835 files on the page. They are read by your browser and stay on your computer.
- The file is balanced. Each service line, claim, and payment is checked against the totals inside the file. Anything that does not balance is listed.
- Review on screen. Payments and claims are shown in tables so you can spot-check before exporting.
- Download. Export one Excel workbook with a sheet per table, or separate CSV files, along with the certificate listing every check.
Worked example
A made-up $625.00 ACH payment covering three claims, with a $50.00 recoupment and $25.00 of interest at the provider level.
| Patient control # | Status | Charge | Paid | Adjustments |
|---|---|---|---|---|
| PCN0001 | Paid as primary | $500.00 | $350.00 | $150.00 |
| PCN0002 | Denied | $250.00 | $0.00 | $250.00 |
| PCN0003 | Paid as secondary | $400.00 | $300.00 | $100.00 |
Claim payments total $650.00. Provider-level adjustments net to $25.00 ($50.00 recouped less $25.00 interest paid), so the payment is $650.00 − $25.00 = $625.00, which matches the payment amount in the file.
The example uses made-up names and numbers.
Questions
Does my file get uploaded?
No. This page is served with a policy that blocks every kind of network request from the page, so it has no way to send your file anywhere. You can disconnect from the internet after the page loads and it still works.
Which files does it read?
Standard 835 health care claim payment files (version 5010), including files that hold several payments. Line breaks and unusual delimiters are handled.
Does it explain the reason codes?
It shows the group and reason codes exactly as they appear in the file, with a short plain-language meaning for the adjustment group. It does not include the published code description text.
What if a file does not balance?
The failed check is shown with the amounts involved, and any export is marked UNVERIFIED so it is not mistaken for a checked result.
This tool calculates and checks numbers. It is not legal, tax, or medical advice.