Nursing Home Tax Relief Excel - Free Template

1. Open the Care Costs & Relief sheet and review the headings from Resident Name through Net Cost After Relief.
2. Enter the resident's name, nursing home, county, HSE region, care start date and care end date. Use dates in DD/MM/YYYY format.
3. Enter the number of months in the 2026 tax year and the monthly nursing home fee. Check the total fees calculation against invoices or bank records.
4. Enter the Fair Deal contribution for the period. This separates the amount covered through the Nursing Home Support Scheme from the amount paid by the family.
5. Enter the claimant's marginal tax rate as a percentage, normally 20% or 40% depending on the claimant's taxable income and circumstances.
6. Review Total Fees Paid, Net Fees Paid by Family, Tax Relief Amount and Net Cost After Relief. Treat the relief as an estimate until the claim is checked against Revenue records.
7. Open the Dashboard for the summary view, then read the Instructions sheet before changing formulas or adding extra rows.

Nursing home costs rarely arrive as one neat annual figure. A family member may be paying the direct debit, the resident may receive a pension, and the Fair Deal contribution may be deducted or paid separately. This workbook gives the person handling the paperwork one row per resident and one place to reconcile those amounts.

Useful at the start and end of the tax year

A daughter dealing with her mother's care in Cork might update the row after each monthly statement. If care started on 12/06/2026 and continued to 31/12/2026, the sheet can record the seven months included in the 2026 tax year rather than accidentally claiming a full twelve months. At a monthly fee of €3,800, the gross figure would be €26,600 before any contribution is deducted.

The workbook is also useful when preparing an income tax return. A sole trader or PAYE employee who paid a parent's eligible care costs can check the annual total before completing the relevant health expense details. Keep the nursing home's invoices and proof of payment alongside the spreadsheet; the row is a control record, not a substitute for evidence.

Different people, the same reconciliation problem

A bookkeeper may maintain the file for an elderly couple with two residents, while a private household may use it for one person and pass the annual totals to a tax adviser. The County and HSE Region columns help identify the care arrangement, particularly where a family deals with several homes or moves from one county to another.

Image 1 shows the practical order of the information: identity and care dates on the left, fees and contributions in the middle, and the tax calculation on the right. That layout makes it easier to spot a missing contribution or a care period that does not cover the full year.

Under Section 469 TCA 1997, qualifying nursing home expenses can be claimed as health expenses at the claimant's marginal rate of income tax. In a straightforward case, a claimant paying €10,000 of eligible net fees with a 20% marginal rate would calculate estimated relief of €2,000; at a 40% marginal rate, the estimate would be €4,000.

The key figure is the amount actually paid by the claimant after amounts such as the Fair Deal contribution or other reimbursement. If the annual nursing home fee is €45,600 and the Nursing Home Support Scheme contribution is €19,000, the starting family-paid amount is €26,600. Applying 20% gives €5,320, but only the eligible expense and the correct claimant's tax position belong in the final claim.

Claiming through the Irish tax system

PAYE taxpayers generally claim health expenses through Revenue's myAccount service, while a self-assessed taxpayer includes the claim with the income tax return filed through ROS. A Form 11 taxpayer should retain the calculation and invoices for the relevant accounting and tax records. The relief reduces income tax; it is not a cash refund of the full nursing home bill.

Do not enter the same expense in two people's claims. The person who paid the expense should normally hold the supporting proof, and the claim must not include amounts already reimbursed by an insurer, an employer or another source. The template's Fair Deal Contribution (€), Net Fees Paid by Family (€) and Marginal Tax Rate columns are intended to expose that calculation rather than hide it in one annual total.

Records and supporting proof

Revenue expects records supporting a health expense claim, so keep statements, invoices, payment confirmations and details of any contribution. Retain them for 6 years in line with the general Revenue record-keeping period. Image 3's Instructions sheet should be read before relying on the figures for a return, especially where more than one person paid the fees or the care arrangement changed during 2026.

The most expensive error I see is using the nursing home's full annual invoice as the claimable figure. Suppose fees are €3,800 a month for 12 months, or €45,600, and Fair Deal support is €19,000. Applying a 40% rate to the full invoice produces €18,240, but applying it to the €26,600 family-paid amount produces €10,640: a difference of €7,600 in the relief estimate.

Mixed payments and duplicated claims

Families often share payments without recording who paid what. One sibling may pay €1,000 a month from a joint account while the resident pays the balance from a pension. Entering the entire fee under one claimant can overstate that person's health expenses and create a difficult query when bank statements are checked.

A second problem is treating the marginal rate as a permanent property of the resident. The rate belongs to the claimant's taxable income for the year. A PAYE employee whose taxable income moves across the 20% and 40% bands may need to confirm the correct marginal rate rather than selecting 40% because the household's combined income is high.

Date and receipt failures

Care beginning part-way through 2026 is another trap. A start date of 12/06/2026 does not justify twelve months of fees in the 2026 row. Conversely, a monthly direct debit paid in January 2027 should not be quietly added to the 2026 total simply because the invoice was issued earlier.

Missing evidence creates the most hassle. A spreadsheet showing €26,600 is useful, but without nursing home statements and proof of payment it does not establish that the claimant incurred the expense. Image 1's separate date, fee and contribution fields make these gaps visible; use them to reconcile each figure before submitting a claim, not after Revenue asks for clarification.

When those date and payment gaps need checking against what was actually counted, the medical card income tracker provides the matching record for each contribution and invoice.

The simplest routine is to update the workbook when the nursing home statement is paid, rather than waiting until the income tax return is due. Set a fixed monthly reminder for the day after the direct debit, enter the fee and contribution, and compare the result with the bank transaction.

Three habits that prevent a year-end scramble

• Save each statement using the same naming pattern, such as 2026-06 Fairfield resident name, and keep the files in a restricted folder.
• Use the Care Start Date, Care End Date and Months in Tax Year columns to check that the period agrees with the invoices before updating the annual figure.
• After each update, review the Dashboard and investigate a sudden change in family-paid costs rather than allowing it to roll into December.

Keep the spreadsheet as the calculation layer and the receipts as the evidence layer. I would not overwrite the formula cells to force the relief to match a preferred result; if the figure differs from Revenue's calculation, add a note to the supporting records and investigate the difference.

When to move beyond Excel

One workbook is practical for one or several residents, but it becomes awkward when multiple relatives edit it, payments come from several accounts, or there are more than 100 supporting documents each year. At that point, use a controlled shared document system or bookkeeping package with user permissions and an audit trail, while retaining the Excel summary for review.

Restrict access because resident names and care costs are personal data under GDPR. Keep one dated backup before making annual changes, and use the Instructions sheet as the handover note if a family member or bookkeeper takes over during 2026.

For that handover, the care contribution estimate keeps the annual figures aligned with the Excel summary when the family or bookkeeper takes over during 2026.