Now that your import template is populated and saved in *.cvs format you can import your data! The import functionality is located in the same location as where you found the import template, in Company Setup Checklist in Company > Data > Import Data.
Locate the line for Accounts Payable Bills and click the ‘Import’ hyperlink.
You will want to select the ‘Choose File’ button in order to locate and select the csv file you saved for this import. It’s important to ensure you select the proper date format from the ‘Date format’ dropdown in order to avoid import errors.
The ‘Post to’ radio button is an indicator of whether you are importing live or historical transactions. If you have already imported the GL Entries separately you will only import these AP Bills into ‘Historical’. Choosing ‘General Ledger’ here would also import them as live bills and they will be posted into the GL. In our example we have already imported the starting GL Entries so importing these into the General Ledger would result in duplicate entries.
If you are importing a large number of records it’s generally preferred if you process the import offline. Instead of being immediately imported your process will be placed in a queue behind others who have already utilized this feature. This functionality is helpful when uploading a large number of transactions. Because the importing of a large number of transactions can take a lot of time it is useful to use this functionality when you wish to continue working on other things within Intacct while the import runs.
When you are satisfied with your selections in this window, click ‘Import’.
If there are issues with your import you might get an error message similar to the following.
If some records imported and others didn’t, it’s important to click the red text on the notification and save the error file. This file will contain only the problem records. For example, if your original import was 200 records and 80 failed, then the error file you download will contain the 80 failed records. The reason for this is so that it’s easy for you to repair the records that didn’t import, and then import them again. For more information on why the records failed you will need to check your error message email for more detailed information. Once you have gone through your error message email and repaired the problem records you can then import them again. We will go over how to read the email error messages more in depth next week.
Please note: When uploading immediately the error file is only available to download from the link shown in the pop-up above. If you close the window your error file will be lost. You will then need to go through Intacct and your original CSV file in order to determine which lines imported and which failed.
Since my error was all of the records I will open my original CSV file, fix the issues there, then re-run the imported. The act of importing may be a single process or multiple repetitions until you get all the records imported without errors.
