Import a client's financial data to an engagement file

Deze functie is alleen beschikbaar in de CaseWare Cloud Samenstel app.

To populate the trial balance, you’ll have to import the financial data to your engagement file. In some cases, you can import this data directly from another accounting software package using the native import utility (for online accounting software) or a desktop utility import we provide.

Import from online accounting software

You can import your trial balance directly from online accounting software. You can currently import from the following software products:

  • Xero

  • QuickBooks Online

  • Exact Online

To import client data from Xero:

  1. U heeft de rol Bewerker nodig of vergelijkbare machtigingen. To connect to the Xero file, ensure that you have a valid Xero account and that you've been assigned the Standard user or Auditor role on the file. For more on users and roles in Xero Online, see their help materials.

  2. From the top menu, select Trial Balance.

  3. On the trial balance page, choose a trial balance grouping structure from the drop-down menu at the top of the page.

    U kunt bijvoorbeeld:

    • Financial
    • Tax Code
    • Chart of Accounts
  4. Under Import from the following platforms, select Xero.

    A new window is displayed prompting you to log in to your Xero account.

  5. In the Xero Accounting Import dialog, select Login.

  6. Enter your Xero account information and select Login.

  7. Select your client organization in Xero and select Allow access for 30 mins.

  8. In your engagement, select the check box beside the correct client file. If your client file includes transactional data, you can import that data by selecting the option.

    The Xero Accounting Import dialog with a client file chosen and the Import Transactional Data option selected.

  9. Klik op Importeren om af te ronden.

To import client data from QuickBooks:

  1. From the top menu, select Trial Balance.

  2. Under Import from the following platforms, select QuickBooks.

  3. In the QuickBooks Online Import dialog, select Login.

  4. Enter your QuickBooks Online account information and select Login.

  5. Complete the credentials that display and select Connect.

  6. In the QuickBooks Online Import dialog, select the client file.

  7. Select the year-end you wish to import - select the prior period if required. Be sure that this is the same year-end as the RCT engagement file.

  8. Klik op Importeren om af te ronden.

To import client data from Exact Online:

  1. From the top menu, select Trial Balance.

  2. On the trial balance page, choose a trial balance grouping structure from the drop-down menu at the top of the page.

    U kunt bijvoorbeeld:

    • Financial
    • Tax Code
    • Chart of Accounts
  3. Under Import from the following platforms, select Exact.

  4. In the Extract Online Import dialog, select Login.

    A new window is displayed prompting you to log in to your Exact Online account.

  5. Enter your Exact Online account information and select Login.

  6. In your engagement, check the box beside the correct client file. If your client file includes transactional data, you can import that data by selecting the option.

  7. Klik op Importeren om af te ronden.

When you import your trial balance from online accounting software, the accounts and groupings are automatically mapped.

Import from CaseWare Working Papers

Let op: Importing financial data from Working Papers is only supported by CaseWare ReviewCompTax.

You can import your client’s financial data from Working Papers and have it transferred to your CaseWare RCT engagement. The steps to carry out this task differ based on whether or not you have disabled your Working Papers license. To learn more, see Import engagement data from Working Papers to CaseWare RCT.

Import from third-party desktop accounting software

Als u andere accounting software gebruikt kunt u een van onze gratis hulpprogramma's gebruiken om uw gegevens snel te kunnen importeren. Welk programma u nodig heeft is afhankelijk van de software die u gebruikt.

CaseWare Cloud Import Utility

Net als CaseWare Working Papers kan de CaseWare Cloud Import Utility gebruikt worden voor de meeste accounting software. Voor de volledige lijst van ondersteunde software, zie Supported third-party desktop accounting software.

Gegevens omzetten met de Cloud Import Utility:

  1. Download het hulpprogramma.

  2. Open na installatie het exe-bestand. Klik op Other Data Source en klik op Volgende.

    Let op: De optie Existing file kunt u negeren; deze is niet relevant voor gebruikers van Cloud. Voor meer informatie, zie de lijst met bekende problemen in Cloud.

  3. In de velden Import From en Version kunt u aangeven welke software u gebruikt.

  4. Zoek op uw computer de map waarin het bestand staat dat u wilt importeren en voeg deze toe aan Import Path. Als er meerdere bestanden in deze map staan moet u in het veld Select Client ID File nog aangeven om welk bestand het precies gaat.

  5. Klik op Volgende. In de melding die opkomt staat waar u het nieuwe bestand kunt vinden. Klik op Voltooien om het bestand om te zetten.

Het bestand dat met dit programma wordt aangemaakt kan in verschillende CaseWare Cloud apps worden geüpload.

CaseWare Transformer

Voor AuditXML 3.x (Beta) software heeft u de CaseWare Transformer nodig.

Download de CaseWare Transformer: 

Import from QuickBooks Desktop

To import from QuickBooks Desktop:

  1. Click the below link to download the CaseWare Cloud Import Utility.

  2. Open the Utility. Select Other Data Source, then select Next.

    Let op: 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.

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

  4. In the Version drop-down, select QuickBooks Online.

  5. At Import Path, browse and select the exported client file.

  6. Select the desired settings for the import (Fiscal Year End, Period Date Sequence).

  7. Select Next, then Finish.

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

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

  10. 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 Trial Balance page.

Import from Excel/CSV

If the accounting software package you have is not supported by any of our import utilities, you can export your client data to a CSV (comma-separated value) file and then perform the import using this file. The format of the file can be either Excel or .csv.

To import client data from Excel/CSV:

  1. From the top menu, select Trial Balance.

  2. On the trial balance page, choose a trial balance grouping structure from the drop-down menu at the top of the page.

    U kunt bijvoorbeeld:

    • Financial
    • Tax Code
    • Chart of Accounts
  3. Under Import from, select Excel or CSV. In the upload dialog, drag and drop an Excel file or a CSV file into the gray upload area, browse for the file on your local device storage or select the file from the engagement if you have already uploaded it.

    The upload dialog for Excel and CSV files.

  4. Map the columns in the import file by choosing the field that best matches the data from the Import as drop-down menu. If you don’t want to import a column, select Do not import to exclude it.

    Mapping columns using import data.

  5. Klik op Importeren om af te ronden.

Your imported client data populates the trial balance.

Troubleshooting

Problem

You follow all the steps to import data from online accounting software, but the process finishes and no data is imported.

Solution

If the year end date in the engagement and the source data file do not match, the trial balance is not imported. Open the engagement properties and ensure that the year end date is correct.

The engagement properties pop-up.