Modifying a New or Revisions Budget Worksheet

To modify a New or Revisions Budget Worksheet, complete the following steps:

  1. Enter a Worksheet Name and press Tab. The Budget Worksheet wizard displays. Enter your budget criteria.
  2. After completing the wizard, the worksheet displays based on the worksheet type that was selected.

Use this worksheet to create a budget for the organization using monetary amounts or units and comparative information. The Budget Worksheet wizard creates a worksheet for any fiscal range; you can specify the G/L account types for budget entries (revenue, expense, both, or all available), and the segments, specific to budget data.

Remember that incomplete worksheets can be saved for editing at a later date.

  1. After completing your budget entries, be sure to run a validations check. If problems are found and you do not have time to correct them, you can change all of the failed Budget Items (B) to Comment Lines ( ). Click Save, to keep your worksheet in this state.
  2. Later, when you are ready to complete the budget, open the worksheet. Sort by Column A and edit all Comment Lines ( ) and change them back to Budget Items (B).
  3. Run the validations check again on your worksheet; once all budget items pass, you can Transfer the budget to Accounting or continue entering budget items.

Use this worksheet to make changes to existing posted budget items for the organization. (These budget items were posted using either Transactions>Enter Budget or Activities>Budget Worksheet>Transfer.)

  • Budget Items in the Revisions Worksheet can be added. Existing items can be modified, but the Account Codes, Effective Dates, and Posted Amounts cannot be modified. However, budget items can be entered in the Adjustments Incr/(Decr) column. Positive values represent an increase in the budget amount, while negative values represent a decrease. When an amount is entered in the Adjustment Incr/(Decr) column, the Revised Budget columns will recalculate as the sum of the Posted Budget amount and the Adjustment.
  • Additionally, Revised Budget amounts can be entered. If an amount is entered in a Revised Budget column, the Adjustment amount will automatically recalculate as the difference between the Revised Budget amount and the Posted Budget amount. (The Adjustment column entries are the only amounts entered as the transaction amount when the Revisions Worksheet is transferred.)

You can use both types of worksheets to:

  • Enter budget items - Enter as many budget items as needed. Entries are not validated as you type.
  • Run the Budget wizard - To add additional segment codes on the budget worksheet, you can run the Budget wizard. Run the wizard as many times as needed. However, keep in mind that the system may create duplicate entries if the same or similar criteria are entered each time the wizard is run. Data generated by the Budget wizard is inserted, starting in the row of your choice.
  • Use the Properties tab - A worksheet's comparative column headings (for a New Worksheet) and account types can be edited; however, a worksheet's segments and budget effective dates cannot be edited. If changes are required, a new budget worksheet must be created.