# EDI 835 Electronic Remittance Advice (ERA) to CSV/Excel Converter
> Convert cryptic ANSI X12 835 Electronic Remittance Advice (ERA) files into flat tabular CSV and Excel-ready formats for accounting, reconciliation, and revenue cycle reporting.

- **Canonical URL:** https://stanzaapi.com/tools/x12-parser/converter/edi-835-to-csv
- **Governing Standard:** ANSI ASC X12 Standards (005010) (Accredited Standards Committee X12 / HIPAA 5010)
- **Edge Latency SLA:** <3ms Edge (Cloudflare V8 Isolates)
- **Execution Model:** Pure compute $f(x) = y$, 100% In-Memory (Zero Store, Zero Log)

## Technical Overview & Governing Rules
Translates hierarchical 835 ERA remittance loops into flat rows suitable for Excel, Google Sheets, or SQL bulk inserts.

Flattens CLP claim payment loops, SVC service lines, CAS contractual adjustments, and BPR check/EFT transaction details.

Runs with zero data retention on Cloudflare V8 edge compute.

## Specification Matrix
| CSV Column Name | 835 Source Segment | Description |
| --- | --- | --- |
| Check / EFT Trace Number | TRN02 | Unique payment identification number |
| Payment Date | BPR16 | Check issue or ACH effective date |
| Payer Name | N1*PR | Health plan or commercial insurance carrier |
| Patient Control Number | CLP01 | Provider invoice/account identifier |
| Total Billed Charge | CLP03 | Total original charge submitted on 837 |
| Amount Paid | CLP04 | Net insurance reimbursement |
| Patient Responsibility | CLP05 | Deductible, coinsurance, or copay |
| Adjustment Group / Reason | CAS01 / CAS02 | CARC code (e.g. CO-45 contractual write-off) |

## Standard JSON Response Model
```json
{
  "format": "csv",
  "columns": [
    "TraceNumber",
    "PaymentDate",
    "Payer",
    "ClaimNumber",
    "Billed",
    "Paid",
    "AdjustmentCode",
    "AdjustmentAmount"
  ],
  "sampleRow": [
    "123456789",
    "20260830",
    "BLUE CROSS",
    "CLM001",
    "2000.00",
    "1500.00",
    "CO-45",
    "500.00"
  ]
}
```

## Frequently Asked Questions & Edge Cases
### Q: Why convert 835 files to CSV?
**A:** EDI 835 files use complex nested delimiters that accounting and revenue cycle management teams cannot view in Excel. Converting to CSV allows immediate auditing of denials and underpayments.