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
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.
Comments
0 comments
Article is closed for comments.