Investment Interest Statements

From Documentation
Jump to navigation Jump to search

Overview of IL332

The IL332 Investment Interest Statements is a report that is a replacement for the 1099 Statements report. It should only be used by clients that utilize an alpha character at the beginning of their account master values. At this point in time, IL332 is specific to UMDF. To run the report:


  • From the DDI Connect main menu, double-click Financial Services
  • Double-click Investments
  • Double-click Reports
  • Double-click 332 Investment Interest Statements. The parameters screen will launch:


IL332 1.png


You have the following options:


Field Description
Base date Typically a year end date. You can type the date in a mm/dd/yyyy format or click the calendar icon to select the date
Account If you wish to generate the report for a particular account, you can type the account number here or click the search icon to search for the account you wish to report against
Term categories If you wish to limit the report to just certain term categories, you can do so here. Type the code or codes, separated by commas, or click the list icon to select from a list of categories configured in the system
Include account types If you wish to report against one or more account types, you can type the account type code or codes, separated by commas, or click the list icon to select from a list of account types configured in the system
Exclude account types If you wish to exclude one or more account types, you can type the account type code or codes, separated by commas, or click the list icon to select from a list of account types configured in the system
Load IRS payee information If selected, the system will update the IRS Reporting system with the results
Remove existing payee information NOTE: This field is only visible if the "Load IRS payee information" box has been selected. If selected, the system will remove any existing payee information for this tax year before uploading the data from the report
Payee operation NOTE: This field is only visible if the "Load IRS payee information" box has been selected. You have the option of copying amounts to existing payee, which will overwrite any existing payee data for this form and for the specified calendar year, or adding the amounts to existing payee, which will add the report results to any existing payee data for this calendar year
Generate comma delimited label file If selected, the system will generate a label file with the results of the report
Destination NOTE: This field is only active if the "Generate comma delimited label file" field is selected Select either a local file or a unix file
Label file name NOTE: This field is only active if the "Generate comma delimited label file" field is selected. You can type the file path and name or click the folder icon to select the destination


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.


Print options.png


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.
Email 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. If you opted to generate a label file, it will be saved in the directory you indicated. The system will also display a summary report of the results. Click below to view a sample of that summary report.


Sample IL332.pdf