Calculated Check Register

Access this report using Reports>Payroll>Processing>Calculated Check Register. It is only available with the Payroll module; it is not available for Payroll Link users.

Use this report during a payroll cycle to verify the current paycheck information and amounts prior to printing paychecks. It is recommended that you print this report prior to printing checks for each pay cycle. The report uses the calculated information from the Payroll Type and Pay Dates selected on the Calculated Payroll form (Activities>Payroll>Calculate Payroll).

Alternatively, you can run Reports>Payroll>Processing>Quick Calculated Check Register to generate a limited, fixed-format report.

You must calculate payroll (Activities>Payroll>Calculate Payroll) in order for this report to work. The report displays the calculated information selected on the Payroll Type and Pay Dates .

 

Use this tab to assign a report name and determine whether or not to include it on the actual report. The report name can be printed in the header or the footer of the report.

Use this tab to determine the order that the data prints on the report. The Items by Page group box is used to divide the data onto separate pages, where as the Report Body group box is used to select the sort order (ascending or descending) of the columns. Selecting columns in the Report Body has no bearing on what appears on the report; the columns are for sorting purposes only.

  • By selecting Available Items, the data is divided onto separate pages. The report starts a new page for each item, and the item is printed in the page header of the report.
  • By selecting Available Columns, the data that appears in the body of the report is determined.

Column

Description

Processing Group

The processing group code assigned to the employee using the Maintain>Payroll>Employee Information form. The report shows the code's name, such as Admin or PartTime.

Processing Group Title

The title associated with the processing group code.

Payroll Type

The payroll type—Adjust, Manual, Regular, Supplemental, or Void

Pay Date

The date on the Payroll check (Activities>Payroll>Calculate Payroll).

Pay Period Begin Date

The pay period beginning date entered on the Maintain>Payroll>Processing Groups form.

Pay Period End Date

The pay period ending date entered on the Maintain>Payroll>Processing Groups form.

SUTA Weeks

The number of SUTA (state unemployment tax) weeks for the pay date on the Maintain>Payroll>Processing Groups form.

Employee ID

The ID assigned to the employee.

Employee Last Name

The employee's last name.

Employee First Name The employee's first name.

Employee Name

The employee's full name, including the middle initial.

First, MI Name

The employee's first name and middle initial.

Class

The employee's class, such as Admin or Staff.

Position

The employee's job title, such as Administrator or Program Rep.

Social Security Number

The employee's social security number. Note that only the last four digits of the number display. To view the entire social security number, you must have been granted Display Sensitive Data rights for Maintain>Payroll>Employee Information. These rights are granted by the Administrator using Security>Set Up Organization Menus form.

Timesheet Reference A unique tracking number provided for timesheets.

Pay/Tax Code

The name assigned to your earning, benefit, deduction, workers' compensation, leave codes, and federal, state, and other withholding taxes, such as Health, 401K, OT, Sick8, and Executive. These codes were created using Maintain>Payroll>Federal Taxes, State Taxes, Other Taxes, Earning, Benefit, Deduction, Workers' Compensation, or Leave Codes.

Code Title

The title of the Payroll Pay Code.

Code Type

The payroll code assigned by the system—Earnings, Benefits, Deductions, Workers' Compensation, Leave, or Taxes.

Jurisdiction

The state or other withholding taxing authority, such as TX for Texas.

Distribution Code

The distribution code of the earnings. This information was entered using the Timesheets>Enter Default Timesheets or Enter Regular/Supplemental Timesheets form.

Rate

Depending on the calculation method, this is the rate entered on one of the tabs.

Hours

Depending on the calculation method, these are the hours entered on one of the tabs.

Applicable Earning Hours

The earning hours applicable to the earning codes on the employee's current pay date.

Applicable Earnings

The earning amount based on the employee’s current pay.

For Benefits, Deductions and Workers Compensation Codes Applicable Earnings are the earnings used to calculate the amounts (given earnings were applicable to the calculation method assigned to the code).

The Tax Codes Applicable Earnings are the Subject Earnings used to calculate the tax.

Note: In those case were a Tax Code is both employee and employer paid, only the subject earnings associated with the Employee displays as the Applicable Earnings.

Earnings

The amount based on the employee's earnings which was calculated for the employee’s current pay date.

Benefits

The amount based on the employee's benefits which was calculated for the employee's current pay date.

Deductions

The amount based on the employee's deductions which was calculated for the employee's current pay date.

Employee Taxes

The amount based on the employee's taxes which was calculated for the employee's current pay date.

Employer Taxes

The amount based on the employer's taxes which was calculated for the employee’s current pay date.

Employee Workers’ Compensation

The amount based on the employee's workers' compensation which was calculated for the employee's current pay date.

Employer Workers’ Compensation

The amount based on the employer's workers' compensation which was calculated for the employee's current pay date.

Net

The amount based on the employee's current pay date uses the following formula: (Earnings minus Deductions, Employee Workers' Compensation, and Employee Taxes). This amount was calculated for the employee’s current pay date.

Leave Hours Accrued

This is the number of leave hours the employee has accrued for the current pay date.

Leave Hours Taken

This is the number of leave hours the employee has taken, for the current pay date.

Net Change Leave

This is the difference between the Leave Hours Accrued less the Leave Hours Taken based on the current pay date.

{User Defined Field} - Employees

An employee type user defined field and its data. There is a separate column for each field that was created by the Administrator using Organization>Set Up User Defined Fields.

Use this tab to narrow down and more explicitly define the data to include in the report by selecting from the Available Filters.

Use this tab to set up any Available Options for the report.

Options

Description

Summarize Amounts

Select this option to add amounts together and display one line item with the total amount. All document information must be identical for the system to add items together.

Use this tab to change the font and page setup for a report.

Use this tab to secure the active report so that other users cannot save their changes to it. The user that selects the check box, and then saves the report, is the only user that can change or save it later. This check box cannot be cleared by any user other than the user that locked the report.