Import data from XML Auditfile (XAF)
You can import client data from XML Auditfile (version 3.1 or 3.2) accounting software, using the data connector feature in Caseware Cloud. A data connector is a tool to connect to and extract data from a specific data provider. A provider could be third-party accounting software, a particular file format, or even another engagement. This feature works for both cloud and desktop versions of Caseware.
Note: Accounts with zero balances are not automatically imported. If you want to include zero-balance accounts, you must manually add them and assign them to the designated groups.
To import data from XML Auditfile:
-
Navigate to the Data page. The Data page opens to the Datasets tab.
-
If you’ve previously imported data, select Add data.
-
If your engagement is consolidated and has internal subsidiary entities, select which entity you want to import data for from the list.
-
Under IMPORT FROM DATA CONNECTOR, select XML Auditfile from the list. If your data source is not visible, enter its name into the Search box to find it.
-
Click the upload window to select a XAF file from your computer to be uploaded or drag and drop your XAF file into the upload window.
-
If applicable, select the RGS version from the dropdown menu under RGS Mapping. Note that versions 3.1 to 3.5 are supported.
-
Select the dataset type for the XAF file.
-
Click Next. The next window will allow you to review the dataset type you are importing.
-
Click Import.