Excel Cumputation

Challenge to Automate reconciliation process

The Input Reco file has following data fields
DepositDate
Orders
CODAmount
Location

The Input Bank Deposit Details has Following Fields.
Amount
Location
Bank
Bank Credit Date

Step 1: CollectedAmount is Sum of COD Amount for same location, Date and Location.

Step 2: User will match the CollectedAmount of Reco file with Amount of Bank Detail file with Same Location using vlookup.

Step 3: For NA Rows in TallycreditAmount of Reco file user will take Amount from Bank Detail File try to sum CODAmount of Recofile using multpile permutation and Combination where the human jundgement and eyevision is required where the Sum of CODAmount of Recofile Matches with Amount of Bank Detail file user will Update Tallycreditamount Accordingly.