 |
 |
|
|
In this Topic Hide
To access this screen select Posting | Post, within the posting screen select Advanced | Import Postings
Accounts Production can import information from any bookkeeping package which can export a comma separated variable (CSV) file.
The procedure for outputting a CSV file varies from one package to another. Consult the package's reference manual. The output file MUST contain the information in the following format:
Amount, Account, Narrative, Posting Date, Work Reference
The Narrative, Posting Date and Work Reference are optional.
The Posting Date must be in the format ddmmyy.
Groups: When importing a CSV file into a group the CSV file needs to be in the format of Amount, Account, Undertaking, Narrative (optional). The Undertaking column will be the Client ID for the relevant subsidiary.
Charity/Branches: When importing a CSV file into a charity or a client that has branches the CSV file needs to be in the format Amount, Account, Narrative, Posting Date, Work Reference, Partner/Director/Officer Account Order, Branch, Enterprise, Fund, Activity, Grant.
If one of the columns is not required, for example, Branch for a charity, the column must be created but remain blank,
-100, 2, Voluntary income, 310307, YRS, , , ,GENERAL, , ,
This example is for a
charity, the columns for Partner/Director/Officer
- Account Order, Branch, Enterprise, Activity and Grant,
have been created but left blank as the are not applicable.
As different bookkeeping packages use different nominal ledger structures you need to create a mapping file to tell Accounts Production which code in the bookkeeping package translates to the relevant Accounts Production code.
To create a mapping file:
Select Setup
| Import maps
This will show a list of import maps already loaded. Certain mapping
files can be supplied by Accounts Production, contact customer
support for further information.
If a new map is required, click New.
Enter a description for the import map, then
complete the relevant options on the screen. Click OK.
The Account Charts screen displays.
Select the IRIS Chart
and click OK.
The New Map Account screen displays.
In the Package account identifier field enter the account number in the package to be imported from.
Enter the relevant IRIS account number into the Attribute amounts to IRIS account or sub-account field.
Enter the partner, director or officer Account Order if relevant.
Click OK.
Enter this information for each account required. Once complete, click Cancel. This will then show a list of all accounts which have been set up.
Click Close if the list is complete, or choose Change, New or Delete.
Select Posting and click Select.
Select the posting entry into which the data is to be imported.
In the posting screen select Advanced | Import Postings
Select Standard (e.g. comma separated) import file.
When the list of mapping files is displayed highlight the one you want to use and click select.
The following screen allows you to select the CSV file created by the bookkeeping package. Either enter the full path and name of the file in the File name field for example a:\bookkeepingfile.csv or use Look in to browse and find the file. Once you have found the file select Open.