There seems to be an error with the Box 5 calculation on spreadsheet v1.1 where a formula for returning Absolute numbers has been inserted.
This is causing VAT to be reclaimed appearing as a positive figure (to pay) rather than a negative (to reclaim).
As an example:
Box 3 = 85.20
Box 4 = 185.19
Box 5 = 99.99
(Box 5 results of the subtraction of Box 3 for Box 4) the correct value on Box 5 should display = -99.99 (to reclaim)
Is this a known issue? And is there a solution for this?
I’m late on the VAT submission and don’t want to process it without knowing if this method works…