Importing Transactions - Open Financial Exchange


This dialog is available from the File / Import / Transactions / Open Financial Exchange... menu command.


Transaction data can be imported from Open Financial Exchange formatted *.ofx or *.qfx files:


Getting Started Tip:

When first getting started, you may want to import positions as of a certain date, and then import transactions from that date forward.  If you have all the transaction data available back to inception, you can skip importing positions, and just import all the transaction data.


OFX File(s) to Import

Select which file(s) to import.  You can either import a single file, or all the files in a single folder.

Accounts to Import from OFX File(s)

Choose whether to import all accounts in the selected files, or only a particular account.  Use the "Scan OFX" button to fill in the list of available accounts in the importing file(s).

Date Range to Import

Choose the date range to import transactions.

Import into Fund Manager Portfolio

Specifies the portfolio where transactions will be imported into.  Select a specific portfolio, or have Fund Manager match the account numbers from the importing file with the assigned portfolio account number.  When this "matching" option is selected you can choose the "Create New Sub-Portfolios as Needed" option to have new portfolios created when a matching portfolio account number cannot be found.

Import Options

Specify whether to skip transactions that are already recorded.  Normally this option is left on.

Also specify if new investments should be created when a matching investment could not be found.  Fund Manager matches investments based on the CUSIP investment property, and the CUSIP in the importing file.  If a match based on CUSIP cannot be found, Fund Manager then searches for a match based on the symbol.  Normally this option is left on.  Select the New Investment Options... to choose options for creating any new investments.

Advanced Options...

Specify various advanced import options.


Press the "Next" button after filling in all of the above fields.  The importing file(s) will be read in, and you will be taken to the Preview Importing Transactions page to see what transactions will be imported.

See Also

Importing Transactions

Retrieving Transactions

Preview Importing Transactions Dialog

Importing Open Financial Exchange Positions

Associating OFX/QFX Files With Fund Manager


Fund Manager Home