A purchase invoice entered using a partial exemption SuiteTax code results in a supplier bill total that is £0.01 higher than the supplier's invoice.
This issue impacts not only the VAT amount but also the Accounts Payable balance, resulting in a supplier liability that does not match the supplier's legal invoice
What is the recommended approach to negate this issue?
Transaction Example
Supplier Invoice
Net Amount: £2,076.92
VAT Amount: £415.38
Invoice Total: £2,492.30
Supplier VAT Calculation
£2,076.92 × 20% = £415.384
Rounded to £415.38
NetSuite Result (Partial Exemption Code)
Net Amount: £2,076.92
VAT Amount: £415.39
Invoice Total: £2,492.31
Difference
Supplier Invoice Total: £2,492.30
NetSuite Invoice Total: £2,492.31
Variance: £0.01
Tax Detail Breakdown
NetSuite generates two tax components:
Tax Type | Tax Rate | Tax Amount |
|---|
VAT_GB_Deductible to Item Cost | 18.26% | £379.25 |
VAT_GB_REC | 1.74% | £36.14 |
Total VAT | 20.00% | £415.39 |
NetSuite calculation
£2,076.92 × 18.26% = £379.244592 → £379.25
£2,076.92 × 1.74% = £36.138408 → £36.14
Total VAT = £415.39
I have tried rounding off, rounding up and down and each time there is a penny difference. This is one line invoice so there is no transaction level rounding taking place, although I have tried transaction line level rounding as well.
I have entered the rate or just the amount but again the rounding is still calculated.
The only way I have been able to match these up is to override the values for the tax after suitetax has made the calculation. This is not acceptable as they are importing invoices and many have partial exemption.
I look forward to hearing from you :)