Excel Receivable-Payment Matching Script

I have a single Excel sheet with more than ten columns where every receivable and every payment already lives side by side. Invoice numbers and payment amounts each sit in their own dedicated columns, so the raw data is tidy—but nothing is reconciled.

What I need is a repeatable way to match each receivable to its corresponding payment using both the invoice number and the exact amount, then clearly flag any rows that remain unmatched. A VBA macro, Power Query routine, or even a robust set of formulas would all be acceptable as long as the end result is one click (or refresh) to:

• pair every exact match
• highlight or list anything still open

Please return the finished workbook with the automation in place plus a short note explaining how to rerun it when new data arrives. If you lean on VBA, well-commented code is essential; if you prefer Power Query or formulas, keep the steps transparent so I can audit them later. Fast, clean, and easy to maintain is the goal.