Interest Earned Allocation Calculation
The following applies to interest earned calculation for the interest earned allocation job:
•  The blended earned interest amount entered in the Interest Earned field on the Interest Earned Allocation dialog box is allocated to each active registry investment account based on the average monthly balance for each account.
•  A registry investment account is active if its investments have a balance greater than zero.
•  Uninvested registry account amounts are not included in the calculation.
The interest earned allocation job uses the following calculation process:
1. The job identifies all registry investment accounts based on the case types selected on the Interest Earned Allocation dialog box.
2. If you selected registry account types on the Interest Earned Allocation dialog box, the job only allocates interest to registry accounts with the selected registry account types. If no registry account types are selected, then all registry account types are allocated interest for the period.
3. Cases that have the Exclude from Interest Allocation check box selected on the Edit Investment dialog box are excluded from calculation. If a case has multiple investment registry accounts, only those investment accounts with the Exclude from Interest Allocation check box selected are excluded.
4. On all remaining registry accounts, the monthly average balance for each account is calculated based on the start and end dates entered on the Interest Earned Allocation dialog box.
5. The balance at the beginning of the date range is added to the account balance at the end of the date range, then divided by two to determine the account's average balance.
6. The average balance for all selected investment registry accounts is totaled.
7. The interested earned for each investment registry account is then calculated as follows: Each registry account's average balance is divided by the total average balances for all registry accounts, then multiplied by the interest earned.
8. The job allocates the total interest earned amount, with total rounding to be limited to +/- $0.05.
9. An interest deposit transaction for the calculated amount is created and loaded to the Interest Earned page for each investment registry account.
10. If a case has multiple investment registry accounts, a separate interest deposit transaction is created for each account.