Common Reporting Requests Outline

Guide for common reporting requests.

PAY CYCLE REPORTS

Below are some common reporting requests:

Cash Requirement

• This report provides a detailed summary of: Wages, Hours, Employee Deductions; and Employer and Employee Taxes, Total Payroll Liability, and Total Amount to be Electronically Transmitted

  • File Type: PDF

  • Report Location: Reports → Pay Cycle

  • Filters Available: Yes, the reports can be viewed by Employee, Department, Class, Branch, or Division.

 

Payroll Summary

• This report provides a detailed summary of client: Wages, Employee Deductions, Employer and Employee Taxes; Direct Deposits, Payroll Fees, Check Net, and Total Bank Transfers for the specified pay cycle.

  • File Type: PDF, Excel, and CSV

  • Report Location: Reports → Pay cycle

  • Filters Available: Yes, the reports can be viewed by Employee, Department, Class, Branch, or Division.

 

Payroll Register

• This report provides a breakdown of client: Wages, Employer & Employee Taxes; and  Employee Deductions, for each employee within the specified pay cycle.

  • File Type: PDF, Excel, and CSV

  • Report Location: Reports → Pay cycle

  • Filters Available: Yes, the reports can be viewed by Employee, Department, Class, Branch, or Division.

 

Company Fee Details

• This report provides a detailed breakdown of the Payroll Processing Fees charged for the current pay cycle.

  • File Type: PDF

  • Report Location: Reports → Pay cycle

  • Filters Available: No

 

Net Check Register

• This report provides a breakdown of employee: Gross Amount, Net Amount, Net Type (Direct Deposit or Physical Check), Check Number, and Check Date. 

  • File Type: Excel

  • Report Location: Reports → Paycycle

  • Filters Available: No

 

Deductions ALL

• This report provides a detailed summary of all employee Deductions and Accruals for the specified pay cycle.

• File Type: Excel & PDF

• Report Location: Reports → Pay cycle

• Filters Available: Yes; the reports can be viewed by Employee, Department, Class, Branch, or Division.

  • Notes: Will only be available if Client has deductions during the pay cycle selected.

 

Deduction Name

• This report provides a detailed summary of only specific deductions for the specified pay cycle.

• File Type: Excel & PDF

• Report Location: Reports → Pay Cycle

• Filters Available: Yes; the reports can be viewed by Employee, Department, Class, Branch, or Division.

  • Notes:

    • Will only be available if Client has deductions for the specified Pay Cycle .

    • The report will be named after the deduction name.

DATE RANGE REPORTS

Cash Requirement

• This report provides a detailed summary of: Wages, Hours, Employee Deductions; and Employer and Employee Taxes, for the date range specified.

  • File Type: PDF

  • Report Location: Reports → Date Range

  • Filters Available: Yes, the reports can be viewed by Employee, Department, Class, Branch, or Division.

 

Payroll Summary

• This report provides a detailed summary of client: Wages, Employee Deductions, Employer and Employee Taxes; Direct Deposits, Payroll Fees, Check Net, and Total Bank Transfers for the date range specified.

• File Type: PDF, Excel, and CSV

• Report Location: Reports → Data Range

• Filters Available: Yes, the reports can be viewed by Employee, Department, Class, Branch, Division

  • Notes: An excel version of this report exists; however, it does not provide: Department, Class, Branch, or Division Filtering

 

Payroll Register

• This report provides a breakdown of client: Wages, Employer & Employee Taxes; and Employee Deductions, for each employee within the date range specified.

  • File Type: PDF, Excel, and CSV

  • Report Location: Reports → Data Range

  • Filters Available: Yes, the reports can be viewed by Employee, Department, Class, Branch, or Division.

 

Employee Census

• This report provides a list of only the Employees who were Active during the date range specified.

  • File Type: Excel & CSV

  • Report Location: Reports → Date Range

  • Filters Available: No

 

Employee Deduction

