Working for Families Tax Credit Excel - Free Template

1. Enter the household ID, names, city and tax year on Input & Estimate. Start with the basics so each family stays easy to track later.
2. Add the number of children in each age band and the household’s weekly family income. If income changes, update the row before you compare cases.
3. Record the in-work hours per week. The sheet then shows whether the household meets the in-work test and whether it appears eligible for Working for Families.
4. Check the estimated amounts for Family Tax Credit, In-Work Tax Credit, Best Start Tax Credit and any minimum family tax credit top-up. Use the total as your working estimate only.
5. Review the Household Summary sheet for a cleaner snapshot. That is the version you can print, share or talk through with a client or family member.
6. Open Rates & Assumptions before you rely on the result. If a rate changes for 2026, update the assumptions first so every estimate stays aligned.
7. Use the notes field to capture anything unusual, such as shared care, missing income details or a case you want to check again before filing.

This is the kind of sheet you use when you want a fast estimate before a payday, a family tax review or a budget reset. A sole trader with two children, a payroll person at a small Ltd company, or a support worker helping a whānau can all use the same layout to test the numbers.

Image 1 shows the Input & Estimate sheet with one row per household. In practice, that means you can compare a couple on $900 a week with three children against a household on $1,250 a week with one child under 5 and see the difference in support straight away.

Why the household layout matters

The layout is built around the things that actually change the result: weekly income, annual income, child ages and in-work hours. That is better than a free-form notes page, because you can scan 10 households in 10 minutes and spot the ones that need a proper check.

How it helps in real work

A bookkeeper checking client data before year-end can use the sheet to prepare questions before the client calls. A community worker can also use it to estimate whether a family with $48,000 of annual income and two school-age children is likely to be in range for support.

Working for Families is tied to family income, the number of dependent children and whether the household meets the in-work test. For 2026, the estimate still needs to be built from annual income, even if you start with weekly figures and convert them across the sheet.

The workbook sits alongside Inland Revenue rules, so keep the assumptions sheet current. If a household is just below a threshold, even a $20 a week change moves the annual figure by $1,040, which can change the estimate.

What to keep an eye on

The result is only as good as the inputs. If the household has 40 hours of combined paid work, two children aged 5–13 and weekly family income of $900, the sheet can produce a very different result from a family on the same income but only 20 hours of work.

How the sheet fits with your records

Keep the workbook with your usual family support notes and use it as a working paper, not a final decision. That way, if you revisit a case later in the year, you can see exactly which income and child counts produced the original estimate.

The usual mistake is using stale income numbers. If last month’s pay has gone up by $150 a week and you forget to update the sheet, the annual estimate is off by $7,800 and the support result can shift enough to matter.

Another common problem is counting the children correctly but missing the age band. A child turning 5 changes the age bucket in the workbook, and a family with one under 5 and one aged 6 does not look the same as a family with two under 5s.

Hours and eligibility errors

The in-work test also causes trouble when people enter contracted hours instead of actual paid hours. If someone averages 18 hours but the workbook is set to 20, the eligibility flag can show the wrong result and waste time later.

Why a neat spreadsheet saves hassle

When the row is messy, people re-enter the same family three times and then cannot tell which figure is current. That leads to double-handling, awkward follow-up and avoidable errors when you are trying to answer a client or family member quickly.

That same kind of double-handling often appears in payroll paperwork, where a tax code record keeps each declaration easy to trace.

The easiest way to keep this sheet useful is to tie it to a fixed check-in, like the first payroll run of the month or your regular family budget review. If you update it at the same time each month, it becomes part of the routine instead of another file that gets ignored.

Simple habits that keep it current

• Copy last month’s household row and change only the numbers that moved.
• Use the Notes column for anything unusual so you do not have to remember it later.
• Review the Rates & Assumptions sheet whenever a new tax year starts.
• Highlight incomplete rows so missing hours or income stand out straight away.

When to move on from a spreadsheet

If you are handling dozens of households, or you need live links to payroll or client management software, a spreadsheet will start to feel clunky. That is the point where a proper system like Xero, MYOB or a dedicated client record tool makes more sense than another manual workbook.