Import from Auditfile 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 Auditfile 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 Portugal Auditfile XML file:

  1. On the ribbon, click Engagement | Import | Auditfile XML File (Portugal). The Import Portugal Auditfile XML formatted file dialog displays.
  2. In the file location field, browse for and select the Auditfile 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 Auditfile 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.