In this video, I’m going to show you how to construct a simple cash flow statement that you can use to keep a running balance of your money coming in and out. It’s based in Excel 2010 but the formulas are the same in all versions.

It’s very useful if you wanted to construct your own version of a bank statement – ideal if you want to do bank reconciliations with it.

 

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/simple_cash_statement.m4v’]

 

 

Here is the file (complete with formulas) for you to download.