Automated Accounts Receivable Aging Reporting Solution

- Developed an automated Accounts Receivable Aging reporting solution using Excel Power Query and Power BI.

- Consolidated multiple Excel workbooks and worksheets with different customer credit policies into a unified reporting model, eliminating repetitive manual processing.

- Automated due-date calculations and aging buckets, enabling daily report refreshes by simply replacing the source files and refreshing the model.