Skip to main content
If you are a Planview customer, sign in to enable additional content.
Planview Customer Success Center

Loading Data into a Financial Plan

Sign in to access this product help article.

You are viewing content for Planview Enterprise One release – Portfolio and Resource Management.

How to Load Data into a Financial Plan

For information on the required options, required features, grants, and other prerequisites that must be met before you load data into a financial plan, see Business Rules of Financial Management and Financial Planning.

           

NOTE

If you are loading capacity for a cost-center-based financial plan, be sure that the calendar of each resource is configured and the standard activities are up to date for all resources before performing the following procedure.

           

To load data into a financial plan:

  1. Take the appropriate action: 

               

    NOTE

    If you are loading capacity for a cost-center financial plan, you must select a cost-center based portfolio.

               

  2. Take the appropriate action:

  • On a Portfolio View screen, the Capacity Portfolio Manager screen, or Demand Portfolio Manager screen, click Load Portfolio.

  • On the Financial Planning Detail screen's context bar, click Version. Then click Load.

    For information regarding what data you can load for the different types of financial plans, see About the Data Loaded into Financial Plans

               

    NOTE

    Performing this procedure to load capacity for a cost-center financial plan, loads the data for all of the cost centers in the relevant portfolio. 

               

               

    TIP

    If the Load Portfolio button or Load button is displayed but disabled, hovering next to it displays an explanation of why you cannot select it.

               

  1. If you are loading work financial-planning data, designate the type of data you want to load. 

               

    NOTE

    Whether you can perform this step while loading data into a financial plan from a Portfolio View screen depends on your system's configuration.

               

    You can load non-labor actual and planned expenditures in addition to labor, actual, and forecast. To do so, select the Actual Expenditures and Planned Expenditures check boxes as appropriate.

    The loading of an actual expenditure into a financial plan is based on the expenditure’s date. If the amount of an actual expenditure for a task is less than the planned expenditure, the planned expenditure’s value is spread across the task’s schedule dates. If the amount of the actual expenditure for a task is greater than the planned expenditure, the planned expenditure’s value is zero and no value for that expenditure is loaded into the financial plan.

  2. From the Period Range Start and Period Range End lists, select the first and last month and year of the date range for which you want to load data.

  3. Click Load Now

               

    WARNING

    Loading information into a financial plan, deletes all data of the plan's relevant accounts for the specified time periods. Suppose you load labor or expenditures into a work financial plan that contains manually entered data. In that case, those entries are overwritten by any labor or expenditures that exist in the project between the specified time periods if the accounts are marked as allowing loads.

               

After you load a financial plan, you can make additional changes to the plan through any of the methods that let you define a financial plan. That is, you can load additional information into the plan, edit the financial plan, copy financial-planning information between entities for the same version or between different versions of a financial-planning model, and export data to work with it in Microsoft Excel and then import your changes back to Financial Planning.

           

About the Data Loaded into Financial Plans

As the following table indicates, the information the system loads into a financial plan depends on what type of plan it is. Before loading such information, you should be familiar with the business rules that apply to loading data into financial plans. If you experience trouble loading information into a financial plan, see the business rules that apply to loading models and versions.

For This Type of Financial Plan…

The System Loads…

Work

The following information for the projects for which you are loading financial planning data:

  • Labor data pertaining to the requirements, allocations, and reserves defined for the relevant projects.
  • Time reported values.
  • Actual and planned expenditures if you designate you want to load such expenditures.
  • Unplanned expenditures.

Strategy

Financial-planning data of work plans that contain information from the projects allocated to the strategic entities for which you are loading financial-planning data.

Cost center

The resource capacity for all resources associated with the given cost centers. When loading a resource's data into a cost center financial plan, the resource's calendar is applied so the system can calculate capacity and reduce the overall capacity by any standard activities the resource is assigned to.

           

NOTE

Loading data into a work financial plan is based on utilization, but loading data into a cost center financial plan is based on capacity.

           

Outcome

Financial-planning data of work financial plans that contain information from the projects associated with the outcomes for which you are loading financial-planning data.