Import from Sage desktop

You can use the Cloud Import Utility to import data from Sage.

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.

Import from Sage 50 Accounts (Sage-Line50)

Before you start, make sure that you have the necessary import files:

  • Profile Information: ACCDATA\ACCOUNT.DTA

  • Chart of Accounts: ACCDATA\NOMINAL.DTA

  • CoA Index: ACCDATA\NOMINDEX.DTA

  • GL Detail: ACCDATA\SPLITS.DTA

  • Company Information: ACCDATA\SETUP.DTA

  • Account Types: ACCDATA\COA

  • Bank Information: ACCDATA\BANK.DTA

  • Ledger Index: ACCDATA\HEADER.DTA

  • Department Information: DEPARTM.DTA

To import the data to your engagement:

  1. Download the CaseWare Cloud Import Utility.

  2. CaseWare Cloud Import Utility(.exe)

  3. Open the Utility, select Other Data Source and select Next.

  4. In the Import From and Version drop-downs, select Sage 50 Accounts and the version you're importing from.

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

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

  6. Specify the desired settings for the import.

    The settings vary based on the version you've selected in Step 3.

  7. Select Next, then Finish.

  8. Save the generated zip file using the displayed prompt.

  9. In your engagement file, go to the Data page and select Desktop Accounting Software.

  10. Select or drag-drop the zip file you've saved in Step 7.

The data is imported to the engagement file and becomes available in the Data page.

Import from Sage 50 Accounting CDN Edition (Simply)

Before you start, make sure that you install either Sage 50 Accounting (CDN Edition) or the Sage 50 Connection Manager utility from MyCaseWare. You must have one of these applications to perform the import; however, do not install both.

To import the data to your engagement:

  1. Download the CaseWare Cloud Import Utility.

  2. CaseWare Cloud Import Utility(.exe)

  3. Open the Utility, select Other Data Source and select Next.

  4. Note: Do not select the Existing File option as it's irrelevant to Cloud users. For more information, see the platform's list of known issues.

  5. In the Import From and Version drop-downs, select Sage 50 Accounting CDN Edition (Simply) and the version you're importing from.

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

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

  7. At Client ID, select the client file.

  8. Specify the desired settings for the import.

    The settings vary based on the version you've selected in Step 3.

  9. Select Next, then Finish.

  10. Save the generated zip file using the displayed prompt.

  11. In your engagement file, go to the Data page and select Desktop Accounting Software.

  12. Select or drag-drop the zip file you've saved in Step 8.

The data is imported to the engagement file and becomes available in the Data page.