Documentation for Administrators

Payroll Reports

Updated on

Payroll Reports allow users to run various reports that pertain to payroll including Reimbursements, Gross To Net, Leave Time Exceptions, Payroll Reallocations, and more. The various Payroll Reports are commonly used by the payroll department prior to posting to estimate grant totals and to ensure the payroll is in balance.

Report permissions are driven by accounting strip permissions enabled via Setup > Accounting Strips. The permissions given here determine the facilities to which you have access.

Payroll Reports

1. From the Payroll menu, click Payroll Reports.

Payroll Reports

2. Select the applicable report from the pull-down.

Payroll Reports

Each of the reports displayed in the pull-down have their own profile permission, which must be enabled in order to run the report via Setup > Profiles.

Profiles

3. Enter the report criteria/filters, and click Report.

Payroll Reports

4. The report generates. To edit the report criteria and rerun the report, click the arrowed tab to reopen the report criteria.

Payroll Reports

You only have access to facilities in the Facility pull-down for select reports based on you accounting strip permissions selected for HR/PR enabled via Setup > Accounting Strips.

Time Exceptions Edit Report

The Time Exceptions Edit report displays a total of the timecard and overtime hours worked by an employee; these totals are grouped by the facility from which the data was entered via Payroll > Run Payroll > Timecards and Overtime tabs.

1. Select Time Exceptions Edit from the pull-down.

2. Select the applicable Fiscal Year from the pull-down from which you'd like data pulled, and select the Pay Run(s) from the pull-down.

Payroll Reports

3. OR enter a Check Date range in the provided text boxes.

4. Select the applicable Employee(s) from the pull-down. Selecting employees from the filter is optional. If no employees are selected, the report runs for all employees.

5. Select the applicable facilities from the Primary Facility pull-down. Selecting facilities from the pull-down is optional. If no facilities are selected, the report runs for all facilities. Note: The Primary Facility pull-down equates to the facility of the employee, not the facility appearing in the accounting strip.

6. Click Report.

Payroll Reports

Results yield several different reports including Employee Hours and Leave, Employee and Facility, Pay Type Totals, and Facility Totals.

The Employee Hours and Leave report displays the following columns of data: payroll Run, Date, Facility, Pay Type, EIN, Name, Job, H/S, Hours/Day, Hours, Standard, Time And A Half, Double, and Holiday.

Payroll Reports

The Employee and Facility report displays the following columns of data: payroll Run, Date, Name, EIN, Facility, Pay Type, Job, H/S, Hours/Day, Hours, Standard, Time And A Half, Double, and Holiday.

Payroll Reports

The Pay Type Totals report displays the following columns of data: payroll Run, Date, Facility, Pay Type, H/S, Hours/Day, Hours, Standard, Time And A Half, Double, and Holiday.

Payroll Reports

The Facility Totals report displays the following columns of data: payroll Run, Date, Facility, H/S, Hours/Day, Hours, Standard, Time And A Half, Double, and Holiday.

Payroll Reports

The Totals of the Hours, Standard, Time And A Half, Double, and Holiday columns displays in the last row of each report.

Payroll Reports
Adjustments Edit Report

The Adjustments Edit report displays a list of payroll adjustments that were done by an employee as well as adjustment batches generated via Payroll > Run Payroll > Adjustments tab.

1. Select Adjustments Edit from the pull-down.

2. Select the applicable Fiscal Year from the pull-down from which you'd like data pulled, and select the Pay Run(s) from the pull-down.

Payroll Reports

3. OR enter a Check Date range in the provided text boxes.

4. Select the applicable Employee(s) from the pull-down. Selecting employees from the filter is optional.

5. Click Report.

Payroll Reports

Results yield two different reports: Employee Adjustments and Batch Totals.

The Employee Adjustments report displays the following columns of data: payroll Run, Date, Batch, EIN, Employee, Job, Pay Type, Type, Supplement, Deduction, Description, and Amount.

Payroll Reports

The Batch Totals report displays the following columns of data: payroll Run, Date, Batch, Description, Wage Adjustments Entries, Wage Adjustments Amount, Supplement Adjustments Entries, Supplement Adjustments Amount, Deduction Adjustments Entries, Deduction Adjustments Amount, Total Entries, and Total Amount.

Payroll Reports

The Totals of select columns display in the last row of each report.

