Importing generic transactions & IAMETH

[Good_Vibe]

My objective is to track sales by lot in order to maintain a current cost basis. To manage our portfolio, I obtain transactions via EXCEL from our custodian (who won't allow direct access via "Retrieve Transactions" to download transactions directly into Fund Manager) and "revise" them to conform to the following generic specification:

IACCT,MM/DD/YY,BNUM,MEMO,XX,ANUM,XX,SYMB,CUSIP,PORT,CNUM,TRAN!REM SELL

I want to adopt a "by lot" accounting method (IAMETH value 2). How do I include the lot date (or some other lot identifier) so that Fund Manager knows where to take the shares?

Haven't been able to find anything in the generic transaction documentation which allows me to specify the purchase date (or some other identifier) of the lot which is to be source of the shares being sold. Right now, without IAMETH, Fund Manager simply applies FIFO for all sales.

Look forward to hearing from you and, as always, appreciate you help.

[Mark]

Hello Good_Vibe,

Unfortunately Fund Manager doesn't support "importing" your lot assignments. The IAMETH value just assigns the accounting method for new investments, but for Specific Lot you must still manually specify the lots from within the program. Right mouse click on an investment, and choose "Investment Data / Specify Lots...".