How to Create a Cash Flow Forecast using Microsoft Excel - Basic Cashflow Forecast

Create a basic cash flow forecast using excel. If you need help get in contact. www.freebookkeepingaccounting.com
Support this channel www.paypal.com...
Take our Online Sage training course
www.freebookke...
Create a bookkeeping spreadsheet using Microsoft Excel
• Create a Bookkeeping S...
Sage Accounts Bookkeeping Tutorial/Training
Learn more at www.freebookkeepingaccounting.com

[@warrilow2008]

I just wanted to say.... iv been struggling to do this for a good few days, with my brain near exploding. And now iv done it. You sir - are a gem. Thank you very much.

[@BookkeepingMaster]

jonathan warrilow No problem. Thanks for watching. www.freebookkeepingaccounting.com

[@omkarghosalkar3428]

Which Excel course should I do for learn this skills

[@warrilow2008]

@ I dunno bro - this was 9 years ago

[@Acidicmixture]

Watching this in 2025. So simple and yet so effective!

[@BookkeepingMaster]

Thanks for watching!

[@Omarsenateur]

I watched the first 3 series of this video, Saves me months of research as a new Business owner. As a token of Appreciation, i have smashed the like, comment, subscribed, signed up for notification and shared this last one before i go to to bed, ill be on his channel tomorrow learning at my own pace. Thank you mate.

[@BookkeepingMaster]

Thank you so much! All the support I can get is appreciated.

[@missinvisble]

Couldn't have done a cash flow without you, thank you, have now subscribed ...

[@BookkeepingMaster]

Awesome, thank you so much!

[@pfreduk]

Exactly what I've been looking for ! Clear, concise and a joy to follow. I'm well impressed and THANK YOU. You are a STAR !

[@BookkeepingMaster]

pfreduk No problem. Please check out my website for more free videos.

[@wattef3945]

no he is hoomun

[@johnpeters2526]

This is a great video, by the time I finished formulating the excel by following this video I was understanding how cashflow really works

[@BookkeepingMaster]

Great job! Thanks so much for watching.

[@FionaAberTaruona]

I know this is an old video, but this along with your creating management accounts series has been really helpful for me. Thanks for sharing!

[@BookkeepingMaster]

No problem, Fiona. Thank you for watching.

[@AA-fu7on]

Thank you so much. An extremely helpful video for someone who doesn't like numbers, but owns a business.

[@BookkeepingMaster]

Glad it was helpful! Thanks for the comment

[@anasuyahpather7613]

I followed this exactly! Thankyou! not only can I do the cashflow but I feel like you also taught me to be an excel wizz!!

[@BookkeepingMaster]

Great job! Thanks for the comment.

[@Taxia123]

Thanks for the update. There's one improvement that you can make is to "group" the sub categories instead of "hiding" them. That makes the manager happier.

[@BookkeepingMaster]

Thanks

[@aschultz007]

Excellent tutorial. After searching lots of sites for an effective tool this wins hands down. All others are too complicated.

[@BookkeepingMaster]

Thank you for the kinds words and thanks for watching.

[@aphelelebekebu1567]

I was struggling with cash flow statements for a while now. thank you for this basic but informative video. keep up the good work.

[@BookkeepingMaster]

+aphelele bekebu Thank you. Please check out my other videos and my website.

[@juliusmkandawire8423]

I struggle with dividing the columns into budgeted and Actual headings how can I do that?

[@Dubysoul_Werke]

is it possible if yoou can help me with the cash flow projections?

[@pablocalderon9528]

Thank you, best simple Cash Flow Forecast model I've seen.

[@BookkeepingMaster]

Wow, thanks!

[@philshorter1118]

Just want to say thank you i found this really helpful in adapting this for my small business..

[@BookkeepingMaster]

No problem. Thanks for watching.

[@HannahAguilar-lk8by]

I"m going to look for more videos from you. I actually understood what you were talking about. After reading this module's chapters for my class, I am so confused by forecasting, but I think this video will help me get through it.

[@BookkeepingMaster]

Great! Thanks for taking the time to comment.

[@adamchaudhry4865]

ABSOLUTELY BRILLIANT!!Couldnt have asked for anything better or precise and explanatory without any jazz !!

[@DashaTolkacheva-b6z]

Amazing explanation, easy even for dummies, thank you!

[@BookkeepingMaster]

Glad it was helpful! Thanks for watching and for taking the time to comment.

[@misfit2022]

