Report Balancing (NZ)

Use the following table to balance reports for payroll or tax reconciliations.


	Report
Value	EMS (IR348)	Employer Deductions (IR345)	Pay Sequence Detail Report	Pay Period Calculation Listing
Total Allowances Taxable	N/A	N/A	"Allowances Taxable"	"All Taxable Gross"
Gross (Taxable) Earnings	Summary field "Gross Earnings"	N/A	"Allowances Taxable" minus "Deductions Taxable"	N/A
PAYE	Summary field "PAYE excluding Tax on Schedular Payments" + "Tax on Schedular Payments" – "Donation Tax Credit"	"Total PAYE and Tax (on Schedular Payments)"	"PAYE Payable"	"All PAYE Payable"
KSE	Summary field "KSE Employee Deductions"	"Total KiwiSaver Deductions"	N/A	N/A
KSR	Summary field "KSR Employer Contributions (ex ESCT)"	"Total KiwiSaver Employer Contributions"	N/A	N/A
Total ESCT	N/A	"Total ESCT Deducted"	N/A	Add up the "Employer Tax" values for each Z-type allowance in the Payroll Summary Non-Paying Allowances and Direct Credits sections
KSR ESCT	Summary field "ESCT"			"ESCT" column on the "Employer Total" line of the "KiwiSaver Contributions" section of the Payroll Summary
Child support	Summary field "Child Support"	"Total Child Support Deductions"	N/A	N/A
Student loan	Summary field "Student Loans"	"Total Student Loan Deductions"	N/A	N/A
Donation Tax Credits (test 1)	Summary field "Donation Tax Credits	N/A	N/A	"Total" column value of the TAXCREDITDON transaction in the Deductions section
Donation Tax Credits (test 2)	N/A	"Total PAYE and Tax (on schedular payments)	N/A	Sum"Total" column value of the PAYE + EP + TAXCREDITDON transactions in the Deductions section

Superannuation Funds

This section explains how to balance values for individual superannuation funds.

Run PGPRSUPA310 - Superannuation Contributions from July 2009 with the first Sorting tab | Field = Superfund.Superfundcode, and the Totals checkbox ticked.
The resultant report contains employee, employer and ECST values for each superannuation fund, including ESCT values (in the tax column) for KiwiSaver and non-KiwiSaver funds.
Run the PGPRPRIM001 - Pay Period Calculation Listing with the Print Payroll summary and Show super checkboxes selected.
The resultant report displays KiwiSaver funds separately so they are easy to balance. However, non-KiwiSaver funds are more difficult to balance.

Use the following table to balance non-KiwiSaver values:

Value	PGPRPRIM001 - Pay Period Calculation Listing	PGPRSUPA310 - Superannuation Contributions from July 2009
Employer Super	Add up the "Total" values for each Z-type allowance in the Payroll Summary Non-Paying Allowances and Direct Credits sections	"Employer Contribution" (for relevant fund)
ESCT	Add up the "Employer Tax" (under the Non-Paying Allowances and Direct Credits sections) for the allowances of the relevant fund	"Tax" (for relevant fund)

Note: If you use one Z-type allowance for multiple superannuation funds, then you will not be able to balance individual superannuation fund values.