Manually exporting the TB to IRIS Accounts Production

This guide steps you through the process of exporting a Trial Balance from MyWorkpapers into IRIS Accounts Production, using a range of popular bookkeeping packages. 

The following guide is split into two stages. Stage one, importing the MyWorkpapers automap files into IRIS Connector and the second exporting the Trial Balance from MyWorkpapers and importing it into IRIS Accounts Production using IRIS Connector.

Stage 1: Setting up the IRIS Integration

NB: Stage 1 is a one-time setup process. Once you have loaded each of the required MyWorkpapers automap files you can proceed directly to Stage 2

Step 1: Download the appropriate MyWorkpapers automap(s) for IRIS 

• Xero
• Kashflow
• Kashflow Partnership
• FreeAgent
• FreeAgent Partnership
• Quick Books

Step 2: In IRIS Accounts Production, select Setup | Import Maps

Step 3:  Select the Standard import maps tab and click Load

Step 4: Locate the MyWorkpapers automap file downloaded in Step 1 above and select Open

Step 5: The new standard import map will now be loaded into your Standard automaps and should be displayed with a small green icon

NB: Stage 1 is a one-time setup process. Once you have loaded each of the required MyWorkpapers automap files you can proceed directly to Stage 2

Stage 2: Export the Trial Balance from MyWorkpapers and import into IRIS Accounts Production

When you have completed your working papers in MyWorkpapers and are ready to create the final Accounts, please complete the following steps.

Step 1: In the appropriate MyWorkpapers file, click Trial Balance

Step 2: On the Trial Balance menu, click Tools | Export Trial Balance to CSV

Step 3: Open and edit the downloaded CSV as follows:

• Delete columns:
  • C - Initial
  • E - Interim
  • F - Previous Year
  • G - Movement
  • H - Lead Schedule
  • I - Account Type
  • J - Quantity
  • K - Audit File Number 
    
    
    
• Reorder the columns so that they are ordered as Final, Account Code, Description
  
  
  
• Delete the header row (row 1)
• Save the edited CSV

NB: Leave the Account Code column empty if using QuickBooks

Step 4: Open the appropriate client in IRIS Accounts Production and create a new posting file by selecting Advanced | Import Standard file (e.g CSV)

Step 5: Press Change and select the appropriate import map then select OK

Step 6: Select the download CSV file and click Open

Step 7: Check import to ensure all codes are correctly mapped or change any as required. Once all changes have been made, click Import

The Trial Balance will now be imported and mapped to the IRIS Accounts Production posting file ready for the final accounts to be generated.