Statement of Cash Flows

Cost: Free
System Requirements: Microsoft Excel® 2003 or later*
User Agreement: Read it Here
Creator: SpreadsheetShoppe.com
Statement of CF
File Size: 148 kb
File Type: xls
Download File
+1 This Page
Picture
Description: The preparation of the statement of cash flows can be a time consuming task.  Schedules become messy and cluttered as the schedule grows in length or complex transactions are introduced.  This clutter often times 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 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.  


This statement of cash flows template includes the following features designed to increase efficiency and enhance professionalism:
  • Automatic alternating row highlighting
  • Dynamic formulas utilizing the offset function 
  • Example date so you can see how the template works
  • 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.
  • 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:
Picture
  • Setup to print on a single page; print settings may need to be adjusted if data is added.
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 common 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.  
Picture
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. 
blog comments powered by Disqus

Other Useful Tools & Excel Templates
Question or comments?  Reach us Here

* Note, utilizing the features of this excel template requires Microsoft Excel® 2007 or later - some of the attributes such as the graded shading, tables, or 3-D formatting are not compatible with earlier versions.