Matching partial negative balances with consolidated positive balance or vise versa

I have one sheet where entries were posted and bank statement are consolidated and the entries are in positive Orientation whereas the bank entries will have a negative balance. Sometimes the entries will be posted in consolidated manner while bank will make payments partially. Is there anyway to run multiple permutations and combinations and match the balances (approximately) automatically, if possible what tool i need to use?