A new feature we have released is allowing you to create a ‘Net pay deduction – Invoice’ directly from the timesheet import, and manual timesheets screen. This means you no longer need to create this specific ‘Pay Element’ in the Pay element screen before raising the invoice.

These deductions need to be inputted as a negative rate amount to align with the agency’s invoice as well as match the total timesheet amount. The system will then create the relevant pay element within the ‘Pay elements’ screen by converting the negative amount into a positive deduction.

The logic for raising this pay element via the import screen is similar to raising other frequencies (e.g. expenses).

And therefore you will need to make sure there is a frequency column so that the system knows to raise this as a Net pay Deduction on the invoice. In this column you will need to have ‘Net Pay Deduction Invoice’ and the rate will need to be negative as below:

You can then import this timesheet as normal and the invoice will raise with an additional line item with the deduction added.

If you do not add this to the timesheet import, you can edit and select this frequency during step 2 of the process.

Upon completion of the timesheet import, we have now given a ‘Timesheet ID’ which corresponds to the new ‘Created From’ column in the Pay Element screen to provide you with a record of any ‘Deductions Net Pay Invoice’ created from the timesheet import. If you hover over the phrase ‘Timesheet Upload’, it will show the ID it relates to:

Similarly, you can raise this pay element within the manual timesheets screen. Upon selecting the units, you now have the option the select ‘Deduction Net Pay Invoice’ and insert a negative rate. The system will prevent you from raising the invoice if the rate is positive when selecting ‘Deduction Net Pay invoice’.

As with the import screen, this will automatically create a pay element with the ‘Pay Element Screen’.