[GNC] How to compare 2 Transaction Reports to find orphan transactions

[Fran_3]

I want to compare Transaction Report A to Transaction Report B
and find transactions that appear on one report but not on the other... aka orphan transactions
In past I have either...
- Done a screen capture of each, pasted them side by side in PC Paint and marked off matching transactions one by one...
- Or printed them out and done the same with pen & paper
- Or exported the reports and then imported them into a spreadsheet and marked matching transactions one by one
All of this is a bunch of work...

Is there an easier way?
Thanks for any help - Fran3