How do I Modify My Budget in Excel?
For various reasons, you may want to modify your budget in Excel.
This Step-by-Step tutorial guides you through the process of exporting the budget for one department to a spreadsheet, making some changes in Excel, and then importing the file back into the General Ledger.
The Financials offers a way to export your budget and modify it in Excel.
•For a visual tutorial, see the Modify Your Budget in Excel .png){kind=small}
video.
•All video tutorials can be viewed from the Tutorials & Videos page.
|
|
3 Common mistakes when importing a budget: •Importing the budget to the wrong year •Not entering income accounts as a credit using the minus key in Excel •Adding accounts to the Excel budget that have not been added to your Chart of Accounts
|
1. From the General Ledger menu, Select Modify -> Budget Information.
(1).png)
2. From the Budget Information page, click the Import/Export Budget button in the lower right-hand corner.
(1).png)
3. Select the Levels (Funds, Departments, etc.) that you would like to export.
(1).png)
4. Click the Export button. The file "BudgetExport.xlsx" is downloaded.
(1).png)
5. Open the exported file (BudgetExport.xlsx) in Excel or whatever spreadsheet program you have that allows you to edit the latest version of Excel files.
NOTE: If using Excel, you may need to click the Enable Editing button.
(1).png)
6. Enter Periodic (monthly) amounts in each field corresponding to the period name.
NOTE: All budget figures import as "by Period" unless the amounts are evenly distributed across the periods. In that case, they import as an "Annual" distribution type. Any rounding should be added to the first period. For example: If you enter $34.33 in each period and enter $34.37 to the first period, this account imports as an Annual budget of $412.
(1).png)
7. Be sure to save your changes.
(1).png)
8. From the Import/Export page, click the Choose File button on the right-hand side of the page.
(1).png)
9. Verify that the file chosen is correct and then click the Import button.
(1).png)
10. The Import Budget window appears and allows you to close if you do not want to import. Click the Import Budget button to import and overwrite the budget figures for the Fiscal Year you are working in.
(1).png)
11. A notification message appears when your budget is finished importing.
(1).png)