• Imports
  • Comparison report
  • Imports and Pervasive SQL
  • Imports and SQL Server
  • Software import index
  • Create a database backup file
  • Import from accounting software
  • Import from ASCII or Excel
  • Import from Caseware Working Papers
  • Import from Engagement CS
  • Import from ProSystem fx Engagement
  • Import from QuickBooks
  • Import from Sage 50 Accounting
  • Import from Working Paper Software
  • Import from XML

Import from XML

You can extract information from accounting software applications by importing an XML file that is in a standardized format.

Note: If you are importing a standardized XML file in Portugal or Poland, see the relevant procedures.

To import data from an Auditfile XML file:

1. On the ribbon, click Engagement | Import | Auditfile XML File. The Import Auditfile XML formatted file dialog displays.
2. In the file location field, browse for and select the XML file that you want to import.

3. Select the applicable options for your import:

   Option	Description
   Update year end date in client profile	Select to update the year end date in the Working Papers file Engagement Properties based on the XML file content.
   Import client information	Select to import the client information from the XML file, and overwrite the client information in the Working Papers file Engagement Properties.
   Import version 3.X auditfile	Select if the XML file you are importing is from version 3.0 or later.
   Import the leadCode as XBRL tag	Select to import map numbers from the XML file where they are coded as XBRL tags.
   Import opening balances	Select to import opening balances from the XML file. This option is only applicable to version 3.X auditfiles. If your file already contains opening balance data, a prompt will display to overwrite it with the auditfile data.

   Click OK.

The data is imported to your Working Papers file.

To import data from a SAF-T PT XML file:

1. On the ribbon, click Engagement | Import | SAF-T PT XML File. The Import SAF-T PT Auditfile XML formatted file dialog displays.
2. In the file location field, browse for and select the XML file that you want to import.

3. Select the applicable options for your import:

   Option	Description
   Import client information	Select to import client information from the XML header.
   Update year end date	Select to update the year end date based on the XML header.
   Import opening balance	Select to import the opening balance from the XML file.
   Import Journals between	Select to import journals from the XML file. Use the Start date and End date calendars to specify the range of journals to import. You must also select an option for how to handle existing journals in the Working Papers file.

   Click OK.

The data is imported to your Working Papers file.

To import data from a JPK_KR XML file:

1. On the ribbon, click Engagement | Import | JPK_KR XML File (Poland). The Import JPK_KR XML File dialog displays.
2. In the file location field, browse for and select the XML file that you want to import.

3. Select the applicable options for your import:

   Option	Description
   Update year end date in Engagement Properties	Select to update the year end date in the Working Papers file Engagement Properties based on the XML file content.
   Import client information	Select to import the client information from the XML file, and overwrite the client information in the Working Papers file Engagement Properties.
   Import opening balance	Select to import the opening balance from the XML file.
   Account number levels	Select the number of levels to import from account numbers (maximum 4). Levels are separated with a hyphen (-). Example: Select 3 to import all levels from the account number 123-45-6.

   Click OK.

The data is imported to your Working Papers file.