Missing Rates Report

Overview

The Reports > Payroll > Missing Rates Report checks the rules and rate cards assigned to employees, identifying any data that is missing.

Jobs will be flagged in this report if: 

• The Rate Card assigned to the Job does is missing a Rate that is used in the Rule Group
• The Job does not have a Rate Card assigned to it

You can navigate directly to a rule group, rule or rate card by clicking on the link in the report. It could be that the name of the Rate on the Rate Card doesn't match the name of the Pay Item used in the Pay Rule. the Rate Card may be the incorrect one, or the wrong Rule Group may have been assigned to the Job. Once you fix the issue, regenerate the report to confirm it's fixed. 

On-Screen Columns

The on-screen report will show the following data:

• Employee
• Job
• Rule Group
• Rule
• Rate Card
• Missing Rate

Export Options

You can export the on-screen report in .pdf and .csv format. A Detailed .csv file can also be downloaded, which will contain the following data:

• Employee MID
• Remote ID
• Employee Name
• Job UID
• Job Code
• Job Name
• Billing Entity CM_CID
• Billing Entity Name
• Sub Entity One
• Sub Entity Two
• Workplace WID
• Workplace Name
• Customer BID
• Customer Name
• Job Start Date
• Job Finish Date
• Rule Group RGID
• Rule Group Name
• Rule RID
• Rule Name
• Rate Card PGID
• Rate Card Name
• Missing Rate PCNID
• Missing Rate