CREATING A BUDGET SPREADSHEET UPDATE

You can upload budget amounts to your budget organization for an existing account that falls within the account ranges assigned to your budget organization. You can determine the correct display size and attributes (alphabetic, numeric, right-justify zero-fill, and so on) for each segment in your account using the Value Sets window.ģ.Ğnter the accounts for which you want to upload budget information from your spreadsheet. For example, if display size is three, then your segment value would be '100,' but if your display size is four, then your segment value would be '0100'. Display size tells you how wide Budget Upload expects each segment value to be. For example, value '01' is not the same as value '1'. Make sure you specify segment values correctly. To determine the order in which your General Ledger application stores your account segments, you need to reference the GL_CODE_COMBINATIONS table.Ģ. To specify accounts in your spreadsheet:ġ.ěefore you enter account segment values into the segment columns of your spreadsheet and Budget Interface table, determine to which column you assigned each account segment using the Key Flexfield Segments window.īudget Upload assumes you enter values for account segments into your spreadsheet in the same order as you store them in General Ledger.

CREATING A BUDGET SPREADSHEET UPDATE

If you do not enter a period amount for an account, your General Ledger application does not update the account balance, regardless of update logic. If you enter A (Add), Budget Upload adds the period amount to the existing account balance. If you enter R (Replace), Budget Upload replaces the existing account balance with the period amount you specify. When you enter a period amount for an account, Budget Upload updates the account balance according to the update logic you specify. For example, if your fiscal year ranges from January to December and you want to upload budget amounts for the months April, May and June, then you need to enter amounts for columns Period4_Amount through Period6_Amount. Budget Upload assumes that you enter period amounts for each account in the sequence that the period falls in the fiscal year. You can enter amounts for up to 60 periods per fiscal year.

Assign a column of your spreadsheet for each budget period in your General Ledger application.

To enter budget amounts for each period in your spreadsheet: Segment1 through Segment30 : Enter existing or new valid account segment values in your spreadsheet for each account segment you enabled in your General Ledger application. You can enter amounts for up to 60 periods for each open fiscal year. Period1_Amount through Period60_ Amount : Enter an amount for each budget period in your open fiscal year. Enter the value A if you want the amounts you enter to add to existing amounts. Enter the value R if you want the amounts you enter to replace existing amounts. Update_Logic_ Type : Enter the value R or A. You can open a new budget fiscal year in the Define Budget window. You can only upload budget amounts for open budget fiscal years within a budget. You can only upload budgets for current or open budgets.īudget_Entity_ Name : Enter the budget organization to which you want to budget amounts.įiscal_Year: Enter the fiscal year to which you want to budget. The following is a list of required columns and the values you must enter:Ĭurrency_Code: Enter the currency for your account.īudget_Name: Enter the name of the budget to which you want to budget amounts.

Define columns that correspond to the required columns in the Budget Interface table.

To enter required budget information in your spreadsheet: Note: If you have Microsoft Excel installed, you can use GL Desktop Integrator to create budget spreadsheets.

Suggestion: Choose a spreadsheet that provides the most flexibility for your organization, and that can store data in ASCII format. You can also organize your budget information in any way you want in the working section, and then automatically copy the information in your working section to an interface section that corresponds to the Budget Interface table. Therefore, each column of your spreadsheet should correspond to a column in the Budget Interface table.įor example, as shown in Figure 1 - 1,your spreadsheet should contain a column called Budget_Name that corresponds to the Budget Interface table column of the same name. However, before you can upload your budgets from a spreadsheet you must organize your budget information according to the structure of the Budget Interface table. Your budget spreadsheet should contain all of the budget information you need for your company or agency. If you plan to import budget information from a spreadsheet, you should use a separate spreadsheet for each budget organization. Creating Your Budget Spreadsheet (Oracle General Ledger Users' Guide)

Creating a budget spreadsheet