Payroll Reports
Substitute Pay Edit Report

The Substitute Pay Edit report displays a list of substitutes, their hours, and the employees for whom they substituted. This list is grouped by the facility. This data is entered via Payroll > Run Payroll > Subs tab.

1. Select Substitute Pay Edit from the pull-down.

2. Select the applicable Fiscal Year from the pull-down from which you'd like data pulled, and select the Pay Run(s) from the pull-down.

Payroll Reports

3. OR enter a Check Date range in the provided text boxes.

4. Select the applicable Employee(s) from the pull-down. Selecting employees from the filter is optional.

5. Select the applicable facilities from the Primary Facility pull-down. Selecting facilities from the pull-down is optional. If no facilities are selected, the report runs for all facilities. Note: The Primary Facility pull-down equates to the facility of the employee, not the facility appearing in the accounting strip.

6. Click Report.

Payroll Reports

Results yield two different reports: Substitute Assignments and Substitute Totals.

The Substitute Assignments report displays the following columns of data: payroll Run, Chk Date, Facility, Substitute Employee number, Substitute Name, Substitute Job, Substitute Sub Date, Replaced Employee number, Replaced Job code, Replaced Name, Rec, Allocation Percent, Allocation accounting strip (such as Fund, Function, Object, etc.), Reason, and Time.

Payroll Reports

The Substitute Totals report displays the following columns of data: payroll Run, Chk Date, Employee, Name, Entries, and Total Hours.

The Totals of select columns display in the last row of each report.

Payroll Reports
Misc Pay Report

The Misc Pay report displays a list of additional payments made to the employee, which are outside of his/her contract. This report is grouped by the batch from which the payment was entered. This data is entered via Payroll > Run Payroll > Misc Pay tab.

1. Select Misc Pay from the pull-down.

2. Select the applicable Fiscal Year from the pull-down from which you'd like data pulled, and select the Pay Run(s) from the pull-down.

Payroll Reports

3. OR enter a Check Date range in the provided text boxes.

4. Select the applicable Employee(s) from the pull-down. Selecting employees from the filter is optional.

5. Click Report.

Results yield two different reports: Employee Miscellaneous Pay and Batch Totals.

The Employee Miscellaneous Pay report displays the following columns of data: payroll Run, Date, Batch, EIN, Employee, Job, accounting strip (such as Fund, Function, etc.), SSI, Retirement, Insurance, and Amount.

Payroll Reports

The Batch Totals report displays the following columns of data: payroll Run, Date, Batch, Entries, and Total.

The Totals of select columns display in the last row of each report.

Payroll Reports
Reimbursements Report

The Reimbursements report displays reimbursements issued per payroll run for each employee along with reimbursement information, such as the reimbursement code. Batch Totals are also included. This data is entered via Payroll > Run Payroll > Reimbursement tab.

1. Select Reimbursements from the pull-down.

2. Select the applicable Fiscal Year from the pull-down from which you'd like data pulled, and select the Pay Run(s) from the pull-down.

Payroll Reports

3. OR enter a Check Date range in the provided text boxes.

4. Select the applicable Employee(s) from the pull-down. Selecting employees from the filter is optional.

5. Select the applicable facilities from the Primary Facility pull-down. Selecting facilities from the pull-down is optional. If no facilities are selected, the report runs for all facilities. Note: The Primary Facility pull-down equates to the facility of the employee, not the facility appearing in the accounting strip.

6. Click Report.

Results yield two different reports: Employee Reimbursements and Batch Totals.

The Employee Reimbursements report displays the following columns of data: payroll Run, Date, Batch, EIN, Employee, Job code, Reimbursement Code, the applicable accounting strip (such as Fund, Function, etc.), the % (percentage), and the Amount.

Payroll Reports

The Batch Totals report displays the following columns of data: payroll Run, Date, Batch, Entries, and Total.

Payroll Reports

The Totals of select columns display in the last row of each report.

Payroll Reports
Calculation Control Report

The Calculation Control report generates three separate reports. The first report displays a list of the total deductions and contributions that were taken for a given run; it also includes the fiscal year and the calendar year totals. The second report displays the total gross, FICA, Medicare, taxable, retirement, insurance, and net wages, along with the fiscal year and calendar year totals. The final report displays a list of error and warning messages for a given run. This report is commonly used by the payroll department to estimate grand totals and to ensure the payroll is in balance.

