Budget and cost · Free Excel template

Ride-Hailing Fleet Partner Weekly Settlement

For fleet partners who run cars and drivers on ride-hailing apps. Copy each app's weekly statement into the workbook, and it checks the payout, works out the company share under weekly rent, a commission share or a salary, what each driver earned, what you owe them or they owe you, and the profit of each car per month.

Free: enter your name, email and job title and we email you the file. It works in Excel, Google Sheets and LibreOffice Calc, with no macros.
  • Statement payout check
  • Due to or from each driver
  • Profit per car per month
safee-ride-hailing-fleet-partner-settlement-en.xlsx
WeekAppDriverNet earningsCash heldPayout differenceCompany shareDriver earningsDue to driverFlags
10-05App AKhalid Shammari5801600320159100
10-05App BKhalid Shammari1545300154101
10-05App ASaad Mutairi667133−3195.30359.70338.70Payout differs from statement
10-05App CNayef Dosari595120059050
10-12App ASaad Mutairi7031410206.10376.90355.90Long online hours
Example rows in US dollars for apps named App A to C; rename them to the apps you work with. The $1 payout allowance and 72-hour weekly limit are example values on Settings.
What's in the file

From the app statement to each driver's balance

Each week the apps pay the fleet, the drivers hold some cash, and the company and the drivers split what is left under their contracts. The workbook does that split the same way every week and shows whether each car pays for itself.

  1. 01

    Weekly settlement

    One row per driver, app and week: trips, online hours, gross fares, app fee, tips, incentives, cash collected, the statement payout and the calculated payout, fuel and costs the driver paid, company share, driver earnings, due to the driver and the balance, with six flags.

  2. 02

    Car profit

    One row per car per month: trips, net earnings, company income and fuel the company carries from the settlement, then installment, insurance, maintenance, permits, driver salaries and other costs, and the car's profit.

  3. 03

    Summary

    For the month: trips, hours, gross fares, app fee %, tips and incentives, net earnings per trip and per hour by app, and net earnings, company share, driver earnings, due, paid and balance by driver.

  4. 04

    Settings

    Each driver's pay terms from their contract (weekly rent, company share or salary, who pays fuel) and car, the apps and cars, the payout allowance and the maximum online hours a week.

What does a ride-hailing fleet partner settle each week?

A fleet partner owns or leases cars and puts drivers on ride-hailing apps. Each week every app sends a statement per driver: the fares riders paid, the app's fee, tips and incentives, and the cash the driver collected from riders who paid in cash. The app pays the partner the balance. The partner then has to settle with each driver: take the rent or the company's share, refund fuel or costs the company carries, and pay the driver what is left, or collect from a driver who holds more cash than their share.

Done by hand, this is where weeks go missing, cash is counted twice and the same rent is charged twice for a driver on two apps. The workbook settles every row the same way and keeps a running balance per driver.

How to use the weekly settlement workbook

  1. Set up once: enter each driver's pay terms from their contract, their car, your apps and your cars on Settings.
  2. Every week, copy each statement: one row per driver and app with trips, online hours, gross fares, fee, tips, incentives, cash collected and the payout.
  3. Add receipts: fuel the driver paid and company costs they paid, such as tolls or parking.
  4. Check the flags, then record what you paid each driver (or received from them, as a negative number) so the balance shows zero.
  5. Each month, add each car's costs on Car profit and review the Summary.

How does the workbook calculate?

Net earnings = gross fares − app fee + tips + incentives Calculated payout = net earnings − cash collected by the driver Company share = weekly rent, on the driver's first row of the week (weekly rent) = (net earnings − tips − fuel if "Before the split") × share (commission share) = net earnings − tips (salary) Driver earnings = net earnings − company share − fuel the driver carries Due to driver = driver earnings − cash collected + fuel and costs the driver paid Car profit = company income − fuel the company carries − monthly costs

Tips stay with the driver under every model. Weekly rent is charged once a week even when a driver works on two apps. A negative amount due means the driver holds more cash than their share and owes the company. The flags are: statement payout differs from the calculated payout by more than the allowance, the driver owes the company and has not paid, online hours above your weekly maximum, trips with no earnings, a driver missing from Settings, and a week not settled. The allowance and the 72-hour maximum are example values; set your own.

Worked example: three drivers in the week of 5 October 2026

