The challenge
MPI Plumbing Corp needed to process thousands of invoices daily from multiple suppliers. Manual data entry was taking three to five days per invoice batch, with high error rates in financial reconciliation.
- Manual PDF-to-Excel conversion across more than twelve different supplier formats
- Complex invoice item mapping to standardised product codes
- Time-consuming accounting-system integration and tax distribution
What we built
We implemented an end-to-end invoice processing workflow built on FastAPI, PostgreSQL and Google Gemini.
- Automated invoice ingestion. Collects invoices directly from an email inbox, identifies the supplier automatically, and processes more than twelve supplier formats.
- Supplier recognition and routing. Identifies the supplier and routes each document to the appropriate processing module.
- End-to-end processing. Inbox through to accounting integration, with automated PDF-to-Excel conversion, line-item mapping and tax distribution.
- Accounting integration. Automated tax distribution, class-based splitting and batch entry generation.
- Price comparison. Monthly supplier price analysis with percentage increase calculations.
Results
85%
reduction in processing time, from 3–5 days to hours
99.5%
accuracy in invoice data extraction
70%
faster accounting integration with automated tax distribution
$500K+
annual cost savings through automation and error reduction
Technology
- FastAPI
- PostgreSQL
- Google Gemini
- QuickBooks integration