Bank Reconciliation using Excel macros

Good afternoon Excel experts!!!

I need your help with bank reconciliation.

I would like to compare the bank statement with our accounting system to find out the discrepancies. The goal is to create a simple list of transactions to reconcile and un-reconcile. Attached is an example. It has been updated.

I should mention that I know very little about macros. Currently I use conditional formatting to do the reconciliation. I wonder if this is an easy way.

It's not clear to me exactly what you are comparing and what results you expect to see and where.

Please manually add a sample set of results with notes that explain how you have obtained them. It's unlikely you'll need macros but we'll know better when we see what the results are.