This chapter discusses how to:
Set up Payment Summary information.
Process Payment Summary information.
Print Payment Summaries.
Generate the Electronic Payment Summary file.
Generate the New Zealand IR file and report.
This section provides an overview of payment summaries, lists a prerequisite, and discusses how to:
Set up company address information.
Set up regional information.
Set up employee name information for payment summaries.
The Australian Tax Office (ATO) requires that all companies in Australia report detailed information about employee earnings on an annual basis. Currently, companies must submit Payment Summaries to comply with ATO regulations for earnings reporting.
Payment Summaries must be submitted to the ATO electronically. In addition, you must provide employees with paper copies of their Payment Summaries. When employees submit their personal tax information to the ATO, they must include a copy of the Payment Summary that is provided by the organization.
In addition to creating Payment Summaries for regular earnings, you must also create ETP Payment Summaries for any employees who have received ETPs at any time during the reporting year. ETP Payment Summaries provide detailed information about payments that employees receive when they are terminated from the organization.
The system creates Payment Summaries using detailed earnings and payment information that is stored in employee history tables. These tables are updated during the final update step of the payroll cycle. To create accurate Payment Summaries, you must extract the correct information from these history tables.
To accurately create and submit Payment Summaries for the organization, you should verify that this information has been set up correctly:
Company address.
Company regional information.
Employee names.
Payment summary reporting codes.
Reporting codes on PDBAs that are included in Payment Summary reporting.
Extract Payment Summary information.
Review Payment Summary data.
Revise Payment Summary data, if necessary.
Add fringe benefit taxable amounts, if necessary.
Print Payment Summaries.
Print ETP Payment Summaries.
Create the ATO extract file (EMPDUPE).
Setting Up Payment Summary Information
Before you can process Payment Summaries, you must verify that the information in the system is set up correctly to assure that the Payment Summaries that you create are valid. Invalid Payment Summaries might not be accepted by the ATO.
You must verify this information before you process Payment Summary information:
Company address.
Company regional information.
Employee names.
Payment summary reporting codes in UDC 06/S2.
In addition, you must assure that PDBAs used in Payment Summary reporting are associated with the appropriate reporting codes and that processing options for all of the Payment Summary programs are set correctly.
Company Address and Regional Information
The ATO requires organizations to provide address and regional information for the supplier and the payer companies. In some cases, these are the same companies.
The supplier company is the organization that produces the data and sends it to the ATO. The ATO uses the street address of the supplier company to return magnetic media, if requested. In addition, the ATO uses the regional information that is associated with the supplier company for all supplier-related correspondence.
The payer company is the organization that pays the employees. It is recorded in the Employee Master Information table (F060116) as the Home Company for the employee. The ATO uses the address and regional information that is associated with the payer company for any payer- or payee-related correspondence.
Note. Creating separate company address records for the supplier and the payer company is necessary only if the two companies have different physical addresses. If the companies have the same physical address, you can use the same company address record for both the supplier and payer company.
See Setting Up Company Options.
Employee Name Information
The ATO requires that the employee names on all Payment Summaries are formatted using the employee's given name, middle name, and surname. To ensure that the employee name information is formatted correctly on Payment Summaries, you must enter the employees' name on the Who's Who form.
Note. To avoid time-consuming maintenance associated with employee name formatting, you should enter the employee name information in the Who's Who form during the initial employee entry process. Adding this step to the employee entry process can significantly shorten the amount of time needed to verify the setup information during Payment Summary processing.
Payment Summary Reporting Codes
You must set up Payment Summary Reporting codes in UDC 06/S2 to specify where information should print on the Payment Summaries. Currently the ATO allows for 5 reportable allowances and 2 reportable deductions. These should be numbered A1 to A5 and U1 to U2. The codes that you use must adhere to these guidelines to ensure that information prints in the correct area of the Payment Summary form:
All reportable allowances must begin with the letter A.
For example, you might use code A1 to specify a car allowance, and code A2 to specify a meal allowance. To comply with ATO regulations, you can set up a maximum of five codes for reportable allowances.
All reportable deductions must begin with the letter U.
For example, you might use code U1 to specify union fees. To comply with ATO regulations, you can set up a maximum of two codes for reportable deductions.
All lump sum amounts must begin with the letter L.
These codes are hard-coded in the UDC table and should not be changed. For example, codes LA, LB, LC, LD, and LE are used to specify Lump Sum A, Lump Sum B, Lump Sum C, Lump Sum D, and Lump Sum E.
See Also
JD Edwards EnterpriseOne Tools 8.96 Foundation Guide
Setting Up Tax Information for PDBAs
Enter employee information into the system.
See Setting Up Employee Information.
Form Name |
FormID |
Navigation |
Usage |
Work With Company Option |
W05001CH |
HRM Setup (G05B4), Company Options |
Select a company. |
Company Options |
W05001CA |
Work With Company Options, select a record in the detail area, and then click Select. |
Enter address information. |
Revise Company Constants |
W75A9096B |
Company Options, select Regional Info from the Form menu. |
Update regional information. |
Work With Addresses |
W01012B |
Daily Processing (G0110), Address Book Revisions |
Select an employee. |
Who's Who |
W0111A |
On Work With Addresses, select an employee and then select Who's Who from the Row menu. |
Set up employee name information. |
Access the Company Options form: Address tab.
Repeat this task for all supplier and payer companies for which you are reporting Payment Summary information to the ATO.
Access the Revise Company Constants form.
Branch Number |
Enter the current active PAYE group number allocated to the employer by the ATO. |
Contact Name |
Enter the name of the caller, customer, or other contact. |
Contact Telephone Number |
Enter the telephone number of the contact person. |
Contact Fax Number |
Enter a number without the prefix or special characters, such as hyphens or periods, that makes up the telephone number for an entity. You can use any applicable telephone number format for a country. This field is used in conjunction with the Prefix field (AR1), where you enter the first segment of the telephone number, which is called the area code in the United States. When you search for an address using a phone number, you must enter the number exactly as it is set up in the Address Book system, including any special characters. |
Company E-mail Address |
Enter the email address for the company. |
Address Number |
Enter a number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location. |
Given Name |
Enter the first name of an individual. This field is informational only. |
Middle Name |
Enter the middle name or initial of an individual. This field is informational only. The name does not appear on any reports. |
Surname |
Enter the last name of an individual. This field is informational only. |
This section provides an overview of payment summary processing, and discusses how to:
Run the Create Payment Summary Extract program.
Set processing options for the Create Payment Summary Extract program.
Enter fringe benefit information by employee.
Import fringe benefit information from a spreadsheet.
Set processing options for the Payment Summary Extract Review program.
Review and revise payment summary information.
After you ensure that the system information is set up correctly, you can begin the Payment Summary process. You must create Payment Summaries for all employees who receive earnings from the organization during the tax year.
To begin the Payment Summary process, you must first extract history information for each employee for whom you want to create a Payment Summary. You extract Payment Summary information using the Create Payment Summary Extract Review program (R75A0140). This program creates records in the Australian Payment Summary table (F75A0140). The system uses information in this table to create printed Payment Summaries and the electronic media that you submit to the ATO.
After you extract Payment Summary information, you can add any necessary fringe benefit tax records to the Australian Payment Summary table. After you have extracted the information from employee history and added fringe benefit records, you can then review the information online to ensure that it is accurate. You use the Payment Summary Extract Review program (P75A0140) to create fringe benefit tax records and to review Payment Summary information.
After you have verified that all of the Payment Summary information is accurate, you can print paper copies of the Payment Summaries and you can create the file (called EMPDUPE) that you electronically submit to the ATO.
Extracting Payment Summary Information
After you have verified that the information in the system is set up correctly, you can begin the process of creating Payment Summaries. The first step in creating Payment Summaries is to extract employee history information to be included on the Payment Summary forms. You extract this information using the Create Payment Summary Extract program (R75A0140).
The Create Payment Summary Extract program extracts all of the appropriate history records for the employees that you have specified in the data selection of the version that you process. It then creates the Australian Payment Summary table (F75A0140). The system uses this table to create the electronic media that you send to the ATO.
Each time that you process a version of the Create Payment Summary Extract program, the system creates records in the F75A0140. Each of these records includes a system-generated batch number and a print status. When the records are initially created, the print status is blank. The system updates the print status as you progress through the Payment Summary process.
We recommend that you set up at least three versions of this program:
Version |
Description |
Version One |
Create this version to process year-end Payment Summary information. The data selection for this version should be set at the company level. This is the most commonly used version, and should be used to process the Payment Summaries for the tax year. |
Version Two |
Create this version to process interim Payment Summary information. The data selection for this version should be set at the employee level. You might use this version if employees are relocating overseas and they want to reconcile all of their tax obligations at the time of their relocation. |
Version Three |
Create this version to delete existing batches of Payment Summaries. You use processing options to specify the batch that you want to delete each time that you process this version. You might find that you need to delete a batch of Payment Summaries if the information in those Payment Summaries is inaccurate. To correct the information, you must delete the incorrect batch, correct any necessary information, and then recreate the Payment Summaries. You must delete the batch before creating a new batch to avoid creating duplicate Payment Summaries. |
Attaching Fringe Benefit Records to Payment Summaries
After you create records in the Australian Payment Summary table (F75A0140), you can update the records to include any necessary fringe benefit information. Fringe benefit information must be calculated outside of the JD Edwards EnterpriseOne system and manually added to the Payment Summary information.
You can enter fringe benefit information at the individual employee level, or you can import this information using an Excel spreadsheet. Regardless of how you enter fringe benefit information, you must enter it before you distribute printed Payment Summaries to the employees and before you submit Payment Summary information to the ATO.
Note. For information about items that are considered reportable fringe benefits, contact the ATO directly.
Before you can attach fringe benefit information to a payment summary, you must:
Extract employee Payment Summary information.
Set the processing options for the Payment Summary Extract Review program (P75A0140) as follows:
Set the Bucket ID to FB.
Set the Line Number to 99.
Enter a description that signifies that the manually entered records are fringe benefit tax records. The description is informational only.
If you are using an Excel spreadsheet to import fringe benefit information, create a two-column spreadsheet; set up column A for the employee number and column B for the reportable fringe benefit amount.
See JD Edwards EnterpriseOne Tools 8.96 Foundation Guide
Reviewing and Revising Payment Summary Information
After you process the Create Payment Summary Extract program (R75A0140) and attach any necessary fringe benefit information to employee Payment Summaries, you can review the information. Using the Payment Summary Extract Review program, you can review the Payment Summary for each individual employee.
You can review Payment Summaries by their print status, which is automatically updated in the Australian Payment Summary table (F75A0140) as you proceed through the Payment Summary process. A payment summary can have one of these print statuses:
Unprinted
Printed
Submitted to ATO
Duplicate
Note. You should search for duplicate Payment Summaries before you print paper copies or submit information to the ATO. Duplicate
Payment Summaries can occur in these circumstances:
You have issued an interim Payment Summary for the employee, but you included them in the year-end version of the Create Payment
Summary Extract program.
When the system identifies an employee for whom more than one Payment Summary has been created during the current tax year,
the system enters a print status of D to mark the record as a duplicate.
The employee was terminated and issued a Payment Summary at the time of termination, but was rehired by the organization within
the same tax year.
You can review information for the entire batch of Payment Summaries, or you can review the detailed information for selected Payment Summaries. In addition, you can revise the information contained in each Payment Summary. You cannot, however, revise a Payment Summary that has already been printed. To revise a Payment Summary that has already been printed, you must first delete the batch of Payment Summaries. You delete a batch of Payment Summaries by running the Create Payment Summary Extract program (R75A0140), specifying the batch number that you want to delete in the processing options. After you delete the batch, you can correct employee information if necessary. You can recreate the batch of Payment Summaries and then continue the Payment Summary process from that point.
Form Name |
FormID |
Navigation |
Usage |
Work With Payment Summary Extract |
W75A0140A |
Australian Annual PAYG Tax Reporting (G07BUSP19), PAYG Payment Summary Extract Review |
Select an employee. |
Fringe Benefit Details |
W75A0140D |
Work With Payment Summary Extract, select a record in the detail area and then select Maintain FBT from the Row menu. |
Enter fringe benefit information by employee. |
Review Payment Summary Details |
W75A0140C |
Work With Payment Summary Extract, select the record in the detail area that you want to review, and then select Review Details from the Row menu. |
Review and revise payment summaries. |
Select Australian Annual Tax Reporting (G07BUSP19), PAYG Payment Summary Extract.
Processing options enable you to specify the default processing for programs and reports.
Delete Option
1. Enter Batch Number to delete. |
Specify a batch number that you want to delete. Blank is the default. |
Access the Fringe Benefit Details form.
Access the Fringe Benefit Detail form.
To import fringe benefit information from a spreadsheet:
Press the Tab to access the first row of the detail area.
Right-click and select Import from the menu.
Select the application that you used to create the spreadsheet.
Locate the spreadsheet that you created and double-click it.
Enter the data range that coincides with the data that you entered in the spreadsheet, and then click OK.
The data range should be (A1:Bx) where x is the number of the last row in the spreadsheet. For example, if you entered 450 lines in the spreadsheet, the data range would be (A1:B450).
The system populates the detail area of the Fringe Benefit Details form, and then edits the data that you import from the spreadsheet to ensure against duplicate records and to ensure that you are not importing information for an employee who is not included in the batch.
On Fringe Benefit Details, click OK to save the imported information.
On Work With Payment Summary Extract, click Close to exit.
Processing options enable you to specify the default processing for programs and reports.
Defaults
1. Enter the two character bucket ID for manually added records. |
Specify the two-character bucket ID for manually added records. |
2. Enter the line number for manually added records. |
Specify the line number for manually added records, |
3. Enter the description associated with manually added records. |
Specify the description associated with manually added records. |
4. Print Payment Summary Version |
Specify the print payment summary version. |
Access the Review Payment Summary Details form.
If the Prt Flg field contains a Y, the Payment Summary has already been printed and cannot be revised.
This section provides an overview of the print process, lists a prerequisite, and discusses how to:
Print selected payment summaries.
Set processing options for the Print Payment Summary program (R75A0150).
Set processing options for the Print ETP Payment Summaries Program (R75A0151).
After you have reviewed the Payment Summaries and ascertained their accuracy, you can use the Print Payment Summary program (R75A0150) to print paper copies to distribute to the employees. You can print an entire batch of Payment Summaries, or you can specify a date range to print.
After you print a Payment Summary, the system updates the print status with a 1, which specifies that the Payment Summary has been printed. Subsequent reprinting does not update the print status.
You cannot revise a Payment Summary after it has been printed. If you find errors on Payment Summaries after you have printed them, you must complete these steps:
Delete the batch of Payment Summaries.
Correct any information that is necessary to create accurate Payment Summaries.
Recreate Payment Summaries and complete all steps of the Payment Summary process.
Note. If you don't need to print a large batch of Payment Summaries, you can print selected Payment Summaries using the Payment Summary Extract Review program (P75A0140).
Printing ETP Payment Summaries
When you distribute Eligible Termination Payments (ETPs) to employees, you must report that information to the ATO in the form of a Payment Summary. In addition to reporting ETP information to the ATO, you must also print paper copies of the Payment Summaries and distribute them to the terminated employees. To print ETP Payment Summaries, you use the Print ETP Payment Summaries program (R75A0151). You use data selection to specify the employees for whom you want to print ETP Payment Summaries.
Review the information on the ETP Calculations Worksheet to ensure that the Payment Summary is accurate.
See Printing the ETP Calculations Worksheet.
Access the Work With Payment Summary Extract form.
To print selected payment summaries:
Select the record in the detail area that you want to print, and then select Print Individual from the Row menu.
On Print Confirmation, click OK.
On Work With Payment Summaries, click Close.
Select Australian Annual PAYG Tax Reporting (G07BUSP19), Print PAYG Payments Summaries.
Processing options enable you to specify the default processing for programs and reports.
Defaults
Enter the beginning date for the income year |
Specify the beginning date for the income year. |
Enter the ending date for the income year |
Specify the ending date for the income year. |
Enter the name of the authorized person who signs the Group Certificates |
Specify the name of the authorized person who signs the group certificates. |
Select Australian Annual PAYG Tax Reporting (G07BUSP19), Print ETP Payment Summaries.
Processing options enable you to specify the default processing for programs and reports.
Defaults
These processing options specify default information that is used when printing ETP Payment Summaries.
1. Enter the Report Start Date |
Specify the start date of the report. |
2. Enter the Report End Date |
Specify the end date of the report. |
3. Name of Signatory |
Specify the name of the person signing the certificate. |
This section provides an overview of the Electronic Payment Summary File, and discusses how to:
Generate the Electronic Payment Summary file.
Set processing options for the Create ATO Extract File EMPDUPE program.
After you have created Payment Summaries and reviewed them for accuracy, you can generate the electronic file that you use to report Payment Summary information to the ATO. You use the Create ATO Extract File EMPDUPE program (R75A0145) to generate this file.
You can run this program in test mode to verify that the information contained in the file is correct. After you verify this information, you can run the program in production mode to generate the actual file that you will send to the ATO.
Note. If you are placing more than one file on the electronic media that you are submitting to the ATO, you must name each file
sequentially, according to ATO regulations. For example, if you place three files on one tape, you should name those files
EMPDUPE.A01, EMPDUPE.A02, and EMPDUPE.A03. You specify the name of the output file in the processing options.
Additionally, if you want to save the output files to the local PC, you must map this job to run locally on the machine.
You must specify the type of software that you are using to produce the EMPDUPE file. Each time that the software is upgraded,
this system identification changes. Contact the system administrator for assistance with correctly identifying the software
type and release.
Do not include commas or full stops when you enter the address information in the processing options. Use of these characters
will cause the ATO to reject the electronic submission.
See JD Edwards EnterpriseOne Tools 8.96 Configurable Network Computing Implementation Guide
After you create the EMPDUPE files that you want to submit to the ATO, contact the system administrator for assistance with copying these files to the appropriate electronic media.
Select Australian Annual PAYG Tax Reporting (G07BUSP19), Create ATO Extract File EMPDUPE.
Processing options enable you to specify the default processing for programs and reports.
Defaults
1. Enter the type of run (T=test, P=Production) |
Specify the type of report that you want to run. Values are: T: Test P: Production |
2. Enter report start date |
Specify the first date for the report. |
3. Enter report end date |
Specify the last date that is included in the report. |
4. Enter the ATO report specification version number |
Specify the version number of the ATO report that you want to run. |
5. Enter the company to use as the supplier of the group certificates |
Specify the company code of the organizational entity that supplies group certificates. |
6. Enter the file reference for this file. This is your reference not the ATO's |
Specify the file reference that you use for your own reference. |
7. Enter the Software product type (JD Edwards EnterpriseOne). |
Specify the product type for your software. |
8. Has the output been tested via the ATO's Electronic Commerce Interface (ECI)? |
Specify whether the output has been tested using the Electronic Commerce Interface of the ATO. |
9. ATO Corporate External Gateway USER ID |
Specify an appropriate user identification number. |
10. ECI Tested (Y or N) |
Specify whether the ECI is tested. Values are: Y: Yes N: No |
11. Enter Output filename with Full Path definition. |
Specify a name, including the full directory path, for the output file. |
Postal Address
If the supplier postal address is different to the address specified in the address book record, enter the details here
Postal Address Line 1 |
Specify the first line of the address. |
Postal Address Line 2 |
Specify a subsequent line of the address. |
Suburb, town or city |
Specify the city portion of the address. |
State |
Specify the state portion of the address. |
Post Code |
Specify the postal code portion of the address. |
Country |
Specify the country portion of the address. |
ETP defaults
Enter the first comparison date. (Usually 1st July 1983) |
Specify the first comparison date. |
Enter the second comparison date. (Usually 30th June 1983) |
Specify the second comparison date. |
This section provides an overview of tax reporting for New Zealand , and 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.
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).
Select Australia/New Zealand Reports (G07BUSP17), New Zealand IR File and Report.
Processing options enable you to specify the default processing for programs and reports.
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. |
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 |
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.
Processing options enable you to specify the default processing for programs and reports.
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. |
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. |
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. |
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. |
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. |