More information

Budget Wizard

Budget Checklists

Budget Wizard - Calculation Options Panel

Access this panel using Activities>Budget Worksheet> Budget Wizard.

Use this panel to choose the Calculation Basis (actual or budget history) for the existing worksheet and to indicate a Calculation Method.

 

Calculation Basis: Because the budget is calculated using historical data, indicate whether to base the budget on actual activity (actual account balances) or budget activity (budget balances).

  • Actual, Budget - Select the type of activity, either Actual (actual account balances) or Budget (budget balances).
  • Budget Version - If "Budget" activity is selected, select a budget version (created by Administrator using Organization>Set Up Modules>Budget>Budget Versions) to base the budget entries.

Calculation Method: Select one of the following methods to use to calculate the following:

  • Average of History - The system calculates the average amount for all the periods included in the history and inserts the average into each budget period. The average is calculated by adding the amounts from each period and dividing the sum by the total number of periods. Thus, the amounts in each budget period are equal, making this the best method if the budget activity is constant.
  • Period Matching - The system matches amounts from the corresponding history period. For example, if the wizard finds $10 (USD) in the first period of history for an account, it enters $10 (USD) into the first budget period in the worksheet for the account. Thus, each period will match history, making this method ideal if you have cyclical revenues and expenditures.
  • Zero Budget - The system creates a zero amount budget line for each account combination that contains history (actual or budget depending on the basis selected). This zero budget is different from that in the Budget Worksheet wizard because it is looking at history to determine whether it should create a zero amount budget line. This method is usually used if you want the system to generate the account combinations only; you would manually enter the monetary amounts.