Setting Up Net-to-Gross Calculations for Earnings

Some earnings, such as bonuses, are paid as net amounts, so you must calculate the corresponding gross amounts. For example, if you want to pay your employee a one-time bonus of 100 GBP, you can use Global Payroll for the UK to calculate the gross payment, which ensures that the employee receives 100 GBP after taxes and National Insurance contributions have been deducted.

Note: If you want to make net-to-gross payments that are subject to tax only or to National Insurance only, you must build your own net-to-gross process.

Set up net-to-gross payments for the UK in the core application using elements that are specific to Global Payroll for the UK. There are no specific pages in Global Payroll for the UK for setting up net-to-gross payments.

To set up net-to-gross calculations for an earning:

  1. Define the earning that stores the net payment to be grossed-up on the Earnings Name page in the core application.

    Global Payroll for the UK is delivered with earning GU ER TAXNI, which you can use for payments that are liable for both tax and National Insurance contributions. If you want the net amount that you enter to be liable for either tax only or National Insurance only, you must create your own earning. This earning is a member of the GU AC GRSUP SEG accumulator, which is a member of the accumulator GU AC TAXABLE PTD.

  2. Define the earning that stores the grossed-up result of the net-to-gross process on the Earnings Name page in the core application.

    Global Payroll for the UK delivers earning GU ER RESULT, which stores the grossed-up result in the core application. This earning is a member of the accumulator GBR AC ALLPAY.

    Note: If you have created a net-to-gross earning that is subject to either tax only or National Insurance contributions only, you must create an additional earning that stores the corresponding grossed-up result.

  3. Add both earnings to the earnings element group on the Element Groups − Members page in the core application.

    Note: Global Payroll for the UK provides you with element group GBR EG ALLPAY, which contains both of these earnings. If you create your own earnings in Steps 1 and 2, you must add them to an element group.

  4. Set up the necessary formulas to calculate the grossed-up amount on the Formula Name Page in the core application.

    PeopleSoft delivers the following formulas that calculate the grossed-up amount:

    • GU FM 2

      This formula determines the net amount to be grossed-up and provides the process with a first resolution for the gross amount.

    • GU FM 3

      This formula is responsible for the iterative processing that calculates the actual gross amount.

    • GU FM 4

      This formula populates the element GU VR RESULT, which displays the results of the net-to-gross process.

  5. Set up a net-to-gross section, where all earnings are processed, on the Definition page in the core application.

    Global Payroll for the UK delivers the section GBR SE NTG, which includes the net-to-gross earnings, the grossed-up earnings, and the formulas that the system processes.

    Section GBR SE NTG references both the net payment earnings and the grossed-up result earnings, as well as the GU FM 2, GU FM 3, and GU FM 4 formulas.

    GBR SE NTG is defined as a subprocess, with a maximum number of 15 iterations. If you are defining your own net-to-gross process, you can amend the number of iterations accordingly.

    Warning! Do not change the delivered formulas and/or sections. Doing so may impact statutory calculations. If you create your own net-to-gross process, discuss this with your PeopleSoft consultant.

  6. Add the net-to-gross section to the process list component on the Definition page in the core application.

    Global Payroll for the UK is delivered with section GBR SE NTG in the GBR PR PAYROLL process list. The position of the section in the process list is important. You must place the process list prior to the tax and National Insurance processing so that the grossed-up amount is derived before tax and National Insurance are calculated.

The following table lists the earnings delivered for the gross-up functionality of tax and National Insurance.

Earning

Description

GU ER NET NI

Calculates the gross up value of NI on the net earnings. This earning is provided as a positive input for the net value.

GU ER PRN GU

Holds the primary gross up value of the GU ER NET NI earning.

When the primary gross up is calculated, the secondary gross up value is calculated based on tax code and NI category of employee.

GU ER SCN GU

Calculates the gross up value of tax and NI on the net element gross up value of NI based on the primary gross up results. The secondary gross of tax and NI is calculated based on the tax rate and NI category of the employee.

GU ER NET TX

Calculates the gross up value of tax on the net earnings. This earning is provided as a positive input for the net value.

GU ER PRT GU

Holds the primary gross up value for the GU ER NET TX earning. When the primary gross up is calculated, the secondary gross up is calculated based on tax code and NI category of employee.

GU ER SCT GU

Calculates the gross up value of tax and NI on the net element gross up of tax based on the primary gross up results. The secondary gross of tax and NI is calculated based on the tax rate and NI category of the employee.