Replies (3)
Please login or register to join the discussion.
Split the calculation
You need to do the calculation in two parts.
Firstly, Take the Gross Pay and deduct taxable expenses and the unmbrella company margin. This leaves you with a subtotal (A) which represents the Adjusted Gross plus the Employer's NI.
Assuming that the taxable expenses are also deductible for NI purposes then you can now calculate the Adjusted gross (G) from A using the following formula:
G = (A + 18.768) / 1.138
It should now be straightforward for you to rework your spreadhseet, using the above formula.