Time And Attendance Exports

Please note, these exports will only work for Attendance+ customers. For more information please contact RotaMaster Support.

Gross Pay TnA

This export shows a summary of the Gross Pay for any shifts that have been clocked into and out of on time, have an early clock in or late clock out matched exception (processed or unprocessed) or a processed late clock in or early clock out exception. Shifts that have a missing clock, or an unprocessed late in or early out exception will not be included.

• Staff Member’s Name
• Company – This refers to individual Staff References set up in Personnel Manager>Personnel Record>Employment Details
• Primary Rota Group – This is the Rota Group the staff member will sit under in Personnel Manager
• Gross Pay – Gross pay for all viable shifts
• Payroll Date – The date Payroll was run

Hourly Rate TnA

This export shows a breakdown by hourly rate for any shifts that have been clocked into and out of on time, have an early clock in or late clock out matched exception (processed or unprocessed) or a processed late clock in or early clock out exception. Shifts that have a missing clock, or an unprocessed late in or early out exception will not be included. The hours worked are broken down by hourly rate. This export doesn’t contain adjustments. You will be given the following information:

• Staff Member’s Name
• Payroll ID – This is set up in Personnel Manager>Personnel Record>Finance References
• Company – This refers to individual Staff References set up in Personnel Manager>Personnel Record>Employment Details
• Primary Rota Group – This is the Rota Group the staff member will sit under in Personnel Manager
• Duration – This is the length of the shift in hours
• Hourly Rate – The hourly rate determined by the Pay Rate Group.
• Pay Rate Reference – The reference assigned to the pay rate group
• Total – Total value of the shift
• Payroll date - Last day of payroll run

Hours and Pay TnA

This export shows a breakdown by hourly rate for any shifts that have been clocked into and out of on time, have an early clock in or late clock out matched exception (processed or unprocessed) or a processed late clock in or early clock out exception. Shifts that have a missing clock, or an unprocessed late in or early out exception will not be included. The hours worked are broken down by hourly rate. This export will also calculate the hours and pay per adjustment reason per person. You will be given the following information:

• Last Name
• First Name
• Payroll ID – This is set up in Personnel Manager>Personnel Record>Finance References
• Rota Group/Adjustment Reason – Shows the adjustment reason for adjustments and the
• Amount – Gross pay per
• Hours – Duration of shift/adjustment
• Payroll Date - Last day of payroll run