Creating a Cash Flow statement









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.


Creating a Cash Flow statement

REGIONS PRODUCT LOGINS CONTACT YOUR ACCOUNTS MY CART SEARCH TAX & ACCOUNTING Creating a Cash Flow statement Important reminder! Licenses f...

220KB Sizes 2 Downloads 7 Views

Recommend Documents

Cash Flow Statement - How a Statement of Cash Flow Works
The cash flow statement is commonly presented using the indirect method. It starts with net income or loss, followed by

Creating Financial Statements: How to Prepare a Cash Flow Statement
Cash flow in your business is like the waves of an ocean, with revenue washing in and payments for expenses flowing out.

Creating a Forecasted Cash Flow Statement using Examples
Therefore, a forecasted cash flow statement is constructed to determine if an entrepreneur's business will have enough c

What is Cash Flow? Use a Sample Cash Flow Statement
A cash flow example or sample cash flow statement can help you understand how to handle your cash flow calculation. ...

The cash flow statement
For questions 1 to 10, read the text and decide which answer, A, B or C, best fits each gap. An example (0) has been don

This Standard establishes a procedure of preparing a cash flow statement, classifying cash flows into ... example, when

Cash Flow Statement -
Cash flows from operating activities. Net income, 14,227 · 6,782 · 49,640 · 49,661 · 45,117. Adjustments to reconcile ne

Cash Flow 101: Building a Cash Flow Statement | Bplans
Building a cash flow statement: The indirect method. Many businesses choose to construct their cash flow statements usin

Creating Cash Flow Statement in Excel by Indirect Method | Chandoo
Apr 11, 2012 - The Basic Concept first! The concept is simple – The basic accounting Equation: Assets = Liabilities. I

Cash Flow Statement - Zeroinfy
Questions that Cash Flow Statement Answers. 1. • Where did the cash come from? 2. • What purpose cash used for? 3. â