how do you include accrued interest in a bond upload transac

[fundsankore]

I uploaded bond transactions and found out that i cannot include accrued interest into the function

[Mark]

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.

[fundsankore]

so we just tried it with the distribution but its not reflecting neither can i see the reduction in cash

[Mark]

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?

[fundsankore]

Yes Mark,
I did all.

[Mark]

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?

[fundsankore]

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

[Mark]

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

[fundsankore]

Thank you Mark,
I get it now.

[fundsankore]

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

[Mark]

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.

[fundsankore]

Thank you Mark,

Please how do we upload for TBills?

[Mark]

Hi fundsankore,

To import accretion or amortization using the Generic transaction import, see the DIST_A and DIST_T TRAN values.

[fundsankore]

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

[Mark]

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.