IRA Custodian Extract
Contents
Overview of IL368
Generate an IRA Custodian Extract that contains the necessary information needed by IRA custodians to update their systems.
- From the DDI Connect main menu, double-click Financial Services
- Double-click Investments
- Double-click Reports
- Double-click 368 IRA Custodian Extract. The parameters screen will launch:
Report Criteria
Field | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Start date | You can type the date in a mm/dd/yyyy format or click the calendar icon to select the date | ||||||||
End date | You can type the date in a mm/dd/yyyy format or click the calendar icon to select the date | ||||||||
Custodian | Constituent PIN of IRA custodian to include | ||||||||
Exclude custodian | Constituent PIN of IRA custodian to exclude | ||||||||
IRA types | Optional comma delimited list of IRA types to include on report | ||||||||
CUSIP required | When yes then display blank CUSIP information in error section and exclude ALL possible spreadsheet results. When no then display blank CUSIP value in report and spreadsheet results | ||||||||
Extract method |
| ||||||||
Extract file | NOTE: Required field visible when an "Extract method" other than None is chosen |
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. If you elected to create statements, you will now need to merge them. The system will display a summary of the report results. Click below to view a sample of the summary output, as well as a sample statement.
Extract Methods
Goldstar
Field | Required? | Label | Header text |
---|---|---|---|
1 | yes | Custodian ID | IRA custodian identifier, typically stored in investment CUSIP field |
2 | yes | Client Name | IRA investor name |
3 | yes | Source Num | Investment number |
4 | yes | Maturity Date | Investment current maturity date |
5 | yes | Interest Rate | Investment interest rate |
6 | yes | Period End Date | Typically a month-end date |
7 | yes | Interest Paid This Month | Interest earned on IRA investment in the entire month |
8 | yes | Month End Balance | Current principal balance |
9 | no | Purchase Date | Investment purchase date |
10 | no | Last Tran Date | Last transaction date |
11 | no | Invest Status | Investment status flag |
12 | no | Inv Type | Investment type |
13 | no | Int Pmt Code | Investment interest payment code |
14 | no | Int Pmt Frequency | Investment interest payment frequency |
15 | no | Int Pmt Method | Investment interest payment method |
16 | no | Account | Investment account number |
17 | no | IRA Type | IRA type |
Goldstar 2019
Field | Required? | Label | Description |
---|---|---|---|
1 | yes | Custodian ID | IRA custodian identifier, typically stored in investment CUSIP field |
2 | yes | Client Name | IRA investor name |
3 | yes | Source Num | Investment number |
4 | yes | Interest Earned | Interest earned during the chosen date range |
5 | yes | Fees Paid | Fees paid during the chosen date range |
6 | yes | Maturity Date | Investment current maturity date |
7 | yes | Interest Rate | Investment interest rate |
8 | yes | Period End Date | Typically a month-end date |
9 | yes | Current Balance | Current principal balance |
10 | yes | Prior Balance | Prior period principal balance |
11 | no | Purchase Date | Investment purchase date |
12 | no | Last Tran Date | Last transaction date |
13 | no | Invest Status | Investment status flag |
14 | no | Inv Type | Investment type |
15 | no | Int Pmt Code | Investment interest payment code |
16 | no | Int Pmt Frequency | Investment interest payment frequency |
17 | no | Int Pmt Method | Investment interest payment method |
18 | no | Account | Investment account number |
19 | no | IRA Type | IRA type |