How to Create a Cash Flow Forecast (in under 20 minutes) {FREE TEMPLATE}

No video

How to Create a Cash Flow Forecast (in under 20 minutes) {FREE TEMPLATE}

Рет қаралды 62,939

Жыл бұрын

Get your FREE cashflow template here: claracfo.com/cashflow
Predicting cash flow (aka forecasting cash flow) is one of the most critical tasks any small business owner can do to help their financial stability.
A good cash flow forecast can help you make decisions, plan ahead for cash shortfalls, scenario plan, and identify financial problems with enough time to make changes!
Update your cash flow forecast at least monthly for best results!
To learn more about CFO services, go to: claracfo.com/cfo-services/
💲 Need an accounting system? We use Quickbooks Online with clients and recommend it as the best accounting system for small businesses. Sign up to get a discounted subscription for 12 months! claracfo.com/QBO
🙋‍♀‍Got Employees? Talk to ADP! They can help you if you are a small business owner or an accountant or advisor who works with small businesses. Learn more here: claracfo.com/adprun
💸Pay vendors any way they want and get paid faster! Accept credit cards without paying merchant fees! Melio is a fantastic payments solution for every small business! claracfo.com/melio
(As an affiliate or referral partner for these companies, I may earn rewards from qualifying purchases)
Hannah Smolinski is a #CPA and the Founder of Clara CFO Group. Find out more about Clara CFO Group at claracfo.com/
Disclaimer: This video is intended for educational purposes and
should not be taken as legal or tax advice. You should consult with your financial professionals about your unique financial situation before acting on anything discussed in these videos. Clara CFO Group, LLC is providing educational content to help small business owners become more aware of certain issues and topics, but we cannot give blanket advice to a broad audience.
CODE: ASGWZCEHOXFNBQYQ, YCJYEEHMQPU1FEOO

Пікірлер: 56

@KuboConsulting 12 күн бұрын

This is a well explained cashflow forcast! Downloaded the file. I will review all the videos.!!

@ClaraCFO 10 күн бұрын

great!

@user-vd3ij5dc6l 3 күн бұрын

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!

@aislinnmarcantelli1650 7 ай бұрын

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!

@rafaelvillalobos9145 7 ай бұрын

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.

@yinggao4885 2 ай бұрын

Extremely helpful videos❤, Hannah you are my mentor, definitely will stay tuned for all your videos!

@annehui7492 2 ай бұрын

Great easy to follow video for me. Your voice is nice to listen to. Appreciate the help.

@valv5993 2 ай бұрын

THIS IS GREAT! Thank you!

@mrwah1271 9 ай бұрын

just what I needed right now, concise and well-explained. Subscribed!

@ClaraCFO 9 ай бұрын

Welcome aboard!

@dw1784 Жыл бұрын

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!

@Amigoampang 10 ай бұрын

Agreed, well done Clara. We will certainty take some program from you some time soon to support you service -Amigo/Saudi

@alonzolopez6264 Жыл бұрын

Hannah your the BEST. THANK YOU AND HAVE A GREAT WEEKEND

@ClaraCFO Жыл бұрын

Thanks Alonzo! Happy 4th!

@crazyfarmboys8421 7 ай бұрын

Very helpful

@luqmansuhazeli6630 Жыл бұрын

Tq Soo much . I am 16. a form 4. student of accounting.

@elisantiago7297 7 ай бұрын

Great presentation and I will recommend you to business in my network.

@jennabantjes3077 Ай бұрын

Thank you for this! You may have saved our business (and my marriage)

@basbijl 10 ай бұрын

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?

@osamashah1 8 ай бұрын

So beautifully explained as beautiful you are. Love you. Keep it up.

@ali.s227 5 ай бұрын

Really appreciate your work

@ClaraCFO 5 ай бұрын

thanks for being here!

@zekk9 10 күн бұрын

Thanks !

@user-jt2me6gp4g 9 ай бұрын

Thanks, this was very handy and educational...

@ClaraCFO 9 ай бұрын

So glad!

@unitedrecycling Жыл бұрын

Thank you, beautiful lady! Always a treat to listen and watch your work.

@ClaraCFO Жыл бұрын

Thanks for being here! Hope it's helpful!

@MasterYourBooks Жыл бұрын

Great video & tool!

@ClaraCFO Жыл бұрын

Thanks!

@HeatherLittleton-k7l 2 күн бұрын

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

@vishalchopra551 2 ай бұрын

Hi Clara one Question how can we adjust it for in a big organizations where weekly payrolls and the working capital changes gets involved

@gfernie4 6 ай бұрын

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!

@billyhofacker1701 8 күн бұрын

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.

@grantwilson3105 Жыл бұрын

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.

@ClaraCFO Жыл бұрын

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.

@grantwilson3105 Жыл бұрын

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

@isabrinah 9 ай бұрын

Does any one have a finished example version of this?

@MasterYourBooks Жыл бұрын

Many smbs get confused between cash flow forecast & budget & the importance of both..do u have a video comparing the 2.

@ClaraCFO Жыл бұрын

I don't, but I think we will get more into budgeting in Q4 as it aligns with our internal initiatives.

@ClaraCFO 9 ай бұрын

Here is our budgeting video! be sure to check out the next videos because we compare a forecast and a budget - kzfaq.info/get/bejne/oLFkd5R7yrqamXk.html

@MasterYourBooks 9 ай бұрын

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

@scotolivera8207 Жыл бұрын

I have read the simple numbers book , and i have searched the channel for another great book recommendation but couldn’t find find it

@ClaraCFO Жыл бұрын

what kind of book recommendation would you like? We have 9 great book recommendations on our shorts if you want to check those out!

@munyanezagodfrey513 2 ай бұрын

Please reshare the free template, thank you

@lvrodas23 6 ай бұрын

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.

@nazcpatax Жыл бұрын

when are you planning to start your cfo course?

@ClaraCFO Жыл бұрын

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.

@evidencechinaemenma7005 7 ай бұрын

@@ClaraCFO Kindly share the course ideas. Thank you

@naveenkgeorge2000 Жыл бұрын

Hannah can you do a video regarding Budgeting

@ClaraCFO Жыл бұрын

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

@ClaraCFO 9 ай бұрын

Here ya go! kzfaq.info/get/bejne/oLFkd5R7yrqamXk.html

@naveenkgeorge2000 Жыл бұрын

Can we consider this as a rolling forecast

@ClaraCFO Жыл бұрын

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.