For an owner-driver, the daily question is simple: after fuel, toll and parking, what did the cab earn? One row a day, with kilometres, fares and running costs, answers that, and a few formulas give cost per km, weekly earnings and a monthly line for EMI and servicing. The sheet below takes about two minutes a day to keep up.
What columns go in the daily row?
| Column | Heading | Notes |
|---|---|---|
| A | Date | One row per day worked |
| B | Km run | Odometer end minus start |
| C | Fares | Cash and app payouts, total for the day |
| D | Fuel | Petrol, diesel or CNG |
| E | Toll | From FASTag messages or statement |
| F | Parking | Parking and entry |
| G | Running cost | =D2+E2+F2 |
| H | Net for the day | =C2-G2 |
| I | Running cost per km | =IF(B2=0, "", G2/B2) |
What does a day look like in numbers?
Say a day shows 180 km, fares of ₹3,200, fuel of ₹1,100, toll ₹140 and parking ₹60. Running cost is 1,100 + 140 + 60 = ₹1,300. The net for the day is 3,200 - 1,300 = ₹1,900. Cost per km is 1,300 divided by 180, which is about ₹7.22. These are sample figures to show the arithmetic.
That ₹1,900 is not take-home pay. EMI, servicing, insurance and tyres still have to come out of it.
How do you handle app commission?
If an app deducts its commission before paying you, you may only see the payout. Record the payout in column C, or add a column for the gross fare and one for commission so you can see how much the platform takes over a month. Whichever you choose, use it on every row.
How do you add the EMI and servicing reserve?
On a Monthly tab, put the fixed monthly costs in cells: EMI, insurance (monthly share) and parking pass if you have one. Then add a servicing reserve per km. Suppose a service every 10,000 km costs ₹6,000. Then the reserve is 6,000 divided by 10,000 = ₹0.60 per km. These numbers are only an example, so use your own workshop bills.
- Km for the month: =SUMIFS(Daily!$B$2:$B$400, Daily!$A$2:$A$400, ">="&A2, Daily!$A$2:$A$400, "<"&EDATE(A2,1))
- Net for the month: the same SUMIFS on column H
- Servicing reserve: =km for the month x reserve per km
- Real earnings: net for the month minus EMI minus reserve minus other fixed costs
How do you see weekly earnings?
Add a Week column with =A2-WEEKDAY(A2,2)+1, which gives the Monday of that date's week. A summary with =SUMIFS(Daily!$H$2:$H$400, Daily!$J$2:$J$400, A2) for each Monday gives weekly net. You will quickly see which weeks are weak because of festivals, rain or a few idle days.
What to do with the numbers
- Compare cost per km across weeks. A sudden rise usually points to more idle running or a fuel change.
- Compare net per working day with your EMI per day, which is the monthly EMI divided by days worked.
- Keep a separate note of the next service due in km, taken from the odometer.
How do you measure idle time?
Add a column for hours on duty and one for paid km. Total km minus paid km gives the distance you drove without a passenger, such as returning from a drop. A rising gap means more empty running, and you can test whether staying near a busy pickup point or accepting a longer trip changes it. Even a rough estimate entered at day end is better than a guess at month end.
Review the gap monthly alongside cost per km, because the two together explain most changes in what is left at the end of the month.
Fuel, toll and EMI payments all show up on your bank and card statements. If you import them into SpendixAI, you can check the sheet against the real debits at month end.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


