VAT submission amounts should be a non-negative number less than 9999999999999.99 with up to 2 decimal places. Mtd-47

Absolute Excel VAT Filer  

The issue you are having is commonly due to one or more of the figures on your source spreadsheet being set to more than 2 decimal places.

Please check your source spreadsheet and if it looks as though your figures are set to 2 decimal places then 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.

After any changes, please re-link the cells to VAT Filer so that they then update, and this should resolve the issue.

 

 

 
 
 

Similar Articles

 

Tags