CBX 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 press Enter.

For complete instructions on navigating the “Display Report” screen and using the available buttons, see Displaying a Custom Report as an Online Inquiry.