Import data using visual mapping
1) From the Tools menu, choose Import then Data Import. The CSV Import wizard appears.
2) Click Next
3) Select Manual selection of import definition file. Click Next.
4) Select the client to import to then click next. TIP: You can create a client or import to an existing client. When you create a client you will be asked for more details on the next page.
5) Enter a description for the import then click Next.
6) Choose Visual Mapping table. click Next.
7) Select the file to import then click Next. TIP: Use the Drive and Folder drop-down list to find the correct drive. Double-click in flders to enter the folder.
8) Allocate fields in the csv file to the Sage APA fileds by selecting the Sage APA field, then clicking Edit. When all Unassigned fields have a field name entered, the Next button will be enabled. Click Next.
If the balances are all in the same field, The CSV file must have debits represented as positive numbers and credits represented as negative numbers. In this case, when allocating fields in the CSV file to the Sage APA fields select the Debit field to be the field with balances in and leave the Credit field set to none.
If the balances are in seperate fields, balances should represent as positive numbers. In this case when allocating fields in the CSV file to the Sage APA fields select the Debit field to be the field with Debit balances in and the Credit field to be the field with Credit balances in.
9) The Unmapped Codes pane lists all the codes in the file being imported that have not been mapped to a Nominal code in Sage APA. You can choose where the codes are mapped to by selecting the code by clicking on it, then dragging it over to an item in the left hand pane. Click Next.
10) Select the default import period then click Next.
11) Click Next to begin the import.
12) When the import is complete, click Next then Finish to close the CSV Import wizard.