Challenge to Automate reconciliation process
The Input Reco file has following data fields
The Input Bank Deposit Details has Following Fields.
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.