MANAGE TIMESHEET PERIODS

Use this screen to define the cycles or periods of time by which your company enters timesheet data for its employees. Using the Open field in the table window, you can control whether timesheets can be entered for a specific timesheet period. Only timesheets with dates that fall within an open timesheet period can be entered on the Manage Timesheets screen. The timesheet periods and related end dates in this table are also used by the Post Timesheets screen for selecting timesheets to post.

You must set up timesheet cycles (periods) before you can assign a timesheet cycle to an employee on the Manage Employee Information screen. You also must establish timesheet cycles before you can complete the Configure Labor Settings screen.

You can access this screen to view whether or not weighted average has been calculated and applied to a specific timesheet period. The weighted average rate is a rate that is calculated by adding the labor amount from several timesheet lines and dividing that sum by the total number of hours from those timesheet lines. This is an important concept for those employees that perform contract work, for which they receive a different rate for each project.

When you create new timesheet periods in this screen, the Weighted Avg Processed check box defaults to cleared.

Location

Identification

Timesheet Cycle Code

Enter this timesheet cycle code. You must assign one of these timesheet cycles to each active employee on the Manage Employee Information screen. You can establish an unlimited number of timesheet cycles.

Description

Enter a description of this timesheet cycle for reports and other documents conducive to a longer description.

Details

Frequency

From the drop-down list, select the frequency type of the timesheet cycle. Valid options are:

Default Auto-Adjust %

Enter the auto-adjustment percentage to be used as a default entry on the timesheet. Normally, this percentage is set to "100.00." However, if you enter only part of a pay period, enter the percentage that applies to the part you are entering. For example, if you enter half of a pay period, enter "50.00" for the percentage.

This percentage refers to the pay period rather than the timesheet period. Although the pay period is not established in Costpoint Labor, you must associate a pay period with each employee. For example, your timesheet period can be Weekly, but your pay period can be Bi-Weekly. The salary rate recorded on the Manage Employee Salary Information screen refers to the amount of pay in the pay period, not the timesheet period.

Because this percentage is offered only as a default, you can change or override it when entering the timesheet.

Add Timesheet Periods

Use this group box to automatically fill in the Timesheet Periods Details table. Enter values into the following two fields and click Add Periods to automatically fill in the Timesheet Periods Details table.

Number of Periods

Enter the number of timesheet periods in this cycle. This number also designates the number of timesheet periods to automatically populate the Timesheet Periods Details table. For example, if you want to set up a timesheet cycle for recording timesheets on a weekly basis for a normal calendar year, enter "52" in this field. This field is required if you want to use Add Periods button to automatically populate the Timesheet Periods Details table.

First End Date

Enter, or click to select, the date to be used as the starting point for adding entries to the Timesheet Periods Details table.

After you select the Add Periods button, Costpoint calculates the dates in each timesheet cycle (period), based on the values in the Frequency and Number of Periods fields, and adds them to the Timesheet Periods Details table. If entries already exist in the table, the additional entries immediately follow the existing ones. Enter data in this field and click Add Periods to automatically populate the timesheet cycle schedule.

Last End Date

To populate this field, click the Add Periods button to calculate the last end date based on the values in the Number of Periods, First End Date, and Frequency fields. This date is the last timesheet period end date added to the timesheet cycle schedule.

Compute Last End Date

Click this button to calculate the last end date based on the values in the Number of Periods, First End Date, and Frequency fields. This date is the last timesheet period end date added to the timesheet cycle schedule.

Add Periods

Click this button to insert entries into the Timesheet Periods Details table. To use this feature, first fill in the Frequency, Number of Periods, and First End Date fields. After you select Add Periods, the rows are added following the previously existing end date in the table.

Timesheet Periods Details

The fields in this group box display the start dates, end dates, and open and weighted average processed flag status for each timesheet period.

Start Date

When you click Add Periods, Costpoint uses the End Date field in this table and the value in the Frequency field to automatically calculate these dates. If you do not use the automatic fill feature, you must select , then enter each start date, in MM/DD/YYYY format, for this timesheet cycle schedule.

End Date

This field displays the end date of each timesheet period. If you do not click Add Periods to automatically fill this table, enter each end date in MM/DD/YYYY format. To change this field, delete the column displaying the old end date and add a new row displaying the new (revised) end date.

Open

If you click Add Periods to automatically load the Timesheet Periods Details table, the check box in this column is set to cleared, indicating a closed timesheet period. You can enter only those timesheets that have dates falling within an open timesheet period. To enter a timesheet that falls within a closed timesheet period, you must first open the timesheet period by changing the check box to selected. Any number of timesheet periods can be open at any time.

Weighted Avg Processed

The check box in this field is selected to indicate that a weighted average rate has been calculated and applied to this timesheet period. If a weighted average rate has not been calculated, the check box is not selected. This check box defaults as cleared for a new timesheet period.