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 YouTube 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

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.

[mark]

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

[briankpaine]

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

[ambujkumar]

You have explained very well. Its so helpful.

[tareqkhanji]

Wish you the best from Syrian re-constructor 👍

[vanessaalpay]

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

[kelechibenemor]

Many thanks Tom for this priceless videos..

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

[fraviusadolph]

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.

[franciscoguzman]

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

[문동렬]

Thank you for your good lecture on making cash flow.

[adriangalessi]

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?

[hossbooo]

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.

[enriquemarollano]

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.

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

[kietnguyenhoang]

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

[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

[sr]

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?

[ravindrankrishnan]

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.

[kozay]

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

[jartmann]

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