Budget cash flow by month

[LG]

This should be simple...

I am creating multiple summary tasks with sub's incurring estimated costs
over the course of several months. I would like to be able to manage and
communicate these costs by month as they fit into the company-wide cash flow
plan.

The cash flow report does little to help me summarize/subtotal the
individual summary tasks within the whole project. Exporting the timephase to
Excel does not let me send additional outline codes with it so I can also do
sorting across the breadth of the project.

Am I trying to do too much within a single project? Any ideas?

 

[John]

This should be simple...

I am creating multiple summary tasks with sub's incurring estimated costs
over the course of several months. I would like to be able to manage and
communicate these costs by month as they fit into the company-wide cash flow
plan.

The cash flow report does little to help me summarize/subtotal the
individual summary tasks within the whole project. Exporting the timephase to
Excel does not let me send additional outline codes with it so I can also do
sorting across the breadth of the project.

Am I trying to do too much within a single project? Any ideas?

LG,
Well depending on your frame of reference, it is simple, or at least
reasonably so. As you found out the built-in reports have limitations
and so does the timephased export utility/add-in. However there are at
least two ways to get what you want. The first is a bit tedious and
prone to human error but straightforward. The second is a little more
elegant.

One method is to set up the Task Usage view to show what you want. Then
copy and paste the left and right sides of the screen into Excel. As I
said, tedious but straightforward.

My preferred method for generating reports of this type is to create a
VBA macro that picks out the exact data needed and exports it to Excel.
VBA gives total flexibility and once the code is developed, the process
becomes very quick and accurate.

Hope this helps.
John
Project MVP

 

[LG]

Thanks John, the Excel copy/paste will get me by to begin with. Thanks for
the reply.

: