(or why you should always keep an eye on your money)!
1. Download the above spreadsheet from Google Drive
2. Fill in row 8 (Total Receipts) by adding up all 'inflows' for each month
1. Add up your 'outflows' for each month
Work it all out!
1. In the 'Net Cash Flow' row, take 'total payments' away from 'total receipts' for that month
2. 'Opening balance' is basically the 'closing balance' from the previous month
3. Closing balance will be 'net cash flow' added to 'opening balance'!