I stopped copy-pasting invoice PDFs into Excel—here’s the workflow that held up

Description and use

Automated invoice processing: replaced manual PDF-to-Excel copy‑paste with Dianwu.AI Flow, speeding up work and reducing errors.

Manual copy‑pasting of invoice PDFs into Excel was time‑consuming and error‑prone, especially with scanned or dense line‑item tables.

The workflow reduced manual copy‑paste time, improved data accuracy, and allowed scaling to 500 conversions/month with a $5/month plan.

1. Gather real invoice files (text PDF, scanned PDF, dense table) and keep originals beside exported sheets.
2. Upload each PDF to Dianwu.AI Flow via web UI or API.
3. Verify extracted fields: vendor, invoice number, date, currency, subtotal, tax, total, and line‑item boundaries.
4. Identify recurring failure modes on a small batch; if consistent, automate the handoff instead of writing per‑supplier rules.
5. For occasional batches, use the web UI; for higher volume, use the API (https://flow.dianwu.ai) with API key prefix dwflow_.
6. Measure correction time on representative invoices; if rows and totals are preserved, accept the output; otherwise, route to human review queue.

The hard part is preserving relationships between fields and rows when the input is a scan, has a stamp over it, or contains a dense line‑item table.

For the web step, I have been trying Dianwu.AI Flow at https://dianwu.ai for invoice/bill PDFs, including scans, into Excel-shaped structured data.