Auto Recon match Bank items

Good day
Hi all Excel Guru’s. I am not an expert to excel but can help myself and always look for answers if I cant help myself and I hope you can help me with this one.
I would like to auto reconcile transactions that appeared on the bank statements with that of my general ledger.
This will be revenue received and cheques issued. The cheques can be matched with the cheque no on the bank statement and general ledger. The income is a bit difficult. Some can be matched by transaction no or total taking per cashier which is amount and the credit card payments.
Is there perhaps that I could auto match the detail and have the unreconciled on a separate sheet or list showing items not reconciled?
I herewith include an extract of a day bank statement versus the GL. I have about 6000 to 10 000 transactions per month.
Any assistance will be highly appreciated.
Jasper