A Australia/New Zealand Payroll Reports

This appendix contains the following topics:

A.1 Australia/New Zealand Payroll Reports: A to Z

This table lists the JD Edwards EnterpriseOne Payroll for Australian and New Zealand reports, sorted alphanumerically by report ID.

Report ID and Report Name Description Navigation
R07845

DBA Transaction with Fund Information Report

This report lists the fund allocation details that are associated with the superannuation benefit and deduction amounts for each employee.

In addition to other details, this report displays the total superannuation amounts for an employee and the grand total of amounts for all employees. The report also displays the Unique Superannuation Identifier (USI) number that the system retrieves from the F07845 table.

Reports (G07BUSP165), select DBA Transaction with Fund Information.
R07855

Employee Fund Allocation Report

This report enables you to review superannuation enrollment information for each employee within the organization. The report includes information such as:
  • Fund ID and name.

  • Membership number.

  • Allocation percentage.

  • Effective dates.

You can set the effective dates in the processing options for this report to include historical information.

Reports (G07BUSP165), select Employee Fund Allocation.
R75A0003

Coinage Analysis Report

This report produces a coinage requirements analysis for each employee to ensure that the minimum number of coins and notes are issued for each payment range. This report includes each employee in the pay cycle whose payment type is a cash payment. Australia/New Zealand Reports (G07BUSP17), select Coinage Analysis.

You can access this report from the Australia/New Zealand Reports menu to update processing options and create new versions of the report; however, you cannot run the report from this menu. You must run this report during an active pay cycle using the reporting options on the Pay Cycle Workbench.

R75A0007

Superannuation Contribution by Employee Report

The Superannuation Contribution by Employee report enables you to review all of the employee and employer superannuation fund contributions that are made during a specified time period. Australia/New Zealand Reports (G07BUSP17), select Superannuation Contribution by Employee.
R75A0010

Payroll Tax Summary Report

You use the Payroll Tax Summary Report (R75A0010) to review tax history information for specific tax areas in a specified tax year and tax period. This report includes gross wages, excludable wages, taxable gross, tax payable, and an employee count for each tax area. Australia/New Zealand Reports (G07BUSP17), select Payroll Tax Summary Report.
R75A0012

Tax Scale Listing Report

This report lists each tax scale that you set up, along with the detail information about that tax scale. We recommend that you run this report and review tax scales before processing employees through a payroll cycle. Australia/New Zealand Reports (G07BUSP17), select Tax Scale Listing.
R75A0014

Tax Rule Listing Report

This report lists the tax rules, by tax scale, for each tax scale that you set up. We recommend that you run this report and review tax scales before processing employees through a payroll cycle. Australia/New Zealand Reports (G07BUSP17), select Tax Rules Listing.
R75A0136

Repost Tax Ledger to Tax Summary for AU

You use this report to verify that the Payroll Tax History Detail table (F06166) and the Payroll Tax History Summary table (F06136) are in synch. This report totals the amounts that are contained in the tax detail records in the F06166 and updates the F06136 with the totals, overwriting the existing information.

Caution: Oracle recommends that you back up the F06136 table before you process this report. Additionally, this report should have a high level of security, as running the report incorrectly can adversely affect tax history data. Work with your system administrator to verify that security for this report is set correctly.

Run this report from batch versions by entering BV in the fast path field.
R75A0745

Superannuation DBAs And Funds

You use this report to review the superannuation history for employees. You run this report to review superannuation details after running pre-payroll and before running the final payroll update. Australia/New Zealand Reports (G07BUSP17), select Superannuation DBAs And Funds
(Release 9.2 Update) R75A730

AU STP XML File Generation

You use this report to generate the XML that you need to submit to ATO to report payments after every pay period. This report retrieves the payment details from F75A710 and F75A710A tables. Payroll (G07BUSP1), select Australia STP Workbench.

On the Work with STP Submissions form, select a record and select Generate XMl from the Row menu.


A.2 Australia/New Zealand Payroll: Selected Reports

These reports are listed alphanumerically by report ID in this appendix.

A.2.1 Setting Processing Options for the DBA Transaction With Fund Information Report (R07845)

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

A.2.1.1 Processing

Select the Processing tab.

1. Begin Date Range

Use this processing option to specify the beginning date in a range of dates. The system includes all DBA transactions that are associated with superannuation contributions beginning with this date, and going through the date that you enter in processing option 2.

2. End Date Range

Use this processing option to specify the ending date in a range of dates. The system includes all DBA transactions that are associated with superannuation contributions beginning with the date that you enter in processing option 1, and going through the date that you enter in this processing option.

A.2.2 Setting Processing Options for the Employee Fund Allocation Report (R07855)

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

A.2.2.1 Processing

Select the Processing tab.

1. Begin Date Range

Use this processing option to specify the beginning date in a range of dates. The system includes all DBA transactions that are associated with superannuation contributions beginning with this date, and going through the date that you enter in processing option 2.

2. End Date Range

Use this processing option to specify the ending date in a range of dates. The system includes all DBA transactions that are associated with superannuation contributions beginning with the date that you enter in processing option 1, and going through the date that you enter in this processing option.

A.2.3 R75A0010 - Payroll Tax Summary Report

After you complete the final update step of the payroll process, the system stores employee tax information in history tables. You use the Payroll Tax Summary Report (R75A0010) to review tax history information for specific tax areas in a specified tax year and tax period. This report includes gross wages, excludable wages, taxable gross, tax payable, and an employee count for each tax area. The system uses the localization country code that is set up in the user profile to identify which tax areas to include in the report. The report includes all tax areas that are associated with the appropriate country and that have records in the Tax History table (F06136) for the specified time period.

A.2.4 Setting Processing Options for Payroll Tax Summary Report (R75A0010)

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

A.2.4.1 Defaults

1. Enter the tax year to be processed. The default of blank will use the current tax year.

Specify the tax year to be processed. The default of blank will use the current tax year. Enter a valid tax year.

2. Enter the period number within the tax year for which the report is to be run. The default of blank will use the current period number.

Specify the period number within the tax year for which the report is to be run. The default of blank will use the current period number. Enter a valid period number.

3. Enter the Tax Type for the State Payroll Tax. The default of blank will use 'ST'.

Specify the Tax Type for the State Payroll Tax. The default of blank will use ST. Enter a valid tax type.

A.2.5 Setting Processing Options for the Repost Tax Ledger to Tax Summary for AU Report (R75A0136)

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

A.2.5.1 Tax Repost

Use these processing options to specify which records you want to repost from the F06166 to the F06136. If you leave these options blank, the system reposts the entire F06166 to the F06136, overwriting all existing records.

Caution:

Oracle recommends that you back up the F06136 table before you process this report.
1. Tax Area to Repost

Use this processing option to specify the tax area that you want to repost to the F06136 table. Only records associated with this tax area will be reposted. If you leave this option blank, the system reposts all tax areas.

2. Tax Type to Repost

Use this processing option to specify the tax type that you want to repost to the F06136 table. Only records associated with this tax type will be reposted. If you leave this option blank, the system reposts all tax types.

3. Tax Year to Repost

Use this processing option to specify the tax year that you want to repost to the F06136 table. Only records associated with this tax year will be reposted. If you leave this option blank, the system reposts all tax years.

4. Month to Repost

Use this processing option to specify the tax month that you want to repost to the F06136 table. Only records associated with this tax month will be reposted. If you leave this option blank, the system reposts all tax months.

5. Employee Number to Repost

Use this processing option to specify the employee that you want to repost to the F06136 table. Only records associated with this employee will be reposted. If you leave this option blank, the system reposts tax records for all employees.