To keep track of passport and visa expiry for the whole family, make one sheet with a row per document: whose it is, the expiry date, how many days before you need to start renewing, and the date you should start. A formula flags rows that are due, and a last column records what the renewal cost. Add the same dates to your phone calendar as reminders.
What columns does the family expiry sheet need?
Keep it plain. One row per document, so a person with a passport and a visa has two rows.
- Member name.
- Document: passport or visa, and for a visa the country.
- Last four digits of the document number only. A full passport number does not belong in a sheet that others can open.
- Expiry or validity date.
- Lead time in days: how early you want to begin.
- Start-by date, worked out by formula.
- Renewal cost paid, and the date you paid it.
How do I set the reminders with formulas?
Say the expiry date is in column D and the lead time in days is in column E. In F2 write =D2-E2 to get the start-by date, and format the cell as a date. In G2 write =D2-TODAY() for the days left. In H2 write =IF(G2<=E2,"START NOW","") so the row announces itself once you are inside the lead time. Copy all three formulas down. These work the same way in Excel and in Google Sheets.
| Member | Document | Expiry | Lead time | Start by | Cost paid |
|---|---|---|---|---|---|
| Asha | Passport | 18 Sep 2028 | 120 days | 21 May 2028 | blank until renewed |
| Rohan | Passport | 3 Feb 2029 | 90 days | 5 Nov 2028 | blank until renewed |
| Asha | Visa, hypothetical country | 30 Jun 2027 | 45 days | 16 May 2027 | blank until renewed |
All dates and lead times above are made up. Check the first row: counting 120 days back from 18 September 2028, a leap year, lands on 21 May 2028.
How early should I start a renewal?
That depends on how long the issuing office takes in your city, whether you need an appointment, and what the next trip requires. Many countries also ask that a passport has some validity left on the date you enter or leave, and the amount differs by country, so read the entry requirements for the place you are going and not a general rule. Pick a lead time that suits your own experience and be generous; you can always shorten it later.
Open the sheet before you book any trip, not after. A two-minute look tells you whether anyone's passport is close to its lead-time window, and whether a visa will still be valid on the dates you want. It is far cheaper to renew first than to rebook flights, and the same habit works for school holidays and festival travel, when appointments fill up early.
What about children and older relatives?
Give every person a row, including infants and grandparents. A child's passport may expire sooner than an adult's, and an elderly relative's document is the one most likely to be forgotten. Sort the sheet by the start-by date, and the document most urgently needing action rises to the top.
Where does the cost column help?
When a renewal is done, record what you paid: the government or office fee, the photographs, any agent charge, courier. That figure becomes a clear number for your next budget. If you pay by card or UPI, SpendixAI can pick up the transaction from the imported statement, and you can add a note saying whose passport it was.
Once a year
- Open the sheet each April and check every row.
- Update lead times if you learned how long things took.
- Add new visas, remove expired ones.
- Confirm everyone's cost paid is filled in after renewals.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

