Help to Buy HTB Refund Estimate Excel - Free Template

1. Enter the applicant details on the HTB Estimator sheet, starting with the name, PPS number and Revenue reference. Keep the purchase and completion dates in DD/MM/YYYY format so the sheet stays readable.
2. Fill in the property fields and check the notes column. If the template flags a missing item, sort that out before you trust the estimate.
3. Open the Sample Cases sheet and compare your own figures with the worked examples. This is useful if you are unsure whether your purchase looks like a standard HTB claim or a borderline one.
4. Review the Summary Dashboard to see the main result in one place. If the figure looks wrong, go back to the input sheet rather than trying to fix it on the dashboard.
5. Use the Instructions sheet as your setup guide when you first copy the file. It is the quickest way to keep your entries consistent from the start.
6. Update the sheet once your purchase figure, lender details or completion date changes. A stale estimate is worse than no estimate at all.

A Help to Buy estimate is usually used by a first-time buyer once an offer is agreed and the mortgage process is moving. You want a rough refund figure before you get too far down the line, because the HTB amount can affect how much cash you need on completion.

The people using this kind of sheet are usually a couple buying their first home, a single buyer with a loan approval in place, or a broker helping a client check the numbers. In practice, the pressure point is the deposit stage: if the purchase price is €320,000 and your expected HTB refund is €11,000, that is money you may be counting on for legal fees, stamp duty and completion funds.

Image 1: the estimator sheet

Image 1 shows the HTB Estimator tab with the fields laid out in four columns: field, input, notes and calculation/result. That is the right layout for a buyer because it keeps the personal details, dates and property information separate from the logic.

Image 2: the sample cases

Image 2 gives you worked examples rather than a blank page. If you are buying an apartment in Dublin or a house in Cork with a completion date in June 2026, the sample cases help you see whether your own claim looks in line with a standard first-time buyer scenario.

A practical example

Take a buyer with a purchase price of €350,000, a small approved mortgage and a completion date of 30/06/2026. If the HTB estimate is €10,500, you can immediately see whether that figure makes the transaction more workable or whether you still need to bridge a cash-flow gap from savings.

The HTB claim sits within Revenue’s online process, so accuracy matters more than presentation. You need the correct PPS number, a valid Revenue HTB reference and dates that match the actual purchase timeline, because a mismatch can slow the claim down.

For Irish property buyers, timing is the technical issue that matters most. A purchase date and completion date that are out of sequence, or entered in the wrong format, can make the estimate useless even if the rest of the sheet looks fine.

Keep the record tight

Revenue record-keeping is not optional. Keep your supporting papers for 6 years, including the contract, mortgage approval, tax evidence and the HTB reference details, because you may need to show how the figure was reached.

Use the right structure

For a simple purchase, I would keep the estimate in a spreadsheet rather than in email threads or notes on your phone. A sheet like this gives you one version of the numbers, and that matters when a solicitor asks for a clean figure close to completion.

Worked timing example

If your purchase is agreed in March, your completion is in June and you are applying through ROS with the HTB reference in hand, the spreadsheet gives you a controlled check at each stage. That is better than trying to reconstruct the facts later from messages and bank statements.

The biggest mistakes are simple: the wrong dates, the wrong property details, and a refund figure that is treated as guaranteed when it is only an estimate. A claim can look healthy on paper and still fall apart if the purchase record does not match the supporting documents.

I have seen buyers lose days because they entered the completion date as 06/30/2026 instead of 30/06/2026, or because the Revenue reference was copied with one digit wrong. That sort of error does not just annoy you; it can delay a mortgage drawdown or leave you short of cash for solicitor costs.

Wrong numbers, real cost

Say a buyer expects €12,000 from HTB and plans the closing funds around that figure. If the real estimate is €9,000 because one of the qualifying inputs was wrong, you are suddenly €3,000 short and have to bridge it fast.

Too much trust in one figure

The other mistake is building the whole completion plan around a single estimate. A spreadsheet is a check, not a decision on its own, so keep a cushion if your budget is tight and do not spend every euro of the estimated refund before the claim is settled.

Blank or messy records

A blank notes column or a file with no clear input history is a nuisance when someone else has to review it. If your broker, solicitor or partner needs to trace the numbers, a clean sheet saves an hour or more of back-and-forth.

A clean paper trail matters just as much when the next question is whether the gift or inheritance pushes you over a CAT limit, which is where a threshold tracker keeps the review tidy.

The easiest way to keep this sheet useful is to treat it as part of the home-buying checklist, not as a one-off calculation. Open it whenever the purchase price changes, the lender updates the approval, or the completion date moves.

Build the habit around existing milestones

• Update the sheet when you get a new mortgage offer.
• Check the figures again when the solicitor issues the contract pack.
• Review the result on the week of completion so nothing is stale.

Save a clean copy each time

Keep one working file and one saved version for each major stage. If your figures change from €8,750 to €9,400 after a price renegotiation, you will want to see why that happened instead of overwriting the history.

When a spreadsheet is no longer enough

If you are juggling multiple purchases, shared ownership structures or a more complicated finance setup, move beyond a single workbook and keep a proper document trail. For one first-time buyer or one couple, though, this template is usually the simplest way to stay on top of the numbers.

That shift in complexity is also where a contribution estimate becomes the natural next workbook, especially when shared purchases or phased payments need a clearer paper trail.