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. 

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.