Urgent Project_Reconciliation

below are the pointers which needs to considered.  Matching Tab – BA (debit / credit) document matching with any other document (except BA) for same amount should be highlighted as green and moved to Matching tab • Condition 1 – BA document should be kept as base • Condition 2 – While applying ABS, macro should identify one duplicate entry • Condition 3 – Document type (Clase) should not be same  Cash Pooling tab – BA (debit / credit) document matching with two other documents (except BA) for same amount should be highlighted as Amber and moved to Cash pooling tab • Condition 1 – BA document should be kept as base • Condition 2 – While applying ABS, macro should identify two or more duplicate entries • Condition 3 – Document type (Clase) should not be same • Condition 4 - check if the two duplicate entries found are BP document. If there is no BP document, the matching should not be considered as cash pooling.  Matching with bank fees - BA (debit / credit) document matching with any other document (except BA) for same amount with a difference of upto 120.20 should be highlighted as Blue and moved to Matching with bank fees tab • Condition 1 – BA document should be kept as base • Condition 2 – Difference in debit and credit should not be more than 120.20 • Condition 3 – Document type (Clase) should not be same Further, I will work on creating Pivot table and matching once these are captured.