Required Balance Info for Third-Party Tax Reporting for the US
When setting up balances, consider these requirements for third-party reporting.
Balance issue |
What you need to know |
---|---|
1099-R balances |
You have to feed some balances if you want to include their info on the quarterly file for the 1099-R form.
|
Balance feeds |
When defining and managing balances, you must establish feeds for any balance you want to pass on the file. |
City balances for tipped employees |
For Philadelphia, Pennsylvania reporting, pass these balances.
For Louisville, Kentucky reporting, pass these balances.
|
Dismissal Payments balance |
For elements using the Dismissal Payments secondary classification, the extract uses the Dismissal Payments balance to pass severance payments on the file. Any elements using this secondary classification automatically feed this balance. ADP subtracts this amount from the employee's state unemployment insurance subject wages for New York and Michigan. |
New York state balances for government employees |
For New York state reporting, pass these balances.
Note:
Populate these state-level balances with the appropriate amounts from a flexible benefits program. If you have government employees meeting this condition, you must perform balance adjustments on these balances. For further info on balance adjustments, see the Oracle Human Capital Management for the US: Balance Adjustments (1600728.1) on My Oracle Support. |
Non-W-2 balances |
You can pass these non-W-2 balances on the file.
For Philadelphia, Pennsylvania reporting, pass these balances.
For Louisville, Kentucky reporting, pass these balances.
|
State Worked Hours balance |
Passed on the quarterly extract for SUI reporting. For quarterly files run before Q1 2023, the Quarterly Tax Filing extract:
For quarterly files run Q1 2023 and later, the Quarterly Tax Filing extract:
For further info on the necessary configurations, see the Hours Worked for State Unemployment Insurance Reporting technical brief (2729519.1) on My Oracle Support. Note:
South Carolina requires the reported quarterly value to be less than 1000 hours. The quarterly extract doesn't enforce this. Use the Employee Active Payroll Balance Report to verify this balance for your South Carolina employees and adjust as needed. For further info, see Employee Active Payroll Balance Report for the US in the Help Center. |
State Worked Weeks balance |
By default, the quarterly extract calculates weeks worked based on the hours worked divided by 40 and rounded. However, you can override this value by feeding the State Worked Weeks balance. If this balance has a nonzero value, the quarterly tax filing extract passes it on the quarterly file for the appropriate state. The extract caps the weeks worked at 13. If the hours worked is less than 40, it defaults the weeks worked to 1. Note:
When defining an Information element to feed this balance:
|
W-2 balances |
For a list of W-2 balances required for end-of-year reporting, see Form W-2 Box Info in the Help Center. |
W-2 balances for quarterly reporting |
Define feeds for the following balances before running your first quarterly tax extract.
|
W-2 balances for Puerto Rico |
For a list of W-2 balances required for end-of-year reporting for Puerto Rico, see Form W-2PR Box Info in the Help Center. The following Puerto Rico balances have special considerations.
For the user-defined results elements feeding these balances, set the State input value to 72. This identifies them as belonging to Puerto Rico. Note:
The quarterly tax filing extract performs a balance call with a State context of Puerto Rico. If the call returns no value, the extract then makes a second balance call with no State context. It passes this value on the file. If you're already processing user-defined elements in payroll without the State context, this ensures the file passes the correct balance value. |
Washington Family Leave and Long Term Care Hours QTD and YTD balances |
The Washington Family Leave and Washington Long Term Care Hours balances are populated from the same value as the Washington State Worked Hours balance. |
Workers' Compensation balances for New Mexico quarterly fees |
Before running your first quarterly tax extract, either define feeds for these balances or perform a quarterly balance adjustment.
The quarterly tax extract sets Coverage Indicator to Y on the W records for the NM SIT and NM SUI balances when:
Otherwise, it sets the indicator to N. |