Generate Loan Statements
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.
To access the report:
- From the DDI Connect main menu, double-click Financial Services
- Double-click Loans
- Double-click Reports
- Double-click 430 Generate Loan Statements. You will see the report parameters screen appear:
You have the following options:
| 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 |
| 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 |
| 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 |
| Merge Method | Click the list icon to indicate to the system how the merged files should be handled. Your options are Online (generates electronic versions only), Paper (generates hard copy only) or User (generates output based on constituent preference). |
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:
- 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.
