![]() ![]() One of the useful new features in Microsoft Project 2013 is the Dashboard Reporting feature. This feature replaced the old Reports feature found in all previous versions of Microsoft Project, which was removed from the 2013 version of the software. Although I personally love these new Dashboard Reports, they have one main limitation: it is not possible to create a cash flow report in Microsoft Project 2013 that looks like the old Cash Flow report. For example, Figure 1 shows a print preview of the Cash Flow report in Microsoft Project 2010. Figure 1: Cash Flow report One limitation of the new Dashboard Reports feature in Microsoft Project 2013 is that it simply will not allow you to create table that looks like the Cash Flow report shown in Figure 1. The way to work around this limitation is to create a new Visual Report for Microsoft Excel instead. The easiest way to accomplish this is to modify the existing Cash Flow Report by completing the following steps: • Open a project and then click the Report tab to display the Report ribbon. • In the Export section of the Report ribbon, click the Visual Reports button. Microsoft Project 2013 displays the Visual Report – Create Report dialog shown in Figure 2. Figure 2: Visual Reports – Create Report dialog • In the Visual Reports – Create Report dialog, click the Select Level of Usage Data pick list at the bottom of the dialog and choose a reporting option. Notice in Figure 3 that I selected the Months level of usage data. Figure 3: Select the Months usage data • In the Visual Reports – Create Report dialog, select the Cash Flow Report for Excel and click the View button. • In the resulting Excel workbook, click the Task Usage tab to display the Task Usage worksheet, as shown in Figure 4. Figure 4: Task Usage worksheet • In the PivotTable Field List sidepane on the right side of the page, deselect the Cumulative Cost field. • In the PivotTable Field List sidepane, select the Monthly Calendar dimension. • In the PivotTable Field List sidepane, drag the Tasks dimension from the Filters section to the Rows section, if necessary. • In the Task section of the PivotTable, repeatedly click the Expand button ( + button) to completely expand all of the summary tasks so that you can see all of the detail tasks in the project. • In the Year section of the PivotTable, click the Expand button ( + button) to expand the Year dimension until you see months across the top of the PivotTable. • Click the Design tab to display the Design ribbon with the PivotTable Tools applied. I can't tell you for sure if you can manipulate the pivot table in Excel to get the exact same format you see in Project's cash flow report because I haven't worked enough with pivot tables to know how to set them up. However, I do know there are issues with the visual reports feature in Project, particularly the. I am really struggling to export a cashflow generated in Microsoft Project as an Excel Spreadsheet. I would like the cashflow to show the Task and the. Try Microsoft Edge A fast and secure browser that's designed for Windows 10 No thanks. Cash flow statement. Thousands of templates to jump start your project. Here is a four-step process you can use to create cash flow projections you can trust. The Near Future Almost Always Looks a Lot Like the Recent Past. The starting. Middle School; Explore over 4,100. Is the project going to generate enough cash flow over its lifetime to make the investment worthwhile? Project Cash Flow. • In the Layout section of the Design ribbon, click the Report Layout pick list button and select the Show in Compact Form item, as shown in Figure 5. Figure 5: Select the Show in Compact Form option Note: If you want to remove the subtotals for years, click the Subtotals pick list button in the Layout section of the Design ribbon, and select the Do Not Show Subtotals item. Select all of the numbers in the PivotTable and apply currency formatting as desired, such as US dollars, for example. Figure 6 shows the completed Cash Flow report in Microsoft Excel 2013. Figure 6: Completed Cash Flow Visual Report Saving the Completed Cash Flow Report as a Template To avoid needing to repeat the preceding set of steps for every project in which you want to use the same custom Cash Flow report, you can save the finished Excel workbook as a new Visual Report template. To do this, complete the following additional set of steps: • Click the File tab in Microsoft Excel and then click the Export tab in the Backstage. • On the Export page of the Backstage, click the Change File Type icon and then select the Template (*.xltx) icon in the Change File Type section of the page, as shown in Figure 7. Figure 7: Save the Cash Flow report as an Excel template In the Save As dialog, Microsoft Excel navigates to your default Templates folder for Microsoft Office templates. • In the Save As dialog, enter a unique name for the new Visual Report, such as Cash Flow 2013, and then click the Save button. Microsoft Excel displays a warning dialog about external data, such as shown in Figure 8. Figure 8: External data warning dialog • In the external data warning dialog, click the Yes button. • Close the workbook in Microsoft Excel and then exit the software. The next time you open a project in Microsoft Project 2013 and want to use your new custom Cash Flow report as a replacement for the old Cash Flow report found in previous versions the software, you can find your new Visual Report template in the Visual Reports – Create Report dialog, such as shown in Figure 9. Before you create the new Cash Flow report, remember to click the Select Level of Usage Data pick list at the bottom of the dialog and choose a selection such as Months. Figure 9: New Visual Report template A version of this article originally appeared on the. ![]() ![]() Related Content Webinars (watch for free now!): Articles. Hi Dale I would like to seek your advise regarding estimating a near accurate monthly cash flow on lets say as an example a fit out project valued at 5 million $ and project duration is say 6 months. As a Project Manager to prepare a near accurate cash flow on such a project wouldn’t I need to have data such as quantities and rates readily available with me and most importantly the schedule of work to be done for that particular month in order for me to arrive at a near accurate figure? And then we need to account for variances as well I would appreciate if you could steer me in the right direction as my understanding is that this is the scope of a QS? Many thanks for this Dale – I have successfully produced an annual Cash Flow Report for my project. However, I need the report to show expenditure by financial year, not calendar year. Any advice on how I can get my visual Cash Flow Report to report on a financial year basis rather than calendar year basis? The “Select level of useage data to include in the report” drop-down in the only offer weeks, months, years, (not financial years) in the” Visual Reports – Create Report” dialog box. I image this must be a common need, so I expect there is a solution, but I can’t find it. Any help gratefully received. Name (required) Mail (will not be published) (required) Comment Allowed HTML tags: Please complete this equation so we know you’re not a robot. * 6 × = 18 Sign me up for the newsletter By submitting a comment you grant MPUG a perpetual license to reproduce your words and name/web site in attribution. Inappropriate and irrelevant comments will be removed at an admin’s discretion. Your email is used for verification purposes only, it will never be shared.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
April 2018
Categories |