Projectscase 02 — data & bi · 2026
Excel Automation — Email Sorter & US/Canada City Financial Reporter
Automated email sorter that classifies incoming Excel workbooks across US and Canada cities and compiles consolidated financial reports.
Role
Author · Financial Workflow Automation
Stack
Links
notesarchitecture & scope
Excel Automation is an internal financial workflow utility designed to eliminate manual email inbox triage and regional spreadsheet consolidation. It automatically ingests and sorts Excel attachments mapped to United States and Canadian cities, normalizes ledger schemas, and outputs executive-ready financial reports.
Key Capabilities
- Automated email attachment sorting and territory routing across US and Canada city jurisdictions
- Multi-workbook Excel ingestion, header normalization, and data-type validation via Python
- City-level and country-level financial aggregation with automated reconciliation checks
- Formatted Excel financial report generation with summary KPIs and audit logs
- Deterministic batch processing that replaces repetitive manual spreadsheet sorting
Built for internal operational efficiency across high-volume North American financial reporting workflows.