Preliminary Tax Estimate Excel - Free Template

1. Open Preliminary Tax Estimate and enter the tax year, name, PPS number or Tax Reference Number, county and tax type. Keep the record consistent so you can compare entries later.
2. Fill in estimated income or profit and allowable expenses. The sheet uses those figures to arrive at taxable income or profit before credits.
3. Check the credit fields for PAYE tax credit, single person credit and earned income credit. These are the main figures that reduce the amount payable for many taxpayers.
4. Enter any preliminary tax already paid. The template will show the balance due or overpaid, which is the figure you need for planning cash flow.
5. Review Tax Rules & Assumptions before you rely on the estimate. That sheet keeps the assumptions visible rather than buried in a formula.
6. Use Summary Dashboard to review the overall position and print or save the file once the figures are checked.

This template is for the people who have to make a sensible guess before the return is filed: a sole trader with mixed business and private spending, a contractor with several invoices, a small Ltd company director, or a bookkeeper preparing the figures for the Form 11. In practice, it is most useful in September to November, when you are trying to see whether the tax bill will be a nuisance or a cash-flow problem.

The first sheet, Preliminary Tax Estimate (image 1), is set out as a clean table with columns for tax year, name, PPSN or Tax Ref No., county, tax type, estimated income or profit, allowable expenses, taxable income or profit, credits, income tax, USC, PRSI, preliminary tax already paid, balance due and status. That is exactly the sort of layout a sole trader can update in ten minutes after month-end. A carpenter with 4 employees might use it to compare his own tax estimate against the payments already made through the year.

For a worked example, say an online shop owner expects €85,000 turnover and €22,000 expenses. That leaves €63,000 taxable profit before credits, which is enough to make a preliminary tax estimate worth checking properly rather than leaving until the last week in November.

Using it for one person or several

If you are a bookkeeper handling 5 or 6 clients, the sheet works as a list rather than a single calculation. That means you can keep one estimate for each client and compare the balances due without opening separate workbooks.

Why the sample rows matter

The sample data is there to show how the template handles PAYE, sole trader and contractor cases. It is not just decoration; it gives you a pattern for the fields that matter when you are typing in the real figures.

The second sheet, Tax Rules & Assumptions (image 2), should be the first place you check before using any estimate. The figures in Ireland matter: the standard VAT rate is 23%, but that is not the key rate here; for this template the important pieces are income tax, USC, PRSI and the relevant credits used in the calculation.

For 2026 planning, you still need to think in terms of filing deadlines and records. Revenue expects you to keep records for 6 years, and the Form 11 self-assessment return is normally due in mid-November on ROS. If you are a sole trader, preliminary tax needs to be ready well before then so you do not create a cash squeeze at year end.

Take a simple example: a self-employed person with €95,000 profit and €18,000 allowable expenses needs to see the effect of credits and social charges, not just the headline profit number. A limited company director might instead be looking at payroll income, PAYE deductions and personal tax credits, while the company itself is dealing with Corporation Tax at 12.5% on trading income via Form CT1.

Where the numbers in the sheet come from

The template keeps the assumptions visible in one place so you can see what rate or credit is driving the result. That matters if you are comparing two scenarios, such as taking more drawings as a sole trader versus moving some income through a company payroll.

What the dashboard shows

Summary Dashboard (image 3) pulls the entered figures into a simpler view, which is useful when you are checking the estimated balance before payment. If you are preparing for preliminary tax, the dashboard gives you the quick answer without hunting through the whole table.

The usual failure is not the maths; it is the missing figure. If you leave out a second income stream, forget a prior payment, or use the wrong tax year, the estimate can be off by hundreds or thousands of euro.

A common example is a contractor who earns €72,000, puts €12,000 of expenses through the business, and forgets that €8,000 of preliminary tax was already paid. On paper the estimate may look manageable, but the real balance due is much smaller, or even an overpayment. That is the kind of mistake that leaves cash sitting idle in Revenue when it could have stayed in your bank account.

Another issue is mixing up personal and business figures. A sole trader who treats private motor costs as allowable expenses can distort the taxable profit and understate the likely bill. If that error is repeated over 12 months, the gap can easily run into €1,000 to €3,000 once USC and PRSI are added.

Bad input, bad estimate

Image 1 is structured to reduce that risk by forcing the key items into separate columns. When the columns are filled properly, you can spot if one client has no expenses entered, or if the balance due looks too low for the level of profit.

Why a rough guess is expensive

A rough guess can wreck cash flow in a small business. If you expect a €4,000 bill and it turns out to be €9,500, you have not just made a spreadsheet error; you have created a funding problem for wages, stock or rent.

That same gap is exactly why a contract tax tracker matters, because each job needs its own record before the total due starts to drift away from the real liability.

The template works best when you tie it to a fixed routine. Most users should update it once a month, ideally after payroll or after the bank reconciliation, so the estimate moves with the business rather than sitting untouched until November.

The simplest habit is to copy the latest figures, refresh the income and expense totals, and review the dashboard on the same day every month. If you are already doing a VAT3 return or month-end payroll, that is the right hook — one routine, one spreadsheet, no extra admin slot.

Small habits that keep it alive

• Use the same day each month, such as the last Friday or the 5th, so you never have to decide when to update it.
• Copy the prior month’s figures forward and only change the numbers that moved, which saves time and reduces keying errors.
• Mark the status field as reviewed once the estimate has been checked, so you can see at a glance what is done.
• Keep the rules sheet beside the estimate sheet so rate changes or credit changes are visible before you start relying on the figure.

If you have more than 20 or 30 recurring lines, or you are tracking multiple years and several linked entities, you are probably beyond a simple spreadsheet. At that point a proper bookkeeping or tax system is easier to control than trying to force one workbook to do everything.

That is usually the point where a tax return workbook becomes the better fit than keeping multiple years and linked entities inside one estimate file.