Life events

A driver’s overtime and fuel log for the family car

A simple daily log for a household driver's hours, overtime and fuel purchases, with formulas that give you the monthly pay and fuel total in minutes.

Editorial illustration for A driver’s overtime and fuel log for the family car

A driver's log needs only seven columns: date, start time, end time, hours, overtime hours, fuel bought and a notes cell. At month end, the totals give you his overtime pay and your fuel spend without any memory-based arguments. A paper diary or a spreadsheet both work, as long as it is filled in daily.

Agree the rules before you start the log

  • How many hours make a normal day, for example nine, and whether the day starts when he leaves his house or when he reaches yours.
  • The overtime rate per hour, and whether it applies after the normal hours or only after a certain time at night.
  • Weekly off day, and what is paid if he works on it.
  • Who pays for fuel, tolls, parking and washing, and how those receipts are handled.

These are household decisions, so make them together and note them on the first page of the log.

The template

DateStartEndHoursOvertime hoursFuel boughtNotes
3 Mar8:0017:309.50.5₹0Airport drop
4 Mar8:3021:0012.53.5₹3,200Dinner event, full tank
5 Mar9:0018:0090₹0Normal day

If you use a spreadsheet and enter Start in column B and End in column C as times, the hours in column D are =(C2-B2)*24. Overtime in column E, with nine as the normal day, is =IF(D2>9,D2-9,0). At the bottom, total overtime is =SUM(E2:E32) and overtime pay is that total multiplied by the agreed hourly rate. Fuel total is =SUM(F2:F32).

A worked example with hypothetical numbers

Say his monthly salary is ₹15,000 for normal hours, the agreed overtime rate is ₹100 an hour, and over the month his overtime hours add up to 14. Overtime pay is 14 x 100 = ₹1,400. Salary plus overtime is 15,000 + 1,400 = ₹16,400.

He also bought fuel three times: ₹3,200, ₹2,900 and ₹3,500, a total of ₹9,600. So the whole cost of having the car driven that month, apart from the car's own fixed costs, is 16,400 + 9,600 = ₹26,000.

How do you keep fuel entries honest and simple?

If he pays for fuel in cash and you reimburse him, keep the fuel receipt in a small envelope or take a photo, and record it against the day. If you give him a card or fuel account, the statement is the record, and you only need to match entries to the log. Either way, note the odometer reading at each fill, so you can see how many kilometres each tank covered.

What about tolls, parking and washing?

Give each its own column or its own tab so the driver's salary does not get mixed with the car's running costs. FASTag toll deductions usually appear on the linked account's statement. Parking and car washes paid in cash can be added by hand when he hands you the receipts.

Where this fits in your wider records

Pay to a driver and fuel for the car belong in different categories, because one is a household staff cost and the other is a vehicle running cost. SpendixAI lets you keep custom categories and sub-categories, so importing your bank or card statement and adding cash fuel or salary by hand puts both in the right place. The daily hours log stays your own sheet.

Month-end routine

  1. Check that every working day has a start and end time.
  2. Total overtime hours and multiply by the agreed rate.
  3. Add the overtime to salary and show him the totals before you pay.
  4. Total fuel and tolls separately, matching receipts to entries.
  5. Save the month's sheet and start a clean copy for the next month.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports