Payroll Statutory Deductions and Reporting

Payroll Statutory Deductions and Reporting Overview

Oracle Payroll enables you to ccalculate an employer's tax liability and deduct the appropriate sums from employee earnings. You can calculate employer and employee tax liabilities for all the taxes and statutory deductions that are applicable to your country. For example, this includes employer liability for state taxes such as State Unemployment Insurance and employee liability for federal, state and local taxes in the US, PAYE and NIC in the UK, PAYE and PRSI in Ireland, Social Security, Unemployment and Complementary Pension in France, Standard and Special tax and Social Insurance in the Netherlands, and so on.

In each instance, Oracle Payroll enables you to enter details of the tax liability and process it at regular intervals.

Reporting on Payroll Statutory Deductions

See: Reports and Processes in Oracle HRMS, Oracle HRMS Configuring, Reporting, and System Administration Guide

Running the Japan, Create Payroll Data for use in Reporting Form

You run this process to create payroll data for reporting purposes.

You run the Japan, Create Payroll Data for use in Reporting Form process from the Submit Requests window.

To run the Japan, Create Payroll Data for use in Reporting Form process

  1. In the Name field, select Japan, Create Payroll Data for use in Reporting Form. The Parameters window opens.

  2. Enter the start date from when you want to create the payroll data.

  3. The current system date appears by default as the end date.

  4. Select the payroll to create data for only those employees who belong to the selected payroll.

  5. The consolidation set appears automatically for the selected payroll.

  6. Select the assignment set for which you want to create the payroll data.

  7. Click OK and then Submit.

Running the Payroll Run (Salary) Process

You run this process when you want to make regular monthly earnings payments to employees.

You run this process in the Submit Requests window.

To run the Payroll Run (Salary) Process

  1. In the Name field, select Payroll Run (Salary). The Parameters window opens.

  2. Select the payroll for which you want to run this process.

  3. The consolidation set, payroll period and pay day appear by default for the selected payroll.

  4. Optionally select an assignment set.

  5. Select the action parameter group. If you define the action parameter group in the Profile Option HR: Action Parameter Group Name, it displays as default value. By grouping action parameter, you can set the required parameter and optimal values for each concurrent program, and as a result, for fine performance tuning.

  6. Select the Employment Insurance Rate Effective Date when required. This option enables you to define the effective date for the employment insurance rate when it should not be as of process date. For example, for the payroll the monthly salary gets paid for previous month, the application refers to the rate process date in April YYYY for monthly salary for March paid in April YYYY. However, if there are new rate changes effective from 04/01/YYYY, the rate before change may want to be referred because it's the monthly salary for March. In such case the users would define the date before 03/31/20x1.

  7. Select the Dependents Effective Date when required. This option enables you to define the effective date for the dependent information when it should not be the Date Earned. For example, for the payroll the monthly salary gets paid for previous month, the application refers to the dependent information as of 12/31/20x1 for monthly salary for December paid in January YYYY. However, if there are new legislative changes effective from 01/01/20x2, the information after 01/01/20x2 should be referred because the payment date is in January 20x2. In such case, you would define the date after 01/01/20x2..

    Note: This option works only when [Report] Extra Contact Info [Payroll] Extra Contact Info is selected for the income tax dependent reference type in Business Group or Payroll.

Running the Payroll Run (Bonus) Process

Run this process while making bonus payments to your employees.

You run the Payroll Run (Bonus) process from the Submit Requests window.

