Property maintenance Excel - Free Template

1. Open the Maintenance Schedule sheet and enter the property name or location in Property. Examples in the workbook include Harbour View Flat 2, Bristol and Maple House, Leeds.
2. Enter the relevant Area / asset and a clear Maintenance task, such as Boiler service, Gutter clearing or Smoke alarm battery check.
3. Choose Monthly, Quarterly, Six-monthly, Annual or Biennial in Frequency. The list is controlled by data validation.
4. Enter the last completion date in Last completed using DD/MM/YYYY, then enter the expected amount in Estimated cost. Costs must be zero or greater.
5. Leave Next due and Status for the workbook to calculate. Next due uses the frequency planning days on Summary, while Status compares the result with TODAY().
6. Open Summary to review task counts, estimated costs and status counts. Adjust the planning days in the frequency table if your internal interval differs.
7. Read Instructions before changing the workbook, and keep the input fields, calculated fields and planning settings distinct.

A property maintenance schedule suits landlords, letting agents, facilities managers, holiday-let operators and small businesses responsible for premises. It gives you one working list for recurring jobs rather than separate notes for each flat, house, shop or office.

Landlords managing several addresses

A landlord with six properties might record a boiler service at Harbour View Flat 2, Bristol, gutter clearing at Maple House, Leeds, and a smoke alarm battery check at Riverside Cottage, York. Each row keeps the location, asset and task together, so a contractor can see what work belongs to which property.

The workbook includes 100 available task rows. A portfolio manager entering 25 properties with four recurring jobs each would use 100 rows exactly, making it important to group related work consistently and avoid duplicate entries.

Agents and facilities teams

A letting agent can use the schedule during a weekly property review, while a facilities coordinator can update it after contractors complete work. For example, Kingsway Office, London has Window cleaning in the sample data, while Station Road Shop, Glasgow has an Emergency lighting check. These examples show how the same sheet covers residential and commercial premises.

Use Area / asset for the maintained item, not a second property name. Heating system, Rainwater goods, Bathroom, Exterior, Lighting and Garden are clearer asset descriptions than a vague entry such as General maintenance.

Small portfolios and project handovers

The file is also useful when responsibility moves between an owner, managing agent and contractor. The Maintenance Schedule records the operational detail, the Summary sheet provides a quick workload view, and the Instructions sheet explains what each column means. It is a planning record, not evidence that work has been completed unless you enter the completion date accurately.

The workbook separates information you enter from results it calculates. You enter Property, Area / asset, Maintenance task, Frequency, Last completed and Estimated cost. Next due and Status are formula fields, so the technical judgement is clear: do not overwrite calculated cells when correcting a task.

Frequency drives the next due date

The Summary sheet contains planning days of 30 for Monthly, 91 for Quarterly, 182 for Six-monthly, 365 for Annual and 730 for Biennial. If a task was last completed on 19/02/2026 and is Annual, the formula adds 365 days to that date. If the frequency is Quarterly and the completion date is 30/05/2026, it adds 91 days.

These are workbook planning values, not legal requirements. The Instructions sheet expressly allows you to adjust them for your internal schedule. For instance, changing Annual from 365 to another planning value changes every linked Next due result using that frequency.

Blank and invalid references

The Next due formula stays blank when Frequency or Last completed is blank. It also uses VLOOKUP with IFERROR, so an unmatched frequency does not display an unhandled lookup error. Keep the supplied frequency list intact unless you also update the lookup table.

Status compares Next due with TODAY(). A date before today becomes Overdue; a date up to 30 days ahead becomes Due within 30 days; a later date becomes Planned. The 30-day label is an internal planning prompt, not a statutory deadline.

Cost and summary checks

Estimated cost accepts decimal values of zero or more, and Summary adds the range with SUM and calculates the average with AVERAGE. Three tasks estimated at £120.00, £85.50 and £40.00 would produce a total of £245.50 and an average of £81.83, subject to normal Excel rounding display.

Maintenance records usually become unreliable when dates, frequencies and assets are entered inconsistently. In this workbook, a missing Last completed date prevents Next due from calculating, so a task can disappear from the useful planning view even though the row exists.

Using the wrong property or asset

Suppose a contractor completes gutter clearing at Maple House, Leeds but the update is entered against Riverside Cottage, York. The date may calculate correctly, yet the maintenance history is attached to the wrong location. With 12 properties and five recurring tasks each, one mislabelled row affects 1 of the 60 records you rely on for review.

Enter a full property identifier in Property and a specific item in Area / asset. Do not put several jobs into one task cell: Boiler service and Radiator bleed should remain separate if they have different completion dates, costs or frequencies.

Typing a frequency outside the list

The validated Frequency cells accept Monthly, Quarterly, Six-monthly, Annual and Biennial. A manually typed variation such as Every year may not match the Summary lookup table. The result can be a blank Next due even though Last completed contains a valid date.

For example, if the intended Annual planning value is 365 days but the row contains an unrecognised label, the calculation cannot retrieve 365 from Summary. Select the supplied list value instead of creating a new spelling.

Entering a cost as text

Estimated cost has decimal validation from zero upwards. Entering £85.50 as a numeric value is different from adding words such as approximately £85.50. Text entries can prevent the total and average calculations from representing the intended figures.

After updating several rows, compare the number of scheduled tasks with the rows you intended to add. If 20 tasks should be present but Summary shows 19, inspect Property cells because the scheduled-task count uses non-blank entries in Maintenance Schedule column A.

A maintenance spreadsheet works best when updating it is attached to an existing property routine. Choose one fixed review point, such as the first Monday of each month or immediately after contractor invoices are checked, and use the Summary sheet before opening individual task rows.

Use a short review cycle

Start with the three status counts on Summary. If two tasks are Overdue and four are Due within 30 days, work through those six rows first rather than reviewing all 100 available rows. Check the property, asset, completion date and estimated cost before contacting a contractor.

Make updates immediately after work

When a boiler service is completed, update Last completed and Estimated cost in the same session. The next due date then moves automatically from the old date. If three jobs are completed in one visit, update each task separately so a £120.00 boiler service, £45.00 gutter clearing job and £30.00 inspection remain traceable to their own rows.

• Use one consistent naming style for property locations.
• Keep one recurring task per row, with a single frequency and completion date.
• Review Summary after changes to confirm the status counts and cost totals moved as expected.

Know when the file is no longer enough

This workbook provides 100 schedule rows, formulas and summary measures, but it has no chart, Excel table or contractor workflow. If several people edit it simultaneously, you need attachments, approval records, photographs, purchase orders or a full audit trail, a dedicated property or facilities system may be more suitable.

Until then, protect the distinction between input and calculated fields. The Instructions sheet is the best reference when onboarding another person, while the Maintenance Schedule remains the place for operational updates.