Develop an Advanced Excel Vba Financial Automation and Reporting System

We are seeking an experienced VBA developer to create a comprehensive and automated financial management system within Microsoft Excel. This project involves developing several interconnected modules to streamline our financial operations, enhance reporting capabilities, and improve decision-making. The ideal freelancer will have strong expertise in VBA programming, data manipulation, and financial reporting. Key functionalities required include: Automated Data Import: Develop VBA scripts to automatically pull trial balances, general ledgers, and bank statements directly into Excel. The scripts must include robust data cleaning and standardization routines to ensure data integrity and consistency across various sources. Dynamic Financial Dashboard: Create an interactive dashboard featuring dynamic charts and graphs for key financial statements, including Profit & Loss, Balance Sheet, and Cash Flow. The dashboard should offer drill-down capabilities, allowing users to click on summary figures (e.g., 'Expenses') to view detailed breakdowns (e.g., Vendor-wise expenses). Compliance & Tax Tracker: Implement an automated system for tracking and reminding users of critical compliance deadlines, such as vat, tds, and corporate tax submissions. The system should also be capable of generating bilingual compliance reports (English and Nepali) suitable for regulatory submission. Scenario Analysis Tool: Build VBA-driven 'What-If' models to facilitate scenario analysis for various financial situations, including interest rate changes, loan restructuring options, and investment decisions. This tool will be crucial for strategic planning and negotiations with financial institutions. Audit Trail & Security: Integrate VBA macros to log every significant change made to financial data within the system, providing a clear audit trail. Implement password-protected modules and reports to ensure the security and confidentiality of sensitive financial information. The freelancer should demonstrate a deep understanding of financial processes and a proven track record in developing complex, reliable, and user-friendly Excel-based solutions.