Time and Attendance

The Time & Attendance User Guide will review the features available in the Time & Attendance, Billing and Payroll modules.


eTime Xpress
Time & Attendance User Guide
(For versions 7.0098.000 and above)

Table of Contents
1. Time & Attendance Overview
2. Shift Distribution Rules
2.1. Branch Bill/Pay Settings
2.1.1. Bill/Pay Preferences
2.1.2. Bill/Pay Periods
2.1.3. Pay Rate Factors
2.1.4. Overtime Thresholds
2.2. Statutory Days (Holidays)
2.2.1. Customizing Statutory Days for Employees and Sites
2.3. Daylight Savings Time
2.4. Pay Settings
2.4.1. Default Pay Settings
2.4.2. Changing Employee Pay Settings
2.4.3. Changing Site Pay Settings
2.5. Pay Rates
2.5.1. Application of Pay Rates
2.5.2. Employee Pay Rates
2.5.3. Site Pay Rates
2.5.4. Combination Pay Rates (previously Site Employee Pay Rates)
2.5.5. Branch Pay Rates
2.6. Bill Settings
2.6.1. Default Bill Settings
2.6.2. Changing Site Bill Settings
2.7. Bill Rates
2.7.1. Application of Bill Rates
2.7.2. Employee Bill Rates
2.7.3. Site Bill Rates
2.7.4. Combination Bill Rates (previously Site Employee Pay Rates)
2.7.5. Branch Bill Rates
3. Managing Time and Attendance Records
3.1. Load View
3.2 Setting Shifts to Worked
3.2.1. Set a Scheduled Shift to Worked
3.2.2. Reset a Worked Shift to Scheduled
3.3. Add a Worked Shift
3.4. Update a Worked Shift
3.5. Delete a Worked Shift
3.6. Update a Shift Distribution
3.6.1. Shift Distribution Calculated by Shift Start Date
3.6.2. Shift Distribution Calculated by Calendar Date (Midnight Cutoff)
3.6.3. Reset a Shift Distribution
3.7. Replace Tool
3.7.1. Update Shift Details
3.7.2. Update Shift Times
3.7.3. Update Pay Hours
3.7.4. Update Pay Rates
3.7.5. Update Bill Hours
3.7.6. Update Bill Rates
3.7.7. Update Recalculation Status
3.8. Allowances
3.8.1. Create Allowance Types
3.8.2. Add an Allowance
3.8.3. Update an Allowance
3.8.4. Delete Allowances
3.8.5. Recurring Allowances
3.9. Setting Shifts to Locked
3.9.1. Set a Worked Shift to Locked
3.9.2. Reset a Locked Shift to Worked
3.10. Other Options
3.10.1. Set Time & Attendance Security
3.10.2. Import Attendance Information
3.10.3. Exporting Shifts Distribution
3.10.4. Time Entry Settings
3.10.5. Accruals
4. Using Payroll Main Screen
4.1. Review Shift Life Cycle
4.2. Set Scheduled Shifts to Worked
4.3. Reset Worked Shifts to Scheduled
4.4. Set Worked Shifts to Locked
4.5. Reset Locked Shifts to Worked
5. Using Billing Main Screen
5.1. Review Shift Life Cycle
5.2. Set Scheduled Shifts to Worked
5.3. Reset Worked Shifts to Scheduled
5.4. Set Worked Shifts to Locked
5.5. Reset Locked Shifts to Worked
6. Using Control Center to Record Attendance
6.1. Load View
6.2. Record Check-In/Out
6.3. Record Safety Check
6.4. Add a Shift
6.5. Update a Shift
6.6. Delete a Shift
6.7. Set a Shift to Open
6.8. Change Employee
6.9. Employee Availability Search
6.10. Set Control Center Security


1. Time & Attendance Overview

The Time & Attendance module of eTime Xpress allows you to process and manage shifts for attendance, billing, and payroll purposes. The Visual Scheduler is used to create the work plan. Time and Attendance is used to finalize and record the work results.
Within eTime Xpress, Time & Attendance is used to manage shifts during the Worked and Locked stages of the Shift Life Cycle as shown in the figure below.

Stage

Description

Scheduled

The shift is created and assigned to an Employee in the Visual Scheduler.

Worked

The shift is worked and matched to attendance information (i.e. recording of actual start and end times).

Locked

The shift is finalized with the correct bill and pay calculations.


To access the Time & Attendance screen, go to the Main Menu and double-click on the Time & Attendance button. The Time & Attendance screen should appear as shown in the figure below.
Time & Attendance Screen with Annotations

Annotation

Description

(1) View Selectors

Specify the date range and Time and Attendance records to view.

(2) Time & Attendance Records

Displays Time and Attendance records over date range.

(3) Process Information

Displays information and settings related to Time and Attendance processing including shift life cycle status, recalculation and bill/pay settings.

(4) Pay Distribution

Displays the break-out of shift time for pay purposes using your configured business rules.

(5) Bill Distribution

Displays the break-out of shift time for bill purposes using your configured business rules.

(6) Reset Distribution

Recalculates Shift Distribution using preset business rules (i.e. resets any manual changes or overrides made to a Shift Distribution)

(7) Bill/Pay Settings

Displays the bill and pay settings used to calculate Shift Distribution.

(8) Allowances

Attach allowances to shifts for pay or bill purposes.


2. Shift Distribution Rules

Employee attendance information can be entered manually or imported into eTime Xpress from a variety of sources such as web time sheets, time collection devices, HandPunches and more.
eTime Xpress Time & Attendance processes your attendance information into Worked Shifts and calculates your gross payroll and billing information. The breakdown of how a shift will be paid and billed is called the Shift Distribution. It separates the total hours of a shift into its components such as overtime, double overtime and statutory (holiday) hours as shown in the figure below.

Shift Distribution if based on Shift Start Date

Shift Distribution if based on Midnight Cutoff
The calculation of a Shift Distribution is based on the business rules configured in eTime Xpress. This section discusses the definition of business rules governing overtime, statutory days (holidays), daylight savings time, pay rates, bill rates and more.
Note: When configuring your Shift Distribution Rules, you may be asked whether you want to recalculate all of the existing shifts affected by these changes. Click 'Yes' to apply the rules to existing, non-locked shifts and future shifts or 'No' to apply the rules only to future shifts.

2.1. Branch Bill/Pay Settings

The Branch Bill/Pay Settings allows you to define your baseline business rules for calculating overtime and pay factors. These rules are applied when calculating Shift Distributions for Scheduled and/or Worked shifts in a Branch.
From the Main Menu, click Configuration > Company & Branch > Bill/Pay Settings. The Branch Bill/Pay Settings Screen should appear as shown in the figure below.

Branch Bill/Pay Settings with Annotations

Annotation

Description

(1) Preferences

Setup advanced rules for processing bill and pay information.

(2) Periods

Setup period start days for weekly, bi-weekly, tri-weekly and quad-weekly periods.

(3) Pay Rate Factors

Setup pay rate factors for regular, overtime, double overtime, statutory, training and other hours.

(4) Overtime Thresholds

Setup overtime thresholds for bill and/or pay calculations.


2.1.1. Bill/Pay Preferences

Bill/Pay Preferences allow you to define advance rules for processing bill and pay to comply with specific labor contracts or legislative requirements. From Branch Bill/Pay Settings, click the Preferences button on the Toolbar. The Preferences dialog box should appear as shown in the figure below.
!worddav0c5286fd411c0faeaa7e7c5d3570516a.png|height=225,width=354!Branch Bill/Pay Settings Preferences
Setting Hours Calculation:
The hours calculation rule sets the cutoff rule when a shift ends the following calendar day (i.e. a graveyard shift from 10pm to 6am). It is a fundamental rule needed to correctly measure the number of hours worked in a day.
The Shift Start Date option will allocate the total hours of a shift to the date when the shift started. The Calendar Date (Midnight Cutoff) option will allocate the total hours of a shift proportionately between the shift date and the next day. The difference between the hours calculation options are illustrated below based on a graveyard shift from 10pm to 6am (8 hours).

Rule/Day

Shift Start Date Rule

Calendar Date Rule

Current Day (Shift Date)

8 Hours

2 Hours

Next Day

0 Hours

6 Hours

Total Hours

8 Hours

8 Hours

If the Calendar Date option is selected, use the "Shift Break Allocation" pull-down to define how you want to allocate break hours between the Current Day (Shift Date) and Next Day.

Break Allocation

Description

Proportionately

Allocates shift break hours proportionately between the Current Day and Next Day (i.e. a 10pm to 6am shift would allocate break hours as 2/8 Current Day and 6/8 Next Day).

Current Day

Allocates all shift break hours to the Current Day (shift date).

Next Day

Allocates all shift break hours to the Next Day.

Evenly

Allocates shift break hours 50/50 between the Current Day and Next Day.

Middle of Shift

Allocates shift break hours based on the date when the mid-point of the shift occurs (i.e. a 10pm to 6am shift would allocate all break hours to the Next Day).


Advanced Rules: eTime Xpress provides additional advanced hours allocation and rate calculation options to accommodate certain labor contracts or legislative requirements. To enable an advanced rule for bill and/or pay, check-on the applicable checkbox. This allows you to Pay Employees and Bill Customers differently for the same shift.

Advanced Rule

Description

When working 7 consecutive days, allocate hours on the 7th day to OT

