Generate Timesheets

Overview

The Generate Timesheets utility enables administrators or supervisors to generate timesheets for employees for the current timesheet period, the previous period, or the upcoming period. A common use of this utility is to facilitate timesheet entry for employees who consistently enter time against the same charge codes.

You can generate timesheets with charge codes only or with both charge codes and default hours. You can also save sets of employee selection criteria and reuse them when you generate timesheets in the future.

To open the Generate Timesheets dialog box, click Time » Record Time » Generate Timesheets on the main menu.

Employees for Whom You Can Generate Timesheets

You can generate timesheets with hours for employees assigned to a timesheet class for which Generate Exception-Based Timesheets is checked on the Basic Information tab of the Timesheet Classes screen. The hours assigned are based on each employee's work schedule, charge favorites, and the work percentages associated with his or her charge favorites.

You can generate timesheets without hours for any employee. Companies that do this often print the timesheets and distribute them to employees as a worksheet for recording their hours for the period. In this case, Time & Expense with ESS prints the timesheets in a special format designed for recording hours by hand.

Set Up Timesheet Generation

To set up Time & Expense with ESS to provide timesheet generation, do the following:

Generate Timesheets

To generate timesheets, do the following:

  1. On the main menu, click Time » Record Time » Generate Timesheets.

  2. If you want to use an existing saved set of parameters to generate timesheets, click search-act.gifSearch and use the Parameter Code Search dialog box to select that set of parameters. Skip to step 4.

If you want to enter a new set of parameters, continue with step 3.

  1. Under Criteria, select the criteria you want to use to select employees and generate timesheets. For details, see Generate Timesheets Screen.

  2. Click Execute to display a list of candidates in the Results grid.

  3. Check the box in the first column next to those employees for whom you want to generate timesheets.

  4. Click Generate to generate the timesheets.

  5. If you want to preview or print the Generate Timesheet report to make sure all the timesheets were generated successfully, click Preview/Print and select the Summary Report option.

  6. If you want to save the set of parameters you entered under Criteria so you can use it again at a later date, click save.gifSave, and make the required entries in the Save Parameters dialog box. For details, see Save Parameters Dialog Box.

  7. If you want to notify employees that timesheets are awaiting their signatures or supervisors that timesheets are ready to be approved, you can use the Time Sheet Status inquiry screen. Click Audit » Timesheet Status on the main menu to open that screen.

  8. If you want to print the timesheets you just generated, click Preview/Print. If you generated timesheets with hours, select Timesheets in the Print dialog box. If you generated timesheets without hours, select Pre-Printed Timesheets in the Print dialog box. (If you generate and print timesheets without hours, they are printed in a worksheet format designed for recording hours by hand.)

A Timesheet Will Not Be Generated If...

If you are generating timesheets with hours, a timesheet won't be generated for an employee if any of the following are true:

If you are generating timesheets without hours, a timesheet won't be generated for an employee if any of the following are true:

Generate Timesheets Screen

Use these application options to add new sets of parameters, display existing sets of paramenters, save new or changed sets of parameters, or remove sets of parameters.

New

Click new.gif New to reset the screen so you can begin entering a new set of parameters.

If unsaved entries exist when you click new.gif New, a message appears asking if you want to save your work.

Save

Click the save.gif Save option to save a new or changed set of parameters.

If you are adding a new set, the Save Parameters dialog box opens so you can enter a code, descriptions, and other properties.

The Save Parameters dialog box also opens if you try to save changes to a set of parameters that you did not create. Because you cannot change a set of parameters you did not create, you must instead add a new set by assigning a new code to the modified set.

Delete

To delete a saved set of parameters, display that set in the Generate Timesheets screen and click delete.gifDelete.

The only system user who can delete or change a set of parameters is the user who created it.

Search

If you want to use an existing saved set of parameters to generate timesheets, click  search-act.gifSearch. In the Parameter Code Search dialog box, select the set of parameters you want to use and click OK.

The only parameter sets available for selection are the following:

If unsaved entries exist when you click Search, a message appears asking if you want to save your work.

 

Use these screen components to select employees and generate timesheets:

Timesheet Schedule

