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. Form 1099R Taxable Distribution Form 1099R Capital Gain Form 1099R Employee Contributions or Insurance Premiums Form 1099R Net Unrealized Appreciation Form 1099R Other Form 1099R Total Employee Contributions Form 1099R In Plan Roth Rollover
Balance feeds	When defining and managing balances, you must establish feeds for any balance you want to pass on the file.
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.
Non-W-2 balances	You can pass these non-W-2 balances on the file. Employer-Subsidized Meals Moving Expenses Paid to Third-Parties Qualified Transportation Sick Pay Wages For Philadelphia, Pennsylvania reporting, pass these balances. City Uncollected Tax Tip Wages Resident City Uncollected Tax Tip Wages Nonresident Note: Populate these city-level balances with the total uncollected tax wages for tipped employees for which no city tax was withheld. If you have employees meeting this condition, you must perform balance adjustments on these balances.For further info, see the Oracle Cloud Human Capital Management for the United States: Balance Adjustments (1600728.1) on My Oracle Support. For Louisville, Kentucky reporting, pass these balances. City Uncollected Tax Tip Withheld Resident City Uncollected Tax Tip Withheld Nonresident Note: Populate these city-level balances with the total uncollected tax wages for tipped employees for which no city tax was withheld. If you have employees meeting this condition, you must perform balance adjustments on these balances.For further info, see the Oracle Cloud Human Capital Management for the United States: Balance Adjustments (1600728.1) on My Oracle Support.
State Worked Hours balance	Passed on the quarterly extract for SUI reporting. For quarterly files run before Q1 2023, the Quarterly Tax Filing extract: Checks if the SUI Employer Reduced Subject Wages are greater than $0 for the quarter and given state. Checks if the State Worked Hours balance has a value greater than 0. If not, it derives the hours using the run result method. For quarterly files run Q1 2023 and later, the Quarterly Tax Filing extract: Checks if the SUI Employer Reduced Subject Wages are greater than $0 for the quarter and given state. Derives the hours from the State Worked Hours balance. 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:
Workers Compensation Withheld	For New Mexico, either define feeds for this balance 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: The Workers Compensation Withheld balance has a nonzero value for the "Relationship Tax Unit,State Quarter to Date" dimension. Note: Oracle HCM Cloud doesn't support Workers' Compensation taxes. The employee is active as of the last day of the quarter you're reporting.
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. W2 Social Security Tips W2 Uncollected Medicare Group Term Life W2 Uncollected Medicare Tips W2 Uncollected Social Security Group Term Life W2 Uncollected Social Security Tax Tips
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. W2 Territory 401k W2 Territory Charitable Contributions W2 Territory Government Retirement Fund W2 Territory Government Employee Savings Plan 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.