Investor Payout Job

  • Updated

Investor Payout Job

Overview

The Investor Payout job is used to create an investor payment. After you run this job, based on the investor's share in the investment order, an Investor Loan Transaction (ILT) is created, and the Transaction Code of the ILT changes from Active to Payment Approval. 

The job fetches only the loans with investment orders, where loan payment transactions exist, instead of fetching all the loan accounts irrespective of whether they have any investment orders (IO) and loan payment transactions (LPTs) exist or not.

Note:

It is recommended to run the IO Interest Accrual Job prior to processing investor payouts, so as to process only the loans that have investment orders, for calculating the returns for investors on their investment orders. The accrued interest is reflected on the investment order details page. 

Scenarios

The following scenarios explain how the Investor Payoutjob works:

Scenario 1: Before the Investor Payout job runs.

The following is the state before the Investor Payout job runs:

  • The Transaction Code for the ILT is Active. 

  • Interest Accrued on the investment order from the Last Accrual Date till the Current System Date is calculated as follows:

    Copy
    Interest Accrued = ((Remaining Investment Amount * Certificate Rate / 100)/365) * N

where N is the number of days from the Interest Accrual Start Date till the Current System date. 

  • Interest Balance is calculated as follows:

    Copy
    Interest Balance = Interest Posted - Interest Amount Paid

where Interest Amount Paid is the amount paid to the Investor and Interest Posted is calculated from the Start Date to the Last Interest Accrual Date. 

Note:

The interest balance is updated in real time, and even if multiple LPTs are processed in the same batch job, interest component is computed and paid each time.

  • The value of Income to be collected remains true for the investor who has sold the IO with Transfer Income as false, and the interest paid by the borrower is picked up by the Investor Payout job for payout to the investor who has sold the IO. However, the flag remains false for the investor who has sold 100% shares in IO with Transfer income true, and the interest paid by the borrower is picked up by the Investor Payout job for payout to the investor to whom the IO is sold.

Scenario 2: After the Investor Payout job runs.

The following events occur after the Investor Payout job runs:

  • Remaining Investment Amount, Accrued Interest, Interest Posted, Interest Amount Paid, Interest Balance, Principal Amount Paid, Late Fees Amount Paid, Total Amount Paid are updated.
  • The Transaction Code is changed to Payment Approval. 
  • Payout of the interest is done to the investor has sold the IO with transfer income false and the value of Income to be collected becomes false thereafter. However, the payout of the interest is done to the investor to whom the IO was sold with transfer income true, and the value of the Income to be collected becomes false for this investor thereafter.
Note:

To know how the Income To Be Collected flag affects the Investor Payout job runs, see Income To Be Collected flag.

After you run the Investor Loan Txn Sweep to ACH job, you can see that a NACHA file has been generated and the Sent to ACH and Sent to ACH on fields in the loan payment transaction page are populated.

Viewing the NACHA file

To view the NACHA file, perform the following steps:

  1. Login to your Salesforce account.
  2. Click the App Launcher.
  3. Search for CL Loan, and then click it.
  4. Click Documents.
  5. Go to Document Folders.
  6. Click Go!.
  7. Click View. The NACHA file is displayed for view.

In This Article