How to import a comparative year Trial Balance into IRIS OpenAudit

Introduction

This topic explains how to import a trial balance for the comparative year into IRIS OpenAudit.

Importing a comparative year trial balance

1. From IRIS OpenAudit, select the relevant client.

2. Select Working Paper Index | Working Trial Balance | Full Working Trial Balance

The Trial Balance screen displays.

3. Click Import Trial Balance.

The Import Wizard – Step 1 Import Trial Balance screen displays.

4. Click Browse and select the relevant CSV/tab delimited text file to be uploaded.

5. Click Open | Upload

The Import Wizard – Step 2 Mapping Trial Balance Columns screen displays.

6. From the drop-down list under Select column header line select the Account, Account Name, Debit, Credit options.

7. Within the Mapping column names fields section, map each option to the relevant column heading, for example, Account Number to Account, Account Name to Account and so on.

8. If required, select Reset previously mapped values or Clear previously mapped data rows.

9. From the Trial Balance Type drop-down list, select the relevant option.

10. Click Next.

The Import Wizard – Step 3 Trial Balance accounts summary screen displays.

11. Scroll to the bottom of the screen.

12. From the drop-down list next to Import select Previous Year.

13. Click Import.

The following message displays.

14. Click OK.

The Import Wizard – Trial Balance import completed screen displays.