Use budgeting to enter estimated account balances for a specified range of periods. You can use these estimated amounts to compare actual balances with projected results, or to control actual and anticipated expenditures.
General Ledger gives you a variety of tools to create, maintain, and track your budgets, including the ability to upload budget amounts from your spreadsheet software.
Define a budget to represent specific estimated cost and revenue amounts for a range of accounting periods. You can create as many budget versions as you need for a ledger. See: Defining Budgets.
You can create budget hierarchies by assigning a master budget to lower-level budgets. This enables you to track budgeted amounts against a control budget. See: Creating Master/Detail Budgets.
Define budget organizations to represent the departments, cost centers, divisions, or other groups for which you enter and maintain budget data. You can also define one general budget organization that includes all accounts. If you are using budgetary control, you set the budgetary control requirements for an account within its budget organization. Assign a password to each budget organization to restrict access to budget account balances. See: Defining Budget Organizations.
Enter the budget amounts. There are several methods you can use to enter your budget amounts:
Copy budget amounts from an existing budget. See: Copying Budget Amounts from an Existing Budget.
Enter amounts directly into the budget, replacing any existing budget amounts. You can also use budget rules to calculate and distribute amounts automatically across several periods. See: Entering Budget Amounts.
Create and post budget journal entries to maintain an audit trail of your budget entries. You can use budget rules to calculate budget journal amounts automatically. After generating budget journal entries, you can review, change, and delete them using the Enter Journals window. See: Entering Budget Journals.
Define budget formulas to calculate budgets based on other budget amounts or on actual account balances. You can use statistical amounts in your formulas. See: Creating Budget Formula Batches.
Define MassBudget formulas to allocate revenues and expenses across a group of cost centers, departments, or divisions. See: Defining MassBudgets.
Transfer budget amounts from one account to another. See: Transferring Budget Amounts.
Create a Microsoft Excel budget spreadsheet using the Applications Desktop Integrator's Budget Wizard, and upload the budget information into General Ledger.
See: Oracle Applications Desktop Integrator Users' Guide
Upload budget amounts from the budget interface table. See: Uploading Budgets.
Calculate budget amounts to update budget balances from your budget and MassBudget formulas. You should calculate budgets after you revise existing formulas, or whenever the balance of any account you use in a budget formula changes. See: Calculating Budget Amounts and Generating MassBudget Journals.
Perform online inquiries to review budget information. Use the Account Inquiry window to display complete budget balances, as well as actual or encumbrance balances. Use the Budget Inquiry window to compare summary balances between your master and detail budgets, and check for budget violations. See: Performing a Budget Inquiry.
Use the Financial Statement Generator to design a wide variety of reports that include budget information. These reports can include budget, actual, variance and variance percentage amounts. See: Overview of the Financial Statement Generator.
Define and run a consolidation to consolidate budget balances between ledgers. See: Defining Consolidation Definitions.
Freeze your budgets to prevent accidental or unauthorized changes. You can freeze all or part of a budget. See: Freezing Budgets.
Translate budget balances to create budget versus actual reports in your reporting currency using the Financial Statement Generator. You can also generate reports comparing different versions of your budgets in your reporting currency. See: Translating Balances.
If you are using Reporting Currencies (Journal or Subledger Transaction Level), you can define budgets and budget organizations in your reporting currency and enter budget amounts or journals directly in the reporting currency budget. Budget amounts and budget journals entered in your source ledger, such as your primary or secondary ledger, are not automatically converted in your reporting currency (journal or subledger transaction level).