How do I use the cash flow worksheet

How do I use the cash flow worksheet

This FAQ will demonstrate the Cash Flow worksheet. The worksheet is designed as a one-time setup tool to assist in the efficient and accurate preparation of the Cash Flow Statement. Unlike other areas of the financial statements, the cash flow statement is prepared using the cash flow worksheet. Cash flow information is not directly derived from the trial balance information and can be manually entered into the worksheet. Any updates made within the cash flow worksheet will flow through to the financial statements. 

The Cash Flow Worksheet:
  • Is easy to use
  • Maps directly to trial balance
  • Allows direct input for line items not in the trial balance
  • Rolls values forward each year
  • Saves time each year
There are 5 steps to complete the Cash Flow Worksheet:

1. Review the cash flows options for the engagement

2. Define the closing cash and cash equivalents

3. Determine the number of analysis items

4. Complete the analysis items

5. Balance the Cash Flow Worksheet


    • Related Articles

    • How to add or remove a Note Reference in the Financial Statements

      To add/remove a note reference in the Statement of the Financial Position: 1. Using your mouse, select anywhere within the Statement of the Financial Position. 2. From the Statements to the Financial Position tab, select Options and tick Note ...

    • How to prepare an 18 Month period Financial Statement

      Prior year: 12 months ending 30 June XXXX Current year: 18 months ending 31 December XXXX  If there is a change in the entity's reporting date like shown above, there are three primary areas to set:  a. CaseWare file Setup b. Leadsheets / Automatic ...

    • How do I Adjust the Print Settings for my Financial Statements?

      The financial statements have both global print settings and print settings for each statement area. To adjust the global print settings, complete the following steps: Click the Document Settings button and select Document Print Settings. The ‘Print ...

    • How to Export the Financial Statements into Microsoft Word

      To export Financial Statements to Microsoft Word, follow the procedure below: 1. Open your Financial Statements. 2. From the File tab, select Export > Rich Text Format. 3. In the File Name enter the name of the RTF file. 4. Click Save.   

    • How do I Sort Content Within the Financial Statements?

      The Document Map provides the ability to navigate around the financial statements, however, it is also used to sort both statement areas and notes to the financial statements. To sort content within the financial statements, complete the following ...