Expenses Resource Assignments Grid

In the Expenses Planning grid, you can open an Expenses Resource Assignments grid below a WBS row. Use the Resource Assignments grid to add and review planned expenses for that WBS element.

Contents

The Baseline, Planned, JTD, and ETC columns display at either billing or cost, depending on the budget type that is selected. If the budget type is Cost and Billing, you can switch between the two, and the amounts in the grid change to reflect your selection. Note that as you switch between billing and cost, the grid displays a somewhat different set of columns.

Field Description
EXPENSE TYPE This column displays the expense type for a planned expense. Only active accounts and those that are available to the project's company display. If you are using a Vision plan, the expense types are derived either from the project plans that are included in utilization or from JTD.

To enter an expense type for a new row, click + Add Resource and select it in the Add Expense Types dialog box.

To change the expense type for an existing row, do either of the following in this column:
  • Enter one or more characters from the expense type name or account number to display a drop-down list of expense types that contain those characters. Select the expense type you want from that list. If only one expense type matches your search text, it is entered automatically without displaying a list.
  • Click to display a list of all available expense types in the Expense Type Lookup dialog box. Scroll or search to locate the expense type, select it in the list, and click Select.

When you select a different expense type, you must note the use of JTD or baseline. If there is no assigned JTD or baseline amount for the expense row, you can change the expense type. If there is assigned JTD or baseline for the expense row, you can select a different expense type only if there is also a planned amount. When you select a different expense type, a new row is created for the expense, and you can choose to move the planned amount to this row. The JTD and/or baseline remains on the original row.

Note: The account type that is applied to this column is dependent on the project's charge type:
  • Regular project charge type: Direct and Reimbursable expense types are available.
  • Promotional/Overhead project charge type: Indirect expense types are available.
TYPE This column displays the account type that is associated with the expense type.
ACCOUNT This column displays the account number that is associated with the expense type.
VENDOR NAME This column displays the name of the vendor.
To enter a vendor, do either of the following:
  • Enter one or more characters from the vendor name or number to display a drop-down list of vendors that contain those characters. Select the vendor you want from that list. If only one vendor matches your search text, it is entered automatically without displaying a list.
  • Click to display a list of all available vendors in the Vendor Name Lookup dialog box. Scroll or search to locate the vendor, select it in the list, and click Select.

When you select a different vendor name, you must note the use of JTD or baseline. If there is no assigned JTD or baseline amount for the expense row, you can change the vendor name. If there is assigned JTD or baseline for the expense row, you can select a different vendor name only if there is also a planned amount. When you select a different vendor name, a new row is created, and you can choose to move the planned amount to this row. The JTD and/or baseline remains on the original row.

BASELINE

This column displays the planned amount that was saved as the baseline for the expense type for the WBS element.

If the project has multiple Vision plans that are included in utilization, iAccess sums the baseline amounts from the plans.

PLANNED This column displays if the budget type is Cost or Cost and Billing, or if the budget type is billing and the rate method is None. If the budget type is Cost, the column displays the planned cost amount for the expense for the WBS element. If the budget type is Cost and Billing, it displays the planned cost or planned billing amount for the expense for the WBS element, depending on your selection in Show. If the plan is a iAccess plan, you can enter or change a planned cost amount.

For direct and indirect expenses, the cost and billing amounts will be the same if you change the option in Show. For reimbursable expenses, iAccess calculates the planned billing amount based on the cost amount and the reimbursable expense markup settings in the plan settings.

If the project has multiple Vision plans that are included in utilization, iAccess sums the planned amounts from the plans.

PLANNED COST This column displays if the budget type is Billing and the rate method is Multiplier Only, From Account Rate Table, or From Category Rate Table. The column displays the planned cost amount for the expense for the WBS element. If the plan is a iAccess plan, you can enter or change the planned cost amount.
PLANNED BILLING This column displays if the budget type is Billing and the rate method is Multiplier Only, From Account Rate Table, or From Category Rate Table. The column displays the planned billing amount for the expense for the WBS element.

If the plan is a iAccess plan, you can enter or change a planned cost amount in PLANNED COST, and iAccess updates the planned billing amount accordingly. For direct and indirect expenses, the cost and billing amounts will be the same. For reimbursable expenses, iAccess calculates the planned billing amount based on the cost amount and the reimbursable expense markup settings in the plan settings.

JTD This column displays the sum of the charges to the expense account for the WBS element for all posted transactions and committed purchase orders through today.

iAccess provides a notification when the JTD amount is greater than the planned amount. A red flag () displays in the column. Each WBS row amount is checked, and a flag can display for any row.

ETC

This column displays the estimate to complete for the expense type and WBS element.

ETC amounts for expenses are calculated differently, depending on whether the project plan is an iAccess plan or a Vision plan:

  • iAccess plan: If Planned expenses - JTD expenses is greater than 0, then ETC = Planned expenses - JTD expenses. If Planned expenses - JTD expenses is less than or equal to 0, then ETC expenses = 0.
  • Vision plan: ETC = Sum of planned expenses from tomorrow forward.