Excel Sales & Purchase Normalisation

I have two sets of Excel workbooks—one for sales, one for purchases—that need to be cleaned, de-duplicated and brought into a single, consistent structure. Every file arrives from different internal teams, so column names vary, date formats jump between Canada and US standards, product codes lack leading zeros and there are occasional free-text notes mixed into numeric fields. I want one harmonised master file that makes month-end reporting painless.

You’ll start from the raw spreadsheets (no CSV conversion has been done) and manually:

• standardise headers, data types, currency and date formats
• remove duplicates and obvious entry errors without deleting genuine reversals or credit notes
• normalise product and supplier codes so they match our master list
• flag any records you are unsure about in a separate “Queries” tab rather than guessing

Final deliverables are:
1. a clean, consolidated workbook ready for pivot-table analysis;
2. a brief change log that shows what was altered, merged or removed so Finance can audit the work.

Please be comfortable working directly in Excel—Power Query, advanced formulas or light VBA are fine if they speed things up, but no third-party tools that would lock us into new licences.