1. Select Calculation Control from the pull-down.

2. Select the applicable Fiscal Year from the pull-down from which you'd like data pulled, and select the Pay Run(s) from the pull-down.

Payroll Reports

3. OR enter a Check Date range in the provided text boxes.

4. Select the applicable Employee(s) from the pull-down. Selecting employees from the filter is optional.

5. Click Report.

Payroll Reports

Results yield three different reports: Deduction Amounts, Gross and Net Totals, and the Exception List.

The Deduction Amounts report displays the following columns of data: payroll Run, Date, Deduction, Description, A/P Cycle, Current Payroll Deducted, Current Payroll Contributed, Fiscal Year-To-Date Deducted, Fiscal Year-To-Date Contributed, Calendar Year-To-Date Deducted, and Calendar Year-To-Date Contributed.

Payroll Reports

The Gross and Net Totals report displays the following columns of data: payroll Run, Date, Description, FICA Gross, Medicare Gross, Taxable Gross, Retirement Gross, Insurance Gross, Total Gross, Deducted, Contributed, Net Pay, and Total Cost.

Payroll Reports

The Exception List displays the following columns of data: payroll Run, Date, Type, Code, and the Message.

The Totals of select columns display in the last row of each report.

Payroll Reports
Proof Register Report

The Proof Register report displays a list of earnings broken down by earnings type (salary, overtime, misc. pay, dockage, etc.). The report is grouped by the facility.

1. Select Proof Register from the pull-down.

2. Select the applicable Fiscal Year from the pull-down from which you'd like data pulled, and select the Pay Run(s) from the pull-down.

Payroll Reports

3. OR enter a Check Date range in the provided text boxes.

4. Select the applicable Employee(s) from the pull-down. Selecting employees from the filter is optional.

5. Select the applicable facilities from the Primary Facility pull-down. Selecting facilities from the pull-down is optional. If no facilities are selected, the report runs for all facilities. Note: The Primary Facility pull-down equates to the facility of the employee, not the facility appearing in the accounting strip.

6. Click Report.

Payroll Reports

Results yield three different reports: Employee Wages, Pay Type Totals By Facility, and Facility Totals.

The Employee Wages report displays the following columns of data: payroll Run, Date, Facility, Pay Type, EIN, Job, Name, Salary, Reg Hourly, Standard, Supplement, Misc Pay, Total Gross, and Variance.

Payroll Reports

The Pay Type Totals By Facility report displays the following columns of data: payroll Run, Date, Facility, Pay Type, Employees, Salary, Reg Hourly, Standard, Supplement, Misc Pay, Total Gross, and Variance.

The Facility Totals report displays the following columns of data: payroll Run, Date, Facility, Employees, Salary, Reg Hourly, Standard, Supplement, Misc Pay, Total Gross, and Variance.

Payroll Reports

The Totals of select columns display in the last row of each report.

Payroll Reports
Gross To Net Report

The Gross To Net report displays a list of the employees' gross earnings, net earnings, and individual deductions that were taken from the gross to calculate the net amount. The data is presented in 3 separate reports. The first report is broken down by facility, pay type, and employe/job. The second report is broken down by facility and pay type. The third report is broken down by facility.

1. Select Gross To Net from the pull-down.

2. Select the applicable Fiscal Year from the pull-down from which you'd like data pulled, and select the Pay Run(s) from the pull-down.

Payroll Reports

3. OR enter a Check Date range in the provided text boxes.

4. Select the applicable Employee(s) from the pull-down. Selecting employees from the filter is optional.

5. Select the applicable facilities from the Primary Facility pull-down. Selecting facilities from the pull-down is optional. If no facilities are selected, the report runs for all facilities. Note: The Primary Facility pull-down equates to the facility of the employee, not the facility appearing in the accounting strip.

6. Click Report.

Results yield three different reports: Employee Wages, Pay Type Totals By Facility, and Facility Totals.

The Employee Wages report displays the following columns of data: payroll Run, Date, Facility, Pay Type, EIN, Name, Job, Gross Wages, Gross Taxable, Gross Social Security, Gross Medicare, Gross Retirement, Gross Insurance, Net, Class, Deduction, and Amount.

Payroll Reports