Select rule if overtime rule applies when working 7 consecutive days.

When working 6 consecutive days, allocate hours on the 6th day to OT & When working 7 consecutive days, allocate hours on the 7th day to DOT

Select rule if overtime rule applies when working 6 or 7 consecutive days.

Calculate OT, DOT and Stat rates based on average weekly regular earnings

Select rule to calculate OT, DOT and Stat rates by the following formula: (weekly earnings/weekly hours) * applicable pay factor.

Calculate OT, DOT and Stat rates based on blended weekly regular earnings

Select rule to calculate OT, DOT and Stat rates by the following formula: Regular rate + [(weekly earnings/weekly hours) * (applicable pay factor-1)].


2.1.2. Bill/Pay Periods

Overtime is calculated when the number of hours over a period exceeds a specified threshold. If you are configuring a Weekly, Bi-weekly, Tri-weekly and/or Quad-weekly overtime rule, you are required to specify the starting point for the applicable period. To specify a Bill/Pay Period, click on the Update button under Periods and define the start date of the applicable period(s).
Note: For Bi-weekly, Tri-weekly and/or Quad-weekly periods, specify a start date corresponding to a period that starts and ends prior to your first scheduled shift. eTime Xpress will then extrapolate the start and end dates of all future periods.

2.1.3. Pay Rate Factors

Pay rates may be grossed up by a multiple or factor based on the hours type listed below. To specify Pay Rate Factors, click on the Update button under Pay Factors and define the applicable multiple or factor.

Hours Type

Description

Reg

Regular Hours

OT

Overtime Hour

DOT

Double Overtime Hours

Stat

Statutory (Holiday) Hours

Training

Training Hours

Other

Other (Miscellaneous) Hours


2.1.4. Overtime Thresholds

Overtime Thresholds allow you to define overtime rules based on daily, weekly, bi-weekly, tri-weekly, quad-weekly and monthly periods.
To Add an Overtime Threshold:

  1. Click the Add button under Overtime Thresholds - the fields in the Overtime Thresholds browser should become active as shown in the figure below.


  1. Assign the thresholds type (Billing or Payroll), period type, overtime type (Overtime or Double Overtime) and threshold hours. Remember for fields that require entry by codes, you may press the F5 key to bring up a list of valid entries.
  2. Press the Enter key to save your new Overtime Threshold record.


2.2. Statutory Days (Holidays)

When a shift occurs on a Statutory Day (Holiday), the associated hours may be broken-out as Statutory hours for billing and/or payroll purposes. Statutory days can be setup to apply to all shifts worked at a Branch or customized to apply to specific Employees and Sites.
From the Main Menu, click Configuration > Company & Branch > Branch Tab > Branch Statutory Days. The Branch Statutory Days screen should appear as shown in the figure below.
Branch Statutory Days
To Add a Statutory Day:

  1. Click the Add button ( ) on the Tool Bar - the fields in the Statutory Days browser should become active.
  2. Assign the Date, Description, Bill (Yes/No), Pay (Yes/No), Employee (Yes/No) and Site (Yes/No) as shown in the figure below. Remember for fields that require entry by codes, you may press the F5 key to bring up a list of valid entries.


  1. Press the Enter key to save your new Statutory Day record.


Note: For each Statutory Day, you can define how a Statutory Day rule is applied by toggling between Yes and No for Bill, Pay, Employee and Site. For example, the combination Bill (No), Pay (Yes), Employee (Yes) and Site (Yes) results in shifts being billed normally and paid as a Statutory Day.

2.2.1. Customizing Statutory Days for Employees and Sites

The Employee (Yes/No) and Site (Yes/No) values of a Branch Statutory Day record are used as the initial 'Apply?' value in the Employee Statutory Days and Site Statutory Days screens, respectively. You can customize the Statutory Day rules for Employees and Sites by selecting which Statutory Days to 'Apply'.
To customize Employee Statutory Days:
From the Main Menu, click Employee > Employee Statutory Days. The Employee Statutory Days screen should appear as shown in the figure below.
Employee Statutory Days
Employee Statutory Days lists all of the Statutory days defined for the Branch and whether a Statutory Day applies for bill or pay purposes. To turn off a Statutory Day rule, double-click on the record - the value in the 'Apply?' column will toggle between 'yes' and 'no'.
To customize Site Statutory Days:
From the Main Menu, click Customers > Site Statutory Days. The Site Statutory Days screen should appear as shown in the figure below.
Site Statutory Days
Site Statutory Days lists all of the Statutory days defined for the Branch and whether a Statutory Day applies for bill or pay purposes. To turn on/off a Statutory Day rule, double-click on the record - the value in the 'Apply?' column will toggle between 'yes' and 'no'.
Note: For a Statutory Day rule to be applied to a shift, the Employee and Site both must have Apply = 'Yes'. For example, only the combination of Employee (Yes) and Site (Yes) results in Statutory Day treat. The combination of Employee (No) and Site (Yes) or Employee (Yes) and Site (No) does not result in Statutory Day treatment.

2.3. Daylight Savings Time

When a shift occurs during a Daylight Savings Time change, the total hours of a shift can be automatically adjusted for the time change. A "spring" Forward rule would subtract one hour from a shift whereas a "fall" Back rule would add one hour to a shift.
From the Main Menu, click Configuration > Company & Branch > Branch Daylight Savings Times. The Branch Daylight Savings Time Changes screen should appear as shown in the figure below.

Branch Daylight Savings Times
To Add a Daylight Savings Time Change:

  1. Click the Add button ( ) on the Tool Bar - the fields in the Daylight Savings Time Change browser should become active.
  2. Assign the Date, time of change and change type ("spring" Forward or "fall" Back). The time of change value is normally 0159 (01:59AM) in North America and 0059 (00:59AM) in the European Union.
  3. Press the Enter key to save your new Statutory Day record.


2.4. Pay Settings

eTime Xpress pay rules controlling the calculation of statutory pay, overtime pay and pay rates are managed at both the Employee and Site levels. For example, controls governing statutory pay and overtime can be found in the Employee and Site Main screens.
When a feature control (i.e. statutory pay) exists at both the Employee and Site levels, they are evaluated in "concert". That is, for Statutory hours to occur both the Site and Employee assigned to a shift must have the setting "Pay Stat = Yes".

2.4.1. Default Pay Settings

When Employees and Sites are first created, they are configured with default Pay rules as outlined in the figure below. These Pay rules can be customized for specific Employees and/or Sites by modifying the applicable Pay rule found in their respective Pay Settings tabs.

Employee Pay Rule

Default Setting

Description

Statutory Pay

Shifts for the Employee that occur on Statutory Days (Holidays) should be processed as Statutory hours for pay purposes.

Overtime Pay

Shifts for the Employee exceeding Branch overtime thresholds will be processed as overtime.

Rate Calculation

Pay rates for overtime, double overtime, statutory, training and other are calculated based on Pay Rate Factors defined in Branch Bill/Pay Settings.


Site Pay Rule

Default

Description

Statutory Pay

Shifts for the Site occurring on Statutory Days (Holidays) should be processed as Statutory hours for pay purposes.Days defined in Site Statutory Days will be used to determine whether a shift occurs on a Statutory Day.

Overtime Pay

Shift hours exceeding Branch overtime thresholds will be processed as overtime or double overtime. Shift hours are calculated based on all shifts worked within the Branch.

Pay Rates

Rates defined in Employee Pay Rates will be used to determine pay rates for a shift.


2.4.2. Changing Employee Pay Settings

From the Main Menu, click Employees and select the Pay Settings tab. The Employee Main screen should appear as shown as in the figure below.
Employee Pay Settings tab with Annotations

Annotation

Description

(1) Pay Stat

Specify if the Employee is paid Statutory pay.

(2) Pay OT

Specify if the Employee is paid Overtime.

(3) Rate Calc

Select the pay rate calculation formula to be applied.

Note: Only items that directly affect the calculation of Shift Distributions are listed above.
Rate Calculation Options
Rate calculation is the formula applied to a Regular pay rate to calculate Overtime, Double Overtime, Statutory, Billing and Training pay rates.

Rate Calculation

Description

Factor Base

Multiplies the Regular Pay rate by Pay Rate Factors defined in Branch Bill/Pay Settings or by user defined Custom Pay Factors (see Employee User Guide or Customer and Site User Guide).

Avg. Base

Regular rate is dynamically re-calculated to eliminate Overtime pay.


2.4.3. Changing Site Pay Settings

From the Main menu, click Customers and select the Sites > Pay Settings tab. The Site Main screen should appear as shown as in the figure below.
Site Main Screen – Pay Settings Tab

Annotation

Description

(1) Pay Rates

Select which pay rates to apply for shifts worked at the Site. See Pay Rates section in this guide for more information.

(2) Pay Stat

Specify if the shifts worked at the Site earn Statutory pay and specify which Statutory Day definitions to use.

(3) Pay OT

Specify if the shifts worked at the Site earn Overtime and specify the subset of shift hours to sum when calculating Overtime (see Summing Hours for Overtime Pay).

Note: Only items that directly affect the calculation of Shift Distributions are listed above.
Summing Hours for Overtime Pay
When calculating Overtime Pay, eTime Xpress sums the shift hours of an Employee to determine if Overtime thresholds have been exceeded. You can customize your Overtime Pay Rules by Site to control how shifts hours are summed for Overtime.