• This report provides a list of only the Employees who were Active during the date range specified, and includes their Deduction Information.

  • File Type: Excel & CSV

  • Report Location: Reports → Date Range

  • Filters Available: No

 

Employee Wage

• This report provides a list of only the Employees who were Active during the date range specified, and includes their Wage Information.

  • File Type: Excel & CSV

  • Report Location: Reports → Date Range

  • Filters Available: 

 

Complete Summary by Employee

• This report provides a detailed summary of: Hours, Employee and Employer Deductions, Employee and Employer Taxes; and Wages, for each employee within the date range specified. 

  • File Type: Excel & CSV

  • Report Location: Reports → Date Range

  • Filters Available: No

 

Employee Banking/Taxing Info Report

• This report provides a list of only the Employees who were Active during the date range specified, and includes their Bank Information.

  • File Type: Excel & CSV

  • Report Location: Reports → Date Range

  • Filters Available: No

 

Quarterly Tax Reconciliation (Employee by Check Date)

• This report provides a summary by Tax Type, Employee, and Check Date 

  • File Type: Excel & CSV

  • Report Location: Reports → Date Range

  • Filters Available: No

 

Quarterly Tax Reconciliation (Employee by Quarter)

• This report provides a summary by Tax Type, Employee, and Date Span

  • File Type: Excel & CSV

  • Report Location: Reports → Date Range

  • Filters Available: No

Quarterly Tax Reconciliation (Company)

• This report provides a summary by Tax Type and Date Range (Quarter)

  • File Type: Excel & CSV

  • Report Location: Reports → Date Range

  • Filters Available: No

 

W2 & 1095-C Consent Status Report

• This report provides a list of all employees W2 and 1095-C Mailing Methods

  • File Type: Excel & CSV

  • Report Location: Reports → Date Range

  • Filters Available: No

W2 Preview Report

• This report provides a snapshot of what data will be pulling onto the W2

  • File Type: Excel & CSV

  • Report Location: Reports → Date Range

  • Filters Available: No

 

Deductions ALL

• This report provides a detailed summary of all employee Deductions and Accruals for the specified date range.

  • File Type: Excel & PDF

  • Report Location: Reports → Date Range

  • Filters Available: Yes; the reports can be viewed by Employee, Department, Class, Branch, or Division.

    • Notes: Will only be available if Client has deductions during the date range selected.

 

Deduction Name

• This report provides a detailed summary of only specific deductions for the specified date range.

  • File Type: Excel & PDF

  • Report Location: Reports → Date Range

  • Filters Available: Yes; the reports can be viewed by Employee, Department, Class, Branch, or Division.

    • Notes:

      • Will only be available if Client has deductions for the specified Date Range.

 

Workers Compensation Salary List

• For the purposes of workers compensation, this report provides a detailed list of employees and their related wages for the date range specified.

  • File Type: PDF, Excel, CSV

  • Report Location: Reports → Date Range

  • Filters Available: Yes, the reports can be viewed by Employee, Department, Class, Branch, or Division.

    • Notes: Must have Workers Comp Data setup at Company and Employee level in order to use this report.

Workers Compensation Estimate

• This report provides an estimate of each employees estimated workers compensation.

  • File Type: PDF, Excel, CSV

  • Report Location: Reports → Date Range

  • Filters Available: No

    • Notes: Must have Workers Comp Data setup at Company and Employee level in order to use this report.

 

EEO1 Federal Report 

• This report provides data for filing the EEO1 Report

  • File Type: PDF

  • Report Location: Reports → Date Range

  • Filters Available: No

    • Notes: N/A

 

Estimated Annual GT Imputed Income Report

• This report provides a Per Pay Amount as well as an Annual Amount of Imputed Income for Group Term Life

  • File Type: Excel & CSV

  • Report Location: Reports → Date Range

  • Filters Available: No

    • Notes: Must use Namely Benefits in order for data to populate on this report.