Create a simple cashflow forecast tool using Excel and Xero’s Cash Summary report (2:56)
Read more about
Good video but a little too fast to actually follow. You’ll need to keep pausing to catch up with him
I agree entirely..really whizzes along. Great but is definitely too fast! Sounds like it it is done by someone who really knows it and uses it so often that it is just sort of an aside!
Love Xero although only new to it. These sort of videos really make a difference and are very useful.
Absolutley, very informative and usefull bet he moves along way too fast.
I found it too fast and wasn’t sure what was going on, and gave up, went back to my personal excel method. Thanks for trying to assist tho.
Very informative but he was speaking fast. A pause between stops would be nice. Still a big fan of Xero.
As the life blood of any business I am suprised that cash flow isn’t a standard report that can be managed and reported on from within Xero. Please look into this for the next release
LOL This is horrendous. Nothing simple or quick about this. I will continue to use pulseapp.com and hope that you guys can implement an actual simple cash flow tool.
I am so confused by this. Not only is it too fast but really confusing. Hope this can be an easy add on to Xero please
Its commonly believed that cashflow forecasting is one of the most important tools for SME’s. (try getting a loan from a Bank without one!)
Spotlight at an extra $87 per month is not a financially viable bolt on.
Xero has been promising an intergrated one for a long time. Where is it now at? What is the release date?
Surely the cashflow forecast has to be automatically generated from the P&L forecast or it is pointless?
This is actually quite easy to follow…the presenter has simply averaged the previous years actual cashflow across the following years comparative months and called it a “cashflow projection”…a little simplistic given no two years will be the same and ignores ad hoc expenses that would need to be adjusted for. Still a big fan of Xero tho!
Hi Rocky – Spotlight Forecasting is available at $19 per month from 31 Jan. (the $87 per month you refer to is an Advisor 6-org pack).
A Casf flow forecast is a vital tool for any business and used frequently in any finance system. Why is it not a standard report within Xero? Cash is king in a small business, this is a decisionl maker tool for owners. The vid is great, too fast as everyone says, funny kiwi accent, but alot of mucking around to get there.
Good basic cash flow summary of previous period although needs to be adjusted for projections of the current year income and expenses. Far too fast for most people and confusing for clients who don’t understand what this report is actually doing. Also noted that he has the opening and closing balance formula the wrong way round which I hope has not caused some incorrect reports being produced!
I see – the opening closing balances are correct, the date order is changed around at the end of the vid. He should probably do this at the start to avoid confusion.
Great video – thanks a lot
For the record – the speed isn’t an issue for me!
I’m pleased to announce that we’re just about to launch our cash flow forecasting application – Float for Xero.
Float pulls all this information out automatically, and will save you the hassle of doing the above.
The beta invites will begin to be rolled out over the next few weeks – if you’re interested sign up and we’ll be in touch.
I am new to Xero and Excel, and found this waaaaaaay too fast, but once I paused it heaps of times I was able to figure it out without too much difficulty.
Richard Graham’s comment above is smack on. I would go further in stating that it is no point doing a cash flow forecast if it is based on averages of last year, unless it is for a business that buys and sells the same quantity of items at the same price, to an unchanging market in an unchanging industry.
Can Zero suggest any other methods including useful add-ons that we can use to properly forecast cash flows?
Hi Colin, really awaiting the launch of Float for Xero. Will it be in my Christmas stocking???
@Bill Christmas came early http://blog.xero.com/2013/10/cashflow-forecasting-budgeting-float/
Email address (will not be shown)
We welcome all feedback but prefer a real name and email address.