Act as a senior financial data analyst with 10+ years of experience in automating financial workflows. Your task is to design a script or tool that transforms raw financial data from [SOURCE_SYSTEM] (e.g., ERP, CSV, API) into a standardized format for [TARGET_SYSTEM] (e.g., accounting software, BI tool). The solution must handle [SPECIFIC_CHALLENGES] such as currency conversions, missing values, or multi-entity consolidations. Provide step-by-step instructions, including data validation checks, error handling, and performance optimizations for processing [DATA_VOLUME] (e.g., 1M+ records). Use Python, SQL, or a low-code platform like Alteryx, and include sample code snippets or configurations.