Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

how do you include accrued interest in a bond upload transac

Questions about updating prices or transactions in Fund Manager

Postby fundsankore » Wed Jun 07, 2017 1:53 am

I uploaded bond transactions and found out that i cannot include accrued interest into the function
fundsankore
 
Posts: 12
Joined: Wed Jun 07, 2017 1:01 am

Postby Mark » Wed Jun 07, 2017 8:35 am

Hi fundsankore,

How are you entering/importing transactions? If you're using the Generic transaction import, record paid bond interest as a negative valued interest type distribution. See the DIST_I transaction code.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby fundsankore » Wed Jun 07, 2017 8:59 am

so we just tried it with the distribution but its not reflecting neither can i see the reduction in cash
fundsankore
 
Posts: 12
Joined: Wed Jun 07, 2017 1:01 am

Postby Mark » Wed Jun 07, 2017 9:34 am

Did you get the negative valued distributed distribution imported okay? Do you have a default cash account assigned? When you did the import, did you leave on the option to automatically enter a corresponding entry in the default cash account?
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby fundsankore » Wed Jun 07, 2017 12:18 pm

Yes Mark,
I did all.
fundsankore
 
Posts: 12
Joined: Wed Jun 07, 2017 1:01 am

Postby Mark » Wed Jun 07, 2017 8:09 pm

Did the interest distribution get recorded? If so, and you have a default cash account, you should also see the cash withdrawal. If it didn't get recorded, what did your data line look like in the import file, and what format string did you use?
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby fundsankore » Thu Jun 08, 2017 1:21 am

Hi Mark,
Below is the upload string:
MM,DD,YY,SYMB,TRAN,ANUM,BNUM,CNUM,DIST_I,BONDCOUP,BONDFREQ,BONDMAT

Below is the upload sample:
06,19,13,15.10 27-APR-2017,BUY,106.010958936033,2000000,0,-4351306.167934,15.1,6,04/27/2017
fundsankore
 
Posts: 12
Joined: Wed Jun 07, 2017 1:01 am

Postby Mark » Thu Jun 08, 2017 6:45 am

Hi fundsankore,

You can't do a BUY and a DIST_I on the same transaction. They are both transaction codes, and go in the TRAN key. So, do it as 2 transactions, like:

Format String:
MM,DD,YY,SYMB,TRAN,ANUM,BNUM,CNUM,BONDCOUP,BONDFREQ,BONDMAT

File Import:
06,19,13,15.10 27-APR-2017,BUY,106.010958936033,2000000,0,15.1,6,04/27/2017
06,19,13,15.10 27-APR-2017,DIST_I,-4351306.167934,0,0,15.1,6,04/27/2017
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby fundsankore » Thu Jun 08, 2017 9:42 am

Thank you Mark,
I get it now.
fundsankore
 
Posts: 12
Joined: Wed Jun 07, 2017 1:01 am

Postby fundsankore » Fri Jun 09, 2017 12:48 am

Hi Mark,

We will like to also know how to account for amortization on a daily basis.
The bonds we have in our portfolio are accounted using held to maturity.
we need to amortize for premiums and discounts on a daily basis.

we cannot find book value option in the performance reporting which will adjust for daily premiums/discounts

Kindly help
fundsankore
 
Posts: 12
Joined: Wed Jun 07, 2017 1:01 am

Postby Mark » Fri Jun 09, 2017 5:29 am

Hi fundsankore,

Right mouse click on your bond, and choose "Investment Data / Accretion/Amortization...". You can either enter the amounts yourself, or use the "Calculate..." button to calculate the amount. Press "Help..." in this dialog for a detailed explanation.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby fundsankore » Fri Jun 09, 2017 9:14 am

Thank you Mark,

Please how do we upload for TBills?
fundsankore
 
Posts: 12
Joined: Wed Jun 07, 2017 1:01 am

Postby Mark » Fri Jun 09, 2017 7:45 pm

Hi fundsankore,

To import accretion or amortization using the Generic transaction import, see the DIST_A and DIST_T TRAN values.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby fundsankore » Mon Jun 12, 2017 1:56 am

Hi Mark,
we uploaded the treasury bills but the values are not changing
i will assume the end values should be increasing as we approach maturity in order to reach face value at maturity date

Also, we just realized that the bond is not amortizing either
we want a case where we can value the bond and at maturity, we get the face value

kindly help
fundsankore
 
Posts: 12
Joined: Wed Jun 07, 2017 1:01 am

Postby Mark » Mon Jun 12, 2017 9:13 am

Hi fundsankore,

Did you update their prices? The value of any investment is the number of shares owned times the closing price. Assuming your shares are correct, then you need to update the price to show the correct new market value.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Next

Return to Prices and Transactions

Who is online

Users browsing this forum: No registered users and 14 guests

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