Excel utility to reconcile amounts

Guru 
we need excel utility may be VBA or Power query to reconcile matching amounts.
so situation is - we raise number of invoices and customer pays for multiple invoices at a time. so we have to do multiple permutation combination attempt to check which invoices are paid. we need to solve this by help of excel capability

Regards,
 ... Show more