Thank you for your feedback.

Was this useful?

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

Thank you for your feedback.

Was this useful?