To track more than one vehicle, give each vehicle its own sub-category (for example Car, Scooter, Papa's bike), file every fuel, service, insurance and repair entry under the right one, and split shared costs such as garage rent between them. After that, one filter gives you a per-vehicle total each month. The rest of this article shows the setup and a worked split.
How should I name the vehicle labels?
Use names that stay readable in a list: the nickname the family uses, not a registration number. Under a main Vehicles category, create one sub-category per vehicle, such as Car, Scooter and Papa's bike. If your tool does not allow two levels, add the vehicle as a prefix in the category name, like Car - Fuel and Scooter - Fuel. Keep the pattern the same for every vehicle.
What goes under each vehicle?
- Fuel or charging
- Servicing and repairs
- Insurance monthly share
- Parking or garage share
- Accessories and cleaning
Do not create a separate category for every possible cost. The vehicle label plus a short note such as service or tyre is usually enough.
What about a vehicle that someone else owns?
If you pay for your father's bike, give it its own label too. That way your own vehicle totals stay clean and you can see how much you spend on a family vehicle. Label it by whose it is, and the cost stays visible without being mixed into yours.
How do I split shared costs like garage rent?
Pick a rule and stick to it. Say garage rent is ₹3,000 and the car takes two-thirds of the space. Enter ₹2,000 under Car and ₹1,000 under Scooter as two separate manual entries. Other fair rules include equal halves or by number of days used. What matters is that the total of the splits equals the real payment.
Here is a made-up month after tagging.
| Vehicle | Fuel | Service | Insurance share | Garage share | Total |
|---|---|---|---|---|---|
| Car | ₹6,200 | ₹0 | ₹1,800 | ₹2,000 | ₹10,000 |
| Scooter | ₹900 | ₹450 | ₹300 | ₹1,000 | ₹2,650 |
| Papa's bike | ₹600 | ₹350 | ₹0 | ₹0 | ₹950 |
The month's vehicle spend is ₹13,600. Without the labels, you would only know that. With them, you see that the scooter's garage share is more than its fuel, a fact worth checking.
How do I read a per-vehicle total in a spreadsheet?
Keep one row per expense with columns for date, vehicle, type and amount. If amounts are in D and vehicle names in B, =SUMIFS($D$2:$D$500, $B$2:$B$500, "Car") totals the car. Add a date condition to limit it to one month, for example =SUMIFS($D$2:$D$500, $B$2:$B$500, "Car", $A$2:$A$500, ">="&$F$1, $A$2:$A$500, "<="&$F$2), where F1 and F2 hold the start and end dates.
Can SpendixAI do this?
It lets you create your own categories and sub-categories, so each vehicle can have one. Imported statement lines are matched by your rules and history, so once a pump or workshop is filed under Scooter, later lines from it follow. The report builder can filter and group your spending, which is how you would pull up a vehicle's total. Shared costs like garage rent would be added as two manual entries.
When a bill covers two vehicles at once, such as a single workshop invoice for the car wash and the scooter service, enter two lines rather than one. It takes a minute and keeps both totals true. If the invoice was one lump sum, split it by the line items printed on the bill.
Review the split once a year. If the scooter is now used mostly by someone else in the family, or the garage rent changes, adjust the rule from that month onward rather than rewriting old entries.
A short checklist
- Create one label per vehicle, including family vehicles you pay for.
- File the last three months of entries under the right label.
- Decide the garage and parking split rule and write it down.
- Review the vehicle totals at month-end.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