To run the Payroll Run (Bonus) Process

  1. Select the payroll.

  2. The consolidation set appears automatically for the selected payroll.

  3. Select the target date when you want to process the bonus payments. The application uses the Target date for Database items in Formulas, Formula process rule - Database items of Assignment set if ASSIGNMENT_SET_DATE = 'D' in PAY_ACTION_PARAMETERS

  4. Select the pay date when you want to pay employees. The application uses the Payment date Global values, Balance values and tables in formula. This application uses the date as of Payment Date.

  5. Select an assignment set if you want to restrict running the bonus payroll to a particular assignment set.

  6. Select an action parameter group. If you define the action parameter group in the Profile Option HR: Action Parameter Group name, it is displayed as default value. By grouping action parameter, you can set the required parameter and optimal values for each concurrent program, for fine performance tuning.

  7. The computation period displays automatically as 6. You can change a number 1-12 when required. This defines which income tax rate table (bonus or monthly salary) will be used in the calculation.

  8. Select the Employment Insurance Rate Effective Date when required. This option allows the users to define the effective date for the employment insurance rate when it should not be as of process date.

  9. Select the Dependents Effective Date when required. This option allows the users to define the effective date for the dependent information when it should not be the Date Earned.

    Note: This option works only when [Report] Extra Contact Info [Payroll] Extra Contact Info is selected for the income tax dependent reference type in Business Group or Payroll.

  10. Specify Yes or NO if SI – Summarize Bonus is paid in the same month. If you select yes, the health insurance premium amount, welfare pension insurance premium amount and max limit amount of the standard bonus are calculated and validated based on the total amount of bonuses in the month. If you select no, then those are calculated and validated based on the individual bonus, even though they get paid multiple bonuses in the month.

  11. Click OK and then Submit.

Running the Payroll Run (Special Bonus process)

You run the Special Bonus process when an employee receives bonus more than four times in a year.

You run the Payroll Run (Special Bonus) process from the Submit Requests window.

To run the Payroll Run (Special Bonus) Process

  1. In the Name field, select Payroll Run (Special Bonus). The Parameters window opens.

  2. Select the payroll for which you want to run this process.

  3. The consolidation set appears by default for the selected payroll.

  4. The target date and pay day display the current system date. You can change if required.

  5. Select the assignment set.

  6. Select the action parameter group. If you define the action parameter group in the Profile Option HR: Action Parameter Group Name, it displays as default value. By grouping action parameter, you can set the required parameter and optimal values for each concurrent program, and as a result, for fine performance tuning.

  7. The computation periods display a value of 12 by default. You can change a number 1-12 when required. This defines which income tax rate table (bonus or monthly salary) will be used in the calculation.

  8. Select the Employment Insurance Rate Effective Date when required. This option allows the users to define the effective date for the employment insurance rate when it should not be as of process date.

  9. Select the Dependents Effective Date when required. This option allows the users to define the effective date for the dependent information when it should not be the Date Earned.

    This option works only when [Report] Extra Contact Info [Payroll] Extra Contact Info is selected for the income tax dependent reference type in Business Group or Payroll

  10. Click OK and then Submit.

Running the Payroll Run (Retirement Money) Process

You run this process to pay the retirement money to employees retiring from your organization.

You run this process from the Submit Requests window.

To run the Payroll Run (Retirement Money) process

  1. In the Name field, select Payroll Run (Retirement Money). The Parameters window opens.

  2. Select the payroll for which you want to run this process.

  3. The consolidation set appears by default for the selected payroll.

  4. The system date appears by default in the target date field.

  5. The system date appears by default in the pay day field.

  6. Select the assignment set.

  7. Select the action parameter group. If you define the action parameter group in the Profile Option HR: Action Parameter Group Name, it displays as default value. By grouping action parameter, you can set the required parameter and optimal values for each concurrent program, and as a result, for fine performance tuning.

  8. Click OK and then Submit.

Running the Withholding Income Tax Report for Termination Income

Run the Withholding Income Tax Report for Termination Income for employers to issue to employees when termination money is paid on termination.

You run the Japan, Withholding Income Tax for Termination Income from the Submit Requests window.

To run the Japan, Withholding Income Tax Report for Termination Income

  1. In the Name field, select Japan, Withholding Income Tax Report for Termination Income.

  2. Click in the Parameters field to open the Parameters window.

  3. Enter the specific year for which you have run the archive.

  4. Specify the withholding agent.

  5. You can sort by employee number or district code. This is a mandatory. The default is Employee Number.

  6. Enter the termination dates from and until when you want to publish the report for terminated employees.

  7. Select the assignment set to restrict the report for a particular set.

  8. Click OK and then Submit.

Running the Japan, Withholding Tax Report Generation Process

The Japan, Withholding Tax Report Generation process is a pre-process of YEA reports, including the withholding income tax report. In this process all the required YEA data is archived.

