Financial Excel Data Cleanup

I need a recent batch of raw financial data brought into shape so it is ready for analysis and reporting directly inside Excel. The source files contain a mixture of transaction records, dates, and numeric fields that currently suffer from inconsistent formats and the usual noise that builds up when several people touch the same sheet.

The end result I want is a single, well-structured Excel workbook with every column using a consistent data type, clear headers, no stray characters, and totals that recalculate accurately. Duplicates, text-as-numbers issues, and any obvious entry mistakes should be resolved along the way, but I am open to your recommended best practices if you spot additional improvements.

You are free to use native Excel functions, Power Query, VBA, or any other technique you trust, as long as the final deliverable remains an .xlsx file that I can open without extra dependencies. Please keep a brief change log or comments tab so I can track what was adjusted.