Quick Timesheets Report
Use this report during a payroll cycle to verify which payroll codes are being used to calculate an employee's pay, as well as the time and amounts entered on the timesheet for a pay date range. This report provides you with information about the timesheets entered using Add Timesheets.
Note: Use the Timesheets Report when a Rate column is needed or you need more columns and control over the report.
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".
To view Earning Code rates and amounts, clear the "Hide Earning Code Rates and Amounts During Timesheet Processing" checkbox by going to Setting Up the Payroll Module. Otherwise, an amount displays only when the calculation method "Amount on Timesheet (AT)" is selected.
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. Sort the Employee IDs by ascending or descending order in the Sort column.
-
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
-
Timesheet 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.