Click [Ref Balance] button after that program will add a column contains balance of matching references. Therefore, you can create a PIVOT table to do more analysis for matching balances.

 Armarecon training image (Bank reconciliation excel add-ins ) - excel screen 1 related to Ref Balance button

Balance of matching references 11 and 12 are not zero in above picture.

Previous user manual : Removing Errors

Next user manual : Effective Reconciliation