Importing Data - iCash v6 User Guide

Comma-Delimited Text
In order to import data from another database application, you need to export it to a common format like Tab-delimited or Comma-Delimited text. Once the data is available in a format iCash can handle, just click on the Import button, select your file from the dialog and click on the Open button. You'll then be presented with a screen showing all the fields included in the file. You can use the Field Delimiter pull-down menu to change the format and to preview the data. You can use the left and right arrows on the top left corner to scroll through all records.

iCash assists you during the import process by giving you the possibility to import the data from the file the way you want, that is, the fields you really need in the order you want using one of the four available delimiters: tab, comma, colon or semicolon. Your database field order likely won't correspond with the field order required by iCash. Just highlight a field and use the up and down arrows on the right hand side of the screen until it matches the correct field and repeat as often as required. You can go through the file data in order to check that each field is really where expected. Once all the fields are lined-up and properly checked, click the Import button and your data will be imported.

Note: iCash lets you save your current import settings for later use. Just use the Import Presets pull-down menu to create, load or remove your import settings.

Quicken QIF
iCash supports QIF imports. You have to export to QIF first from your previous accounting software into a single file or three separate files, Categories, Accounts and transactions. These files have to be imported to iCash in this same order.

OFX | QFX (Open Financial eXchange)
iCash also supports the OFX imports (aka QFX). OFX is a unified specification for the electronic exchange of financial data between financial institutions, businesses and consumers via the Internet. OFX is very common as the online Banks preferred export format as it is based on the XML standard. To import an OFX file, select the File | Import | OFX menu, select OFX from the import window, press Import and select the file.