Tax and GST

A travel log of days in India and abroad, from tickets and stamps

Build a simple dated log of days in India and abroad from boarding passes, e-tickets and passport pages, and leave the meaning of the counts to your CA.

Editorial illustration for A travel log of days in India and abroad, from tickets and stamps

A travel log is a table with one row per trip: the date you left, the date you returned, where you went, and the document that proves each date. Fill it from boarding passes, e-tickets and passport pages as the trips happen, not from memory at year end. The log records facts; what the counts mean for tax or residential status is for your CA to decide.

Why keep a log at all?

Because memory of dates is unreliable, and the dates matter. People who travel often, such as NRIs returning for a visit or professionals who work across countries, can find they are unsure whether a trip began on the 28th or the 29th. A log built from documents answers that quickly, and it shows your CA that your numbers come from papers rather than recollection.

What sources should I use?

  • E-tickets and booking confirmations in your email, which show the planned dates.
  • Boarding passes, paper or on the phone, which show the actual flight and date.
  • Passport pages with entry and exit stamps, photographed after each trip.
  • Immigration or arrival records you receive in an app or by email, where available.
  • Hotel or lodging bills for the end dates of a stay, as a cross-check.

Where two sources disagree, note both and flag the row. Flights that cross midnight, or time zones that move the date, are the usual reason.

What does the log look like?

Left onReturned onFrom and toEvidenceDays between
3 January20 JanuaryMumbai to a foreign city and backE-ticket, both boarding passes, passport stamp photo17
14 March30 MarchDelhi to another city and backE-ticket, boarding passes16
12 August28 AugustHyderabad to abroad and backE-ticket, passport stamp photo16

The last column is the difference between the two dates. If the left-on date is in B2 and the returned-on date is in C2, then =C2-B2 gives the number of days between them in Excel or Google Sheets, so 3 January to 20 January gives 17. That count includes one end day and excludes the other. If you want both the departure and arrival days included, use =C2-B2+1, which gives 18. Which method matters, if either does, is something to ask your CA. Record both columns if you like, and label them clearly.

Which date counts when time zones are involved?

That is a good question for your CA, not for a website. A flight that leaves late in the evening may land the next calendar day, and the date on the boarding pass may differ from the date of the stamp. Write down the date from each document and the local time where known, then let the CA say which one applies for what purpose. Do not adjust dates yourself to get a neat result.

How do I keep the log up to date?

  1. The day you return, photograph your passport's new stamp pages and save them in a Travel folder.
  2. Forward the e-ticket and boarding passes into the same folder.
  3. Add a row to the log with the dates and a file link.
  4. At each April, copy the sheet to a new tab for the new year, so old counts stay untouched.
  5. Send the log to your CA with your yearly summary.

How long should I keep the proof?

Keep the supporting papers with the year's tax folder, and ask your CA how long they want them. Passport pages are sensitive, so store the images in the same encrypted or protected place as your other identity papers. If you change passports, photograph the old one's stamped pages before it expires or is surrendered, and save them with the log.

SPENDIXAI JOURNAL

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

Explore your reports