Download a free trial and follow these steps to get started:
- Start with a simple Excel spreadsheet that lists all of the projects in your portfolio. This spreadsheet shows the dates, budget, and actual cost for each project:
- Launch OnePager Express. Don't have OnePager? You can download a free trial.
- Click NEW to build a new project/portfolio report:
- Give your report a name, click Next, and then Create New Project View to get a first draft of your project portfolio budget report.
- Now, we want to add some of the budget vs. cost information from the spreadsheet into the Gantt chart. To do this, go to Home > Project View Properties > Rows/Swimlanes, and click on the Text Column Properties button. We'll set up one column for the budget and a second column for the actual cost:
- With the budget vs. actual cost information now clearly showing in the Gantt chart, we now want things to stand out when they are over budget. To do this, we'll use conditional formatting. Go to Home > Project View Properties > Task Bars > Manage Rules. When projects are over budget, we'll color them red. When projects are on-budget, we'll color them green:
- Click OK to apply these settings, and you'll get a multi-project budget status report like this:
Once you've built your budget report, it's easy to update each week or each month and your projects and your budgets change. No need to re-build the report from scratch; OnePager can import fresh data from Excel into an existing report, making tracking and updating your portfolio of projects very easy!
Get started today by downloading a free trial, complete with our world-class tech support.15-Day