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.
The Engagement CS Variable toolbar appears below the main Excel toolbar(s) when Excel is launched from Engagement CS. With this toolbar you can create CSA formulas that link directly to the CSA client data for which you are creating the workpaper.
Click the button to the right of each variable field on the Engagement CS Variable toolbar to open the associated drop-down menus.
Fields & buttons
From the drop-down list, choose one of the variable options that you would like to insert into the workpaper:
- Grouping Schedule (1-5)
- Account
- Account Groups
- Cash Flow Lines
- Text
- Date
- Additional Amounts
- Workpaper Properties
- Net Income Variable
From the drop-down list, choose the variable, which changes based on the Variable Type that is selected, and indicates the variable 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 to be inserted into the selected cell(s) of the workpaper. Note that 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 from the drop-down.
You may choose Adjusted, Unadjusted, Tax, Report(default), Other, or Budget. In addition you can insert the following Journal Entry amounts into a cell: Adjusting Journal Entries, Reclassifying Journal Entries, Tax Journal Entries, Other Journal Entries, and Potential Journal Entries are available.
The Period and the Year variables are selected when using period indicators. For example, CP for Current Period and C for Current year are selected from the Period Indicator drop-down list and the Year Indicator drop-down list respectively. All of the formulas in that column will use these variables for the Period and the amounts will be updated when the client is advanced into the next period.
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).
Click the Filter button on the Engagement CS toolbar in Excel to add multiple Locations and Departments together in a formula without the need to use the Insert Multiple Formula dialog.
For details see, Filtering locations and departments in Excel.