There is no direct import from XERO to IDEA. You must first export the Trial Balance and General Ledger from XERO. Then import them into IDEA.

Create the files in XERO

• Select Accounting> Advanced> Export Accounting Data 

• Trial Balance: 

• Select CaseWare from Product list  

• Select the Year End

• Select download to download the csv file

• General Ledger: 

• Select CaseWare from Product list  

• Select the date range

• Select download to download the txt  file

Import data to IDEA 

The CaseWare Accounting Package import lets you import data from a wide selection of third-party accounting software directly through the Import Assistant.

However, you must first use the CaseWare Cloud Import Utility to convert the data into a compressed file (CaseWare Accounting Package) that IDEA can process. 

For more information on the CaseWare Cloud Import Utility, refer to the CaseWare IDEA Passport

IDEA extracts the following individual files from the CaseWare Accounting Package and imports each file as a separate IDEA database.

• balance

• company

• journal

• ledgerAccount

Use the CaseWare Cloud Import Utility to create a CaseWare Accounting Package compressed file.

1. If required download the Cloud Import Utility from the CaseWare IDEA Passport

2. Open the downloaded file, then select Next.

3. The Import From Other Data Source page displays. In the Import From and Version fields, specify the accounting software (XERO) you’re exporting from.

4. Browse to the Import Path  for the files created above.

5. Select the TB file 

6. Select the GL file 

7. Select Next. The New File Wizard Complete page displays. This shows the location of a temporary file that will be used to generate the final .zip file with the imported data.

8. Select Finish to perform the conversion. After the data is generated, the Save As dialog displays.

9. Navigate to the desired location to save the .zip file and select Save.

Now launch IDEA 

1. On the Home tab, in the Source Data group, click Import.

2. Select CaseWare Accounting Package and click Next.

3. Select the CaseWare Accounting Package compressed file.

1. Click the Browse button adjacent to the Input file field.

2. Navigate to and select the required CaseWare Accounting Package compressed file (.zip) that contains the files you want to import.

3. Click OK.

4. Four files are listed in the CaseWare Accounting Package dialog box. By default, all files are selected for import.

5. To exclude files from the import, in the Select files to import list, clear the check boxes for the files you do not want to import.

6. In the Prefix for each database field, accept the default prefix or enter a prefix to be appended to the output database names.