Add Investment Subsidiary
These steps explain how to add new investment records to the system.
-
Launch Tool #993 INV 1: Work With CU Investments.
-
Select Add.
-
Create Investment ID of your choice. (i.e. CD0001, MBS200, FHLB06, etc.)
-
Select Investment Type if configured. (Learn more.)
-
Input Original Par (Original Principal).
-
Enter a Description of your choosing. The Investment Type will auto-fill the description, but you can edit it.
-
Enter in FDIC and/or CUSIP information (if applicable).
-
Enter the Current Par (Original Principal minus any principal paydowns).
-
Enter FASB Code (Held to Maturity [HTM], Trading Account [TRA], Available for Sale [AFS]).
-
Enter additional investment information (if applicable) in the Misc info field.
-
Enter Coupon rate. This will be the rate used in the accrual calculation. This is required even if the investment doesn't accrue.
-
NOTE: You will need to enter the whole number, period, then three decimal positions for accuracy of input. For example, if your rate is 5.50%, you will enter in 5.500.
-
-
Enter Yield. This step is not required. The information is used as a projection of the true return rate for this investment.
-
NOTE: You will need to enter the whole number, period, then three decimal positions for accuracy of input. For example, if your rate is 5.50%, you will enter in 5.500.
-
-
Credit rating, Pledged, and Pledged to are optional informational fields only.
-
Enter the # of units.
-
Generally 1, but it represents the price paid per unit for this investment.
-
-
Enter the Curr Unit Price (the price paid per unit).
-
EXAMPLE: 2 units @ 250,000.00 = 500,000.00 Current Par
-
-
Enter the Quote date. Generally the same day as the settlement date, but with more complex investments this could be different.
-
Enter the Settlement Price, which is the price paid for purchase.
-
You must enter the amount with 6 decimal positions after your period to get the correct amount entered. For example, for a $250,000.00 investment, you will input 250000.000000
-
-
Enter the Settlement date. This is generally the same as the Purchase date.
-
Enter the Purchase date. This is generally the same as the Settlement date.
-
Enter the Maturity date.
-
Enter a Review Date. (This is a required field. Enter in 1 month prior to maturity or another date you choose.)
-
Select Call dates by using the pencil icon next to the checkbox. (Only if applicable, not a required field as it is informational only).
-
Select Coupon reset dates by using the pencil icon next to the checkbox. (Only if applicable, not a required field as it is informational only).
-
Select Contact, Institution, Safekeep, or Broker. (Only if applicable, not a required field as it is informational only).
-
Enter a date for Last accrued. This is generally the date of purchase.
-
Select the Calc type.
-
Select Accrual income based on Premium or Discount, if applicable.
-
Enter the Monthly amount of premium or discount.
-
-
Select Variable rate code, if applicable.
-
Then, select the Variable rate date.
-
-
Select G/L code or enter in appropriate G/Ls for Principal, Discount, Premium, Income, Accrual, and Gain/loss. If you do not have Premium or Discount, your principal G/L will be entered in those G/L fields as the system requires a G/L even if no premium or discount occurs.
-
Select Add/Update.
-
NOTE: You may see error messages below in red. Most often this is due to an interest rate below 1%, or otherwise due to a "required field" error. Correct the error or use Add/Update if rate is correct.
-
-
Enter the principal amount of purchase as a debit to the Principal balance field.
-
If applicable, enter the accrued amount as a debit to the Accrued Balance field.
-
Enter in the settlement G/L in the Miscellaneous G/L or Settlement value field as a credit to offset. This will be contingent on where your settlement was posted (i.e. corporate or offsetting suspense G/L).
-
Select Create J/E.
-
If you already posted the settlement to your principal G/L, you still need to Create J/E in order for the detail to be loaded into the subsidiary record.
-
-
Launch Tool #61 Create/Post GL Journal Entries to post, delete, or edit J/E.
-
Post current J/E if all entries need to be posted to the General Ledger.
-
Highlight the entry and select the Post option. Then select Post.
-
-
Edit current J/E if only the Accrued balance needs to be posted to the General Ledger by deleting the principal amount for the J/E.
-
Highlight the entry and select the Change option. Make the changes, then select Post.
-
-
Delete current J/E if all entries are posted already to the General Ledger.
-
Highlight the entry and select the Delete option. Then select Delete entries.
-
-
-
Launch Tool #993 INV 1: Work With CU Investments and verify that the investment has been loaded and Subsidiary Detail is posted to the sub ledger.
Learn More
![]() |
Learn more about working with investments. |
![]() |
Learn more about adjusting subsidiaries. |