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.

Also specify if "Banking Transactions" should be imported.  Banking Transactions are always imported into your default cash account.  These are transactions such as interest on your cash balance, checks you wrote, or other deposits and withdrawals from your cash account.

Also specify if you would like Fund Manager to combine separate but matching Purchase and Distribution transactions into a Reinvestment transaction.  Some mutual fund companies report reinvested distributions as 2 transactions (Purchase + Distribution).  Using this option records this case as a single reinvestment.  Either method is equivalent in terms of performance and gain/loss calculations, but a reinvestment is clearer documentation of the actual transaction.

Also specify if distributions in the default cash account should be recorded as reinvested.  Any distributions (dividends, interest, etc) paid from the default cash account are reinvested back into the default cash account when this option is on.  If this option is off, the distributions are paid out of the portfolio in cash.  This option is normally left on.

 

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