Overtime Sum Rule

Description

Branch

Sums the hours of all shifts worked at a Branch by an Employee.

Customer

Sums the hours of all shifts worked at a Customer by an Employee.

Site

Sums the hours of all shifts worked at a Site by an Employee.

2.5. Pay Rates

eTime Xpress allows pay rates to be defined at the Employee, Site, Combination and Branch levels. The selection of which pay rate definition to apply is made at the Site level - this allows you to customize how shifts are paid when worked at a particular Site.

2.5.1. Application of Pay Rates

eTime Xpress applies pay rates according to the 'Pay Rate' setting found on the Pay Settings tab in the Site Main screen as shown in the figure below. By default, eTime Xpress applies the pay rate definitions created in Employee Pay Rates.


If a pay rate cannot be found, eTime Xpress will then apply the pay rates defined under Branch Pay Rates.
For example, where the Site Pay Rates pointer is set to 'Employee', eTime Xpress will first attempt to match pay rates defined under Employee Pay Rates. If a Pay Rate cannot be found under Employee Pay Rates, the system will apply the pay rates defined under Branch Pay Rates.
Note: The Greatest and Least options will dynamically compare the pay rates defined in Employee Pay Rates, Site Pay Rates and Combination Pay Rates to determine the applicable pay rate.

2.5.2. Employee Pay Rates

Employee Pay Rates allow you to define a pay rate by Service. When shifts are paid according Employee Pay Rates, an Employee is paid by the Service performed regardless of where they worked.
From the Main Menu, click Employees > Employee Pay Rates. The Employee Pay Rates screen should appear as shown in the figure below.
Employee Pay Rates Screen
To Add an Employee Pay Rate:

  1. Click the Add button ( ) on the Tool Bar - the fields in the Pay Rates browser should become active.
  2. Assign the Service Code (enter '*' for All Services), Effective Date and the applicable Pay Rate. Remember for fields that require entry by codes, you may press the F5 key to bring up a list of valid entries.
  3. Press the Enter key to save your new Employee Pay Rate.


The Effective Date allows you to define current and future Pay Rates. When calculating payroll, eTime Xpress will apply the Pay Rate in effect on the date of the shift.
Pay Rate Factors
When entering an Employee Pay Rate, eTime Xpress automatically applies the 'Default' Pay Factors defined for the Branch (see Branch Bill/Pay Settings). If a Pay Rate requires a custom Pay Factor that is different than the 'Default' Pay Factor, select the Pay Rate and click the Pay Factors button in the Tool Bar. The custom Pay Factors dialog should appear as shown in the figure below.
Custom Pay Rate Factors Window
Custom Pay Factors allow you to define new Pay Rate Factors (Multipliers) or dollar amounts (Fixed Amounts) for each type of hours. Pay Rates using custom Pay Factors will be identified in the Employee Pay Rates screen as 'Custom' under the Pay Factor column.
Note: If shifts were created prior to defining Pay Rates or you are updating an existing Pay Rate, you will be asked whether you want to apply the new Pay Rate to existing shifts. Selecting 'Yes' will recalculate your payroll information with the new rate, where as selecting 'No' will apply the new rate only to newly created shifts.

2.5.3. Site Pay Rates

Site Pay Rates allow you to define a pay rate by Service. When a Site is set to pay by Site Pay Rates, all Employees working at the Site will be paid at the same rate when performing the same Service.
From the Main Menu, click Customers > Site Pay Rates. The Site Pay Rates screen should appear as shown in the figure below.
Site Pay Rates Screen
To Add a Site Pay Rate:

  1. Click the Add button ( ) on the Tool Bar - the fields in the Pay Rates browser should become active.
  2. Assign the Service Code (enter '*' for All Services), Effective Date and the applicable Pay Rate. Remember for fields that require entry by codes, you may press the F5 key to bring up a list of valid entries.
  3. Press the Enter key to save your new Site Pay Rate.


The Effective Date allows you to define current and future Pay Rates. When calculating payroll, eTime Xpress will apply the Pay Rate in effect on the date of the shift.
Pay Rate Factors
When entering a Site Pay Rate, eTime Xpress automatically applies the 'Default' Pay Factors defined for the Branch. If a Pay Rate requires a custom Pay Factor that is different than the 'Default' Pay Factor, select the Pay Rate and click the Pay Factors button in the Tool Bar. The custom Pay Factors dialog should appear as shown in the figure below.
Custom Pay Rate Factors Window
Custom Pay Factors allow you to define new Pay Rate Factors (Multipliers) or dollar amounts (Fixed Amounts) for each hour's type. Pay Rates using custom Pay Factors will be identified in the Site Pay Rates screen as 'Custom' under the Pay Factor column.
Note: If shifts were created prior to defining Pay Rates or you are updating an existing Pay Rate, you will be asked whether you want to apply the new Pay Rate to existing shifts. Selecting 'Yes' will recalculate your payroll information with the new rate, where as selecting 'No' will apply the new rate only to newly created shifts.

2.5.4. Combination Pay Rates (previously Site Employee Pay Rates)

Combination Pay Rates allow you to define a pay rate based on a shift's Customer, Site, Employee and Service values.
Combination Pay Rates may be defined from three areas within the application:

  1. Employee > Employee Combination Pay Rates

Employee Combination Pay Rates allow you to define and view combination pay rates filtered by employee. Customer, Site and Service values may be a combination of specific or wild card values. Please see the Employee Combination Pay Rates section in the Employee User Guide for more information.

  1. Customer > Site Combination Pay Rates

Site Combination Pay Rates allow you to define and view combination pay rates filtered by site. Employee and Service values may be a combination of specific or wild card values. Please see the Site Combination Pay Rates section in the Customer User Guide for more information.

  1. Company/Branch > Branch Combination Pay Rates

Branch Combination Pay Rates allow you to view and administer All combination pay rates defined in a branch. Customer, Site, Employee and Service values may be a combination of specific or wild card values. Please see the Branch Combination Pay Rates section in the Administrator User Guide for more information.
Combination Pay Rate Tie Break/Priority Rules
Combination pay rates allow you to assign a pay rate based on a shift's customer, site, employee and service values. Those values may be defined as specific or wild card values. As a result, more than one combination pay rate may apply to a shift requiring prioritization rules as tie breakers.
The following tie break rules are applied in the following priority order when selecting between pay rates that are valid on the same shift:

Priority

Employee

Customer

Site

Service

1

2

All

3

All

4

All

All

5

All

All

6

All

All

All

7

All

8

All

All

9

All

All

10

All

All

All

11

All

All

All

12

All

All

All

All

√ = Specific Value
All = Wild Card value
Example:
A basic scenario of 2 combination pay rates applying to the same shift would be as follows:

Combination Pay Rate

Employee

Customer

Site

Service

Pay Rate #1 = $10

Joe Doe

All

All

All

Pay Rate #2 = $ 9

All

All

All

On Call


If Joe Doe is scheduled to perform On Call duties that shift satisfies the criteria for both combination pay rate #1 and #2.
Based on the priority table above, pay rate #1 would have priority rank of 6 while pay rate #2 would have priority rank of 11. The system would assign combination pay rate #1 of $10 to the shift.
Pay Rate Factors
When entering a Combination Pay Rate, eTime Xpress automatically applies the 'Default' Pay Factors defined for the Branch. If a Pay Rate requires a custom Pay Factor that is different than the 'Default' Pay Factor, select the Pay Rate and click the Pay Factors button in the Tool Bar. The custom Pay Factors dialog should appear as shown in the figure below.
Custom Pay Rate Factors Window
Custom Pay Factors allow you to define new pay rate factors (Multipliers) or dollar amounts (Fixed Amounts) for each hour's type. Pay Rates using custom Pay Factors will be identified in the Combination Pay Rates screen as 'Custom' under the Pay Factor column.
Note: If shifts were created prior to defining Pay Rates or you are updating an existing Pay Rate, you will be asked whether you want to apply the new Pay Rate to existing shifts. Selecting 'Yes' will recalculate your payroll information with the new rate, where as selecting 'No' will apply the new rate only to newly created shifts.

2.5.5. Branch Pay Rates

Branch Pay Rates allow you to define a pay rate where all Employees performing the same Service are paid at the same rate. Remember that Branch Pay Rates are default rates applied when an applicable pay rate cannot be found in Employee Pay rates, Site Pay Rates or Combination Pay rates depending on your configured business rules. Branch Pay Rates can be used as a "catch-all" or if your organization simply pays according to the service performed.
From the Main Menu, click Configuration > Company/Branch > Branch Pay Rates. The Branch Pay Rates screen should appear as shown in the figure below.
Branch Pay Rates Screen
To Add a Branch Pay Rate:

  1. Click the Add button ( ) on the Tool Bar - the fields in the Pay Rates browser should become active.
  2. Assign the Service Code (enter '*' for All Services), Effective Date and the applicable Pay Rate. Remember for fields that require entry by codes, you may press the F5 key to bring up a list of valid entries.
  3. Press the Enter key to save your new Branch Pay Rate.


