IRIS OpenBooks - CSV File Formats for Bank Uploads

How to format your CSV file

To create a basic CSV to upload to OpenBooks you need to include three columns: date, amount and description.

• Column A - date: use the date format dd/mm/yyyy
• Column B - amount: formatted as 'Number' to 2 decimal places. Transactions for money paid out of the bank account should have minus signs in front of them (-) and transactions for money coming into the bank account in should not have minus signs in front of them.
• Column C - description: the invoice reference, or a brief description.

Checklist

In your CSV file make sure:

• You haven’t included a header row
• The date format is dd/mm/yyyy
• You've used a single 'amounts' column that contains both money paid out and money paid in
• There are no commas in your amounts columns
• You haven't included any quote marks (")
• Each description is on a single line with no carriage returns
• The file format is .csv (not .xls or .xlsx)
• A character delimiter of comma ',' is being used when you export your CSV file.