Budget Methods

Sage 300 ERP

previous page next page

Home > Adding and Maintaining Accounts > Budgets > Budget Methods

Budget Methods

On the G/L Budget Maintenance screen, you select a budget method to specify budget method options that are used to calculate budget period amounts.

For more information about using this screen, see G/L Budget Maintenance Screen.

Budget Methods
Option	How to Use	How G/L Calculates Budget Amounts
Base, Amount Increase	When you select this option, the Base Amount and Amount Increase fields appear. In the Base Amount field, enter the base amount you want to begin with (that is, the base amount you want to use to calculate the budget for Period 1). In the Amount Increase field, enter the amount by which the base amount should be increased.	General Ledger uses the base amount you specify as the Period 1 Budget Amount. To calculate the budget amount for Period 2, General Ledger adds the amount increase to the base amount. To calculate the budget amount for Period 3, General Ledger adds the amount increase to the Period 2 amount. General Ledger continues to calculate budget amounts in this manner until all periods have a budget amount.
Base, Percent Increase	When you select this option, the Base Amount and % Increase fields appear. In the Base Amount field, enter the base amount you want to begin with (that is, the base amount you want to use to calculate the budget for Period 1). In the % Increase field, enter the percentage (in decimal notation) by which the base amount should be increased.	General Ledger multiplies the base amount by the percent increase to calculate the Period 1 budget amount. To calculate the budget amount for Period 2, General Ledger multiplies the Period 1 amount by the percent increase. To calculate the Period 3 budget amount, General Ledger multiplies the Period 2 amount by the percent increase. General Ledger continues to calculate budget amounts in this manner until all periods have a budget amount.
Copy, As Is	Select this option to copy or add the amounts in each period of the Inquiry Amount column into the corresponding periods of the Budget Amount column.	General Ledger copies the exact amounts in each period of the Inquiry Amount fields into the corresponding periods of the Budget Amount fields.
Copy, Amount Increase	When you select this option, the Amount Increase field appears. In this field, enter the amount by which the period amounts should be increased.	General Ledger adds the period amount in each Inquiry Amount field to the amount in the Amount Increase field, and then copies the result into the Budget Amount field for the corresponding period.
Copy, Percent Increase	When you select this option, the % Increase field appears. In this field, enter the percentage by which the period amounts should be increased.	General Ledger multiplies the amount in the Inquiry Amount field for each period by the percentage in the % Increase field, and then copies the result into the Budget Amount field for the corresponding period.
Copy, Prorated Spread	When you select this option, the Spread Amount field appears. In this field, enter the amount you want to prorate to the individual periods. Note: In a multicurrency system, you must enter the source and functional equivalents of other currencies separately if you want both sets of numbers. To calculate the functional equivalent from a source amount, inquire on the source amount, and then use the percent increase budget method. If the rate is less than one, use a negative percent increase (calculated by subtracting the rate from 1).	General Ledger performs a weighted distribution of amounts based on: The period amount in the Inquiry Amount field. The sum of period amounts in all the Inquiry Amount fields. The amount you specify in the Spread Amount field. The system uses the following equation to compute each period's budget amount: (Period inquiry amounts x Spread amount for period) / Sum of amounts (all periods) In other words, a ratio (weight factor) is calculated by dividing each individual period’s inquiry amount by the sum of the inquiry amounts for all periods. That weight factor is then multiplied by the spread amount you specify to arrive at each period’s budget amount.
Fixed Amount	When you select this option, the Fixed Amount field appears. In this field, enter a fixed amount.	General Ledger adds the fixed amount you specify to the Budget Amount field for each period.
Spread Amount	When you select this option, the Spread Amount field appears. In this field, enter an spread amount.	General Ledger distributes the spread amount you specify evenly across the Budget Amount fields for all periods. Note: If the amount cannot be divided evenly, the remainder is added into the last period.