Skip to main content

Export & trace

Outcome

You can export the receivable's lines as a CSV for a payer call or appeal, and you can read the Trace tab to confirm provenance — which loop and segment produced which UI row.

Prerequisites

ScopeWhat it lets you do
billing.receivable.readView the tabs
report.exportExport CSV

The Trace tab

Trace renders the raw 835 with the structural mapping the platform applied:

SectionContents
EnvelopeISA / GS / ST headers.
HeadingBPR / TRN / DTM envelope amounts and dates.
Payer / Payee1000A / 1000B N1 loops.
Claim loops2100 CLP per claim with nested SVC lines.
FooterPLB / SE / GE / IEA.

Click a UI row in any other tab → the Trace tab highlights the source segment. This is how you defend an interpretation: "We posted X because the file said Y at loop Z."

Reading PLBs

PLB rows are file-level adjustments not tied to a specific claim:

Reason codeMeaning
WOWithhold (e.g. provider takeback).
FBForwarding balance.
IRInternal revenue service / tax.
L6Interest.
CVCapitation.

PLB amounts post to the global adjustments ledger; they don't shift a specific claim's balance.

Export CSV

  1. Click Export lines in the receivable's toolbar.

  2. Pick the columns and the line filter (all lines, exception lines, specific claim).

  3. The platform writes a CSV + an audit.report.export row. The file lands in your browser; for tenants with retention policies the file also writes to the audit-archive bucket.

The CSV columns:

ColumnSource
claim_idOur claim ID.
payer_claim_control_numberCLP01.
member_idOur member ID.
member_nameMember name.
dos_from / dos_toDTM*150 / 151.
billed / paidCLP03 / CLP04.
casConcatenated CAS list.
rarcConcatenated LQ list.
posted_amount / expected_amountComputed.
varianceComputed.
tagsUser tags.

Use cases

Use caseWhat you export
Payer call about underpaymentExport filtered to one claim with full CAS list.
Appeal packageExport filtered to a denial group; attach to the appeal.
Reconciliation handoffExport full receivable + add to handoff folder.
Discrepancy escalationSame; tag with escalate.

Validation

CheckExpected
Trace highlights the source segment when you click a UI rowYes.
Export produces a CSV with audit rowYes; audit row carries actor + filter.
PLB amounts equal global adjustments ledger entriesYes.
Export filtered to exceptions only includes thoseYes.

Troubleshooting

SymptomCauseFix
Export greyedYou lack report.exportAsk admin.
CSV totals don't reconcile to the Trace footerFilter excluded global adjustmentsRe-export All lines.
Trace highlight doesn't move on clickStale renderHard refresh; the loop links should update.
PLB amount appears twice in the ledgerPre-existing duplicate from a prior repostReverse the second one with a reason.

Where to next