Check Consistency of data formats

Dear experts,

I have been tasked to do a consistency check for a monthly report we receive from partners. The report covers a fixed range of aspects, each represented in a column. The problem is that sometimes the data format (e.g. date format, currency, etc.) is not consistent over time; columns are missing; or inconsistent column names are used. Therefore we would like to use a most accurate and complete report as the correct version and run a check for other reports in comparison with it. Could you please provide me with some guidance on this? Unfortunately I don't have the report yet. I will upload it as an attachment as soon as I get it. For now I am just seeking general advice (if you can provide a sample file to explain the codes, that would be perfect.) Thank you very much in advance!

Regards,
Tuan