Portfolio Maintenance
Contents
Overview of IL701
Portfolio Maintenance allows you to create a new portfolio record or modify an existing one.
- From the DDI Connect main menu, double-click Financial Services
- Double-click Transactions
- Double-click Portfolio Maintenance. You will see this screen:
Adding a New Portfolio
To add a new portfolio, click the Add button on the toolbar. You will see this screen:
At the top of the screen, the portfolio number is displayed. This field is automatically populated with the next available portfolio number and cannot be modified. Also displayed is the CUSIP# of the portfolio, if applicable. This field is also display only.
There are several tabs available on this screen.
Settings tab
The following fields are available on the Settings tab:
Field | Description |
---|---|
Account | ID number of the master account for this portfolio record. Type the account number or click the search icon to locate the account. |
Type | Click the drop down arrow to select from a list of active portfolio types in the system |
Rate | Interest rate for this portfolio |
Effective rate | Interest rate on the portfolio investment after factoring in the premium or discount, if any |
Maturity date | Date of investment maturity, if applicable. Enter the date you wish to use. You can type it in mm/dd/yyyy format or click the calendar icon to select the date |
Call date | Date when a callable bond may be redeemed before its maturity date. Enter the date you wish to use. You can type it in mm/dd/yyyy format or click the calendar icon to select the date |
Manager | Click the drop down arrow to select from a list of active portfolio managers in the system |
Currency | Type of currency, if indicated, of the funds invested under the selected portfolio. Click the drop down arrow to select from a list of active currency codes in the system |
Interest Receipts tab
You will see this screen when you click the Interest Receipts tab:
The following fields are available on this screen:
Field | Description |
---|---|
Frequency | Interest-accrual frequency for this portfolio. Click the drop down arrow to select the appropriate frequency |
Computation | Calculation used to determine interest income. The following abbreviations are used in this formula:
|
Expect int amount | Estimated amount of interest income to be earned each time this portfolio pays interest |
Expect int date | Date when interest will be paid on this portfolio. Based on various combinations of interest frequency codes, maturity dates, and purchase dates |
General Ledger tab
When you click the General Ledger tab, you will see this screen:
The following fields are available on this screen:
Field | Description |
---|---|
Cash | General-ledger account affected by cash transactions for the selected portfolio record |
Income | General-ledger account affected when interest income associated with a particular portfolio record is realized |
Principal | General-ledger account affected by principal transactions for the selected portfolio record |
Interest | General-ledger account affected when interest income is calculated and when interest is paid. The realization of interest income will increase this general-ledger account while the receipt of interest will decrease this general-ledger account. Typically a receivable account |
Premium/Discount | General-ledger account that holds the Premium/Discount balance associated with a particular portfolio. This balance will move closer to $0.00 as the portfolio record reaches maturity |
Premium | General-ledger account used when premium amounts are amortized |
Discount | General-ledger account used when discount amounts are amortized |
Reference Information tab
When you click the Reference Information tab, you will see this screen:
The following fields are available on this screen:
Field | Description |
---|---|
Investee # | Investment number assigned by issuer |
Safekeep | Safekeeping receipt number assigned by the institution holding the investment |
CUSIP | An identification number assigned to all stocks and registered bonds. The Committee on Uniform Securities Identification Procedures (CUSIP) oversees the entire CUSIP system. This number is used when buy and sell orders are recorded |
Moody | Risk rating assigned by Moody’s Investment Rating Service |
Standard/Poor | Risk rating assigned by Standard & Poor’s Investment Rating |
Market price | Most current market price per unit. Typically relevant when portfolio consists of stocks |
Market date | Date the most recent market price was entered. Enter the date you wish to use. You can type it in mm/dd/yyyy format or click the calendar icon to select the date |
When you have finished entering the information, click Save to retain your changes.
Editing an Existing Portfolio
To edit an existing portfolio, you can type the portfolio number in the field and click Find, or you can click the list icon to select from a list of portfolios in the system. If applicable, you can also type the CUSIP# to search by that information. Once you select the portfolio you wish to work with, the screen will appear as such:
Make the changes you wish to make, and click Save when you are finished.