Processing U.K. Withholding

To set up U.K. withholding, use the Withholding Codes component (WTHD_CODE).

This section provides an overview of the U.K. Construction Industry Scheme (CIS).

Page Name

Definition Name

Usage

Withholding Entity Page

WTHD_ENTITY

Define the withholding entities (tax authorities).

Entity Fields - Supplier Page

WTHD_ENTITY_FIELDS

Indicate which information the tax authority (entity) requires for your suppliers.

Procurement Control - Withholding Page

BU_WTHD_JUR

Specify General Ledger business unit withholding setup.

Withhold Code Page

WTHD_CODE

Define withholding codes.

Withhold Rule Page

WTHD_RULE

Establish rules that determine the actions to be taken during withholding.

Withhold Type Page

WTHD_TYPE

Define withholding types and associate them with withholding classes.

Withholding Supplier Information Page

VNDR_GBL_OPT_SEC

Define withholding control information and reporting information for the supplier location.

Entering Address Information for CIS Suppliers

VNDR_ADDRESS

Enter an alternate name to be used on withholding transactions.

Report Control Information - Payor Data Page

WTHD_CONTROL

Enter payor data as defined by your tax authorities.

Calendar Builder Page

CALENDAR_BUILDER

Create and maintain tax calendars.

Withhold Report Post Page

WTHD_RPT_POST

Define parameters for running the Withholding Reporting Application Engine process (AP_WTHDRPT) to populate the withholding report table with data from the withholding transaction table based on your report setup.

Print CIS Payment Statement Page

GBR_CIS_RPT_RUN

Print CIS payment statement.

See Withhold Report Post Page

This section describes how to implement the CIS using the Global Withholding features in PeopleSoft Payables.

In the U.K., payments to suppliers for construction operations fall within the scope of the CIS. This scheme states that suppliers (referred to in the scheme as subcontractors) who operate in the construction industry can be paid only if they are holders of either a Registration Card or a Subcontractors Tax Certificate. Registration Card holders have amounts deducted from their payments for labor based on their tax and National Insurance Contribution (NIC) liability. Certificate holders can be paid gross, but details of all the payments must be retained for reporting to the Inland Revenue.

With the legislative changes effective 04/2007, Contractors and sub-contractors will no longer use CIS Vouchers. Contractors must send a monthly return to HM Revenue & Customs including details of payments made within the scheme to all sub-contractors, details of any deductions they have made from payments to sub-contractors, a declaration confirming that employment status has been considered, and a declaration that the verification process has been applied correctly.

Note: Detailed Inland Revenue specifications are available at this web address: http://www.hmrc.gov.uk/new-cis

CIS Sample Data

The withholding setup for the U.K. should be configured as the sample data shown in this table:

Type

Value

Withhold Entity

HMRC

Withholding Rule

CIS0

 Withholding Rule

CISS

Withholding Rule 

CISI

Withholding Type

CIS07

Withholding Class

CISI

 Withholding Class

CISIM

 Withholding Class

CISS

 Withholding Class

CISSM

Withholding Jurisdiction

UKWTA

Withholding Code

CISS

 Withholding Code

CISSSM

 Withholding Code

CISI

 Withholding Code

CISIM

Withholding Code

CIS0

Note: Jurisdiction is not needed for CIS processing, but it is a required object in the data structure. A dummy jurisdiction of UKWTA is delivered with the sample data.

Registration Cards

Registration cards, of which there are two types, are issued to those that do not qualify for a subcontractor tax certificate. For holders of these cards, a deduction must be made on payments at the prevailing rate that is specified by the government. The two types of registration cards are:

Term

Definition

CIS4(P) - Permanent Card

This bears the National Insurance number of the card holder. It has no expiration date.

CIS4(T) - Temporary Card

This does not bear the National Insurance number and has an expiration date.

In PeopleSoft Payables, no distinction is made between the two types of registration cards. This is because withholding is triggered by the withholding code and its associated rule, not by attributes that are assigned to the supplier. Oracle recommends that registration card holders use the delivered sample withholding codes (or their equivalents).

Use the Withholding Entity page (WTHD_ENTITY) to define the withholding entities (tax authorities).

Navigation:

Set Up Financials/Supply Chain > Product Related > Procurement Options > Withholding > Withholding Entities > Withholding Entity

This example illustrates the fields and controls on the Withholding Entity page.

Withholding Entity page

The system creates scheduled payments for amounts that are deducted from payments to sub-contractors defined under the withholding entity. These payments must be made to the HM Revenue & Customs within 14 days after the end of the tax month. You must create a supplier that represents the Accounts Office of the HM Revenue & Customs to which these deducted amounts can be remitted. To ensure that scheduled payments are made to the HM Revenue & Customs supplier, you enter the supplier details on the Withholding Entity page.

