Reports - Historical

<< Click to Display Table of Contents >>

Navigation:  Payroll > Payroll Reports >

Reports - Historical

There are several historical reports.

Payroll Register

The Historical Payroll Register allows you to print a payroll register for any prior updated cycles.

The Payroll Register can be printed by one of three levels of detail. Print All will print all detail by employee with a Grand Total page at the end, Department and Grand Totals Only will print the totals by department with a Grand Total page at the end, Grand Totals will print just the Grand Totals of the Cycle.

Labor Distribution

Labor Distribution Reports are frequently in job costing situations, where expenses and income are being tracked by job.  This is common in construction industry, and with some contract work.  Most often, expenses are broken out by Sub-Account, with each Sub-Account representing a job.  The Labor Distribution Report can report on how many hours each employee worked on particular jobs.  The Labor Distribution Report can be printed by payroll cycle or by date range, or outputted into a CSV file.

NOTE: When reporting totals, if a Sub-Account is blank, "blank" will display letting the user know.

401K Deduction

The 401(k) deduction report lists 401(k) information for each employee being paid.  The information can be printed by payroll cycle or by date range.  The sequence of the report can be by employee #, employee name, department+ emp #, or by social security #.

Deduction Report

Ability to print a report of totals for any pay detail(s) set up in.  Can print the report by cycle or by a date range.  Enter the sequence number order to print, check box to include in current printing and/or create a CSV file, and select the detail number to include on the report.

Create Pension Extract File

Creates an extract of the pension information to send to the company’s administrator.  Enter the dates to include in the extract and select OK. Enter a range of employees, if applicable, and the date range for the checks to accumulate. Option to extract based on Original Hire date or Recent Hire date.

The extract format is setup in Advanced Options > 401K Options.  After clicking on OK the screen will display where the files are written to for you to send to the Pension administrator.

Employee Wage Report

For this report, select a range of employees and dates to print. Accumulate checks date from allows you to set a date range to be printed.  The wages in between the dates will be summed together.

If the Print Each Check box is checked, then a line will be printed for each check, and a summary for each employee.  If it is not checked, then only the summary is printed.

History Summary Report by Check Date

The History Summary by Check Date Report gives a history of every payroll cycle run by quarter.  This is a good report to run if you experience hardware problems and you want to ensure that you have all the history intact.  Enter the date to print checks on or after.

Workers Compensation

The Workers Compensation Insurance Report shows the Net Payroll by Workers Comp Code multiplied by the Rate to give you the premium balance.

Vacation/Sick Accrual Report

Report of Vacation and Sick accrual information for each employee based on the specified date range.The report can be printed by employee number, name, department + employee number, or social security number. The report can be further customized by status

Totals by Detail Code

Listing of all detail codes and the dollar amount totals within the requested date range.  Also gives you the subject to information for each detail code (i.e. subject to social security, federal withholding, etc.) Check the "Print Copy for each Employee" box to print totals by employee.

Also see Payroll Year-End > Reports W-2 > Assessing Year-End Data

Taxable Wages and Withholding by State

This report provides a listing of taxable wages and withholding by state for a date range.  Print totals for each employee by checking box. Print unemployment wages by checking box

Tips Tax Credit report

Provides information necessary to file Form 8846. This report provides all information regarding each employee and any tips received in order to file Form 8846. Enter the check date range desired, the minimum wage amount, and check whether each check should be printed.

Payroll Summary CSV File

Creates a CSV file for the payroll Earnings Records in a selected cycle. The file will be saved in the GLN32\XXXXX\EDI\Earnings_CC.csv where XXXXX is the company code and CC is the cycle number.

Historical Pay Rate Comparison

Compares pay rates for up to three different time periods.

Employee Change Report

Reports changes to employee records based on a date range.

Cycle Comparison Report

This report will compare detail code amounts between two payroll cycles. It will include all detail codes, not just the ones that changed.

Output Payroll Summary to SAP

This report will create detail code summary records and check summary for the date range specified for use with the SAP system. Do not use this without calling your Customer Success Team.

Historical Statements

Detailed statements for employees having detail codes with Payment Calculation Method "D".

Covid-19 Wage Report

For the Covid 941 Credits Report. This is a new report for "Covid-19 Wage Report". Enter in the Employee Number From/Thru to select an employee or range of employees. Leave as the default for all employees. Enter in the check date range.

Select Report Type "Detail" or "Summary"

Detail report will include Employee Number, Employee Name, Check Date, Cycle #, Detail Code, Earnings, and Insurance. Will print a line for each detail code for each pay cycle.

Summary report will include Employee Number, Employee Name, Earnings, and Insurance. Will print one line per employee.

Click Select by the Earning Codes /Insurance codes to select the Detail Codes that need to be included in this report.

The report pulls information from the Payroll Stub Detail.