This shows a nifty way to implement a Pivot Table to reconcile many accounts. The basic concept is fairly simple to implement so long as you can get your two data sources in electronic format.
The file is too big to upload here. It can be downloaded from here along with other freebies. Or here in zip format PivotTable Reconciliation
Hope this is useful to a few persons.
Regards,