Automated Water Invoice Extraction & Reporting System

Summary I built a fully automated system that collects monthly water-usage invoices from email, extracts attachments, organizes them into structured folders, validates data, calculates shared-water usage, and generates ready-to-send CSV/PDF reports.

Problem A property manager was manually collecting invoices, renaming files, checking for missing data, and producing monthly summaries — a slow, repetitive, error-prone workflow.

Solution Automated email-processing (Google Apps Script) extracts invoices and stores them correctly. A Python reporting tool validates data, checks for inconsistencies, calculates common-water amounts, and produces monthly summaries with one click.

Impact Zero missed invoices, no manual sorting, accurate monthly reports, and hours saved every cycle. The system eliminated human error and made the reporting process fully automatic.

Role Solo developer — architecture, automation agent, reporting engine, validation logic.

Tech Python, Google Apps Script, Gmail automation, structured data processing, PDF/CSV generation.