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​