Open topic with navigation

 Show/Hide All

 Overview

You can revise all or a range of accounts in a single budget based on another budget without immediately updating the budget being revised. This procedure uses Budget Revision Entry to apply automatic budget calculations to all or selected accounts to create revision entries which you can further edit manually or adjust using the Change Budget window. After creating the revision entries, you must update the Budget Revision Register to save the changes.

 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.

 

To revise a single budget

1. Select General Ledger Budget menu > Budget Revision Entry.

2. In the Select Accounts to Revise window, set up the budget revision entries:

1. In the Budget to Revise field, select the fiscal year of the budget and the budget to revise. For more information, see Select Accounts to Revise - Fields.

2. In the Revise Based On field, select the fiscal year of the budget and the budget to use as the basis for the revision.

3. In the Revision Method field, select the revision method to be applied to the budget selected in the Revised Based On field.

4. In the Starting Period and Ending Period fields, select the starting and ending periods for calculating revisions.

5. If the revision method selected is Percent Change or Amount Change, type a percent or amount in the Revision Percent/Amount field. If the revision method selected is New Budget, type a new budget amount in the Amount field.

6. In the Rounding Factor field, select a rounding factor that determines how budget amounts will be rounded, and in the Precision field, select a precision that determines how budget amounts appear.

7. In the Period Column Width field, select a width for the period columns in the Budget Revision Entry window.

8. Complete one of the following options:

 To automatically create budget revision entries for a selected range of accounts:

1. Select the Enable Account Selections check box.

2. At the Select Field, Operand, and Value fields, select a range of accounts for revising budget amounts and click Proceed. The Budget Revision Entry window appears and is populated with revision entries created based on the options selected in the Select Accounts to Revise window.

 To manually create budget revision entries:

1. Clear the Enable Account Selections check box.

2. Click Proceed. The Budget Revision Entry window appears.

3. In the Budget Revision Entry window, create or edit revision entries using one, all, or a combination of the following methods:

4. Enter the Account No. field to manually add revision entries. For more information, see Budget Revision Entry - Fields. Revision entries that are manually added are based on the options selected in the Select Accounts to Revise window.

5. Manually edit existing entries.

 Use the Change Budget window to automatically edit entries.

1. In the Budget Revision Entry window, select a budget cell and click the Change Budget button.

2. Note: Revising budget amounts using the Change Budget window affects all budget cells to the right of the selected budget cell in the same row (this means that all periods greater than the selected period in the same row are affected). The Change Budget window bases its calculation on the value in the selected cell.

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

4. If the change method selected is Change by Percent, Change by Amount, Accumulate by Percent, or Accumulate by Amount, type the percent/amount change at the Change Percent/Amount field.

5. Click Proceed. The Budget Revision Entry window appears and the budget amounts are revised automatically according to the change method applied.

4. Click the Select Accounts button and repeat step 2 to select different revision options or to create additional revision entries in the Select Accounts to Revise window.

5. To delete all revision entries in the Budget Revision Entry window and start over again, click the Select Accounts button. In the Select Accounts to Revise window, click Clear. All entries are deleted immediately.

6. To view budget information for an account entered, select a row and click the Information Zoom button.

4. When you are finished, click Accept.

5. Print the Budget Revision Register and review the entries that were created.

6. When the register is correct, update the register.

The budget revision entries are updated.

 

 Example - Revised Budget Amounts

This example shows the Revised Budget selected in the Budget to Revise field and the Original Budget selected in the Revised Based On field. The Original Budget's amounts are increased by 20 percent and copied to the Revised Budget.

Account No: 74000-04-003-000-000

Description: Rent/Lease Exp.:Houston-Clay St.

Budget to Revise: Revised Budget

Revised Based On: Original Budget

Revision Method: Percent Change

Revision Percent: 20.00%

 

Period	Original Budget	Revised Budget
1. JAN 31	100,000.00DR	120,000.00DR
2. FEB 29	100,000.00DR	120,000.00DR
3. MAR 31	100,000.00DR	120,000.00DR
4. APR 30	150,000.00DR	180,000.00DR
5. MAY 31	150,000.00DR	180,000.00DR
6. JUN 30	150,000.00DR	180,000.00DR
7. JUL 31	200,000.00DR	240,000.00DR
8. AUG 31	200,000.00DR	240,000.00DR
9. SEP 30	200,000.00DR	240,000.00DR
10. OCT 31	250,000.00DR	300,000.00DR
11. NOV 30	250,000.00DR	300,000.00DR
12. DEC 31	250,000.00DR	300,000.00DR
YTD TOTAL:	2,100,000.00DR	2,520,000.00DR

 

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