Home and property

An 11-month rent agreement: a renewal calendar for dates and costs

Set up a renewal calendar for an 11-month rent agreement: start, lock-in end, notice window, expiry and renewal costs to ask about, with sheet formulas.

Editorial illustration for An 11-month rent agreement: a renewal calendar for dates and costs

An 11-month rent agreement ends sooner than most people feel it will, so build a small calendar on day one: start date, lock-in end, last day to give notice, expiry and the date a renewed agreement begins. Add reminder dates ahead of each, and a list of renewal costs to ask about rather than guess.

What dates should the calendar hold?

Use your own agreement for every figure. The example below assumes an agreement starting on 1 April 2026, a six-month lock-in and a one-month notice period, all made up.

MilestoneExample dateHow to get it
Agreement start1 April 2026From the agreement
Lock-in ends30 September 2026Start date plus the lock-in months, minus one day
Last day to give notice28 January 2027Expiry date minus the notice period
Agreement expires28 February 2027Start date plus 11 months, minus one day
Renewed term begins1 March 2027The day after expiry

How do I let a sheet calculate the dates?

In Excel or Google Sheets, put the start date in B2. Then these formulas fill in the rest.

  • Lock-in ends: =EDATE($B$2, 6) - 1
  • Expiry: =EDATE($B$2, 11) - 1
  • Last day for notice: =EDATE($B$2, 11) - 1 - 28, if your notice period is 28 days. For a one-month notice, use =EDATE(EDATE($B$2, 11) - 1, -1)
  • First reminder, 60 days before expiry: =EDATE($B$2, 11) - 1 - 60

Format the result cells as dates. EDATE adds whole months and returns a serial number, which is why the cell needs date formatting. Check one result against a paper calendar once.

Which reminders should I set?

  1. Sixty days before expiry: decide whether you want to renew, and think about moving costs if not.
  2. Forty-five days before: talk to the landlord about the rent for the next term.
  3. Thirty days before: confirm the notice position in writing, either way.
  4. Seven days before: agree who arranges the new document and when you will sign.
  5. Day after expiry: check that the new agreement is signed and that rent is being paid under it.

What renewal costs should I budget for?

Do not trust a number from a friend or a website. For each line below, ask your landlord, broker, or the official source for the current figure and write it in. Leave the amount blank until you have it.

  • Stamp duty on the new agreement: ask for the current amount in your state.
  • Registration or notarisation fee, if your agreement will be registered or notarised.
  • Broker or agent fee, if any, and whether it applies again on renewal.
  • Society charges or no-objection paperwork for the new term.
  • Any police or tenant verification forms, and who pays for them.
  • The rent increase, if any, from the first day of the new term.
  • A buffer for repainting or repairs the landlord may ask you to share.

What if I decide to leave?

Then the same calendar becomes a moving plan. The notice date tells you when to give notice, and the expiry date tells you when the new flat must be ready. The deposit refund is another date worth writing down, whatever the agreement says about how many days after handover it will be returned.

Where SpendixAI fits

Lump costs like stamp duty and fees arrive in one go. A savings goal in SpendixAI Pro, or simply a monthly amount you set aside, spreads them over the months before renewal, so they do not land as a surprise. The calendar itself belongs in your sheet or phone.

Set-up checklist

  • Start date and lock-in months entered from the agreement.
  • Formulas giving lock-in end, expiry and notice dates.
  • Four reminders on your phone calendar.
  • Renewal cost lines written down with the amounts left to ask.
  • A folder holding the signed agreement and every renewal.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports