Try the sheet here, on the example
The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.
Example from the sheet
| التاريخ | المنصة | الفترة | ساعات الاتصال | عدد الرحلات | الكيلومترات | إجمالي الأجرة | العمولة | الضمان | صافي الوردية |
|---|---|---|---|---|---|---|---|---|---|
| 46298 | أوبر | صباح | 7 | 14 | 85 | 868.00 | 217.00 | 250.00 | 258.07 |
| 46299 | أوبر | ظهر | 10 | 21 | 131 | 1,449.00 | 362.25 | 250.00 | 646.47 |
| 46300 | ديدي | مساء | 8 | 18 | 127 | 1,368.00 | 273.60 | 250.00 | 640.85 |
| 46301 | إن درايف | ليل | 11 | 25 | 150 | 1,600.00 | 160.00 | 250.00 | 977.77 |
| 46302 | أوبر | صباح | 9 | 18 | 126 | 1,278.00 | 319.50 | 250.00 | 516.63 |
| 46303 | كريم | ظهر | 7 | 15 | 99 | 1,170.00 | 292.50 | 250.00 | 461.03 |
| 46305 | تاكسي الشارع | صباح | 5 | 12 | 95 | 792.00 | 0.00 | 250.00 | 412.26 |
| 46305 | ديدي | مساء | 5 | 13 | 88 | 949.00 | 189.80 | 0.00 | 621.23 |
| 46306 | أوبر | صباح | 11 | 22 | 144 | 1,760.00 | 440.00 | 250.00 | 867.86 |
| 46307 | أوبر | ظهر | 9 | 19 | 117 | 1,292.00 | 323.00 | 250.00 | 542.26 |
| 46308 | ديدي | مساء | 7 | 16 | 113 | 1,200.00 | 240.00 | 250.00 | 519.99 |
Example from the “الورديات” tab (Arabic), with the numbers and formulas that are in the file.
What is inside
- "الإعدادات" (Settings): Today's date, any date in the month you are reviewing, the daily car rent (enter 0 if the car is yours), the first day of the first week, the daily net target, and the lists of periods and expense types. It calculates fuel cost per kilometre and average consumption from the fuel log.
- "المنصات" (Platforms): The name of each platform you work on and its commission rate (the names and rates are examples for you to edit). Beside each: the month's trips, total fares, commission, tips, net, fare per trip, cash, card, platform balance and net per hour. Room for 20 platforms.
- "الورديات" (Shifts): One row per platform per day: date, platform, period, odometer, hours, trips, cash fare, card fare and tips. It shows kilometres, total fare, commission rate, commission, car rent, estimated fuel, net for the shift, and net per hour, per kilometre and per day. Room for 1,000 shifts.
- "الوقود" (Fuel): Each fill-up with its date, odometer reading, litres and price per litre. Beside it: cost, kilometres since the last fill-up, consumption per 100 km and cost per kilometre, with a warning when consumption is high. Room for 300 fill-ups.
- "المصروفات" (Expenses): Maintenance and repairs, tyres, car washes, phone, licence, insurance, fines and any other car expense, with date, type and amount. Room for 500 expenses.
- "الأسابيع" (Weeks): Twelve weeks, the first starting on the date you enter: working days, trips, kilometres, hours, fares, commission, tips, car rent, fuel paid, expenses, net for the week, and net per hour, per kilometre and per day.
- "الشهور" (Months): Twelve months with the same columns, so you can compare each month's net with the month before.
- "الملخص" (Summary): Figures for the month you are reviewing, from fares down to the month's net, your best and weakest day, a table by day of the week and another by work period, average car consumption, and four charts.
The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.
What makes it different
The sheet shows the number that matters: what is left after commission, car rent, fuel and expenses, not what the platform screen shows. You can see which platform, day and period gives the highest net per hour, and it reveals your car's fuel consumption and cost per kilometre, so you can decide when to work and when to rest.
How to use it
- In "الإعدادات" (Settings) enter today's date, any date in the month you are reviewing, the daily car rent if you rent your car (enter 0 if it is yours), and the first day of the first week.
- In "المنصات" (Platforms) enter the platforms you work on and each one's commission rate as shown in the platform's reports. The rates in the sheet are examples, so edit them.
- In "الورديات" (Shifts) add a row for each platform each day: date, platform, period, start and end odometer, online hours, number of trips, cash fare, card fare and tips.
- In "الوقود" (Fuel) enter every fill-up in date order: date, odometer reading, litres and price per litre. The sheet then works out your car's consumption and cost per kilometre.
- In "المصروفات" (Expenses) enter maintenance, car washes, tyres, insurance and any other car expense with its date.
- Open "الأسابيع" (Weeks) and "الشهور" (Months) for the net of each period, and "الملخص" (Summary) for the month's net, best days and periods, and the charts.
Before you start:
- The fare you enter is the total the passengers paid (before the platform's commission). Commission = fare × the platform's rate, and it is not charged on tips.
- Net for the shift = fare − commission + tips − car rent − estimated fuel. Estimated fuel = the shift's kilometres × cost per kilometre from the "الوقود" (Fuel) sheet, because fuel is paid for in lumps, not daily.
- Net for the week and month uses the fuel you actually paid for in that period plus the expenses from the "المصروفات" (Expenses) sheet, so it may differ slightly from the sum of the shift nets.
- Car rent (the amount you pay the car's owner) is deducted once for each recorded working day, even if you worked on two platforms the same day. A rest day with no row in the sheet carries no rent, so add a row with no figures if the owner charges you for it.
- Card fares are paid to you later by the platform after it deducts its commission, while cash is already with you. The "platform balance" column in "المنصات" (Platforms) = card − commission: positive means the platform owes you, negative means you must pay it from your cash.
- Fuel consumption assumes every fill-up fills the tank. If you only part-filled, consumption on that row is approximate.
- The sheet has room for 1,000 shifts, 20 platforms, 300 fill-ups, 500 expenses, 12 weeks and 12 months. For a fleet of several cars, use the fleet fuel and maintenance 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.
Still running this on Excel?
This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.
| In this sheet | In Custom Software from Softwiro |
|---|---|
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |
Frequently asked questions
Do I enter the fare before or after commission?
Enter the total the passengers paid, before the platform's commission is deducted. The sheet calculates the commission using the platform's rate. If you enter the fare after the deduction from the platform's report, the commission will be deducted twice.
How does the sheet calculate fuel for each shift?
From the shift's kilometres × cost per kilometre, which comes from the fuel log (what you paid at fill-ups ÷ the kilometres between them). It is an estimate because fuel is paid for in lumps. Net for the week and month uses the fuel you actually paid for in that period.
How do I handle car rent if the car is mine?
Enter 0 for the daily rent in "الإعدادات" (Settings) and nothing is deducted. If you pay rent, enter the amount. It is deducted once for each recorded working day, even if you worked on two platforms that day.
Can I edit the platform names and rates?
Yes. The names and rates in the sheet are examples. Enter your own platforms and the commission rate shown in each platform's report. You can add new platforms and they appear in the dropdown list in the "الورديات" (Shifts) sheet.
Is the template free?
Yes, with no sign-up and no email address. Use it, edit it and share it as you like.
Does it work in Google Sheets and on mobile?
The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.
What is the difference between the white and the gray cells?
You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.
Can I use the sheet from an AI assistant?
Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html
More free templates for: Transport and cars
More free templates
- Car rental fleet tracker (Excel)
- Fleet fuel and maintenance tracker (Excel)
- Car showroom accounts sheet
- Personal car maintenance log (oil and filter dates by kilometre and months)
- Parking garage management sheet (hourly and monthly)
- Car wash management sheet (packages, cards, workers, materials)
- Food factory sheet in Excel: recipes, batches, cost and shelf life
- Biscuit factory sheet: dough, lines, packing and scrap
- Detergent factory sheet: formulas, batches, cost and filling
- Detergent ingredients and their names: function, chemical name and use
- Pharma factory sheet: batch records, materials, QC and release
- Industrial waste management sheet: quantities, classification, recycling and cost
- Algebra rules summary sheet: laws, identities and solving equations with examples





