Required Calculation Card Info for Third-Party Tax Reporting for the US
For each employee or retiree, make sure you have correctly configured their calculation cards. There are some special values that might be required for accurate reporting.
Reporting Information Card
For employees, if you enter values for the appropriate fields in the Reporting Information calculation component, they're passed on the quarterly tax file. Use the Retiree Reporting Information calculation component for retirees. These components are part of the Federal component group.
For each state or territory where the person is employed, create a Regional calculation component with the proper regional association. Set the appropriate fields for these states as noted in the following table.
-
For State Reporting Information calculation components, enter the fields under Calculation Component Details.
-
For Regional Tax Information calculation components, enter the fields under Enterable Calculation Values on Calculation Cards.
For further info, see Reporting Information Calculation Card for the US in the Help Center.
Component group |
Calculation component |
Calculation component detail |
Field name |
What this does |
---|---|---|---|---|
Federal |
Reporting Information |
Third-Party Interfaces |
ADP Special Processing Required |
Indicates whether the employee's W-2 is excluded from main population printing. Note:
The quarterly extract passes this in a separate field than the employee print preferences. |
ADP Special Sort Code |
Provides additional data for sort options G and E in the ADP client maintenance application. For further info, see your ADP product documentation. Not used by MasterTax. |
|||
Reporting Information |
Corporate Officer |
Identifies employees who are corporate officers of the employer. As multiple states require this, set it at the federal level. Note:
Most states require Corporate Officer or Not a Corporate Officer; however, Washington DC allows others. If you select a value other than Corporate Officer or Not a Corporate Officer for any state other than Washington DC, ADP interprets the value as N. |
||
Eligible for Retirement Plan |
An employee is automatically marked as eligible for the retirement plan on Box 13 of their W-2 when any of these balances has a value greater than 0.
Use this field to manually identify employee eligibility if they don't contribute to any plan. For further info, see Configure Calculation Card Configuration for Year-End Tax Forms in the Help Center. |
|||
Family Member with Majority Interest |
Designates if the employee or a family member owns majority interest of this business. |
|||
Probationary Code |
Identifies employees hired on a trial basis. |
|||
Retiree Reporting Information |
Reporting Information |
Account Number |
Form 1099-R account, policy, or other identifying number. Required when you have multiple accounts for a recipient that has multiple 1099-Rs. This populates field code H1 of the C record and the Account Number box on the 1099-R. |
|
Annuity Percentage |
Use this field when an annuity contract is part of a multiple recipient lump-sum distribution. Enter the percentage of the total annuity represented. The annuity percentage is field code YL of the C record and is fed to the % next to Box 8 on the 1099-R. Use whole numbers only. For example, enter 5% as |
|||
Distribution date for section 6050Y death benefits |
Use this date for distribution codes C and CD. This date indicates when the death benefit was paid according to section 6050Y. This date is passed as an E record and is fed to the Date of Payment box 13 on the 1099-R. |
|||
FATCA Filing Requirements |
This field is for your info tracking only. The quarterly tax file doesn't include it. |
|||
First Year of Designated Roth Contribution |
Identifies the year when this person made a first-year designated Roth contribution. Use four digits for the year, such as This value populates field code R1 of the C record and is fed to Box 11 on the 1099-R. |
|||
Taxable Amount not Determined |
Use this field when the taxable amount of the payments can't be reasonably obtained. If you select Yes, then a Y value is fed to field code YD of the C record. It enters an X in Box 2b of the 1099-R, Taxable amount not determined. |
|||
Total Distribution |
Used to indicate if the payment was a total distribution. For further info, see How the Quarterly Tax-Filing Extract for Retirees Identifies Total Distributions in the Help Center. |
|||
Total Distribution Percentage |
For use if a total distribution is made to more than one recipient. Enter the distribution percentage you're allocating for this recipient. Use whole numbers only. For example, enter 5% as The total distribution percentage is field code YM of the C record and is fed to box 9a on the 1099-R. |
|||
Traditional, SEP, or SIMPLE IRA |
Identifies the person is receiving a traditional IRA, SEP, or SIMPLE distribution. If you select Yes, it enters an X in the IRA/SEP/SIMPLE box on the 1099-R. |
|||
Regional |
State Reporting Information |
Alaska Reporting Information |
Geographic Code |
Two-digit code that identifies the employee's primary place of work. |
Occupational Code |
Identifies the employee's occupation category. The value you enter here overrides the value you specified on the job. Note:
For further info, see the Alaska Department of Labor and Workforce Development website. Search for the Alaska Occupation and Geographic Coding Resources page. |
|||
California Reporting Information |
Wage Plan Code |
Used to override the value specified at the payroll statutory unit (PSU) and tax reporting unit (TRU) levels. For further info, see the California Employment Development Department website. Search for the Electronic Filing Guide for the Quarterly Wage and Withholding Program. Choices include:
|
||
Colorado Reporting Information |
Seasonal Worker |
Identifies the person as a seasonal worker. |
||
Indiana Reporting Information |
Seasonal Worker |
Identifies the person as a seasonal worker. |
||
Maine Reporting Information |
Seasonal Worker |
Identifies the person as a seasonal worker. |
||
North Carolina Reporting Information |
Seasonal Worker |
Identifies the person as a seasonal worker. |
||
Oregon Reporting Information |
Replacement Worker |
Identifies the person as a replacement worker, hired to cover for an employee out on Paid Family Medical Leave. Update or end-date this value once the employee returns to work. |
||
Seasonal Worker |
Identifies the person as a seasonal worker. |
|||
Vermont Reporting Information |
Health Care Status |
Designates if the employee is considered covered or not covered. Used in the calculation of Vermont health care deduction reporting. |
||
Regional Tax Information |
New York |
Part Year Resident |
Designates if the employee is a part-year resident of New York City in the calculation value. If you select Yes, the quarterly extract passes the city-resident wages. Otherwise, it passes the FIT wages. |
|
Puerto Rico |
W-2PR Control Number |
When populated, the third-party quarterly tax extract passes this field on the W record for Puerto Rico state tax codes in positions 299-314. ADP ignores this data, but MasterTax accepts it. |
||
W-2cPR Control Number |
||||
Qualified Physician Under Act 14-2017 |
Designates if the employee had wages for services rendered by a qualified physician who has a valid decree according to Act 14-2017. |
|||
Domestic Services |
Designates if the employee had wages for domestic services in a private home, local college club, or local chapter of a college fraternity or sorority. |
|||
Agricultural Work |
Designates if the employee had wages for services rendered in agricultural labor. |
|||
Minister of a Church or Member of a Religious Order |
Designates if the employee had wages for services rendered by a minister of a church or by a member of a religious order. |
|||
Health Professionals Under CC 20-01 |
Designates if the employee had wages for services by health professionals according to CC 20-01. |
|||
Others |
Designates the type of other wages the employee received. This can be a value from 1 to 9. For info on the meaning of these values, refer to the W-2PR instructions provided by the Hacienda. These values can change yearly. |
|||
Any Other Service Required by the Department Through Regulations |
This value isn't passed on the third-party quarterly tax extract output
file. It is included in the XML file as
Note:
ADP doesn't support this field. |
|||
Direct Employment |
Designates if the payments are for services by a direct employee. |
|||
Direct Employment Hours Worked |
Total hours worked by the direct employee. Note:
The third-party quarterly tax extract passes this data with an implied decimal. |
|||
Direct Employment EIN |
If your business is subject to a tax exemption decree, and you have leased or been assigned employees to work in your tax-exempt business lines, provide your EIN here. |
|||
Washington |
Reason for SUI Wages with Zero Hours |
Select a reason code for employees with wages and zero hours. Because the current reason code might not apply to future quarters, end date this value at the end of the quarter. Note:
ADP issues a warning if it detects employees with wages and no hours and no reason code. |
Tax Withholding Card
If you enter values in the following fields on the employee tax card, they're included in the appropriate extract.
Associations
Section |
Federal Income Tax field name |
What it does |
---|---|---|
Federal |
Primary Work Address |
The extract derives the work location's county and ZIP Code from this field. For each state context processed for an employee, the county and ZIP Code from the last primary work address in that state is passed. This is required for:
However, the extract passes the work location county and ZIP Code for all states. |
Statutory Employee |
Identifies an independent contractor as an employee by statute. |
Withholding Details
Calculation component |
Field name |
---|---|
Federal |
Filing Status |
Federal |
Allowances Note:
As of 2020, Form W-4 no longer uses this value. However, the extract continues to pass this data until the employee updates their W-4. |
Regional |
Allowances Note:
For states that follow the federal W-4, as of 2020, the form no longer uses this value. However, the extract continues to pass this data until the employee updates their W-4. |
Regional |
Exempt from State Unemployment |
Regional |
Exempt from State Disability |
Regional |
Exempt from Long Term Care Note:
For the extract to include a WALTC tax code record, one or more of these conditions must be true.
|
Residency Certificate |
Resident PSD Code Identifies the resident political subdivision (PSD) code for Pennsylvania Act 32 jurisdictions. |
Tax Withholding for Pension and Annuity Payments Card
If you enter values in the following fields on the retiree tax card, they're included in the appropriate extract.
Withholding Details Section
Calculation component |
Field name |
---|---|
Federal |
Filing Status |
Regional |
Exempt from State Unemployment |
Regional |
Exempt from State Disability |
Organization Calculation Cards
The quarterly tax extract includes Massachusetts Paid Family Insurance (FLI) and Medical Leave Insurance (MLI) employee contribution percentages. If you override these default percentages, you must enter them as whole numbers, and their sum must equal 100%.
For further info, see Massachusetts Paid Family and Medical Leave in the Help Center.