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.
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.
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.
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!
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.
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
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 😀
I’m confused from 5:18. When I add numbers to my money in it isn’t automatically populating the months in the opening balance like it did when you put in £500 under owners capital. HELP!
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
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?
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
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.
A bit late but thank you, just one question this is calculating month by month but would it be good if we accumulate monthly net cashes to find out whether we really have a cash flow
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.
jonathan warrilow No problem. Thanks for watching. www.freebookkeepingaccounting.com
Which Excel course should I do for learn this skills
@ I dunno bro - this was 9 years ago
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 !
pfreduk No problem. Please check out my website for more free videos.
no he is hoomun
This is a great video, by the time I finished formulating the excel by following this video I was understanding how cashflow really works
Great job! Thanks so much for watching.
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!
No problem, Fiona. Thank you for watching.
Couldn't have done a cash flow without you, thank you, have now subscribed ...
Awesome, thank you so much!
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.
Thank you so much! All the support I can get is appreciated.
I was struggling with cash flow statements for a while now. thank you for this basic but informative video. keep up the good work.
+aphelele bekebu Thank you. Please check out my other videos and my website.
I struggle with dividing the columns into budgeted and Actual headings how can I do that?
is it possible if yoou can help me with the cash flow projections?
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!!
Great job! Thanks for the comment.
Thank you so much. An extremely helpful video for someone who doesn't like numbers, but owns a business.
Glad it was helpful! Thanks for the comment
Watching this in 2025. So simple and yet so effective!
Thanks for watching!
Just want to say thank you i found this really helpful in adapting this for my small business..
No problem. Thanks for watching.
Excellent tutorial. After searching lots of sites for an effective tool this wins hands down. All others are too complicated.
Thank you for the kinds words and thanks for watching.
Thank you, best simple Cash Flow Forecast model I've seen.
Wow, thanks!
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.
Thanks
Amazing explanation, easy even for dummies, thank you!
Glad it was helpful! Thanks for watching and for taking the time to comment.
I use a very similar model in the real world and works a treat. Nice and simple model but works every time.
+misfit Thanks for watching
You are a great teacher. Thank you! Thank you!
Wow, thank you!
ABSOLUTELY BRILLIANT!!Couldnt have asked for anything better or precise and explanatory without any jazz !!
Wow I love the clarity of this lecture
I'm so glad! Thanks for watching.
Very elaborate and precise, thanks for this video.
Glad it was helpful! Thanks for watching
Very good! Actually tweaked it for expenses at uni but just as effective.
Truly helpful, thank you for taking the time to make this video.
No worries! Thanks for watching
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!
Karen Brett Thanks for the comment. Please check out my website for more free videos www.freebookkeepingaccounting.com
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
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!
Glad it was helpful! Thanks for the comment, good luck!
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.
Great! Thanks for taking the time to comment.
Really helpful this mate, helped with sorting my finances a lot
No problem. Thanks for watching.
Thank u for making such a useful video. I have gained a lot of knowledge from this.
Great! Thanks for watching.
You are so good with teaching , Love your tips and thanks a lot ..
No problem. There are many more free videos available on my website.
Hitashi AkounaMattata
Hitashi AkounaMattata
You made it look so simple.Thank you
No problem. Thanks for watching.
Thank you for such a great video. Straight forward and informative!!
Thanks a lot
you have saved me for my Business project!
no he has nat
This was Interesting, you explain it very well
Thanks!
Thanks, sir excellent tutorial and very easy to follow
Glad you liked it. Thanks for watching.
VERY helpful! exactly what I have been looking for. Thanks!
Great to hear!
Simple and effective. Thanks for sharing.
No problem. Thanks for watching.
THanks...very usefull.. i've done make it month by month by your tutorial
Great. Thanks for watching.
This is tutorial I've been looking for. Thanks!
Glad I could help. Thanks for watching.
tq for a great and clear video tutorial, I have subscribed your channel as a way of my appreciation to you
Thanks and welcome
ALL I CAN SAY IS, "I LOVE YOU"
Thank you
best tutorial and really helped a lot, thanks very much sir
Thanks a lot
Thank you for this educative video...can't wait to see more videos
More to come! Thanks
Great explanation ❤
Glad you think so!
Thank you! You solved my problem at work! Great valuable video 👍
Great to hear! Thanks for watching
Loved the way you're so precise about everything. Keep up the good work mate!
+Mobeen Khalid Khawaja Thanks a lot. Please check out my website for more free videos.
Sure mate
Thank you so much for this video, it was very helpful.
No problem. Thanks for watching.
Thank you. Very helpful. God Bless You.
You're welcome! You too!
Thank you so much! that's a fantastic tutorial!! you saved me!!!!
no he did nat
Great tutor 👍👍👍if a little slower much better.
Thanks for the tip
This really was useful. Thank you.
Glad to hear that! Thanks for watching and for the comment
This helped so much thank you!
You're so welcome! Thanks for watching
Thank you for sharing. Very helpful
Thanks!
your voice reminds me an old friend. oh i miss him
F
Thanks, excellent, clear and helpful.
Great to hear! Thanks for watching
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
Science R&D No problem. Thanks for the comment.
Great Tutorials. Very helpful
No problem. Thanks for watching.
Thank you so much Sir. This was really helpful.
So nice of you. Thanks for watching.
You are a star thanks so much
No problem 😊 Thanks for watching
Thanks for sharing this video I found the information very helpful.
No problem. Thank you for watching and for your comment.
thank you sir i learn a lot
It's my pleasure. Thanks for watching.
thank you so much. your video are quite helpful and clear .
Thanks a lot, much appreciated.
Very useful material. Thanks.
No problem. Thanks for watching.
Amazing video. Thank you!
Glad you liked it! Thank you for watching and for taking the time to comment
Thanks Bookkeper! This helped me out a lot:)
It is really helpful. Thank you so much for the video
No problem. Thanks for watching.
Cool - thanks for this tutorial - very clear and useable -
No problem. Thanks for watching.
Fantastic, Thank you very much!
Glad it helped! Thanks for the comment
Very precise and more understandable
Thanks
i have to say this is mind blowing :)
Thanks!
massive help thank you
Thanks!
This is really helpful. Thanks a lot!
No problem, thanks for watching.
This was such a huge help thank you so much!
No problem. I am glad that it was beneficial. Thanks for watching.
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?
Thanks for demo. Much appreciated!
No problem. Thanks for watching.
Immensely clarifying! Excellent work and thanks for the tutorial!
No problem. Thank you for watching and for your kind words.
I appreciate your project is excellent. Thank you very much.
No problem. Thanks for watching.
I am grateful, thank you.
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 😀
I am a typical accountant; boring, in need of glasses, slightly overweight.
Helped me with my uni work, thank you!
+Jo Tierney No problem. Please check out my website for more free accounting videos.
Thank you for this, it was really helpful. Best regards from Croatia!
Thanks. Best regards from England!
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?
You would enter the payments received as 3 months after the invoice sale. I hope this helps. Thanks for watching
well explained. Many thanks
Glad it was helpful! Thanks for watching
Awesome content 🙏
Glad you think so! Thanks for the comment and the sub
Shoo.. This was so helpful. Thank you.
So glad! Thanks for watching and for the comment
do you have a video for daily cash flow forecast? or there's not much difference there?
SO helpful! Thanks.
You're welcome! Thanks for watching.
YOU ARE THE BEST DUDE!
+Milad Chowdhury Thanks, no problem
@bookkeepingmaster I just have a quick doubt: Why you dont add the wages on the money out statement?
Yes you could add wages to money out. This is purely an example. Thanks for watching.
👍 Great video. V helpful
Glad you think so! Thanks for watching
I’m confused from 5:18. When I add numbers to my money in it isn’t automatically populating the months in the opening balance like it did when you put in £500 under owners capital. HELP!
You need to add a formula to take the previous months closing balance.
Thanks for your share, It is wonderful.
No problem. Thanks for watching.
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
Thanks a lot for sharing that. Make a huge difference to me.
No problem. Thanks for watching.
This is amazing, exactly what I need, thanks 🙏
Glad it was helpful! Thanks so much for the comment and for watching
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?
Interest begins the moment you sign the paperwork.
Top Man, Thank you so much
You're welcome! Thanks for watching and for the comment
thanks for your help. Happy I came across this as it's my first business venture. Appreciated :).
Wondering if you can create a cash flow forecast for a small business plan ? Please reply how can I contact you if yes . Thanks
I can but I do charge for my services. Feel free to email me - info@bpfs-online.com. Thanks for watching.
Hello Sir how to you keep the outflow and closing balance increasing when added the overdraft interest?
Great help and nice excel tricks
Thanks a lot
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
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.
hi is the money out supposed to link up with the expense forecast?
thanks
Yes
A bit late but thank you, just one question this is calculating month by month but would it be good if we accumulate monthly net cashes to find out whether we really have a cash flow
I don't understand your question. Please can you explain? Thanks for watching.