Add Investment Subsidiary

These steps explain how to add new investment records to the system.

 

  1. Launch Tool #993 INV 1: Work With CU Investments.

  2. Select Add.

  3. Create Investment ID of your choice. (i.e. CD0001, MBS200, FHLB06, etc.)

  4. Select Investor Type if Configured. Learn more.

  5. Input Original Par (Original Principal).

  6. Enter Description of your choosing; Investment Type description will prefill, you can retype the description.

  7. Enter in FDIC and/or CUSIP information (if applicable, Information field not required).

  8. Current Par (Original Principal minus any principal paydowns).

  9. Enter FASB Code (Held to Maturity [HTM], Trading Account [TRA], Available for Sale [AFS]).

  10. Enter Misc. additional investment information (if applicable).

  11. 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.

  12. Enter Yield. This step is not required, as it is used for information 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.

  13. Credit rating, Pledged, and Pledged to are optional informational fields only.

  14. Enter # of units. Generally 1, but it represents the price paid per unit for this investment.

  15. Enter Current Unit Price -- Price paid per unit.

    • EXAMPLE: 2 units @ 250,000.00 = 500,000.00 Current Par

  16. Enter Quote Date. Generally the same day as the settlement date, but with more complex investments this could be different.

  17. Enter Settlement Price, which is the price paid for purchase.

    • You must enter the amount and 6 (decimal positions) zeroes after your period to get the correct amount entered.

  18. Enter Settlement Date. This is generally the same as the Purchase Date.

  19. Enter Purchase Date. This is generally the same as the Settlement Date.

  20. Enter Maturity Date.

  21. Enter Review Date. (Only if applicable, not a required field).

  22. Select Call Date. (Only if applicable, not a required field as it is informational only).

  23. Select Coupon Reset Dates. (Only if applicable, not a required field as it is informational only).

    • Select pencil to input rates and dates.

  24. Select Contact, Institution, Safekep, or Broker. (Only if applicable, not a required field as it is informational only).

  25. Enter Last Accrued Date. This is generally the date of purchase.

  26. Select Calc Type.

  27. Select Accrual Income Based On "Premium or Discount," if applicable.

    • Enter Monthly Amount of premium or discount.

  28. Select Variable Rate Code, if applicable.

  29. 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 and 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.

  30. Select Add/Update.

    • NOTE: You may see error messages below in red. Most often this is due to an interest rate below 1%, but otherwise due to a "required field" error. Correct error or Add/Update if rate is correct.

  31. Enter in Principal amount of purchase as a debit to the Principal Balance field.

  32. If applicable, enter in Accrued amount as a debit to the Accrued Balance field.

  33. Enter in the settlement G/L in the Misc 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).

    • 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.

  34. 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.

    • Edit current J/E if only the Accrued balance needs to be posted to the General Ledger by deleting principal amount for J/E.

    • Delete current J/E if all entries are posted already to the General Ledger.

  35. 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.