In this window, you can view a summary of the amount budgeted for each G/L account in different time periods.
If you have not yet set up your budget, click here for more information.
To enter the budget figures, remember to click the Net Change button in the lower left-hand corner of the window.
You can select different time intervals by clicking the buttons in the lower left-hand corner of the window: 1 (Day), 7 (Week), 31 (Month), 3 (Quarter), 12 (Year) and three horizontal lines (Accounting Period). The selected period is shown in the Date Filter field. Accounting periods are set up in the Accounting Period table.
You can select one of the following options to determine what type of amount will be shown in the period columns: the Net Change feature (displays the net change in the budgeted amount for each period) or the Balance at Date feature (displays the budgeted amount as of the last day in each period).
The header includes three tabs:
|
Budget Name |
Here you can select the name for the budget you what to work on. |
|
Show as Lines |
Here you can select the dimension that you want to show as lines in the Budget window. |
|
Show as Columns |
Here you can select the dimension that you want to show as columns in the Budget window. |
|
Date Filter |
In this field you can set a filter to filter amount fields by date. |
|
G/L Account Filter |
In this field, you can set a filter for G/L accounts, so that the values in the Balance, Budget at Date and Budgeted Amount fields are based only on the G/L accounts included in the filter. |
|
Global Dimension Filters |
Here you can enter the dimension values that the program will use to filter the information in the window. Click here to learn more about dimensions. |
|
Budget Dimensions Filters |
In these fields, you can select a budget dimension as a filter, so that the values in the budget fields are based only on budget entries with these dimension values. |
|
Rounding Factor |
Here you can select a rounding factor that the program will use to round the amounts in the columns. For example, if you select 1000, then all amounts will be shown in thousands. |
|
Show Column Name |
If you place a check mark in the Show Column Name field, the program will show as column headings the descriptive names you have given dimension values and G/L accounts, instead of the corresponding codes. This makes the matrix window easier for you to understand if you have set up numerical dimension value and G/L account codes. |
The columns in left side of the matrix window display the following information:
|
Code |
This column shows the dimension value code for the dimension selected in the Show as Lines field. To view a list of dimension values, click the AssistButton in the field. |
|
Name |
This column shows the name of the dimension value on the line. |
|
Budgeted Amount |
This column displays the dimension's or G/L account's total budget or, if you have specified a name in the Budget Name field, a specific budget. To see the G/L budget entries, click the AssistButton next to the field. |
The headings on the right side of the matrix window shows the dimension value code for the dimension selected in the Show as Columns field.
The fields on the right side of the matrix window displays the dimension's or G/L account's total budget or, if you have specified a name in the Budget Name field, a specific budget. To see the G/L budget entries, click the AssistButton next to the field.