A single sheet with one row per vehicle, sorted by expiry date, keeps every household policy visible in one place. Record the vehicle, the policy number, the insurer, the expiry date, the premium and a reminder date, then let a formula count the days left. It matters most in a family where cars, scooters and a parent's bike all renew in different months.
What belongs on each row?
- A: Vehicle and who uses it, for example car, scooter, Papa's bike
- B: Registration number
- C: Insurer, typed the same way each time
- D: Policy number
- E: Expiry date
- F: Premium paid last time (₹)
- G: Reminder date
- H: Days left
Keep the full policy documents in one locked folder rather than pasting them into the sheet. The sheet only needs enough to find the right document.
What does it look like with three vehicles?
The insurers, dates and premiums here are invented, and the days left are counted from 1 November 2026.
| Vehicle | Insurer | Expiry | Premium (₹) | Reminder date | Days left |
|---|---|---|---|---|---|
| Car | Insurer A | 28 Nov 2026 | 14,500 | 14 Nov 2026 | 27 |
| Scooter | Insurer B | 15 Jan 2027 | 3,200 | 1 Jan 2027 | 75 |
| Parent's bike | Insurer A | 9 Mar 2027 | 2,100 | 23 Feb 2027 | 128 |
Which formulas make it work?
- Reminder date in G2: =E2-14, so that 28 Nov gives 14 Nov
- Days left in H2: =E2-TODAY()
- Total premium for the household: =SUM(F2:F20)
- To sort by expiry, use Data then Sort on column E from oldest to newest, or in Excel 365 and Google Sheets use =SORT(A2:H20,5,TRUE) in another area
- To flag renewals due within a month, add conditional formatting on column H with the rule: less than or equal to 30
Format column E as a date and column H as a plain number. After the sort the vehicle that needs attention first is always in the top row.
How early should you start renewing?
Start when the reminder fires, not on the expiry day. Two weeks is enough to compare quotes, fix a lapsed document or find the policy number. Renewal quotes often differ between the insurer's own channel and an agent or website, and the add-ons can differ too, so compare like with like: same cover, same add-ons, same insured value.
Row order matters. The car, with the largest premium and only 27 days left, is on top, so it gets attention first. A parent's policy is the one most likely to slip, because the paperwork lives in someone else's drawer. Ask them to send a photo of the policy page, and copy the policy number, expiry date and the insurer's contact details printed on it into your row.
Who keeps the sheet?
One person, with a copy the others can see. In many households a parent's bike, a spouse's scooter and your own car are renewed by different people, which is exactly how one slips past. Share the sheet read-only and agree who updates it after each renewal. Put the new expiry date and premium in as soon as the payment is done.
What do you do after renewing?
- Replace the expiry date, premium and policy number on the row.
- Save the new policy PDF in the folder and delete the old file from the sheet's links.
- Compare the premium with last time and note the reason for any big change.
- Reset the reminder date.
Where does SpendixAI help?
Premium payments show up on the statement you upload, and you can add a payment made in cash or by cheque by hand. Group them under a vehicle or insurance category and the yearly total per vehicle is easy to see. Renewal dates themselves stay in your sheet.
Every renewal, do this
- Check the expiry date on the policy itself, not only in the sheet.
- Confirm the registration number and the insured name are correct.
- Keep the receipt with the policy PDF.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

