Import data from desktop accounting software

To import client data from third-party desktop accounting software, use the Cloud Import Utility. The CaseWare Cloud Import Utility supports most desktop accounting software.

For a complete list of third-party accounting software, see Supported third-party desktop accounting software.

To start, go to the Import tab in the Data page and select Desktop Accounting Software. Select the link in the dialog to be directed to this page, where you can download the Cloud Import Utility executable file below.

To learn how to import data from QuickBooks desktop, QuickBooks desktop (Export from QB) or Sage desktop, see the following:

For all other third-party accounting software, use the instructions on this page.

Note: Accounts with zero balances are not automatically imported into CaseWare Cloud apps. If you want to include zero-balance accounts, you must manually add and assign them to the designated groups.
Zero-balance accounts are imported into IDEA files.

After you complete the import, you can reimport the trial balance data at any point in time by going to the Data page, and selecting Import, then one of the available options:

  • Reimport Trial Balance - Select this method to reimport the data with the original import method that you used. For example, if you previously used Xero to import the trial balance data, the Xero import method displays when you attempt a reimport.

  • Reimport from different source - Select this method to reimport the data with a different import method. For example, if you previously used Xero, but now want to import the trial balance data from a CSV file.

When you reimport the data, accounts from the new data are matched to the old data using the account name and number. Balances for matching accounts are overwritten with the new data. Accounts that only exist in the old data and not the new data are deleted.

Note: In engagement files created from carry forward, account balances from prior years are not overwritten or deleted by the new data from reimport.

Prerequisites

Before you import your client data, ensure you complete the prerequisite steps for your accounting software. See Prerequisites for importing from desktop accounting software for more information.

Import data

After you complete the prerequisite steps for your accounting software, you can import your client data using the Cloud Import Utility.

To import data using the Cloud Import Utility:

  1. Download the Cloud Import Utility.

  2. Open the downloaded file, then select Next.

  3. The Import From Other Data Source page displays.

  4. In the Import From and Version fields, specify the accounting software you're exporting from.

    The content of the page changes depending on your selection.

    Note: Refer to Supported third party accounting packages for the list of supported packages. If you find outdated packages in the list, report the issue to CaseWare for investigation.

  5. Browse to the Import Path of the client file you want to import.

    If your accounting software requires you to specify a client file, you will see the Select Client ID File drop-down. If there is more than one file, be sure to select the correct one here.

  6. Select Next. The New File Wizard Complete page displays.

    This shows the location of a temporary file that will be used to generate the final .zip file with the imported data.

  7. Select Finish to perform the conversion.

    After the data is generated, the Save As dialog displays.

  8. Navigate to the desired location to save the .zip file and select Save.

    Note: If you're importing data into IDEA using the Cloud Import Utility, do not proceed to Step 8. Your next step is to import the zip file into IDEA. See the IDEA Help for detailed instructions.

  9. Upload the generated output file in your Data page.

    1. Go to the Import tab.

    2. Select Desktop Accounting Software.

    3. Browse or drag and drop the .zip file you've saved in Step 8.

      Tip: If transactions are available in the data, you can select the Import available transactional data checkbox to import them as well.

      Select the checkbox to import transactions - if avaiable.