none
Fixed cost cash flow reporting RRS feed

  • Question

  • I need step by Step instructions on how to build a monthly cash flow report using fixed cost

    Thursday, October 18, 2012 5:11 PM

All replies

  • Jwhitejr02 --

    Well, my friend, it really would help if you told us WHAT type of report you want to create.  Do you mean a Visual Report?  Or do you mean the built-in reports that you access by clicking the Reports button on the Project ribbon?  And it would also help if we knew whether you are using cost rates for your resources, or whether you are only using Fixed Cost amounts on every task.  Oh, well, let me guess what you are trying to do and give you a possible solution.  Try this:

    1.  Open the project in question.
    2.  Click Project > Reports > Costs.
    3.  Double-click the Custom button to display the Custom Reports dialog.
    4.  Select the Cash Flow report and then click the Copy button.
    5.  In the Name field, enter a name for this new report, such as Monthly Fixed Cost Cash Flow.
    6.  In the Column field, select Months.
    7.  In the Row field where you see the Cost field, click the pick list and select Fixed Cost instead.
    8.  Click the OK button and then click the Select button to display the new Monthly Fixed Cost Cash Flow report in Print Preview mode.

    To create a monthly Cash Flow visual report using Fixed Cost, do the following:

    1. Open the project in question.
    2. Click Project > Visual Reports.
    3.  In the Visual Reports – Create Report dialog, select the Cash Flow Report.
    4.  Click the Select Level of Usage Data to Include in the Report pick list below the list of Visual Reports, and then select the Months item on the pick list.
    5.  Click the View button to create the initial Cash Flow report in Excel.
    6.  In the resulting Cash Flow report in Excel, DESELECT the checkboxes for the Cost and Cumulative Cost fields in the PivotTable Field List sidepane.
    7.  In the PivotTable Field List sidepane, SELECT the Fixed Cost checkbox, the Tasks checkbox, and the Monthly Calendar checkbox.
    8.  In the lower left corner of the Excel application window, click the Task Usage tab.
    9.  In the Task column of the resulting PivotTable, expand the tasks and summary tasks as needed.
    10.  In the Year columns, expand the years so that you can see months.

    Hope this helps.


    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Friday, October 19, 2012 2:43 AM
    Moderator
  • Jwhitejr02 --
     
    Well, my friend, it really would help if you told us WHAT type of report you want to create.  Do you mean a Visual Report?  Or do you mean the built-in reports that you access by clicking the Reports button on the Project ribbon?  And it would also help if we knew whether you are using cost rates for your resources, or whether you are only using Fixed Cost amounts on every task.  Oh, well, let me guess what you are trying to do and give you a possible solution.  Try this:
     
    1.  Open the project in question.
    2.  Click Project > Reports > Costs.
    3.  Double-click the Custom button to display the Custom Reports dialog.
    4.  Select the Cash Flow report and then click the Copy button.
    5.  In the Name field, enter a name for this new report, such as Monthly Fixed Cost Cash Flow.
    6.  In the Column field, select Months.
    7.  In the Row field where you see the Cost field, click the pick list and select Fixed Cost instead.
    8.  Click the OK button and then click the Select button to display the new Monthly Fixed Cost Cash Flow report in Print Preview mode.
     
    To create a monthly Cash Flow visual report using Fixed Cost, do the following:
     
    1. Open the project in question.
    2. Click Project > Visual Reports.
    3.  In the Visual Reports �?? Create Report dialog, select the Cash Flow Report.
    4.  Click the Select Level of Usage Data to Include in the Report pick list below the list of Visual Reports, and then select the Months item on the pick list.
    5.  Click the View button to create the initial Cash Flow report in Excel.
    6.  In the resulting Cash Flow report in Excel, DESELECT the checkboxes for the Cost and Cumulative Cost fields in the PivotTable Field List sidepane.
    7.  In the PivotTable Field List sidepane, SELECT the Fixed Cost checkbox, the Tasks checkbox, and the Monthly Calendar checkbox.
    8.  In the lower left corner of the Excel application window, click the Task Usage tab.
    9.  In the Task column of the resulting PivotTable, expand the tasks and summary tasks as needed.
    10.  In the Year columns, expand the years so that you can see months.
     
    Hope this helps.
     

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Friday, October 19, 2012 12:46 PM
    Moderator
  • Dale

    I am Looking to create a Monthly Cash Flow Spreadsheet in excel. all of my task have a fixed cost assigned to them.

    Thanks for all your help

    Friday, October 19, 2012 1:49 PM
  • Also Dale I am using Project 2010 Professional
    Friday, October 19, 2012 1:50 PM
  • Jwhitejr02 --
     
    Then you need to use the second solution I suggested:  using a Visual Report.  If neither of my solutions works for you, then the only way to create your report is to write custom software code in Microsoft Project VBA.  Hope this helps.

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Friday, October 19, 2012 7:38 PM
    Moderator