• Home
  • Blog
  • Courses
  • Tools
  • Jobs
  • Forums
Have any question?
(00) 201277767728
[email protected]
RegisterLogin

Login with your site account

Lost your password?

Not a member yet? Register now

Register a new account

Are you a member? Login now

Planning Engineer Est.
  • Home
  • Blog
  • Courses
  • Tools
  • Jobs
  • Forums
      • Cart

        0

    Planning Using Primavera

    • Home
    • Blog
    • 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

    • Posted by Hany Ismail, MSC, PMP
    • Categories Planning Using Primavera
    • Date January 2, 2013
    • Comments 13 comments

    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.


     

    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:

    Cash-flow-Sample

     

    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

     


     

    Tag:Cash Flow, cash flow report, Cash flow Sample, cash flow steps, earned value, earned value cost, excel cash flow, excel sheet, internet explorer, Monthly Project Cash flow, planned value, planned value cost, pr v7 cash flow, primavera cash flow, primavera HTML, primavera p6 v7 reports, primavera Tabular report

    • Share:
    Hany Ismail, MSC, PMP
    Hany Ismail, MSC, PMP

    Hany Ismael is the founder and CEO of Planning Engineer Est. in Egypt. He has started his career back in 2003 as a site engineer, technical office engineer, planning engineer, planning manager, and finally planning department manager where he has been involved in several mega construction projects in Egypt and Saudi Arabia. In 2016, he established his own company in Egypt “Planning Engineer Est.” Hany gained his MSc degree in project management from Liverpool University-UK 2013-2016, PMP certified from PMI-USA 2010, and BSc Civil Engineer Tanta University-Egypt 2003. Hany provided more than 3,500 hours of planning and project management training on his website planningengineer.net, YouTube channel, and offline courses since 2011. He enjoys teaching project management in simple and practical way, and he developed several planning tools, techniques and courses.

    Previous post

    Cost Management for Engineers-Cost Terms
    January 2, 2013

    Next post

    construction project management essential 4 terms you should know
    January 3, 2013

    You may also like

    Remove Actuals using Global Change cover
    Remove Primavera P6 Actuals using Global Change
    24 January, 2022
    Bulk Delete Relationships in P6 cover
    Bulk Delete Relationships in P6
    20 January, 2022
    img_0237.png
    Primavera P6 Calendar 10 Tips and Tricks
    18 November, 2020

      13 Comments

    1. blank
      Hasan Jlelaty
      January 4, 2013
      Log in to Reply

      thank you

    2. blank
      Hassaan Akram
      January 29, 2013
      Log in to Reply

      Thanks a lot! Now if we want this P6 report in excel format, what to do?

    3. blank
      Isra Abu Saadeh
      February 7, 2013
      Log in to Reply

      thanks many.

    4. blank
      Abu Afnan Dawood Chughtai
      April 29, 2013
      Log in to Reply

      🙂 thnks

    5. blank
      Sefa Gencer
      July 8, 2013
      Log in to Reply

      Thanks. It is usefull. I use P6 R8.3 but do not know how to get cash flow. Anybody knows that?

    6. blank
      Zarmina Popal
      October 21, 2013
      Log in to Reply

      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?

    7. blank
      pushpalatha
      July 10, 2014
      Log in to Reply

      ur doing wery nice and simple. i want to know how make weightage and %complete works in p6 with out resources
      sir

    8. blank
      Michael
      October 15, 2014
      Log in to Reply

      Hi,
      I couldn’t make cash flow report in p6 R8.1 & i cant find REport tabular under cost group.please …

    9. blank
      mohammad
      October 16, 2014
      Log in to Reply

      do you have excel sheet for cashflow

    10. blank
      johnkbaby
      December 16, 2014
      Log in to Reply

      good

    11. blank
      Mohammed Afroz Ahmed
      May 29, 2015
      Log in to Reply

      Thanks Mr. Hani

    12. blank
      tairi.abdelhak
      August 28, 2015
      Log in to Reply

      Thanks Mr Hany

    13. blank
      mihiso72
      April 27, 2016
      Log in to Reply

      Thanks, Mr. Hani, great job!

    Leave A Reply Cancel reply

    You must be logged in to post a comment.

    Cart

    0

    Planning Courses

    Cost Control for Construction Projects

    Cost Control for Construction Projects

    $299.00
    Power Bi Monitoring and Controlling with P6

    Power Bi Monitoring and Controlling with P6

    $299.00
    Advanced Planning 3 Courses Package

    Advanced Planning 3 Courses Package

    $499.00
    Data Management and Reporting

    Data Management and Reporting

    $199.00
    Primavera Online Basic Course -Arabic

    Primavera Online Basic Course -Arabic

    $99.00
    Professional Planning Engineer (PPE)

    Professional Planning Engineer (PPE)

    $335.00
    Claims Management and (EOT)

    Claims Management and (EOT)

    $175.00
    Primavera Online Basic Course -English

    Primavera Online Basic Course -English

    $99.00

    Follow Us:

    About Us | Contact Us | Terms of Service | Privacy Policy | Refund Policy

    Copyright ©2012- 2018 planningengineer.net | All materials, unless otherwise noted, were developed originally for Planning Engineer Website. In the event that there is still a problem or error with copyrighted material, the break of the copyright is unintentional and noncommercial and the material will be removed immediately upon presented proof.

    • Planning Courses
    • Planning Jobs
    • Planning Blog
    Posting....