Learn 3 Ways to create a cash flow report & S curve in MS Project. MS Project Made Easy Tutorial 21

[@aizuwan_]

Hello sir. I just want to say I really appreciate for everything you teach. very helpful!

[@TomStephensontraining]

Im very happy to help on your learning journey

[@mark81440]

Hello. Wish you all the best from Korea^^ I can't thank you too much on your video. Have a great weekend

[@TomStephensontraining]

Thanks so much, have a great weekend as well! Nice weather in Toronto, a little rain but nice

[@tareqkhanji]

Wish you the best from Syrian re-constructor 👍

[@TomStephensontraining]

Thanks so much Tarek, all the best from Canada!

[@kelechibenemor5103]

Many thanks Tom for this priceless videos..

[@TomStephensontraining]

Thanks Kelechi, I’m glad the videos are helping you. Keep learning!

[@ambujkumar1627]

You have explained very well. Its so helpful.

[@TomStephensontraining]

Thank you Ambuj for taking the time to write this thoughtful comment.

[@vanessaalpay8829]

Thank you so much, the last part is the one I'm looking for..

[@TomStephensontraining]

Excellent Vanessa, glad 1 works for yoy

[@hillsong-ny6yc]

awesome videos, many thanks . I have been watching videos and practicing, here is my question, I could not see cash flow report for the cost and material allocations. for example, the rental cost of the task 1 is 100 which is paid out at the start of the task. however such cost flow is not shown in the cash flow report, all that I can see is the cash flow for work type cost. why so?

[@briankpaine]

Very helpful. Thanks and BTW, excel will autofill months 😉

[@TomStephensontraining]

Thanks for letting me know

[@nessim.liamani]

Thanks Tom, It's very well explained. Just some recommendations : 1. It would be great to have a video showing the most useful reports to make use of during a project. There is none (for MSP 2019) as good as yours on YT. 2. As stated before on another video, it would be awsome to have a video using both usage of Budget and Cost to see the added value of having them both on our projects. -- Thanks again Tom.

[@TomStephensontraining]

Great thanks for the ideas

[@문동렬]

Thank you for your good lecture on making cash flow.

[@TomStephensontraining]

Great I'm glad it helps you, I have more in depth talks (no MS Project specific) on cash flow in my Construction Business Management Playlist link below. Tutorial 6A Cash Flow kzbin.info/www/bejne/o2SngnVordd3p7s

[@adriangalessi9261]

Hi Tom, thanks for the video. I'm trying to map cumulative forecasted costs against cumulative actual costs. Do you know how I could achieve that in the cashflow report?

[@ФишкиОтАйтишника]

Thanks a lot!

[@TomStephensontraining]

Happy to help

[@shishupalsingh5614]

Great work.

[@TomStephensontraining]

Thanks Shishupal

[@fraviusadolph3261]

Thanks tom for This Amazing Video. How can I put the Actual cost flow day By day In MS Project. Example the Material Used by Today's work etc.

[@franciscoguzman1524]

Hi Tom, thanks, great video. One question: how can I be able to depict a cashflow report showing amounts regarding construction cost (as you do show at this tutorial) and amounts regarding income due to real estate sales (units that have been sold over the course of the construction process) AND the diference between both of them at a separate row as well, then I truly know when I´m in green numbers or RED numbers, that would be great. I do that with other softwares but I´d rather MS project to perform it as well. thanks, cheers

[@TomStephensontraining]

Hey Francisco, you probably could but it require some programming. Easier to do in excel.

[@constanzagil9712]

😁 wauuuu you are so good, thanks!!!!!!!

[@TomStephensontraining]

Thanks so much for the kind comment Constanza

[@x9rtu3os1t8]

You are awesome 😁👌⭐.

[@TomStephensontraining]

Thanks Tomer, Have a wonderful weekend!

[@bootinaka]

What would be the best way to cost load a schedule for a construction manager. Our only direct labor costs are for a PM & Superintendent. All of our subs are lump sum broken down by cost code.

[@TomStephensontraining]

Check my videos on cost and I resource loading i have a few on my MS Project playlists. Usually around video 4 or 5. Easy enough you. Add site super and pm as work and the subs as a cost. Add the pm and site super to appropriate summary tasks.

[@hillsong-ny6yc]

Another question, assiging project manager resouces to the very top project summary is not allowed in MS project, So, the alternative solution is to assign it to all sub project summmy tasks to reflect the PM cost ?

[@TomStephensontraining]

You can assign to the top one if you create it instead of adding or on top of adding a project summary task.

[@hossbo0o0o22]

