Life events

Vehicle paperwork calendar: insurance, PUC and servicing dates

A one-sheet vehicle renewal calendar for insurance, PUC and servicing: columns to keep, a costed yearly example and how to set reminders.

Editorial illustration for Vehicle paperwork calendar: insurance, PUC and servicing dates

A vehicle renewal calendar is one sheet with a row for every recurring task on your car or two-wheeler: insurance renewal, the pollution-under-control (PUC) certificate, servicing, and any other dated paper your vehicle needs. Each row carries a due date, the date you last did it, what it cost and where the document is kept. Add a reminder a few weeks before each due date and nothing lapses quietly.

What belongs on the calendar

Start with the things that have a date printed on them. Your insurance policy shows when cover ends, your PUC certificate shows its own validity, and your service booklet or the last invoice shows when the next service is due by time or by kilometres. Registration and fitness-type paperwork differs by vehicle type and state, so add those rows only if they apply to you, and read the date from your own document rather than from memory.

  • Insurance renewal (third-party only or comprehensive, as per your policy)
  • PUC certificate
  • Scheduled servicing, by date and by odometer reading
  • Tyres, battery and wiper checks that you do yourself at a fixed interval
  • FASTag recharge habit, if you keep a prepaid balance
  • Any parking permit or society sticker that renews yearly

Which columns keep the sheet useful?

Resist the urge to add twenty columns. These eight are enough, and the last-done and cost columns are the ones that make the sheet more than a reminder list.

ColumnWhat to enterWhy it helps
VehicleSwift, Activa, and so onOne sheet can cover every vehicle at home
TaskInsurance, PUC, second serviceOne task per row
Last doneDate from the invoice or certificateShows how long you actually went between visits
Next dueDate or odometer figureDrives the reminder
CostAmount you paid last timeLets you plan the next payment
Paid fromUPI, card, cashHelps you find the entry in your statement
DocumentFolder name or phone gallery albumYou can find the paper in a minute
Reminder setYes or noStops you assuming it is done

What does a year look like with real arithmetic?

Take clearly made-up figures. Say comprehensive insurance cost ₹7,500 last year, the PUC certificate cost ₹100, and you paid ₹2,200 for each of two servicing visits. Your yearly vehicle paperwork-and-service total is ₹7,500 + ₹100 + ₹4,400 = ₹12,000, which is ₹1,000 a month. Fuel and tyres sit outside this total on purpose; the sheet is only for dated, repeat tasks.

The useful part is the monthly figure. If the insurance bill lands in one month and servicing lands in two others, you can put ₹1,000 aside every month into a separate pot and the renewal never feels like a shock.

Servicing by kilometres needs one extra step. Note the odometer reading at each visit. If your booklet asks for a service every 5,000 km and you drive about 800 km a month, then 5,000 ÷ 800 = 6.25, so pencil in the next visit about six months after the last one, even if the calendar date allows longer. Update the guess whenever your driving pattern changes, such as after a job or house move.

How do I get reminders without another app?

  1. Put the next-due date in a calendar event, not just in the sheet. Create it two to three weeks before the due date so you have time to compare quotes or book a slot.
  2. Add a second event on the due date itself titled with the vehicle and the task.
  3. In the sheet, use =D2-TODAY() in a helper column to show days left, where D2 holds the next-due date.
  4. Colour the row amber when days left fall below 30, using conditional formatting with the formula =AND($E2>=0,$E2<=30), where column E holds the days-left helper.
  5. After each task, replace the last-done and next-due dates and paste the new cost.

What if a payment shows up in my statement but not in the sheet?

That is a sign the sheet is incomplete, which is good to know. Search your statement for the garage, the insurer name or the PUC centre and add the missing row. When statements are imported into SpendixAI, you can keep these payments under one vehicle category so a year of them can be read together, and receipts can stay attached to the transaction.

A quarterly five-minute check

  • Open the sheet and sort by next-due date.
  • Anything inside the next sixty days gets a calendar event if it does not have one.
  • Confirm the document folder still has the latest copy of each paper.
  • Update the monthly savings figure if any cost changed.
SPENDIXAI JOURNAL

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

Explore your reports