VAT Filer- Excel import but get Index out of Range warning (Negative)

Article ID

vat-filer-excel-import-but-get-index-out-of-range-warning-negative

Article Name

VAT Filer- Excel import but get Index out of Range warning (Negative)

Created Date

25th November 2021

Product

Problem

IRIS VAT Filer- Index out of Range (Negative) when i try and import a Excel spreadsheet

Resolution

You have tried to import the Excel spreadsheet but you keep getting this warning.

1. Create a new Excel spreadsheet with the clients VAT figures saved on your pc.
2. This file must have the headings and figures saved like this below (Note: the values below the headings are test numbers). Do NOT use the dash symbol ‘-‘ for a value (use ‘0’ instead) as it can cause the VAT filer to close.

1 Output VAT	2 EC acquisitions VAT	3 Total output VAT	4 Input VAT	5 Net VAT due	6 Total sales	7 Total purchases	8 Total EC sales	9 Total EC purchases
100	200	300	400	500	600	700	800	900

3. Now import this Excel file.

4. If you get the same warning then create a new CSV file with the clients VAT figures saved on your pc 0 just like the on step 2). You can now import this rather then a excel spreadsheet.