You run the Japan, Withholding Tax Report Generation process from the Submit Requests window.

To run the Japan, Withholding Tax Report Generation

  1. In the Name field, select Japan, Withholding Tax Report Generation.

  2. The Parameters window opens.

  3. In the Run Japan, Create Payroll Data for use in Reporting Form field, select Yes to run Japan, Create Payroll Data for use in Reporting Form. Select No if Japan, Create Payroll Data for use in Reporting Form has already been done.

  4. The current system date appears by default in the Subject Date field. You can change the date for when you want to run the report.

  5. Select the payroll and the withholding agent.

  6. Select to archive terminated employees.

  7. Enter the termination dates, if Archive Terminated People is Yes.

  8. Select Yes if you want to re-archive the data. The default is No.

    If you select Yes, then archive data will be created or re-created for all the assignments, even for the assignments for which the Japan, Withholding Tax Report Generation has been run before and the archive data already exists.

    If you select No, then archive data will be created only for the assignments that have no archived data yet, and no updates for the assignments for which the Japan, Withholding Tax Report Generation has been already done and archive data already exists.

    Note: If Re-archive is No, then the existing data will be saved regardless of this value.

  9. Select if you want to inherit the archive data for Description. If you select Yes, then User Description under Description for use in Reporting Form section and User Description (Kanji) under Description for use in Magnetic File section you entered on SSHR Japan, Withholding Tax Report will be saved. The default is Yes.

  10. Select the open period status. If you select Open in the Open Period Status, then enter the start and end dates for the open period to enable you to view and make updates to the employee information. The default is Closed.

  11. Select the assignment set to run the report for a particular group of employees.

  12. If the Japan, Create Payroll Data for use in Reporting Form is Yes, then enter the start and end dates to create payroll data.

  13. If the Japan, Create Payroll Data for use in Reporting Form is Yes, then select the consolidation set.

  14. Click OK and then Submit.

Running the Japan, Withholding Tax Report Generation (Standalone)

You can use the Japan, Withholding Tax Report Generation (Standalone) process to archive the tax withheld amounts.

Note: The difference between Japan, Withholding Tax Report Generation report (Standalone) and Japan, Withholding Tax Report Generation report is that, Japan, Withholding Tax Report Generation runs Japan, Create Payroll Data for use in Reporting Form in the concurrent process, but not in Japan, Withholding Tax Report Generation report (Standalone). To run Japan, Withholding Tax Report Generation report (Standalone), you have to run Japan, Create Payroll Data for use in Reporting Form process prior to running this process.

You run the Japan, Withholding Tax Report Generation Report (Standalone) from the Submit Requests window.

