Create a simple cashflow forecast tool using Excel and Xero’s Cash Summary report (2:56)
Read more about How To's
15 comments
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.
Bree
Absolutley, very informative and usefull bet he moves along way too fast.
Peter
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.
Owen
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
Peter Venero
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.
Heidi
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
Rocky Douché
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?
Robert Flunder
Surely the cashflow forecast has to be automatically generated from the P&L forecast or it is pointless?
Richard Graham
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).
Paul Zisson
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.
Dylan
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.
Good video but a little too fast to actually follow. You’ll need to keep pausing to catch up with him