Skip to content

Create a simple cashflow forecast tool using Excel and Xero’s Cash Summary report (2:56)

 

Read more about How To's

 

21 comments

Rad Dougall
1 November 2011 #

Good video but a little too fast to actually follow. You’ll need to keep pausing to catch up with him

Lily Gardner
3 January 2012 #

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
21 April 2012 #

Absolutley, very informative and usefull bet he moves along way too fast.

Peter
29 April 2012 #

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
4 May 2012 #

Very informative but he was speaking fast. A pause between stops would be nice. Still a big fan of Xero.

Chris
31 May 2012 #

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
24 June 2012 #

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
6 August 2012 #

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é
10 August 2012 #

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
21 December 2012 #

Surely the cashflow forecast has to be automatically generated from the P&L forecast or it is pointless?

Richard Graham
18 January 2013 #

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!

Richard Francis
22 January 2013 #

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
14 March 2013 #

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
23 April 2013 #

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!

Dylan
23 April 2013 #

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.

Tim
24 May 2013 #

Great video – thanks a lot

For the record – the speed isn’t an issue for me!

Colin Hewitt
19 June 2013 #

Hi guys.
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.

Laura
4 July 2013 #

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.

Mark H
12 July 2013 #

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?

Bill Shaw
12 November 2013 #

Hi Colin, really awaiting the launch of Float for Xero. Will it be in my Christmas stocking???

Add your comment





We welcome all feedback but prefer a real name and email address.