Many thanks Tom for these valuable lessons. I have one question. I am working as a contractor, and I want to include the received payment from the client on cash flow (as cash-in), which will give me real cash flow. I believe MS project just provide Cash-out only.

[@TomStephensontraining]

Hi Hoss, Thanks for the kind words. Yes MS Project only shows the amount going out not what is coming in.

[@abeltube-5755]

Please help me ! How to prepare cash flow , man power allocation, equipment and material delivery schedules based on the revised master schedule.

[@TomStephensontraining]

See other reply

[@enriquemarollano3816]

Hi Sir, Is Budgeted Cost of Work Schedule BCWS is applicable only for material type resources? Thank you. I've been watching your videos every night after work. And I learned a lot.

[@TomStephensontraining]

Hi Enrique, its part of eva and relates to variable cost eg work under resource type

[@kietnguyenhoang8193]

Thank you very much. Could you send your file MS project, I want to study about this

[@TomStephensontraining]

Hi Kiet, In the coming weeks I intend to upgrade my website to make that possible

[@madnilkdigital]

@@TomStephensontraining looking forward to it also

[@ashraf_madkour]

great vedious can i use Ms Project as a cashflow for ( collections & cost ) rather than only costflow ? if yes plz help me with an example

[@TomStephensontraining]

Hi Ashraf, glad the videos help, unfortunately it only shows the money going out, not coming in.

[@ashraf_madkour]

@@TomStephensontraining Thanks for rapid replay .. so can we walk around by using negative sign or some how ?

[@thomasperkins8925]

@@ashraf_madkour I had the same question. Working for a real estate developer we want to see cash flow over time to predict lines of credit and when they are replenished from a sale. It does seem to work to use a (-) for revenue, but I applied it to a fairly complicated project and need to try it out on a dummy project to see if it makes sense.

[@ashraf_madkour]

@@thomasperkins8925 great please share with me your experience

[@ravindrankrishnan2964]

Pls put video for cost loading in.MS project ( item Rate contract. Where Qty and Rates are available in the BOQ ) for Cash flow and etc.

[@TomStephensontraining]

Hi Ravinder check my playlist on resources video number 4

[@ravindrankrishnan2964]

@@TomStephensontrainingThanks. I just checked, I want to understand how to do the cost loading and cash flow ( in and out ). Where BOQ is available with item Rates on Cum / Sqm in each items - Post Construction contracts. The Rate includes Men, Materials and etc. Possible pls put one Video with one example.... Expecting soon.

[@ravindrankrishnan2964]

Expecting your reply and Video for item Rate Civil construction contracts with few example ( BOQ with Qty and Rates are available )...

[@TomStephensontraining]

Hi Ravinder, Project does not do cash inflows. It’s also not really meant for detailing micro quantities

[@ravindrankrishnan2964]

@@TomStephensontraining Thank you.

[@sr940]

Dear Tom, i got an issue with costs in MS Project. I have planned fixed costs for each task. What i need is proper cash flow that shows income and outcome in the report. What is the way to do it? What i need to emphasize that all incomes and outcomes are not regular and can not be divided evenly by the duration of the task. As sample i have to purchase 1 item paying 30%advance payment and than 50% at delivery and the rest 20% -30 days after delivery. Second item these numbers are different, same is with incomes these are not regular. I can predict amounts for both but how to insert these into MS Project?

[@TomStephensontraining]

Hi, you can’t get it that accurate eg 30 before and after, you would need financial software. But you can get it more accurate by apply costs in your resource sheet and timing payments either start end or prorated. Look on my playlists eg ms project made easy likely video 4 or 5. Don’t apply everything in the fixed cost column.

[@jartmann2011]

Hello! Can anyone help me to change the cash flow report from showing the blue lines to actual monetary values? Urgent!

[@kozay8994]

May i know how to show Resource Plan Histogram or Chart in MS Project Sir?

[@TomStephensontraining]

Sure slide the mouse to the far left right click and you’ll see a menu of views and sheets. Select resource graph and you should see it. You can scroll by resource at the bottom.

[@gerhardhough8138]

Hi, Why does project not display any data in the excel file. I have followed all steps. Is there any other steps to follow?

[@TomStephensontraining]

Sorry I’m not sure works for me when I do it. Reboot and try it again I would suggest.

[@luisenriquedavilacaballero5931]

Hi Tom, how to do a Budget Cum graph?

[@TomStephensontraining]

Hi Luis, yes I need to do more videos on reports to show things like that. Thanks for watching

[@briankpaine]

... cumulative 💧💧💧🍆 ... hahaha!

[@87BBG]

+1