How to reduce Gross NIable amount on Car Allowance when paying below HMRC approved rate for mileage?

Cintra iQ allows a reduction of the Gross NIable pay on Car Allowance when the milage rate is below HMRC approved rate and the Mileage is calculated by the Capture Expenses system. 

To get the system to calculate the NIable gross reduction you need to follow these steps:

1. Set up a new Ad Hoc heading that is not subject, to tax, not subject to NI and it is not paid. In this instance, it has no impact on the payslip. Let's call this heading 'HMRC Mileage Rate Difference'.
2. Our new heading needs to be shared with the Capture Expenses support team who will link it to the calculation on their end. Going forward this heading will be used to provide a value for the difference between the HMRC-approved rate and the reduced rate paid to employees for mileage claims if that is below the HMRC-approved rate.
3. Create a Numeric Expression function based on period calculation. This function will use the value of the HMRC Mileage Rate Difference heading and multiply it by (-1) to create a reduction.
4. Create a Conditional Function based on period calculation for any employee in payroll to have the numeric function applied
5. Create another Numeric expression based on period calculation for the car allowance payment to be changed to a negative value so it is then used as the maximum reduction of the gross NIable amount
6. Create a new heading under Period Payment Functions and set it up to be derived by the Functions you have created. Remember to include the secondary function to limit the maximum of the gross NIable reduction to the value of the car allowance. This heading needs to be NIable for Employee and Employer so it will reduce the NIable gross but it is not being paid to the employee.   
7. You can also remove this heading from being shown on the payslip
8. once this is ready, any employee who has a car allowance and the HMRC Mileage Rate Difference has been provided by Capture Expenses will have the Gross NIable amount reduced up to the value of the car allowance as in this example

Attachments (7)

6758587190cb....png
119 KB

6758587190cb....png
176 KB

6758587190cb....png
191 KB

6758587190cb....png
181 KB

6758587190cb....png
193 KB

6758587190cb....png
141 KB

6758587190cb....png
99.3 KB