Travel and vehicles

Work out your car's monthly cost from a bank statement alone

No car log? Use three months of bank statements to find fuel, FASTag, service, insurance, EMI and parking, then divide to get your monthly car cost.

Editorial illustration for Work out your car's monthly cost from a bank statement alone

You can work out what your car costs each month from bank statements alone. Download three months, pick out the merchants that are car-related, add each group, add a monthly share of yearly bills, then divide by three. It takes about half an hour, and it is a good first estimate even if you have never kept a log.

Which statements do I need, and for how long?

Three months is a sensible minimum because fuel and service bills move around. Six is better if a big repair or a long trip landed in the window. Download statements for every account you pay from: the salary account, any credit card, and a wallet if you top up FASTag from it. Use your bank's own statement option and check the file you get rather than assuming the layout. Open PDFs in a way that lets you copy rows, or ask for CSV or Excel.

Search the narration or merchant column for words you recognise: the petrol pump names near you, FASTag, toll, motors or workshop names, your insurer, the finance company that holds the loan, and parking apps. Make a list of those merchants on a separate tab so the second month goes faster. In a sheet, =SUMIF($B$2:$B$300, "*FASTAG*", $C$2:$C$300) adds every amount whose merchant text contains FASTAG, because SUMIF accepts wildcards and ignores letter case. Replace the text in quotes with each keyword in turn.

A worked example with made-up numbers

Suppose three months of statements give these totals.

GroupThree-month total
Fuel (card and UPI at pumps)₹23,400
FASTag recharges₹3,000
Workshop and service₹6,200
Insurance (renewed last year at ₹21,600, so ₹1,800 a month)₹5,400
Loan EMI (₹14,500 a month)₹43,500
Parking paid by card or UPI₹900
Total from statements₹82,400

Divide by three and the statement-only monthly cost is ₹27,467, rounded. Notice that the insurance row is not what actually left the account in those months. A yearly premium usually falls outside your window, so use last year's amount divided by twelve and then multiplied by three.

What will the statement miss?

  • Cash fuel: if you sometimes pay ₹500 or ₹1,000 at the pump in cash, those fills are invisible.
  • Cash parking, valet tips and small toll payments on routes without FASTag.
  • Anything a family member paid from another account.
  • Depreciation, which is not a payment at all, so it will never appear on a statement.

To estimate cash, think of the last two weeks. Say you paid cash about once a month for ₹1,000 of fuel. Add ₹1,000 for each of three months: ₹82,400 plus ₹3,000 is ₹85,400, and ₹85,400 divided by three is about ₹28,467 a month. Label that figure as an estimate, since you guessed part of it.

Can SpendixAI do the sorting for me?

It can help with the repetitive part. You pick the account first, upload the statement as a PDF, CSV or Excel file, and review the rows before they are saved. Categories come from your own rules, then your history, then AI if you leave it on. Not every statement layout will parse perfectly, so scan the preview. Once the rows are categorised, a car category gives you the totals without any wildcard formulas.

A rough check on the answer: divide the monthly total by the kilometres you usually drive in a month. A figure that surprises you in either direction is worth a second look at the list of merchants you included, in case a line from a different vehicle or a family member slipped in.

Next step

Once you have the monthly figure, start a simple log for what the statement cannot show: odometer on the first of each month and a note for each cash payment. After a quarter you will know how far off your estimate was.

SPENDIXAI JOURNAL

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

Explore your reports