Automation of financial Excel reports (Python)

Development of a Python script for automatic processing of financial Excel reports.

Functionality:
• data cleaning and normalization
• calculation of payments and debts
• grouping by settlements
• formation of summary rows (all / debtors)
• automatic Excel formatting (column widths, styles, highlighting, freeze panes)
• generation of final report with one click

The project works with closed and personal data, therefore:
— the source code is published partially
— examples of final files are not provided

A screenshot of the code execution process is added to the portfolio.