Daten aus Desktop-Buchhaltungssoftware importieren

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 Unterstützte Desktop-Buchhaltungssoftware von Drittanbietern.

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. After you complete the prerequisite steps for your accounting software, you can import your client data using the Cloud Import Utility.

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 or Sage desktop, see the following:

• Import from QuickBooks desktop.

• Import from Sage desktop.

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

Hinweis: Accounts with zero balances do not automatically import into Caseware Cloud apps with the exception of IDEA. To include zero-balance accounts, you must manually add and assign them to the designated groups.

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.

Generate the import file

During this step, you download and install the Caseware Cloud Import Utility. Use it to import your client data and generate an import file.

To generate the import file:

1. Download the Caseware Cloud Import Utility.

Caseware Cloud Import Utility(.exe)

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

3. 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.

4. 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.

5. Wählen Sie Weiter. 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.

6. Select Finish to perform the conversion.

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

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

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

Import the data

After you generate the zip file using the Caseware Cloud Import Utility, you can import the data into your engagement.

To import the data into your engagement:

1. Open your Caseware Cloud engagement file. When you first open the engagement, the Engagement properties popup appears. Set Year end date to be the same as the data you are about to import.

   The year-end date is the last element of the name of the zip file you generated. For example, for the file named UNIVERSAL CONSTRUCTION 2025-06-30.zip, the year-end date is June 30, 2025.

2. On the Data page, go to the Import tab and select Accounting Software or Structured File.

3. If this is the first time you’re importing data into the engagement, select New data source. If you’ve previously imported data, select Add data.

4. If your engagement is consolidated and has internal subsidiary entities, select which entity you want to import data for from the list.

5. Select Desktop Accounting Software from the list of data sources, then select Next.

   If the option is not visible, you can use the search box to find it.

6. At the Upload stage of the import wizard, select or drag-drop the zip file you generated using the Caseware Cloud Import Utility, then select Next.

7. At the Configure Data stage of the import wizard:

   • Reporting period is automatically filled with the reporting period of the data.

   • Start Date is automatically filled with the start date of the data.

   • End Date is automatically filled with the end date of the data.

8. In Select dataset type, choose the type of dataset you are importing.

   To learn more about the dataset options, see Dataset types. Not all dataset types may be available if they have not been enabled in your product.

9. If you selected Trial balance, collapse the list of dataset types by selecting the Collapse icon (). Notice the Import the last 5 years of TB option appears. Select it to import up to five years of trial balance data if it is available in the zip file you generated.

10. Wählen Sie Weiter.

11. At the Confirmation stage of the import wizard, review the information and select Import.

To view the imported financial data, go to your engagement's Data page.

Reimport the trial balance

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.

Hinweis: If you reimport the data from a different source and there are accounts in the existing data that are not in the new data, the balance of these existing accounts is set to 0.

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

Dataset types

Dataset type	Beschreibung
General ledger	General ledger transactions
Trial balance	A worksheet in which all ledgers are compiled into debit and credit columns in order to ensure a company's bookkeeping system is mathematically correct.
Accounts payable - invoices	The Accounts payable—invoices dataset contains all invoices received during the period under review.
Accounts payable - payments made	The Accounts payable—payments Made dataset contains all payment transactions (check, wire transfer, cash, and so on) made during the period.
Accounts payable - suppliers	The Accounts payable—suppliers dataset contains all details related to the Supplier such as Contact details, address, credit limit and so on.
Accounts payable - open balances	The Open accounts payable dataset contains details regarding all open, unpaid, or unresolved payable transactions as of the close of business on a specified date.
Accounts receivable - invoices	The Accounts receivable—invoice dataset contains all invoices generated during the period under review.
Accounts receivable - cash received	The Accounts receivables—cash received dataset contains all payment transactions (check, wire transfer, cash, and so on) received during the period.
Accounts receivable - customers	The Accounts receivable—customers dataset contains all details related to the customer, such as contact details, address, credit limit and so on.
Accounts receivable - open balances	The Accounts receivable—open balances dataset contains details regarding all open, unpaid, or unresolved customer transactions as of the close of business on a specified date.
Inventory transactions	Captures all transactions affecting inventory accounts during the time period specified (for example, receipts, shipments, transfers, returns, and adjustments).
Inventory on hand	Captures the on-hand inventory quantities of items by location and amounts as of the specified date.
Andere	Unstructured transaction data that does not follow a predefined schema. Select this option to import data that does not correspond to any of the dataset types described here. Each file you import using this dataset type is considered its own dataset.