A renewal sheet with one row per annual payment keeps yearly fees from disappearing. Each row needs six things: what is being renewed, who you pay, the due month, the amount last time, where the proof is saved, and whether it has been paid this year. A twenty-row sheet is enough for most small businesses and takes an hour to build.
Which renewals belong on the sheet?
Anything you pay once a year or once in a few years, where missing the date has a cost. Make a list by walking through the year and asking what you paid once.
- Insurance for the shop, stock, vehicles or health cover for staff.
- Trade licences, shop registrations or similar permits.
- Software or domain subscriptions billed yearly.
- Professional memberships and association fees.
- Annual maintenance contracts for machines, air conditioners or lifts.
- Vehicle taxes and pollution certificates.
- Fire or safety certificate renewals, if your premises need them.
Your CA or your registration documents will tell you which of these apply to you. This article is about keeping track, not deciding what you must have.
What columns should the sheet have?
| Renewal | Vendor | Due month | Amount last time | Proof saved | Status this year |
|---|---|---|---|---|---|
| Shop insurance | Insurer, agent phone | March | ₹14,200 | Policy PDF, receipt | Due |
| Delivery van insurance | Insurer, agent phone | August | ₹9,800 | Policy PDF, UPI screenshot | Paid |
| Accounting software | Vendor name | June | ₹6,000 | Invoice PDF | Paid |
| Trade licence | Municipal office | April | ₹2,500 | Receipt, licence copy | Due |
| Printer AMC | Service firm | October | ₹3,600 | Contract copy | Paid |
The amounts here are invented for illustration. Put in your own, and update the column each year after you pay.
How do you use the due month?
Sort the sheet by due month so the next three months always sit at the top. Set a calendar reminder one month before each date, not on the date itself. A month's notice gives you time to compare quotes, ask for an invoice in your business name and arrange the money.
What proof do you save?
Proof means the document that shows you paid and what for. For a policy, that is the policy document plus the receipt. For a licence, it is the licence and the payment slip. Name each file with the renewal, year and amount, for example 2026 Shop insurance 14200, and note the folder or link in the Proof column.
Can you also plan the cash?
Yes, with one extra column. Add up what comes due in each quarter and set money aside in advance. Take the sample above: March has ₹14,200 and April ₹2,500, so those two months together need ₹16,700 plus anything else due. Seeing a number like that before it arrives is the whole point.
Where does an expense tracker fit?
A sheet records what is coming. A tracker records what happened. In SpendixAI you can import your statement, categorise the payment and keep the invoice with its transaction, so next year's amount and receipt are easy to find. It will not remind you of a due date by itself, so the sheet or a calendar still does that job.
What about renewals that change from year to year?
Some fees go up, some vendors change, and some policies get replaced by a different product. Whenever a renewal changes, add a short note in the sheet instead of overwriting the old figures: the new amount, the new vendor and the reason. For instance, if the van insurance moved from ₹9,800 to ₹10,900, a note saying the cover was widened tells next year's you why the number jumped.
A yearly review
- Once a year, list every renewal you paid and compare with the sheet.
- Add any that were missing.
- Remove any that are cancelled.
- Update the last amount and proof.
- Re-sort by due month.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

