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