How to load rates to get the correct outcome for your client:
- The gross rate is £55.00 and the end of line hover over is correct for both values
However, on the document where the rate is expressed as nett, the actual calculation of 9 x £45.83 is incorrect at £412.50 when it should be £412.47
This is caused by a rounding issue, to deduct 20% VAT from £55 you divide by 1.2. 55 divided by 1.2 = 45.83333333333
- Rather than loading the gross rate of £55, load the net rate of £45.83 on the charges table, as the recurring .3 has been rounded down the hover over calculations are slightly lower
On the document, the total of the line is correct for a nett figure 9 x £45.83 = £412.47
- Alternatively, you could load the total value of the charge with the detail in the description:
On the document, the calculation is correct, the rounding issue is not affecting this total.