I use a very similar model in the real world and works a treat. Nice and simple model but works every time.

[@BookkeepingMaster]

+misfit Thanks for watching

[@deborahjoseph5170]

You are a great teacher. Thank you! Thank you!

[@BookkeepingMaster]

Wow, thank you!

[@SilasMwaiO]

Very elaborate and precise, thanks for this video.

[@BookkeepingMaster]

Glad it was helpful! Thanks for watching

[@digitalloyd1842]

Thank u for making such a useful video. I have gained a lot of knowledge from this.

[@BookkeepingMaster]

Great! Thanks for watching.

[@selfcareforcarers893]

Thanks a million -very good and easy to follow- I had to review the part where you entered the formulas as you were a little too quick for me. but it has been really valuable and clear thanks so much!

[@BookkeepingMaster]

Karen Brett Thanks for the comment. Please check out my website for more free videos www.freebookkeepingaccounting.com

[@shanairogers5964]

me too I still dont understand how he was able to copy the closing balance formula into the opening balance formula. when I try im not able to do it

[@hitashiakounamattata4627]

You are so good with teaching , Love your tips and thanks a lot ..

[@BookkeepingMaster]

No problem. There are many more free videos available on my website.

[@airenedimapilis4510]

Hitashi AkounaMattata

[@airenedimapilis4510]

Hitashi AkounaMattata

[@chickp100]

This was great! You make it look so easy. I will try this out myself and if I get stuck I will be in contact for some help. Thank you!

[@BookkeepingMaster]

Glad it was helpful! Thanks for the comment, good luck!

[@sunshyne40]

Truly helpful, thank you for taking the time to make this video.

[@BookkeepingMaster]

No worries! Thanks for watching

[@joecastle3942]

Really helpful this mate, helped with sorting my finances a lot

[@BookkeepingMaster]

No problem. Thanks for watching.

[@fatmatajarieubarrie6458]

Wow I love the clarity of this lecture

[@BookkeepingMaster]

I'm so glad! Thanks for watching.

[@righteousness31]

ALL I CAN SAY IS, "I LOVE YOU"

[@BookkeepingMaster]

Thank you

[@stephendonovan6773]

Thank you for such a great video. Straight forward and informative!!

[@BookkeepingMaster]

Thanks a lot

[@chrisashton8729]

Very good! Actually tweaked it for expenses at uni but just as effective.

[@Vyollete]

You made it look so simple.Thank you

[@BookkeepingMaster]

No problem. Thanks for watching.

[@my_hot_kitchen3220]

tq for a great and clear video tutorial, I have subscribed your channel as a way of my appreciation to you

[@BookkeepingMaster]

Thanks and welcome

[@nel_grp]

VERY helpful! exactly what I have been looking for. Thanks!

[@BookkeepingMaster]

Great to hear!

[@ScienceRDVentura]

Thanks this was great and just what I needed. The only comment I would have is slow down and explain clearer when you enter a formula I had to go back over and over to get it. But overall Great! Thanks

[@BookkeepingMaster]

Science R&D No problem. Thanks for the comment.

[@ceciliairungu3909]

Thank you for this educative video...can't wait to see more videos

[@BookkeepingMaster]

More to come! Thanks

[@UzairRuwaida]

THanks...very usefull.. i've done make it month by month by your tutorial

[@BookkeepingMaster]

Great. Thanks for watching.

[@Unitywf]

Thanks, sir excellent tutorial and very easy to follow

[@BookkeepingMaster]

Glad you liked it. Thanks for watching.

[@ajayjackson7727]

This was Interesting, you explain it very well

[@BookkeepingMaster]

Thanks!

[@zoeliang2364]

your voice reminds me an old friend. oh i miss him

[@JoJo-wl3xc]

F

[@ErtugrulOsman-e6s]

Great explanation ❤

[@BookkeepingMaster]

Glad you think so!

[@xjyoyo]

Thank you! You solved my problem at work! Great valuable video 👍

[@BookkeepingMaster]

Great to hear! Thanks for watching

[@manuelmyles.s2530]

best tutorial and really helped a lot, thanks very much sir

[@BookkeepingMaster]

Thanks a lot

[@ademolashabi6643]

This really was useful. Thank you.

[@BookkeepingMaster]

Glad to hear that! Thanks for watching and for the comment

[@finndrummond3393]

you have saved me for my Business project!

[@wattef3945]

no he has nat

[@dyahiffahnovitasari4020]

This is tutorial I've been looking for. Thanks!

