Importing Budget into EIQ
Summary: This document explain how to import the budget into EIQ from an Excel Spreadsheet. The spreadsheet should be formatted correctly for the import to work and the correct budget year etc. needs to be chosen. When going to a new budget year the Period information on the Budget Import will need to be changed
Excel Format
- The account numbers should be formatted with the following layout with the dashes inside of the account number need to be added.
- The Amount fields should be a number field with the decimal set to two places
- Please assure that there are no blank extra lines at the end of the spreadsheet
- Note: The file must be in the older XLS (excel 97-2003) file format
Importing the Budget
- Go the General Journal Module – GL Tab/ GJ Entries
- Select any Journal Entry in the Picklist or Create a new one if one does not exist
- Go the File Menu and choose Import External File
- Select the Budget Import from the Picklist
Assure the following is correct
- File Type should be Excel
- Records to Skip should be 1 – in other words you need to tell the system how many rows to skip to find the first G/L Account
- Budget Code: By default this is the default budget other budget types can be created.
- Fiscal Year: This is the G/L year that you want to import the budget into, note that if you are changing to a new G/L year you will need to go in and update the Period information
- To Update the period information click on the Period field and select the ellipses from the pick list choose the appropriate Period to match the Month column
- Repeat until all fields have been updated.
- Performing the Import
- Select the Open File button – locate the Excel spreadsheet that you wish to load into EIQ – make sure to set the file type to excel
- After the system loads the Prep Table select the Load Into System Tables Button
- When the process is complete you will get a Message saying ‘Import Completed Successfully’