Daten mit Hilfe des rechten Bereichs in Caseware Cloud Connector einfügen
Hinweis: 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:
-
Go to the Documents page.
-
Open the excel file.
-
Select the Datalink icon from the ribbon.
A pane opens on the right side showing two data source links: Trial Balance and Properties.
To insert trial balance data:
-
Select the cell where you want to insert trial balance group data.
-
Go to the right pane and locate the desired group. Use the down arrows () to expand parent groups if needed.
-
Select the Insert TB Link icon () next to the group.
-
From the drop-down, select either Name, Current Period or Prior Period.
Tipp: You can also use the search field at the top. You can search by group name or group number (if you've enabled the display of trial balance group numbers in your product).
The selected data is fetched from the engagement and inserted in the cell.
To insert an engagement property:
-
Select the cell where you want to insert an engagement property.
-
Go to the right pane and select the Properties tab.
-
Locate the engagement property that you want to insert.
-
Select the Insert Property Link icon ().
Tipp: You can also use the search field at the top.
The information is fetched from the engagement and inserted in the cell.
To insert a firm property:
-
Select the cell where you want to insert an engagement property.
-
Go to the right pane and select the Properties tab.
-
Scroll down to the Firm Properties section.
-
Select the Insert Property Link icon () to insert the Firm name or the Firm address.
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.
Hinweis: 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.