QIF import from Quicken

[ridgerunner]

I am importing my transaction history from Quicken via a QIF file and I am not getting my cost basis to balance with my statements. The securities are ETF's and the settings are set for FIFO.

My Quicken account balances with my statements, so maybe I do not understand how to arrive at my cost basis in FM.

[Mark]

Hi ridgerunner,

You can get cost basis for your sold shares using a "Capital Gains" report. If you'd like to know the cost basis for the shares you still own, create a "Custom" report, and add the field:

Tax basis, FIFO (ending)

If the tax basis isn't as you expect, look at your recorded transactions, and make sure the recorded purchases have the correct cost. You can see these in the "Data Register", under the "Investments (all)" data type.

[ridgerunner]

Mark,

Thanks - that gives me the correct amounts.

[Mark]

Hi ridgerunner,

Great, glad that worked out. I should have also mentioned, you can add "FIFO basis" as a column in your Portfolio Editor. While viewing the Portfolio Editor, select "View / List Columns..." and put a check mark next to that field.