Conditional formating two reports for differences

I am new to this forum as I am trying to find an easier way of balancing two reports from two different systems for discrepancies.
For the last days I have been stuying conditional formating but the more I read the less I understand, my excel knowlegde is pretty basic

I need to compare the batch number and the amount booked. Plus I need to check if it's booked in the correct office (EU,US etc)

Is there a way to do this balancing by Excel with some clicks instead of ticking them off by hand?

Thanks for all your help :-)

Many thanks for your reply. I have enclosed how I would like to see it. Basically the - amounts and + amounts should balance themselves out.

The coding seems to be quite difficult. This is a process I have to do a lot. Will it be easy to create a template or something like that?

Again thanks for your help! I appreciate it

Hello, try the attached WB.
I only did the first table since i haven't understood what you needed to do on the second one.