How to Create a Cash Flow Forecast (in under 20 minutes) {FREE TEMPLATE}
Вставка
- Опубліковано 28 чер 2023
- 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
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!
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.
just what I needed right now, concise and well-explained. Subscribed!
Welcome aboard!
Extremely helpful videos❤, Hannah you are my mentor, definitely will stay tuned for all your videos!
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
Hannah your the BEST. THANK YOU AND HAVE A GREAT WEEKEND
Thanks Alonzo! Happy 4th!
Great easy to follow video for me. Your voice is nice to listen to. Appreciate the help.
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?
So beautifully explained as beautiful you are. Love you. Keep it up.
THIS IS GREAT! Thank you!
Thank you, beautiful lady! Always a treat to listen and watch your work.
Thanks for being here! Hope it's helpful!
Really appreciate your work
thanks for being here!
Great video & tool!
Thanks!
Thanks, this was very handy and educational...
So glad!
Great presentation and I will recommend you to business in my network.
Very helpful
Tq Soo much . I am 16. a form 4. student of accounting.
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.
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 - ua-cam.com/video/jK4D1JeT6iE/v-deo.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 Clara one Question how can we adjust it for in a big organizations where weekly payrolls and the working capital changes gets involved
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!
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!
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
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.
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! ua-cam.com/video/jK4D1JeT6iE/v-deo.html
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.
Please reshare the free template, thank you
Why did you take material and labor in revenue? These are expenses
जय श्री राम🙏🙏🙏🙏
'Promo sm' 🌹