Templates

A monthly partner settlement you can check ride by ride.

We’ve laid out the rides, fees and passenger payments side by side. Use this sheet to agree the month’s activity with one partner, in one currency.

Download template · .csvFilled-in example

Templates

Filled-in example

Illustrative data only. Balance = agreed fee − collected by partner + adjustment. Positive: we owe the partner; negative: the partner owes us. This is the period’s activity before opening balances and transfers, not the final account balance.

The CSV includes the example rows. Open it as UTF-8 with commas as separators, replace the sample data and check the figures. It contains no formulas or automatic recalculation.

A monthly partner settlement you can check ride by ride. — 1
Period2026-10
Partner referencePARTNER-01
Booking referenceEX-101
Ride date2026-10-05
CurrencyEUR
Agreed fee80
Collected by partner0
Adjustment10
Adjustment noteApproved waiting; approval EX-A1
Balance90
A monthly partner settlement you can check ride by ride. — 2
Period2026-10
Partner referencePARTNER-01
Booking referenceEX-102
Ride date2026-10-12
CurrencyEUR
Agreed fee100
Collected by partner120
Adjustment0
Adjustment noteNo adjustment
Balance-20
A monthly partner settlement you can check ride by ride. — 3
Period2026-10
Partner referencePARTNER-01
Booking referenceEX-103
Ride date2026-10-20
CurrencyEUR
Agreed fee90
Collected by partner0
Adjustment-5
Adjustment noteAgreed deduction; approval EX-A2
Balance85
A monthly partner settlement you can check ride by ride. — 4
Period2026-10
Partner referencePARTNER-01
Booking referencePeriod total
Ride date
CurrencyEUR
Agreed fee270
Collected by partner120
Adjustment5
Adjustment note
Balance155

Templates

What goes in each field

We explain what to enter and what to check before sharing the document.

  • Period

    Use YYYY-MM and agree which pickup dates fall in the period, in the relevant local time zone.

  • Partner reference

    Use a stable supplier reference. Keep a separate sheet for each partner.

  • Booking reference

    Use the ride’s reference to match the booking and supporting documents. The total row is not a ride.

  • Ride date

    Enter the local pickup date as YYYY-MM-DD. Leave the total row’s date blank.

  • Currency

    Use the three-letter code. Never add amounts in different currencies together.

  • Agreed fee

    Enter the total amount payable to the partner for the ride, including any applicable tax. Use full payable amounts for adjustments too.

  • Collected by partner

    Enter passenger money the partner actually holds on our behalf, not money we collected ourselves.

  • Adjustment

    Add an agreed extra with a positive amount; use a negative amount for a deduction. Do not count it twice in the fee.

  • Adjustment note

    Record the reason and evidence or approval reference. State explicitly when there is no adjustment.

  • Balance

    Calculate fee minus collections plus adjustment for each ride. Add the ride balances for the period; recalculate after every edit.

TransferCRM

How we handle this in TransferCRM

Keep the information with the booking and reuse it in your daily work.

  • One carrier account

    We bring ride fees, passenger collections, adjustments and recorded payments together on the partner’s account.

  • Numbered statements

    We issue statements by balance currency, with PDF and CSV downloads. Later changes appear as differences on a subsequent statement.

How we handle this in TransferCRM

Before you use the template

Does a positive balance mean we pay the partner?

Yes, for the activity shown. A negative figure means the partner holds more than their fee and adjustments allow. Agree any opening balance and transfers separately before making a payment.

Can I combine currencies?

Keep separate sheets and totals for each currency. If you agree a conversion, record the rate and its date separately; this template does not convert amounts.

Does the CSV calculate totals or replace an invoice?

Neither. The CSV contains editable example values, without formulas. Recalculate every balance and total after editing. Use it for reconciliation alongside the documents required by your agreement.

Keep the ride and its paperwork together.

We bring bookings, communication, rates and partner settlements into one workspace.

Start your free trialCompare plans in detail

No credit card. 14 days free. Cancel anytime.