Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

generic import ... dist_f

Questions about updating prices or transactions in Fund Manager

Postby mcrews » Wed Mar 25, 2020 9:02 am

Hello,

Slowly dialing in my generic import method and while I'm getting most things working as expected I'm struggling with importing advisor fees. In general all money movement is in cash and then swept into a money market fund.

All div_d and div_i are being imported and recorded correctly into the default cash. Here is an example of what isn't:

12345,REP,2/12/2020,2/12/2020,,DIST_F,,ADVISOR MANAGEMENT FEE 10012019 TO 12312019 115218.89 ,CASH,,0,-100.00,Cash

Here is the import format:

ACCT,XX,MM/DD/YY,XX,XX,TRAN,BNUM,MEMO,SYMB,XX,CNUM,ANUM,XX !REM CashMovement

Thank you for any help resolving this one.

Matthew
mcrews
 
Posts: 21
Joined: Fri Nov 02, 2012 11:13 am

Postby Mark » Wed Mar 25, 2020 9:13 am

Hi Matthew,

One issue is that your value for BNUM is blank. You must have some number for ANUM, BNUM, and CNUM, even if they are 0. So, try this instead:

12345,REP,2/12/2020,2/12/2020,,DIST_F,0,ADVISOR MANAGEMENT FEE 10012019 TO 12312019 115218.89 ,CASH,,0,-100.00,Cash

Please note, this will record a negative valued distribution, but it won't sell shares to pay for it. If you're trying to sell cash to pay a fee, it needs to be a reinvested distribution of type account fee, instead of distributed. If you want this, it would be:

12345,REP,2/12/2020,2/12/2020,,REINV_F,-100,ADVISOR MANAGEMENT FEE 10012019 TO 12312019 115218.89 ,CASH,,0,1,Cash
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 9234
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby mcrews » Wed Mar 25, 2020 9:29 am

Thank you for the reply ... i'm trying to keep the accounting correct between cash and sweep cash. The second suggestion works for me:

12345,REP,2/12/2020,2/12/2020,,REINV_F,-100,ADVISOR MANAGEMENT FEE 10012019 TO 12312019 115218.89 ,CASH,,0,1,Cash

Thanks again,

Matthew
mcrews
 
Posts: 21
Joined: Fri Nov 02, 2012 11:13 am

Postby mcrews » Wed Mar 25, 2020 10:09 am

Now that I've updated the TRAN code I tried it with money market interest income but it's behaving weird. This is what I have using the same string format as above:

12345,REP,2/28/2020,2/28/2020,,REINV_I,0.07,"EXPANDED BANK DEPOSIT 022820 1,749 ",9999332,,0,1,Cash

It's not picking it up as a transaction. I can't find anything recorded so as far as I can tell it's a new transaction.

Thank you,

Matthew
mcrews
 
Posts: 21
Joined: Fri Nov 02, 2012 11:13 am

Postby mcrews » Wed Mar 25, 2020 10:16 am

grrr ... I found it. It was the comma in 1,749. notepad added the quotes but not the csv file.

Thank you for your time as always.
mcrews
 
Posts: 21
Joined: Fri Nov 02, 2012 11:13 am


Return to Prices and Transactions

Who is online

Users browsing this forum: No registered users and 3 guests

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2020 Beiley Software, Inc. All rights reserved.