Define the State and Local Tax Jurisdiction Through Fast Formula
For this example, you're defining a new state employer liability for the New Jersey Employer Payroll Expense tax. Because you never anticipate using this configuration for any other state, you're setting the state through fast formulas.
You're assuming a New Jersey Employer Payroll Expense tax of 1% of gross earnings for the calculation, with payroll results configured for periodic and quarterly archival and reporting.
These are the high-level steps.
-
Define and configure the elements.
-
Configure the fast formulas.
-
Configure the balances.
-
Create element entries.
-
Validate tax calculations.
-
Extract the payroll data.
Define and Configure the Elements
To define the New Jersey Employer Payroll Expense tax, perform the following element operations.
-
Define the state tax base element, New Jersey Payroll Tax.
-
Configure the element's input values.
-
Configure the state tax results element, New Jersey Payroll Tax Results.
Defining the State Tax Element
To define the base element:
-
Start the Elements task.
-
Create an Employer Taxes element with the following settings.
Field name
What you enter
Legislative Data Group
Your US legislative data group
Name
New Jersey Payroll Tax
Primary Classification
Employer Taxes
Secondary Classification
Leave blank
Employment Level
Payroll relationship level
Calculation Rule
Percentage
-
Specify the other required fields as needed, and submit.
Configuring the Element Input Values
After you define the element, you define a State input value that identifies New Jersey as the jurisdiction.
-
On the Element Summary page, click Input Values.
-
Click Actions and then Create Input Values.
-
In Create Input Value, specify these values.
Field name
What you enter
Name
State
Displayed
Selected
Allow User Entry
Selected
Create a Database Item
Selected
Unit of Measure
Integer
Display Sequence
1
-
In Default Entry Values and Validation, set this value.
Field
What you enter
Reference
State
-
In Default Value, set these values.
Field name
What you enter
Default
NJ
Apply Default at Run Time
Don't select
-
Click Save.
-
Edit the Percentage input value to set the default to 1.
-
Review all other input values.
Make sure none of them use a display sequence of 1. If they do, renumber them appropriately.
Don't create element eligibility until after you have configured the input values.
-
Create the element eligibility.
Configuring the State Tax Results Element
When you defined the New Jersey Payroll Tax element, the template automatically created a results element, New Jersey Payroll Tax Results. Make these configuration changes to the results element.
-
Using the Elements task, search for and open for editing the New Jersey Payroll Tax Results element.
-
Set the priority to 6255.
This ensures the payroll process:
-
Runs the results element after the base element
-
Makes the results element available for selection when setting the formula results (see the next section)
-
-
Create a State input value with the same settings as the base element.
-
Review all other input values.
Make sure none of them use a display sequence of 1. If they do, renumber them appropriately.
-
Create a Gross Earnings input value with the following values.
Field name
What you enter
Displayed
Selected
Allow User Entry
Selected
Create Database Item
Selected
Unit of Measure
Money
Configure the Fast Formulas
When you define the New Jersey Payroll Tax base element, the template creates these fast formulas.
-
New Jersey Payroll Tax_CHG_DEDN
-
New Jersey Payroll Tax_CHG_DEDN_CALCULATOR
Edit these fast formulas to default the jurisdiction for the state of New Jersey.
-
Use the Fast Formula task to modify the New Jersey Payroll Tax_CHG_DEDN formula.
Edit this formula to make these changes.
-
Locate the
INPUTS are Amount
section, and add a,State(number)
entry after it. -
Locate the
call_formula( 'GLB_DEDN_CHG_BASE'
statement, and insert this immediately before it.ee_id2 = ee_id ||'State' IF (WSA_EXISTS(ee_id2,'TEXT_TEXT')) THEN ( ee_array = WSA_GET(ee_id2, EMPTY_TEXT_TEXT) ) ELSE ( dummy = PAY_INTERNAL_LOG_WRITE('[NEW_JERSEY_PAYROLL_TAX_CHG_DEDN] - ARRAY NOT FOUND : ' || ee_id2)) IF (State WAS NOT DEFAULTED) THEN ( ee_array['State'] = to_char(State) dummy = PAY_INTERNAL_LOG_WRITE('[NEW_JERSEY_PAYROLL_TAX_CHG_DEDN] - 999 : ' || to_char(State)) wsa_set(ee_id2, ee_array))
-
Locate the
IF error_mesg
section, and modify it to include a state reference:( Return error_mesg, state )
-
Submit and compile the formula.
-
-
Modify the New Jersey Payroll Tax_CHG_DEDN_CALCULATOR formula.
Edit this formula to make these changes.
-
At the end of the declaration section, add this line.
Default for NEW_JERSEY_PAYROLL_TAX_STATE_REL_ENTRY_VALUE is 31
-
After the
INPUTS
section, add this line.State = NEW_JERSEY_PAYROLL_TAX_STATE_REL_ENTRY_VALUE
-
Search for the
call_formula( 'GLB_DEDN_CHG_CALC'
section. Locate the following lines at the end of that section.stop_entry )
After these lines, insert this.
ee_id2 = ee_id||'State' IF (WSA_EXISTS(ee_id2,'TEXT_TEXT')) THEN ( ee_array = WSA_GET(ee_id2, EMPTY_TEXT_TEXT) dummy = PAY_INTERNAL_LOG_WRITE('[NEW_JERSEY_PAYROLL_TAX_CHG_DEDN_CALCULATOR] 999 = '|| ee_id2) IF ee_array.EXISTS('State') THEN ( state = to_number(ee_array['State'] ) dummy = PAY_INTERNAL_LOG_WRITE('[NEW_JERSEY_PAYROLL_TAX_CHG_DEDN_CALCULATOR] = '|| to_char(state)) ) )
-
Search for the
RETURN
statements that includededn_amt
, and add this at the end of each.eligible_compensation, state
-
Submit, and compile the formula.
-
-
Return to the Elements task.
-
Make these changes to the New Jersey Payroll Tax Calculator element.
-
Select Status Processing Rules, and select the current rule.
-
Create a formula result rule to pass ELIGIBLE_COMPENSATION as an indirect result to the Gross Earnings input value of the Results element.
-
Create a formula result rule to pass STATE as an indirect result to the State input value of the Results element.
-
Configure the Balances
After you configure the fast formulas, you define the balances necessary for this tax.
-
Define the state tax balances.
-
Implement the balances at the enterprise level.
Defining State Tax Balances
Define and configure the required balances.
-
Use the Balance Definitions task to define a Reduced Subject Wages balance.
Field name
What you enter
Name
New Jersey Payroll Tax Reduced Subject Wages
Balance Category
Employer Tax Wages
Unit of Measure
Money
Balance Dimensions
Because this is a state-level tax, search for and add the following.
-
Relationship Tax Unit,State Run
-
Relationship Tax Unit,State Year to Date
-
Relationship Tax Unit, Area1 Payslip
-
Relationship Tax Unit,State Quarter to Date
Balance Feeds by Element
New Jersey Payroll Tax Results
Input Value
Gross Earnings
-
-
Define a Taxable Wages balance.
Field name
What you enter
Name
New Jersey Payroll Tax Taxable Wages
Balance Category
Employer Tax Wages
Unit of Measure
Money
Balance Dimensions
Because this is a state-level tax, search for and add the following.
-
Relationship Tax Unit,State Run
-
Relationship Tax Unit,State Year to Date
-
Relationship Tax Unit, Area1 Payslip
-
Relationship Tax Unit,State Quarter to Date
Balance Feeds by Element
New Jersey Payroll Tax Results
Input Value
Gross Earnings
-
-
Define a Gross Wages balance.
Field name
What you enter
Name
New Jersey Payroll Tax Gross Wages
Balance Category
Employer Tax Wages
Unit of Measure
Money
Balance Dimensions
Because this is a state-level tax, search for and add the following.
-
Relationship Tax Unit,State Run
-
Relationship Tax Unit,State Year to Date
-
Relationship Tax Unit, Area1 Payslip
-
Relationship Tax Unit,State Quarter to Date
Balance Feeds by Element
New Jersey Payroll Tax Results
Input Value
Gross Earnings
-
-
Configure the predefined New Jersey Payroll Tax Eligible Compensation balance.
Make these changes.
-
Add these balance classifications as feeds.
-
Regular
-
Supplemental Earnings
-
Imputed Earnings
-
-
Add these balance dimensions.
-
Relationship Tax Unit,State Run
-
Relationship Tax Unit,State Year to Date
-
Relationship Tax Unit, Area1 Payslip
-
Relationship Tax Unit,State Quarter to Date
-
-
-
Add the same balance dimensions to the predefined New Jersey Payroll Tax balance.
Implementing the Balances at the Enterprise Level
Perform these steps to implement the balances you defined in the previous section. This makes them available for payroll archival and reporting.
-
Start the Manage Enterprise HCM Information task.
-
Add a row to the US Balance Definition table, and enter these values.
Field name
What you enter
Legislative Data Group
Your US legislative data group
Archive Level
State
Category
Reduced Subject Wages
Balance Name
New Jersey Payroll Tax Reduced Subject Wages
Tax Code
PAYTAX_ER
Type
Balance
Report Usage
Periodic and Quarterly
-
Add a row to the US Balance Definition table, and enter these values.
Field
What you enter
Legislative Data Group
Your US legislative data group
Archive Level
State
Category
Taxable Wages
Balance Name
New Jersey Payroll Tax Taxable Wages
Tax Code
PAYTAX_ER
Type
Balance
Report Usage
Periodic and Quarterly
-
Add a row to the US Balance Definition table, and enter these values.
Field
What you enter
Legislative Data Group
Your US legislative data group
Archive Level
State
Category
Withheld or Liability
Balance Name
New Jersey Payroll Tax
Tax Code
PAYTAX_ER
Type
Balance
Report Usage
Periodic and Quarterly
-
Add a row to the US Balance Definition table, and enter these values.
Field
What you enter
Legislative Data Group
Your US legislative data group
Archive Level
State
Category
Total Wage or Gross
Balance Name
New Jersey Payroll Tax Gross Wages
Tax Code
PAYTAX_ER
Type
Balance
Report Usage
Periodic and Quarterly
Note: As the tax you're defining is for New Jersey, the tax filing processes automatically prefixes the tax code with NJ. For example, NJPAYTAX_ER.
Create Element Entries
After you configure the required balances, use the Element Entries task to create element entries for each employee subject to this New Jersey tax.
-
Start the Element Entries task for the selected employee.
-
Select the effective date for your new entry.
-
Click Create.
-
Select the New Jersey Payroll Tax element.
-
Click Continue and then Submit.
Validate Tax Calculations
Use these steps to validate your new New Jersey state tax.
-
Run your payroll.
-
Upon completion, check the Statement of Earnings run results.
For further info, see How to View the Statement of Earnings for the US in the Help Center.
-
Verify the tax was calculated correctly and the State and Gross Earnings input values were correctly populated.
Extract the Payroll Data
For complete info about third-party tax reporting, refer to the US Third-Party Tax Filing Interface technical brief.
To extract the state tax data in preparation for submitting to a third-party tax filing agent:
-
Run prepayments.
For further info, see Calculate and Validate Payroll Payment Distributions for the US in the Help Center.
-
Run the periodic archive.
For further info, see Archive Periodic Payroll Results for the US in the Help Center.
-
Run the Third-Party Periodic Tax Filing Extract.
For further info, see Oracle Cloud Human Capital Management for United States: Third-Party Tax Filing Interface (1594079.1) on My Oracle Support.
-
Check the output file.
Verify the following.
-
Correct TAX CODE appears in the file
-
All four balances you defined were passed on one record for the NJPAYTAX_ER tax code
-
-
Run the Third-Party Quarterly Tax Filing Extract process to verify your state tax data.