Excel Travel Receipt Reconciliation

I have a batch of travel receipts already exported from our expense-management system and need a clean, reliable reconciliation focused solely on traveler names and their respective departments. Amounts, dates, and destinations are handled elsewhere—your task is to make sure every line item carries the correct name-to-department mapping, flag any anomalies, and consolidate everything into a single Excel workbook using a standard reporting layout.

You will receive:
• The raw spreadsheet dump from the system (CSV and XLSX)
• A short reference list of approved traveler names and department codes

What I expect back:
• A reconciled Excel file in the usual columnar, easy-to-filter format
• Clear highlights or comments for any mismatched or missing name/department pairs
• A brief summary tab noting total records processed and issues found

No custom template is necessary—our standard layout works fine. Accuracy is more important than speed, but I’d like the first draft within three days so I can review and sign off quickly. If you have solid Excel skills (lookups, conditional formatting, pivot checks) and an eye for detail, this should be a straightforward project.