IRIS Bookkeeping - Exporting to IRIS Accounts Production

Introduction

How to export a trial balance or all transactions from IRIS Bookkeeping?

Within IRIS Bookkeeping click on the Tools menu and select the Export to IRIS Accounts Production option.

How to use the Export to IRIS Accounts Production Window

Use this window to transfer data to the IRIS Accounts Production suite. This is achieved by exporting a CSV (Comma Separated Values) file from IRIS Bookkeeping and importing the same file into IRIS Accounts Production.

The full process is described in the topic Transfer to IRIS Accounts Production.

• Make sure that you keep a note of the location of the .csv export file. You will need to locate this file when importing the contents of the file into the Accounts Production software.
  
  Make sure that you export details to Accounts Production before the Year End has been processed.
  
  All items that have not been previously transferred (that is, items in the list displaying No in the TransAP column) will be exported to the .csv file when you click on the Export button.
  
  Once exported it is not possible to reverse the process or re-export the transactions/trial balance.

Field descriptions

• Trial Balance and All Transactions options - You have the option to transfer all transactions or just the trial balance. Select the relevant option to filter the list to display the trial balance or to list all transactions.

The following fields are for information only and list the details that will be contained within the exported .csv file.

• Amount - Displays the trial balance or transaction amount (depending on which radio button has been selected)

• Reference - Displays the reference of the transaction or trial balance

• NominalID - Displays the nominal code that relates to the trial balance or transaction (depending on which radio button has been selected).

• Date - If the All Transactions radio button has been selected, this column displays the date of the transaction. If the Trial Balance radio button has been selected this column displays today's date (that is, the date of the balance).

• TransAP - Indicates whether the item has been previously exported. Yes indicates that the item has been exported and No indicates that the item has yet to be exported. You will notice that after you have exported the balances/transactions all rows will be set to Yes.

You can filter this column to display all transactions/balances (ALL), only those items that have been previously exported (YES) or only those items that have still to be transferred (No). Just click on the filter icon and select the relevant option.

• Period - Displays the period in which the transaction took place (for example, 1 for 1st quarter, 2 for 2nd quarter, and so on).

• Export button - Once you have selected the type of export (transactions or trial balance) click Export. This will display the Save As dialog allowing you to specify the name and location of the .csv file that will be created. Make a note of this location and try and use a meaningful file name (for example, 28-02- Company Name.csv).

• If you do change the file name make sure that you always keep the .csv file extension.

See Transfer to IRIS Accounts Production guide for details on importing these transactions or balances into IRIS Accounts Production.

• IRIS Bookkeeping Support should be contacted with any questions relating to this guide.

Back to top