When importing a CSV file into Accounts Production what format is IRIS using?
- Article ID
- ias-6319
- Article Name
- When importing a CSV file into Accounts Production what format is IRIS using?
- Created Date
- 21st May 2008
- Product
- IRIS Accounts Production
- Problem
- When importing a CSV file into Accounts Production what format is IRIS using?
- Resolution
- The CSV file format used is as follows: Column 1: Amount Column 2: Account Column 3: Narrative Column 4: Date Column 5: Work Reference Column 6: Partner, Director, Officer Column 7: Branch ID Column 8: Enterprise ID Column 9: Fund Column 10: Activity Column 11: Grant NOTE: The formatting of the cells within the CSV may also be a reason as to why the Trial Balance does not balance. To format cells: Highlight the relevant column | Right click on Highlighted column | Select Format cells… | Select the Number tab | Select the relevant option – e.g. For the Amount column select your category as ‘Number’, decimal places ‘2’ and Un-tick the ‘Use 1000 Separator (,) box
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.