Revise Multiple Budgets

 

Expand/Collapse all Show/Hide All

Expand/Collapse item  Overview

You can revise multiple budgets for a single account while viewing and comparing budgets from various fiscal years, side-by-side with actual posting activity. You can revise multiple budgets manually by entering your changes in the Budget Maintenance window, or you can use the Change Budget window to automatically calculate budget revisions and apply them to periods in a budget. You can also use the Calculate Budgets Wizard in Budget Maintenance to revise several periods in a budget based on another source budget or activity. In addition, use the Select Budgets to Clear window to clear budget amounts for selected budgets back to zero if you want to re-enter budget amounts from scratch. You can perform these types of revisions in any order or combination.

Expand/Collapse item  Before You Begin

  • This procedure assumes you have set up budgets in the General Ledger Options window and have entered budget amounts for general ledger accounts.

  • You must first select the budgets to revise. For more information, see Select Budgets to View.

 

Use one, all, or a combination of the following methods to revise multiple budgets:

 

To automatically revise budgets using the Change Budget window

  1. Select General Ledger Budget menu > Budget Maintenance.

  2. Enter the account number. Only accounts that are not in use can be entered. For more information, see Budget Maintenance - Fields.

  3. In a budget column, select the budget amount that precedes the actual budget amounts to change and click the Change Budget button.

Note Revising budget amounts using the Change Budget window affects all budget cells below the selected cell in the same budget column. The Change Budget window bases its calculation on the value in the selected cell.

  1. In the Change Budget window:

  1. In the Change Method field, select a change method. For more information, see Change Budget - Fields.

  2. If the change method selected is Change by Percent, Accumulate by Percent, Change by Amount, or Accumulate by Amount, type a percent or amount in the Change Percent/Amount field.

  3. Click Proceed. The Budget Maintenance window appears and the budget amounts are revised automatically according to the change method applied.

Note The Reset button only applies to entries made to individual cells and is not available after using the Change Budget window; however, you can click the Reset All button to reset all amounts back to their original values.

  1. Repeat steps 3-4 for each budget column to revise for the selected account number. When you are finished, click Accept.

Budget values for the selected budgets are updated and the total for each budget revised is recalculated.

 

To automatically revise budgets using the Calculate Budgets Wizard

  1. Select General Ledger Budget menu > Budget Maintenance.

  2. Enter the account number. Only accounts that are not in use can be entered. For more information, see Budget Maintenance - Fields.

  3. Click the Calculate Budget button.

  4. In the Calculate Budgets Wizard, answer the questions.

Note When using the Calculate Budgets Wizard, the values used for the source budget are the saved values. If the source budget is currently selected in the Budget Maintenance window and has changed values that have not been saved, the unsaved values are not used.

After completing the wizard, the Budget Maintenance window appears and the budget amounts for periods you selected are revised.

Note The Reset button only applies to entries made to individual cells and is not available after using the Calculate Budgets Wizard; however, you can click the Reset All button to reset all amounts back to their original values.

  1. Repeat steps 3-4 for each budget column to revise for the selected account number. When you are finished, click Accept.

Budget values for the selected budgets are updated and the total for each budget revised is recalculated.

 

To clear budgets to zero using the Select Budgets to Clear window

  1. Select General Ledger Budget menu > Budget Maintenance.

  2. Enter the account number. Only accounts that are not in use can be entered. For more information, see Budget Maintenance - Fields.

  3. Click the Clear Budget button.

  4. In the Select Budgets to Clear window, select the Clear check box next to individual budgets or click the Select Clear All button to clear budget amounts to zero for all budgets. For more information, see Select Budgets to Clear - Fields.

  5. Click Proceed. The budget amounts for the selected budgets that were cleared are zero.

Note The Reset button only applies to entries made to individual cells and is not available after using the Select Budgets to Clear window; however, you can click the Reset All button to reset all amounts back to their original values.

  1. Click Accept.

Budget values for the selected budgets are updated and the total for each budget revised is recalculated.

© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks