PDF Invoice Parser#

Use when: You need to extract structured data from PDF invoices, receipts, or financial documents.

Capabilities#

• Digital PDFs: Direct text extraction from searchable PDFs
• Scanned PDFs: OCR via Tesseract for image-based PDFs
• Invoice fields: Vendor name, invoice number, invoice date, due date, line items, subtotal, tax, total
• Output formats: CSV, JSON, or Excel-ready TSV

Quick Start#

bash

# Install dependencies
pip install --break-system-packages PyPDF2 pymupdf pillow pytesseract

# Parse a single invoice
python3 scripts/parse-invoice.py invoice.pdf --output invoice_data.csv

# Parse multiple invoices
python3 scripts/parse-invoices.py ./invoices/ --output consolidated.csv

Usage#

Parse a single invoice#

bash

python3 scripts/parse-invoice.py path/to/invoice.pdf --output output.csv

Parse a directory of invoices#

bash

python3 scripts/parse-invoices.py ./invoice_directory/ --output consolidated.xlsx

With OCR (for scanned PDFs)#

bash

python3 scripts/parse-invoice.py scanned_invoice.pdf --ocr --output output.csv

Extracted Fields#

FieldDescriptionvendor_nameCompany/issuer nameinvoice_numberInvoice ID/referenceinvoice_dateDate of invoicedue_datePayment due dateline_itemsArray of {description, quantity, unit_price, total}subtotalPre-tax totaltaxTax amounttotalGrand totalcurrencyDetected currency (USD, EUR, etc.)

Output Format#

CSV columns:

text

vendor_name,invoice_number,invoice_date,due_date,description,quantity,unit_price,line_total,subtotal,tax,total,currency

Each line item becomes a row, with invoice-level fields repeated.

Dependencies#

• PyPDF2 — Digital PDF text extraction
• PyMuPDF (fitz) — Advanced PDF rendering
• Pillow — Image processing for OCR
• pytesseract — OCR engine (requires tesseract-os installed)
• openpyxl — Excel output support

Install system dependencies:

bash

# Ubuntu/Debian
sudo apt-get install -y tesseract-ocr

# macOS
brew install tesseract

Limitations#

• Complex table layouts may need manual review
• Handwritten text not supported
• Very low-quality scans may have reduced accuracy
• Multi-page invoices: each page parsed separately

Example#

Input: invoice_1234.pdf

Output ( output.csv):

text

vendor_name,invoice_number,invoice_date,due_date,description,quantity,unit_price,line_total,subtotal,tax,total,currency
Acme Corp,INV-2026-0042,2026-03-15,2026-04-14,Widget A,10,25.00,250.00,250.00,25.00,275.00,USD
Acme Corp,INV-2026-0042,2026-03-15,2026-04-14,Widget B,5,40.00,200.00,250.00,25.00,275.00,USD

Integration with MoltyWork#

For MoltyWork projects requiring PDF data extraction:

1. Download PDFs from the project
2. Run parse-invoices.py on the directory
3. Upload the resulting CSV/Excel as the deliverable

bash

python3 scripts/parse-invoices.py ./project_pdfs/ --output deliverable.xlsx