The W-2 Edit Report compares the combined total of your per pay period taxes to the quarterly totals transmitted for each tax code set up on your Client Master File at quarter-end. It also compares the combined totals of your quarterly returns to the year-to-date totals. This report consist of the following fields:
1. Tax Code A/T: Tax type.
2. DIV: Division number assigned to the client ID#.
3. QTR: Current quarter.
4. RPT TYP: Source of quarterly data according to the following codes:
R = client transmitted data
Z = Zero fill by Ceridian Tax Service
P = Mid-year data
M = Amended quarterly data
5. Quarterly Report: Quarterly totals you transmitted to Ceridian Tax Service.
6. CTS Adjustment: Adjustment by Ceridian Tax Service for Third Party Sick Pay, "fractions only" rounding, "V" entries at year-end to force balance to YTD.
7. Total Tax Return: Sum of the Quarterly Report and CTS Adjustment columns.
8. Taxes Impounded: Total of periodic tax liabilities received by Ceridian Tax Service. (It does not reflect deposits.)
9. Tax STMT Variance: Difference between the quarterly total and the periodic total. If your variance is:
Zero - the QTD = periodic
Negative (-) - the QTD is greater than periodic. Deposit amounts will be increased and additional funds may be required.
Positive (+) - the QTD is less than periodic. Deposit amounts will be decreased. Funds already deposited will be refunded by agency.
10. Prior QTR Adjustment: New quarterly return total, usually as a result of an amendment or notice completed by Ceridian Tax Service. This replaces original quarterly return total in Quarterly Report.
11. Quarterly Report: YTD totals transmitted by client. YTD = annual returns = W-2s
12. Tax Return Total: Sum of quarterly return totals filed by Ceridian Tax Service.
13. W-2 Variance: Difference between Quarterly Report and Tax Return Total. If your variance is:
Negative - YTD is less than the return totals.
Positive - YTD is greater than the return totals.
Click here to view the W-2 Edit Report (Tax Edit W-2 Analysis) - PDF file