To ensure that deductions from payments made to CIS Sub-contractors are kept as a separate payment that can be made at the end of the month to the HM Revenue & Customs, select the Create Withholding Payment check box for the CIS4 withholding class. Then, in the Round Option field, select Natural as the rounding option (you must not leave this field blank). Set the Hold Payment field to Wthd Only (withhold only) or No Hold.

Important. You must define at least one entity named HMRC as there is processing tied to the entity.

Use the Entity Fields - Supplier page (WTHD_ENTITY_FIELDS) to indicate which information the tax authority (entity) requires for your suppliers.

Navigation:

Set Up Financials/Supply Chain > Product Related > Procurement Options > Withholding > Withholding Entities > Entity Fields - Supplier

Mark the Registration Insurance Number, Business Type, Verification Complete, Verification Date, Verification Number, and Taxpayer Identification Number fields as optional.

Use the Procurement Control - Withholding page (BU_WTHD_JUR) to specify General Ledger business unit withholding setup.

Navigation:

Set Up Financials/Supply Chain > Business Unit Related > Procurement > Procurement Control > Withholding

To ensure that the supplier withholding defaults are passed to the voucher, select the Collection Agent Flag option for the withholding entities that apply to your business unit.

Use the Withhold Code page (WTHD_CODE) to define withholding codes.

Navigation:

Set Up Financials/Supply Chain > Product Related > Procurement Options > Withholding > Withholding Codes > Withhold Code

There are several different classes you can use for CIS withholding:

Field or Control

Description

CIS0

Sub-Contractor non-deduction.

CISI

Incentive deduction

CISIM

Sub-contractor materials

CISS

Standard deduction

CISSM

Sub-contractor materials

Use the Withhold Rule page (WTHD_RULE) to establish rules that determine the actions to be taken during withholding.

Navigation:

Set Up Financials/Supply Chain > Product Related > Procurement Options > Withholding > Rules > Withhold Rule

There are several different rules you can use for CIS withholding:

Field or Control

Description

CIS0

No Deduction

CISS

Verified supplier with a standard deduction of 20 percent.

CISI

Unverified or Incentive deduction of 30 percent.

Use the Withhold Type page (WTHD_TYPE) to define withholding types and associate them with withholding classes.

Navigation:

Set Up Financials/Supply Chain > Product Related > Procurement Options > Withholding > Types and Classes > Withhold Type

PeopleSoft delivers the CIS07 withholding type that is associated with the CIS0, CISI, CISS, CISSM, and CISIM withholding classes.

Use the Withholding Supplier Information page (VNDR_GBL_OPT_SEC) to define withholding control information and reporting information for the supplier location.

Navigation:

Suppliers > Supplier Information > Add/Update > Supplier > Location

Click the Global Withholding link on the Supplier Location page.

This example illustrates the fields and controls on the Withholding Supplier Information page. You can find definitions for the fields and controls later on this page.

Withholding Supplier Information UK

Withholding Information

The following fields in this grid have specific requirements for certificate withholding:

Field or Control

Description

Withholding Entity

Select the entity to which the withholding amounts are reported.

Withholding Type

Select the type of withholding. For each withholding type, there may be classes and categories associated with the type.

Withholding Jurisdiction

Select the withholding jurisdiction for this type of withholding.

Default Jurisdiction

Select to ensure that the withholding defaults are copied to the invoice.

Default Withholding Class

Select a withholding class that will be used as a default for this supplier location.

Withhold

Select when setting up certificate information or registration card information for the supplier.

Hold Pay Indicator

Accept the default from the control hierarchy, or select Specify to override the default and activate the Hold Payment field.

Hold Payment

Select from these options:

  • Hold All: Hold both the payment and the withholding amount for this supplier.

  • No Hold: Do not hold payments for this supplier.

  • Wthd Only (withhold only): Hold only the withholding amount.

Withhold Rule Indicator

Accept the default from the control hierarchy, or select Specify to override the default and activate the Rule field.

Withholding Rule

Select a withholding rule. The withholding rule describes the actions to be taken during withholding.

Remit Withhold to Flag

Select withholding Entity or Supplier to indicate to whom you remit withholding payments for this supplier location.

Remit Supplier

For a remit to of Supplier, select the supplier to whom you want to remit withholding information.

Withholding Reporting Information

Field or Control

Description

Withholding Entity

Select the entity to which the withholding information is reported. The withholding entity is the body to which withholding is reported. You can define more than one entity for a supplier location.

Address Seq (address sequence)

Select the supplier's address from the addresses defined on the Supplier Information - Address page. The entity needs the supplier's address.

Business Type

Select Corporation or Individual.

Registration/Insurance Number

