Bank Reconcilation

[Sarfraz Khan]

Dear Sir,

In attached sheet based on Ref number I want to reconcile ledger and bank statement.

eg : which entries are missing from either side.

 

[eibi]

Sarfraz,

See attached -- I set up a conditional formatting formula I set up in the BS tab to highlight items that will require reconciliation:

=AND(ISNUMBER(C3),ISNA(C3=INDEX(BL!$D$2:$E$500,MATCH(IF(ISNUMBER(C3),$B3),BL!$C$2:$C$500,0),5-COLUMN(C3))))

You'd probably want to develop a similar reciprocal conditional formatting rule on the BL tab.

All best.