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

   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 Poland Auditfile XML file:

1. On the ribbon, click Engagement | Import | Auditfile XML File (Poland). The Import Poland 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.
   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.