Quick overview of how to import different data

The basic principle for importing is the same for each type of import. Your information needs to be saved as an Excel CSV (comma separated values) file.

1. Once this has been completed select the tab, Sales for importing Customer details and product list, Bookkeeping for other imports.
2. Click ‘Load file’ (or ‘Import’) to the right above the list area
3. Click ‘Browse’
4. Select the desired CSV file
5. Click ‘Open’
6. Click ‘Load file’(Note: the import may take a while depending on the amount of data.)
7. Define import template:
   1. Template: The first time you import data, you can only select ‘Save as new’. When you have created several templates you can select these from the drop-down list.
      
   2. Name of new: Save the selected settings by naming the template.
      
   3. Skip rows: Column headings and other initial text cannot be imported. Enter the number of rows (counted from the top of the file) that should be skipped when loading data.
8. Set up the data for import:
   
   1. Source file: Shows the data to be imported.
      Load: Bold column headers indicate mandatory information. Further information is optional.
      
   2. Load from: Indicate which data to import and where to place it:
      Select “Fixed value” to apply the same value to all imported data. E.g., to include all imported suppliers in the same group.
      Note that ‘fixed value’ cannot be used for bank statements.
      Select “None” if this data is not in the source file, or if you do not want to import it.
      Select “Column [n]” to enter the column in the source file that should be inserted.
      
   3. Update existing: Check this to update existing data in e-conomic. If left unchecked, new data for any given supplier (/customer/product) will be skipped. (Note: as settings are defined, data from the source file appears under Load > Data)
9. Click ‘Import data’

For suppliers/customers
Create new items: Tick this to load new suppliers (or customers). Leave empty if you are updating data for existing customers in E-conomic.

For budget figures
Convert sign into +/-:
Income must be imported as credit amounts (negative amounts) and expenses as debit amounts (positive amounts). If the income in the source file is in positive amounts and the expenses are negative amounts, convert them by ticking ‘Convert sign into +/- ‘.

For day book entries
Convert sign into +/-:
Withdrawals from bank accounts will be viewed as credit entries in the day book if the bank account has been selected as the contra account. In order to convert the entries so that they are debited to the relevant expense accounts and credited to the bank account, tick ‘Convert sign into +/- ‘.

For products
Create new items: Tick this to load new products. Leave empty if you are updating data for existing customers in E-conomic.
Create missing units: Tick this to automatically create any units in the data (e.g., l (litre), m (metre)) that have not been defined in E-conomic. Such units must be in separate columns (i.e., ‘km’, not ’10 km’).

For bank statements:
‘Always import, even if the combination of date, text and amount corresponds to an existing bank statement entry’: Tick to allow the same entry to be loaded several times, e.g., several payments with the text ‘payment’ – but from different customers.