Home Free Categories Planning Using Primavera 14 steps to create cash flow from primavera with sample file

14 steps to create cash flow from primavera with sample file

How to use primavera 6 version 7 reports to create cash flow 5

Cash flow could be created by primavera 6 version 7 using the reports section, However i found primavera 6 v7 reports are not very clear that every one can do it simply,  Therefore we are going to see step by step how to create planned values and earned values using primavera p6 v7 reports.


[cmamad id="1174" align="left" mobid="ad-off"]


To create Cash Flow Statement using primavera follow the following steps:

1- Open reports section from tools tap then reports then reports as per photo below :

Open report tap in primavera p6

Open report tap in primavera p6

 


2- From the report group Tabular select the report called CT-01 Monthly Project Cash flow and then click on wizard icon on the right as per photo below

Select monthly cash flow report

Select monthly cash flow report

 


3- The report wizard window will open, just click next as per photo below

click next on primavera report

click next on primavera report


4- From configure selected subject area under activities click columns

click column icon to adjust primavera report

click column icon to adjust primavera report


5-from available options on the left under earned value group select planned value cost and earned value cost (double click to move items from available option on the the left to the selected options in the right) Then click apply Then OK

select planned value and earned value

select planned value and earned value

 


6- Then click next

 

Click next in report wizard

Click next in report wizard

 


7- from the date options click time interval fields.

Select time interval from primavera report

Select time interval from primavera report


 

8- from available options on the left under earned value group select earned value cost, cum earned value cost, planned value cost and cum planned value cost  then click OK

Select earned value and planned value cumulative

Select earned value and planned value cumulative


9- click next

 

Click next

Click next


10- put your report title then click next

Name the primavera report

Name the primavera report

 


11- Congratulations !! report generated click run report

 

Run the P6 report

Run the P6 report

 


12- choose HTML file and from output file select the location the report will be saved then click OK

choose HTML file

choose HTML file

 


13- now the internet explorer should open and this step is tricky one , if your internet explorer not your default browser like if you are using Firefox or Google chrome, go to the location the report saved and right click the open with internet explorer, otherwise the copy and paste will not work probably.

Open p6 report

Open p6 report

 

You should should see something like this

Primavera P6  Report

Primavera P6 Report

 


14- Copy values of Earned Value, Cum. Earned Value, Planned Value and Cum Planned Value from internet explorer to any excel sheet and create cash flow easily, Or download the attached sample and it will create the cash flow based on the values from primavera

Download the  cash flow report:

[attachments docid="754"]

 

Copy values from internet explorer to the excel sheet

Excel sheet

Excel sheet

 

You will get the cash flow chart based on your inputs

Cash flow chart sample

Cash flow chart sample

 


 

[cmamad id="1174" align="none" mobid="ad-off"]


Recommended Materials to Learn Primavera

Oracle Primavera P6 Version 8

Project Planning and Control Using Oracle Primavera P6

Project Planning & Control Using Primavera P6

[cmamad id="2705" align="center" mobid="ad-off"] [cmamad id="2706" align="center" mobid="ad-off"] [cmamad id="2707" align="center" mobid="ad-off"]

 


6 COMMENTS

  1. hello, friends, I created cash flow tabulate for quarter report but the Actual cast is very less than what i wanted. Can any body help me in this regard?

Leave a Reply