How do I import the prior year trial balance using a CSV format within OpenAudit
Article ID
ias-11643
Article Name
How do I import the prior year trial balance using a CSV format within OpenAudit
Created Date
13th June 2014
Product
Problem
Within IRIS OpenAudit, how do I import the comparative year trial balance using a CSV format?
Resolution
Users are required to select,
1. My Files
2. Below the Audit Engagement Files section, click on the relevant Audit File
3. On the right hand side of screen, under File Details tab, click Working Paper Index
4. Click Working Trial Balance | Import Trial Balance | Browse
5. Select CSV file
Note: The CSV file must be in the following format: Account, Account Name, Debit, Credit
6. Click Open | Upload
7. Within the Select column header line field select, Account, Account Name, Debit, Credit option
8. Within the Mapping column names fields section, map each option to the relevant column heading, e.g. Account Number to Account, Account Name to Account etc.
9. If required, place a tick in ‘Reset previously mapped values’ or ‘Clear previously mapped data rows’
10. Select Trial Balance Type | Next
The trial balance will appear on screen.
11. Scroll to the bottom of the screen
12. Beside the Import button, from the drop down menu select, Previous Year
13. Click Import
For further information please view our detailed, ‘How to import the comparative year trial balance using a CSV format within IRIS OpenAudit’ guide, published within the Support section.
From our Iris Help Centre, select – IRIS OpenApps | IRIS OpenAudit| How to import a comparative year trial balance into IRIS OpenAudit.
We are sorry you did not find this KB article helpful. Please use the box below to let us know how we can improve it.