CASH FLOW SPREADSHEET - Create it in 7 minutes [Excel Template]

I would like to show you how to create a simple Cash Flow Spreadsheet that is great for forecasting and monitoring your business or personal cash flows.
You probably don't like complicated formulas and you probably don't want to spend hours designing your own.
So this cash flow forecasting spreadsheet template should be ideal for you.
This simple worksheet contains both Cash Inflows and Cash Outflows and calculates your Net Cash Flow.
The Cash Flow spreadsheet can be used for weekly, monthly or even yearly forecasts.
If after watching the video you would like a copy of our Free Cash Flow Spreadsheet, then please help us by visiting and subscribing to one of our social media channels.
We will the send you a copy of the completed file.
Our Social Media channels are:
On Facebook - Like at Mr.Spreadsheet
On Instagram - Follow @MrSpreadsheet
On Twitter - Follow @Mr_Spreadsheet

Thank you for watching and subscribing.

[ashk]

The best a simplest example I've found any where, explained very well, I can now build out something very personal, rather than confusing templates that I can't understand or relate to thank you

[zulidzhar]

A big thanks to you, sir. I've just started my business during this pandemic and having this video as reference for the filing is really helpful. Cheers

[siangtze]

This is very useful for me. Thank you so much for explaining in details as i have spend many days to figure out from many complicated website. Thank you Sir

[asimsiddiq]

Please accept our thanks for a great presentation.

[n.j.products]

You made my year in 7 minutes Thank you

[matttring]

Really easy to follow and helpful, thank you!

[jamesperry]

*I was looking out for this today n found it. Fantastic! Thank you.*

[Jane-knrj]

Hi, I am from Brazil. Thank you for this vídeo.

[Weightlosscoach]

Excellent, thank you for sharing this

[Freedom-sgbs]

Your videos are awesome thanks so much

[rickgarcia]

Great video, solid content, thank you!

[iecivil]

Thanks for sharing, it is really simple to forecast & plan for cash flow

[syedmuzammil]

Hi in my ecxel -1234.10 is not showing 04:47
how to create it

[metinatakan]

Really good . Thank you, i followed and it worked . Can we turn the info into graphs and charts etc.

[NoOne-cfji]

If you purchase land at the start of the project would this be a relevant cash flow ?

[shlin]

I don't understand. The number that you record "inflow 1, inflow 2..." Is a summary for each month or each transaction?.

Accounting spreadsheet, i see it being recorded for daily & each transaction.

What makes a difference between cash flow &Accounting spreadsheet ?hope can advise me.

TQ

[quintoncarroll]

When I hear the term forecasting I think of predicting. Is this model predicting future values?

[luizdunne]

thank you for this its awesome. could I get a copy please?

[pthdxe]

Great video, thanks for your sharing. Can you share your file for practice?

[bibtbahamas]

Great video but with one confusion for me; I think the opening balance is added to the net flows in order to get the closing balance. Please confirm if this is correct. The video said to subtract.