The Effective Date allows you to define current and future Pay Rates. When calculating payroll, eTime Xpress will apply the Pay Rate in effect on the date of the shift.
Pay Rate Factors
When entering a Branch Pay Rate, eTime Xpress automatically applies the 'Default' Pay Factors defined for the Branch. If a Pay Rate requires a custom Pay Factor that is different than the 'Default' Pay Factor, select the Pay Rate and click the Pay Factors button in the Tool Bar. The custom Pay Factors dialog should appear as shown in the figure below.
Custom Pay Rate Factors Window
Custom Pay Factors allow you to define new Pay Rate Factors (Multipliers) or dollar amounts (Fixed Amounts) for each hour's type. Pay Rates using custom Pay Factors will be identified in the Branch Pay Rates screen as 'Custom' under the Pay Factor column.
Note: If shifts were created prior to defining Pay Rates or you are updating an existing Pay Rate, you will be asked whether you want to apply the new Pay Rate to existing shifts. Selecting 'Yes' will recalculate your payroll information with the new rate, where as selecting 'No' will apply the new rate only to newly created shifts.

2.6. Bill Settings

eTime Xpress bill rules controlling the calculation of non-billable time, statutory billing, bill rates and billable overtime are managed at the Site levels.

2.6.1. Default Bill Settings

When Sites are first created, they are configured with default Bill rules as outlined in the figure below. These Bill rules can be customized for specific Sites by modifying the applicable Bill rule found in the Bill Settings tab.

Site Bill Rule

Default Setting

Description

Bill Site

Shifts scheduled at the Site are billable.

Bill Rates

Rates defined in Site Bill Rates will be used to determine bill rates for a shift scheduled at the Site.

Statutory Billing

Shifts for the Site occurring on Statutory Days (Holidays) should be processed as Statutory hours for bill purposes.Days defined in Site Statutory Days will be used to determine whether a shift occurs on a Statutory Day.

OT Billable

Overtime will be processed as standard billable hours (i.e. Overtime is not billable at a special Overtime rate).


2.6.2. Changing Site Bill Settings

From the Main Menu, click Customers and select the (Site) Bill Settings tab. The Site Main screen should appear as shown as in the figure below.

Site Bill Settings tab with Annotations

Annotation

Description

(1) Bill Site

Specify if the shifts worked at the Site are billable.

(2) Bill Rates

Select which bill rates to apply for shifts worked at the Site. See Bill Rates section in this guide for more information.

(3) Bill Stat

Specify if the shifts worked at the Site are billable as Statutory hours and specify which Statutory Day definitions to use.

(4) OT Billable

Specify if shifts worked at the Site resulting in Overtime pay can be billed as Overtime (i.e. recoverable Overtime). If Overtime is billable, specify the scope of shift when summing hours to calculate overtime.

Note: Only items that directly affect the calculation of Shift Distributions are listed above.
Summing Hours for Billable Overtime
When calculating Billable Overtime, eTime Xpress sums the shift hours of an Employee to determine if Overtime thresholds have been exceeded. You can customize your Billable Overtime Rules by Site to control how shifts hours are summed for Billable Overtime.

Overtime Sum Rule

Description

Branch

Sums the hours of all shifts worked at a Branch by an Employee.

Customer

Sums the hours of all shifts worked at a Customer by an Employee.

Site

Sums the hours of all shifts worked at a Site by an Employee.


2.7. Bill Rates

eTime Xpress allows bill rates to be defined at the Employee, Site, Site/Employee and Branch levels. The selection of which bill rate definition to apply is made at the Site level.

2.7.1. Application of Bill Rates

eTime Xpress applies bill rates according to the 'Bill Rate' setting found on the Bill Settings tab in the Site Main screen as shown in the figure below. By default, eTime Xpress applies the bill rate definitions created in Site Pay Rates.

If a bill rate cannot be found, eTime Xpress will then apply the pay rates defined under Branch Bill Rates.
For example, where the Site Bill Rates pointer is set to 'Site', eTime Xpress will first attempt to match bill rates defined under Site Bill Rates. If a Bill Rate cannot be found under Site Bill Rates, the system will apply the bill rates defined under Branch Bill Rates.
Note: The Greatest and Least options will dynamically compare the bill rates defined in Employee Bill Rates, Site Bill Rates and Combination Bill Rates to determine the applicable bill rate.

2.7.2. Employee Bill Rates

Employee Bill Rates allow you to define a bill rate for an Employee. When shifts are billed according to Employee Bill Rates, the Employee's standard Bill Rate by Service is applied.
From the Main Menu, click Employees > Employee Bill Rates. The Employee Bill Rates screen should appear as shown in the figure below.
Employee Bill Rates Screen
To Add an Employee Bill Rate:

  1. Click the Add button ( ) on the Tool Bar - the fields in the Bill Rates browser should become active.
  2. Assign the Service Code (enter '*' for All Services), Effective Date and the applicable Bill Rates by hour's type (standard, overtime, double overtime, statutory and other). Remember for fields that require entry by codes, you may press the F5 key to bring up a list of valid entries.
  3. Press the Enter key to save your new Employee Bill Rate.


The Effective Date allows you to define current and future Bill Rates. When calculating billing, eTime Xpress will apply the Bill Rate in effect on the date of the shift.
Note: If shifts were created prior to defining Bill Rates or you are updating an existing Bill Rate, you will be asked whether you want to apply the new Bill Rate to existing shifts. Selecting 'Yes' will recalculate your billing information with the new rate, where as selecting 'No' will apply the new rate only to newly created shifts.

2.7.3. Site Bill Rates

Site Bill Rates allow you to define a bill rate by Service. When a Site is set to bill by Site Bill Rates, shifts are billed according to the Service performed regardless of the Employee who performed the Service.
From the Main Menu, click Customers > Site Bill Rates. The Site Bill Rates screen should appear as shown in the figure below.
Site Bill Rates Screen
To Add a Site Bill Rate:

  1. Click the Add button ( ) on the Tool Bar - the fields in the Bill Rates browser should become active.
  2. Assign the Service Code (enter '*' for All Services), Effective Date and the applicable Bill Rates by hour's type (standard, overtime, double overtime, statutory and other). Remember for fields that require entry by codes, you may press the F5 key to bring up a list of valid entries.
  3. Press the Enter key to save your new Site Bill Rate.


The Effective Date allows you to define current and future Bill Rates. When calculating billing, eTime Xpress will apply the Bill Rate in effect on the date of the shift.
Note: If shifts were created prior to defining Bill Rates or you are updating an existing Bill Rate, you will be asked whether you want to apply the new Bill Rate to existing shifts. Selecting 'Yes' will recalculate your billing information with the new rate, where as selecting 'No' will apply the new rate only to newly created shifts.

2.7.4. Combination Bill Rates (previously Site Employee BillPay Rates)

Combination Bill Rates allow you to define a bill rate based on a shift's Customer, Site, Employee and Service values.
Combination Bill Rates may be defined from three areas within the application:

  1. Employee > Employee Combination Bill Rates

Employee Combination Bill Rates allow you to define and view combination bill rates filtered by employee. Customer, Site and Service values may be a combination of specific or wild card values. Please see the Employee Combination Bill Rates section in the Employee User Guide for more information.

  1. Customer > Site Combination Bill Rates

Site Combination Bill Rates allow you to define and view combination bill rates filtered by site. Employee and Service values may be a combination of specific or wild card values. Please see the Site Combination Bill Rates section in the Customer User Guide for more information.

  1. Company/Branch > Branch Combination Bill Rates

Branch Combination Bill Rates allow you to view and administer All combination bill rates defined in a branch. Customer, Site, Employee and Service values may be a combination of specific or wild card values. Please see the Branch Combination Bill Rates section in the Administrator User Guide for more information.
Combination Bill Rate Tie Break/Priority Rules
Combination bill rates allow you to assign a bill rate based on a shift's customer, site, employee and service values. Those values may be defined as specific or wild card values. As a result, more than one combination bill rate may apply to a shift requiring prioritization rules as tie breakers.
The following tie break rules are applied in the following priority order when selecting between bill rates that are valid on the same shift:

Priority

Employee

Customer

Site

Service

1

2

All

3

All

4

All

All

5

All

All

6

All

All

All

7

All

8

All

All

9

All

All

10

All

All

All

11

All

All

All

12

All

All

All

All

√ = Specific Value
All = Wild Card value
Example:
A basic scenario of 2 combination bill rates applying to the same shift would be as follows:

Combination Bill Rate

Employee

Customer

Site

Service

Bill Rate #1 = $25

Joe Doe

All

All

All

Bill Rate #2 = $20

All

All

All

On Call


If Joe Doe is scheduled to perform On Call duties that shift satisfies the criteria for both combination bill rate #1 and #2.
Based on the priority table above, bill rate #1 would have priority rank of 6 while bill rate #2 would have priority rank of 11. The system would assign combination bill rate #1 of $25 to the shift.
Note: If shifts were created prior to defining Bill Rates or you are updating an existing Bill Rate, you will be asked whether you want to apply the new Bill Rate to existing shifts. Selecting 'Yes' will recalculate your billing information with the new rate, where as selecting 'No' will apply the new rate only to newly created shifts.

2.7.5. Branch Bill Rates

