If your agency pays or tracks commission for consultants, you can set up split commissions for a placement between up to five consultants on the placement profile. You can choose whether to force the total of the splits to be equal to 100% or allow non 100% totals. Split commissions against a placement can be made mandatory but are optional by default. The values set here are used in the Margin Report. If you'd like to make split commissions mandatory or set the % values more than 1 decimal place (e.g. 25.75% and 74.25%) please contact the Support team.
Invoice Exports and Margin Report
Split commissions can be captured and output when exporting invoices to your external accounting system. We can enable export configuration to split invoice lines according to the consultant split commission. Please contact the Support team if you require this for your accounts system.
You can report on the commission per consultant against timesheets and expenses using the Margin Report functionality in InTime. This is shown as below:
Additionally, you can forecast the commission for consultants on periods in the future. To do this, you must have contracted hours set against the placement profiles in your agency for the estimated commission values to be calculated. When running the margin report you need to ensure the Status selected is Missing.
The forecast value given is based on a calculation of (contracted hours x default charge rate) x commission value (for example 40 x 12.50 x 0.5 = £250 projected value of 50% commission on placement with contracted 40 hour week at £12.50 per hour charge rate).
Split Commission Settings
Split commissions are stored against timesheets and expenses submitted against placements where commissions are set. These are then reported on in the Margin Report. You can choose how commissions are managed and captured within InTime via System Administrator > System Split Commission Settings. Please note: be careful when making changes to the split commission settings as any Support needed to reverse incorrect settings may be subject to charge.
Any changes made to these setting are not retrospective so will only be applied to future created timesheets/expenses. There are four options available:
Always use the current placement value
With this method the values always reflect the value from the placement. This means that if you change the values on the placement then the margin report will change to reflect the current value.
Advantages: You can retrospectively change the split commissions for a placement by simply adjusting the values on the placement
Disadvantages: The margin report is not fixed in time
When the client invoice is generated
This method results in a copy of the split commissions being taken at the time the client invoice is generated.
Advantages: The margin report is fixed at that point in time. The process is performed automatically on invoice creation so there is no manual stage to remember
Disadvantages: It is more complex to make alterations if the split commission was wrong at the time the invoice was generated
When the purchase invoice is generated or the timesheet is exported for PAYE
With this method the split commissions are fixed when the purchase invoice is created for limited company workers or when the timesheet is exported for PAYE workers.
Advantages: The margin report is fixed at that point in time. There is no manual operation to remember as the information is stored as part of the payment of workers/invoice generation
Disadvantages: It is more complex to make alterations if the split commission was wrong at the time the invoice was generated
When the timesheet is exported
This method allows you to fix the split commissions based on when you export the timesheets.
Advantages: The margin report is fixed at that point in time. You can control when this is done independently of when you generate your purchase invoices
Disadvantages: It is more complex to make alterations if the split commission was wrong at the time the invoice was generated. You must remember to run the timesheet export process for limited company workers, otherwise your commissions will not be fixed.