A health policy renewal tracker needs only a few columns: the premium due date, the grace period end date as printed in your own policy, the date you paid, and the date the money actually left your account. Add a rule that you pay several days before the due date, not on the last day. The reason is simple: a payment made on the last day can post to your bank the next morning, and you may not know which side of the date it falls on.
What is a grace period, and how long is yours?
A grace period is a stretch of days after the due date during which the insurer may still accept the renewal premium. Its length and what it means for your cover are set by your insurer and policy wording, so read yours instead of relying on what a friend was told. Write the number of days and the exact wording in your sheet, with the page where you found it. If the wording is unclear, ask the insurer to explain in writing.
The renewal sheet
| Column | What goes in it | Example (made up) |
|---|---|---|
| Policy | Insurer and policy number | Family plan, policy ending 4471 |
| Due date | From the renewal notice | 14 March |
| Grace days | From your policy wording | 30 |
| Grace end | Due date plus grace days | 13 April |
| Paid on | The date you made the payment | 10 March |
| Debit date | As shown on the statement | 10 March |
| Receipt saved | Yes or no, with file name | Yes |
In a spreadsheet, put the due date in C2 and grace days in D2, then use =C2+D2 in E2 and format the cell as a date. Excel and Google Sheets both count dates as numbers, so adding days works directly.
What goes wrong when you pay on the last day?
Say your due date is 14 March, and you pay through net banking at 11:40 at night on the 14th. The bank may show the payment as processed the next morning, and the insurer's system may record the receipt a day later. Your policy might treat the date of receipt differently from the date you initiated it. You do not need to know exactly how your bank handles this if you pay a week early. A week of margin also covers a failed transaction, a bank holiday, or a card limit surprise.
How do you check that the payment really went through?
- Look for the payment on your bank or card statement, with the date it was debited.
- Open the insurer's confirmation or receipt, and save it as a file named with the policy and year.
- Check that the new policy period or schedule has arrived by email or in the insurer's app.
- Write the confirmation date in the sheet.
- If anything is missing after a few working days, contact the insurer with the transaction reference.
Can an app help?
SpendixAI has bills on its Pro plan, and you can import your statement to confirm the premium debit appears on the date you expect, reviewing rows before saving. For the policy-specific details such as grace days, a small sheet like the one above is still the right place.
If a payment does slip past the due date, write down the date and time you noticed, the date you paid and the insurer's reply. Then ask the insurer in writing what the delay means for the policy period and the continuity of cover. Their reply, not a guess, is what you should rely on, and it belongs in the same folder as the receipt.
A checklist for each renewal
- Due date and grace end copied from the notice and the policy.
- Payment made at least a week early.
- Debit visible on the statement.
- Receipt and new schedule saved.
- Next year's date set in the calendar.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

