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.
Use the Insert Variables Formula dialog in Engagement CS to create and insert formulas in your Excel workpaper. You can select from a number of variables in the Insert Variables dialog to create a formula or multiple formulas that are linked directly to the CSA client data.
Choose Insert Variables from the Engagement CS pull-down menu, or click the Insert Variables button on the toolbar.
Fields & buttons
From the drop-down list, choose one of the amount type variable options that you would like to insert into the workpaper:
- Grouping Schedule (1-5)
- Account
- Account Groups
- Additional Amounts
- Cash Flow Lines
- Net Income Variable
Note: You can select theNet Income Variable option to carry Year-to-Date and Current Net Income amounts fromRevenue orExpense accounts in the CSA engagement client.
From the drop-down list, choose a variable name (changes based on the Variable Type that is selected) that will be inserted into the workpaper field.
From the drop-down list, choose the Account/grouping code, Account/grouping description or the amount type that are to be inserted into the selected cell(s) of the workpaper. This field is only available when used with Accounts and/or Grouping Codes.
From the drop-down list, choose the basis type that you would like to appear in the selected cell of the workpaper. You may choose Adjusted, Unadjusted, Tax, Report (default), Other, or Budget. In addition, you can insert the following Journal Entry amounts into a cell:
- Unadjusted
- Adjusted
- Report
- Tax
- Other
- Budget
- Adjusted Budget
- Adjusted JE
- Reclassifying JE
- Other JE
- Tax Adj JE
- Potential JE
- Budget JE
- Eliminating JE (available in consolidated clients)
From the drop-down list, choose the period for the amounts that you would like to appear in the cell. You may choose Year to Date, Current Period, Cumulative and Beginning Balance amounts for the current, future, or preceding years. Typically, you would assign the cell period to an entire column, and then change only those cells that require different properties.
If the current engagement client has locations and > or departments set up, specify the location and > or department to display amounts for by selecting one from the drop-down list. Only the amounts for the specified location > department will appear in the selected cell(s).
If you are using an amount type variable, you can add formulas together. When you have highlighted the appropriate item, click the Operator that you would like to follow it.