Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Cash Flow report without resource loading in P6

9 replies [Last post]
Tony Thomas
User offline. Last seen 5 years 35 weeks ago. Offline
Joined: 15 Aug 2018
Posts: 3
Groups: None

Hi,

How Can I prepare a monthly cash flow report(Budgeted vs Actual) without resource loading in P6, only by putting the budget against each activity?

Thanks in advance

Tony

Replies

Rafael Davila
User offline. Last seen 10 hours 53 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229

The above example is very simple for illustration purposes but it is not unusual to have different budgets, perhaps one for purposes of Billings, and another for purpose of cost control where you will track labor, equipment, materials, subcontracts and other cost types for each cost account. In such case you level only cost accounts that define your financial constraints.  The use of Cost Centers make it easy to select the account groups of concern. 

Zoltan Palffy
User offline. Last seen 4 weeks 21 hours ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

thanks Tom good to know I never uses expenses 

Tom Boyle
User offline. Last seen 4 weeks 1 day ago. Offline
Joined: 28 Nov 2006
Posts: 304
Groups: None

Zoltan, yes you can.  Activity Usage Profile using Cost instead of Units incorporates all the Expense tab data. 

Zoltan Palffy
User offline. Last seen 4 weeks 21 hours ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

I am not sure that you can get an S curve using expenses

Mohammed Atia
User offline. Last seen 3 years 28 weeks ago. Offline
Joined: 4 Apr 2017
Posts: 2
Groups: None

you can use Expenses to load cost on all activities you want,

add one expense on an activity then export on excel then add the cost and import it again on primavera.

Tom Boyle
User offline. Last seen 4 weeks 1 day ago. Offline
Joined: 28 Nov 2006
Posts: 304
Groups: None

I'd agree that cost loading is most commonly done through resource loading of a lump-sum resource as Zoltan has laid out.  The restriction, "...without resource loading in P6...." can be strictly satisfied by loading costs through the Expenses tab.  Although this is not the stated purpose of the Expenses tab, some contract specifications explicitly require it (not sure why.)  

Zoltan Palffy
User offline. Last seen 4 weeks 21 hours ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

add a resource call LUMPSUM or what ever

filter for all of the activities that you want to cost load

select edit select all

right click and select assign 

then select  resources

then select the new resource that you created

now in the resource tab under budgeted cost

assign the cost for each of teh actyivities

when done you can either select view show on bottom activity usage spreadsheet

or view show on bottom resource usage profile thsi will give you your cost curve

Tony Thomas
User offline. Last seen 5 years 35 weeks ago. Offline
Joined: 15 Aug 2018
Posts: 3
Groups: None

How can I prepare a report with dollars for each activity?

Zoltan Palffy
User offline. Last seen 4 weeks 21 hours ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

putting the budget against each activity is resource loading its loading with dollars not manhours