The Pay Type Totals By Facility report displays the following columns of data: payroll Run, Date, Facility, Pay Type, Employees, Gross Wages, Gross Taxable, Gross Social Security, Gross Medicare, Gross Retirement, Gross Insurance, Net, and Deductions.

The Facility Totals report displays the following columns of data: payroll Run, Date, Facility, Employees, Gross Wages, Gross Taxable, Gross Social Security, Gross Medicare, Gross Retirement, Gross Insurance, Net, and Deductions.

Payroll Reports

The Totals of select columns display in the last row of each report.

Payroll Reports
Check Register Report

The Check Register report displays a list of earnings broken down by earnings type (salary, overtime, misc. pay, dockage, etc.). The data is presented in 3 separate reports. The first report is broken down by facility, employee, and job group. The second report is broken down by facility and employee. The third report is broken down by facility.

If the Direct Deposit: Can View Account Number profile permission is enabled via Setup > Profiles > Human Resources tab, you can view Direct Deposit account numbers on the Check Register report and Human Resources > Employee > Check History.

1. Select Check Register from the pull-down.

2. Select the applicable Fiscal Year from the pull-down from which you'd like data pulled, and select the Pay Run(s) from the pull-down.

Payroll Reports

3. OR enter a Check Date range in the provided text boxes.

4. OR enter a Check Number range in the provided text boxes.

5. Select the applicable Employee(s) from the pull-down. Selecting employees from the filter is optional.

6. Select the applicable facilities from the Primary Facility pull-down. Selecting facilities from the pull-down is optional. If no facilities are selected, the report runs for all facilities. Note: The Primary Facility pull-down equates to the facility of the employee, not the facility appearing in the accounting strip.

7. Select the applicable Bank(s) from the pull-down. Selecting banks from the pull-down is optional. If no banks are selected, the report runs for all banks.

8. Select the user(s) responsible for the payroll run from the Created/Run By pull-down. Selecting users from the pull-down is optional. If no users are selected, the report runs for all users.

9. Select No from the Reconciled pull-down to pull checks that have not been reconciled via Budgeting/General Ledger > Bank Reconciliation or Internal Account Bank Reconciliation.

10. Select whether or not you want to pull checks that have been Voided from the pull-down.

11. Select the check box to display Element Description in the generated reports; i.e. to include the description for Fund, Function, Object, etc., as opposed to only displaying the code number.

12. Click Report.

Results yield three different reports: Pay Runs, Checks, and Facility Totals.

The Pay Runs report displays the following columns of data: Fiscal Year, payroll Run, Type, Date, District, Facility, Name, EIN, Pay Type, Pay Status, Checks, Gross Pay, Taxable Gross, FICA Gross, Medicare Gross, Fed Withholding, Pre-Tax Deductions, FICA Deductions, FICA Contributions, Medicare Deductions, Medicare Contributions, Retirement Deductions, Retirement Contributions, Insurance Deductions, Insurance Contributions, All Other Deductions, All Other Contributions, and Net Pay.

Payroll Reports

The Checks report displays the following columns of data: Fiscal Year, payroll Run, Date, Facility, Name, EIN, check Number, Check Payer Bank, Check Payee Bank, Check Account, Check Cash Acct,  Check Reconciled, Check Voided, Check Amount, Descr, Allocation Journal ID, Allocation accounting strip (such as Fund, Function, Object, etc.), Allocation amount, Allocation Deduction, Net Allocation, and Allocation Contribution.

Payroll Reports

The Facility Totals report displays the following columns of data: payroll Run, Type, Date, District, Facility, Checks, Gross Pay, Taxable Gross, FICA Gross, Medicare Gross, Fed Withholding, Pre-Tax Deductions, FICA Deductions, FICA Contributions, Medicare Deductions, Medicare Contributions, Retirement Deductions, Retirement Contributions, Insurance Deductions, Insurance Contributions, All Other Deductions, All Other Contributions, and Total Net Pay.

Payroll Reports

The Totals of select columns display in the last row of each report.

Payroll Reports
Deduction/Contribution Register Report

The Deduction/Contribution Register report displays the deduction/contributions that were processed in selected runs. The data is presented in 4 separate reports. The first report is broken down by deduction/contribution code, employee, job group, and pay type. The second report is broken down by deduction/contribution code and employee. The third report is a total by deduction/contribution codes. The fourth report is a total by deduction/contribution class.

