Adjust Posted Budgets

In this topic:

 

Worksheet Details

Enter the details for your new worksheet.

Worksheet Name: Enter a name for the worksheet. We recommend limiting your worksheet name to strictly alphabetic (A through Z) or numeric characters (0 through 9), and avoiding the use of symbols.

Budget Version: Select a budget version.

Budget Type: Select a budget type. Selections include the currency based Budget Dollars or Budget UDFs.

Effective Date From, To: Select an effective date range for the worksheet.

Budget Cycle: Select a Monthly, Quarterly, or Yearly budget cycle for the worksheet.

Number of Cycles: Enter the number of cycles for the worksheet. 12 is pre-populated by default.

Chart of Accounts Segments: Select the chart of accounts segments for the worksheet. The general ledger segment is required; therefore, it's selected by default. Add additional segments as required.


Budget Entries

Select the budget entries you'd like to include in your worksheet.

Account Type: Select either Expense Accounts, Revenue Accounts, both, or all available accounts.

Activity Basis: Select either Accounts with Activity, All Valid Accounts, or start with a Blank Worksheet.


Filter By Segment Code

Optionally, you can use filters to narrow down the data you want to include in your worksheet. You can double click or drag-and-drop individual segments to move them to the Selected Filters area.

Add All | Remove All: Select to quickly add or remove all of the Available Filters to the Selected Filters area.

 

Operators

When filtering data, select an operator and enter criteria to determine which data to display.

 

Criteria 1

Enter or select a value to compare with the item in the Selected Filter column. When using Like or Not Like, use "%" to represent any number of characters. For example, you want results showing the Accounts Receivable offset account assignments. Since you only want information on AR accounts and they all begin with "AR," you would complete the criteria as follows:

  • Selected Filter: Transaction Source
  • Operator: LIKE
  • Criteria 1: AR%

This filter limits the results to only transaction source codes that begin with AR, while the rest of the code could have any characters.

Please note the results if you choose the Like operator and the following criteria:

Criteria

Result

%AR%

Returns data with "AR" in any position

AR%

Returns data that begins with "AR"

%AR

Returns data that ends with "AR"

 

Criteria 2

Enter or select a value for the end of a range if the Compares To contains the Between or Not Between operators.


Select Create to create the worksheet.

Note: The parameters entered in the Budget Worksheet cannot exceed the limit of 60,000 cells. If you receive an error message, decrease the size of the worksheet by adding filters or adjusting the budget cycles.