Filter or group the input sheet

Filter or group the input sheet

How to group the input sheet

By default, the input sheet will be grouped by employee. This means the list on the left displays each employee (with multiple lines if they have multiple departments) and is organized alphabetically. You can also group by department, which will show each department (organized by department code) grouped together. If grouped by department, employees working in multiple departments will have an entry per department.  

1. On the input sheet, click the Group by dropdown and select the grouping you wish to see.


2. Click Add.

How to filter on the input sheet

1. On the input sheet, under Filter, click Add.

2. You can filter by department, or by employee. If you wish, you can also combine both filters.

  1. By Department: Move the departments you wish to see over from Available to Assigned by double clicking or by using the arrows available. Select one of the three options:

    1. Show Only Home Departments: Employees with multiple departments will only be displayed if their home department matches your search term.
    2. Show Only These Departments: Employees with multiple departments will be shown if one of their departments matches your search term.
    3. Show All Departments For Employees Who Belong To These Departments: Employees with multiple departments will be shown if one of their departments that matches your search term, and they will show with all other departments they work in also displayed.

  2. By Employee: Enter your search term in First Name, Last Name or both. The system will only show results that match your search terms (you can enter partial names).


3. Click Save.


    • Related Articles

    • Add an employee to the input sheet

      1. On the Payroll Input page, click Add Employees. 2. Filter to the employment status of the employee you wish to add, or select -- any employment status -- to see all employees who are not on the current run. 3. Select the appropriate employee, move ...

    • Regenerate the input sheet

      You may have seen the Regenerate button on your input sheet and wondered, "What are the implications of pressing it?" Thankfully, there is a warning that pops-up and details all the affects this button has, but we'll also reiterate them below. Any ...

    • Add payroll instructions to the input sheet

      Adding an instruction to the input sheet If a payroll instruction is not scheduled to appear on this run (or potentially not scheduled to appear on any run by default, as is the case with "occasional" payroll instructions) it will be available to add ...

    • Refresh or remove an employee on the input sheet

      Refreshing employee information If you make any changes to an employee's profile after you have created the input sheet, you will need to "refresh" the employee by removing them from the input sheet and adding them back in. When you refresh an ...

    • Import a CSV file into the input sheet

      Export as CSV 1. Create a regular or ad-hoc pay run. 2. Enter the input sheet by clicking Input Sheet. 3. Click Export as CSV. You will be downloading a file and depending on computer settings may be prompted for a save location. If not, it will be ...