Service Charge Budget Excel
Budget, levies, arrears & sinking fund for OMCs
- Budget in the 9 categories of the MUD Act, vs actual
- Levy per unit from the lease share or floor area
- Arrears aged 0–30 / 31–60 / 61–90 / 90+ days
One-off purchase – no subscription
RTB Rent Calculator Excel
Rent review estimate, tenancy register & RTB deadlines for Irish landlords
€69incl. VAT
Every tenancy, every rent change and every RTB date in one workbook – with an estimate before each rent review
10sheets
20properties
0macros
- Rent review estimate: the lower of CPI and 2% a year, pro rata
- Full rent history per tenancy and per property
- RTB registration and annual renewal dates with warnings
- 90-day notice, 12/24-month rule, 7-day RTB copy and registration checks
- Notice periods by length of tenancy for landlord and tenant
- Monthly rent ledger with arrears per tenant
STARTSETTINGSPROPERTIESTENANCIESRENT HISTORYRENT CALCULATORRENT LEDGERNOTICESCPI INDEXDASHBOARD
Found an error in the template? We'll fix it – or refund you.
Know what rent you can ask – and what the RTB expects from you – before you send the notice
Keep each property, tenancy and rent change in one place. The workbook estimates the next rent review under the CPI / 2% rule, tracks RTB registrations and notice periods, and shows who is behind with the rent.
A rent review in Ireland is more than a number. The rent can usually be reviewed once every 12 months, the notice has to reach the tenant at least 90 days before the new rent and must include three comparable rents from the RTB Rent Register, a copy goes to the RTB within 7 days, and the tenancy registration has to be updated afterwards – on top of the annual RTB registration of every tenancy. Since 1 March 2026 the cap is the lower of CPI inflation and 2% a year, nationwide – and if a tenancy already existed when its area became a rent pressure zone in June 2025, the first review can only come 24 months after the rent was last set.
Small landlords usually keep this in emails, the RTB portal and a notebook. This workbook brings it together: a register of properties and tenancies, the full rent history, an RTB-style estimate of the maximum rent for any property and date, a planner for all your next reviews, the notice periods that apply to each tenancy and a monthly rent ledger – with a next action for every tenancy. The official RTB Rent Calculator remains the one to attach to your notice.
Without a template
- Unsure when the rent was last set and when the next review is allowed
- Annual RTB registrations missed and late fees building up
- Notice dates worked out by hand – and sometimes a few days short
- Arrears noticed only when the bank statement arrives
With ExcelGrand
- Rent history per tenancy with 'review possible from' dates
- Next registration date and status for every tenancy
- Required period and earliest valid date for each notice
- Monthly ledger that flags part payments and arrears
What's in the file
START
Key figures, quick links and a step-by-step guide.
SETTINGS
Landlord details, warning window, the 2% cap, 90-day notice, RTB fees, notice period tables and notice types.
PROPERTIES
Up to 20 dwellings with Eircode, type, BER, new-build flag and the date the area became a rent pressure zone – current tenancy, tenant, rent and last rent set are filled in.
TENANCIES
Tenants, dates, deposit, RTB registration and next renewal, current rent, review date, notice periods, arrears and next action.
RENT HISTORY
Every rent set or reviewed: previous rent, % change, months since last set, days of notice, RTB copy, registration update and checks.
RENT CALCULATOR
RTB-style estimate for any property and date, timing checks, market-rent check with 3 comparables and a review planner.
RENT LEDGER
Rent received per tenancy for 12 months against the rent due, with balances and arrears.
NOTICES
Rent review, rent setting, warning and termination notices – required period, earliest valid date and RTB copy.
CPI INDEX
CSO Consumer Price Index (all items, the series the RTB calculator uses) from January 2020 with release dates, ready for each new month.
DASHBOARD
Rent roll, due vs received, CPI against the 2% cap and the estimated room at each next review.
Take a look inside
Specifications
Format.xlsx
RequiresExcel 2016+ / Microsoft 365
Sheets10
Capacity20 properties · 40 tenancies · 150 rent changes
CPI dataCSO all-items CPI, Jan 2020 – Sep 2026 included
MacrosNone
Who is it for?
- Landlords with 1–20 homes
- Couples & families letting a property
- Accidental landlords
- Small letting agents
- Accountants helping landlord clients
Frequently asked questions
Can a landlord increase the rent every year in Ireland?
In general the rent can be reviewed once every 12 months, and the increase is capped at the lower of CPI inflation and 2% a year (pro rata) under the rules in force from 1 March 2026. If the tenancy already existed when its area became a rent pressure zone (for example on 20 June 2025), the first review comes 24 months after the rent was last set. The TENANCIES sheet shows the date from which each rent review is possible, and the RENT CALCULATOR estimates the maximum. Always check the current rules on rtb.ie.
Do you have to notify the RTB of a rent increase?
Yes. According to the RTB's guidance, the rent review notice goes to the tenant at least 90 days before the new rent, a copy goes to the RTB within 7 days (since 14 September 2026), and the tenancy registration must be updated within one month of the rent change. RENT HISTORY and NOTICES record these dates and flag what is missing.
How do I calculate the CPI increase for my rent?
Compare the CSO Consumer Price Index for the month before the new rent is set with the index for when the rent was last set (the month it was set if before 1 March 2026, otherwise the month before), and compare that change with 2% a year for the same number of months – the lower of the two applies. The workbook does this for you with the official CSO figures in the CPI INDEX sheet. It is an estimate: the official RTB Rent Calculator is the one to print and attach to your notice.
What are the landlord rules from March 2026?
From 1 March 2026 the rent cap (CPI or 2%, whichever is lower) applies nationwide, new tenancies run in 6-year cycles, and the reasons a landlord can end a new tenancy depend on whether they have 1–3 tenancies or 4 or more. Rent can be reset to market rent between tenancies only in certain cases. SETTINGS summarises the figures used and they can be edited if the rules change.
How do I renew my RTB registration?
Every tenancy is renewed once a year, within one month of each anniversary of its start. The fee is €40 per tenancy, plus a late fee of €10 per month or part of a month. The workbook shows the next deadline for every tenancy and warns you in advance – the renewal itself is done on the RTB portal.
Is this the official RTB Rent Calculator?
No. It is an independent Excel workbook and is not affiliated with the Residential Tenancies Board. It helps you organise your tenancies and plan rent reviews, but it never confirms that an increase or a notice is valid. Use the RTB's own calculator, templates and guidance before you serve a notice.
Guide for this template
- RTB Registration and Rent Increases in 2026: The Rules After Rent Pressure ZonesWhen each tenancy must be registered and renewed, what late fees and fines apply, and how far the rent can rise under the national CPI / 2% cap – with a rent review worked out after 12 and after 18 months.
Other templates you may need
Fire Safety Register Excel
Fire safety log book with due-date alerts for Irish buildings
- Weekly fire alarm test log with call point rotation
- Monthly checks of fire doors, escape routes and emergency lighting
- Service due dates for extinguishers, alarm and other equipment
Risk Assessment Template Excel
Hazard register, 5×5 risk matrix, action plan & Safety Statement checklist
- Hazard register by area with who is at risk and existing controls
- 5×5 likelihood × severity scoring with colour-coded ratings
- Action plan with owner, target date from the rating and overdue alerts
RTB Rent Calculator Excel
Rent review estimate, tenancy register & RTB deadlines for Irish landlords · €69
RTB rent calculator and rent review planner in Excel for Irish landlords
An RTB rent calculator tells you the maximum rent increase at a rent review. This Excel workbook gives you an RTB-style estimate – a rent increase calculator for Ireland under the CPI / 2% rule (what many landlords still call the rent pressure zone calculator) – and keeps the result next to the full rent history of each tenancy.
It also tracks what the RTB expects around it: RTB registration and annual renewal dates, the rent review notice with 90 days' notice, the notice of termination periods by length of tenancy and a rent ledger for arrears. A practical landlord spreadsheet for Ireland for anyone letting one to twenty homes.
RTB Rent Calculator Excel€69