TAX & ACCOUNTING
Creating a Cash Flow statement Important reminder! Licenses for Payroll CS, Trial Balance CS, and Write-Up CS (but not Engagement CS) permanently expired on March 1, 2017. For details, see CSA license expiration 2017 – frequently asked questions. Some processes documented in the Help & How-To Center are no longer applicable, due to the discontinuation of these CSA modules. Creative Solutions Accounting Engagement CS enables you to create cash flow statements in Microsoft Excel based on information that is linked directly to your client's trial balance data in Creative Solutions Accounting. You can customize your Cash Flow lines and transfer them from one engagement client to another from Engagement CS. The Create Workpaper wizard allows you to select an indirect or direct cash flow workpaper that are classified according to the FASB standard of operating, investing, and financing activities. Prior to creating a Cash Flow Statement, amounts have to be analyzed in the Cash Flow Worksheet. For more information on the Cash Flow Worksheet, refer to K62281531. The process of creating a cash flow statement is the same as the process for inserting any other type of document in the engagement. 1. In the engagement client, highlight the folder where you wish to create the cash flow statement. 2. Choose File > New > Document, right-click and choose Insert New Document, or press CTRL+N to open the Insert Engagement Document wizard. 3. Mark the Custom Excel workpaper or cash flow statement option from the Excel / Word tab and click the Continue button to open the Create Workpaper Wizard. 4. Mark the Indirect or Direct statement of cash flows option and click the Next button. Note: If you have not setup either the indirect or direct cash flow worksheet, the option is not available (grayed). Also, you must be in the latest period for this option to be available. 5. In the Create Workpaper Wizard dialog define the columns for the cash flow statement and click the Next button.
6. The New Engagement Document - Properties dialog opens. Document name - Enter the name of the document. This is the name Engagement CS will use to reference this document Workpaper reference (required) - Enter a workpaper reference. Workpaper references must be unique within a single engagement. Assign responsibility - From the drop-down list, assign responsibility for this document to a staff member. You can also choose Unassigned. Treatment for Roll Forward - Select the roll forward treatment of this workpaper from the drop-down list. Exclude - (default option) If this option is selected, the workpaper will not be included in the next period's engagement, but will still remain in the original engagement. Note: You can choose to override the command to exclude the workpaper from the new engagement created during the roll forward process in the Roll Forward Wizard and Wrap Up Wizard. Include - If this option is selected, the workpaper will be wrapped up and included in both the final engagement and in the new engagement created during the roll forward process. Replace from PPC Template - Workpapers are replaced with a PPC Practice Aid from an available title. Replace from selected engagement - Workpapers are replaced with another document in a selected engagement client on the Select Template Engagement page of the Roll Forward wizard when this option is selected. Delete during Wrap-Up - Mark this checkbox if you want the program to delete this workpaper during the wrap up process. If you select Include or Replace from the Roll Forward drop-down list, this checkbox will be unavailable (grayed out) and does not apply. Note: The Workpaper Removal page of the Wrap Up Wizard will not appear during the wrap up process if the Deleted during Wrap Up checkbox has been left unmarked for all workpapers in the engagement. 7. Click Finish to insert the document into the current engagement. Note: When the Excel Cash Flow Statement is created, all cash flow lines are included in the Excel workbook. The Hide/Show Zero Balance Rows function available from the Engagement CS drop-down menu can be used to suppress the rows with zero balances.