Invalid monetary amount Mtd-39

Absolute Excel VAT Filer  

Please check that your figures are not more than two decimal places, the easiest way to check is to click into each box on the VAT return tab and check the number of decimal places being displayed in the formula bar.

You will need to open your Excel source file, click on File > Options > Advanced, scroll down to the section ‘when calculating this workbook’ and tick the box ‘set precision as displayed’.

Once you have done this you will then need to check the formatting on each of the cells for boxes 1 to 9 to make sure that they are set as number and to 2 decimal places.

We would recommend that you then re-link the cells to VAT Filer so that they then update and this should resolve the issue.

 
 
 

Similar Articles