Get started with Caseware Cloud Connector
Caseware Cloud Connector is a Microsoft Office Add-in that provides realtime data linkage between your engagement and MS Excel. With that linkage in place, you can access and retrieve trial balance data, engagement properties and firm properties, then insert the information in a MS Excel file. If a linked value or information changes in the engagement, it's automatically updated in the excel file.
You can use the Cloud Connector to author financial statements, worksheets and schedules or to verify calculations.
Before you start, ensure your firm administrator has purchased and enabled a Caseware Cloud Connector license for your account.
To get started:
If you are using Windows, make sure you have a local installation of the latest version of Microsoft Office 365 Desktop and are using the latest version of Windows 10.
If you are using Mac, make sure you have a local installation of version 16.35 or later of Office on Mac and are using a Mac OS that supports Microsoft Office 365.
Note: MS Office version 2019 or prior and Office Online are not supported.
Open an Excel file in MS Office 365.
Upload the Excel file to your engagement.
Open the Excel file from the Documents page.
Get the Caseware Cloud Connector Add-in from the Microsoft Add-ins Store.
Your firm administrator can pre-install the add-in for you. See Deploy add-ins in the admin center for instructions.
If the add-in is not pre-installed, you can also search "WA200002239" in the store to locate the add-in and install it manually.
Use the Caseware Cloud Connector Add-in to insert data from your engagement in the excel file.
To learn more about inserting data using Caseware Cloud Connector, see the following: