Create a Net-to-Gross Earnings Element
This example demonstrates how to create a net-to-gross (gross-up) earnings element when an organization wants to pay a person a specific net amount on a bonus.
Before you create your earnings element, you may want to determine the following:
Decisions to Consider |
In This Example |
---|---|
What is the primary classification of this earning? |
Irregular Earnings |
Is the element recurring or nonrecurring? |
Nonrecurring |
Who is the bonus recipient? |
Linda Swift |
How much is the bonus? |
1000 GBP |
What is the allowed difference between the specified bonus and the actual amount paid? |
.05 GBP |
What is the calculation rule? |
Flat amount |
Creating the Earnings Element
Perform the following steps to create the element:
-
In the Payroll work area, click Elements.
-
Click Create and then select the values shown in the table in the Create Element window.
Field
Value
Legislative Data Group
UK LDG
Primary Classification
Irregular Earnings
Secondary Classification
Bonus
Category
Standard
-
Click Continue.
-
On the Create Element: Basic Information page select the values shown in the table.
Field or Question
Value
Name
Bonus
Reporting Name
Bonus
Effective Date
06-April-2017
Should every person eligible for the element automatically receive it?
No
What is the earliest entry date for this element?
First Standard Earning Date
What is the latest entry date for the element?
Last Standard Earning Date
At which employment level should this element be attached?
Assignment Level
Does the element recur each payroll period, or does it require explicit entry?
Nonrecurring
Process the element only once in each payroll period?
Yes
Note: All gross-up earnings elements must be processed and paid separately from other elements.Can a person have more than one entry of this element in a payroll period?
Yes
Process and pay element separately or with other earnings elements?
Process separately and pay separately
Tax this earning across multiple pay periods?
No
Prorate this earning across all periods during which it was earned, and consider it for FLSA calculations, such as for commissions, bonuses, incentives, and other nondiscretionary earnings?
No
-
Click Next.
-
On the Create Element: Additional Details page select the values shown in the table.
Field or Question
Value
What is the calculation rule?
Flat Amount
Note: The default value is Flat Amount. Do not change this value. All gross-up earnings must have a calculation rule of Flat Amount.What is the default periodicity of this element?
Periodically
Periodicity Conversion Rule
Periodic Work Schedule Rate Annualized
How do you want the work units to be reported?
None
Is this element subject to retroactive changes?
No
Use this element to calculate a gross amount from a specified net amount?
Yes
Should this element be included in the earnings calculation of the FLSA overtime base rate?
No
Should this element be included in the hours calculation of the FLSA overtime base rate?
No
-
Click Next.
-
Click Submit.
-
In the Element Overview pane, select and review each input value, as shown in the table.
Input Value
Description
Pay Value
The gross pay value to be processed in the payroll run, entered by the iterative formula when it completes gross-up calculations.
Net
The user-entered flat amount, which provides the iterative formula with the desired net pay.
Low Gross
Used by the iterative formula to hold the lower gross pay guess, which feeds into the next iteration of the formula.
High Gross
Used by the iterative formula to hold the higher gross pay guess, which feeds into the next iteration of the formula.
Remainder
The amount by which the additional pay to be paid by the employer (gross minus desired net) differs from the total of the balances that are eligible for net-to-gross processing. This amount is returned by the iterative formula.
To Within
The amount by which actual net can differ from desired net after normal processing. This amount must not be zero but can be a nominal amount such as 0.01.
Additional Amount
The amount to add to the desired net to calculate gross pay. This amount is returned by the iterative formula.
Note: Not all input values are visible by default.
Creating Eligibility Rules
Perform the following steps to create eligibility rules:
-
In the Element Overview pane, click Element Eligibility.
-
Select Create Element Eligibility from the Actions menu.
-
In the Element Eligibility Name field, enter Bonus.
-
Click Save.
Reviewing Iterative Processing Order
Perform the following steps to review the iterative processing order:
-
In the Element Overview pane, click Bonus.
-
In the Advanced Rules section, review the iterative order.
Note: The default value is 1000. If you have more than one iterative element that may be processed in the same payroll flow, it's important to adjust the iterative order to indicate which should be processed first. Iterative order must be in the reverse sequence of the processing priority numbers. The element with the lowest iterative priority number is reduced first.
Including Balances in the Net-to-Gross Processing
Perform the following steps to include balances:
-
In the Element Overview pane, click Balance Feeds.
-
Review the balances to which the bonus contributes.
-
In the Element Overview pane, click Gross Balance Exclusions.
-
Add any balances that have been set to exclude by default if you want to include it on this specific earnings.
-
Click Submit.
Creating an Element Entry
In this example, create the element entry for the bonus for Linda Swift.
-
In the Payroll work area, select Element Entries.
-
In the Name field, enter Swift, Linda.
-
In the Legislative Data Group field, select UK LDG.
-
In the Effective As-of Date field, enter 06-April-2017.
-
Click Search.
-
In the Search Results, select Linda Swift.
-
Click Create.
-
In the Effective Date field, enter 06-April-2017.
-
In the Element Name field, select Bonus.
-
In the Assignment field, select E1026.
-
Click Continue.
-
In the Net Value field, enter 1000.00.
Note: If you want to pay a net-to-gross element, without the net-to-gross processing, add the flat amount in the Amount field. This amount will be the gross paid. It will be reduced by the applicable deductions. -
In the To Within field, enter .05.
-
Click Submit.