Trip Details File – Roundtrip

Getting Your File

Roundtrip emails your Trip Details File to your company's billing contact during each payment cycle. It lists every ride in that payment and what your company was paid for it, including any approved additional costs.

For security, each billing contact must be individually granted access. Missing a file, or need an older one? Contact the Billing Team at billing@roundtriphealth.com.

What’s in the File?

Column	What it Shows
Scheduled Start Time	The scheduled start time for the ride within Roundtrip. If the ride was a will call that was not launched but was completed, this will just say “Will Call”.
Ride ID	The Ride ID for the ride being paid out.
Trip Vehicle Type	The type of vehicle the ride was booked with.
Hospital Name	The name of the group the ride was booked under (in Organization > Group format)
Program Name	The program the ride was booked under for the group listed above. If no program was selected during booking, this will just show as “(blank)”.
Pickup Address	The scheduled pick-up address for the ride within Roundtrip.
Dropoff Address	The scheduled drop-off address for the ride within Roundtrip.
Patient Name	The name of the Rider that was transported.
CC Name	The name of the Ride Booker.
Mileage	The total scheduled mileage for the ride (this is only the ride distance and does not include any dead mileage).
TX Provider	The name of the Transportation Provider that completed the ride.
TX Payment	The total amount the provider was paid for the ride, including any additional transportation costs.
Billing Notes	Any miscellaneous notes from the Billing Team. For providers, this often includes any approved transportation costs (i.e. “Includes $100 dead mileage & $25 cancellation fee).

Working With Your File

Filtering: select the header row, click Sort & Filter → Filter, then use the dropdown on any column to narrow your results. Combine filters across multiple columns — including Hospital or Program — to drill down further. A "(blank)" or null cell means no data was entered for that ride.

Understanding a ride's cost: check the TX Payment column alongside Billing Notes. If TX Payment matches the missed connection fee listed in Billing Notes, the ride wasn't redispatched. If TX Payment is higher than that fee, the ride was redispatched after a missed connection, and the total includes both the completed ride's cost and the fee.

Totaling a group of rides: set your filters (for example, all rideshare rides in a specific program), and the total appears in your spreadsheet's status bar. Learn more about summing filtered data.

Rideshare fees are set by the rideshare provider and may vary by mileage and other factors.