Portfolio Financial Maintenance
Overview of IL709
It may be necessary to change the financial information associated with a portfolio without performing all the steps that would otherwise be required. Adding to the accrued interest amount, for example, usually requires that you set up the portfolio with the proper accrual frequency and method then run the accrual program to update the amount. But Portfolio Financial Maintenance also allows you to change this amount manually if desired.
- From the DDI Connect main menu, double-click Financial Services
- Double-click Portfolio
- Double-click Transactions
- Double-click Portfolio Financial Maintenance. You will see this screen:
Enter the portfolio number and click Find or click the list icon to select from a list of portfolios in the system. You can also click the search icon to search for the portfolio, or enter the CUSIP # to search that way. When you have entered a portfolio number or CUSIP number, the screen will look like this:
Summary tab
When you click the Summary tab, you will see this screen:
The fields on this screen are read only, and include:
| Field | Description |
|---|---|
| Account | ID number of the master account for the selected portfolio record |
| Type | Number and description of the type for the selected portfolio record |
| Status | Current status of the selected portfolio record |
| Rate | Interest rate of the selected portfolio record |
| Effective | The rate earned after receiving a discount or paying a premium on commercial paper or corporate bonds as an investment changes hands. When your organization pays less or more principal to acquire a bond, you change the coupon rate paid. If a bond is earning a 5.75-percent rate of return and the market is trading at a lower rate, for example, your organization would have to pay a premium to bring the rate down. Your organization still earns 5.75 percent, but the premium paid makes the effective rate around 5 percent |
| Maturity date | Maturity date of the selected portfolio, if any |
| Call date | Date when a callable bond may be redeemed before its maturity date |
| Manager | Individual responsible for oversight of the selected portfolio, if applicable |
| Currency | Type of currency of the selected portfolio |
Fields 1 tab
When you click the Fields 1 tab, you will see this screen:
The following fields are available on this screen:
| Field | Description |
|---|---|
| Number units | Number of units in the selected portfolio. A bond, for example, would likely consist of only one unit, whereas a mutual fund might have several according to the number of shares owned. Number of units in the selected portfolio following the adjustment |
| Face value* | Face value of the selected portfolio following the adjustment |
| Cash invested* | Cash invested in the selected portfolio following the adjustment |
| Last interest date | Date of the last interest accrual for the selected portfolio following the adjustment |
| Accrued interest* | Accrued interest for the selected portfolio following the adjustment |
| Accrued interest YTD | Year-to-date accrued interest for the selected portfolio following the adjustment |
| Accrued interest TD | Accrued interest to date for the selected portfolio following the adjustment |
| Interest paid YTD | Interest paid year-to-date for the selected portfolio following the adjustment |
| Interest paid TD | Interest paid to date for the selected portfolio following the adjustment |
Fields marked with an asterisk (*) require a manual journal entry to adjust the general ledger
Fields 2 tab
When you click the Fields 2 tab, you will see this screen:
The following fields are available on this screen:
| Field | Description |
|---|---|
| Monthly prem/disc amt | Monthly premium/discount amortization on the purchase price of a bond following the adjustment |
| Prem/Disc balance* | Premium/Discount balance on the purchase price of a bond (after amortization) following the adjustment |
| Prem/Disc amort YTD | Year-to-date amortization of a premium/discount on the purchase price of a bond, following the adjustment |
| Prem/Disc amort TD | To-date amortization of a premium/discount on the purchase price of a bond, following the adjustment |
| Orig prem/disc bal | Premium/Discount on the purchase price of a bond (prior to amortization), following the adjustment |
| Gain/Loss total | Gain or loss when the portfolio investments (typically stocks) are sold. If the sale price is greater than the face value, a gain is realized. If it is less than the face value, a loss is realized. Gain or loss from the sale of portfolio investments, following the adjustment |
| Gain/Loss YTD* | Year-to-date gain or loss from the sale of portfolio investments, following the adjustment |
| First purchase date | Initial purchase date of the portfolio investment, following the adjustment |
| Last amortization date | Date of the most-recent amortization of premium/discount on the portfolio investments, following the adjustment |
Fields marked with an asterisk (*) require a manual journal entry to adjust the general ledger
When you have finished entering the information, click Save to retain your changes. You will see this message:
Click OK. You will be returned to the Portfolio Financial Maintenance screen.
