IQ Report - Below Minimum Wage

Created by Martin Parkinson, Modified on Sun, 2 Jul, 2023 at 3:03 PM by Martin Parkinson

It is important that you make sure you are paying  Minimum Wage or above, so you will need to check if you have anything below minimum wage in your system.

There are 2 places you will need to check to see if they are below minimum wage, Rates and bookings. Below are IQ Reports for checking that your Rates and Bookings are the minimum wage or above.



Contents  (Click an Item to Jump to that section)

Rates below Minimum Wage

Example

Notes

Installation

Bookings below Minimum Wage

Example

Notes

Usage

Installation






Rates below Minimum Wage


This report will list details of any RATES agreements which have been setup where the 'Basic' rate is below minimum wage.
This report works for sites using the 'New' rates files (This is only available in Influence versions after ver 1.00.15.084)


Tip: You can tell if you are using the 'New Rates' file by going into a company record, choosing the 'Rates' page and checking.  If the rates page looks like the one below you are using the 'New' Rates and the report may work.


Back to top


Example - (Screenshot)


Notes/Special Features

The report uses the 'New' booking rates file and will only work if you are using these NEW rates.
The report will list any RATES that have been setup where the 'Basic' pay rate for PAYE, Ltd Co or Umbrella is below a minimum rate which the user enters.
Users can key-in the minimum rates - they will be prompted to enter the rate 3 times (e.g. for Oct 2015, this is £6.70)
The report can be found under the 'Booking Rates' file.


Back to top


Installation


You will need: IX_RATEUNDXX.IQX or IX_RATEUNDXX.ZIP

The report can be installed on Influence Professional systems from version 1.00.14.109 or later by downloading the report attached to this article, then Dragging/dropping the report onto the [I Query] workbench within the [Admin] section of the system. For more information about installing IQ Reports, please Click Here

On newer Systems you can load the *.zip version of the report.


Back to top

 







Bookings below Minimum Wage


This report will list details of Temp Bookings (days) created where the 'Basic' pay rate is below the minimum wage.

The report will prompt users to enter a minimum wage and will then list all bookings where the BASIC rate is below this value.


Example - (Screenshot)


Back to top


Notes/Special Features

The report looks at any bookings (days) which will occur on or after 1st October 2015.
The report prompts for a cut-off date for bookings.
The report will prompt for a rate and will look for bookings below  the entered rate
The report is based on the 'Candidate Booking Records' file.


Usage

If you enter the rate as the 'under 25' rate, then the system will find any bookings which are below this value. In SOME cases, these booking are OK because they are for workers who are under 25, but in some cases they will need to be reviewed (The report shows the AGE of the worker, so you can check if the rate is suitable for their age.) 

To check the relevant minimum pay rates please see the Government web site.


Back to top



Installation


You will need: IX_MINWAGXX.IQX or IX_MINWAGXX.ZIP

The report can be installed on Influence Professional systems from version 1.00.14.109 or later by downloading the report attached to this article, then Dragging/dropping the report onto the [I Query] workbench within the [Admin] section of the system. 

On newer Systems you can load the *.zip version of the report.


Back to top

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article