Budget reports in Project Insight break project and financial data into timed phases. For example, a standard Project Report may show values for the full length of a project, while a budget report can break those values down month by month, quarter by quarter, or by another selected time period.
The Portfolio Allocation Report helps teams review time-phased budget, work, cost, and billable information across projects. This is useful when you need to understand not only the total value of project work, but also when that value is expected to occur.
Use the Portfolio Allocation Report when you need to:
- Review project and financial data over time
- Compare planned, earned, and actual values
- Analyze cost and billable values by time period
- Group budget information by month, quarter, company, project, resource, or other rollups
- Create charts that show how values accumulate over time
Create a Portfolio Allocation Report
In the Reports home of Project Insight, Portfolio Allocation is the first option under Budget reports:
Click Create Portfolio Allocation Report to get started.
Then add the report and begin choosing the projects, date ranges, fields, charts, and grouping options you want to include.
Display & Filter Options
Filter For The Project Results You Want
Like all reports in Project Insight, you first narrow down which projects you want to include in the report.
- Date Range Options filter projects that fall within selected date ranges.
- Companies narrow the results to projects associated with a specific company.
- Task Options can narrow the report by task-related criteria, such as task type.
Choose The Information You Want To Compare
The next set of options lets you choose which data fields are important for the report.
Charting adds up to four charts to display line graphs, bar charts, or pie charts.
Work Fields compare hour-based values for the selected time period:
- Scheduled Work is the work hours for the selected time period.
- Actual Entered Hours sums time entries for the selected time period.
- Completed Work is based on the percent completed during the selected time period.
Project Financial Fields compare cost and billable values for the selected time period.
Available financial value types may include:
- Planned Values for both cost figures and billable figures.
- Earned Values for both cost figures and billable figures.
- Actual Values for both cost figures and billable figures.
These variations can calculate for time, expense, and total values.
Cumulative is used primarily for charting. It helps line graphs show values growing as they accumulate over time.
Choose How The Information Should Be Displayed
After choosing your projects and the information you want to review, choose how the report should group the information.
For example, you could use the Date selection at the top of the filtering options to show information for the current year, then use the Group By section to break that information down month by month.
Roll Ups can total and subtotal information by options such as Company, Project State, Project Type, Resource, or Resource Type.
Review The Results
When you finish setting up the report, run it to see the results.
The gray bar highlights the values for each project.
Use the triangle carets to expand and collapse rows according to your Group By selections.
Quick Tip: Use the More icon to expand or collapse rows all at once:
Save, Share & Schedule
Continue reading the following articles for using the options at the bottom of all reports:
Common Questions
What Is The Portfolio Allocation Report Used For?
The Portfolio Allocation Report is used to break project and financial data into timed phases. It helps teams understand how work, cost, billable values, planned values, earned values, and actual values appear over time.
How Is A Budget Report Different From A Project Report?
A project report may show values for the entire project, while a budget report can break those values into time periods, such as months or quarters.
Can The Portfolio Allocation Report Show Planned, Earned, And Actual Values?
Yes. The report can include planned, earned, and actual values for cost and billable figures, depending on the fields selected.
Can I Group The Report By Month?
Yes. You can use the date and grouping options to show information month by month or by another selected time period.
In Short
The Portfolio Allocation Report helps Project Insight teams view budget and financial information over time. Instead of only seeing project totals, teams can break work, cost, billable, planned, earned, and actual values into timed phases for clearer budget visibility and reporting.
Comments
0 comments
Please sign in to leave a comment.