...
The Intermediaries Report will use the current Engagement Type set against a contractor. if a contractor has changed engagement type during a reporting period then you will need to manually update the report to change/remove the values.
Note: if the report is amended in Excel you will need to open it in Notepad or similar and ensure that all dates are in the format dd/mm/yyyy.