...Menu...

Management Reporting - US

This topic will review the various management reports and some of their applications within the payroll.

A word about reports

Labour Distribution  -----------------------> by EBD
by G/L Code
by G/L & Job
by Department/Employee
by Employee
Cheque Details by EBD
Multiple Cheque Details by EBD
Employee Leave Status
Hirings List
Termination Reports  ----------------------> Termination List
Employee Amounts Due
Workers Compensation Report
Income Tax Reports  ---------------------> 401k Report
401k Monthly Transmission
Federal 941 Returns
Quarterly Witholding Report
Quarterly State Report
Quarterly State Tax Report
EDD- State of California Witholding
New Hampshire Quarterly Wage Report
W2 Form Printing
W2 Magnetic Media
W2 State Detail Report
Retirement Reports State of California PERS Report
PERS Electronic Transmission

Labour Distribution

The first report on the menu is the Labour Distribution. Clicking on the item you will be presented with five choices of reports. All of these are variations of the same report. The only report that must be run as part of the payroll run is the Labour Distribution by EBD. This report will update the G/L interface files for integration to the General Ledger. You may run the report as many time as you wish, but it must be run at least once per period. The Payroll Initialisation cannot be run if this report hasn't been printed.

Check Details By EBD

This report will print the details for an individual EBD for a range of employees and periods. You will also have the option to print the contents of the employer share EBD as a separate column on the report. An example application for this report would be to determine the total union dues for a period. Another example would be to show how much federal income tax was paid by an individual or group of employees for a period of time.

Multiple Check Details by EBD

This report is essentially the same as the Check Details by EBD except you can choose a range of EBD's to print. Click here for more information about this report.

Employee Leave Status

A report showing the balances in the employees different banks including vacation, sick pay and time banks.

Hiring List

Report of employees hired since the last report was run.

Termination Reports

This sub-menu comprises three reports:

1) the Termination report showing all employees terminated since the last time the report was printed

2) The Employee Amounts Due List that will show if the employee has any amounts owing to the company. This report would be printed prior to termination to ensure that the employee being terminated does not owe any money to the employer.

Workers Compensation Report

A report showing the employer shares accrued for employees designated as under a Workers Compensation plan.

Income Tax

This menu contains the end of year reports and programs for electronic end of period and end of year reporting.

Before printing W2's you must run the W2 State Detail Update. This program will ensure that all the State information and withholding tax is properly recorded on the W2. Enter the year and click OK.

You can also run the W2 State Detail Report to view the state details by employee.

After that W2's can be run at any time. We recommend that you print them to blank 8 1/2 x 11 paper before printing them to the actual W2 forms. This way you can check the numbers, verify the front end options, etc before committing to the actual form. You can do this at any time during the year, or immediately after the final payroll of the year.

Retirement Reports

These reports are used for the reporting of PERS in California.

Last Update October 20, 2006