# Taxi and Uber driver income sheet Excel (free)

> Free Excel sheet for Uber and taxi drivers: log shifts, deduct commission, rent and fuel, and see net per day, hour and km with weekly and monthly totals.

Source: https://softwiro.com/blog/taxi-driver-income-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Taxi and Uber driver income sheet in Excel (free): trips, fuel and commission

See what is really left after commission, fuel and the car rent, by day, week and month, and which hours pay best.

15 November 2026 6 min read

## In short

- Type one line per shift; the sheet deducts each platform's commission, the daily car rent and estimated fuel to give the shift's net.
- Commission rates are set per platform (the sample rates are examples) and are never charged on tips.
- The fuel log gives litres per 100 km and the cost per km, which feeds each shift's fuel estimate.
- Weekly and monthly totals use the fuel you actually paid and your expenses, with net per hour and per km.
- The summary shows the best day, weekday and period, with four charts.

You drive for Uber, Didi, inDrive or a street taxi, and at the end of the day you want to know what is really left after the platform's commission, fuel and the car rent, and which days, periods and platforms deserve your hours. The free [taxi and Uber driver income sheet](https://softwiro.com/templates/taxi-driver-income) does that: you type one line per shift and the sheet works out the rest.

## The problem it solves

What the platform app shows is the fare, not what you keep. A commission that differs from platform to platform comes off the fare, the car's daily rent goes to its owner if you rent it, fuel is paid in lumps that do not show day by day, and upkeep arrives as large surprise amounts. So a day can look big in the app and be weak after deductions, while another day is unfairly judged because it contained a fill-up. The sheet puts all of this in one place and gives you the net of each shift, week and month.

## How the sheet works, step by step

1. In Settings type today's date, any date in the month you are reviewing, the daily car rent (type 0 if the car is yours), and the first day of week one.
2. In المنصات (Platforms) type the platforms you drive for and each one's commission rate as shown in its statements. The names and rates in the file are examples, so change them.
3. In الورديات (Shifts) add a line per platform per day: date, platform, period (morning, noon, evening or night), odometer start and end, hours online, trips, cash fares, card fares and tips.
4. In الوقود (Fuel) type each fill-up in order: date, odometer, litres and price per litre.
5. In المصروفات (Expenses) type upkeep, washing, tyres, insurance and any other car expense.
6. Open الأسابيع (Weeks), الشهور (Months) and الملخص (Summary) to read the result.

The core rules: **commission = gross fare × the platform's rate** (it is not charged on tips), **shift net = fare − commission + tips − car rent − estimated fuel**, **estimated fuel = the shift's km × fuel cost per km** taken from the fuel log, and **month net = fare − commission + tips − rent − fuel actually paid − expenses**.

## What each sheet holds

- Settings: the dates, the daily rent and net-per-day target, the fuel cost per km and the average consumption.
- Platforms: each platform's commission rate with the month's trips, fares, commission, net and balance with the platform.
- Shifts: one line per shift, with km, commission, rent, net and net per hour calculated.
- Fuel: the fill-ups, litres per 100 km and cost per km.
- Expenses: everything you spend on the car except fuel.
- Weeks and Months: the totals and net of each period.
- Summary: the month's net, the best day and period, and four charts.

## Walk-through on the sample numbers

The figures below are sample data for October 2026 inside the sheet, not a real driver, and the fuel price (20), the rent (250) and the commission rates are examples.

- The 3 October shift on Uber: 85 km in 7 hours and 14 trips, fares 868 (608 cash and 260 card). Commission 25% = 217, rent 250, estimated fuel 85 × 1.68 = about 142.93. Net = 868 − 217 − 250 − 142.93 = 258.07, about 36.87 an hour.
- The car: ten fill-ups logged, average consumption 8.41 litres per 100 km and a fuel cost of 1.68 per km.
- All of October: 24 working days, 27 shifts, 219 hours, 477 trips and 3,086 km. Fares total 33,832 (20,113 cash and 13,719 card). Commission is 6,782.45 (about 20% of fares), tips 530 and rent 6,000, so net before fuel and expenses is 21,579.55. Fuel paid was 5,938 and expenses 2,700, giving a month net of 12,941.55.
- Indicators: net per working day 539.23, per hour 59.09, per km 4.19 and an average fare of 70.93.
- Platforms: Uber 194 trips, fares 13,846, commission 3,461.50 and a platform balance (card 4,637 − commission) of 1,175.50 owed to you. Didi fares 8,758, commission 1,751.60, balance 2,906.40. The street taxi 2,340 with no commission.
- Days and periods: the best day is 10 October at a net of 1,033.49, the weakest 3 October at 258.07, and five days fell under the target of 450. Evening is the best period for net per hour (94.74 against 64.86 in the morning) and Tuesday the best weekday (90.12). These are differences in a small sample, so read your own pattern after two or three months.

## Common mistakes

- Typing the fare after commission: type the gross fare, otherwise commission is deducted twice.
- Forgetting a fill-up or typing an odometer lower than the previous one: consumption goes wrong, and the sheet turns the cell red so you correct it.
- Judging a platform by its big fares: compare net per hour after commission, not the fare.
- Skipping big expenses: insurance, tyres or brakes change the month's net, so log them on their day.
- Assuming a rest day is free: rent is deducted only for logged days, so if the owner charges you for every day, add an empty line for those days.

## When to move to a system

The sheet suits one driver with one car. Once you have several cars and drivers, want each driver to log from a phone, settle each one's rent and see profit per car, a system Softwiro builds around your way of working fits better. To track oil and filter dates by kilometre use the [personal car maintenance sheet](https://softwiro.com/templates/car-maintenance-log), and for a fleet the [fleet fuel and maintenance sheet](https://softwiro.com/templates/fleet-fuel-maintenance) and its [guide](https://softwiro.com/blog/fleet-fuel-maintenance-free-excel-online.html).

## Your next step

Download the sheet, open Platforms and type your platforms with each commission from the latest statement, then log today's shift on one line. After two weeks open the Summary and read net per hour by period before you change your working hours. Taxes and insurance follow local law and are not calculated by the sheet.

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: taxi and Uber driver income (1/3)](https://softwiro.com/uploads/cheatsheets/taxi-driver-income/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/taxi-driver-income/en-1.jpg)[![Cheat sheet: taxi and Uber driver income (2/3)](https://softwiro.com/uploads/cheatsheets/taxi-driver-income/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/taxi-driver-income/en-2.jpg)[![Cheat sheet: taxi and Uber driver income (3/3)](https://softwiro.com/uploads/cheatsheets/taxi-driver-income/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/taxi-driver-income/en-3.jpg)

0 downloads · 3 pages

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Questions this raises

### Do I type the fare before or after commission?

Type the gross amount the passengers paid, before the platform's commission. The sheet works out commission from the platform's rate; if you type the fare after deduction, commission is taken twice.

### How does the sheet count fuel for each shift?

As the shift's km × the fuel cost per km worked out from the fuel log. It is an estimate because fuel is paid in lumps; week and month net use the fuel you actually paid.

### What do I type for the rent if the car is mine?

Type 0 in Settings and nothing is deducted. If you pay a rent, type it and it is deducted once for each logged working day, even if you drive for two platforms.

### Can I change the platform names and commission rates?

Yes, the names and rates are examples. Type your platforms and the rates from each platform's statements; new platforms appear in the drop-down on the Shifts sheet.

### Does the sheet calculate taxes and insurance?

No. Taxes and insurance follow local law. You can log what you pay in Expenses so it counts in your net.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
