3 Easy steps to help you complete a cash flow template

In order to correctly show the movement and management of cash within a business, accountants use a cash flow statement. This statement will display a business’s money coming in from ‘cash receipts’ and where it has paid money out, ‘cash paid’. The cash flow statement is a standard financial statement and is frequently used in conjunction with the balance sheet and income statement.

As a result, the cash flow statement plays an important part in the management of finances for the company. In this week’s tip, we share a basic cash flow statement template that you can download, customize and use.

You are welcome to download the workbook here.

Applies to Microsoft Excel 2010, 2013 and 2016.

1. To enter values for the beginning of the period, enter values in row 6 for their respective months.

1_Excel on steroids tips and tricks

2. The cash receipts can be entered in rows 9 to 11.

2_Excel on steroids tips and tricks

3. Cash paid out values are entered in rows 16 to 44.

3_Excel on steroids tips and tricks

By entering these values for the respective period, your statement will showcase the cash movements, and can therefore be better analyzed.