Good day all,
In the attached file, I'm reconciling Bank and Cash balances for a given period. My challenge here is that in cases where I highlighted in yellow fill, I have same account number for different payments.
I want the following to happen:
1. Where the account number in the Bank Statement is same with that in the Cash Book, the system should only accept the values if they are also same
2. Where there are more than one payment to one account, the system should only assign correspond values to accounts.
3. Where the values in the statements don't agree, the system should ignore both and highlight to enable me know there is discrepancy in the balances.
I hope my explanation is clear enough.
Thanks for your usual cooperation.
Bookmarks