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

In this video, I go over 3 ways to make a cash flow report in MS Project. Often the report you seek requires some special information so I go through different ways of producing the report with the 3rd way providing an interesting workaround to creating a cash flow report in MS Project. If this video is too advanced for you or there is other specific information you seek, subscribe and check out my playlists on my KZbin channel, click notifications so that you know when I upload new videos, and provide feedback and comments. This video was produced based on a question sent to me.
A sampling of MS Project Tutorials
• Tutorial 1 Introduction: • MS Project Tutorial 1 ...
• Tutorial 2 Calendars & Columns • MS Project Tutorial 2 ...
• Tutorial 3 How to Maneuver • MS Project Tutorial 3 ...
• Tutorial 4 Resources and Costs • MS Project Tutorial 4 ...
• Tutorial 5 Updating a Schedule • MS Project Tutorial 5 ...
• Tutorial 6 Recovering Schedule • MS Project Tutorial 6 ...
• Tutorial 7 Adding a Change • MS Project Tutorial 7 ...
• Tutorial 8 File Saving Protocol • MS Project Tutorial 8 ...
• Tutorial 9 No Open Ends • Three ways to avoid op...
Tom Stephenson is a national award-winning professor (George Brown College, University of Toronto) and best-selling author whose background in education spans nearly three decades. His diverse teaching disciplines include construction project management, business management, human resource management, architecture, carpentry, and brick and stone masonry. As a dual-professional, Tom is called upon by industry leaders to translate knowledge, reinvigorate corporate culture, and inspire innovation in emerging and established companies across Canada. Before breaking into the academic realm, Tom acquired more than a decade of practical project-management experience, operating a mid-sized Toronto-based general contracting firm. He is also the author of the newly released Planning, Scheduling, and Control of Construction Projects with American Technical Publishers and the four best-selling editions of Understanding Construction Drawings for Housing and Small Buildings with Nelson Publishing Canada. Tom most recently received the Toronto Construction Association’s 2020 Chancellor’s Award for “helping his peers become more ethical, knowledgeable and professional.” A champion of change management, Tom takes pride in helping students and businesses navigate uncharted territories, take calculated risks and rise above the status quo. Some of the companies he’s worked with include Mattamy Homes, EllisDon, BIRD Construction, MCA, Maple Reinders, and Tucker HiRise, University of Toronto Project Managers.

[@kelechibenemor5103]

Many thanks Tom for this priceless videos..

[@TomStephensontraining]

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

[@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

[@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

[@user-tz9ie3hw9m]

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

[@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

[@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?

[@constanzagil9712]

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

[@TomStephensontraining]

Thanks so much for the kind comment Constanza

[@shishupalsingh5614]

Great work.

[@TomStephensontraining]

Thanks Shishupal

[@tareqkhanji]

Wish you the best from Syrian re-constructor 👍

[@TomStephensontraining]

Thanks so much Tarek, all the best from Canada!

[@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.

[@x9rtu3os1t8]

You are awesome 😁👌⭐.

[@TomStephensontraining]

Thanks Tomer, Have a wonderful weekend!

[@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.

[@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

[@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.

[@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.

[@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.

[@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

[@jartmann2011]

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

[@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

[@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.

[@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.

[@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.