In Timesheet Schedule, enter the timesheet schedule assigned to the employees for whom you are generating timesheets.

Period Ending

In Period Ending, select the payroll period for which you want to generate timesheets for the employees. Your choices are

When you select a saved parameter set, Time & Expense with ESS sets the default period based on the saved period (Previous, Current, or Next) and the current date.

Generate As

The status you want to assign to the generated timesheets: Open, Signed, or Approved.

Generate with Hours

Check Generate with Hours if you want to generate timesheets with both charges and default hours for those charges. After you generate timesheets, you have the option to print them for review or distribution.

Leave the box unchecked if you want timesheets that show charges but no hours. After you generate timesheets, you have the option to print them (so you can distribute them to employees so they can record their hours by hand, for example).

If you check Generate with Hours, you can only generate timesheets for employees assigned to timesheet classes for which the Generate Exception-Based Timesheets check box is checked in the Timesheet Classes screen.

Function

The valid selections in Function are those functional roles that meet both of these criteria:

If you are adding a new set of parameters and you have more than one role that meets these criteria, "Select" appears in Function. In that case, you can select one of them, or you can select "All."

The selected role or roles in turn control which groups are displayed for selection in the Groups list box. The only groups listed are those for which you are assigned one of the selected roles.

Group

In Group, select the employee groups to which the employees belong for whom you want to generate timesheets. You can select one group, all groups, or any combination of them.

Your selection in Function controls which groups are displayed for selection. The only groups listed are those for which you are assigned one of the selected roles.

Use the Select All button to select all groups in the list. To select more than one group but not all, press Ctrl while clicking on the groups to select or deselect groups individually.

Select All (Groups)

Click Select All to select all employee groups shown in the list.

If all groups are selected, the button label changes to Deselect All.

Class

In Class, select the timesheet classes to which the employees for whom you want to generate timesheets are assigned. You can select one class, all classes, or any combination of them.

The Generate with Hours check box controls which classes are displayed for selection:

Use the Select All button to select all classes in the list. To select more than one class but not all, press Ctrl while clicking on the classes to select or deselect classes individually.

Select All (Classes)

Click Select All to select all timesheet classes shown in the list.

If all classes are selected, the button label changes to Deselect All.

Sort

In Sort, indicate whether you want the employees listed under Results by employee ID or employee name.

Execute

Click the Execute button to display a list of employees in Results. The employees are selected based on your entries under Criteria.

Results

When you click Execute, the employees selected based on your entries under Criteria are listed under Results.

To select the employees for whom you want to generate a timesheet, check the box in the first column next each of the employees.

If you want to select most but not all of the employees, you can check the box in the heading area of the grid to select all of them and then clear the boxes for those employees you want to exclude.

Generate

Click Generate to generate a timesheet for the specified timesheet schedule, period, and status for each of the employees you selected under Results.

Preview/Print

Once you have generated timesheets, you can do either of the following:

If you want to print the Generate Timesheet report or the timesheets themselves, you should do so as soon as the timesheets have been generated. Make sure you don't change anything on the Generate Timesheet screen between the completion of the generation process and when you print the report. If you change any settings, the Preview/Print button is no longer available.

Cancel

Click Cancel to close the Generate Timesheets screen without generating timesheets.

Save Parameters Dialog Box

When you click Save in the Generate Timesheets screen, the Save Parameters dialog box opens. Use this dialog box to assign a code, description, and options to a new set of paramenters or to change the description or options for an existing set of parameters:

Code

In Code, enter a unique code to identify the set of parameters you are saving.

Description

In Description, enter a description of the set of parameters you are saving.

Public

If you want other users to have access to the set of parameters you are saving, check Public.

Print Report

The Print Report check box is not used in the current version.

Generate Timesheets Report

After you generate timesheets, you have the option to also produce the Generate Timesheets report in .PDF format. You can then review that report online or print it.

The Generate Timesheets report lists each employee for whom you attempted to generate a timesheet. If the timesheet was generated, the Results column on the report contains "Timesheets Successfully Generated." If Time & Expense with ESS was unable to generate a timesheet for an employee, the Results column provides an explanation so you can correct the problem.