1. Select Deduction/Contribution Register from the pull-down.

2. Select the applicable Fiscal Year from the pull-down from which you'd like data pulled, and select the Pay Run(s) from the pull-down.

Payroll Reports

3. OR enter a Check Date range in the provided text boxes.

4. Select the applicable Employee(s) from the pull-down. Selecting employees from the filter is optional.

5. Select the applicable facilities from the Primary Facility pull-down. Selecting facilities from the pull-down is optional. If no facilities are selected, the report runs for all facilities. Note: The Primary Facility pull-down equates to the facility of the employee, not the facility appearing in the accounting strip.

6. Click Report.

Results yield four different reports: Employee Job Deductions/Contributions, Employee Totals, Deduction Totals, and Deduction Class Totals.

The Employee Job Deductions/Contributions report displays the following columns of data after you click Download to save the large report to your computer: Run Code, Check Date, Class, Subclass, Descr, EIN, Job, Employee, Pay Type, Facility, Deducted, Contributed, and Total.

Payroll Reports
Deduction_Contribution_Register-1588985854772

The report displayed was downloaded because the results were too large to view in a report via Payroll Reports. See Additional Features for more information.

The Employee Totals report displays the following columns of data after you click Download to save the large report to your computer: Run Code, Check Date, Class, Subclass, Descr, EIN, Employee, Deducted, Contributed, and Total.

Deduction_Contribution_Register-1588986477538

The report displayed was downloaded because the results were too large to view in a report via Payroll Reports. See Additional Features for more information.

The Deduction Totals report displays the following columns of data: payroll Run, Date, Class, Subclass, Description, Deducted, Contributed, and Total.

Payroll Reports

The Deduction Class Totals report displays the following columns of data: payroll Run, Date, Class, Description, Deducted, Contributed, and Total.

Payroll Reports

The Totals of select columns display in the last row of each report.

Leave Time Exceptions Report

The Leave Time Exceptions report shows the leave taken in each run. The data is present in 4 separate reports. The first report is broken down by facility, pay type, employee/job group, and the date the leave was taken. The second report displays totals of leave taken by facility, pay type, and employee. The third report displays total leave taken by facility and pay type. The fourth report displays total leave taken by facility.

1. Select Leave Time Exceptions from the pull-down.

2. Select the applicable Fiscal Year from the pull-down from which you'd like data pulled, and select the Pay Run(s) from the pull-down.

Payroll Reports

3. OR enter a Check Date range in the provided text boxes.

4. Select the applicable Employee(s) from the pull-down. Selecting employees from the filter is optional.

5. Select the applicable facilities from the Primary Facility pull-down. Selecting facilities from the pull-down is optional. If no facilities are selected, the report runs for all facilities. Note: The Primary Facility pull-down equates to the facility of the employee, not the facility appearing in the accounting strip.

6. Click Report.

Results yield four different reports: Leave Exceptions, Employee Totals, Pay Type Totals, and Facility Totals.

The Leave Exceptions report displays the following columns of data: payroll Run, Date, Facility, Pay Type, Absent, EIN, Employee, Job, Hours Per Day, Substitute, Hours, and the accounting strip (such as Fund, Function, Object, etc.).

Payroll Reports

The Employee Totals report displays the following columns of data: payroll Run, Date, Facility, Pay Type, EIN, Employee, Total Leave, and Hours Per Day.

Payroll Reports

The Pay Type Totals report displays the following columns of data: payroll Run, Date, Facility, Pay Type, Total Leave, and Hours Per Day.

Payroll Reports

The Facility Totals report displays the following columns of data: payroll Run, Date, Facility, Total Leave, and Hours Per Day.

The Totals of select columns display in the last row of each report.

Payroll Reports
Invoice Generation For Deductions Report

The Invoice Generation For Deductions Report displays the invoiced, uninvoiced (remaining), and total deduction amounts, as well as the totals. Each section of the report displays deduction and invoice amount details based on accounting strip elements: Class Totals, Fund/Project Totals, and Fund Totals.

1. Select Invoice Generation For Deductions from the pull-down.

2. Select the applicable Fiscal Year from the pull-down from which you'd like data pulled, and select the Pay Run(s) from the pull-down.

Payroll Reports

3. OR enter a Check Date range in the provided text boxes.

