Three-Way Reconciliation

A three-way reconciliation extends the standard two-way reconciliation by adding a third independent record. In a typical fund setup the three sources are the manager’s IBOR or shadow books, the fund administrator’s ABOR, and the custodian or prime broker statement.

The value of the third source is diagnosis. When two sources agree and one differs, the outlier is usually where the error sits. That shortens investigation time and avoids the common two-way problem of not knowing which side is wrong.

Pitfalls include comparing sources struck at different cut-off times, inconsistent security identifiers across the three systems, and treating agreement between the manager and administrator as proof of accuracy when both may rely on the same flawed feed. Clear identifier mapping through the security master and aligned timing are prerequisites. Results should be logged with break category, owner and resolution so recurring causes can be fixed at source.

Example

For one equity line, the manager’s books show 10,000 shares, the custodian shows 10,000 shares and the administrator shows 9,500 shares. Because two independent sources agree, the investigation starts with the administrator, where a 500-share buy was found to have been booked to the wrong fund.