NetLoan - Loan Statements

Overview

This article reviews how to generate loan statements within NetLoan. Using the NetLoan statements feature, you can generate PDF loan statements to send to customers.

Prerequisites

In order to generate loan statements, you must first have loan records that are in a "commenced" status.

Step-by-Step Process

1. Before generating statements, you'll need to create a NetLoan Statement Template. Navigate to NetLoan > NetLoan Setup > Manage Statement Templates. This will bring you to the list of your loan statement templates. To create a new template, select "New NetLoan Statement Template". View full size
2. Edit the template as desired. Give the template a name, as well as any other customization. The following customizations are available:
   1. Filter down which loans are eligible for generating statements. This is done by adding the saved search to the Statement Eligible Loan Saved Search field.  
   2. Customize the amortization schedule printed in the statement. This is done by adding a saved search to the Amortization Schedule Saved Search field. The default Netgain saved search that can be used as a starting point for this field is the "NetLoan Statement Amortization Schedule" search. 
   3. Customize the recent G/L activity presented in the statement. This is done by adding a saved search to the Recent G/L Activity Saved Search field. The default Netgain saved search that can be used as a starting point for this field is the "NetLoan Recent Statement G/L Activity" search.
   4. Add a company logo to be used on the PDF statements by selecting a file in the Logo field. 
   5. Select an Advanced PDF Template (NOTE: Netgain has provided one default .html template for clients to use. If customizations to the PDF template are desired, clients will need to create those customizations).
   6. Include an NPV calculation in the template by checking the box next to Calculate XNPV.
      View full size
3. Save.
4. To generate loan statements, navigate to NetLoan > Process Monthly Transactions > Generate Statements. 
5. Select the desired date range for the statements and the statement template that should be used when generating the statements (refer to Step 1 for statement templates). Use the filter fields as needed to filter down to the loans you want to generate schedules for. View full size
6. Select either "Mark All", or check the box next to the individual loans you want to generate schedules for, then click Generate.
7. Once the statements have generated, you can email the statements by selecting "Email Statements". The statements will send to the email address of the borrower/customer that is associated with the loan. View full size
8. You can view the loan statement record that was created by clicking on the "Statement ID" link. View full size
9. You can also view the loan statement by navigating to the loan record, then to the "Related Records" subtab, then to "Statements". View full size
10. The loan statement record contains all relevant statement information such as the associated loan record, loan balance, payments to be made, etc. You can preview the PDF version of the statement by selecting the print icon. View full size
11. Below is an example of a PDF loan statement with the Amortization Schedule starting on page 2. Note that if a client logo were added in Step 2, the logo would appear in the top left corner of the statement. View full size