Excel Reconciliation Automation

I export two Excel workbooks every cycle—one “old” file and one “new.” I need a reusable automation that:

• Imports both files and matches rows by Company + Account Name.
• Flags each record with conditional formatting: yellow for changed amounts, blue for new accounts, grey for unchanged, and moves closed accounts to a separate tab.
• Carries forward existing remarks only when the amount is unchanged.
• Refreshes the CK List and DK List tabs, copying prior remarks and highlighting any new or modified lines.
• Handles the light data transformation I require so the output is immediately ready for pivoting or further analysis.

You’re free to choose the best approach—Power Query, XLOOKUP/INDEX-MATCH formulas, or a well-commented VBA macro—so long as the final workbook:

1. Runs with a single refresh or button click.
2. Produces a clean “Processed” file that I can drop straight into the next cycle.
3. Is clearly documented so I can adjust source file paths or add extra columns later.

Accuracy and clarity matter more to me than flashy visuals. If you’ve built similar reconciliation tools before, I’d love to see an example screenshot or short demo video with your bid.