New User Experience: Manage Financial Plans
The new Financials page gives you quick access to financial plans of a project. As a financial manager and analyst, Rita gets a quick glance at all financial cost plans of a project as a list. Rita can also use the grid view for detailed analysis of the financial plans. Cost Plans are created in the Classic PPM but can be viewed in the ppmnew. The grid view lets Rita reorder, sort, and filter columns, like an Excel sheet. Rita can also view the detailed transactions behind any actual cost or aggregated cost of a cost plan. Because they appear as hyperlinks, Rita can click any actual cost to view the Transactions Review page. Moreover, unlike Classic PPM, Rita can view the transactions without navigating away from the current cost plan.
The new Financials page gives you quick access to financial plans of a project. As a financial manager and analyst, Rita gets a quick glance at all financial cost plans of a project as a list. Rita can also use the grid view for detailed analysis of the financial plans. Cost Plans are created in the Classic PPM but can be viewed in the
New User Experience. The grid view lets Rita reorder, sort, and filter columns, like an Excel sheet. Rita can also view the detailed transactions behind any actual cost or aggregated cost of a cost plan. Because they appear as hyperlinks, Rita can click any actual cost to view the Transactions Review page. Moreover, unlike Classic PPM, Rita can view the transactions without navigating away from the current cost plan.
Similar to the functionality available in Classic PPM, if you have viewing rights on the project, you can access the Financials tab.
View the Cost Plan List
By default, the Financials page displays the detail view of the
Plan of Recordcost plan. Click
Plan Listto view other plans, if available.
- The plan name, Created Date, Start and Finish period, total planned cost, and period type appear. The Period Type defines the type of time period for the plan, for example,Monthly,Quarterly, andAnnually.
- By default, the list is sorted by the created date field, in descending order. You can change the list to sort by any other column. The changed sort persists even after navigating to another page, session time-out, page refresh, or application logout. The sorting happens on cost plans other than the plan of record where the plan of record is always displayed on the top.
- You can click on any cost plan to view its details.If you have one or both of the following access rights, you can view the list of cost plans and the cost plan details:
- Project - Cost Plan – View
- Project - Cost Plan – Edit
Analyze Financial Plans
To view the financial status of projects, you can analyze financial plans. For example, you can compare actual costs with planned costs.
Follow these steps:
- In the main menu, clickProjects.
- Open a project and clickFinancials.By default, the cost plan that is designated as the Plan of Record (POR) appears.
- To view a list of other available plans, clickPlan List. Click a plan or clickReturn to Plan Details.
- In theVIEWmenu, select one of the following views:
- Planned: This view displays planned cost by time period.
- Planned to Actuals: This view helps you compare the planned and actual costs. This view also providesREMAININGand% SPENTdata. The application performs the following calculations:
- Remaining Cost=Planned Cost−Actual Cost
- % Spent Cost= (Actual/Planned) × 100
- Planned to Forecast:This view helps you compare the planned and forecast costs.
- For past time period,Forecast=Actual
- For current and future time periods,Forecast=Planned
- Forecast(Calculated) =Actual+Forecast Remaining
- Forecast Remaining=Actual Cost(posted through the last complete fiscal period) +Planned Cost(remaining in the cost plan of record after the last complete fiscal period)For example, the time period is set tomonthlyand the project as of date is 05/20/2018. The Forecast remaining is actual cost through 04/30/2018 plus planned cost in fiscal periods after the fiscal period ending 04/30/2018.
- % Variance= (Variance/Planned) × 100
- Actuals: This view displays actual costs posted during the fiscal period.
- In Planned to Actuals and Planned to Forecast views, you can hide or show all columns of one type. Click on the respective color in theSHOWINGlegend at top right.
- To view details for the current plan, click Settings. The plan name, description, ID, start and finish period, currency, decimal display, and time period, period type appear.
- To change the appearance of decimal amounts, select a value in theDECIMAL DISPLAYfield.
- To change the cost plan view to a different fiscal time period, select a value in theTIME PERIODfield.
Group Financial Data
You can group your data by any grouping attributes and can see the aggregated values for each group.
- Drag-and-drop the column headers that can be grouped to theGroup Bysection.
- Once the data is grouped, you can expand each group to view the individual rows. The aggregate of each row is shown in far right in theTOTALScolumn. The first three grouping attributes are pinned on the left and theTOTALScolumn is pinned on the right.The following example shows the Plan List view and the grouping feature.
Review Transactions Associated with Actual Costs
In the Planned to Actuals or the Actuals view, you can view the transactions behind an actual cost. Every Actual Cost value appears as a hyperlink. You can click an individual cost and row level or column level actual aggregates. The transaction review window displays Transaction Date, Resource, and Task columns pinned on the left. Units, Unit Cost, and Actual Cost appear pinned on the right.
Filter Line Items in a Cost Plan or Financial Transactions Grid
Both the financial grids (cost plan and transaction review) offer the following grid controls.
Follow these steps:
- On the grid, you can hover on any column header and view more options. You can pin columns to the left or right. You can also autosize or reset column width.
- To view only specific data in a column, you can apply your own filter criteria.If a grid has more than 200 rows, the filter applies only to the first 200 rows on the current page. The filter does not apply to the entire data set.
- A numeric data filter is also available, as shown in the following image:
- You can apply text-based filters, as shown in the following example:The data is paginated when it exceeds 200 rows, with up to 200 rows per page.
- You can show and hide columns on the cost plan. Select the columns that you want to see on the view and clear the ones that you want to hide.