Warning
Product support for the ended on September 30, 2020.
- Write Up CS
- Payroll CS
- Engagement CS
- Client Bookkeeping Solution
- Financial Analysis CS
Help & How-To Center content for the Creative Solutions Accounting platform may be outdated and is used at your own risk.
On this page of the Create Workpaper wizard you can define columns for the custom worksheet or cash flow statement that you are creating by choosing one of the available column types.
See also: Defining columns in the Create Workpaper wizard
Special information
- When creating a Indirect or Direct Cash Flow Worksheet, only the variable type of Year is available. (Cash flow worksheet data is only saved on a yearly basis with the selected balance type when the worksheet was created.)
- When creating a Indirect or Direct Cash Flow Worksheet, Column A automatically creates the Cash Flow Line Description. After defining the columns for the statement of cash flows, the cash flow statement is formatted in Microsoft Excel as a cash flow statement that include the following three sections that are based on the assigned cash flow types:
- Operating
- Investing
- Financing Activities
Note: 990 clients have slightly different cash flow lines and these differences are reflected in the Excel worksheet that is created. For details, see Indirect > Direct Cash Flow Worksheet.
Fields & buttons
Select a previously saved template from the drop-down list to automatically set up columns for your custom worksheet or cash flow statement based on the existing template.
Notes
- Once you have inserted the settings from an existing template, you can modify those settings for the current workpaper or cash flow statement.
- To delete an existing template, right-click the item and choose Delete Setting.
- To search for an existing template, right-click in the drop-down list and enter a search item in the Search Drop-Down List dialog.
- All templates are saved globally. If you have previously set up templates in a laptop version or separate installation of the program, be sure to back up your system data and restore it to the main installation of the program to include those templates.
Columns A and B are defined as Account Number and Description or Grouping Code by default. Define columns C through Z by highlighting the column you wish to define in the column listview pane.
- Use the Move Up button to move the description of the currently selected column to the column above it.
- Use the Move Down button to move the description of the currently selected column to the column below it.
- Use the Add Column button to add the column type you have chosen from the drop-down list to the column you have selected in the column list.
- Use the Clear Column button to Remove the column type from the column you have selected in the column list.
Define the Type, Period, and Year in the group box that appears when Amount is selected as the column type.
Type of amount
Choose one of the following amount types from the drop-down list:
- Unadjusted
- Adjusted
- Report <default>
- Tax
- Other
- Budget
- Adj Budget
- Adjusted JE
- Reclassifying JE
- Other JE
- Tax Adj JE
- Potential JE
- Budget JE
Period
Choose one of the following periods from the drop-down list:
- Current Period [CP]
- Current Year-to-date [CY]
- Current Year Cumulative [CZ]
- Period 1 [C1]
Note: The number of individual periods available varies depending on the number of periods in the client.
Year
Choose the year from the drop-down list. (Current Year up to 9 years prior)
Location/Department
Choose a Location and > or Department from the drop-down list when applicable for the current engagement client.
Lists five column types that you can choose from the drop-down list to define the column you selected.
You can choose one of the following options from the column type assignment drop-down list:
- Grouping Code > Account number
- Description
- Workpaper Reference
- Amount. When this type is selected, you need to define the following items in the group box that appears:
- Type of amount. Select a type of amount
- Period. Select a period from the drop-down list.
- Year. Select the year from the drop-down list.
- Relational ( + - * /). When you select this type, you need to define the relational properties for the selected columns in the group box that appears.
- Column. Select a column for the first part of your operation from the drop-down list.
- Operation.Select an operation from the drop-down list.
- Column. Select a column for the last part of your operation from the drop-down list.
Enter up to 25 alphanumeric characters in the Save template as field and click Save.
As a timesaver, you can choose to save your column settings to a template that can be recalled from the drop-down list in the Select a template to create your workpaper field when you create subsequent workpapers or cash flow statements.
Related topics
Inserting a new engagement document