Branch Bill Rates allow you to define a Bill Rate where all Employees performing the same Service are billed at the same rate. Remember that Branch Bill Rates are default rates that are applied when an applicable bill rate cannot be found in Employee Bill rates, Site Bill Rates or Combination Bill Rates depending on your configured business rules. Branch Bill Rates can be used as a "catch-all" or if your organization simply bills according to the service performed.
From the Main Menu, click Configuration > Company/Branch > Branch Bill Rates. The Branch Bill Rates screen should appear as shown in the figure below.
Branch Bill Rates Screen
To Add a Branch Bill Rate:

  1. Click the Add button ( ) on the Tool Bar - the fields in the Bill Rates browser should become active.
  2. Assign the Service Code (enter '*' for All Services), Effective Date and the applicable Bill Rates by hour's type (standard, overtime, double overtime, statutory and other). Remember for fields that require entry by codes, you may press the F5 key to bring up a list of valid entries.
  3. Press the Enter key to save your new Branch Bill Rate.


The Effective Date allows you to define current and future Bill Rates. When calculating billing, eTime Xpress will apply the Bill Rate in effect on the date of the shift.
Note: If shifts were created prior to defining Bill Rates or you are updating an existing Bill Rate, you will be asked whether you want to apply the new Bill Rate to existing shifts. Selecting 'Yes' will recalculate your billing information with the new rate, where as selecting 'No' will apply the new rate only to newly created shifts.

3. Managing Time and Attendance Records

The Time & Attendance screen allows you to verify, adjust and record the work results of your Schedule. Your Scheduled shifts are matched with attendance information (i.e. manual or web timesheets, swipe card systems, HandPunches etc.) to create Worked shifts.

3.1. Load View

The Time & Attendance screen allows you load only the shifts which you want to view and update.
To load shifts into the Time & Attendance screen:

  1. From the View Selector, specify the applicable filters for the shifts you want to view.


Filter Option

Description

From/To Dates

Specify the date range for shifts.

View

Specify the type of shift to be viewed.

Customer

Specify the shifts by Customer. To see All Customers, enter '*'.

Site

Specify the shifts by Site. To see All Sites, enter '*'.

Employee

Specify the shifts by Employee. To see All Employees, enter '*'. To see Open shifts, enter '0'.


  1. Start the shift load process by clicking the Refresh button ( ). Refresh clears your current view and loads shifts matching your specified filters.


3.2 Setting Shifts to Worked

Shifts created in the Visual Scheduler are first loaded into Time & Attendance as Scheduled shifts as shown in the figure below.
Scheduled Shift in Time & Attendance
In eTime Xpress, shifts are categorized as Worked when the work results (actual In, Out and Break values) are recorded as shown in the figure below.

Worked Shift in Time & Attendance

3.2.1. Set a Scheduled Shift to Worked


To Set a Scheduled Shift to Worked:

  1. Select a Scheduled shift and click the Set Shift Worked button ( ) on the Tool Bar. By default, the In, Out, Break and Total fields will be populated with the Scheduled values.


To Set a Range of Scheduled Shifts to Worked:

  1. In the View Selector of Time & Attendance, specify the applicable filters for the shifts you want to view and click the Refresh button ( ).
  2. Click the Set All Worked button ( ) on the Tool bar. All Scheduled shifts in the specified range will be set to Worked. By default, the In, Out, Break and Total fields will be populated with the Scheduled values.


Note: Open shifts cannot be set to Worked - an Employee must be assigned to a shift before being categorized as Worked. eTime Xpress will skip any Open shifts found in the specified range.

3.2.2. Reset a Worked Shift to Scheduled


To Reset a Worked Shift to Scheduled:

  1. Select a Worked shift and click Data > Worked > Reset Shift from the Menu bar. The Worked shift will be reset to Scheduled and the In, Out, Break and Total fields will be cleared.


To Reset a Range of Worked Shifts to Scheduled:

  1. In the View Selector of Time & Attendance, specify the applicable filters for the shifts you want to view and click the Refresh button ( ).
  2. From the Menu bar, click Data > Worked > Reset All. All Worked shifts will be reset to Scheduled and the In, Out, Break and Total fields will be cleared.


Note: Locked shifts cannot be reset. You must first remove the Lock status before resetting the Worked shift. eTime Xpress will skip any Locked shifts found in the specified range.

3.3. Add a Worked Shift

The Visual Scheduler is the primary method for entering "Scheduled" shifts records into eTime Xpress. Shifts may be entered in Time & Attendance but they are considered "Worked" and are not validated against your business rules such as double book and time off.
To Add a Worked shift:

  1. Click the Add button ( ) on the Tool Bar - the fields in the Time & Attendance browser should become active as shown in the figure below.


  1. Assign the date, Customer, Site, Employee, Service, In, Out and Break values. Remember for fields that require entry by codes, you may press the F5 key to bring up a list of valid entries.
  2. Press the Enter key to save your new Worked Shift Record. The Shift Distribution is automatically calculated for the new worked shift.


Note: In and Out refer to the actual start and end times of a shift. For example, a shift may have a scheduled 8AM "Start" time but the actual "In" or arrival time of the Employee may be 8:15AM.

3.4. Update a Worked Shift

To Update a Worked shift:

  1. Select a shift and click the Update button ( ) on the Tool Bar - the fields in the Time & Attendance browser should become active as shown in the figure below.


  1. Update the date, Customer, Site, Employee, Service, In, Out and Break values. Remember for fields that require entry by codes, you may press the F5 key to bring up a list of valid entries.
  2. Press the Enter key to save changes. The Shift Distribution is automatically calculated for the updated worked shift.


3.5. Delete a Worked Shift


To Delete a Worked shift:

  1. Select a shift and click the Delete button ( ) on the Tool Bar - a Confirm Delete dialog box should appear as shown in the figure below.



Deleting a Shift

  1. Click 'Yes' to delete the selected shift.


To Delete a range of Worked shifts:

  1. From Time & Attendance, click the Edit > Delete > Range. The Delete Range dialog box should appear as shown in the figure below.
  2. Set search criteria by specifying the date range, shift type (Worked or Not Worked), Employee, Service, Customer and Site.
  3. Click the Search button to display a list of shifts matching the search criteria.
  4. From the list of shifts, select the shifts which you want to delete. You can select shifts using the Select All button or by pressing the [Shift] or [Ctrl] key while selecting shift records.
  5. Click the OK button to start the delete process.


Deleting a Range of Shifts

3.6. Update a Shift Distribution

When a shift is created in eTime Xpress, a Shift Distribution is automatically created based on your configured business rules. The Shift Distribution is the breakdown of how a shift will be paid and billed.
eTime Xpress allows you to adjust the hours and rates of a Shift Distribution to account for bill and/or pay exceptions that differ from your common business rules (i.e. special one-time events with specific rates and overtime rules).
The Shift Distribution calculation depends on your 'hours calculation' rule defined in the Branch Bill/Pay Settings screen as shown in the figure below. The hours calculation rule sets the cutoff rule when a shift ends the following calendar day (i.e. a graveyard shift from 10pm to 6am).

Depending on your hours calculation rule for the branch, the display of the Shift Distribution will differ as outlined below.

3.6.1. Shift Distribution Calculated by Shift Start Date


To Update a Shift Distribution Calculated by Shift Start Date:

  1. From Time & Attendance, select a Worked shift and click the Distribution button ( ) on the Tool Bar - the fields under Shift Distribution should become active as shown in the figure below.



Shift Distribution Calculated by Start Date

  1. Update the Pay and/or Bill Hours and Rates as required. When updating Pay or Bill hours, the sum of all hour types must equal the total hours of a shift.
  2. Assign a Reason Code to any fields updated in the Shift Distribution. Beside every Shift Distribution field is a Reason Code field whose purpose is to record why a field was updated or overridden. You may generate a report on what changes were made to Shift Distributions and why. Remember for fields that require entry by codes, you may press the F5 key to bring up a list of valid entries.
  3. Click the Save button ( ) to save the changes to the Shift Distribution.


Note: To define your own Reason Codes, click on Configuration > Codes Maintenance option from the Main Menu. Next select either 'Bill Reason Code' or 'Pay Reason Code'.

3.6.2. Shift Distribution Calculated by Calendar Date (Midnight Cutoff)


To Update a Shift Distribution Calculated by Calendar Date (Midnight Cutoff):

  1. From Time & Attendance, select a Worked shift and click the Distribution button ( ) on the Tool Bar - the fields under Shift Distribution should become active as shown in the figure below.



Shift Distribution Calculated by Calendar Date (Midnight Cutoff)

  1. Update the Pay and/or Bill Hours and Rates as required. When updating Pay or Bill hours, the sum of all hour types must equal the total hours of a shift.
  2. Assign a Reason Code to any fields updated in the Shift Distribution. Beside every Shift Distribution field is a Reason Code field whose purpose is to record why a field was updated or overridden. You may generate a report on what changes were made to Shift Distributions and why. Remember for fields that require entry by codes, you may press the F5 key to bring up a list of valid entries.
  3. Click the Save button ( ) to save the changes to the Shift Distribution.


Note: To define your own Reason Codes, click on Configuration > Codes Maintenance option from the Main Menu. Next select either 'Bill Reason Code' or 'Pay Reason Code'.

3.6.3. Reset a Shift Distribution

Resetting a Shift Distribution recalculates the Shift Distribution based on your preset business rules. It will overwrite any manual updates or overrides made to a Shift Distribution.
To Reset a Shift Distribution:

  1. From Time & Attendance, select a Worked shift and click the Reset Distribution button under Shift Distribution as shown in the figure below.


Reset Shift Distribution
To Reset Shift Distributions of a Group of Shifts:

  1. In the View Selector of Time & Attendance, specify the applicable filters for the shifts you want to view and click the Refresh button ( ).
  2. From the Menu bar, click Data > Reset > Reset All Distributions. The Shift Distributions of All Worked shifts in the specified range will be reset.


