A simple sheet with one row per free service lets you see at a glance which coupon is due next, by kilometres or by date, and what each visit actually cost. Put the due km, the due date and a reminder date on each row, and fill in the done date and bill when the visit happens. Read the service booklet for the real windows, because they differ by manufacturer and model.
What does the sheet need?
Use one row for each free service, numbered as the booklet numbers them. The columns that earn their place are below.
- Service number, such as 1, 2, 3.
- Due at km and due by date, both taken from the booklet.
- Reminder date, ten to fourteen days before the due date.
- Done date and odometer at service.
- Bill amount, which is often zero.
- Status, calculated from the dates.
What do the rows look like?
The windows in this example are made up for illustration; your booklet will have its own. Say you bought the bike on 10 January and the first coupon is due by 500 km or 60 days, whichever comes first.
| Service | Due at km | Due by date | Reminder date | Done date | Km at service | Bill (₹) |
|---|---|---|---|---|---|---|
| 1 | 500 | 11 Mar | 25 Feb | 20 Feb | 470 | 0 |
| 2 | 3,000 | 10 Jul | 26 Jun | Pending | Pending | Pending |
| 3 | 6,000 | 10 Nov | 27 Oct | Pending | Pending | Pending |
Row 1 shows the usual pattern: the coupon was used a few days before the date limit, at 470 km, with a nil bill. Rows 2 and 3 stay pending until the visits happen, and the status column keeps showing Upcoming until then. If you ride little, the date limit will usually arrive long before the kilometre limit.
Which formulas keep it running?
- Put the purchase date in cell B1. For service 1 in row 4, the due date is =$B$1+60, so that 10 January plus 60 days gives 11 March.
- Reminder date in D4: =C4-14
- Status in H4: =IF(E4<>"","Done",IF(TODAY()>C4,"Overdue",IF(C4-TODAY()<=14,"Due soon","Upcoming")))
- Total spent on free services: =SUM(G4:G12), which may well be zero or a small amount.
These work in Excel and Google Sheets. If your booklet gives a window as a range of days and kilometres, enter the earlier limit as the due date so the reminder fires in time.
What should you log when the dealer charges only for consumables?
Log the real amount, even if it is small. Say labour is free but you pay ₹450 for engine oil and a filter. Enter 450 as the bill and type consumables only in a note column. A visit with a ₹0 bill still gets a row with the done date, because the row is how you prove the coupon was used on time. Keep the dealer's job card or invoice photo next to it.
When is the next service actually due?
Many booklets set a limit in kilometres and a limit in days, and the first one you reach counts. Someone who rides little may hit the date first, while a heavy rider hits the km first. Add a due-by column for each limit and treat the earlier of the two as your real deadline.
Can SpendixAI help with this?
It will not remind you of the odometer or the booklet, so the schedule stays in your sheet. What helps is the money side: add each service visit as an expense, even a small or zero-rupee one if you want it in the record, and attach the job card as a receipt so everything stays together with the transaction.
A last check before each visit
- Confirm the due km and the due date in the booklet, not from memory.
- Take the booklet and the bike's papers along.
- Ask what is chargeable before the work starts.
- Update the done date and odometer before you leave the dealer.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


