Generic Import of TXIN for CASH account issue

[rjwerning]

I'm currently evaluating FM, and have went through the exercise of exporting my historical data from the previous software I was using and importing it into FM. After a few tries to figure out the details of what I needed to do, I have everything importing correctly with the exception of my deposits into the CASH account.

The deposits import correctly, but the OOP Cost Value and Tax Cost Basis value end up as some random high values. This causes the balance in the CASH account to become way out of sync with what the actual value is. This happens with all of the TXIN transactions, not just a limited few.

Example:

format: MM/DD/YY,SYMB,TRAN,ANUM,BNUM,CNUM,MEMO
line: 01/06/2014,CASH,TXIN,1.0,452.94,22919.76,Employeer Contribution

What shows up in the Transfer In transaction is the following:
Date: 1/6/2014
Shares: 503.27
Market Value: 503.27
OOP Cost value: 11,788,108.31
Date acquired: 1/6/2014
Value: 11,788,108.31

I'm not sure if I'm doing something incorrect, or there is an issue with the generic import. But would appreciate any assistance you can offer. I've manually corrected several of my portfolios as there weren't many transactions. But for my main account, there is no way I'm going to go back and correct 20 years worth of deposits. If I can get this issue resolved I'll be making my purchase of FM.

Thank you,
Rich

[Mark]

Hi Rich,

I believe the problem is your CNUM value. The CNUM value for a TXIN transaction is the cost per share. For CASH you probably want this at 1.0, instead of 22919.76. I'm not sure if you had a typo below (or maybe it was a different transaction), but when I test imported the example you showed of:

format: MM/DD/YY,SYMB,TRAN,ANUM,BNUM,CNUM,MEMO
line: 01/06/2014,CASH,TXIN,1.0,452.94,22919.76,Employeer Contribution

I get:

Date: 1/6/2014
Shares: 452.94
Market Value: 452.94
OOP Cost value: 10,381,276.09
Date acquired: 1/6/2014
Value: 10,381,276.09

The reason is that a cost of 22919.76 times 452.94 shares is 10,381,276.09. Instead, if you change the import line to be:

01/06/2014,CASH,TXIN,1.0,452.94,1.0,Employeer Contribution

You will get what you're expecting, where you have a Transfer In of 452.94 shares at a value/cost also 452.94. There are actually 2 different supported formats for specifying cost of a TXIN. You are using the "Format 1" option, but with "Format 2" you can specify a different date for your OOP/Tax cost basis. See the documentation for TXIN here:

https://www.fundmanagersoftware.com/hel ... neric.html

You can use a TXIN to record a deposit. You can also just use a BUY transaction, which are easier. Personally I prefer BUY for a cash deposit, but either one works. If you wanted to use a BUY, it would be:

01/06/2014,CASH,BUY,1.0,452.94,0.0,Employeer Contribution

For a BUY, CNUM is the commission, so 0.0 is what you want here, instead of the cost per share for a TXIN.

[rjwerning]

Ok, that solved it - thank you. I must have been looking at the TXOUT, in my head the CNUM didn't matter when using TXIN. I had to massage the export from my old software to replace the existing CNUM with 1.0, it's not very friendly for doing exports.

Thanks for the heads up on the BUY, I may stick with the TXIN for now - not sure I want to go back and remove / import the transactions again.

Rich