To Reset Shift Distributions of a Range of Shifts:

  1. From the Menu bar, click Data > Reset > Reset Distribution Range. The Shift Distributions of all matching shifts over the specified date range will be reset.


3.7. Replace Tool

Time & Attendance provides a collection of update features to manage Worked shifts and their underlying Shift Distribution information. The Time & Attendance replace tool allows you to edit and make multiple adjustments all at once.
From Time & Attendance, click Edit > Replace from the Menu bar. The Replace dialog box should appear as shown in the figure below.
Time & Attendance Replace Tool

Annotation

Description

(1) View Selector

Contains a list of criteria that allows you to narrow your search to a subset of Worked shifts.

(2) Record Selector

Displays Worked shifts matching criteria defined in the View Selector. You then select the Worked shifts to which you want to apply the Replace tool.

(3) Data Selector

Select the type of data you want to update and replace.

(4) Data Fields

Specify the data fields and change required. The Data Fields will dynamically update based on the data type selected.


Using the Time & Attendance Replace Tool:

  1. Set Search Criteria. In the View Selector, define your shift search criteria and click the Search button. The Search feature will display only shifts matching your search criteria.
  2. Select Records. From the list of Worked shifts, select the shifts to which you want to apply the Replace tool. You can select shifts using the Select All button or by pressing the [Shift] or [Ctrl] key while selecting shift records.
  3. Select Data Type. Select the type of data you want to update and replace.
  4. Configure Tool. Specify the data fields and change required based on the data type selected.


Note: The Replace tool searches and displays only Worked shifts (i.e. Scheduled shifts cannot be edited with the Replace tool).

3.7.1. Update Shift Details

The Shift option of the Time & Attendance Replace tool allows you to perform a bulk update of the Customer, Site, Employee and Service values of Worked shifts.
To Update Shift Details:

  1. From the Time & Attendance Replace tool, select Shift - the fields under Adjust should appear as shown in the figure below.


  1. Update the Customer, Site, Employee and/or Service as required. Enter '*' for No Change. Remember for fields that require entry by codes, you may press the F5 key to bring up a list of valid entries.
  2. Click the OK button start the replace process.


3.7.2. Update Shift Times

The Time option of the Time & Attendance Replace tool allows you to perform a bulk update of the In, Out and Break times of Worked shifts.
To Update Shift Times:

  1. From the Time & Attendance Replace tool, select Time - the fields under Adjust should appear as shown in the figure below.


  1. Update the In, Out and Break as required. You may select to increase, decrease or replace values.
  2. Click the OK button start the replace process.


3.7.3. Update Pay Hours

The Pay Hours option of the Time & Attendance Replace tool allows you to perform a bulk update of the pay hours in the Shift Distribution of Worked shifts. This tool allows you to move hours from and to hours types (i.e. Regular to Overtime) based on a flat amount or formula.
To Update Shift Distribution Pay Hours:

  1. From the Time & Attendance Replace tool, select Pay Hours - the fields under Adjust should appear as shown in the figure below.


  1. Select the applicable move from/to hours type, reason code and the amount of hours.
  2. Click the OK button start the replace process.


Hours Options

Description

All Available

Moves all hours from/to selected hours types.

Flat Amount

Moves specified amount of hours from/to selected hours types.

In Time Range

Moves any hours occurring during specified time period from/to selected hours types. From example, if the specified time period is 0000 to 0400, the portion of shift hours occurring from 12AM to 4AM will be moved.

Over

Moves any hours over specified threshold from/to selected hours types.

Under

Moves any hours under specified threshold from/to selected hours types.


3.7.4. Update Pay Rates

The Pay Rates option of the Time & Attendance Replace tool allows you to perform a bulk update of the pay rates in the Shift Distribution of Worked shifts. This tool allows you to increase/decrease pay rates by a flat amount or percentage.
To Update Shift Distribution Pay Rates:

  1. From the Time & Attendance Replace tool, select Pay Rates - the fields under Adjust should appear as shown in the figure below.


  1. Select the applicable rate type, reason code, action (increase/decrease) and the amount of change.
  2. Click the OK button start the replace process.


3.7.5. Update Bill Hours

The Bill Hours option of the Time & Attendance Replace tool allows you to perform a bulk update of the bill hours in the Shift Distribution of Worked shifts. This tool allows you to move hours to and from hours types (i.e. Standard to Overtime) based on a flat amount or formula.
To Update Shift Distribution Bill Hours:

  1. From the Time & Attendance Replace tool, select Bill Hours - the fields under Adjust should appear as shown in the figure below.


  1. Select the applicable move from/to hours type, reason code and the amount of hours.
  2. Click the OK button start the replace process.


Hours Options

Description

All Available

Moves all hours from/to selected hours types.

Flat Amount

Moves specified amount of hours from/to selected hours types.

In Time Range

Moves any hours occurring during specified time period from/to selected hours types. From example, if the specified time period is 0000 to 0400, the portion of shift hours occurring from 12AM to 4AM will be moved.

Over

Moves any hours over specified threshold from/to selected hours types.

Under

Moves any hours under specified threshold from/to selected hours types.


3.7.6. Update Bill Rates

The Bill Rates option of the Time & Attendance Replace tool allows you to perform a bulk update of the bill rates in the Shift Distribution of Worked shifts. This tool allows you to increase/decrease pay rates by a flat amount or percentage.
To Update Shift Distribution Bill Rates:

  1. From the Time & Attendance Replace tool, select Bill Rates - the fields under Adjust should appear as shown in the figure below.


  1. Select the applicable rate type, reason code, action (increase/decrease) and the amount of change.
  2. Click the OK button start the replace process.


3.7.7. Update Recalculation Status

The Other option of the Time & Attendance Replace tool allows you to perform a bulk update of the Recalculation Status of Worked shifts. By default, eTime Xpress will recalculate the Shift Distribution of shifts. When you update or override a Shift Distribution, the Automatic Recalculation setting for that shift is set to 'No'. This occurs so that your changes are not overwritten by a future recalculation process.
If want to have eTime Xpress reverse changes made to Shift Distributions, use the Replace Other option to set the Automatic Recalculation value back to 'Yes'. eTime Xpress will recalculate Shift Distributions using your preset business rules.
To Update the Recalculation Status of Worked Shifts:

  1. From the Time & Attendance Replace tool, select Other - the fields under Adjust should appear as shown in the figure below.


  1. Select the applicable Automatic Recalculation value.
  2. Click the OK button start the replace process.


3.8. Allowances

eTime Xpress allows allowances to be attached to shifts for payroll and billing purposes. Allowances may include mileage, per diems and other items.
From Time & Attendance, select a Worked shift and click the Allowances button under Shift Distribution. The Allowances screen should appear as shown in the figure below.
Shift Allowances

3.8.1. Create Allowance Types

eTime Xpress allows you to create the Allowance types applicable to your organization (i.e. meal allowances, health & welfare premiums, mileage, per diems etc.).
To create an Allowance types:
From the eTime Xpress Main screen, click Configuration > Codes Maintenance and select 'Shift Allowance Code'.

3.8.2. Add an Allowance


To Add an Allowance:

  1. Click the Add button ( ) on the Tool Bar - the fields in the Allowance Items browser should become active.
  2. Assign the Allowance type, unit amount, pay rate and bill rate as required. Remember for fields that require entry by codes, you may press the F5 key to bring up a list of valid entries.
  3. Press the Enter key to save your new Allowance record.


3.8.3. Update an Allowance


To Update an Allowance:

  1. Select an Allowance record and click the Update button ( ) on the Tool Bar – the fields in the Allowance Items browser should become active.
  2. Update the Allowance type, unit amount, pay rate and bill rate as required. Remember for fields that require entry by codes, you may press the F5 key to bring up a list of valid entries.
  3. Press the Enter key to save your changes.


3.8.4. Delete Allowances


To Delete an Allowance:

  1. Select an Allowance record and click the Delete button ( ) on the Tool Bar - the Confirm Delete dialog box should appear.
  2. Click 'Yes' to delete the selected Allowance.


3.8.5. Recurring Allowances

Recurring Allowances are rules can be created to automatically attach allowances based on predefined shift criteria.
To Apply Recurring Allowances:

  1. From Time & Attendance, click Tools > Recurring Allowances from the Menu bar.
  2. Specify the date range to calculate Recurring Allowances and click the Apply button. Allowances will be attached to shifts according to your Recurring Allowance rules.


Note: To setup Recurring Allowances, go to the eTime Xpress Main screen and click Configuration > Company/Branch > Branch Recurring Allowances. Please refer to the Administrator Guide for more information.
To Undo Recurring Allowances:

  1. From Time & Attendance, click Tools > Recurring Allowances from the Menu bar.
  2. Click the Log tab and select the instance which you want to Undo.


3.9. Setting Shifts to Locked

After completing the task of finalizing attendance and Shift Distribution information, it is recommended that Worked Shifts be to set to Locked. The Lock status grants read-only access to prevent accidentally deletion or changes to finalized Worked shifts. By locking shift records, you have a historical record of how shifts were paid and billed.
When locking shifts, you are required to specify a lock date. Lock dates may be used to track shifts by accounting periods. For example, when locking shifts for pay purposes, you may assign a lock date corresponding to the last day of the pay period in which the shift was paid. Payroll reports can then be generated by pay period using the shift's lock date. You may apply lock dates in a similar fashion for bill purposes.

