SB Enterprise Help Center

GL Import Budget From Excel

Updated on

Summary

The Import Budget from Excel process is used to import budget amounts into the application from a Microsoft Excel spreadsheet. The budget amounts imported into the application can be any type of budget amount (requested, proposed, approved, adopted, estimated actuals) and can be in any column on the spreadsheet, but the process can only be used to import the budget amounts of the next fiscal year. For example, if the current fiscal year (SS> Utilities> System Setup> Organization tab> Fiscal Year field) is 2023, the imported budget amounts will be posted to the 2024 budget. If you would like to import a budget for the current fiscal year you will have to set the current fiscal year to the previous year, import the budget amounts, run the Fiscal Year End Reset process (GL> Utilities> Fiscal Year End Reset) to copy the adopted budget amounts to the current budget and then set the fiscal year back to the correct year.

The fiscal year chart of accounts must be created before you can import the budget amounts into it. The chart of accounts for the next fiscal year can be created using the Create New Fiscal Year process (GL> Utilities> Create New Fiscal Year).

In order to import the budget amount from an MS Excel spreadsheet, all of the sections of the GL account number must be in a single column and separated by a dash (-). For example, if your GL account number format is XX-XXX-XXXX, then all three of those GL account number sections need to be in one column on the spreadsheet that contains the entire GL account number (01-001-0001).

The Import Budget from Excel process will overwrite the budget amounts in the application with the budget amounts that are being imported. For example, if GL account number 0-0-0001 has an adopted budget amount of $5000 in the application, that amount will be overwritten if you import an adopted budget amount for that GL account using the import feature. This only affects GL accounts that are included on the imported spreadsheet. If a GL account has a budget amount in the application but was not included on the imported spreadsheet, the budget amount of that GL account in the application will not be affected by the import process. When using the Import Budget from Excel process, make sure you are importing the budget amounts to the correct budget types (requested, proposed, approved, adopted, estimated actuals) and are not overwriting any budget amounts that should not be overwritten.

The Import Budget from Excel feature can be used to import budgets that have been exported from the application using the Export Budget Analysis (GL> New Budget Information> Export Budget Analysis) feature or can be used to import budgets into the application that have been generated in MS Excel. The Export Budget Analysis feature (GL> New Budget Information> Export Budget Analysis) is used to create an MS Excel spreadsheet from budget information already entered in the application. The budget amounts on the generated spreadsheet can be modified and then imported back into the application using the Import Budget from Excel process. Even if you have not already entered budget information into the application, the Export Budget Analysis feature can be used in order to generate an MS Excel spreadsheet that contains all of your GL account numbers in the correct format to be imported back into the application.

After the Import Budget from Excel process has been run and the budget amounts have been imported into a budget type (requested, proposed, approved, adopted, estimated actuals), the budget amounts can be copied to another budget type using the Copy Budget Information process (GL> New Budget Information> Copy Budget Information). You can also export the budget back into MS Excel using the Export Budget Analysis process (GL> New Budget Information> Export Budget Analysis), make more changes to the budget and then import the budget back into another budget type in the application. The budget amounts must be in the Adopted budget type before they can be copied to the current budget amounts when the fiscal year is rolled over.

If you want the imported budget amounts to become the budget amounts of the current fiscal year you will have to run the Fiscal Year End Reset process (GL> Utilities> Fiscal Year End Reset) to copy the adopted budget amounts to the current fiscal year budget.

Step by Step

1     Open the Import Budgets window (GL> New Budget Information> Import Budget from Excel).

 

2     Complete the Import Options section.

  • Click the BROWSE button and locate the Excel budget file by browsing through the file structure on your network. You can also drag and drop the file into the area next to the button.
    • The Configuration drop-down menu is used to select the import configuration you would like to use.
      • Non-Configurable will be selected by default.
    • The standard Springbrook Layout will also be selected by default.
    • Click VIEW LAYOUT/FORMAT to view the expected format of the import file.
  • Select the type of budget amounts you are importing in the Budget Type drop-down menu. The budget amounts in the spreadsheet will be imported into the selected budget type.
    • Adopted budget amounts will be copied to the current budget amounts (GL> Maintenance> Chart of Accounts> Budget tab> Budget field) when the Fiscal Year End Reset process (GL> Utilities> Fiscal Year End Reset) is run.
  • Click the Submit button to import the budget amounts.
Previous Article GL Export Budget Analysis
Next Article GL Account Analysis Report
Still Need Help? Contact Us