4. Select the applicable facilities from the Facility pull-down. Selecting facilities from the pull-down is optional.

5. Click Report.

Results yield five different reports: Invoices, Deduction Totals, Class Totals, Fund/Project Totals, and Fund Totals.

The Invoices report displays the following columns of data: payroll Run, Chk Date, Invoice, Inv Date, Vendor, Name, Deduction, Batch, Cycle, Fund, G/L, Project (or applicable accounting strip element), Offset, Invoiced amount, Remaining amount, and Total amount.

Notification Center

The Deduction Totals report displays the following columns of data: payroll Run, Chk Date, Deduction, Invoiced amount, Remaining amount, and Total amount.

Payroll Reports

The Class Totals report displays the following columns of data: payroll Run, Chk Date, Deduction Class, Invoiced amount, Remaining amount, and Total amount.

The Fund/Project Totals report displays the following columns of data: payroll Run, Chk Date, Fund, Project, Invoiced amount, Remaining amount, Total amount.

Payroll Reports

The Fund Totals report displays the following columns of data: payroll Run, Chk Date, Fund, Invoiced amount, Remaining amount, Total amount.

Payroll Reports

The Totals of select columns display in the last row of each report.

Payroll Reports
Salaries And Benefits Report

The Salaries And Benefits report displays salaries and benefits broken down by account then employee, as well as by fund total and project total.

1. Select Salaries And Benefits from the pull-down.

2. Select the applicable Fiscal Year from the pull-down from which you'd like data pulled, and select the Pay Run(s) from the pull-down.

Payroll Reports

3. OR enter a Check Date range in the provided text boxes.

4. Select the applicable Employee(s) from the pull-down. Selecting employees from the filter is optional.

5. Select the applicable facilities from the Primary Facility pull-down. Selecting facilities from the pull-down is optional. If no facilities are selected, the report runs for all facilities. Note: The Primary Facility pull-down equates to the facility of the employee, not the facility appearing in the accounting strip.

6. Click Report.

Results yield three different reports: Salary And Benefits, Fund Totals, and Project Totals.

The Salary And Benefits report displays the following columns of data: Fiscal Year, Run code, Description, Check Date, the applicable accounting strip (such as Fund, Function, Object, etc.), EIN, Employee, Job code, Titles, Salary, RETIREMENT (21x), SOCIAL SECURITY (22x), GROUP INSURANCE (23x), WORKERS' COMPENSATION (24x), and Misc Benefit.

Payroll Reports

The Fund Totals report displays the following columns of data: Project, Fund, Salary, RETIREMENT (21x), SOCIAL SECURITY (22x), GROUP INSURANCE (23x), WORKERS' COMPENSATION (24x), and Misc Benefit.

Payroll Reports

The Project Totals report displays the following columns of data: Project, Salary, RETIREMENT (21x), SOCIAL SECURITY (22x), GROUP INSURANCE (23x), WORKERS' COMPENSATION (24x), and Misc Benefit.

Payroll Reports

The Totals of select columns display in the last row of each report.

Payroll Reports
Encumbrances Report

The Encumbrance report displays the remaining salary and benefit costs for the year that has been encumbered. The data is presented in 3 separate reports. The first report is broken down by facility, employee/job, and allocation strip. The second report is a total by facility and employee. The third report is total by facility.

1. Select Encumbrances from the pull-down.

2. Select the applicable Fiscal Year from the pull-down from which you'd like data pulled.

Payroll Reports

3. Select the applicable Employee(s) from the pull-down. Selecting employees from the filter is optional.

4. Select the applicable facilities from the Primary Facility pull-down. Selecting facilities from the pull-down is optional. If no facilities are selected, the report runs for all facilities. Note: The Primary Facility pull-down equates to the facility of the employee, not the facility appearing in the accounting strip.

5. Click Report.

Results yield three different reports: Encumbrances, Employee Totals, and Facility Totals.

The Encumbrances report displays the following columns of data: the Contract Year, Job Center, EIN, Employee, Job Index, Job Title, applicable accounting strip (such as Fund, Function, Object, etc.), Benefits, and Salary.

Payroll Reports

The Employee Totals report displays the following columns of data: Contract Year, Job Center, EIN, Employee, Benefits, and Salary.

Payroll Reports

The Facility Totals report displays the following columns of data: Contract Year, Job Center, Benefits, and Salary.

