Generate IRA Statements
Contents
Overview of IL275
The Generate IRA Statements report produces a statement for IRA holders, summarizing the transaction details within the date range you specify. The report output displays information such as the name/address of the holder, the investment number, starting balance, deposits, withdrawals and interest transactions, and ending balance. To generate the report:
- From the DDI Connect main menu, double-click Financial Services
- Double-click Investments
- Double-click Reports
- Double-click 275 Generate IRA Statements. The parameters screen will launch:
You have the following fields available on this screen:
| Field | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Beginning statement date | Enter the beginning date of the range you wish to generate statements for. You can type the date in mm/dd/yyyy format or click the calendar icon to select the date | ||||||||
| Ending statement date | Enter the ending date of the range you wish to generate statements for. You can type the date in mm/dd/yyyy format or click the calendar icon to select the date | ||||||||
| Sort mode | Click the drop down arrow to sort by either Account or ZIP code | ||||||||
| Investments | If you wish to generate the statements for only a particular investment, enter that number here or click the list icon to select from a list of investments in the system. Leave the field blank to generate statements for all investments meeting the other parameters you enter | ||||||||
| Print report | If selected, the system will generate a summary report | ||||||||
| Print statements | If selected, the system will create merge notices. The Merge Method field will enable if selected. Click the list icon to select the method desired to create the notices. Your options are:
| ||||||||
| IRA types | To generate statements only for one or more IRA types, type the code or codes, separated by commas, or click the list icon to select from a list of IRA types in the system |
Mailmerge Fields
This report generates mailmerge data (max 50) and has the potential to include the following fields.
| Name | Description |
|---|---|
| reg-addr1 | |
| reg-addr2 | |
| reg-addr3 | |
| reg-addr4 | |
| reg-addr5 | |
| reg-addr6 | |
| month-range | |
| end-dt | |
| reg-pin | |
| page-info1 | |
| page-info2 | |
| deposit-amt | |
| interest-amt | |
| withheld-amt | |
| current-yr | |
| next-yr | |
| verbal-end-dt | |
| begin-bal | |
| end-bal | |
| agency-pin | |
| ira-label |
Merge Form Selection Rules
| Form | Description |
|---|---|
| IRA[1-6]V2 |
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. The system will generate the statements based on the parameters you entered. If you selected Print Report, a summary of the results will also be generated. Click below to view a sample of this report.
If you opted to generate statements, you will now have to merge them. Click below to view a sample IRA Statement.
Security Function
Users must pass the security function listed below in order to run this report.
INVTRANINQ
