Quick Calculated Check Register Report

The Calculated Check Register provides information about the payrolls that were calculated for processing (see Process Payroll and Print Checks).

Use this report during a payroll cycle to verify paycheck information and amounts prior to printing paychecks. It is recommended that you print this report prior to printing checks for each pay cycle. Note that this is a fixed-format report. You cannot customize the columns in the report; the system has already determined them. However, you can arrange the data using sort order.

  • To view an employee's entire social security number, you must have been granted Display Sensitive Data rights for Payroll>System Setup>Employee Information. Otherwise, only the last four digits of the Social Security Number display.

  • These rights are granted by the Administrator by going to Administration>Users>Manage Users, selecting the "Accounts Payable" module, scrolling down to the "Maintenance" section and selecting the checkbox under "Display Sensitive Data".

Tip: If you're not familiar with the MIP Cloud Report Builder interface, see Report Builder for an introduction.

Current Transaction dates are required to specify the date range for data included in the report. Enter these dates on the Setup tab.

Selecting columns in the Report Body has no bearing on what appears on the report; the columns are for sorting purposes only.

  • By selecting Employee ID in the Available Columns box, the data can be divided onto separate pages. The report starts a new page for each Employee ID. You can sort the Employee IDs by ascending or descending order.

  • By selecting Available Columns, the sort order for each column is determined. Sort the columns by ascending or descending order. Below is a list of the columns available to sort on. Keep in mind, that the report includes additional columns; these are the only ones that have sorting capabilities.

    • Processing Group

    • Pay Date

    • Employee ID

    • Employee Last Name

    • Payroll Type

Use the Filter tab to narrow down and define the data using the available filters.

Use the Options tab to Summarize Amounts on the report, to implement security features, and more.

  • Select "Summarize Amounts" 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

  • You can secure the report so that other users cannot save their changes to it. This option can only be undone by the user that locked the report.

  • Select the "Year End Adjustments" option to include year end adjustments on the report. This entry type was designated during transaction entry.

  • Select the "Replace total debits and credits with Balance" option to show the net amount for each segment where totals have been requested. Otherwise, the report displays the total debits and total credits for each segment.

  • Select the "Total by Payroll" option to total processing group information, such as the hours taken and the hours accrued for the employees.

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