Auto Reconcile two lists

[Swinging Beef]

I wonder if this is something excel can do.

Its based on the desire to whip through the bank reconciliations I need to do monthly for a large number of companies and seperate accounts.

I have two lists of numerical data, with no control number (like a cheque ID or unique debtor ID), only date and amount.

I would like excel to compare and provide two list of reconciling items.
eg: In bank, not in cashbook... in cashbook, not in bank

I would like excel to be able to deal with duplications of amounts in both lists, such as when $100 is paid three times in the example.

Attached is a sample spreadsheet with a small amount of data and the desired solution to the problem, calculated manually.

Any assistance that would reduce my 'tick and bash' time would be graciously received.
Thanks all.
SB