Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Custom Field to Account for Retained Income

Questions about updating prices or transactions in Fund Manager

Postby jkitchens » Mon Feb 01, 2016 3:16 am

Some accounts I manage are owned by trusts. The trustees need me to keep up with undistributed income and gains passed through to the trust as taxable income from the underlying investments. This enables them to determine the character of future distributions -- income or principal -- received from the investments.

Is there a way to use custom fields within FM to accommodate this need of the trustees?
jkitchens
 
Posts: 16
Joined: Sun Jan 31, 2016 4:43 pm

Postby Mark » Mon Feb 01, 2016 9:41 am

Hi jkitchens,

Do you just need to keep track of 2 values, or do you need to keep track of many values/dates? If you just need to keep track of 2 values per investment, then you can use the Custom Investment properties. Use "Options / Custom Investment Properties..." to define the label for the 2 values you want. Use "Investment Properties... / Custom" to set the actual values for each investment.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby jkitchens » Mon Feb 01, 2016 8:35 pm

Mark, I need to keep track of these 3 numbers for each investment:
[*]Cost
[*]Tax Basis
[*]Undistributed Income

The program already keeps up with Cost and Tax Basis. So it seems I only need to use Custom Investment Properties for Undistributed Income.

I went into the Custom Investment Properties' screen and changed the label for Custom1 to Undistributed Income. Then I selected Number as the type. I was confused about the Combination Method field. I'm not really sure where I should go from here.

Thanks for your help! I think your program is great!
jkitchens
 
Posts: 16
Joined: Sun Jan 31, 2016 4:43 pm

Postby Mark » Mon Feb 01, 2016 8:40 pm

Hi jkitchens,

You probably want a combination method of "Sum", and set the digits to "2". This means if you display a report, sub-totals and totals will be calculated by summing from all the investments.

After this, go to "Investment Properties... / Custom" to assign a value to each investment.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby jkitchens » Tue Feb 02, 2016 4:39 am

This works great. Thanks!
jkitchens
 
Posts: 16
Joined: Sun Jan 31, 2016 4:43 pm

Postby jkitchens » Sat Feb 06, 2016 6:07 pm

Is it possible to import values for custom fields into FM? How about exporting them? Thanks. Jim
jkitchens
 
Posts: 16
Joined: Sun Jan 31, 2016 4:43 pm

Postby Mark » Sun Feb 07, 2016 11:40 am

Hi Jim,

Yes, you can do this when import transactions using the Generic import command. See "File / Import / Transactions / Generic...". Press "Help" in that dialog. See the:

CIP01
...
CIP10

keys. Those same keys can be used for import or export of these custom investment properties.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby jkitchens » Sun Feb 07, 2016 12:15 pm

Mark it seems that CIP01-CIP10 can only be imported for new accounts, not existing ones. Am I right about this? Is there a workaround for this? Thanks. Jim
jkitchens
 
Posts: 16
Joined: Sun Jan 31, 2016 4:43 pm

Postby Mark » Sun Feb 07, 2016 12:47 pm

Hi Jim,

Yes, you are correct. These only apply to new investments.

The workaround isn't too pretty, but you could export all prices/transactions from an existing investment, add the CIPXX values, and re-import into a new investment.

The other workaround is to edit the custom investment properties manually on your existing investments.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby jkitchens » Sat Jan 28, 2017 6:23 am

Mark, I'm checking in to see if you have or would consider modifying FM so that custom fields can be imported for all accounts, including existing ones. Thanks!
jkitchens
 
Posts: 16
Joined: Sun Jan 31, 2016 4:43 pm

Postby Mark » Mon Jan 30, 2017 8:20 am

Hi jkitchens,

Thanks for the feedback. I can see that being useful. We can try to add this in a future update.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ


Return to Prices and Transactions

Who is online

Users browsing this forum: No registered users and 15 guests

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