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 Investment Type if configured. (Learn more.)

  5. Input Original Par (Original Principal).

  6. Enter a Description of your choosing. The Investment Type will auto-fill the description, but you can edit it.

  7. Enter in FDIC and/or CUSIP information (if applicable).

  8. Enter the 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 additional investment information (if applicable) in the Misc info field.

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

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

  14. Enter the # of units.

    • Generally 1, but it represents the price paid per unit for this investment.

  15. Enter the Curr Unit Price (the price paid per unit).

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

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

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

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

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

  20. Enter the Maturity date.

  21. Enter a Review Date. (This is a required field. Enter in 1 month prior to maturity or another date you choose.)

  22. Select Call dates by using the pencil icon next to the checkbox. (Only if applicable, not a required field as it is informational only).

  23. 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).

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

  25. Enter a date for Last accrued. This is generally the date of purchase.

  26. Select the Calc type.

  27. Select Accrual income based on Premium or Discount, if applicable.

    • Enter the Monthly amount of premium or discount.

  28. Select Variable rate code, if applicable.

    • Then, select the Variable rate date.

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

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

  31. Enter the principal amount of purchase as a debit to the Principal balance field.

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

  33. 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).

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

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

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

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

      1. Highlight the entry and select the Delete option. Then select Delete entries.

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