The example rows in the file cover four weeks of October 2026 in US dollars.

  • Khalid, weekly rent of $320, pays his own fuel: on App A, net earnings of $580 ($661 fares − $132 fee + $11 tips + $40 incentives). The company takes the $320 rent on this first row. His earnings are $580 − $320 − $101 fuel = $159; he holds $160 in cash and paid $101 for fuel, so $100 is due to him. On App B the same week no rent is charged again, and $101 is due.
  • Saad, 30% company share: net earnings of $667, $651 without tips, so the company's share is $195.30. Due to him: $359.70 − $133 cash + $112 fuel = $338.70. The statement payout of $531 is $3 below the calculated $534, so the row is flagged.
  • Nayef, on salary: the company keeps $590 of net earnings and his $5 tips are his. His fuel and tolls are refunded against the $120 cash he holds: nothing is due either way.
  • For October, CAR-01 on weekly rent makes $346 after its costs, CAR-03 on salary $120, while CAR-02 on a 30% share loses $162.40: on these figures the share does not cover the car.

What do Saudi rules say about app-based passenger transport?

In Saudi Arabia, passenger transport through apps is an intermediation activity licensed by the Transport General Authority (TGA). The executive regulation for intermediation in passenger transport by cars through electronic applications, decision 6/18 of 1447/03/01 AH, makes linking the intermediation system to the authority's electronic platform a licensing condition. The executive regulation for taxi transport and taxi intermediation was published in Umm Al-Qura on 2 September 2025. Check the Naql portal for the requirements on your cars and drivers.

Common mistakes in fleet partner settlement

  • Charging the weekly rent on every app: a driver on two apps pays one rent a week.
  • Forgetting the cash the driver holds: cash rides are already in the driver's pocket; they come off what you pay them.
  • Taking a share of tips: tips belong to the driver under every model here.
  • Not checking the payout: compare each statement payout with the calculation; differences are cheaper to raise in the same week.
  • Judging a car by its fares: under a share model a busy car can still lose money once its installment and insurance are paid.

What the template does not do

The workbook calculates from the statement figures you enter; statement line names differ by app, so map them to the columns once. It does not read statements, bank transfers or tracking data. Pay terms come from your driver contracts, and activity rules from your regulator. To compare pay models before you sign a driver, use the Taxi & Limousine Profit and Driver Pay Calculator; for cars that change hands every shift, use the Taxi Shift Handover and Cash Settlement Sheet.

Sources

  • Executive regulation for intermediation in passenger transport by cars through electronic applications, decision 6/18 of 1447/03/01 AH (Art. 3: linking the intermediation system to the authority's platform). Source: Qanoniah.
  • Executive regulation for taxi transport and taxi passenger intermediation, Umm Al-Qura 2 September 2025. Source: Qanoniah. Last reviewed 21 October 2026.
Related Safee solution

See how each car is used between statements

Safee's Asset Utilization report shows the distance each car covers per day and the days it did not move, and the Driver Trips report counts each driver's trips by day or month. The Out of Working Hours alarm fires when a car moves outside the hours you set, so personal use shows up before the statement does.

  • Asset Utilization report with daily distance and idle days per car.
  • Driver Trips report with each driver's trips by day or month.
  • Out of Working Hours alarm when a car moves outside the hours you set.
  • Scheduled reports by email at the interval you choose.
FAQ

Questions about ride-hailing fleet partner settlement

Want to see how every car in your fleet is used each day? Talk to Safee.

How do I calculate what to pay a ride-hailing driver each week?

Start from net earnings (fares − app fee + tips + incentives), take off the company share for the driver's pay model and any fuel the driver carries, then take off the cash the driver already collected and add back fuel and costs they paid for the company. The workbook does this per row.

What if the driver holds more cash than their share?

The amount due is negative: the driver owes the company. Record what you collect as a negative payment, and the balance returns to zero.

Which pay model is best for a fleet partner?

It depends on your cars' costs and how steady the earnings are. The Car profit sheet shows which cars cover their costs under their model; the profit calculator compares models before you agree terms.

Why does the payout on the statement differ from the calculation?

Adjustments, refunds to riders, fees for cancelled trips or a missed cash entry. The workbook flags differences above your allowance so you can raise them with the app in the same week.

Can I use it with several apps?

Yes. Rename App A to C on Settings to the apps you work with, and enter one row per driver per app per week. Weekly rent is charged once per driver per week.

Does it work in Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it in Google Sheets. It also works in Excel and LibreOffice Calc, with no macros.

Next step

Know how each car is used every day

Tell us how many cars you run on apps, and we will show you Safee's utilization and trip reports for a fleet like yours.

Related tools and templates

Run an app fleet on numbers

Get the report

Enter your details and we will email you the file.

Use your real name so the file arrives addressed to you. Don't worry, we won't flood you with emails or calls.

Scroll to Top