Generate Loan Statements
Contents
Overview of IL430
The loan statements report is generally set up to be run automatically via periodic job processing, based on your organization's schedule. Most likely, it is set up to run monthly, with a year end statement being generated at the end of the calendar year. The report offers options on sorting, including separating ACH statements, and separating single and multi page statements.
Generating statements is a two part process. The first step is to generate the information, using the report menu item. The second step is to perform the merge and generate the output. This is performed via the Merge system.
Report Criteria
Report Criteria Fields
Field | Description | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Start date/to | Enter the date range that you are generating the statements for. You can type the date in a mm/dd/yyyy format, or you can click the calendar icons to select the dates | ||||||||||
Sort order | Click the drop down to indicate how you want the statements to be sorted. Your options are account, ZIP code or loan number | ||||||||||
Account | Clicking the icon allows you to search for a specific account in Name/Address Inquiry | ||||||||||
Constituent | Clicking the icon allows you to search for a specific constituent in Name/Address Inquiry | ||||||||||
Loan numbers | If you wish to generate a statement for a specific loan or loans, you can enter that information here. You can type the loan number or numbers, separated by commas, or you can click the list icon to select from a list of loans in the system. Leave this field blank to generate statements for all active loans | ||||||||||
Loan types | If you wish to generate statements for only certain loan types, you can enter that information here. Enter the loan type or types, separated by commas, or click the list icon to select from a list of active loan types in the system. Leave the field blank to generate statements for all loan types | ||||||||||
Loan categories | Enter one or more comma-separated loan categories or click the list icon to select from a list of possible loan categories. Leave the field blank to generate statements for all loan categories. | ||||||||||
Loan status | Click the drop-down to indicate the type of loan status you want used to sort the statements. Your options are All loans, Interest-only loans, or Regular loans | ||||||||||
Due day range: | If used, allows you to run statements for loans due on the 1st thru the 15th, for example | ||||||||||
Separate ACH statements | If selected, the system will separate ACH statements from the rest of the statements. ACH statements are generated at the end of the merge batch | ||||||||||
Separate single and multi-page statements | If selected, the system will separate single statements from multi-page statements. Multi-page statements are generated at the end of the merge batch | ||||||||||
Corrected statement | If selected, the merged output will show "Corrected", to indicate to the borrower that this statement should replace a previous statement, if applicable | ||||||||||
Generate label file | This option creates a comma separated value (CSV) file containing constituent mailing label information | ||||||||||
Override Form Code | If selected, you can select the form code to be used instead of the default option | ||||||||||
Set payment amt to interest due for interest only loans | If selected, this sets the payment amount to interest due for interest-only loans | ||||||||||
Exclude closed loans | If selected, closed loans will be excluded from the report | ||||||||||
Exclude $0 balance loans with no activity since: | If selected, click the icon to enter the date you want $0 balance loans excluded from that date going back | ||||||||||
Exclude simple adjustments | If selected, simple adjustments will be excluded from the report | ||||||||||
Combine regular and extra payments | If selected, regular and extra payments will be combined on the report | ||||||||||
Display loan fee details | If selected, loan fee details will be displayed on the report | ||||||||||
Include late fee accrual transactions | If selected, late fee accrual transactions will be displayed on the report | ||||||||||
Include interest accrual transactions | If selected, interest accrual transactions will be displayed on the report | ||||||||||
Include loan relief | If selected, loan relief details will be displayed on the report | ||||||||||
Display current interest due | If selected, the system calculates interest through the "end date" for the statements. This box only should be checked when the date range extends past the current business date. If left unchecked, the system calculates interest through current business date. | ||||||||||
Merge Method | Click the list icon to select the method desired to create the notices. Your options are:
| ||||||||||
Mailing label |
|
Mailmerge Fields
This report generates mailmerge data (max 50) and has the potential to include the following fields.
Flat Mailmerge
Name | Description |
---|---|
Address1 | |
Address2 | |
Address3 | |
Address4 | |
Address5 | |
Address6 | |
Address7 | |
Address8 | |
Registration | |
Loan | |
Rate | |
PaymentAmount | |
EndingDate | |
StartingDate | |
SupportAmount | |
MaturityDate | |
PageInfo1 | |
PageInfo2 | |
TotalPayments | |
TotPrin | |
TotInt | |
TotalReserve | |
LoanRef | |
CashSent | |
IntDed | |
CLFee | |
InsPrem | |
TaxPmt | |
PastDueMessage | |
PastDueAmount | |
AddressType | |
Year | |
CorrectionMessage | |
AdjustmentDt | |
PayoffDate | |
FeeMessage | |
InterestCapitalized | |
LnAdvAmt | |
TotIntPaid | |
Region | |
Pin | |
LoanType | |
LoanTypeDescr | |
LoanBal | |
LnIntAndFees | |
LnPayOff | |
DueDate |
Nested Mailmerge
Table | Field |
---|---|
ttStatement | seqNum |
ttStatement | address1 |
ttStatement | address2 |
ttStatement | address3 |
ttStatement | address4 |
ttStatement | address5 |
ttStatement | address6 |
ttStatement | address7 |
ttStatement | address8 |
ttStatement | registration |
ttStatement | loanNum |
ttStatement | intRate |
ttStatement | paymentAmt |
ttStatement | endDate |
ttStatement | startDate |
ttStatement | supportAmt |
ttStatement | maturityDate |
ttStatement | totalPayments |
ttStatement | totalPrincipal |
ttStatement | totalInterest |
ttStatement | totalReserve |
ttStatement | refinanceAmt |
ttStatement | cashSent |
ttStatement | interestDeduct |
ttStatement | closingFee |
ttStatement | insurancePremium |
ttStatement | taxesPaid |
ttStatement | pastDueMessage |
ttStatement | pastDueAmt |
ttStatement | addressType |
ttStatement | fiscalYear |
ttStatement | isCorrection |
ttStatement | adjustmentDate |
ttStatement | payoffDate |
ttStatement | feeMessage |
ttStatement | capInterest |
ttStatement | dueDate |
ttStatement | intYTD |
ttStatement | lastStatementDate |
ttStatement | loanTypeCode |
ttStatement | loanAdvAmt |
ttStatement | namePin |
ttStatement | regionDescr |
ttStatement | statementGUID |
ttDetail | statementGUID |
ttDetail | rowNum |
ttDetail | tranDate |
ttDetail | advanceAmt |
ttDetail | paymentAmt |
ttDetail | principalAmt |
ttDetail | interestAmt |
ttDetail | lateFeeAmt |
ttDetail | reserveAmt |
ttDetail | loanBalance |
ttDetail | tranID |
ttDetail | tranIDDescr |
ttDetail | tranDescr |
ttFeeContainer | statementGUID |
ttFeeContainer | feeGUID |
ttFee | feeGUID |
ttFee | rowNum |
ttFee | tranDate |
ttFee | feeDescr |
ttFee | feeAmt |
ttStatementSummary | statementGUID |
ttStatementSummary | loanBal |
ttStatementSummary | loanPayOff |
ttStatementSummary | loanIntAndFees |
ttStatementSummary | maturityDate |
ttStatementSummary | payoffDate |
Merge Form Selection Rules
Form | Description |
---|---|
LS1 | |
LSP2 | |
LS3 | |
LS4 |
Print Options
After clicking the Print Options button you will see the following options. Choose the desired options and click OK to return to the report parameters screen.
Option | Description |
---|---|
Printer | Click the drop down arrow to select from a list of available printers. DDI Connect uses your default printer unless told otherwise |
Format | Click the drop down arrow to select from a list of available formats. Select paper size, number of columns, and number of rows for printing. Each report has built-in format defaults. Select “Use Defaults” to use the built-in report defaults. The number of rows and columns controls the print size and amount of information per page |
Memo | If you wish, you can add a memo to the output of the report. NOTE: It is recommended that Word documents be saved with the .docx extension |
View Report | This option generates a pdf file that is displayed on the screen when the report is generated |
Archive Report | If this option is selected, the system will archive the report in the DDI Connect report archives. For information on working with archived reports, please reference this page: Archived Report Viewer |
Print Report | If selected, the system will generate the report output to your default printer. NOTE: You will also receive a pdf version of the report, displayed on your screen |
Print via PDF | Prints directly to your printer. |
This option allows you to send a .pdf attachment of the report to the indicated users' email addresses. When OK is clicked, a dialog box will open requesting a recipient | |
Duplex/Top | Prints the report on both sides of the paper in landscape style. The printer must be capable of printing on both sides or an error will occur |
Duplex/Side | Prints the report on both sides of the paper in portrait style. The printer must be capable of printing on both sides or an error will occur |
Green bar | Adds shaded, horizontal bars to the report, making it easier to read across columns |
No dialog | Selecting this option means that no ‘Report Completed’ dialog will display after the report has been generated |
Extra copies | If you want extra copies of the report generated, type the number in this field |
Click Start. You will now see the pdf output, which lists the loans in the batch. Click below to view a sample of this output.
Once you have the report, the next step is to merge and print the statements. To make il430 use nested, you will have to go to System Administration --> Codes --> Nested Statements Codes --> and put a "1" in the Active field. Also, LS4 must be in the form code name in forms maintenance.
- From the DDI Connect main menu, double-click Merge System
- Double-click Merge Print Requests. You will see a screen similar to this one:
Locate the batch that you are wanting to merge. Click the box to the left of that batch, and then click Merge:
You will see this prompt:
Click Start to launch the merge. When the merge completes, you will see output similar to this (click the icon to view a sample loan statement).
You can now print the statements as desired.
Security Function
Users must pass the security function listed below in order to run this report.
LNTRANINQ