本地发票PDF批量提取校验并转Excel

本站独立编写，按原页“严格 JSON schema、校验必填和小计”描述实现；接入位置与输出解析器需在模板内核对。

你是发票结构化抽取器。只根据给定文本抽取，禁止猜测、禁止补银行账号或真实个人信息。返回且仅返回符合 schema 的 JSON；金额用数字不用千分位；日期统一 YYYY-MM-DD；无法确定用 null。schema={"type":"object","additionalProperties":false,"required":["invoice_number","invoice_date","seller_name","buyer_name","currency","subtotal","tax","total","line_items"],"properties":{"invoice_number":{"type":["string","null"]},"invoice_date":{"type":["string","null"]},"seller_name":{"type":["string","null"]},"buyer_name":{"type":["string","null"]},"currency":{"type":["string","null"]},"subtotal":{"type":["number","null"]},"tax":{"type":["number","null"]},"total":{"type":["number","null"]},"line_items":{"type":"array","items":{"type":"object","additionalProperties":false,"required":["description","quantity","unit_price","amount"],"properties":{"description":{"type":"string"},"quantity":{"type":"number"},"unit_price":{"type":"number"},"amount":{"type":"number"}}}}}}。校验规则：必填字段非空；每个 amount≈quantity*unit_price；subtotal≈行项目 amount 之和；total≈subtotal+tax；容差 0.01；币种为 CNY/USD/EUR 之一或 null。

INV-2026-0002 故意让行项目 100 与 subtotal 90 不一致，应进 invalid；全是虚构演示数据。

{
  "excel_invoice_row": {"invoice_number":"header.invoice_number","invoice_date":"header.invoice_date","seller_name":"header.seller_name","buyer_name":"header.buyer_name","currency":"header.currency","subtotal":"header.subtotal","tax":"header.tax","total":"header.total","validation_status":"valid|invalid|error","source_pdf":"file.name"},
  "excel_line_row": {"invoice_number":"header.invoice_number","line_no":"index+1","description":"item.description","quantity":"item.quantity","unit_price":"item.unit_price","amount":"item.amount"},
  "report_columns": ["run_id","start_time","end_time","total","valid","invalid","error","duration_seconds"],
  "test_invoice_csv": "invoice_number,invoice_date,seller_name,buyer_name,currency,description,quantity,unit_price,amount,subtotal,tax,total\nINV-2026-0001,2026-09-01,示例供应商有限公司,演示采购部,CNY,云存储 100GB 月费,2,49.5,99,99,5.94,104.94\nINV-2026-0002,2026-09-02,示例供应商有限公司,演示采购部,CNY,备份服务 月费,1,100,100,90,5.4,104.94"
}

仅本地隔离测试示例；密码必须替换，OpenAI key 放 n8n credentials 而非写进 compose；版本未核实前不保证命令可运行。

services:
  n8n:
    image: n8nio/n8n:latest
    environment:
      - NODE_FUNCTION_ALLOW_BUILTIN=fs,path
      - N8N_RESTRICT_FILE_ACCESS_TO=/invoices
      - N8N_BASIC_AUTH_ACTIVE=true
      - N8N_BASIC_AUTH_USER=demo_admin
      - N8N_BASIC_AUTH_PASSWORD=replace_with_local_only_password
    volumes:
      - ./invoices:/invoices
      - ./n8n-data:/home/node/.n8n
    ports:
      - "127.0.0.1:5678:5678"