The W2 Report module creates a report used for reporting W2 wage information at calendar year end.
...
Option for Districts to submit own W2 Submission Files
- Please click here for further instructions and setup.
Districts have the option to create and submit their W2 Submission file to:
...
For More information on CCA setup, please click here.
Example of CCA W2 Submission File Summary
...
For more information on RITA setup, please click here.
For employees that worked or lived in at least one RITA municipality, employers are required to report for each employee every municipality for which tax was withheld or should have been withheld.
...
Employee's will only show 'City Wages' if the Payroll Item' Deduction Type' is marked as 'Employment'. The employees that are marked as residence on their city Payroll Items, will have the taxable gross reported as 0.00 in the submission file and the summary report but will still count in the employee's processed. The W2 RITA Submission City Summary report only counts employee who have values in Tax Withheld, Applicable Gross, and Total Gross that are greater than zero.
The City Wages (taxable gross) likely will not match the w2 report summary because RITA only includes the taxable gross in the submission file if the city 'Deduction Type' is not RESIDENCE (this value is on each individual employee's city tax item). If the 'Deduction Type' is RESIDENCE, the taxable gross in the submission file and the W2 RITA Submission City Summary report, will be 0.00. Therefore, the City Wages (taxable gross) on the W2 RITA Submission File City Summary report is usually smaller than the W2 Report summary for the city.
...
Example of Ohio W2 Submission File Summary Report
The Wages Other Comp value is the taxable gross for the federal tax item. This value can include federal applicable gross adjustments, life insurance, taxable benefits, fringe benefits, and vehicle lease adjustments. It also includes board pickup amount adjustments for Medicare or social security. From payroll history, it would include the federal applicable gross, Medicare or social security taxable employer pickup, and dependent care amounts over $10,500.
The Wages will show on the W2 Ohio Submission file RT lines, in positions 10-24 and Federal Income Tax Withheld in positions 25-39.
Indiana - W2MAST_IN.txt
Field Definitions:
...
Error Contact email address must be entered on W2 configuration.
Error Contact name must be entered on W2 configuration.
Error Contact phone number must be entered on W2 configuration.
Error Invalid SSN, verify SSN before printing W2's s.
Error Employee last name should not be null or empty.
Error Employee first name should not be null or empty.
Error Employee must have either a STANDARD or FOREIGN address.
Error Employee must have a city.
- Check employee's City on their Employee record
Error Employee must have a country code.
- If the Foreign Address field in Employee screen is checked, a Country code must be entered
- If the Foreign Address field in Employee screen is checked, a Country code must be entered
Error Employee must have a postal code.
- If the Foreign Address field in Employee screen is checked, a Postal Code must be entered.
- If the Foreign Address field in Employee screen is checked, a Postal Code must be entered.
Error Gross for this payroll item (code: XXX) exceeds the maximum for this reporting year.
- For each gross amount reported to the IRS/SSA, there is a maximum value that can be reported. The current maximum that the submission file will accept is 9999999.99.
If this message is encountered, verify the gross amount for the employee.
- For each gross amount reported to the IRS/SSA, there is a maximum value that can be reported. The current maximum that the submission file will accept is 9999999.99.
Error Medicare amount does not equal 1.45% of Medicare Gross (If Medicare withheld is (+-) $0.30 off).
Error FICA/OASDI amount does not equal 6.2% of FICA/OASDI Gross.
- These two messages are related. W2 Processing calculates the amount of Medicare and FICA tax by multiplying the taxable gross by the correct withholding percentage. If the calculated tax amount differs from the tax amount found on the 692/693 records by more than $.30, the messages are issued.
These These errors will most likely cause the IRS/SSA to reject the submission file therefore it is necessary to research and resolve the problem.
- These two messages are related. W2 Processing calculates the amount of Medicare and FICA tax by multiplying the taxable gross by the correct withholding percentage. If the calculated tax amount differs from the tax amount found on the 692/693 records by more than $.30, the messages are issued.
Error Submitter EIN must be entered on W2 configuration.
Error Submitter delivery address address must be entered on W2 configuration.
Error Submitter location address must be entered on W2 configuration.
Error Submitter city must be entered on W2 configuration.
Error Submitter state must be entered on W2 configuration.
Error Submitter zip code must be entered on W2 configuration.
Error This employee has Medicare tax without any Medicare wages.
- This message cannot be ignored under any circumstances. Upon receipt of the submission file from the ITC, the IRS/SSA calculates the expected tax amount and compares it to the amount reported on the file. If these figures are off by more than a few cents, the file is rejected.
Run the Audit Trail report to determine if manual changes on the Medicare deduction records may be the cause.
- This message cannot be ignored under any circumstances. Upon receipt of the submission file from the ITC, the IRS/SSA calculates the expected tax amount and compares it to the amount reported on the file. If these figures are off by more than a few cents, the file is rejected.
Error This employee's Medicare wages are less then their social security wages.
- The Medicare gross wages amount is incorrect or the FICA (Social Security) gross wages amount is incorrect. Please update the gross amount using CORE/ADJUSTMENTS/TOTAL GROSS that has the incorrect amount. This error should be corrected before creating a submission file. The Social Security Administration will contact the district if this error is not fixed.
- The Medicare gross wages amount is incorrect or the FICA (Social Security) gross wages amount is incorrect. Please update the gross amount using CORE/ADJUSTMENTS/TOTAL GROSS that has the incorrect amount. This error should be corrected before creating a submission file. The Social Security Administration will contact the district if this error is not fixed.
Error This employee has FICA wages without any Medicare wages.
- To properly withhold FICA tax, the employee must have two payroll item records (692 and 693), one flagged as type Medicare and one flagged with type Social Security Tax. This message will occur if W2 Processing encounters a record set up with type Social Security Tax but no record set up with type Medicare for the same employee.
Contact the ITC for assistance if this message is encountered.
- To properly withhold FICA tax, the employee must have two payroll item records (692 and 693), one flagged as type Medicare and one flagged with type Social Security Tax. This message will occur if W2 Processing encounters a record set up with type Social Security Tax but no record set up with type Medicare for the same employee.
Error This employee has FICA/OASDI tax without any FICA/OASDI wages.
- This message cannot be ignored under any circumstances. Upon receipt of the submission file from the ITC, the IRS/SSA calculates the expected tax amount and compares it to the amount reported on the submission file. If these figures are off by more than a few cents, the file is rejected.
Run the Audit Trail report to determine if manual changes on the Medicare/FICA payroll item records may be the cause.
- This message cannot be ignored under any circumstances. Upon receipt of the submission file from the ITC, the IRS/SSA calculates the expected tax amount and compares it to the amount reported on the submission file. If these figures are off by more than a few cents, the file is rejected.
Warning Federal Total annuities, $xxxx.xx, does not equal total gross less taxable gross.
- The W2 Processing program verifies that the annuity (generally in the 500-599 payroll items code range) payroll item amount equals the calculated annuity amount. The calculated amount is determined by taking the total gross and subtracting the taxable gross. The result is the amount of the annuity that was in effect while the tax was being withheld. If this calculated value differs from the totals on the annuity records, the warning appears.
This warning is often associated with a change that has been made to the taxable gross but no corresponding change was made to the total gross or vice versa. Manual adjustments in CORE/ADJUSTMENTS option to the annuity amounts may also cause this warning. Run the Audit Trail report to attempt to isolate these situations.
If an annuity was in effect for only part of the year, this warning may appear and can be ignored.- Using Core/Adjustment, enter an adjustment to the Total Gross to Create a Core>Adjustments for the Federal, State, City (if they honored the annuity initially) OSDI and Medicareoriginally,) OSDI (if applicable), and Medicare Payroll Items using the Type of Total Gross.
- The W2 Processing program verifies that the annuity (generally in the 500-599 payroll items code range) payroll item amount equals the calculated annuity amount. The calculated amount is determined by taking the total gross and subtracting the taxable gross. The result is the amount of the annuity that was in effect while the tax was being withheld. If this calculated value differs from the totals on the annuity records, the warning appears.
Warning Payroll Item XXX: Negative annuity on file for this employee. Assuming zero.
- A total negative annuity indicates a check was voided from a prior calendar year in the current calendar year. Run the REPORTS/PAYMENT TRANSACTION STATUS REPORT option to attempt to isolate the problem. If this is the case, you will need to zero the negative amount of the annuity and file a W2-C form for the previous calendar year
Using Core/Adjustment, enter a positive adjustment amount to the withholding amount for the Annuity .- Create a Core>Adjustments for the annuity Payroll Item and enter the Amount Withheld value (as a positive) to offset the negative amount , making the amounts being reported and make the amount 0.00.
- If no adjustments are made the system will assume zero , and the Warning will continue to appear on the W2 Report.
- A total negative annuity indicates a check was voided from a prior calendar year in the current calendar year. Run the REPORTS/PAYMENT TRANSACTION STATUS REPORT option to attempt to isolate the problem. If this is the case, you will need to zero the negative amount of the annuity and file a W2-C form for the previous calendar year
Warning Employee last name contains a comma.
- Check employee's last name for a comma and remove.
Warning Federal Total Annuities , $xxxx.xx, does not equal total gross less taxable gross.
- The W2 Processing program verifies that the annuity (generally in the 500-599 payroll items code range) payroll item amount equals the calculated annuity amount. The calculated amount is determined by taking the total gross and subtracting the taxable gross. The result is the amount of the annuity that was in effect while the tax was being withheld. If this calculated value differs from the totals on the annuity records, the warning appears. This warning is often associated with a change that has been made to the taxable gross but no corresponding change was made to the total gross or vice versa. Manual adjustments in CORE/ADJUSTMENTS option to the annuity amounts may also cause this warning. Run the Audit Trail report to attempt to isolate these situations. If an annuity was in effect for only part of the year, this warning may appear and can be ignored. Using Core/Adjustment
- Create a Core>Adjustment, enter an adjustment to the Total Gross to Federal, State, City (if they honored the annuity initially) OSDI and Medicare.
- The W2 Processing program verifies that the annuity (generally in the 500-599 payroll items code range) payroll item amount equals the calculated annuity amount. The calculated amount is determined by taking the total gross and subtracting the taxable gross. The result is the amount of the annuity that was in effect while the tax was being withheld. If this calculated value differs from the totals on the annuity records, the warning appears. This warning is often associated with a change that has been made to the taxable gross but no corresponding change was made to the total gross or vice versa. Manual adjustments in CORE/ADJUSTMENTS option to the annuity amounts may also cause this warning. Run the Audit Trail report to attempt to isolate these situations. If an annuity was in effect for only part of the year, this warning may appear and can be ignored. Using Core/Adjustment
Warning Payroll Item XXX: Negative amount payroll item can not be reported on W2, reporting zero.
- This message indicates a check was voided from a prior calendar year in the current calendar year. Run the REPORTS/PAYMENT TRANSACTION STATUS REPORT Reports>Payment Transaction Status Report to attempt to isolate the problem. If this is the case, you will need to file a W2-C form for the previous calendar year.
- This message indicates a check was voided from a prior calendar year in the current calendar year. Run the REPORTS/PAYMENT TRANSACTION STATUS REPORT Reports>Payment Transaction Status Report to attempt to isolate the problem. If this is the case, you will need to file a W2-C form for the previous calendar year.
Warning Possible medicare Medicare discrepancy detected for amount over 200,000. Amount calculated = $xxxxxx.xx.
- This warning will appear if medicare Medicare wages are over $200,000.00 and the medicare Medicare amount on the Payroll Item is not within 30 cents of the calculated value. This warning will allow the submission file to be written.
- This warning will appear if medicare Medicare wages are over $200,000.00 and the medicare Medicare amount on the Payroll Item is not within 30 cents of the calculated value. This warning will allow the submission file to be written.
Warning Payroll Item XXX: No state ID on payroll item configuration.
- This warning will appear if No state ID is entered on the State Tax Payroll Item configuration.
Warning Federal gross is zero.
- The employee has no gross amount on the Federal tax record (001). If an employee was included in a payroll during the year (even if it was dock-only) or if the employee has any adjustment journals for withholding, applicable gross or total gross during the calendar year.
- The employee has no gross amount on the Federal tax record (001). If an employee was included in a payroll during the year (even if it was dock-only) or if the employee has any adjustment journals for withholding, applicable gross or total gross during the calendar year.
Warning Payroll Item XXX: Calculated annuity amount exceeds the total annuities.
- The calculated annuity value is larger than the amounts showing on the annuity (generally in the 500 through 599 Payroll Item code range) records. The calculated amount is determined by subtracting the taxable gross from the total gross.
Manual changes may have been made to the payroll items. It is possible the total or taxable gross was changed incorrectly due to an error adjustment, thus causing the calculated annuity amount to be too high.
- The calculated annuity value is larger than the amounts showing on the annuity (generally in the 500 through 599 Payroll Item code range) records. The calculated amount is determined by subtracting the taxable gross from the total gross.
Warning Payroll Item Employer Health Coverage: Negative amount payroll item cannot be reported on W2, reporting zero.
Warning Employee has ITIN. SSN will be all zeroes- .
- Employee that has an SSN starting with a 9 is considered an ITIN number. W2 Report will show zero's for this employee. The W2 Form, XML and Submission file will show zero's.
Warning Regular Payroll Item (5XX) associated with Annuity Payroll Item Configuration.
- Will give this warning when there is a mismatch between the Payroll Item type and Payroll Item Configuration type.
Warning Federal tax item cannot show COVID19-Emergency amount in Box 14 of W2.
- This warning appears specifically when there is a value in all 3
...
- COVID fields, and there is a vehicle lease. This has been this way since the introduction of the
...
- COVID fields. If any of the
...
- COVID field values are 0.00, they can be cleared out and the warning would go away, or they can ignore it since box 14 is purely informational. The warning is telling them "You have vehicle lease info, as well as values in all 3
...
- COVID fields, but we only show 3 items in box 14, so we can only give you vehicle lease,
...
- COVID self, and
...
- COVID other".
Warning Payroll Item XXX: Tax withheld is 0.00 and total gross is greater than 0.00.
- This warning usually indicates the Payroll Item was not stopped properly - meaning only the Rate field value was removed instead of placing a Stop Date on the record. Removing the percentage will assure nothing is withheld; however, the Total Gross will continue to accumulate. Create a Core>Adjustments for the City Payroll Item using the Type of Total Gross and for the Amount (as a negative to offset the positive amount) currently showing on the City Payroll Item>YTD Total Gross to zero this field.
Warning Payroll Item XXX: Tax withheld is 0.00 and taxable gross is greater than 0.00.00.
- This warning usually indicates the Payroll Item was not stopped properly - meaning only the Rate field value was removed instead of placing a Stop Date on the record. Removing the percentage will assure nothing is withheld; however, the Applicable Gross will continue to accumulate. Create a Core>Adjustments for the City Payroll Item using the Type of Applicable Gross and for the Amount (as a negative to offset the positive amount) currently showing on the City Payroll Item>YTD Applicable Gross to zero this field.
Warning Payroll Item XXX: Tax withheld Taxable gross is 0.00 and taxable total gross is greater than 0.00 Warning Payroll Item XXX: Taxable gross is 0.00 and total gross is greater than 0.00.
- This warning usually indicates the Payroll Item was not stopped properly. Verify which figure, the Applicable Gross or Total Gross, is accurate. Create a Core>Adjustments for the City Payroll Item using the appropriate Type of Total Gross or Applicable Gross and for the Amount (as a negative to offset the positive amount) currently showing on the City Payroll Item>YTD Total Gross or Applicable Gross to zero this field.
Info Employer paid life insurance > 99,999.99 limit - field truncated.
- The employer paid life insurance field is six characters long. If W2 encounters anything larger, the message is issued. Verify that the amount was entered properly on the Adjustment Journal record for the employee under Life Insurance.
Info Payroll Item XXX: Taxable gross is larger than total gross.
- It is possible that a change was made to the taxable gross but no corresponding change was made to the total gross or vice versa. Run the Audit trail report program to help identify the problem.
- It is possible that a change was made to the taxable gross but no corresponding change was made to the total gross or vice versa. Run the Audit trail report program to help identify the problem.
Info Payroll Item XXX: Possible error in OSDI gross or tax.
- OSDI taxable wages with no OSDI tax or OSDI tax with no taxable wages have been detected.
Manual changes may have been made to the payroll items using the CORE/ADJUSTMENTS Core>Adjustments option. Run the Audit Trail report and verify.
If the employee has not earned enough wages to have any tax withheld, this message can be ignored.
- OSDI taxable wages with no OSDI tax or OSDI tax with no taxable wages have been detected.
Info Pension Plan flag on Federal tax payroll item is overriding W2 calculations.
- On the federal tax record, there is a pension plan box flag. This flag is used to indicate
- Verify the Federal Tax Payroll Item>Pension Plan option selected and whether there is an active retirement record. The Pension Plan option selected and the employee having an active retirement record is used together to determine how/if the pension plan box on the employee W2 should be checked. There are three values for the flag:
- Automatically check the pension plan box per W2 Processing calculations.
- Yes, check the pension plan box.
- No, never check the pension plan box.
- Verify the Federal Tax Payroll Item>Pension Plan option selected and whether there is an active retirement record. The Pension Plan option selected and the employee having an active retirement record is used together to determine how/if the pension plan box on the employee W2 should be checked. There are three values for the flag:
W2 Report Summary Breakdown
Dependent Care Report: This report is the total of all Payroll Item Configuration>Type equaling Dependent Care and the Annuity Type equaling Section125NonWages.
...
Criteria for an Employee to be Included on the W2 Report, W2 Submission File, W2 Form File
- If the Federal YTD Gross is not equal to 0 or
- If the Federal YTD Amount Withheld is not equal to 0 or
- If the OSDI Taxable Gross is not equal to 0 or
- If the Employee Medicare/FICA Taxable Gross amount is not equal to 0
- Archived employees with YTD Amounts, will be reported and a W2 generated
USPS-R W2 Submission Overview Video
...