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.
1. From the Payroll menu, click Payroll Reports.
2. Select the applicable report from the pull-down.
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.
3. Enter the report criteria/filters, and click Report.
4. The report generates. To edit the report criteria and rerun the report, click the arrowed tab to reopen the report criteria.
See the following sections for more information on each of the available reports: Time Exceptions Edit Report, Adjustments Edit Report, Substitute Pay Edit Report, Misc Pay Report, Reimbursements Report, Reimbursements Report, Calculation Control Report, Proof Register Report, Gross To Net Report, Check Register Report, Deduction/Contribution Register Report, Leave Time Exceptions Report, Invoice Generation For Deductions Report, Salaries And Benefits, Encumbrances Report, Run Differences, Payroll Reallocations, Net Pay By Fund, and Salaried Employees.
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.
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.
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.
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.
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.
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.
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.
The Totals of the Hours, Standard, Time And A Half, Double, and Holiday columns displays in the last row of each 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.
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 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.
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.
The Totals of select columns display in the last row of each 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.
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: Substitute Assignments and Substitute Totals.
The Substitute Assignments report displays the following columns of data: payroll Run, Chk Date, Facility, Substitute Employee number, Sub Name, Sub Job, 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.
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.
The Run Totals displays the payroll Run number, Chk Date, Entries, and Total Hours.
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.
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.
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.
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.
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.
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.
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.
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 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.
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.
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.
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.
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, Job, Name, Salary, Reg Hourly, Standard, Supplement, Misc Pay, Total Gross, and Variance.
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.
The Totals of select columns display in the last row of each 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.
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.
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.
The Totals of select columns display in the last row of each 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.
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.
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.
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.
The Totals of select columns display in the last row of each 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.
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.
The report displayed was downloaded because the results were too large to view in a report via Payroll Reports.
Whether or not the data displays or must be downloaded depends on the Deduction/Contribution PDF Download Threshold setting enabled via Setup > Settings > Payroll tab > Payroll Reports section.
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.
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.
The Deduction Class Totals report displays the following columns of data: payroll Run, Date, Class, Description, Deducted, Contributed, and Total.
The Totals of select columns display in the last row of each 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.
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.).
The Employee Totals report displays the following columns of data: payroll Run, Date, Facility, Pay Type, EIN, Employee, Total Leave, and Hours Per Day.
The Pay Type Totals report displays the following columns of data: payroll Run, Date, Facility, Pay Type, Total Leave, and Hours Per Day.
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.
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.
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.
The Deduction Totals report displays the following columns of data: payroll Run, Chk Date, Deduction, Invoiced amount, Remaining amount, and Total amount.
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.
The Fund Totals report displays the following columns of data: payroll Run, Chk Date, Fund, Invoiced amount, Remaining amount, Total amount.
The Totals of select columns display in the last row of each 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.
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.
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.
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.
The Totals of select columns display in the last row of each 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.
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.
The Employee Totals report displays the following columns of data: Contract Year, Job Center, EIN, Employee, Benefits, and Salary.
The Facility Totals report displays the following columns of data: Contract Year, Job Center, Benefits, and Salary.
The Totals of select columns display in the last row of each 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.
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.
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.
The Totals of select columns display in the last row of the 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.
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.
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.
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.
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.
The Totals of select columns display in the last row of the report.
The Net Pay By Project report includes the Project, Fund, Gross pay, Cycle R, Cycle W, Due Now, Due EOM, Deductions, Contributions, Net pay, and Total Cost.
1. Select Net Pay By Project 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.
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 Project report displays the following columns of data: Project, Fund, Gross, Cycle R, Cycle W, Due Now, Due EOM, Deductions, Contributions, Net, and Total Cost.
The Totals of select columns display in the last row of the 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.
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.
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.
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.
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.
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.
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 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.
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.
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.
3. OR enter a Check Date range in the provided text boxes.
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.
5. Click Report.
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.
The Unpaid Employees section displays the payroll Run, Date, EIN, Employee name, Job code, Pay Type, Position, Start date, End date, and Scheduled Days.
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.
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.
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.
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.
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.
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.
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.
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.