Payroll Reports

The Totals of select columns display in the last row of each report.

Run Differences Report

The Run Differences report allows users to compare wages, deductions, and contribution amounts between two different pay runs.  The selected runs can exist within the same or different fiscal years.

1. Select Run Differences from the pull-down.

2. Select the applicable 1st Fiscal Year from the pull-down from which you'd like data pulled, and select the 1st Pay Run from the pull-down.

Payroll Reports

3. Select the applicable 2nd Fiscal Year from the pull-down from which you'd like data pulled, and select the 2nd Pay Run from the pull-down.

4. Enter the Threshold in the provided text box and select the applicable radio button to determine the type of threshold: Amount or Percentage.

5. Select the applicable Employee(s) from the pull-down. Selecting employees from the filter is optional.

6. Select the applicable Wage Type/Deduction from the pull-down.

7. Select the Show Only Changes check box to limit the report to employees that had a change between the 1st Pay Run selected and the 2nd Pay Run selected. The check box is selected by default.

8. Click Report.

Payroll Reports

The Run Difference report displays the following columns of data: EIN, Name, Job, Type, 1st and 2nd pay runs selected and the date, the Difference, and the Percentage.

Payroll Reports

The Totals of select columns display in the last row of the report.

Payroll Reallocations Report

The Payroll Reallocations report displays the results of employee pay being reallocated to different accounts (via Check Voids and Reallocations) for balancing and auditing purposes.

1. Select Payroll Reallocations from the pull-down.

2. Select the applicable Fiscal Year from the pull-down from which you'd like data pulled, and select the Pay Run(s) from the pull-down.

Payroll Reports

3. OR enter a Check Date range in the provided text boxes.

4. Select the applicable Employee(s) from the pull-down. Selecting employees from the filter is optional.

5. Click Report.

Payroll Reports

The Payroll Reallocations report displays the following columns of data: Fiscal Year, payroll Run, Payroll Run Date, Payroll Reallocation Batch, Posted On, Prepared By, Employee, Checks, Wage Type, Debit, Credit, the applicable accounting strip (Fund, Function, Object, etc.), and Allocation.

Payroll Reports
Net Pay By Fund Report

Displays employees' net pay by Fund, which includes the following information: Fund, Gross pay, pay cycles, Due Now, Due EOM, Net pay, and Total Cost.

The Net Pay By Fund report pulls allocations information from wage allocations if no deductions are present.

1. Select Net Pay By Fund from the pull-down.

2. Select the applicable Fiscal Year from the pull-down from which you'd like data pulled, and select the Pay Run(s) from the pull-down.

Payroll Reports

3. OR enter a Check Date range in the provided text boxes.

4. Select the applicable Employee(s) from the pull-down. Selecting employees from the filter is optional.

5. Select the applicable facilities from the Primary Facility pull-down. Selecting facilities from the pull-down is optional. If no facilities are selected, the report runs for all facilities. Note: The Primary Facility pull-down equates to the facility of the employee, not the facility appearing in the accounting strip.

6. Click Report.

The Net Pay By Fund report displays the following columns of data: Fund, Gross, applicable cycles, Due Now, Due EOM, Net, and Total Cost.

Payroll Reports

The Totals of select columns display in the last row of the report.

Payroll Reports
Salaried Employees Report

The Salaried Employees report lists all active salaried employees by pay type per run.

1. Select Salaried Employees from the pull-down.

2. Select the applicable Fiscal Year from the pull-down from which you'd like data pulled, and select the Pay Run(s) from the pull-down.

Payroll Reports

3. Select the applicable facilities from the Primary Facility pull-down. Selecting facilities from the pull-down is optional. If no facilities are selected, the report runs for all facilities. Note: The Primary Facility pull-down equates to the facility of the employee, not the facility appearing in the accounting strip.

4. Click Report.

The Employees report displays the following columns of data: payroll Run, Pay Type, Facility, EIN, Employee, and Hours Worked.

Payroll Reports
Payroll Site Employee Verification Report

The Payroll Site Employee Verification Report lists all active hourly employees as well as salaried employees by pay type per run.

1. Select Payroll Site Employee Verification Report from the pull-down.

2. Select the applicable Fiscal Year from the pull-down from which you'd like data pulled, and select the Pay Run(s) from the pull-down.

Payroll Reports

