Entering Budget Values

Budget values are subject to the same journal validation, balancing and posting rules. The budget transactions are maintained to provide a full budget audit trial.

To use budget checking, you must first set up Budget Check Setup records.

Budget values can be entered onto the budget ledger using any of the following methods:

  • Ledger Entry (LEN)
  • Ledger Import (LIM)
  • Corporate Allocation Run (CAL)
Note: Before you use any of these methods to load budget values, you must use Change Budget (CBG) to access the budget ledger. The budget ledger is the ledger defined as the Primary Budget Ledger in the Business Unit Setup.

Budget transactions can be entered onto a budget ledger using Ledger Entry (LEN) in the same way as you would enter actual transactions. However, you may also prepare your budget file in a spreadsheet package, and then transfer the data to the budget ledger using Ledger Import (LIM).

Budgets can be as detailed as you require. You can create budgets for individual accounts by posting directly to these accounts.

If you report against budget on a summary basis, you can enter the budget for a range of accounts in any one account. For example, if you always report sales accounts as a range, you might set the budget in the first sales account in the budget ledger.

Budgets can also be entered by analysis code, for example, by department or project. To enter the budget for an analysis code or analysis code combination, you post a transaction to the budget account for the appropriate budget amount and reference the analysis codes on the transaction.

If you want to set a budget by analysis code only, you should post the budget to a single account and point all of the relevant actual accounts to this one budget account.

When entering the budget into the ledger, budget records are created for the unique combination of the following:

  • Account Code - this must be the Budget Check Account defined on the Budget Check Setup.
  • Period
  • Analysis Code 1 (optional - dependent on the Budget Check Setup)
  • Analysis Code 2 (optional - dependent on the Budget Check Setup)
  • Analysis Code 3 (optional - dependent on the Budget Check Setup)
  • Analysis Code 4 (optional - dependent on the Budget Check Setup)
  • Analysis Code 5 (optional - dependent on the Budget Check Setup)

The above details are taken from the journal when posted. The normal Chart of Account and Journal Type rules apply, so care must be taken with mandatory, optional, prohibited analysis and so on. Budgets must be entered in the base currency.

On posting the journal, entries are made in the Primary Budget Ledger, and also in the budgeting tables. The budgeting tables are used by the budget checking functionality. The Primary Budget Ledger is then used for reference only.

For purchase orders and purchase invoices, amounts are entered as debit amounts. The following is an example of a journal entry:

  Account Analysis Period Amount D/C
Line creating budget check records Budget check account code Optional Period in which the budget is entered Budget amount for that period D
Balancing line Miscellaneous account code Not relevant Period in which the budget is entered Budget amount for that period C

Example 1 of a budget:

Account Period Budget
A 11/2005 USD 100
A 12/2005 USD 150
A 01/2006 USD 200
A 02/2006 USD 100
and so on    
A 12/2006 USD 100
B 11/2005 USD 100
B 12/2005 USD 100
B 01/2006 USD 150
and so on    

Example 2 of a budget:

Account Period Analysis Code 1 Budget
A 11/2005 Dept A USD 100
A 11/2005 Dept B USD 100
A 12/2005 Dept A USD 150
A 12/2005 Dept B USD 100
A 01/2006 Dept A USD 200
A 01/2006 Dept B USD 200
A 02/2006 Dept A None
A 02/2006 Dept B USD 150
and so on