Managing Inhabitant Tax

This chapter provides an overview of the inhabitant tax business process and maintaining the Inhabitant Tax table, lists prerequisites, and discusses how to:

• Set up the Inhabitant Tax table.

• Load the Inhabitant Tax data.

• Print the Inhabitant Tax report.

Understanding the Inhabitant Tax Business Process

Global Payroll for Japan provides rules, pages, processes, and reports that you use to:

• Set up the Inhabitant Tax table, which holds municipality and recipient-number data for employees as well as inhabitant-tax monthly amounts.

• Prepare Wage Payment reports and summaries for municipalities.

• Load inhabitant tax amounts and individual numbers that are received from the municipalities either manually or through a data load process.

• Deduct inhabitant tax amounts from monthly salary.

• Prepare monthly inhabitant tax reports for municipalities.

See Running Year-End Reports.

Object Year

Object Year generally refers to the year for which you want to run a process or generate a report. When we discuss inhabitant tax, object year is defined like this: The municipality provides monthly inhabitant tax amounts for a period that runs from June 1 to May 31 of the following year. The object year is the year in which June 1 falls.

Viewing Delivered Elements

The PeopleSoft system delivers a query that you can run to view the names of all delivered elements designed for Japan. Instructions for running the query are provided in the PeopleSoft Enterprise Global Payroll 8.9 PeopleBook.

See Also

Viewing the Delivered Elements

Maintaining the Inhabitant Tax Table

The Inhabitant Tax table (GPJP_IH_PYE_TAX) includes effective-dated rows for each employee paying inhabitant tax. This row includes employee ID, employment record number, recipient number, individual number, municipality code, previous employment last month, and special collection amount. Inhabitant Tax will be deducted only from one Job Record of an employee for each payment that the employee receives.

To determine an employee’s inhabitant tax, the system first creates a relationship between the postal code in which employees live and the municipalities that charge inhabitant tax. This requires a correlation between the municipality table and the postal code table. The Blank Municipality Audit Report query identifies postal codes that are not associated with municipality codes. After this relationship is established, a connection exists between the employee and the municipality.

Now that the employee-municipality relationship has been identified, you can create the Inhabitant Tax table. The table will be populated with tax amounts either by loading data electronically using the Load Inhabitant Tax process (GPJP_IHMUN2) or by entering the data manually.

This diagram illustrates the process of maintaining the Inhabitant Tax table:

Maintaining the Inhabitant Tax table

The following list provides more details about maintaining the Inhabitant Tax table:

1. Associate municipality codes with tax establishments and taxpayer-specified numbers on the Municipality table.

2. Associate municipality codes with postal codes on the Postal Code table.

3. Update employee addresses as of January 1 of the object year.

4. Run the Blank Municipality Audit Report query to identify postal codes that do not have a municipality code in the Japan Postal Code table.

   Add missing municipality codes to the Japan Postal Code table.

5. Run the Municipality Audit report to check for invalid postal codes in employee addresses.

   • Correct errors that are reported by the audit report.

   • Rerun the audit report until all errors are corrected.

   • Correct all errors before you run the Pre-Load Inhabitant Tax process (GPJP_IHMUN1).

6. Run the Pre-Load Inhabitant Tax process.

   The process loads each employee’s municipality code and recipient number into the Inhabitant Tax table with the effective date of June 1 of the object year.

   Edit recipient numbers and/or employment record number for the object year on the Inhabitant Tax Data page, if necessary.

7. Send updated Wage Payment reports with summary to each municipality by the end of January of the object year.

8. Load employee inhabitant tax amounts and individual numbers that are provided by the municipality in May of the object year.

   • To load data from a printed list, manually enter tax amounts on the Inhabitant Tax Data page.

   • To load data from an electronic file, use the Load Inhabitant Tax process (GPJP_IHMUN2).

See Also

Running Year-End Reports

Prerequisites

Before processing inhabitant tax, perform these setup steps:

1. Associate municipality codes with tax establishments and taxpayer-specified numbers on the Municipality Table page.

2. Associate municipality codes with postal codes on the Postal Code Table page.

3. Define a file handle for each municipality’s electronic file that you want to load directly into the Inhabitant Tax table. Use the File Handle Table page.

   You do not have to do this step if you load inhabitant tax amounts manually.

See Also

Setting Up for Inhabitant Tax Processing

Setting Up the Inhabitant Tax Table

This section provides an overview of the Pre-Load Inhabitant Tax Process and discusses how to:

• Identify and correct blank municipality codes on the Japan Postal Code table.

• Audit and correct postal code errors.

• Run the Pre-Load Inhabitant Tax process.

Understanding the Pre-Load Inhabitant Tax Process

The Pre-Load Inhabitant Tax process (GPJP_IHMUN1) selects employees by the specified salary payer reference number. It loads their municipality codes and recipient numbers into the Inhabitant Tax table with the effective date of June 1 of the object year. You can view and update or correct the results of this process on the Inhabitant Tax Data page.