3. Select the applicable facilities from the Position Facility pull-down. Selecting facilities from the pull-down is optional. If no facilities are selected, the report runs for all facilities. Note: The Position Facility pull-down equates to the facility of the position to the employee.

4. Click Report.

Payroll Reports

The Employees report displays the following columns of data: payroll Run, Pay Type, Facility, EIN, Employee, Salary or Hourly, and Hours/Day, Job Starts, Job Ends, and Hours Worked.

Payroll Reports
Voided Check Gross Totals Report

The Voided Check Gross Totals Report lists the gross and net totals of voided checks by pay run.

1. Select Voided Check Gross Totals from the pull-down.

2. Select the applicable Fiscal Year from the pull-down from which you'd like data pulled, and select the Pay Run(s) from the pull-down.

Payroll Reports

3. OR enter a Check Date range in the provided text boxes.

Payroll Reports

4. OR enter a Check Number range in the provided text boxes.

Payroll Reports

5. Select the applicable Employee(s) from the pull-down. Selecting employees from the filter is optional.

Payroll Reports

6. Select the applicable Bank(s) from the pull-down. Selecting banks from the pull-down is optional. If no banks are selected, the report runs for all banks.

7. Click Report.

Payroll Reports

The Gross and Net Totals report displays the Fiscal Year, pay Run; Type; employee Name; EIN (Employee Identification Number); Gross Totals: Total Gross, FICA Gross, Medicare Gross, Taxable Gross, Retirement Gross, Insurance Gross; Net Pay; Check Info: Check #, Date, Voided On, Diff Qtr indicator.

Payroll Reports
Daily Pay By Schedule

The Daily Pay By Schedule report allows the district to ensure accuracy in payroll processing by confirming that employees are compensated for the correct days worked or scheduled according to their assigned schedules. This helps to minimize errors and discrepancies in employee payments and promotes transparency and accountability in payroll management.

1. Select Daily Pay By Schedule from the pull-down.

2. Select the applicable Fiscal Year from the pull-down from which you'd like data pulled, and select the Pay Run(s) from the pull-down.

Payroll Reports

3. OR enter a Check Date range in the provided text boxes.

Payroll Reports

4. Select the Show Only Discrepancies check box to display only the discrepancies or differences between the scheduled days and the days actually paid in the payroll.

Payroll Reports

5. Click Report.

Payroll Reports

The report displays in two sections: Paid Employees and Unpaid Employees.

The Paid Employees section displays the payroll Run, Date, EIN, Employee name, Job code, Pay Type, Position, Start date, End date, Scheduled, Charged, and Difference.

Payroll Reports

The Unpaid Employees section displays the payroll Run, Date, EIN, Employee name, Job code, Pay Type, Position, Start date, End date, and Scheduled Days.

Payroll Reports
Additional Features

If the results yielded by your search are too large to display as a report via Focus, a warning message displays: Results are too large to display. Click the "DOWNLOAD" button to the right to download the whole report, or select specific runs, facilities or employees, or narrow the date range.

Payroll Reports

Click Download as described to download the file onto your computer.

Use the Filter text box located in select pull-down to quickly find a selection. Begin typing the name or number of the data in question to pull it to the beginning of the list.

Payroll Reports

Click the Check all visible link to select all options in the pull-down. Click Clear selected to remove any selections made in the pull-down.

Payroll Reports

If there are multiple pages of data, click the Prev and Next buttons to sift through pages. You can also enter a number in the Page text box to jump to a page.

Payroll Reports

Click the Excel icon in the Export section to export the table of data to an Excel spreadsheet, which can then be saved to your computer.

Payroll Reports

Click the Printer icon to print the table of data.

Click the Filters button to filter data and apply filter rules.

a. To add more than one filter to a column, click on the green plus sign.

b. To delete an added filter, click on the red minus sign.

c. Select the gray arrow for additional filtering rules.

Payroll Reports

For more information on how to use the Filters feature, see the Filters document.

The Page Size defaults to 20 results per page. To display a different number of results per page, click the Page Size text box and enter a different number. When you change the Page Size, the number of pages displayed will change as well.

Payroll Reports

You can sort data by clicking on any of the headers with the double black arrows. Click once for ascending results; click twice for descending results.

Payroll Reports
Previous Article Verification Reports
Next Article Payroll Costing Export