Finance: trip ledger and remittance

The Finance page (sidebar → Finance & reports → Finance) answers the question Billing can't: not "what did we bill?" but "what did we actually get paid?" It has two tabs: Trip ledger and Remittance.

Trip ledger

The ledger shows every billed trip — claimed, invoiced, or submitted from Billing — with billed vs. collected amounts. Its numbers tie out to the Billing page's figures for the same range.

KPIs

• Total billed — with the count of trips billed in the range
• Collected, Outstanding, Collection rate, and Trips

Filters

Set the Date range, then narrow by Billing status (All / Claims / Invoices / Submitted), Payer type (Broker, Payer / facility, Private pay), a specific Payer, and Payment status — Paid, Underpaid, Overpaid, Unpaid, Awaiting (invoice sent), or Uninvoiced. Reset clears everything.

Reading the table

Each row shows Date, Member, Payer, Type (Claim/Invoice), Billing status, Billed, Collected, Variance (red when you collected less than you billed), and a Payment status badge.

Tip: Filter Payment status to Underpaid at month end — that's your short-pay follow-up list, with the variance per trip already computed.

Remittance

The Remittance tab reconciles what your broker actually paid against what each trip should have paid. It has two inner tabs:

Upload

Upload the remittance/payment file you receive from the broker. ZeitRide matches its lines to your trips by trip ID and service date.

Reconciliation

Each matched trip shows Expected, Paid, Variance, and a Status — Paid in full, Underpaid, Overpaid, Unpaid, Paid (no expected), or Pending review — along with the member, driver, vehicle, facility, and whether the claim was submitted. Filter by broker, payer category, status, batch file, facility, route, driver, or vehicle.

Lines from the file that couldn't be matched to any trip appear in the Unmatched remittance lines table with the file, external ID, paid amount, and service date, so nothing silently disappears.

How the pieces fit

1. Billing — generate and submit claims/invoices (billed amounts).
2. Finance → Remittance — upload broker payment files as they arrive; ZeitRide computes per-trip variance.
3. Finance → Trip ledger — the rolled-up truth: billed, collected, outstanding, and the trips needing follow-up.

Access to Finance follows the same permission as Billing, so your billing team sees both.