The
Verify IRA Balances Report (Tool #942) compares records in the IRABENDS (beneficiary distribution) table with records in the IRABL (balance file) table for these two fields: PREMWE and QUALW. These are the ones populated when posting with either the T or Q posting codes. It will show if there are discrepancies between these amounts. However, because these codes can be used for transactions other than beneficiary distributions,
they will not show when the beneficiary distribution is missing.
It should show if:
- There are amounts in both IRABENDS and IRABL tables but they are not in balance
- There is a beneficiary distribution recorded, but nothing in the fields in IRABL
- These are no beneficiary distributions recorded, but there is a conflict in IRABL where both the fields were used in a single year
It will not show if the fields in IRABL are populated, but no beneficiary distribution amount is recorded.