Excel Macro: Auto Credit Allocation

I keep my customer ledger in an existing Excel workbook. Each time I receive the bank statement it arrives as an Excel file, laid out on a single sheet that lists every transaction. The customer’s name appears in the description column of each credit line, and that is the key I use to decide which account the money belongs to.

What I need is a lightweight VBA / Power Query routine (whichever is cleaner for this size of task) that lets me paste or import the statement and have every matching credit automatically recorded against the right customer inside my workbook. No extra clicks—just import, confirm, and the ledger updates.

Core expectations
• Read the statement from one sheet and detect credit rows.
• Match each credit to the correct customer account by the name string.
• Post the amount in the proper spot of my existing ledger without breaking current formulas.
• Flag any names that are not recognised so I can review them.

Deliverables
1. Updated workbook with the working macro / query.
2. A brief note inside the file explaining how to run or refresh the process.

If you can keep the solution compact, transparent, and easy for me to tweak later, that would be ideal.