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...