Copy a Budget

 

Expand/Collapse all Show/Hide All

Expand/Collapse item  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.

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 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.

Expand/Collapse item  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

 

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