Develop an Automated Overdue Invoice Tracking and Ecl Calculation Tool

Companies often face financial challenges due to late customer payments and require an efficient system to monitor overdue invoices without the high cost of traditional ERP software. This project seeks a skilled professional to develop a robust and user-friendly solution, either as an advanced Excel sheet or a dynamic Power BI dashboard. The primary goal is to create a tool that provides clear visibility into outstanding debts and supports proactive financial management. The solution must include: Outstanding invoice tracking functionality to monitor all pending payments. Categorization of debts into distinct aging buckets, such as Current, 1-30 days overdue, 31-60 days overdue, and 90+ days overdue, to highlight critical accounts. Automated alert mechanisms to flag overdue accounts, enabling timely follow-up actions. An integrated Expected Credit Loss (ECL) calculation template to assist in financial provisioning and risk assessment. The ideal freelancer will have strong expertise in data analysis, dashboard development, and financial reporting to deliver a comprehensive and actionable tool.