Budget Worksheet Wizard - Calculation Options Panel

Access this panel using Activities>Budget Worksheet.

Use this panel to select the Calculation Basis (actual or budget history) for the worksheet and to indicate the Calculation Method. The calculation basis determines whether the system uses actual or budget history to create the budget entries. To use budget history, posted transactions from a previously entered budget must be available.

Because the budget is calculated using historical data, indicate whether to create the new budget based on actual activity (actual account balances) or budget activity (budget balances). If Budget activity is selected, the Administrator must select a budget version (Organization>Set Up Modules>Budget>Budget Versions).

 

Calculation Basis: Select the calculation basis to use for the budget entries.

• 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 the Administrator on Organization>Set Up Modules>Budget>Budget Versions) to base the budget entries.

Calculation Method: Select a method to use to calculate the budget:

• 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 system 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 dollar amounts.

The Calculation Basis is not available when "Zero Budget" is selected for the Calculation Method and "All " is selected for Activity Basis on the Account Types and Activity Basis wizard panel.