CU*BASE Query: IRA Balance File Comparison

The IRA Balance File Comparison tool uses IBM Query to produce a display showing a comparison between the balance shown in the member's IRA Balance file and the net total of all deposit and withdrawal transactions performed for the IRA type. Only those accounts where the totals do not match will be displayed using the default criteria.

Specifications

File(s) used by this Query: IRABL

Access: Tool #410: IRA Balance File Comparison (IRABL)

Following is a description of the calculated columns in this report:

Column

Calculation

Net Change

End Year Balance minus Begin Year Balance

Current Years Deposit

Total of the following amounts in the IRA balance file:

  • Current Year deposits

  • Previous Year deposits

  • Dividend deposits

  • Transfer deposits

  • Rollover deposits

  • Recharacterization deposits

Current Years Withdrawals

Total of the following amounts in the IRA balance file:

  • Premature W/Exception withdrawals

  • Transfer withdrawals

  • Distributed withdrawals

  • Recharacterization withdrawals

  • Premature withdrawals

  • Prohibited withdrawals

  • Disability withdrawals

  • Death withdrawals

  • Excess Current Year withdrawals

  • Excess Previous Year withdrawals

  • Other withdrawals

  • State Withholding

  • Federal Withholding

  • Rollover to IRA

  • Rollover to QP

Net Change Calculated

Current Years Deposit minus Current Years Withdrawals

Errors

Net Change minus Net Change Calculated

Sample Conditions

For this Query, all you need to do is enter the tax year to view (in place of the “1995” in the sample) and use Enter.

Clickherefor complete instructions on navigating around the “Display Report” screen or using the available buttons.