 |
 |
|
|
This topic explains how to transfer a trial balance or all transactions from IRIS Bookkeeping to IRIS Accounts Production.
In this Topic Hide
Step 1 - Export the Trial Balance or All Transactions from IRIS Bookkeeping
Step 2 - Select a Mapping File in Accounts Production
Step 3 - Import the Company's Transactions or Trial Balances into Accounts Production
A trial balance or set of all transactions in the form of a CSV (comma separated values) file must be created within IRIS Bookkeeping.
Do this as follows:
Open IRIS Bookkeeping. If you have a multi-company licence (bureau user), select and open the relevant company.
From the Tools menu select Export to Accounts Production option.
See Export to IRIS Accounts Production guide for details on the fields and buttons on this window.
When you export the .CSV file keep a note of the file name and location. Use a filename and location that is easy to find and identify (for example. C:\TT\28-02-2005 Company Name.csv).
If you do change the file name make sure that you always keep the .csv file extension.
A mapping file is required to translate the IRIS Bookkeeping codes on to IRIS Accounts Production codes. A set of standard mapping files is issued on the IRIS Practice Suite CD.
Only 'Super users' or 'MASTER' can load the mapping file from the CD.
Within the Accounts Production
software select the menu option Setup
| Import Maps | Load.
The mapping files are located in the SAMPLES directory within the IRIS
Programs folder.
Select the most relevant mapping file as follows:
FinELTD Limited companies using Enhanced (ELTD) chart in AP and Standard chart in IRIS Bookkeeping.
FinLTD Limited companies using Standard (IRIS) chart in AP and Standard chart in IRIS Bookkeeping.
FinPST Partnership or sole trader using Standard (IRIS) chart in AP and Standard chart in IRIS Bookkeeping.
FinEPST Partnership or sole trader using Enhanced (EPST) chart in AP and Standard chart in IRIS Bookkeeping.
Sol2ELTD Limited companies using Enhanced (ELTD) chart in AP and Solution chart in IRIS Bookkeeping.
Soltoltd Limited companies using Standard (IRIS) chart in AP and Solution chart in IRIS Bookkeeping.
Sol2psst Partnership or sole trader using Standard chart (IRIS) chart in AP and Solution chart in IRIS Bookkeeping.
Sol2EPST Partnership or sole trader using Enhanced chart (EPST) chart in AP and Solution chart in IRIS Bookkeeping.
Select Open
to load the import map.
This map can be amended if required as follows:
Select Setup | Import Maps.
Select the Standard tab.
Highlight the mapping file required and select Change.
Select Accounts in Import Map.
The accounts in the mapping file are now listed and it is possible to
add new accounts, change
or delete any existing ones (as
required).
Open the IRIS Accounts Production software and select the client and posting entry.
Select Posting | Post.
In the posting window select Advanced | Import Postings.
Select Standard (for example, comma separated) import file.
Select the appropriate mapping file (the same mapping file loaded in Step 2).
The .csv file created by IRIS Bookkeeping in Step
1 can now be selected.
Either:
Enter the full path and name of the file in the File Name field or
Use Look In to browse and locate the file.
Once the file has been located select Open.
The transactions or trial balance will now be imported into the current posting file. If any codes in the trial balance are not recognised (that is, not in the selected mapping file) then the import process will pause (with message stating ‘Alien account’) and the appropriate code may be entered.
These account mappings can then be added to the import map (Setup | Import Map) at a later date.