Dynamic Financial Statement Parser with Multi-Sheet Reconciliation

Create a Python script using pandas that can automatically parse complex financial statements across multiple Excel sheets, detecting and reconciling discrepancies between income statements, balance sheets, and cash flow statements. The script should implement advanced error checking, handle varying column structures, and generate a comprehensive validation report highlighting potential accounting inconsistencies. Include type hinting, robust error handling, and the ability to work with both .xlsx and .csv formats from different financial reporting systems.