Advance MS Excel macro helps to reconcile organisation internal systems encrypted Credit Card (BIN numbers) transactions with banks data, which saves many man hours. Apart from reconciliation if helps to; 1: Identify duplicate transactions. 2: Highlight outstanding transactions. 3: Helps to identify frauds and discrepancies related transactions. 4: Archives the transactions. 5: Removes the burden of manually matching. 6: Number of days outstanding. 7: identify Refunds