DocuFlow: Turning Invoice PDFs into Structured Financial Data

Description and use

DocuFlow automates extraction of data from PDF invoices using Docker, Celery, Tesseract, and PostgreSQL, and visualizes results in Streamlit.

Problem

Invoices stored as PDFs in a folder are difficult to process at scale; manual extraction is error‑prone and duplicate detection is missing.

Outcome

The pipeline processes hundreds of invoices automatically, eliminates duplicate processing, and provides real‑time analytics without blocking the UI.

Workflow

• Watch hot folder for new PDFs
• Queue task to Redis via Celery
• Asynchronous worker runs Tesseract + Poppler to extract text
• Parse extracted text for invoice fields (number, date, vendor, total)
• Store parsed data in PostgreSQL
• Query data from Streamlit dashboard for analysis

Evidence

DocuFlow is a containerized, event‑driven pipeline that automates ingestion, OCR, parsing, and analytics for invoices and financial documents.

Source

Hot‑folder watcher for real‑time ingestion

Source

Celery + Redis for asynchronous OCR and parsing

Source

Tesseract + Poppler for PDF/image text extraction

Source

PostgreSQL for persistent storage

Source

Streamlit dashboard for visualization and quick analysis

Source