Municipality Code

The process selects the municipality code in the Postal Code table based on the postal code that is in the employee’s legal address record as of January 1 of the object year. If the employee does not have a legal address, the process uses the postal code that is in the home address record.

Employment Record Number

If a row of Inhabitant Tax data already exists, then the Employment Record of the New row is updated with the Employment Record of the old row. If no row exists, then the record that has a tax type of ‘KOU’ is selected for tax deductions for the newly inserted row. If there are no record with tax type ‘KOU’ then the minimum Job Record with a Pay System Flag of ‘GP’ is selected for Tax Deductions for the newly inserted row.

Recipient Number

The process loads each employee’s recipient number in the following way:

• Implementation year.

  The process enters the employee ID as the recipient number. You must correct the recipient number manually if the recipient number is different from the employee ID.

• Subsequent years.

  The process looks up the municipality code of the object year. It compares that municipality code with the employee’s municipality code existing in the Inhabitant Tax record of the previous year.

  • If the municipality codes do not match, the process assigns a new recipient number.

  • If the municipality codes match, the process carries forward the recipient number.

Cautions About Running the Process

Before running this process, be sure to run the Blank Municipality Audit Report query and the Municipality Audit Report, and correct all postal code errors.

You can run this process only once for each salary-payer reference number and object year. If you try to run it a second time, the process halts with an error message.

Auditing and Correcting Postal Code Errors

Run the Municipality Audit report to find postal code errors in employee address records as of January 1 of the object year. When looking up the postal code, the process first looks to the legal address. If the employee does not have a legal address, the process looks to the home address.

The following table shows the possible error messages and the method of correction:

Pages Used to Set Up the Inhabitant Tax Table

Identifying and Correcting Blank Municipality Codes on the Japan Postal Code Table

Access the Query Manager page.

To identify and correct blank municipality codes on the Japan Postal Code table:

1. Search for the GPJP_AUDIT_BLANK_MUNIC query.

2. Run the query.

3. View the list of postal codes for which the municipality code is blank.

Note. Correct the missing municipality codes on the Japan Postal Code table before running the Pre-Load Inhabitant Tax process.

Running the Pre-Load Inhabitant Tax Process

Access the Pre-Load Inhabitant Tax page.

Object Year	The default is the current year.
Salary Payer Reference Number	The process selects all employees who are reported to the municipality for the salary payer reference number that is entered here.

See Also

Understanding the Pre-Load Inhabitant Tax Process

Loading Inhabitant Tax Data

This section provides an overview of loading inhabitant tax data and discusses how to:

• Update inhabitant tax data and manually enter tax amounts.

• View year-to-date inhabitant tax amounts.

• Load inhabitant tax amounts from electronic file.

Understanding Loading Inhabitant Tax Data

You can either enter the inhabitant tax amounts manually or load the tax amounts from an electronic file.

After a payee's inhabitant tax data is loaded, the data can be changed through the reloading process. You can overwrite or delete the data when the status is Updated by User.

When loading inhabitant tax data, you can:

• Load the file that was sent from a Municipal office into the table.

• Modify the rows that were loaded by the process, if necessary.

• Create new rows, especially for new employees whose information has not yet been submitted to the Municipal office.

Pages Used to Load Inhabitant Tax Data

Updating Inhabitant Tax Data and Manually Entering Tax Amounts

Access the Inhabitant Tax Data page.

Effective Date	The Pre-Load Inhabitant Tax process sets this date to June 1 of the object year for employees who are reported to the municipality. Use June 1 of the object year for manual entry of Inhabitant Tax Data for new hires regardless of their actual dates of hire.
Empl Rcd Nbr (employment record number)	Select the record number of the employment record from which you want to collect inhabitant tax data.
Recipient Number	If the employee ID is not the correct recipient number, you can change it.
Individual Number	View the value loaded by the Load Inhabitant Tax process.
Municipal Code	Based on the employee’s postal code as of January 1 of the object year.
Prev Employment Last Month (previous employment last month)	Enter the last month that the previous employer paid inhabitant tax. Use this field if the payee was hired during the object year.

Tax Amount Details

Viewing Year-to-Date Inhabitant Tax Amounts

Access the Collection Status Details page.

This page summarizes the data that you need to complete the Change of Status Report on Special Collection.

Loading Inhabitant Tax Amounts from Electronic File

Access the Load Inhabitant Tax page.

Object Year	The current year is the default.
File Handle	Select the file handle that identifies the municipality file that you want to load to the Inhabitant Tax table.

Note. PeopleSoft provides the file layout for the Tokyo municipality as a model. You can modify the layout for other municipalities using Application Designer.

Record Load Options

See Also

Setting Up File Handles

Printing the Inhabitant Tax Report

This section lists the page you use to print the Monthly Inhabitant Tax report.

Page Used to Print the Monthly Inhabitant Tax Report