Thank you for your feedback.

Was this useful?

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.

Thank you for your feedback.

Was this useful?