KiwiSaver Reconciliation Excel - Free Template

1. Open the Reconciliation sheet and enter each employee’s payroll details for the pay period. Use the yellow input cells for the numbers you know from the payroll run.
2. Add the expected employer KiwiSaver contribution for each employee. For example, 3% of a $1,200 gross pay packet is $36.00.
3. Check the difference column against what was actually paid. If one employee is short by $12.50 across 2 pays, you can fix it before the next filing.
4. Review the Summary sheet to see totals by pay period and the overall variance. This is the sheet you can use when you want one quick figure for the whole team.
5. Use the Reference sheet when you need the standard rates or a reminder of the contribution logic. It keeps the rules in one place instead of buried in email notes.
6. Follow the Instructions sheet the first time you use the workbook, then copy the structure for each new pay run or month-end reconciliation.

A KiwiSaver employer contribution reconciliation spreadsheet is what you reach for when you need to check payroll numbers against what should have been paid. In practice that is usually a payroll admin, office manager, bookkeeper or owner-manager looking at a pay run with 4 staff, 12 staff or 40 staff and wanting the totals to line up.

The workbook in this template is built for that job. The Reconciliation sheet is where you work through each employee, the Summary sheet gives you the totals, and the Reference and Instructions sheets keep the pay logic close at hand.

When the check matters most

You normally use it around payday filing, month-end, or when you are reviewing a payroll correction. If a Christchurch builder has 6 staff on mixed wages and salary, a $7.50 shortfall on each of 4 employees quickly becomes a $30 error before you even count any KiwiSaver top-up or adjustment.

Why a spreadsheet still helps

A payroll system can process the pay, but a spreadsheet is still handy when you want a separate control sheet. It lets you test the numbers, print a clean summary, and keep a visible trail for the person who signs off the payroll or checks the bank payment.

For employer KiwiSaver contributions, the practical rule is simple: the employer contribution is 3% of gross salary or wages for eligible employees, and it sits alongside PAYE, ACC and any KiwiSaver deductions on the payroll run. If you pay an employee $1,000 gross, the employer contribution is $30.00; at $1,250 gross, it is $37.50.

That is why reconciliation matters. If your payroll shows 8 staff and the contribution should total $320.00 for the week, but the bank payment or payroll report shows $312.50, you are $7.50 short and can fix it before the mistake rolls forward.

Records and timing

Inland Revenue expects good records to be kept for 7 years, so a payroll reconciliation sheet is useful evidence if you need to show how you checked the numbers. For employers filing under payday filing, the employer schedule is reported through the IR348, so keeping a clean support file by pay date makes the monthly workflow much easier.

Choosing the right approach

For a small team, a spreadsheet check before submitting payroll is usually better than trying to explain differences after the fact. If you are reconciling 15 employees and each one takes just 2 minutes to confirm, that is 30 minutes well spent to avoid a messy adjustment run.

That same quick check is easier to document when employee deductions are already captured in a saver contributions tracker by pay period.

The most common problem is not the rate itself, it is the data around the rate. An employee with the wrong gross figure, a missed opt-in deduction, or a pay period that gets doubled up can throw the contribution total off by $10, $50 or much more before anyone notices.

Another common slip is comparing the wrong totals. If you reconcile employer contribution only but forget that the payroll report already includes a previous correction, you can think you are short when the numbers are actually right.

Small errors that become real money

Say you have 10 employees and 2 of them are underpaid by $4.20 each for 6 fortnights. That is $50.40 in total, and the correction takes time from payroll, management and possibly the employee who spots the issue on their payslip.

Why the paperwork matters

A reconciliation sheet with no date, no pay period and no employee names is almost useless when you come back to it 6 months later. If you are looking at a year-end review or a payroll audit trail, the time saved by having the numbers laid out clearly is worth more than the few minutes it takes to fill the sheet properly.

A dated levy estimate sheet keeps the figures traceable when you need to reconcile the numbers against a later payroll review or audit trail.

The easiest way to keep this spreadsheet alive is to tie it to something you already do every pay cycle. Most small firms use it straight after payroll is finalised, or on the same day they prepare the IR348 filing and bank payment.

Simple habits that stick

• Save one copy per pay period so you can compare week to week or month to month.
• Paste in the payroll totals first, then check the employer contribution line second.
• Use the Summary sheet as your sign-off page before you file or pay.
• Keep the workbook in the same folder as your payroll reports so you are not hunting for files at 5:00 pm.

When to move on from a spreadsheet

If you are dealing with 30+ staff, multiple pay rates, salary sacrifice, or frequent employee changes, the manual check will start to drag. That is the point where Xero or MYOB payroll controls may be better, with the spreadsheet kept only as a review tool for month-end or year-end.

For everyone else, a tidy workbook is often enough to catch the 1% of payroll errors that cause 90% of the grief.