To run the Japan, Withholding Tax Report Generation report (Standalone)

  1. In the Name field, select Japan, Withholding Tax Report Generation (Report (Standalone). The Parameters window opens.

  2. The current system date appears by default in the Subject Date.

  3. Select the payroll.

  4. Select the withholding agent.

  5. Select if you want to archive terminated employees. The default is Yes.

  6. Enter the termination dates, if Archive Terminated People is Yes..

  7. Select if you want to re-archive the data. The default is No.

    If you select Yes, then archive data will be created or re-created for all the assignments, even for the assignments for which the Japan, Withholding Tax Report Generation has been run before and the archive data already exists.

    If you select No, then archive data will be created only for the assignments that have no archived data yet, and no updates for the assignments for which the Japan, Withholding Tax Report Generation has been already done and archive data already exists.

    Note: If Re-archive is No, then the existing data will be saved regardless of this value.

  8. Select if you want to inherit the archive data. The default is Yes.

    Select if you want to inherit the archive data for Description. If you select Yes, then User Description under Description for use in Reporting Form section and User Description (Kanji) under Description for use in Magnetic File section you entered on SSHR Japan, Withholding Tax Report will be saved. The default is Yes.

  9. Select the open period status. If you select Open in the Open Period Status, then enter the start and end dates for the open period to enable you to view and make updates to the employee information. The default is Closed.

  10. If you select Open in the Open Period Status field, then enter the start and end dates for the open period. If the period is Open, then you can update the information. It the period is Closed, then you can only review the information.

  11. If the Japan, Create Payroll Data for use in Reporting Form is Yes, then enter the start and end dates to create payroll data.

  12. If the Japan, Create Payroll Data for use in Reporting Form is Yes, then select the consolidation set.

  13. Click OK and then Submit.

Running the Japan, Withholding Tax Report of Earned Income

Run the Japan, Withholding Tax Report for Earned Income process to report the money paid to employees. You run the Japan, Withholding Tax for Earned Income from the Submit Requests window.

To run the Japan, Withholding Tax Report of Earned Income

  1. In the Name field, select Japan, Withholding Tax Report for Earned Income. The Parameters window opens.

  2. Enter the year to run the report.

  3. Enter a withholding agent.

  4. You can sort by employee number or by district code. This is mandatory.

  5. Select Yes to report only the employee's income details to the tax office.

  6. Select Yes to report the income details of the terminated employees.

  7. Enter the termination dates from when you want to process this report.

  8. Select the specific employees to restrict the report.

  9. Select an assignment set to restrict the report for a particular set of employees.

  10. Select an output type.

  11. Select the chunk size.

  12. Select Yes to display the assignment number in the report. The default is No.

  13. Select Yes to Print with Era Code before Era Change. The default is No.

  14. Click OK and then Submit.

Running the Withholding Income Tax Report for Termination Income – Archive

Run the Japan, Withholding Income Tax for Termination Income Archive process to archive the payment details of the termination money paid to employees.

You run the Japan, Withholding Income Tax for Termination Income - Archive from the Submit Requests window.

To run the Japan, Withholding Income Tax Report for Termination Income – Archive process

  1. In the Name field, select Japan, Withholding Income Tax Report for Termination Income - Archive. The Parameters window opens.

  2. Select No if you've already performed Run Japan, Create Payroll Date for use in Reporting Form for the current results of termination money data in the Run Japan, Create Payroll Date for use in Reporting Form field. The default is Yes so as to submit the JP Pre-Tax Archiver process prior to archiving process.

  3. Enter the effective date for running the archive the details of the employees who must be paid termination money within the specified year.

  4. Select Yes, if you have previously the archived data and want to delete it and re-archive. The default is No.

  5. Specify a withholding agent.

  6. Specify a payroll.

  7. Enter the Termination date from and to for which you want to archive

  8. Select an assignment set, if you want to restrict the archive for a particular assignment set.

  9. Enter the start and end dates for the pre-archive process. This is enabled when you set the Run Japan, Create Payroll Date for use in Reporting Form to Yes.

  10. Enter the consolidation set for the pre-archive process. This is enabled when you set the Run Japan, Create Payroll Date for use in Reporting Form to Yes.

  11. Click OK and then Submit.

Running the Japan, Withholding Book and Wage Ledger – Archive

You can use the Japan, Withholding Book and Wage Ledger - Archive to archive the monthly salary, bonus payment, and year-end adjustment information for reporting purposes. indow.

Run the Japan, Withholding Book and Wage Ledger – Archive from the Submit Requests window.

To run the Japan, Withholding Book and Wage Ledger – Archive

  1. In the Name field, select the report name. Then select the Parameters field to open the Parameters window.

  2. Enter the date for the archive. YYYY/MM is used for archiving the data. This is a mandatory field.

  3. Specify the special withholding agent. This is a mandatory field.

  4. Select New, Recreate, Add, or Amendment as the archive mode. This is a mandatory field.

    • New, Recreate: Create or recreate the data from January to specified month of the year.

    • Add: Add the data after the already archived month to specified month.

    • Amendment: Correct the data of specified month, which is already archived before.

  5. Specify payroll group for archiving. This is optional.

  6. Specify an assignment set if you want to restrict the archive to a particular set. This is optional.

  7. Click OK and then Submit.

Running the Japan, Withholding Book and Wage Ledger

You can use the Japan, Withholding Book and Wage Ledger to report the monthly salary, bonus payment, and year-end adjustment information of the year for reporting purposes.

Run the Japan, Withholding Book and Wage Ledger from the Submit Requests window.

To run the Japan, Withholding Book and Wage Ledger Report

  1. In the Name field, select the report name. Then select the Parameters field to open the Parameters window.

  2. Enter the date for the reporting year. This is a mandatory field.

  3. Specify the special withholding agent for reporting. This is a mandatory field.

  4. Specify payroll group for reporting. This is optional.

  5. Specify the location which you want to report. This is optional.

  6. Specify if you want to include all organization under the specified organization.

  7. Specify the organization to report. If you do not select any organization, the report displays for all organizations. This is optional.

  8. Specify Yes if you want to include terminated employees in the report. This is a mandatory field.

  9. Specify the termination dates from and until when you want to include terminated employees.

  10. Specify an assignment set if you want to restrict the report for a particular set. This is optional.

  11. Specify the preferable sort order. If no sort order is specified, the employee number is used for sorting.

  12. Click OK and Submit.

Running the Separation Certificate – Archive Process

Run the Separation Certificate – Archive process to archive the details of the terminated employees. Employers issue the Separation Certificate to terminated employees on their request for submitting to the employment insurance office.

You run the Japan, Separation Certificate Archive process from the Submit Request window.

To run the Japan, Separation Certificate - Archive

  1. In the Name field, select the report name. Then select the Parameters field to open the Parameters window.

  2. Enter the effective date for running the archive.

  3. Specify the employment insurance office where the employee is registered.

  4. Enter the Termination dates from and until when which you want to published the report. This is a mandatory and defaults to the Effective Date.

  5. Enter an assignment set if you want to restrict the archive to a specific set of assignments.

  6. Click OK and then Submit.

Running the Japan, Separation Certificate Report

Run the Separation Certificate to issue to employees insured under Employment Insurance for claiming unemployment insurance when they leave their job.

Run the Japan, Separation Certificate from the Submit Requests window.

To run the Japan, Separation Certificate Report

  1. In the Name field, select the report name. Then select the Parameters field to open the Parameters window.

  2. Enter the specific year and month in which you have run the archive. The report picks data from the year start till the Subject Year Month entered.

  3. Select a Payroll ID from the list of values of archives and publish the report. The list of values depends on the specified Subject year and month.

  4. You can sort by Employee Number, Termination date. Default is Employee Number.

  5. Specify an assignment set if you want to restrict the report for a particular assignment set.

  6. Click OK and then Submit.

Running the JP Payslip Generation – Self Service Process

You run this process for generating the payslip for self service users.

You run the JP Payslip Generation – Self Service process from the Submit Requests window.

To run the JP Payslip Generation - Self Service process

  1. In the Name field, select JP Payslip Generation – Self Service Process. The Parameters window opens.

  2. Enter the start date and end date for when you want to generate the payslip.

  3. Select to generate the payslip for the selected payroll.

  4. The consolidation set appears automatically for the selected payroll.

  5. The payment date appears by default depending on the end date entered.

  6. Enter a label for the payslip for identification purposes.

  7. Click OK and then Submit.

Running the Payroll Report (Check List for Geppen at Child-Care Leave/Maternity Leave End)

If you want to report the result of the Payroll Run (Geppen at Child-Care Leave End/Maternity Leave End) process, you run the Payroll Report (Check List for Geppen at Child-Care Leave End/Maternity Leave End) for such employees.

Note: EBS does not comply with the Nihon Horei format of the Notification of Geppen after Child-Care Leave/ Notification of Geppen after Maternity Leave, but the Notification of Geppen.

You run the Payroll Report (Check List for Geppen at ChildCare Leave End/Maternity Leave End) from the Submit Requests window.

To run the Payroll Report (Check List for Geppen at Child-Care Leave End/Maternity Leave End) Process

  1. In the Name field, select Payroll Report (Check List for Geppen at Child-Care Leave End/Maternity Leave End). The Parameters window opens.

  2. Select the payroll.

  3. Select the consolidation set.

  4. Select the applying month. The applied date appears by default. This means from which monthly salary the result should be applied.

  5. Select the effective dates.

  6. Enter the location.

  7. Select where you want to submit the details.

  8. Select the Output Flag. The default is to include all assignments. You can select to exclude or include assignments in the report.

  9. Select the reported date. The default is current date.

  10. Select the employees for whom you want to run the report.

  11. Click OK and then Submit.