3.9.1. Set a Worked Shift to Locked

When a shift is locked, the shift details, times, hours and rate information of Worked shifts are set to read-only.
To Set a Worked Shift to Locked:

  1. From Time & Attendance, select a worked shift you want to lock.
  2. From the Menu bar, click Data > Lock > Lock Shift - the Lock Shift dialog box should appear.
  3. Select whether you are locking the shift for Payroll and/or Billing purposes.
  4. Specify the lock date.
  5. Click the OK button to lock the selected shift.


To Set a Range of Worked Shifts to Locked:

  1. In the View Selector of Time & Attendance, specify the applicable filters for the shifts you want to view and click the Refresh button ( ).
  2. From the Menu bar, click Data > Lock > Lock All - the Lock Shift dialog box should appear.
  3. Select whether you are locking the selected shifts for Payroll and/or Billing purposes.
  4. Specify the lock date.
  5. Click the OK button to lock the selected shifts.


Note: Shifts can also be locked from the Payroll and Billing Main Screen by clicking on the Lock Shift ( ) or Lock All ( ) buttons.

3.9.2. Reset a Locked Shift to Worked


To Reset a Locked Shift to Worked:

  1. Select a Locked shift and click Data > Lock > Unlock Shift from the Menu bar - the Unlock Shift dialog box should appear.
  2. Select whether you are unlocking the shift for Payroll and/or Billing purposes.
  3. Click the OK button. The Locked shift will be reset to Worked and the lock status will be updated from 'Yes' to 'No' under the shift distribution area.


To Reset a Range of Locked Shifts to Worked:

  1. In the View Selector of Time & Attendance, specify the applicable filters for the shifts you want to view and click the Refresh button ( ).
  2. From the Menu bar, click Data > Locked > Unlock All - the Unlock Shift dialog box should appear.
  3. Select whether you are unlocking the selected shifts for Payroll and/or Billing purposes.
  4. Click the OK button. The selected Locked shifts will be reset to Worked and the lock status will be updated from 'Yes' to 'No' under the shift distribution area.


3.10. Other Options

Time & Attendance provides additional features as outlined below.

3.10.1. Set Time & Attendance Security

For organizations where payroll and billing information are managed by different departments or individuals, eTime Xpress allows you to hide payroll and billing information from specific users.
To Hide Payroll Information:

  1. From Main Menu, click Administration > Security > User Security from the Menu bar (requires user with administrator rights).
  2. Select the applicable user and click the Menu tab.
  3. Double-click (plus) next to Time & Attendance.
  4. Double-click the 'no' value next Pay Distribution until it reads 'yes'. The pay information of the Shift Distribution should be hidden in Time & Attendance as shown in the figure below.
  5. Click the Close button ( ) to return to the Main Menu.



Shift Distribution – Pay Information Hidden
To Hide Billing Information:

  1. From Main Menu, click Administration > Security > User Security from the Menu bar (requires user with administrator rights).
  2. Select the applicable user and click the Menu tab.
  3. Double-click (plus) next to Time & Attendance.
  4. Double-click the 'no' value next Bill Distribution until it reads 'yes'. The bill information of the Shift Distribution should be hidden in Time & Attendance as shown in the figure below.
  5. Click the Close button ( ) to return to the Main Menu.



Shift Distribution – Bill Information Hidden

3.10.2. Import Attendance Information

eTime Xpress integrates with both Celayix attendance solutions and 3rd party hardware to automate the flow of attendance information into eTime Xpress. Attendance information can be entered by employees via the Web, telephone, HandPunch or card swipe system and later imported into eTime Xpress.
The following is a list of common attendance solutions that can be integrated with eTime Xpress:

System

Description

Web Xpress

Web Xpress is Celayix's Web Time Sheet solution that allows employees to enter their time over the Internet.

Voice Xpress

Voice Xpress is Celayix's telephone based attendance solution that allows employees to check-in and check-out from shifts using a telephone.


Time Collection Devices

eTime Xpress integrates into a variety of time collection devices such as HandPunch, TraxG and XPocket time collection devices. Time records from other 3rd party time collection devices may also be supported using our standard CSV import template.


If you want to purchase any of the attendance solutions above, please contact your Celayix Software Sales Representative. Integrating eTime Xpress with an attendance solution requires additional configuration – please consult the respective user manual or contact Celayix support for assistance.

3.10.3. Exporting Shifts Distribution

eTime Xpress allows Shift Distribution information to be exported to a .CSV file.
From the menu bar in the Time & Attendance Main screen, click File > Export Shifts Distribution. Select Shifts Distribution and click OK.
For more information on exporting data from eTime Xpress, see the Global Features Guide.

3.10.4. Time Entry Settings

If you have licensed either Celayix's Voice Xpress or Web Xpress product, you can configure when employees are able to enter their time.
To configure your Time Entry rules:

  1. From Time & Attendance, click File > Time Entry Settings from the Menu bar. The Time Entry Settings dialog box should be shown as in the figure below.
  2. Specify the dates or date range rules when employees are allowed to enter their time.
  3. Click OK to save your Time Entry rules.


Time Entry Settings
Note: Voice Xpress and Web Xpress are additional products that are licensed separately from eTime Xpress. Both products require additional setup and configuration. Please refer to the installation documentation for these products.

3.10.5. Accruals

Accruals allow you to configure complex formulas to automatically calculate accrual balances such as holiday, sick time and other entitlements. Please refer to the Accruals User Guide for more information.
The Accruals module in eTime Xpress requires additional licensing. If you wish to purchase the Accruals Module, please contact your Celayix Software Sales Representative.

4. Using Payroll Main Screen

The Payroll Main screen allows you to manage the 'Life Cycle' of shifts over a pay period. From the Payroll Main screen, you can generate a view of Scheduled, Worked and Pay Locked shifts to ensure that all shifts have been properly processed at each stage. For example, if a pay period is Locked, it is recommended that a Scheduled and Worked view is generated to ensure that no shifts have been missed.
From the Main Menu, double-click Payroll. The Payroll Main screen should appear as shown in the figure below.
Payroll Screen with Annotations

Annotation

Description

(1) View Selector

Specify the date range and shift records to view.

(2) Shift Records

Displays shift records over date range with Worked and Locked status.

(3) Shift Information

Displays shift information including notes, shift status, bill OT status and pay lock date.


4.1. Review Shift Life Cycle

The following is a list of shift views available in the Payroll Main screen:

Shift View

Description

All Shifts

Displays all shifts over date range.

Scheduled

Displays Scheduled shifts over date range.

Worked

Displays Worked shifts over date range.

Locked

Displays shifts Locked for Pay over date range.

Unlocked

Displays shifts Locked for Bill but not Locked for Pay over date range.


4.2. Set Scheduled Shifts to Worked


To Set a Scheduled Shift to Worked:

  1. Select a Scheduled shift and click the Set Shift Worked button ( ) on the Tool Bar. The Scheduled shift will be set to Worked.


To Set a Range of Scheduled Shifts to Worked:

  1. In the View Selector of the Payroll Main screen, specify the applicable filters for the shifts you want to view and click the Refresh button ( ).
  2. Click the Set All Worked button ( ) on the Tool bar. All Scheduled shifts in the specified range will be set to Worked.


Note: Open shifts cannot be set to Worked - an Employee must be assigned to a shift before being categorized as Worked.

4.3. Reset Worked Shifts to Scheduled


To Reset a Worked Shift to Scheduled:

  1. Select a Worked shift and click Data > Worked > Reset Shift from the Menu bar. The Worked shift will be reset to Scheduled.


To Reset a Range of Worked Shifts to Scheduled:

  1. In the View Selector of the Payroll Main screen, specify the applicable filters for the shifts you want to view and click the Refresh button ( ).
  2. From the Menu bar, click Data > Worked > Reset All. All Worked shifts will be reset to Scheduled.


Note: Locked shifts cannot be reset. You must first remove the Lock status before resetting the Worked shift. eTime Xpress will skip any Locked shifts found in the specified range.

4.4. Set Worked Shifts to Locked


To Set a Worked Shift to Pay Locked:

  1. Select a Worked shift and click the Lock Shift button ( ) on the Tool Bar - the Lock Shift dialog box should appear.
  2. Specify the Pay Lock date.
  3. Click the OK button. The Worked shift will be Pay Locked and the Pay Lock date will appear in the shift information area.


To Set a Range of Worked Shifts to Pay Locked:

  1. In the View Selector of the Payroll Main screen, specify the applicable filters for the shifts you want to view and click the Refresh button ( ).
  2. Click the Lock All button ( ) on the Tool bar - the Lock Shift dialog box should appear.
  3. Specify the Pay Lock date.
  4. Click the OK button. All Worked shifts in the specified range will be Pay Locked and the Pay Lock dates will appear in the shift information area.


4.5. Reset Locked Shifts to Worked


To Reset a Pay Locked Shift to Worked:

  1. Select a Pay Locked shift and click Data > Locked > Unlock Shift from the Menu bar - the Unlock Shift dialog box should appear.
  2. Click the OK button. The Pay Locked shift will be reset to Worked and the Pay Lock date will be cleared in the shift information area.


