Budget Matrix
View or add Budget Entries for a Project using the Budget Matrix. The Budget is used to plan the Resources that that are allocated to a Project. The Budget can be either general with few entries or it can contain more entries that are divided into activity levels. A comparison can then be made between the budgeted amounts and the actual usage as recorded in the Project Journal. By monitoring differences between Actual Usage and Budgeted Usage, you can control an ongoing Project and improve the quality of future Projects by reducing the risk of underestimating costs.
Create Budgets using Budget Matrix
The Budget Matrix can be used to manually create Budget Entries or change an existing Budget. Navigate to the Budget Matrix page from the Role Center > Projects > Projects > Budget > Budget Matrix.
The following options are available in the Budget Matrix:
Basic FastTab
| Field Name | Description |
|---|---|
| Budget Version Filter | Specifies Budget Version from the list. Select a Budget Version to display, add or modify Budget items to that specific Budget. |
| Type | Specifies the type for Budget. Options: |
| - Resource | |
| - Resource Group | |
| - Expense (Total Cost) | |
| - Expense (qty) | |
| - Item | |
| - Resource Sub Group |
Tip
Select a Type from the list to display or add or modify Budget items to that specific Type (see Number field below).|
| Number | Specifies the Type number from the drop-down list. For example, if Resource is selected as Type, the Number field displays a list of Resource Numbers from which to select. The list changes depending on what value is selected in the Type field. |
| Resource Group No. | Specifies the Resource Group Number |
| Resource Sub Group No. | Specifies the Resource Sub Group No. |
| Work Assignment Action | Specifies how a Work Assignment is affected when a change is made to a Budget Entry. No action will be taken when a Work Assignment is locked, has a Status of Completed, or no Work Assignment exists for the Budget Entry. |
| View by | Specifies to view the Budget by day, week, month, quarter, year or accounting period. |
| Show Column Name | Specifies, if yes/true, Budget dates will show as names instead of dates. |
| Show Extra Filters | Specifies, if yes/true, the Extra Filters tab is displayed. |
| Ignore Filters (only for view) | Specifies, if yes/true, the filters in the Budget Matrix will be ignored. All possible values will be shown. |
| Start Date | Specifies the Start Date for the Budget. |
Budget Lines
Print Tab
Resource planning capacity/Budget: Select to print a report that compares Resource Capacity vs Budget. Report prints Resource No., Resource Name, Capacity, Budget, and Remaining.
Resource planning Budget/booked: Select to print a report by Resource, of the budgeted versus actuals. The report prints Resource No., Resource Name, Period Start, Period Type, Hours, Resource Booked, and Remaining.
Project Task No.: Specifies the Project Task Number for the Budget line.
Description: Specifies identifying information about the text that defaults from the Project Task Description.
Original Budget: Specifies an amount to enter for the original Budget.
ETC Budget: Specifies an amount to enter for the ETC (Estimate to Complete) Budget.
EAC Budget: Specifies an amount to enter for the EAC (Estimate at Completion) Budget.
Date Columns: The headings in the date columns change, depending on the value specified in the View By field in the header. If the View By value is Day, the column headers display a daily value (i.e., 10/6/2022, 10/7/2022). If the View By value is Month, the column headers display monthly values *(i.e., Oct 2022, Nov 2022, etc.). This allows you to enter Budgets in these columns for the required date value.
To add Budget Amounts
- To add a Budget amount, select a Budget from the Budget Version Filter.
- Select the Type to which to add a Budget.
- Select the specific Number for which to add a Budget.
- Select any other filters and select a Start Date for the Budget.
- In the Budget Lines, select a Project Task No. line and enter a Budget amount in the Date columns to the right.
Note
If the associated Project requires approvals for Budget changes, any changes will need to be approved before the Budget amounts are available for processing.
For more information on Budgets, see:
B&R1 - Setting up Budget & Reservations features
B&R2 - Budget & Reservations - Project Card Setup
B&R3 - Setting up Budget & Reservations with Project Wizard
B&R4 - Budgets & Reservations - Creating Job Planning Lines
B&R5 - Budgets & Reservations - Updating Job Planning Lines
B&R6 - Budget & Reservations - Using Job Planning Lines with Purchasing
B&R7 - Budgets & Reservations - Purchase Receipt Posting - Received Not Invoiced
B&R8 - Budgets & Reservations - Purchase Receipt Posting - Usage Cost Option
BR9 - Budgets & Reservations - Purchase Receipt Posting - Inventory Reserved to Project Option
B&R10 - Budget & Reservations - Purchase Receipt Posting - How to Update Costs on Unposted Receipts