TimeTrex Time and Attendance

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?

"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.

Thanks, mikeb. That's very helpful.