Etrade interest imports creating dummy investments

[CGB]

Hi Mark,

When importing Etrade debit interest, FM creates a redemption (sale) in the default cash account, and FM creates a new investment "()" with negative account fees. A similar thing happens with cash account earned interest, where FM creates a new investment named "earned interest on credit balance", with a number for a symbol.

Please help.

CGB

[Mark]

Hi CGB,

Could you email me an example log file from a transaction retrieve where this happens? See "Help / Logs / Transaction Retrieve...". Please send both the "Raw" and "Parsed" versions. To make sure your logs are for that account, just retrieve only that one account, and cover the date range where this issue happens.

[CGB]

Hi,

I cannot find "Help / Logs / Transaction Retrieve..." in my version.

Really only happened once because I just started importing transactions from Etrade, so don't know if it will always happen.

[Mark]

Hi CGB,

In older versions, these log files are available here:

C:\Users\<username>\AppData\Roaming\Fund Manager

as "ofxretr.txt" and "xmldump.txt"

[CGB]

Mark,

The files appear to only have stock holdings, and not transactions.

Does the log only include the most recent transaction retrieve because I did a subsequent retrieve?

Also, how does one read the date ranges in the files?

CGB

[Mark]

Hi CGB,

Yes, the log files are from the most recent transaction retrieve only.

If you request a date range where there were no transactions you would only see positions, and not any transactions.

The transactions will have a date (not a range), something like:

DTTRADE (20170627160000.000[-5:EST])

where the date is read from the beginning as YYYYMMDD and then the time is after that. So, in the above example it would be June 27, 2017.

[CGB]

Hi Mark,

Thank you.

For an interest distribution on 5/29/18, FM had the pennies come out of a file created by FM in 2016 that currently has no previous transactions, named: "INTEREST ON CREDIT BALANCE 0.00% 02/15/2013", with symbol: "00099A109", and with file name: "00099A109.dat".

Maybe I should delete this odd old file and then FM might use the cash account and reinvest the dividend?

However, on 8/26/18 their were two small debit interest payments that FM made a new file for during the retrieve with file name: "autoname.dat" with no security name or symbol.

I sent you the retrieve files for this date by forum PM, but not sure if that is working because sitting in the outbox.

CGB

[Mark]

Hi CGB,

When retrieving transactions, the CUSIP is used. The filename and symbol do not matter. FM looks for investments in the sub-portfolio being retrieved and matches up incoming transactions with any existing investments that have the matching CUSIP. You can see the CUSIP in the "Investment Properties..." dialog, or you can add it to the list view in the Portfolio Editor.

I didn't see a 8/26/18 transaction in your log files. I suspect you meant 7/26/18? Yesterday was 8/26/18, and that was a Sunday. Here is the 7/26/18 transaction:

Code: Select all

- INCOME
   - INVTRAN
      - FITID (180726_INT_0)
      - DTTRADE (20180726170000.000)
      - MEMO (INT - INTEREST ON CASH BALANCE - AT  0.039% 06/26 THRU 07/25)
   - SECID
      - UNIQUEID (B00099A109)
      - UNIQUEIDTYPE (CUSIP)
   - INCOMETYPE (INTEREST)
   - TOTAL (0.02)
   - SUBACCTSEC (MARGIN)
   - SUBACCTFUND (MARGIN)

You can see this has a CUSIP of B00099A109. The log file shows this CUSIP has these properties:

Code: Select all

- SECINFO
   - SECID
      - UNIQUEID (B00099A109)
      - UNIQUEIDTYPE (CUSIP)
   - SECNAME (INTEREST ON CREDIT BALANCE 0.00% 02/15/2013)
   - TICKER (00099A109)
   - UNITPRICE (0.000000)
   - DTASOF (20180824180200.000)
- PARVALUE (100)
- DEBTTYPE (ZERO)

So, if you want this interest to go into your default cash account investment, make sure your default cash account investment has a CUSIP of B00099A109. If no existing investment has this CUSIP, FM will create one for you when it imports the retrieved transactions. You can see this when previewing the importing transactions in the "New Investment" column. If it shows "Yes" for a transaction here, then it is going to create a new investment because it couldn't find a match with an existing investment.

[CGB]

Hi Mark

So I should give my default cash account that CUSIP number so FM does not make a new investment producing interest income.

What do I do about the two negative debit interest payments from the default cash account on 6/26/18 where FM created a corresponding account named "autoname.dat" without any CUSIP number?

Thank you.
CGB

[Mark]

Hi CGB,

Yes, assign that CUSIP to your cash investment.

Fix up the prior transactions. Just record the interest in your cash investment, and close the other investments if they only contained these interest transactions.

[CGB]

Hi Mark,

If FM only uses the CUSIP number for transaction imports, then how does FM match dividends for stock investments without a CUSIP number in the properties box for several of my existing investments?

Thanks.
CGB

[Mark]

Hi CGB,

When importing, FM will look for matching investments based off Symbol if the CUSIP is empty. You're better off recording the CUSIP if you're retrieving transactions. Any new investments created by FM from a transaction retrieve will have the CUSIP filled in.