13 (NZL) Generating the New Zealand IR File and Report

This chapter contains the following topics:

13.1 Understanding Tax Reporting for New Zealand

New Zealand employers are required to submit monthly tax returns to the New Zealand Inland Revenue Department. Some employers are also required to file this information on a semimonthly basis. All employers are expected to file this information electronically. To accommodate these reporting needs, you can run the New Zealand IR File and Report program (R75Z0006). This program creates a flat file in the format that is required by the Inland Revenue Department, along with a report, which lists all of the information that is contained in the file. The flat file and the report are created based on data that is stored in the New Zealand Ledger Detail table (F75Z0002).

13.2 (NZL) Generating the New Zealand IR File and Report

This section discusses how to:

  • Generate the New Zealand IR file and report.

  • Set processing options for the New Zealand IR File and Report program.

  • Generate the Labour Department Statistics Report for New Zealand.

  • Set processing options for the Labour Department Statistics Report for New Zealand.

13.2.1 Generating the New Zealand IR File and Report

Select Australia/New Zealand Reports (G07BUSP17), New Zealand IR File and Report.

13.2.2 Setting Processing Options for New Zealand IR File and Report (R75Z0006)

Processing options enable you to specify the default processing for programs and reports.

13.2.2.1 Report

1. Enter the Period Start date for this report

Specify the period start date for this report.

2. Enter the Period End date for this report

Specify the period end date for this report.

3. Enter the deduction code used for Child Support Payments

Specify the deduction code used for child support payments.

4. Do you wish to create an electronic file for filing?Y/N

Specify whether you want to create an electronic file for filing. Values are:

Y: Yes

N: No

No is the default value.

13.2.2.2 Electronic File

1. Enter the Name of the Payroll Contact person.

Specify the name of the payroll contact person.

2. Enter the Phone Number of the Payroll Contact person

Specify the phone number of the payroll contact person.

3. Enter the IRD form version number to be used. Default value is 0001

Specify the IRD form version number to be used. The default value is 0001.

4. Enter the file name for the output file, including extension

Specify the file name for the output file, including the extension.

5. Do you wish to update the date reported field on the records processed Y/N

Specify whether you want to update the date reported field on the records processed. Values are:

Y: Yes

N: No

13.2.3 Generating the Labour Department Statistics Report for New Zealand

Select Australia/New Zealand Reports (G07BUSP17), Labour Department Statistics Report.

Employers in New Zealand might be required to report statistical information to the New Zealand Labour Department on a quarterly basis. To fulfill this requirement, you can print the Labour Department Statistics Report (R75Z0007). This report groups selected employees by employment status and sex and lists the number and value of regular and overtime hours worked.

13.2.4 Setting Processing Options for Labour Department Statistics Report (R75Z0007)

Processing options enable you to specify the default processing for programs and reports.

13.2.4.1 Date

1. Enter the Date of End of Quarter:

Specify the As Of date. If you leave this processing option blank, the system uses the current date.

The default value is today's date.

13.2.4.2 Full/Part Time

1. Use Employment Status Field (Y/N)

Specify whether the system uses the Employment Status field or the Employee Master Category Code to determine if an employee works full time or part time. Values are:

Y (default): Use the Employment Status field.

N: Use the Employee Master Category Code.


Note:

If the Employment Status field is completed with LE 1, the employee is full time. If the Employment Status field is completed with GT 1, the employee is part time. If the Employee Master Category Code is blank, the employee is full time, otherwise the employee is part time.

2. If using Employee Master Category Code then enter the 3 digit CC Number.

Specify the category code for the Employee Master. You complete this processing option if you completed the Use Employment Status Code processing option with N.


Note:

If the Employment Status field is completed with LE 1, the employee is full time. If the Employment Status field is completed with GT 1, the employee is part time. If the Employee Master Category Code is blank, the employee is full time, otherwise the employee is part time.

Values can range from 001 through 020.

13.2.4.3 Ordinary Time/Overtime

1. Use Pay Type Category Field (Y/N)

Specify whether the system uses the Pay Type Category field (PTCT) or UDCs to identify ordinary time and overtime. If you enter Y for this processing option, complete the processing options on the Pay Type Category tab. If you enter N for this option, complete the processing options on the UDC Tables tab. Values are:

Y (default): Use the Pay Type Category field (PTCT) on the PDBA Master.

N: Use UDC tables.

13.2.4.4 Pay Type Category

1. Ordinary Time Pay Type Category

Specify a value from the Pay Categories/DBA Print Group UDC (06/PC). If you leave this processing option blank, the system uses R (Regular).

2. Overtime Pay Type Category

Specify the code that the system uses for overtime pay. You select a value from the Pay Categories/DBA Print Group UDC (06/PC). If you leave this processing option blank, the system uses V (Overtime).


Note:

The system uses this processing option only if you entered Y in the Use Pay Type Category Field processing option.

13.2.4.5 UDC Tables

1. If you have specified the use of UDC Tables to identify Ordinary Time

Specify the product code of the UDC that contains the code for identifying overtime pay. For example, if the UDC is set up in the 07 (JD Edwards EnterpriseOne Payroll) system, enter 07.


Note:

The system uses this processing option only if you entered N in the Use Pay Type Category Field processing option.

2. If you have specified the use of UDC Tables to identify Overtime:

Specify the user-defined code that identifies overtime pay. The system uses this processing option only if you entered N in the Use Pay Type Category Field processing option.