A renewal schedule in Excel, free.
A ready-made spreadsheet for fire alarms, lifts, gas, electrical checks, insurance and every other recurring certificate. Type when each was last done and it works out the next due date and flags what is overdue. No sign-up, no email.
Everything a renewal schedule needs, nothing more.
Next due, calculated
Enter the last date and the interval in months; the next due date fills in by itself.
Overdue at a glance
Rows turn red when overdue and amber when due within 60 days. The status column says the same in words.
Common items listed
Fourteen typical building renewals are already in the list. Rename, delete or add rows freely.
Ready to import
The columns are the ones Dueclear reads, so you can import the file as it is later.
Four steps, about ten minutes.
Add your buildings
Fill in one row per recurring certificate at each building. Copy rows for each site.
Name an owner
Write who is responsible for each renewal, and the contractor if there is one.
Enter the last date
Type when it was last done and how often it repeats. Next due and Status update every time you open the file.
Sort and filter
Use the filters in the header row to see one building, one owner or everything overdue.
The intervals in the template are examples. What a building needs, and how often, depends on the country, the building and its equipment. Check with your qualified people and current official sources.
A spreadsheet only works if someone opens it.
It will not email the owner 60 days before a lift inspection, collect the certificate from the contractor or show a client where things stand. Dueclear does, and it imports this file as it is.
Questions about the template
Is it really free?
Yes. Download it, use it, share it with colleagues. No sign-up and no email address needed.
Does it work in Google Sheets and LibreOffice?
Yes. The formulas and colours are standard and work in Excel, Google Sheets, Numbers and LibreOffice.
Can I change the columns?
Yes. Add columns such as contract number or floor; if you import into Dueclear later, extra columns become custom fields.