A rental maintenance schedule that tells you what is due

A maintenance list is useless if you have to remember to read it. Store when each job was last done and how often it repeats, and let the sheet work out the next due date.

Three columns do the work

  1. Every: how many months between jobs (3 for HVAC filters, 12 for the furnace).
  2. Last done: the date you or your contractor did it.
  3. Next due: =EDATE(LastDone, Every). Change the last-done date and next-due moves forward.

Add a status: =IF(Next<TODAY(),"Late", IF(Next-TODAY()<=30,"Due soon","")), then color red and amber with conditional formatting.

The sample schedule, soonest first

JobWhereEveryLast doneNext dueStatus
Smoke and CO detector test1907 Larkin Rd6 moApr 29, 2026Oct 29, 2026Late, 9 days
Furnace service88 Fenwick Ave12 moNov 15, 2025Nov 15, 2026Due in 8 days
Gutter clean412 Alder St6 moMay 28, 2026Nov 28, 2026Due in 21 days
Water heater flush1907 Larkin Rd12 moDec 2, 2025Dec 2, 2026Due in 25 days
Window and door weatherstrip412 Alder St12 moDec 13, 2025Dec 13, 2026In 36 days
HVAC filter change412 Alder St3 moSep 20, 2026Dec 20, 2026In 43 days
Faucet and toilet leak check1907 Larkin Rd6 moJul 1, 2026Jan 1, 2027In 55 days
Pest control1907 Larkin Rd3 moOct 16, 2026Jan 16, 2027In 70 days

24 jobs worth tracking on a small rental

Doorledger loads these with the interval most landlords use. Change any interval to match your climate, equipment or lease.

JobEvery
Smoke and CO detector test6 months
Furnace service12 months
AC service12 months
HVAC filter change3 months
Gutter clean6 months
Water heater flush12 months
Dryer vent clean12 months
Fire extinguisher check12 months
Roof inspection12 months
Chimney sweep12 months
Pest control3 months
Sump pump test6 months
Septic pump36 months
Exterior caulk and seal check12 months
Deck or porch inspection12 months
Window and door weatherstrip12 months
Faucet and toilet leak check6 months
GFCI outlet test6 months
Range hood filter clean6 months
Refrigerator coil clean12 months
Sprinkler winterize12 months
Lawn and landscapingmonth
Snow removal contract renew12 months
Smoke detector battery swap12 months

Smoke and CO detector rules, and who must test them, differ by state and city. Check your local code.

Skip building it. Doorledger has these 24 jobs loaded, with red and amber flags and a Monday view of what is due this week. The full Doorledger workbook ($29 once, no monthly fee) adds a Monday view, 24 recurring repair jobs, leases, deposits, expenses and a Year summary by Schedule E line.

Download the free rent ledger Get Doorledger, $29 once