Thank you for your tutorial. I am not running a business. I am going to use this cash flow template to forecast my elderly parent's cash flow now that they have moved into assisted living. I wanted something simple to create and also easy to understand for my parent and siblings. I am so glad that I took the time to watch your video.
Thank you for helping me to understand what cash flow really is and how to implement cash flow tracking using a workbook. I had been struggling for days trying to grasp the concept, and finally understood what it is thanks to this video and studying the sample workbook. I'm going to drive for Uber, so of course I made my own workbook after studying yours.
Wow, thank you so much! Trying to keep the books for our small business and numbers are just not my thing. This was so helpful, understanding what a cash flow is and how to use one, I plan to implement it as part of my weekly routine to hopefully get us on track a bit more and expand my knowledge as s small business owner. Thank you so, so so much!
This is a good explanation. However I would argue this should be daily rather than monthly. It was the first thing I updated every morning after downloading the bank balances.
Hmm - curious why you would need daily? I think it would be hard to keep track of daily cash flow in excel because of the detail needed. It could get very tedious.
@@ClaraCFO I set up the cashflow spreadsheet looking 6 months into the future. Put in all loan repayments, wages estimates, creditors estimates, payroll estimates etc. Then update it each day. I did this for 3 or 4 companies over 10 years and never ran out of cash.
Thanks, great video, curious to know how now to adjust it to cater to receiving sales payments within 60 days, do I need to shift the revenue cells to the right?
Thank you very much for the video and presentation. However, I believe this template is somewhat basic and may be more suitable for very small businesses. I noticed that it does not include any sections on working capital investment or scenario options related to changes in DSO, DIO, or DPO. We understand that the main difference between EBITDA and operating cash flow is the investment in working capital. Therefore, without forecasting working capital investments, it’s not possible to accurately forecast cash flows. Additionally, working capital investment is influenced by the company's revenue growth as well as changes in DSO, DIO, and DPO. If these scenario options are added to the template, it would significantly enhance its effectiveness as a tool for forecasting cash flows. Thanks again for the template and the video!
Thank you very much. This was a great video! I have watched a few so far and haven't been satisfied that I received the information that I am looking for until I watched this one. Great explanations! I am going to subscribe!
Thank you for your video, really helpful :) I understand including all outflows to the spreadsheet because a lot of them are fixed (the same every month) so we can always account for those type of outflows as a way to project future expenses and how that impacts cash flow. I have a hard time figuring how to include AR as inflows on cash flow as a general contractor, we have payment terms that we need to deal with and consider but how can we incorporate AR into cash flow given that we may not know when exactly that cash will be coming in? also, we have AP vendors to pay of which most are paid once we are paid.. how do we incorporate AP costs to cash flow when paying these vendors is dependent on our payment? I guess in summary, my questions are around including AP/AP sources to cash flow given that they are not fixed or date specific. Does anyone have a template or system they use in the construction industry? We are a small business. Thanks!
Very well put together. Explains cashflow in easy layman terms. Thanks 🙂 I cant download the template. I enter my email, but the continue button remains disabled. Please help.
Here is our budgeting video! be sure to check out the next videos because we compare a forecast and a budget - ruclips.net/video/jK4D1JeT6iE/видео.html
@ClaraCFO thats going to be an AWESOME topic as many SMBs confuse one over the other. Excited to see your explanation of budget vs forecast. Excellent topic!
Hi Hannah, can you help please... firstly thank you for sharing such in depth videos and providing this template! What I'd like to know is when using the data from my P&L and Balance sheet, does this need to be downloaded as the 'accrual' or 'cash' basis? We are an accrual based business
I'll be working on one! We have a profit planning workshop that goes through the budgeting process here if you don't want to wait: learn.claracfo.com/profit-planning-workshop-reach-your-goals-in-2022?coupon=OVNQ5SG
I apologize if you said this and I missed it but I’m assuming this is an active sheet where you update each month as needed. If reality is different (significantly) than the forecast for a short period, do you just update it in real time? For example, if revenue is 5K less one month than expected for a small biz, just adjust and keep going? If not the rest will be off. It sounds obvious but I think I just need that affirmation! Thanks for the awesome content.
Hi there! Love your videos! I had a question about creating the spreadsheet. When you have a few checking accounts and credit cards, are you focusing on just ONE main checking account for the spreadsheet or are you finding your combined beginning cash balance across all banks? I'm getting a bit confused on whether this spreadsheet should include EVERYTHING in my bookkeeping or if we just want to follow the cash for our main checking account and only include revenues/expenses/cc payments/etc. that hit that account? Thank you so much!!!
Great question - I would include all your cash accounts that are used for operations. I'd recommend excluding savings accounts that you don't want to think about in your operating cash budget. For example, I might exclude my Long-term rainy day savings and my tax savings accounts from the cash flow forecast because I don't want the false sense that I have enough money when that money is not meant to be touched unless it's used for specific purposes. Then any additions I make to those accounts goes in the "cash out" section of the cash flow forecast.
@@ClaraCFO Okay this is helpful! Let's say a business had two checking accounts, a cc, a savings, and a PayPal (business), would you essentially total the beginning balance for the two checking accounts and PayPal only? And the cc payments and savings transfers would go in the cash out section?
@@ClaraCFO she more financial planning for the home and you’re focused on the business. I’m sure there’s a collab there somehow. You both have helped me so much so I’d hope a collab would help you both grow.
The formulas are not working. I downloaded the template, changed my expense titles and revenue titles, started plugging numbers and it is only taking account of what I put on the first line of my expense and cash at beginning of period; that is the only math that is working, none of the other cells are computing but it does show they have formulas plugged in.
Thank you for your tutorial. I am not running a business. I am going to use this cash flow template to forecast my elderly parent's cash flow now that they have moved into assisted living. I wanted something simple to create and also easy to understand for my parent and siblings. I am so glad that I took the time to watch your video.
Tq Soo much . I am 16. a form 4. student of accounting.
Thank you for helping me to understand what cash flow really is and how to implement cash flow tracking using a workbook. I had been struggling for days trying to grasp the concept, and finally understood what it is thanks to this video and studying the sample workbook. I'm going to drive for Uber, so of course I made my own workbook after studying yours.
Wow, thank you so much! Trying to keep the books for our small business and numbers are just not my thing. This was so helpful, understanding what a cash flow is and how to use one, I plan to implement it as part of my weekly routine to hopefully get us on track a bit more and expand my knowledge as s small business owner. Thank you so, so so much!
Great easy to follow video for me. Your voice is nice to listen to. Appreciate the help.
Great presentation and I will recommend you to business in my network.
Great video! How would you recommend to incorporate a budget spreadsheet with the cash flow forecast?
This is a good explanation. However I would argue this should be daily rather than monthly. It was the first thing I updated every morning after downloading the bank balances.
Hmm - curious why you would need daily? I think it would be hard to keep track of daily cash flow in excel because of the detail needed. It could get very tedious.
@@ClaraCFO I set up the cashflow spreadsheet looking 6 months into the future. Put in all loan repayments, wages estimates, creditors estimates, payroll estimates etc. Then update it each day. I did this for 3 or 4 companies over 10 years and never ran out of cash.
Hannah your the BEST. THANK YOU AND HAVE A GREAT WEEKEND
Thanks Alonzo! Happy 4th!
Thank you for this! You may have saved our business (and my marriage)
Thanks, great video, curious to know how now to adjust it to cater to receiving sales payments within 60 days, do I need to shift the revenue cells to the right?
just what I needed right now, concise and well-explained. Subscribed!
Welcome aboard!
Thanks, this was very handy and educational...
So glad!
This is a well explained cashflow forcast! Downloaded the file. I will review all the videos.!!
great!
Hi Clara , very helpful. Thank you
when are you planning to start your cfo course?
Ha - you mean how to be a CFO? I have some course ideas, but I want to know what's going to be the most helpful for people first.
@@ClaraCFO Kindly share the course ideas. Thank you
Extremely helpful videos❤, Hannah you are my mentor, definitely will stay tuned for all your videos!
Really appreciate your work
thanks for being here!
Thank you very much for the video and presentation. However, I believe this template is somewhat basic and may be more suitable for very small businesses. I noticed that it does not include any sections on working capital investment or scenario options related to changes in DSO, DIO, or DPO.
We understand that the main difference between EBITDA and operating cash flow is the investment in working capital. Therefore, without forecasting working capital investments, it’s not possible to accurately forecast cash flows. Additionally, working capital investment is influenced by the company's revenue growth as well as changes in DSO, DIO, and DPO.
If these scenario options are added to the template, it would significantly enhance its effectiveness as a tool for forecasting cash flows. Thanks again for the template and the video!
Thank you very much. This was a great video! I have watched a few so far and haven't been satisfied that I received the information that I am looking for until I watched this one. Great explanations! I am going to subscribe!
Agreed, well done Clara. We will certainty take some program from you some time soon to support you service -Amigo/Saudi
Thank you for your video, really helpful :) I understand including all outflows to the spreadsheet because a lot of them are fixed (the same every month) so we can always account for those type of outflows as a way to project future expenses and how that impacts cash flow. I have a hard time figuring how to include AR as inflows on cash flow as a general contractor, we have payment terms that we need to deal with and consider but how can we incorporate AR into cash flow given that we may not know when exactly that cash will be coming in? also, we have AP vendors to pay of which most are paid once we are paid.. how do we incorporate AP costs to cash flow when paying these vendors is dependent on our payment? I guess in summary, my questions are around including AP/AP sources to cash flow given that they are not fixed or date specific. Does anyone have a template or system they use in the construction industry? We are a small business. Thanks!
Very well put together. Explains cashflow in easy layman terms. Thanks 🙂
I cant download the template. I enter my email, but the continue button remains disabled. Please help.
Email us at hello @ Claracfo.com (no spaces) and we can email it to you.
Thank you, beautiful lady! Always a treat to listen and watch your work.
Thanks for being here! Hope it's helpful!
Many smbs get confused between cash flow forecast & budget & the importance of both..do u have a video comparing the 2.
I don't, but I think we will get more into budgeting in Q4 as it aligns with our internal initiatives.
Here is our budgeting video! be sure to check out the next videos because we compare a forecast and a budget - ruclips.net/video/jK4D1JeT6iE/видео.html
@ClaraCFO thats going to be an AWESOME topic as many SMBs confuse one over the other. Excited to see your explanation of budget vs forecast. Excellent topic!
THIS IS GREAT! Thank you!
So beautifully explained as beautiful you are. Love you. Keep it up.
Hi Clara one Question how can we adjust it for in a big organizations where weekly payrolls and the working capital changes gets involved
Very helpful
Hi Hannah, can you help please... firstly thank you for sharing such in depth videos and providing this template! What I'd like to know is when using the data from my P&L and Balance sheet, does this need to be downloaded as the 'accrual' or 'cash' basis? We are an accrual based business
Hannah can you do a video regarding Budgeting
I'll be working on one! We have a profit planning workshop that goes through the budgeting process here if you don't want to wait: learn.claracfo.com/profit-planning-workshop-reach-your-goals-in-2022?coupon=OVNQ5SG
Here ya go! ruclips.net/video/jK4D1JeT6iE/видео.html
I apologize if you said this and I missed it but I’m assuming this is an active sheet where you update each month as needed. If reality is different (significantly) than the forecast for a short period, do you just update it in real time? For example, if revenue is 5K less one month than expected for a small biz, just adjust and keep going? If not the rest will be off. It sounds obvious but I think I just need that affirmation! Thanks for the awesome content.
Hi there! Love your videos! I had a question about creating the spreadsheet. When you have a few checking accounts and credit cards, are you focusing on just ONE main checking account for the spreadsheet or are you finding your combined beginning cash balance across all banks? I'm getting a bit confused on whether this spreadsheet should include EVERYTHING in my bookkeeping or if we just want to follow the cash for our main checking account and only include revenues/expenses/cc payments/etc. that hit that account? Thank you so much!!!
Great question - I would include all your cash accounts that are used for operations. I'd recommend excluding savings accounts that you don't want to think about in your operating cash budget. For example, I might exclude my Long-term rainy day savings and my tax savings accounts from the cash flow forecast because I don't want the false sense that I have enough money when that money is not meant to be touched unless it's used for specific purposes. Then any additions I make to those accounts goes in the "cash out" section of the cash flow forecast.
@@ClaraCFO Okay this is helpful! Let's say a business had two checking accounts, a cc, a savings, and a PayPal (business), would you essentially total the beginning balance for the two checking accounts and PayPal only? And the cc payments and savings transfers would go in the cash out section?
@@rachelburke2552 Correct! You've got this!
Great video & tool!
Thanks!
Hi, Thanks for the video. Could you check the spreadsheet again, because the link to download the file on the website is inactive. thanks again.
This is active now: learn.claracfo.com/cash-flow-forecast
Thanks !
Can we consider this as a rolling forecast
This is a rolling cash forecast. It isn't a rolling P&L forecast. I think it matters what you are trying to forecast to answer that question.
I have read the simple numbers book , and i have searched the channel for another great book recommendation but couldn’t find find it
what kind of book recommendation would you like? We have 9 great book recommendations on our shorts if you want to check those out!
Unfortunately I cannot download the cashflow excel. It states Im blocked off
Please reshare the free template, thank you
You and budget mom should collab.
I don't know who that is actually! I will have to look her up!
@@ClaraCFO she more financial planning for the home and you’re focused on the business. I’m sure there’s a collab there somehow. You both have helped me so much so I’d hope a collab would help you both grow.
Does any one have a finished example version of this?
The formulas are not working. I downloaded the template, changed my expense titles and revenue titles, started plugging numbers and it is only taking account of what I put on the first line of my expense and cash at beginning of period; that is the only math that is working, none of the other cells are computing but it does show they have formulas plugged in.
Why did you take material and labor in revenue? These are expenses
जय श्री राम🙏🙏🙏🙏
'Promo sm' 🌹