As the Fiscal year winds to a close, we need to look forward towards budgeting our new year. If you have the optional module, Budget Management, you have the capability to quickly import your budget into The Financial Edge with ease.
It is important to note that you should define budgets from the Project perspective first. Because when you create a Project Budget, the program automatically updates the account budget. The only time you need to create the budget from the account occurs when you have a figure to be budgeted to the account, but not distributed to a project. In an upcoming blog post, I will go into further detail about importing budgets with both project and account distribution.
We have sample import files available for your different budget types located in our General Ledger Importing Article . Our sample import files include the Budget Scenario Import ID in the first column of the import along with the other required fields. We recommend using this to identify to which Budget record you are importing, as it is a unique ID specific to that record. This can be found by creating the Budget record:
In General Ledger, click Records, Budgets, New Budget
Select the desired Scenario ID and Fiscal year, and click Load Now
Select File, Save
Select File, Properties to view the Import ID
Once our CSV file has been created with the necessary budget information listed in the sample file, we may begin importing! In General Ledger, we’ll want to select Administration, Import Records, highlight either Fiscal Year Account Budget or Fiscal Year Project Budget, and click New Import. In the import parameter screen, choose the settings below.
more