[@BookkeepingMaster]

Glad I could help. Thanks for watching.

[@elias_xp95]

Thank you for the help. Genuinely appreciated. But I can't help but laugh.
It's true what they say. Even talking about accounting is boring 😂
Thanks for the help 😀

[@BookkeepingMaster]

I am a typical accountant; boring, in need of glasses, slightly overweight.

[@littleperson2237]

This helped so much thank you!

[@BookkeepingMaster]

You're so welcome! Thanks for watching

[@luizaugustowagner]

Simple and effective. Thanks for sharing.

[@BookkeepingMaster]

No problem. Thanks for watching.

[@letsCOOKwithELLE]

Thank you so much for this video, it was very helpful.

[@BookkeepingMaster]

No problem. Thanks for watching.

[@leo96119611]

Great tutor 👍👍👍if a little slower much better.

[@BookkeepingMaster]

Thanks for the tip

[@MobeenKhalidKhawaja]

Loved the way you're so precise about everything. Keep up the good work mate!

[@BookkeepingMaster]

+Mobeen Khalid Khawaja Thanks a lot. Please check out my website for more free videos.

[@MobeenKhalidKhawaja]

Sure mate

[@youvsyouofficial]

Thank you for sharing. Very helpful

[@BookkeepingMaster]

Thanks!

[@k-fly4786]

Shoo.. This was so helpful. Thank you.

[@BookkeepingMaster]

So glad! Thanks for watching and for the comment

[@monajoseph2709]

You are a star thanks so much

[@BookkeepingMaster]

No problem 😊 Thanks for watching

[@vj-pt2fi]

Thank you. Very helpful. God Bless You.

[@BookkeepingMaster]

You're welcome! You too!

[@luzvimindachangsi8806]

thank you sir i learn a lot

[@BookkeepingMaster]

It's my pleasure. Thanks for watching.

[@gomzify]

Awesome content 🙏

[@BookkeepingMaster]

Glad you think so! Thanks for the comment and the sub

[@gusolive]

i have to say this is mind blowing :)

[@BookkeepingMaster]

Thanks!

[@ezequiel2955]

Amazing video. Thank you!

[@BookkeepingMaster]

Glad you liked it! Thank you for watching and for taking the time to comment

[@tracymarsh8783]

Thanks, excellent, clear and helpful.

[@BookkeepingMaster]

Great to hear! Thanks for watching

[@jordansloane515]

Thanks for sharing this video I found the information very helpful.

[@BookkeepingMaster]

No problem. Thank you for watching and for your comment.

[@ernestdegraft-amoah]

Great Tutorials. Very helpful

[@BookkeepingMaster]

No problem. Thanks for watching.

[@radhadevan1768]

thank you so much. your video are quite helpful and clear .

[@BookkeepingMaster]

Thanks a lot, much appreciated.

[@TopMusicChannelLive]

massive help thank you

[@BookkeepingMaster]

Thanks!

[@michaelvaluciek8893]

👍 Great video. V helpful

[@BookkeepingMaster]

Glad you think so! Thanks for watching

[@theliberatedqueen603]

Thank you so much Sir. This was really helpful.

[@BookkeepingMaster]

So nice of you. Thanks for watching.

[@stacysr7117]

What if I dont own any loan? Do I need to list every expenses for the business? How do I predict the sales and salary? Also What should be the same as the owner's capital?I'm asking since I have two businesses under one.

[@kayitarenancy4631]

Thank you so much! that's a fantastic tutorial!! you saved me!!!!

[@wattef3945]

no he did nat

[@memfycases]

Fantastic, Thank you very much!

[@BookkeepingMaster]

Glad it helped! Thanks for the comment

[@HowiReallyFeel]

hello, love this! how would i adjust my cash forecast if I were to convert clients from a net 30 term to net 90 term?

[@BookkeepingMaster]

You would enter the payments received as 3 months after the invoice sale. I hope this helps. Thanks for watching

[@derinsider3438]

well explained. Many thanks

[@BookkeepingMaster]

Glad it was helpful! Thanks for watching

[@danielmagdziarz7440]

Very useful material. Thanks.

[@BookkeepingMaster]

No problem. Thanks for watching.

[@najimsyraimi2793]

Great help and nice excel tricks

[@BookkeepingMaster]

Thanks a lot

[@eiahtotz]

do you have a video for daily cash flow forecast? or there's not much difference there?

[@iamlucasbernard]

