The Import GL interface allows the user to import a general ledger file in Excel or csv format.
If prior year data exists, the mapped headers and sample data from the prior year data displays in the Data Comparison section. Looking at these headers and sample data and comparing it to the current year GL prior to importing your file is a good way to see if your current year GL contains the same headers and account structure as the prior year report.
The Imported GL Section displays the name and time of the imported GL if there is one, or an Import GL link button if a GL has not been imported.
To import a GL:
Click the Import GL link button.
An uploader window will display allowing you to select a file to import via the Browse button.
After selecting the file, click Upload.
Uploaded files must be .xlsx, .xls, or .csv. Csv files may be delimited by comma, pipe, or tab.
After the file is uploaded, the window will close and a progress bar displays the progress of the data import. You may leave this interface while the file is importing. The progress bar also displays on the dashboard.
When the file has completed importing, the file name and time of import will display in the Import GL section - refer to screenshot above.
To delete an uploaded GL:
Click the Delete link button for the file. Then click the O button to confirm or X to cancel.
If you have completed stages beyond importing the GL, you will need to revisit them after importing a different GL.
The Data Comparison section shows prior year mapped headers and sample data as well as the headers and sample data from the currently imported GL file.
Prior Year Mapped Headers and Sample Data:
If prior year data exists, the Prior Year Mapped Headers and Sample Data section always displays. Looking at the headers and sample data prior to importing your GL file is a good way to prepare your GL file for maxiumum success. Ensure your source GL file has the exact headers shown and the account structure is the same.
Current Year Imported GL Headers and Sample Data:
When a current year GL file has been imported, the Current Year Imported GL Headers and Sample Data section displays below the prior year section. It displays all the imported headers and sample data from the source file.
When both prior year and current year data exist, a message will display at the top of the Data Comparison section indicating whether all prior headers are present in the current year import or whether headers are missing.
Matched headers display in bold green text in both the prior year and current year tables.
Prior year headers which do not exist in the current year data display in red text.
Note: If your headers don't match, you may still proceed, but prior year data matching will be incomplete.
For more information on potential errors when importing the General Ledger please see the following article: Troubleshooting Report Upload Errors