If one vehicle serves both work and family, split its costs by use. Keep a trip log with each journey marked Business or Personal, work out the business share of the total kilometres, and apply that share to the EMI, fuel, service and insurance. This article shows the records only; what can be treated as a business expense is a question for your CA.
What do you need to keep?
- A trip log: date, start and end odometer reading, kilometres, and purpose marked Business or Personal
- Every cost with its date: EMI, fuel, service, insurance, tolls, parking
- The loan schedule and the lender's statement
- A short note of any trip that mixed purposes, with how you split it
Write the log on the day. Reconstructing a month from memory in the first week of the next one is how the numbers become guesses.
How do you work out the business share?
Take one hypothetical month. The odometer moved 2,000 km in total, of which 1,200 km was business and 800 km personal. In a sheet with the purpose in column C and kilometres in column D, the formula is:
- =SUMIF($C$2:$C$200,"Business",$D$2:$D$200)/SUM($D$2:$D$200)
That gives 1,200 / 2,000 = 0.60, or 60% business. Format the cell as a percentage.
How do you apply it to the costs?
Add up the month's costs. Say the EMI is ₹18,000, fuel ₹7,000, service averaged at ₹1,500 and insurance averaged at ₹2,000. The total is 18,000 + 7,000 + 1,500 + 2,000 = ₹28,500.
| Cost | Total (₹) | Business at 60% (₹) | Personal at 40% (₹) |
|---|---|---|---|
| EMI | 18,000 | 10,800 | 7,200 |
| Fuel | 7,000 | 4,200 | 2,800 |
| Service (averaged) | 1,500 | 900 | 600 |
| Insurance (averaged) | 2,000 | 1,200 | 800 |
| Total | 28,500 | 17,100 | 11,400 |
Check: 10,800 + 4,200 + 900 + 1,200 = 17,100, and 28,500 × 0.6 = 17,100. The personal column follows the same logic. If you are tracking the business side separately, the 17,100 is the figure you move across; the 11,400 stays in your household budget.
What if the share changes from month to month?
It will. In the next month, say 900 km of 1,800 km was business, so the share is 50%, and the business portion of ₹28,500 would be ₹14,250. Keep each month's percentage on its own row and calculate it again. Over a year, the average of twelve months is more reliable than any single month, and a steady log helps you see when a vehicle has shifted from mostly personal to mostly business.
What should you check with others?
- Your CA: how the business share of vehicle costs and interest should be treated for your situation, and what evidence they want
- Your lender and insurer: whether business use affects the terms of your loan or the cover on the policy
- Anyone who shares the business: how you split costs if the vehicle is used by partners
Where does SpendixAI help?
You can upload your bank statements to SpendixAI and sort EMI, fuel and service into custom categories, using sub-categories such as Vehicle, Business and Vehicle, Personal where that suits your records. The trip log itself stays with you.
How do you keep the log light enough to maintain?
Photograph the odometer at the start and end of each day you use the vehicle, and note the purpose in one word. Once a week, copy the entries into the sheet. If a trip mixes purposes, such as a client visit with a personal stop, record the kilometres to each part, or write down the rule you will follow and apply it every time. A simple, consistent rule beats a perfect one you abandon in a week. Every quarter, check that the log's total kilometres match the odometer.
Monthly routine
- Log every trip with its purpose, as it happens.
- At month end, calculate the business percentage.
- Add up the vehicle costs and split them by that percentage.
- File the log, the cost summary and the lender statement together.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