Enter the registration number if this is a corporation or the insurance number if this is an individual.

Verified

Select this check box if the number provided has been verified.

Verification number

Enter the verification number provided by the HMRC

Verification Date

The system automatically populates this field with the current date when the Verified check box is selected.

Match TIN

Select this check box if you have used the IRS online matching process. If the check box is selected, then the TIN Match Code is set to 0 and the TIN Match status set to Matched.

TIN Match Status

Displays the TIN match status. The various options displayed are New, Pending, Matched, or Error.

TIN Match Code

Displays the match code returned by the IRS (U.S. Internal Revenue Service).

  • 0: TIN and Name match

  • 1: TIN missing or entered incorrectly

  • 2: TIN entered is not currently issued

  • 3: TIN and Name do not match

  • 4: Invalid TIN matching request

  • 5: Duplicate TIN matching request

  • 6: TIN Match found only on SSN (Social Security Number)

  • 7: TIN Match found only on EIN (Employer Identification Number)

  • 8: TIN Match found on both the SSN and EIN

Match Date

Match date is the date the user enters when the file is uploaded. If the TIN was manually matched, the user can enter the match date from the Interactive TIN matching process. The Match date can be entered only if the Match TIN check box is selected.

IRS Tracking Code

The IRS assigns a tracking code to every file the user downloads. If the user enters the tracking code when the file is loaded into PeopleSoft, the supplier/location can be tracked enabling the user to tie the TIN to a bulk file.

Manually Matched

The check box will be selected as default if the matching was done through the online matching process.

Use the Supplier Information - Address page (VNDR_ADDRESS) to enter an alternate name to be used on withholding transactions.

Navigation:

Suppliers > Supplier Information > Add/Update > Supplier > Address

Make sure that you include the county. The program that extracts withholding data requires that the county field to be filled in.

Complete the Withholding Alternate name field with the name that appears on the withholding document.

Use the Report Control Information - Payor Data page (WTHD_CONTROL) to enter payor data as defined by your tax authorities.

Navigation:

Set Up Financials/Supply Chain > Product Related > Procurement Options > Withholding > Report Control Information > Payor Data

Before you generate the monthly and annual returns, you must enter your own company's tax information (contractor details) on the Report Control Information - Payor Data page.

Payer Name 1 and Payer Name 2 are optional fields, but they are used on the EDI file that is submitted to the HM Revenue & Customs. Ideally, you should enter at least Payer Name 1. You should enter your Contractor tax reference in the Tax ID field. If you are using EDI to submit your returns, enter the EDI ID that is issued to you by the HM Revenue & Customs in the Transmitter Cntl Cd field.

It is also important that you enter your business address on the address page. Access this page by clicking the Envelope button.

Note: You must also make sure that you have listed the applicable business units and suppliers (or chose the All Suppliers option) on the Report Control Information - Suppliers and Business Units.

Use the Calendar Builder page (CALENDAR_BUILDER) to create and maintain tax calendars.

Navigation:

Set Up Financials/Supply Chain > Common Definitions > Calendars/Schedules > Calendar Builder

U.K. reporting consists of monthly and annual returns. You are obliged to report all payments that are made to subcontractors within 14 days of the end of the tax month.

In the U.K., the tax year runs from April 6 to April 5 of the following year. Each tax month starts on the sixth day of the month. To ensure that payments that are subject to withholding processing are reported in the correct tax month, create a monthly calendar for the U.K. tax year.

To produce the annual return, create an annual calendar.

Monthly Calendar

This is an example of a monthly calendar:

This example illustrates the fields and controls on the Calendar Builder page (monthly calendar).

Calendar Builder page (monthly calendar)

Annual Calendar

This is an example of an annual calendar:

This example illustrates the fields and controls on the Calendar Builder page (annual calendar).

Calendar Builder page (annual calendar)

You generate two kinds of reports for CIS: monthly and annual.

Generating Monthly Reports

PeopleSoft provides a flat file conforming to the CIS scheme GFF(generic flat file format) data mapping standards as defined in the EB5/CIS300 message implementation guidelines published by the HMRC.

The U.K. CIS File SQR report (APY8032), which you run from the Withhold Report request page, produces both the flat file and the report output. The PeopleSoft system produces two files:

Field or Control

Description

Construction Gross Payment Vouchers

This file contains details of payments that are made to contractors. The file that is produced is called APY8032.23E (or APCIS23E.DAT on IBM OS390 servers).

Tax Payment Vouchers

This file contains details of payments that are made to sub-contractors. The file produced is called APY8032.25E (or APCIS25E.DAT on IBM OS390 servers).