This is really helpful. Thanks a lot!

[@BookkeepingMaster]

No problem, thanks for watching.

[@sbrother176]

Very precise and more understandable

[@BookkeepingMaster]

Thanks

[@fitbyphase8157]

Immensely clarifying! Excellent work and thanks for the tutorial!

[@BookkeepingMaster]

No problem. Thank you for watching and for your kind words.

[@SJQuirke]

Cool - thanks for this tutorial - very clear and useable -

[@BookkeepingMaster]

No problem. Thanks for watching.

[@richardtrent4836]

SO helpful! Thanks.

[@BookkeepingMaster]

You're welcome! Thanks for watching.

[@PeterMoran-u3i]

Top Man, Thank you so much

[@BookkeepingMaster]

You're welcome! Thanks for watching and for the comment

[@jebarajakumar9371]

Thanks for demo. Much appreciated!

[@BookkeepingMaster]

No problem. Thanks for watching.

[@mcmilad1]

YOU ARE THE BEST DUDE!

[@BookkeepingMaster]

+Milad Chowdhury Thanks, no problem

[@SpecialSpear]

It is really helpful. Thank you so much for the video

[@BookkeepingMaster]

No problem. Thanks for watching.

[@btddck1310]

Thanks Bookkeper! This helped me out a lot:)

[@markoamanita1981]

Thank you for this, it was really helpful. Best regards from Croatia!

[@BookkeepingMaster]

Thanks. Best regards from England!

[@sailani_traveller]

Thank you for the video. Here we are learning two thinks Cash Flow and Excel.
I have a question, You have left the cell blank in sale (B10, C10) ... why ?
Same with Merchant and Postage (B23,B24 - C23,C24)...?
What is the meaning of Goods for Resale ?
Please answers to my question and help me in clearing my doubts...
Thank you so much

[@sunnysam1166]

Thanks for your share, It is wonderful.

[@BookkeepingMaster]

No problem. Thanks for watching.

[@anwarorakzai123]

video was extremely helpful...just a small question if we start to pay the loan amount from the 2nd month why do we have to pay the interest on loan in a first month?

[@urbanmusellc2007]

Interest begins the moment you sign the paperwork.

[@gaz9012]

Hi, thanks for posting this, its helping me do my business plan. i followed everything until you went from closing balance in april to opening balance for the next month. i keep rewatching it, but i just can see what you did to link the two

[@BookkeepingMaster]

When starting a new month use the closing balances of the previous month for the opening balances of the current. Delete any other data on the spread sheet but obviously do not delete any formulas. On the P&L you will need to delete sales info - everything else will be updated automatically. Hope this helps. If you still need assistance I can provide email support but this will incur a small fee. Thanks for watching.

[@johnnausiennasak4980]

Hello Sir how to you keep the outflow and closing balance increasing when added the overdraft interest?

[@jacquelinejacqueline162]

Brilliant! Thank you.

[@BookkeepingMaster]

You're very welcome! Thanks for watching.

[@Kitty-lj7eg]

Very helpful, thanks!

[@BookkeepingMaster]

No problem. Thanks for watching.

[@ArlenaMaree]

This was such a huge help thank you so much!

[@BookkeepingMaster]

No problem. I am glad that it was beneficial. Thanks for watching.

[@transformationaltv5949]

This is a good job. Please, can explain to me what to click to get the sum or the currency sign when you added or were totaling incoming cash?

[@jobabes170]

Helped me with my uni work, thank you!

[@BookkeepingMaster]

+Jo Tierney No problem. Please check out my website for more free accounting videos.

[@nhitranphanphuong2152]

This method is called Direct Cash Flow Forecast, right? Thanks for your useful video with basic info. Keep going!

[@kelvingonah6843]

This is awesome thank you

[@BookkeepingMaster]

Glad you like it! Thanks for watching

[@rodrigopalomino6603]

I appreciate your project is excellent. Thank you very much.

[@BookkeepingMaster]

No problem. Thanks for watching.

[@rodrigopalomino6603]

I am grateful, thank you.

[@hakeembaileyy]

Thank you for this video

[@BookkeepingMaster]

No problem. Thanks for watching.

[@Rozie32]

This is amazing, exactly what I need, thanks 🙏

[@BookkeepingMaster]

Glad it was helpful! Thanks so much for the comment and for watching

[@vitorsouza1335]

Thanks a lot for sharing that. Make a huge difference to me.

[@BookkeepingMaster]

No problem. Thanks for watching.