The preparation of the statement of cash flows (indirect method) can be a time-consuming task.  Schedules become messy and cluttered as the schedule grows in length or complex transactions are introduced.  This clutter oftentimes leads to unnecessary time, wasted energy, and the occasional error.  The purpose of this template is to help those responsible for preparing a statement of cash flow to create one that is easy to follow, professional in appearance, and should also help in identifying errors common in formulas.  This spreadsheet will not ensure your statement is error free – it is your responsibility to identify the appropriate classification, keep track of non-cash items, and to ensure the amounts are accurate.

Statement of Cash Flows Template

System Requirements & Download

This statement of cash flows template includes the following features designed to increase efficiency and enhance professionalism.

Example data is included within this template so it’s easy to see just how the spreadsheet works.  Two types of conditional formatting 1) Conditional formatting for data entry – notice at the top of the picture above, the pink highlights.  This is data that must be completed.  Once the date is entered in the title section, the remaining dates are automatically calculated. 2) Conditional formatting for certain summations – balances that don’t balance but should, are a common error that can occur in a spreadsheet like this.  When totals that should balance, but don’t, arise in this excel template, the cells turn bright red.  See example below:

• Decrease Cash Flow Statement preparation time.
• Improve accuracy.
• Improve usability.
• Learn how to alternate row highlighting.
• Link this statement to your balance sheet.
• Learn how to use dynamic formulas with the offset function.
• Set up to print to a single page.

Supplemental cash flow disclosures

The following section has been added to the bottom of the statement of cash flows in order to identify some more commonly required disclosures. These disclosures can be within the statement or within the notes to the financial statements. As with the statement of cash flows, this listing is not intended to apply to all circumstances. Necessary disclosures may not be included in this list.

Note: Remember, the data included in this statement of cash flows is example data only.  There could be items included that are not relevant to your financial statements, or items missing that require disclosure within your statements.

On October 26, 2015   /   Accounting, Analysis, Audit, Business Tools, Downloads, Financial Statements