In addition to producing the flat file, you must also print a copy of the Tax Payment Voucher (form CIS25E). This single-part document is sent to the subcontractor to provide a record of the amounts that have been deducted from the subcontractor's payments during the tax month.

To create the files, you must first post the withholding details into the transaction table using the Withholding Posting Application Engine process (AP_WTHD), from the Withhold Transaction Post page. You then need to extract the data from the transaction table into the reporting tables, using the Withhold Report Post page to run the Withholding Reporting Application Engine process (AP_WTHDRPT). On the Withhold Report Post page, you enter your report ID and control ID for CIS reports (the delivered Report ID for monthly reports is CIS_NEW, UK Construction Industry Scheme; the delivered Control ID is GBR-REPORT, UK Withholding Report). For the monthly returns, you must select the U.K. monthly tax calendar.

After you extract the data to the report files, you create the output files and the CIS25E report by running the withholding reports using the Withhold Report page.

You must send the files that are produced into the EDI translation software of your choice. This software converts the flat file into EDI messages. A list of third-party EDI translation and submission software providers is available from the HMRC.

Generating Annual Reports

All payments that are made to subcontractors during the tax year must be reported to the HMRC. This can be done using preprinted, multi-part stationery or through EDI. PeopleSoft provides for the EDI solution. The system generates a flat file that conforms to the file that is specified in the HM Revenue & Customs Message Implementation Guide. A single file is produced:

End of Year Payments. The file that is produced is called APY8032.36E (or APCIS36E.DAT on IBM OS390 servers).

To create the files, all the withholding details for the year must have been posted to the transaction table using the Withhold Transaction Post page.

Then, extract the data from the transaction table into the reporting tables using the Withhold Report Post page. For the annual returns, select the U.K. annual tax calendar.

After you extract the data to the report table, you create the output file by running the Withholding Reports.

You must send the files that are produced to the EDI translation software of your choice. This software converts the flat file to EDI messages. A list of third-party EDI translation and submission software providers is available from the HM Revenue & Customs.

There are several ways in which you can set up the system to generate the payment to the HMRC. The method you select depends on the volume of CIS transactions and the way in which you run your pay cycle.

Method 1 - Placing HMRC Payments on Hold

With this method, you set up the system to place the HMRC scheduled payments on hold automatically. Within 14 days after the end of the tax month, you take the scheduled payments off hold. Set up a pay cycle that includes scheduled payment dates within the tax period range (for example, from the sixth of the previous month to the fifth of the current month). Then a single payment to the HMRC can be generated for all withheld amounts.

To place the withheld scheduled payments on hold:

  1. Set the Hold option to Wthd Only (withhold only) on the Withholding Entity page for withholdingClasses CIS0, CISS, CISSM, CISI, and CISIM.

  2. Set the Withholding Date option to Payment on the Payment Selection Criteria - Dates page.

    This sets the scheduled due date on the payment so that it is equal to the payment date, making it easier to select only the withheld payments that were made during the tax month.

A variation of this method is to place the HM Revenue & Customs supplier on hold. With this approach, you leave the supplier on hold until just before running a pay cycle that selects HM Revenue & Customs scheduled payments. You take the supplier off hold before running the pay cycle and place the supplier back on hold immediately after the pay cycle completes. To do this, you select the Hold Payments check box on the Additional Payables Options collapsible region on the Supplier Information - Payables Options page.

Method 2 - Using Pay Groups

If the volume of withheld payment is too great to permit resetting the Hold option manually, then you can use Pay Groups. You define one set of pay groups for regular payments and another pay group exclusively for payments that are made to the HM Revenue & Customs. Then you assign the HM Revenue & Customs pay group to your HM Revenue & Customs supplier. When scheduled payments are created for the withheld amount, the system assigns the HM Revenue & Customs pay group to it. When payment to the HM Revenue & Customs is due, you either temporarily include the HM Revenue & Customs pay group in the Payment Selection Criteria component (PYCYCL_DEFN) or create a new pay cycle ID. To prevent the HM Revenue & Customs payments from being selected during the tax month, use different pay groups for all other voucher payments.

Method 3- Using Withholding Class Payment Terms

When defining your withholding entities, you can indicate for every combination of withholding class and withholding categories the payment terms you want to apply to the withheld payment. For example, knowing that you need to pay within 14 days after the end of the tax month, which ends on the 5th of the calendar month, you would create a payment term (Single Payment) that contains two split terms. The first term would say that for any payment falling between the 1st and the 5th of the calendar month, the payment ID would be Same month, on the 15th. The second term would indicate that between the 6th and the end of the calendar month, the scheduled date should be Next month, on the 15th. That way, all withheld amounts that need to be paid to the HM Revenue & Customs will be scheduled to be paid on the 15th, allowing you to run your pay cycle before the due date of the 19th of the calendar month.