Insert data using the right pane with Caseware Cloud Connector

Note: Your firm administrator must purchase and enable Caseware Cloud Connector for your account.

You can use the right pane to retrieve and insert data from the engagement into the excel file.

Note that your starting point is always the Documents page:

  1. Go to the Documents page.

  2. Open the excel file.

  3. Select the Datalink icon from the ribbon.

  4. A pane opens on the right side showing two data source links: Trial Balance and Properties.

A Microsoft Excel file with the Caseware Cloud Connector pane open.

To insert trial balance data:

  1. Select the cell where you want to insert trial balance group data.

  2. Go to the right pane and locate the desired group. Use the down arrows () to expand parent groups if needed.

    Tip: You can also use the search field at the top. You can search by group name or group number.

  3. Use the filters ( ) to select which columns you want to add for the group and its subgroups. For example, if you want to insert the group number, name, the current year balance and the prior year balance, select the filters for those columns.

    If you want to include zero balance accounts, select the Insert zero-balance items filter.

    If your engagement is consolidated, you can select an entity in the consolidation data to display data for that entity. You can also use the Consolidated filter to select whether to insert consolidated or non-consolidated data.

  4. Select the Add groups and subgroups icon ( ) next to the group.

    The group you selected and all its subgroups are inserted in the file.

A Microsoft Excel spreadsheet with a group and its subgroup added to the file from the Cloud Connector pane.

To insert an engagement property:

  1. Select the cell where you want to insert an engagement property.

  2. Go to the right pane and select the Properties tab.

  3. Locate the engagement property that you want to insert.

  4. Tip: You can also use the search field at the top.

  5. Select the Insert Property Link icon ( ).

  6. The information is fetched from the engagement and inserted in the cell.

To insert a firm property:

  1. Select the cell where you want to insert an engagement property.

  2. Go to the right pane and select the Properties tab.

  3. Scroll down to the Firm Properties section.

  4. Select the Insert Property Link icon ( ) to insert the Firm name or the Firm address.

  5. The information is fetched from the engagement and inserted in the cell.

Tips:
You can use operators with Cloud Connector formulas to perform calculations.
#BUSY! means that it's taking a few moments to load the data into the cell.
#VALUE! means that the data cannot be found. For example, if the firm address has not been entered, #VALUE! displays in the cell.

Note: Do not forget to save your excel file once you're done. If you want to share a copy of the current excel file and do not want the data to update as the engagement file is updated, you can use the Duplicate & Unlink option. This will create a copy of the spreadsheets that does not include formulas which you can use to backup information or send it to clients. Note that protected sheets cannot be duplicated.