Automate MYOB Duplicate Invoice Detection

I rely on MYOB AccountRight Plus and export each entity's (14 entities) Purchases [Supplier Statement] report to Excel, and using conditional formating highlight duplicates . I’d like to replace that manual check with a reliable, repeatable method—preferably a small script, macro, or add-in that can compare key fields (invoice number, date, amount, supplier) and flag any matches and present a summary report before we run Account Payable for the week.

Here’s what I need to walk away with:
• A working solution that runs against Excel invoice files and pinpoints potential duplicates in seconds.
• Clear instructions so I can rerun, tweak, or expand the check myself whenever new Entities are added.
• A brief hand-over session (video or written) to confirm everything works inside my existing AccountRight Plus workflow.

If you’ve built similar validation tools—especially for MYOB or other accounting packages—let’s make the duplicate hunt a one-click affair.