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?