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.
- Create a new Excel spreadsheet with the clients VAT figures saved on your pc.
- 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.
We are sorry you did not find this KB article helpful. Please use the box below to let us know how we can improve it.