--- title: "E-Banking: How do I import NAI bank statement files?" canonical: "https://kb.myframeworks.com.au/space/PROSTIXV48DOC/31101561/E-Banking%3A%20How%20do%20I%20import%20NAI%20bank%20statement%20files%3F" format: markdown --- FAQ REVIEW AND APPROVAL TABLE TO BE COMPLETED Note : This table will be hidden when this FAQ is published. Complete the drop down selections first, then click 'Next' to replace the instructional text in grey with the detail of the FAQ. QUESTION: We are wanting to use a new NAB statement file format called NAI. How do I import NAI bank statement files? ANSWER: The National Account Information (NAI) file is a report produced by the National Australia Bank that provides on a daily basis a client’s full list of all account activity for a particular set of accounts. In relation to the NAB Connect business banking channel, this report is generally imported into the client’s ERP or Accounting package to provide automated reconciliation of their accounts. To import NAI bank statement files, you first need to perform a one off set-up to define the appropriate import format for the NAI files. R efer to step 1 below. To define the appropriate import format for the .nai files, perform the following: 1. From the ProStix Main Menu select ' Electronic Trade Module ' then ' ETM Input Control ' then ' Input Formats '. 2. Select (Add). Refer to the 'ETM Input Format' collapsible link below for a screenshot and an explanation of the options: Once the setup has been completed ( using the NAB Statement Transformation utility arunabstmt.p ) , you can convert any downloaded NAI files to .csv files to enable you to import the .csv file into ProStix E-Banking. Refer to step 2 below. To convert the .nai file into a csv file, which in turn can be imported using the ProStix E-banking feature, perform the following steps. 1. From the ProStix Main Menu select ' System Administration ' then ' Utilities ' then ' Run a Program '. 2. Type ' arunabstmt.p ' into the ' Which Program ?' field. 3. Type the path and file name for the Bank Statement file NAI file, then the output path of the csv file to be created. 4. Select < F1> (Go) to create the .csv file. The program will create a .csv file for each bank account set up in ProStix (often the .NAI file will contain multiple account numbers). Only the account/s set up in ProStix will extract to .csv, and one file will be created for each account number. 5. You are now able to im port the newly created .csv file using the newly defined import format ( NAB_ConvertedNAI.xml) . Refer to Loading Bank Statements into ProStix in the E-Banking User Guide for further information. If you would like to add program arunabstmt.p to the regular menu options, refer to Define Programs and Menu Maintenance in the System Administration User Guide . FOR FURTHER INFORMATION REFER TO: nab-connect file-formats.pdf Loading Bank Statements into ProStix found in the E-Banking User Guide. Define Programs found in the System Administration User Guide . Menu Maintenance found in the System Administration User Guide IF THIS FAQ DOESN’T RESOLVE YOUR ISSUE: Contact Sterland Support .