To Reset a Range of Pay Locked Shifts to Worked:

  1. In the View Selector of the Payroll Main screen, specify the applicable filters for the shifts you want to view and click the Refresh button ( ).
  2. From the Menu bar, click Data > Worked > Unlock All - the Unlock Shift dialog box should appear.
  3. Click the Ok button. All Pay Locked shifts will be reset to Worked and the Pay Lock dates will be cleared in the shift information area.


5. Using Billing Main Screen

The Billing Main screen allows you to manage the 'Life Cycle' of shifts over a Bill period. From the Billing Main screen, you can generate a view of Scheduled, Worked and Bill Locked shifts to ensure that all shifts have been properly processed at each stage. For example, if a Bill period is Locked, it is recommended that a Scheduled and Worked view is generated to ensure that no shifts have been missed.
From the Main Menu, double-click Billing. The Billing Main screen should appear as shown in the figure below.
Billing Screen with Annotations

Annotation

Description

(1) View Selector

Specify the date range and shift records to view.

(2) Shift Records

Displays shift records over date range with Worked and Locked status.

(3) Shift Information

Displays shift information including notes, shift status, bill OT status and bill lock date.


5.1. Review Shift Life Cycle

The following is a list of shift views available in the Billing Main screen:

Shift View

Description

All Shifts

Displays all shifts over date range.

Scheduled

Displays Scheduled shifts over date range.

Worked

Displays Worked shifts over date range.

Locked

Displays shifts Locked for Bill over date range.

Unlocked

Displays shifts Locked for Pay but not Locked for Bill over date range.


5.2. Set Scheduled Shifts to Worked


To Set a Scheduled Shift to Worked:

  1. Select a Scheduled shift and click the Set Shift Worked button ( ) on the Tool Bar. The Scheduled shift will be set to Worked.


To Set a Range of Scheduled Shifts to Worked:

  1. In the View Selector of the Billing Main screen, specify the applicable filters for the shifts you want to view and click the Refresh button ( ).
  2. Click the Set All Worked button ( ) on the Tool bar. All Scheduled shifts in the specified range will be set to Worked.


Note: Open shifts cannot be set to Worked - an Employee must be assigned to a shift before being categorized as Worked.

5.3. Reset Worked Shifts to Scheduled


To Reset a Worked Shift to Scheduled:

  1. Select a Worked shift and click Data > Worked > Reset Shift from the Menu bar. The Worked shift will be reset to Scheduled.


To Reset a Range of Worked Shifts to Scheduled:

  1. In the View Selector of the Billing Main screen, specify the applicable filters for the shifts you want to view and click the Refresh button ( ).
  2. From the Menu bar, click Data > Worked > Reset All. All Worked shifts will be reset to Scheduled.


Note: Locked shifts cannot be reset. You must first remove the Lock status before resetting the Worked shift. eTime Xpress will skip any Locked shifts found in the specified range.

5.4. Set Worked Shifts to Locked


To Set a Worked Shift to Bill Locked:

  1. Select a Worked shift and click the Lock Shift button ( ) on the Tool Bar - the Lock Shift dialog box should appear.
  2. Specify the Bill Lock date.
  3. Click the OK button. The Worked shift will be Bill Locked and the Bill Lock date will appear in the shift information area.


To Set a Range of Worked Shifts to Bill Locked:

  1. In the View Selector of the Billing Main screen, specify the applicable filters for the shifts you want to view and click the Refresh button ( ).
  2. Click the Lock All button ( ) on the Tool bar - the Lock Shift dialog box should appear.
  3. Specify the Bill Lock date.
  4. Click the OK button. All Worked shifts in the specified range will be Bill Locked and the Bill Lock dates will appear in the shift information area.


5.5. Reset Locked Shifts to Worked


To Reset a Bill Locked Shift to Worked:

  1. Select a Bill Locked shift and click Data > Locked > Unlock Shift from the Menu bar - the Unlock Shift dialog box should appear.
  2. Click the OK button. The Bill Locked shift will be reset to Worked and the Bill Lock date will be cleared in the shift information area.


To Reset a Range of Bill Locked Shifts to Worked:

  1. In the View Selector of the Billing Main screen, specify the applicable filters for the shifts you want to view and click the Refresh button ( ).
  2. From the Menu bar, click Data > Worked > Unlock All - the Unlock Shift dialog box should appear.
  3. Click the Ok button. All Bill Locked shifts will be reset to Worked and the Bill Lock dates will be cleared in the shift information area.


6. Using Control Center to Record Attendance

The Control Center of eTime Xpress can be used to manually record attendance information as shifts are being worked. You can easily sort shifts by time and shift type to determine missed check-ins, check-outs and health & welfare (safety) checks.
From the eTime Xpress Main Menu, double-click on the Control Center button. The Control Center screen should appear as shown in the figure below.
Control Center with Annotations

Annotation

Description

(1) View Selectors

Specify the date and shift records to view.

(2) Shift Records

Displays shift records matching search criteria.

(3) Shift Information

Displays detailed shift information.


6.1. Load View

The Control Center allows you load only the shifts which you want to view and update.
To load shifts into the Control Center:

  1. From the View Selector, specify the applicable filters for the shifts you want to view.
  2. Start the shift load process by clicking the Refresh button ( ). Refresh clears your current view and loads shifts matching your specified filters.


6.2. Record Check-In/Out

The Check-In/Out values record the actual start and end times of a shift.
To Record a Check-in or Check-out:

  1. Select a shift and click the Check-In/Out button ( ) on the Tool Bar. The Check-In/Out dialog box should appear as shown in the figure below.


  1. Specify the check-in, check-out or break time as required and click the OK button.


6.3. Record Safety Check

The Safety Check is used where employees are required to perform regular call-ins for health & welfare or other service related updates.
To Record a Safety Check:
Select a shift and click the Safety button ( ) on the Tool Bar. The value in the Safe column for the shift will be populated with the current time.
To Reset a Safety Check:
Select a shift and click Data > Reset Safety > All or Shift in the Menu bar. The value in the Safe column for the shift(s) should be cleared.

6.4. Add a Shift


To Add a Shift:

  1. Click the Add button ( ) on the Tool Bar - the fields in the shift browser should become active.
  2. Assign the date, Customer, Site, start time, end time, break, Service and Employee. Remember for fields that require entry by codes, you may press the F5 key to bring up a list of valid entries.
  3. Press the Enter key to say the new record.


6.5. Update a Shift


To Update a Shift:

  1. Select a shift and click the Update button ( ) on the Tool Bar - the fields in the shift browser should become active.
  2. Update the date, Customer, Site, start time, end time, break, Service and/or Employee. Remember for fields that require entry by codes, you may press the F5 key to bring up a list of valid entries.
  3. Press the Enter key to save your changes.


6.6. Delete a Shift


To Delete a Shift:

  1. Select a shift and click the Delete button ( ) on the Tool Bar - a Confirm Delete dialog box should appear as shown in the figure below.
  2. Click 'Yes' to delete the selected shift.


6.7. Set a Shift to Open

Open shifts are shifts where no Employee is currently assigned (i.e. Employee ID is zero).
To Set a Shift to Open:
Select a shift and click the Set to Open button ( ) on the Tool Bar. The Employee ID will be set to zero and the description will be 'Open'.

6.8. Change Employee


To Change an Employee:
Select a shift and click the Change Employee button ( ) on the Tool Bar. Select the required desired employee from the lookup dialog box.

6.9. Employee Availability Search

The Employee Availability tool automates the process of finding and replacing employees for shifts. Searches are dynamic allowing you query your entire employee database based on criteria such as qualifications, experience and overtime.
From the Visual Scheduler, click the Availability button ( ) on the Tool Bar. The Availability dialog box should appear as shown in the figure below.

Employee Availability with Annotations

Annotation

Description

(1) Shift Details

Specify a shift that you want to assign an employee.

(2) Filters

Specify search criteria to filter your employee list. Appendix III Employee Search Filters provides detailed explanations of each search criteria.

(3) Available Employees

Displays employee matching search criteria defined in the Filters section. You then select the employee(s) you want to assign to the specified shift.

(4) Employee Filter

Select or create a user definable employee filter to search for specific groups of employees. To create your own filters, click button (see the Global Features User Guide for more information).


If you have different availability filtering rules, you may save profiles in the Settings Manager so for fast loading in the future. The Settings Manager allows you to save setting profiles to the database or to an xml file as well as setting your default availability settings. From the Availability screen, click Data > Settings > Settings Manager from the menu bar.
To run the Employee Availability tool:

  1. Select a shift or an empty cell and click the Availability button ( ) in the Tool Bar. The Availability dialog box should appear with the Shift Details automatically populated - if any shift information is missing, specify the necessary information.
  2. Specify the applicable search Filters and/or user definable employee filter and click the Search button. A list of employees matching your search criteria should appear under Available Employees.
  3. Select an employee and click the Add Shift or Update Shift button. The Visual Scheduler display should now show your newly created or updated shift.


6.10. Set Control Center Security

eTime Xpress allows you to set security on the Control Center to manage what dates are accessible as well as add, update and delete permissions.
To set Control Center Security:

  1. From the eTime Xpress Main Menu, click Configuration > Control Center.
  2. Select a User and define the applicable View and Edit permissions. If you select to 'Track Changes', you can review changes made through the Control Center by going to Reports > Scheduling > Control Center > Changes.