Comparing 2 xlsx files

How can I easily improve the comparison between 2 xlsx files (or 1 xlsx with 1 csv) considering that it is a recurring task where data is updated everyday.

File 1 = Authorized transactions

File 2 = Invoiced transactions

Problem is that data is not always presented in the same way 🤨

I would like to identify quickly:

1/ the transactions that are OK

2/ missing transactions

3/ incorrect transactions

Any advice?

Thanks 🙂