Reviewing Additional Year-End Audit Reports
In addition to audit reports that you run from the DREAM Writer, there are a variety of other year-end audit reports you can run to verify the amounts in your system.
Use the menu selections on the W-2 Reports & Forms Setup (G072473) or Additional Year-End Reports and Forms (G072474) menus to set up the DREAM Writer versions for the reports. Execute the reports from the Year End Processing menu (G07247), and choose Forms.
Reviewing additional year-end audit reports includes:
Reviewing the W-2 Federal Control (Summary) Report (P06740)
Reviewing the Federal Detail Report (P06740A)
Reviewing the State/Local Control Report (P06741)
Reviewing the State/Local Detail Report (P06741A)
Reviewing the W-2 Special Handling Report (P067421)
Reviewing the W-2 Federal Adjusted Wage Detail Report (P06743)
Reviewing the W-2 State/Local Adjusted Wage Detail Report (P06744)
Reviewing the W-2 Summary Report (P06746)
Reviewing the Federal Allocation Report (P06748)
Reviewing the W-2 Restaurant Control Report (P06749)
Reviewing the W-2 Benefit Statement Report (P06750)
Reviewing the Federal Railroad Control Report (P06753)
Reviewing the Employee Form Count Report (P06754)
Reviewing the 1099-MISC Summary Report (P06756)
Reviewing the 1099-R Summary Report (P067561)
Reviewing the 499R-2 Summary Report (P06758)
Reviewing the W-2 Box 13 Flag Audit Report (P06776)
Reviewing the Tax History/W-2 Workfile Integrity Report (P06790)
Reviewing the W-2 Federal Control Report (P06740)
The W-2 Federal Control report prints all of the information for each employee's W-2. You should consider producing this report as a mandatory step in the year-end process because it is your hard copy of the information that prints on the W-2 forms that you distribute to your employees. This report is the only report that includes all of an employee's data as it displays on the W-2 form.
This report prints summary information by company as reported on your W-2s. The report includes federal reportable wage (taxable and adjustments) and tax.
You can run this report in summary or detail mode.
Navigation
From Additional Year End Reports & Forms (G072474), choose W-2 Federal Control Report
Processing Options
Data Selection
You must have Record Type equal to P for the report to run properly.
Data Sequence
JD Edwards World recommends you do not change the data sequence.
Reviewing the Federal Detail Report (P06740A)
This Report displays the taxable wages, adjustments, adjusted wages and taxes for the various federal tax types for each tax type that is applicable for a given employee.
If you choose the detail version of this report, the report lists the following information by employee:
All federal taxable wages
Special adjustments
Reportable wages
Taxes paid
Navigation
From W-2 Reports & Forms Setup (G072473), choose Federal Detail Report
Processing Options
Data Selection
The Type of Form field must have a value of 0 to insure that you are reporting W-2 records for the employees.
Data Sequence
The data sequence is hard coded and any changes to the report will cause a program error.
Example: Federal Detail Report
Reviewing the W-2 State/Local Report (P06741)
The W-2 State/Local Control Report allows you to print the detail information for the State/Local Wages and Taxes.
Navigation
From Additional Year End Reports & Forms (G072474), choose W-2 State/Local Report
Processing Options
Data Sequence
To print summary information correctly, you cannot have Page Skip equal to Y for Work State, Work City, and Work County. To print detail and summary information, Page Skip can equal Y for Work State, Work City, or Work County.
Example: W-2 State/Local Report (P06741)
Reviewing the State/Local Detail Report (P06741A)
The State/Local Detail report prints the following information:
State and local taxable wages
Special handling adjustments
Reportable wages
Tax by employee, tax area, and tax history type, as reported on the W-2 forms
If you choose summary information, the report lists detail by company, tax area, and tax type.
Navigation
From W-2 Reports & Forms Setup (G072473), choose State/Local Detail Report
Processing Options
Data Selection
Type of form must have a value of 0 to insure that you are reporting W-2 records for the employees.
Data Sequence
The program is hard coded and any change to the data Sequence causes an error.
Example: State/Local Detail Report
Reviewing the W-2 Special Handling Report (P067421)
This report lists DBA amounts on the W-2 forms by box, DBA, and employee. You can run this report for only one special handling box at a time. Summary information displays a total by box, DBA, and company.
Navigation
From W-2 Reports & Forms Setup (G072473), choose Special Handling Report
Processing Options
Data Selection
Because you enter a value for the Special Handling Tag in the processing option, it is not necessary for you to enter this in the data selection. Doing so can cause the report to fail.
Form Type must have a value of 1 and 0 to insure that you are reporting W-2 records for the employees.
Data Sequence
JD Edwards World recommends that you do not change the data sequence.
Reviewing the W-2 Federal Adjusted Wage Detail Report (P06743)
The W-2 Federal Adjusted Wage Detail Report lists taxable wages and any special handling adjustments for FIT, FICA, and Medicare. This report groups the information by employee if you choose detail information or by company if you choose summary information. This report also lists error messages if the adjusted wages on the report do not match the adjusted wages on the W-2.
Navigation
From W-2 Reports & Forms Setup (G072473), choose Federal Adjusted Wage Report
Processing Options
Data Sequence
JD Edwards World recommends that you do not change the data sequence.
Example: Federal Adjusted Wage Detail Report
Reviewing the W-2 State/Local Adjusted Wage Detail Report (P06744)
The W-2 State/Local Adjusted Wage Detail Report prints employees' taxable wages, fringe benefits, and reportable wages, as reported on the individual W-2 forms. A processing option allows you to specify up to three states or localities for which to print this information. This report also prints error messages if adjusted wages on the report do not match adjusted wages on the W-2.
Navigation
From W-2 Reports & Forms Setup (G072473), choose State/Local Wage Adjustments
Processing Options
Example: W-2 State/Local Adjusted Wage Detail Report
Reviewing the W-2 Summary Report (P06746)
You should consider producing this report as a mandatory step in the year-end process. The report is your hard copy of the information that prints on the W-2 forms and is the only report that includes all of an employee's data the W-2 form.
Additionally, JD Edwards World recommends that you run the following reports:
The 1099-MISC Summary report (P06756) for detailed information for each employee's 1099-MISC.
The 1099-R Summary report (P067561) for detailed information for each employee's 1099-R.
Tax History/W-2 Workfile Integrity report (P06790)
Navigation
From W-2 Reports & Forms Setup (G072473), choose W-2 Summary Report
Processing Options
Reviewing the Federal Allocation Report (P06748)
This report provides a detailed list of federal taxable wages that are allocated to the various states where the employee worked.
Navigation
From Additional Year End Reports & Forms (G072473), choose Federal Allocation Report
Data Selection
Set the data selection as follows:
Tax Type must be equal to F.
Allocation Percentage must not equal 0.
Data Sequence
JD Edwards World recommends you do not change the data sequence.
Reviewing the W-2 Restaurant Control Report (P06749)
The W-2 Restaurant Control report provides detailed information about employees that receive tips as a form of compensation.
The report includes all federal wages you report, federal taxes, allocated tips, and taxable tips that you report on the individual W-2 forms.
Navigation
From Additional Year End Reports & Forms (G072474), choose W-2 Restaurant Control Report
Processing Options
Data Selection
JD Edwards World recommends you do not change the data selection.
Example: W-2 Restaurant Control Report
Reviewing the W-2 Benefit Statement Report (P06750)
The W-2 Benefit Statement Report (P06750) prints a summary of benefits for select employees by state.
Navigation
From W-2 Reports & Forms Setup (G072473), choose W-2 Benefit Statements
Data Sequence
JD Edwards World recommends you do not change the data sequence.
Example: W-2 Benefit Statement Report
Reviewing the W-2 Railroad Control Report (P06753)
This report provides detailed tax and wage information that is specific to railroad employees.
Navigation
From W-2 Reports & Forms Setup (G072474), choose W-2 Railroad Control Report
Processing Options
Data Selection
You must have Record Type equal to P for the report to run properly.
You must have Type of Form equal to 0 for the report to run properly.
Data Sequence
JD Edwards World recommends you do not change the data sequence.
Reviewing the Form Count Reports (P06754)
These reports provide a listing of the form you submit to employees. It lists the total amount of earnings for employees that are on the forms.
This report lists federal, state, and local reportable wages by employee, as well as an employee count by company and tax ID as reported on the individual forms. If you choose summary information, only the company and tax ID totals appear.
From this menu selection, you can run the following reports:
W-2 and W-2C Count Report (Summary or Detail)
499R-2 Count Report (Summary or Detail)
1099-R Count Report (Summary or Detail)
1099-Misc. Count Report (Summary or Detail)
Navigation
From W-2 Reports & Forms Setup (G072473), choose W-2 Count Report
Processing Options
Data Sequence
JD Edwards World recommends you do not change the data sequence.
Example: Form Count Report
Example: 1099-MISC Count Report
Reviewing the 1099-MISC Summary Report (P06756)
The 1099-MISC Summary report lists all of the information that displays on 1099-MISC forms for contract employees. You should consider producing this report as a mandatory step in the year-end process and it is mandatory if you are creating 1099-MISC forms during the payroll year-end process. This is the only report that lists all of the data on each employee's 1099-MISC form.
Navigation
From Additional Year End Reports & Forms (G072474), choose 1099-MISC Summary Report
Processing Options
Data Sequence
JD Edwards World recommends you do not change the data sequence.
Example: 1099-MISC Summary Report
Reviewing the 1099-R Summary Report (P067561)
This report allows you to review all of the retirement or pension amounts earned by employees within a given company and version.
The 1099-R Summary report lists all of the information that displays on 1099-R forms for pension employees. You should consider producing this report as a mandatory step in the year-end process and it is mandatory if you are creating 1099-R forms during the payroll year-end process. This is the only report that lists all of the data on each employee's 1099-R form.
Navigation
From Additional Year End Reports & Forms (G072474), choose 1099-R Summary Report
Processing Options
Data Selection
You must have Type of Form equal to 5 for the report to run properly.
Data Sequence
JD Edwards World recommends you do not change the data sequence.
Example: 1099-R Summary Report
Reviewing the 499R-2 Summary Report (P06758)
This report provides a detailed listing of all information pertaining to a 499R-2 and the non-form hardcopy of the 499R-2 that you issue to the employee.
Navigation
From Additional Year End Reports & Forms (G072474), choose 499R-2 Summary Report
Reviewing the W-2 Box 13 Flag Audit Report (P06776)
The W-2 Box 13 Flag Audit Report lists which employees have information that prints in Box 13 of the W-2 form.
Navigation
From Year End Processing (G07247), choose Audit Reports
Example: W-2 Box 13 Flag Audit Report
Reviewing the Tax History/W-2 Workfile Integrity Report (P06790)
Once you build and balance the workfiles, there can be occasions when you need to modify employee history because of late corrections. Modifications might include manual or void checks that you did not process promptly or DBA's which were previously unidentified. When you process these items through the standard payroll cycle or update them directly into the history, the integrity report creates a variance. The main purpose of this integrity report is to identify employees with variance amounts so you can correct the information, by running a Changes Only workfile, before printing year end forms.
The Tax History/W-2 Workfile Integrity Report lists any variances by employee when comparing the actual W-2 forms to the payroll history tables. The EC (Error Code) column identifies the error numbers that appear on the error table at the end of the report. This table lists which integrity test the system performs to identify the variance.
This report displays variances between the following history files and the W-2/1099 Workfile build files:
Taxation Summary History (F06136)
Transaction Summary History (F06146)
Tax Area Transaction History (F06148)
Employee Federal Control Record (F06730)
Employee State/Local Control Record (F06731)
Employee Special Handling Control Record (F06732)
The report includes the following fields and descriptions:
Tax Area, Tax Type, Description of the Problem
History Type, History Amounts and Taxes
Workfile Amounts and Taxes
Variance Amounts and Taxes
Error Code (EC)
The EC column prints a numeric error code (01-06) that identifies which history files and W-2 workfiles contain errors.
Following are the error codes for this report:
01 = Tax History Taxable Wage VS. W-2 Workfile (Federal)
When this error occurs, the program locates a variance between the Federal Taxation History (F06136) and the W-2 Employee Federal Control Record (F6730) files. This error can occur on each of the employee's Federal tax records and on each company in which the employee worked. This variance is for only Federal Taxes Areas and Tax Types.
02 = Tax History Taxable Wage VS. W-2 Workfile (State/Local)
When this error occurs, the program locates a variance between the State and Local Taxation History (F06136) and the Employee State/Local Control Record (F06731) files. This error can occur on each State record and on each company in which the employee worked. This variance is for only Tax Areas and Tax Types.
03 = Transaction Summary VS. W-2 Workfile (Federal)
When this error occurs, the program locates a variance between the total Transaction History file (F06146) and the PDBA's in the Special Handling Tables that create the Employee Federal Control Record file (F06730). This error can occur on the following forms and boxes:
W-2 Forms:
Box 11 - Non-qualified Plans
Box 10 - Dependent Child Care
Box 12 - Benefits included in Box 1
Magnetic Media (W-2)
Fringe Benefit Amounts
Deferred Compensation
Non-Qualified Non 457 Amounts
Dependent Child Care
Group Term Life
1099-R Forms
Non-Qualified Plan Income
Gross Distributions
Employee Contributions
1099-Misc Forms
Rents
Royalties
Prizes and Awards
Non-Employee Compensations
Medical and Health
Substitute Payments
1099-NEC Forms
Non-Employee Compensations
499R-2 Forms
Commissions
Concessions
Reimbursed Expenses
Retirement Funds
CODA Plans
If the total of the PDBA's in a Special Handling table does not match the grand total in the field, the program issues an error.
04 = Transaction Summary VS. W-2 Special Handling Workfile
When this error occurs, the program locates a variance between the Transaction History file (F06146) defined in a Special Handling Table and the Employee Special Handling Control Record file (F06732). This error can occur when you enter Special Handling Table codes for the W-2 form, in the following boxes:
Box 13 - Statutory employee, Retirement plan, Third-party sick pay
Box 14 - Other
The program is comparing each Special Handling record to a related Transaction History record. Because each DBA in the Special Handling Table must be handled separately, the program performs the comparison on a record by record basis. If a variance exists, the program issues an error.
05 = Tax Area Trans. History VS. W-2 Special Handling Workfile
When this error occurs, the program locates a variance between the Tax Area Transaction History file (F06148) and the PDBA's defined in a Special Handling Table that create the Employee Special Handling Control Record file (F06732). The only time this error occurs is when you enter Special Handling Table codes for any of following boxes on the W-2 form:
Box 17 - State Wages, tips, etc.
Box 20 - Local wages, tips, etc.
The program is comparing each Special Handling record to the related Tax Area Transaction History record. Because each DBA in the Special Handling Table must be handled separately, the program performs the comparison on a record by record basis.
06 = Arreared Payroll Taxes VS. W-2 Special Handling Workfile
When this error occurs, the program locates a variance between the Federal Taxation History (F06136) and the Employee Special Handling Control Record files (F06732). This error identifies variances when it encounters an arrearage in FICA and Medicare taxes and the system creates unique Special Handling records to accommodate the following codes in Box 13:
A - Uncollected FICA on Tipped Employees
B - Uncollected MEDICARE on Tipped Employees
M - Uncollected FICA on Group Term Life
N - Uncollected MEDICARE on Group Term Life
Note:The only time that an A or B Special Handling can occur is when the employee is defined as a Tipped Employee in the Basic Employee Data. If the program finds FICA or Medicare taxes in arrears on a non-tipped employee, the Special Handling record creates codes M and N to note the uncollected taxes.
The program is comparing each Special Handling record to the related Tax History record.
Navigation
From W-2 Reports & Forms Setup (G072473), choose W-2 Workfile Integrity
Processing Options
Data Sequence
JD Edwards World recommends you do not change the data sequence.
Example: Tax History/W-2 Workfile Integrity Report
