Import From CSV/QIF File

Transactions can be either entered manually or imported via downloaded CSV (comma separated value) / QIF (Quicken Interchange Format) files or a combination of both approaches. When importing CSV/QIF files USBMoney checks every imported transaction against transactions already entered in the relevant account. Firstly USBMoney checks the first & last dates of the CSV/QIF files then adds a + or - 3 day error margin to capture transactions that may have been manually entered wrongly by a day or two, this approach try's to avoid multiple matches being detected for recurring transactions.

1) In the Options dialog box click on the CSV/QIF tab. If the account has been configured to accept CSV files then proceed to step 2. Otherwise See Configure CSV. (Note: QIF files require no configuration).

2) Click the 'Import from CSV/QIF file' button. The following dialog box is displayed if pending transactions are present.

By default the ending balance of the relevant account is entered into the dialog box. It is assumed that CSV/QIF files are correct & the CSV/QIF ending balance should be entered if it is different form the displayed amount. (the account will be reconciled after the CSV/QIF file import) Click OK & the following dialog box is displayed.

The first CSV/QIF transaction will be displayed & if any transactions in the relevant account match they will be listed in the top grid. The bottom grid shows detail of the selected transaction. This is usually the same as the top grid except in the case of split debits where the individual elements of the split would be listed.

A match is split into 3 parts. Date/Detail & Amount. The 3 boxes on the far right hand side of the dialog box show which parts of the selected transaction match the CSV/QIF transaction. A full match as above shows the 3 boxes coloured green.

3) Its now time to choose what to do with the CSV/QIF transaction. PWSMoney displays its recommended action just above the row of speed buttons. This is only a recommendation as does not have to be adhered to.

Accept Transaction - I accept the selected transaction (the one selected in the top grid) as the downloaded CSV/QIF transaction. This will replace the transaction in the relevant account. If there are any differences in date / detail & amount the account will be reconciled.

New Transaction - The transactions in the top grid (if any) do not match the CSV/QIF transaction & I wish to insert this transaction as a new transaction. The relevant account will be reconciled.

Note:USBMoney allows for a 'speed' import of CSV or QIF files if the account to be imported into is empty. Click New Transaction & the following dialog box will be displayed.

This option is useful when importing into an empty account or when migrating from another personal finance program. All transactions will be automatically imported with no user intervention required. Categories are supported in QIF files only, in CSV files the categories will appear blank & can be manually edited after importing.

Skip Transaction - No matter if there are any matches to this transaction I wish to ignore it and move onto the next CSV/QIF transaction. The relevant account will be unaffected.

Manual Search - No matches (or the wrong matches) were found for the CSV/QIF transaction. I know it is in the relevant account & I wish to search for it manually. This action should be followed by one of the above actions.

Add to Transactions - This should be used before any of the above actions and is a quick way to add any of the CSV/QIF transactions to the transactions table on the main form. (e.g. A CSV/QIF transaction that is a recurring transaction).

4) After the CSV/QIF download is complete a reconcile dialog box is displayed if the CSV/QIF ending balance & the relevant accounts ending balance differs.

5) Now click on the 'Preview CSV/QIF Report' speed button. Print the report to compare records in the relevant account if required as a double check.