Payroll Export report columns "Regular Time" vs "Total Regular Time"

General support regarding TimeTrex, such as
configuring policies/taxes or processing payroll.
Post Reply
bobs
Posts: 11
Joined: Fri Dec 30, 2022 8:57 pm

Payroll Export report columns "Regular Time" vs "Total Regular Time"

Post by bobs »

In the Payroll Export report, I'm confused about the distinction between columns "Regular Time" vs "Total Regular Time".

Same with "Vacation" vs "Vacation (Taken)".

Would someone kindly clarify?
mikeb
Posts: 708
Joined: Thu Jul 27, 2006 11:58 am

Re: Payroll Export report columns "Regular Time" vs "Total Regular Time"

Post by mikeb »

"Regular Time" just includes time from the "Regular Time" pay code (Policy -> Pay Codes), "Total Regular Time" includes time from all pay codes that are associated with Regular Time policies, similar with "Total Overtime" and "Total Absence", etc... If you only have one regular time policy, these will always match. If you have more than one regular time policy, they could be different.

"Vacation" just includes the "Vacation" pay code (Policy -> Pay Codes). "Vacation (Taken)" (or any column labeled with "(Taken)" ) is the initial amount of absence time entered for that pay code, before other policies have been calculated. Typically these are the same, but they could differ if you include absence time into other policies such as overtime. In those cases, an employee could take 12hrs of vacation (12hrs taken), but 4hrs gets allocated to Overtime, therefore:

Vacation (Taken) = 12hrs

Which gets split into:
Vacation = 8hrs
Overtime = 4hrs
Total = 12hrs

Somewhat similar to a more common case of:

Worked Time = 12hrs

Which gets split into:
Regular Time = 8hrs
Overtime = 4hrs
Total = 12hrs.
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!
bobs
Posts: 11
Joined: Fri Dec 30, 2022 8:57 pm

Re: Payroll Export report columns "Regular Time" vs "Total Regular Time"

Post by bobs »

Thanks, mikeb. That's very helpful.
Post Reply