Use the Budget -- Revise import process when the total amount for an Adopted, Adjusted, or Revised budget has changed — for example, the monies available for the fund have been increased or decreased.
Use the Budget Exports to Text or the Budget for Revision Export To Excel to edit data for import into Budget Management.
Copy the downloaded spreadsheet, Budget - New-09112012.xls, and rename it something like Revise Budget.xls.
Open the spreadsheet, and click on the Update Budget Item Amounts worksheet. Note: Columns A - D are required.
Enter data in the columns as described.
Column A - Cycle Name: Enter the name of the accounting cycle for which you want to create budgets — e.g. FY15-16.
Column B - Fund Element Value: Enter the fund for which you want to create a budget.
Column C - Account Code: Enter the account code including hyphens.
Column D - Amount Type Name: Enter one of account types listed in the column header for this account code. Note: Be sure to enter the type exactly as it's spelled in the list.
Column E - Amount: Enter the budget amount for this account code. Note: You don't need to enter $, commas, or zero cents.
Column F - Comment: Optional. This text will be displayed in the Comment column in the Budget Items grid in the Budget Management window.
Repeat step 3 until you've created lines for all the budget items you want to revise. Note: You can use the Fill Down command to complete several of the columns.
Open Notepad, copy only the cells that contain data, and paste them into a new file. Save the file as something like Revise Budget Items.txt.
Save the spreadsheet.
Select Data Import from the Administration menu, and the Manage Data Imports window opens.
Select Budget -- Revise from the Batch Import Process pull-down list, and those processes are displayed.
Click the Update Budget Item Amounts link, and the Select file for data source popup opens.
Navigate to the location of the import file, select it, and click Open.
When the file is done uploading, click Save. You're returned to the Manage Data Imports window and notified that the file attached successfully.
Do not use the second task - Revise Budget - that will change the status to Revised and you can't make any changes. Go into Budget Management and review your proposed amounts then use the Revise command in Budget Management.
If the processes have been run previously, check the boxes, and click Reset. The status is changed to Not Run.
Leave the boxes checked, and click Include.
Leave the boxes checked, and click Execute Batch.
You're notified that the process is executing. When the process has completed successfully, you're returned to the Manage Data Imports window, and the status is changed to Succeeded. Note: If you get a message that the processes failed, click the Display Successes/Exceptions button.
Return to Budget Import Overview