Do you want to prorate hours?
This option is available to users of e-timecard standalone only. The export program can calculate prorated hours based on the standard hours divided by the actual hours entered by the employee. You establish standard hours on the Employee Types screen. The proration does not change the actual time card record. It affects only the ASCII export file.
If you check the Calculate Prorated Hours box, then you must turn this feature on for each employee type for which you want to perform the calculation. Also note that you can exclude certain earning codes from the proration calculation.
Example
An employee enters the following hours on a time card.
Job |
Earning code |
6/7 |
6/8 |
6/9 |
6/10 |
6/11 |
Total |
AAA |
REG |
5 |
|
5 |
|
|
10 |
BBB |
REG |
10 |
10 |
10 |
10 |
10 |
50 |
CCC |
REG |
|
|
|
|
10 |
10 |
Total hours |
|
15 |
10 |
15 |
10 |
20 |
70 |
The standard hours for this employee’s employee type is 40. When you run an export, the program calculates the factor to prorate as follows.
standard hours/ total time card hours for the period
= 40 / 70
= 0.57
e-timecard can generate the ASCII file by either a summary record for each job/earning code combination or a detail record for every entry on the time card. Read details on selecting one of these options.
If e-timecard generates the ASCII file by summary, then the program multiplies the total hours for each job/earning code by the prorate factor to obtain the prorated hours. This information appears in the ASCII file:
Job |
Earning code |
Total hours |
Prorated hours |
AAA |
REG |
10 |
5.71 |
BBB |
REG |
50 |
28.58 |
CCC |
REG |
10 |
5.71 |
If e-timecard generates the ASCII file by a detail record for every time card entry, then the program multiplies the hours for each job for each day by the prorate factor to obtain the prorated hours. This information appears in the ASCII file:
Job |
Earning code |
Date |
Hours |
Prorated hours |
AAA |
REG |
6/7 |
5 |
2.88 |
AAA |
REG |
6/9 |
5 |
2.86 |
BBB |
REG |
6/7 |
10 |
5.71 |
BBB |
REG |
6/8 |
10 |
5.71 |
BBB |
REG |
6/9 |
10 |
5.71 |
BBB |
REG |
6/10 |
10 |
5.71 |
BBB |
REG |
6/11 |
10 |
5.71 |
CCC |
REG |
6/11 |
10 |
5.71 |