Show/Hide All

 Overview

You can set up a budget by copying and applying revision calculations to another budget. This method allows you to prepare a new budget with no data entry. Also, use this procedure to revise a budget by increasing an existing budget by a percentage or an amount. The budget is updated immediately; there is no revision register.

 Before You Begin

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

 

To copy a budget

1. Select General Ledger Budget menu > Automatic Budget Copy.

2. In the Copy to Budget field, select the fiscal year of the budget and the budget to copy to. For more information, see Automatic Budget Copy - Fields.

3. In the Copy Based On field, select the fiscal year of the budget and the budget to copy from.

4. In the Revision Method field, select the revision method to apply to the budget selected in the Copy Based On field. For example, you can copy a budget and increase or decrease it by a percentage or an amount.

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

6. 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 Revision Amount field.

7. In the Rounding Factor field, select a rounding factor that determines how budget amounts are rounded.

8. Select the Enable Account Selections check box.

9. In the Select Field, Operand, and Value fields, select a range of accounts for copying budget amounts and applying the revision method to and click Proceed.

The selected budget is updated immediately. Print the Budget Report and review your changes.

 Example - Copied Budget Amounts

This example shows the Next Year Budget selected in the Copy to Budget field and the Original Budget selected in the Copy Based On field. The Original Budget's amounts are decreased by 10 percent and copied to the Next Year Budget.

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

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

Copy to Budget: Next Year Budget

Copy Based On: Original Budget

Revision Method: Percent Change

Revision Percent: -10.00%

 

Period	Original Budget	Next Year Budget
1.  JAN 31	100,000.00DR	90,000.00DR
2.  FEB 29	100,000.00DR	90,000.00DR
3.  MAR 31	100,000.00DR	90,000.00DR
4.  APR 30	150,000.00DR	135,000.00DR
5.  MAY 31	150,000.00DR	135,000.00DR
6.  JUN 30	150,000.00DR	135,000.00DR
7.  JUL 31	200,000.00DR	180,000.00DR
8.  AUG 31	200,000.00DR	180,000.00DR
9.  SEP 30	200,000.00DR	180,000.00DR
10. OCT 31	250,000.00DR	225,000.00DR
11. NOV 30	250,000.00DR	225,000.00DR
12. DEC 31	250,000.00DR	225,000.00DR
YTD TOTAL:	2,100,000.00DR	1,890,000.00DR