Travel and vehicles

Match your FASTag statement to your trip log

Match your FASTag statement to your trip log: pair each toll row to a trip by date and plaza, mark unmatched rows, and see what they usually mean.

Editorial illustration for Match your FASTag statement to your trip log

To reconcile a FASTag statement, download it, then match each toll row to a trip in your log by date and plaza. Rows that match are fine; rows that do not are the ones to look at. They usually turn out to be a trip you forgot to log, someone else driving the car, or a charge worth querying.

How do you set up the match?

  1. Download the statement for the month from your tag issuer's app or portal. Check your own screen for where the option is.
  2. Copy it into a sheet with the date and time in column A, plaza in B and amount in C.
  3. Keep your trip log on a second sheet called Trips, with the date in column A and the plaza in column B.
  4. Add a Match column next to the statement rows and fill it with a formula.

In D2 on the statement sheet, enter =IF(COUNTIFS(Trips!$A$2:$A$200,INT(A2),Trips!$B$2:$B$200,B2)>0,"Trip found","Check") and copy it down. INT strips the time so that a date-and-time stamp is compared with a plain date. This works in Excel and Google Sheets provided the statement dates are real dates, not text.

What does a ten-row reconciliation look like?

All rows here are invented. A commuter has one plaza on the daily route and another on a monthly trip.

RowDate and timePlazaAmount (₹)Result
13 Nov 08:12Plaza A65Trip found
23 Nov 19:05Plaza A65Trip found
34 Nov 08:10Plaza A65Trip found
44 Nov 19:20Plaza A65Trip found
55 Nov 08:15Plaza A65Trip found
65 Nov 08:22Plaza A65Check: formula says found, but only seven minutes after row 5
75 Nov 19:00Plaza A65Trip found
88 Nov 07:40Plaza B240Trip found
98 Nov 20:30Plaza B240Trip found
109 Nov 11:15Plaza C110Check, no trip logged

The statement total is ₹1,045. Matched rows add up to ₹870, and the two rows to check come to ₹175 (65 plus 110), which together make ₹1,045. The formula marks row 6 as found, because it shares its date and plaza with row 5, so only reading the times catches it. Row 10 has no trip at all, so the formula says Check on its own.

What do unmatched rows usually mean?

  • A trip you did not log, which is the commonest reason.
  • Someone else drove the car, such as a family member or a driver.
  • A repeat charge at the same plaza within minutes, which is worth a query to the issuer.
  • A plaza on a road you did not realise had a toll.
  • A row that belongs to another vehicle on the same account.

What do you do with the rows to check?

Ask yourself and the family first. If you are sure there was one crossing, start a dispute record with the statement lines, times, plaza and your log, as in the related article on double charges. If the trip simply was not logged, add it so the next reconciliation is clean.

Where does SpendixAI fit?

A statement uploaded as PDF, CSV or Excel is reviewed before saving, and its Possible duplicate charges report lists the same amount to the same merchant within two days, which helps you spot repeats. Your trip log stays in your own sheet, so the match itself is still done there.

If your trip log is only notes on your phone, a quick pass is enough: scan each statement row and ask whether you remember being there. The formula just speeds up a long month.

Monthly routine

  • Download the statement after month end.
  • Fill the Match column and look at every Check row.
  • Add forgotten trips to the log.
  • Raise anything that still looks wrong, with its record.
SPENDIXAI JOURNAL

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

Explore your reports