You define budget formulas to calculate budget amounts. Your budget formulas can be simple or complex. You can use any combination of fixed amounts and account balances, including actual or budget amounts, statistics, and period-to-date or year-to-date balances from the current period, prior period or same period last year.
When you define budget formulas, you create a budget formula batch. The batch contains one or more budget entries, and each entry contains one or more formulas. Use budget batches and entries to group your budget formulas. For example, you might combine all formulas for a single department or division into one batch, or group all formulas for certain types of calculations into separate entries. When you calculate budgets using a budget formula, General Ledger replaces any existing budget amounts directly; it does not create a budget journal.
Prerequisites
1.Enter a Name and Description for the budget formula batch.If you want to copy budget formula entries from an existing batch to your new batch, choose AutoCopy.
2. Enter a Name for the Journal formula entry.
Enter the formula entry Category.
Enter the formula entry Currency.
3. Enter a Line number to set the order of your budget formula entry lines.
Enter the Account whose budget amount you want to calculate with a formula.
Enter a formula for the line.
Calculating Budget Amounts
You must calculate budget amounts whenever you define or revise your budget formulas, or if you change the accounts you use in your formulas.
Calculating budget amounts from budget formulas does not create journal entries; rather, it updates budget balances directly. General Ledger replaces, rather than increments, the account balances with the calculated amounts.
When you define budget formulas, you create a budget formula batch. The batch contains one or more budget entries, and each entry contains one or more formulas. Use budget batches and entries to group your budget formulas. For example, you might combine all formulas for a single department or division into one batch, or group all formulas for certain types of calculations into separate entries. When you calculate budgets using a budget formula, General Ledger replaces any existing budget amounts directly; it does not create a budget journal.
Prerequisites
- Define your budget organizations and assign the budget entry type ”Calculated” to the accounts to which you want to budget.
- Define your budgets.
1.Enter a Name and Description for the budget formula batch.If you want to copy budget formula entries from an existing batch to your new batch, choose AutoCopy.
2. Enter a Name for the Journal formula entry.
Enter the formula entry Category.
Enter the formula entry Currency.
Enter the Account whose budget amount you want to calculate with a formula.
Enter a formula for the line.
You must calculate budget amounts whenever you define or revise your budget formulas, or if you change the accounts you use in your formulas.
Calculating budget amounts from budget formulas does not create journal entries; rather, it updates budget balances directly. General Ledger replaces, rather than increments, the account balances with the calculated amounts.
0 comments