Thank you for your feedback.

Was this useful?

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 VAT2 EC acquisitions VAT3 Total output VAT4 Input VAT5 Net VAT due6 Total sales7 Total purchases8 Total EC sales9 Total EC purchases
100200300400500600700800900

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.

Thank you for your feedback.

Was this useful?