AI/AIZENME
🧾 AUTOMATION · Agents & IoT Level: Intermediate ⏱ 40 MIN Free & Open Source

Auto-Enter Invoice Photos into Excel with PaddleOCR + an LLM

Open-source PaddleOCR reads invoice text and layout, an LLM extracts amount, tax ID and date fields with sum checks, and rows are written straight into a spreadsheet.

CORE TOOLS PaddleOCR, DeepSeek, Python, openpyxl
BEST FOR Accountants, small business owners, admin and expense staff
REQUIREMENTS Able to run Python; an LLM API key; store invoice images securely
✦ WHY THIS WORKFLOW

Invoice entry is high-volume, rule-based and error-prone. OCR reads, the LLM understands and code validates, keeping errors low.

✦ Interactive Workflow Animation Preview

Step-by-Step Action Checklist

0 / 4 Completed
READY-TO-USE PROMPT TEMPLATE
Open Official Tool / Repo ↗
Below is OCR text from an invoice. Output JSON only with no explanation: {"invoice_no":"","date":"YYYY-MM-DD","seller":"","tax_id":"","amount":0,"tax":0,"total":0}.
Use null for missing fields, never guess; amounts must be numbers.
If the text looks clearly incomplete, also output "need_review": true.
[OCR text]
Use Cases & Tags:
Expense entrySmall-business bookkeepingInvoice reconciliationVendor document filing#ocr#paddleocr#excel