🖶

Setting Up Rate Sheets for Deposits

You can set up rate sheets for interest-bearing deposits on the Rate Sheet Set page.

  1. Select Pricing > Rate Sheets from the menu.
  2. Open the rate sheet set that you want to work with by selecting its name in the Rate Sheet Set Name column.
  3. Update the Funding Date, if needed.
    This date determines the appropriate value of funds for a deposit. You can use the calendar selection or manually enter a date.
  4. Update the Effective Date, if needed.
    This date represents when the current rate sheet goes into effect. You can use the calendar selection or manually enter a date.
  5. Select ""Add.
    You can also select an existing rate sheet to modify from the list.
    The Add Rate Sheet dialog box opens.
  6. Enter a Name.
  7. Select Deposit as the Type.
  8. Select a Product.
  9. Select Add.
  10. Enter a percentage in the Target ROE field.
  11. Enter the Term.
  12. Enter Comments as needed.
  13. Update the tier table as needed.
    You can edit the amounts in the Lower Tier column, and the percentages in the Rate Paid column. You can also add or delete tier rows.
  14. Select Save when the tiers and rates are set.
    The remaining calculations appear.
Select Export to export the rate sheet to a .csv file when you are ready to distribute it.