IR4 Company Tax Return Workings Excel - Free Template

1. Start on the Cover & Instructions sheet and check the company details, IRD number, NZBN and balance date are correct. The example file is set up for Aroha Consulting Ltd, so replace those fields before you do anything else.
2. Move to the IR4 Workings sheet and enter the accounting result plus any tax adjustments. Add items such as non-deductible expenses, depreciation changes, and any income that needs to be treated differently for tax.
3. Use the Provisional Tax sheet if you need to test the next instalment or compare current-year figures with the prior year. This is useful when you want to see whether the company is likely to have a payable amount or a refund position.
4. Check the Summary Dashboard for the final position and any key totals you want to review quickly. The dashboard is there for a fast read, so you do not need to scan the whole worksheet when you are pressed for time.
5. Cross-check the tax result against your source reports, such as the trial balance, depreciation schedule and year-end journals. A clean set of workings is only useful if it ties back to the numbers in your accounts.
6. Save a fresh copy for each year and keep the old file with your records. Inland Revenue expects records to be kept for 7 years, so do not overwrite the prior working paper.

This is the sort of file you use when a company has reached year-end and somebody has to turn the accounts into a tax position. In practice, that is often a bookkeeper at a small Ltd company, a director doing the first review, or an accountant helping a client with a 31 March balance date.

On a real job, you might be dealing with a Christchurch consulting company turning over $420,000 a year, or a Hamilton tradie company with 4 staff and a ute fleet. You need a place to park the accounting profit, then layer on the tax adjustments so the final IR4 figure is traceable.

Why the workbook matters at filing time

The biggest win is control. If the company has $18,000 of accounting profit, $4,200 of non-deductible expenses and $6,500 of depreciation adjustments, you can see the tax picture without rebuilding the numbers from scratch in a note or email chain.

That matters when you are reviewing the return before sending it on to Inland Revenue. A clear workings file also makes it easier to explain why the final taxable income is different from the profit and loss.

Where it fits in your year-end process

You would normally open it when the draft accounts are ready, not halfway through the year. It is also useful if you are comparing the current year with last year’s result, because the pattern of adjustments often repeats.

For a small company, that is a lot faster than hunting through old PDFs. One workbook with the workings, the provisional tax view and the dashboard gives you a cleaner review pack.

A company files an IR4 rather than an IR3, and the working papers should support the tax result shown in the return. Inland Revenue expects records to be kept for 7 years, so the workbook should be saved with the source reports that back it up.

If the company is GST-registered, that does not change the company tax return itself, but the underlying accounting figures need to tie to the books. For a standard company, the taxable year usually follows the 31 March balance date unless a different approved date is used.

Rates and deadlines that matter in practice

Company tax planning often starts with provisional tax. If the company’s residual income tax is high enough, you need to budget for instalments during the year rather than waiting for the final return.

For example, if the return shows $36,000 of residual income tax, that cash will usually be easier to handle if you have been setting aside $3,000 a month than if you leave it until year-end. That is why a workings sheet with a provisional tax view is so useful.

Why the structure needs to be tidy

The template includes a cover sheet with company details like the IRD number and NZBN, which is useful for audit trail and filing support. That is not just admin fluff — it helps you match the file to the right entity when you are dealing with multiple companies.

For a two-company group, that can save an ugly mistake. A working paper labelled clearly at the front is far safer than a loose spreadsheet called “final tax v6”.

The most common mistake is starting from the profit and loss and forgetting the tax adjustments. That can leave you overstating deductions by thousands of dollars, especially where entertainment, private use or non-deductible costs are sitting in expenses.

Another one is depreciation. If a company buys a $28,000 ute and the depreciation schedule is not updated, the tax result can be wrong by hundreds or even a few thousand dollars depending on the asset mix and timing.

Missing links between the reports

I have seen jobs where the accounts say one thing, the tax working paper says another, and the figures do not reconcile by $1,240 or $8,900. Once that happens, every check after that takes longer, because nobody trusts the starting point.

The fix is not more talking — it is a proper workings file that keeps the adjustment lines visible. If you can see the add-backs and deductions in one place, review becomes much quicker.

Provisional tax surprises

Another pain point is leaving provisional tax until the last minute. If the company earned $54,000 more taxable income than expected, the tax bill can feel brutal if no money was parked aside during the year.

That is why the provisional tax sheet matters. It turns a year-end shock into a number you can plan around, which is much easier on cash flow.

Provisional tax surprises become far easier to map once the add-backs, deductions, and year-end figures sit in one place; the IR3 income tax return spreadsheet NZ provides that same structured layout for the personal return side of the process.

The easiest way to keep this useful is to tie it to the same routine every year. Most small companies will get the best result if the workbook is updated as soon as the draft accounts are ready, rather than waiting until someone chases the return.

For a March balance date, that usually means a fixed block in April or May, before the file gets buried under GST returns and payroll work. If you leave it for three months, you spend more time re-checking the source numbers than actually doing the tax work.

Simple habits that keep it alive

• Copy the prior-year file and change the dates, company details and year labels first.
• Use the same source reports each year so the adjustment pattern stays familiar.
• Keep the depreciation schedule, trial balance and journals in the same folder as the workbook.
• Use cell formatting and simple checks so unusual figures stand out before filing.

When to move on from a spreadsheet

If the company has multiple entities, lots of intercompany entries, or a complex tax position, the spreadsheet may stop being enough on its own. At that point, you are usually better off doing the accounting in Xero or MYOB and using the workbook only as a review layer.

For a straightforward small company, though, this template is often enough. It gives you a clean working paper without forcing you into software you do not need yet.

For a straightforward small company, this IR526 donation tax credit claim spreadsheet sits neatly alongside the workbook approach, giving you another clean paper trail for a separate NZ tax task without extra software.