05-13-2026-004-INV-001

{
  "tax": 0,
  "notes": "No invoice date is printed on this handwritten invoice. The printed total reads '13,175.00' but there is also a handwritten note at the bottom reading 'TOTAL = 3,18' (possibly 3,175 or a partial subtotal for extra work items only). The main printed TOTAL of 13,175.00 has been used as the invoice total. Line item amounts are partially legible from handwriting; some amounts are ambiguous (e.g., '$300' for extra Farrow & Ball paint, '$280' for exterior window, '$750' for exterior porch windows trim). The sum of extracted line items is $13,205 which does not perfectly reconcile to $13,175 — human review recommended. The 'last payment $10,000' appears to be the base contract payment amount, not a prior payment deduction. Ship-to address is 3919 East 49th St, Minneapolis, MN 55406 (Stealth Desing Build). OCR quality is moderate due to handwritten form.",
  "terms": null,
  "total": 13175,
  "due_date": null,
  "shipping": 0,
  "subtotal": 13175,
  "confidence": {
    "total": 0.72,
    "vendor_name": 0.97,
    "invoice_date": 0,
    "project_name": 0.92,
    "invoice_number": 0.95
  },
  "line_items": [
    {
      "qty": null,
      "amount": 10000,
      "unit_price": null,
      "description": "Paint: Windows, Casing, baseboard/shoe, Crown molding, repair same windows, door casing, powder room panel, Sun porch walls/ceilings"
    },
    {
      "qty": null,
      "amount": 550,
      "unit_price": null,
      "description": "Extra work - Stairs walls basement"
    },
    {
      "qty": null,
      "amount": 1000,
      "unit_price": null,
      "description": "Extra work - Fix door stain"
    },
    {
      "qty": null,
      "amount": 325,
      "unit_price": null,
      "description": "Extra paint Farrow & Ball / porch floor"
    },
    {
      "qty": null,
      "amount": 280,
      "unit_price": null,
      "description": "Exterior window"
    },
    {
      "qty": null,
      "amount": 300,
      "unit_price": null,
      "description": "Extra paint Farrow & Ball (additional)"
    },
    {
      "qty": null,
      "amount": 750,
      "unit_price": null,
      "description": "Exterior porch windows trim"
    }
  ],
  "vendor_name": "DLG Painting LLC",
  "invoice_date": null,
  "project_name": "5503 Lakeview, Edina",
  "document_type": "invoice",
  "invoice_number": "738982",
  "is_billable_invoice": true
}

{
  "alias_lookup": {
    "found": true,
    "alias_id": "cmp1abiyk007sagtbrtgq2cfq",
    "vendor_id": "vend_a5aa9cd33c484136b0aefafdc738cfac",
    "alias_name": "DLG Painting LLC",
    "canonical_name": "DLG Painting LLC",
    "category_count": 1,
    "category_options": [
      {
        "name": "Painting",
        "notes": "Mapped from JKath historical QuickBooks export: Building Services:Painting (36).",
        "expense_category_id": "cat_5cd8cff9602249029902722ebd6e200d",
        "fully_qualified_name": "Building Services:Painting",
        "quickbooks_account_id": "134",
        "vendor_expense_category_id": "cmp1bb19q004y13pf4qt3j0hl"
      }
    ],
    "expense_category_id": "cat_5cd8cff9602249029902722ebd6e200d",
    "normalized_alias_key": "dlg painting llc",
    "quickbooks_vendor_id": "48",
    "quickbooks_account_id": "134",
    "default_expense_account": "Painting",
    "invoice_processing_notes": null,
    "missing_category_options": false
  },
  "category_selection": {
    "method": "single_assignable_category",
    "reason": "Vendor has exactly one assignable expense category, so the category was assigned without a Claude category-selection call.",
    "confidence": 1,
    "category_name": "Painting",
    "expense_category_id": "cat_5cd8cff9602249029902722ebd6e200d",
    "quickbooks_account_id": "134",
    "selected_expense_category_id": "cat_5cd8cff9602249029902722ebd6e200d",
    "selected_expense_category_name": "Painting"
  }
}

No payload stored.

{
  "run_id": "run_f1ed1cc417da48d2a76d84462d2452f7",
  "source": "make.com",
  "run_key": "05-13-2026-004",
  "make_trace_id": "make-20260512_202408_049",
  "source_file_name": "DLG Lakeview Invoice_VALIDATION-FAILED.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/DLG Lakeview Invoice_VALIDATION-FAILED.pdf",
  "source_dropbox_id": "id:CHX6_xJiKhAAAAAAAABihQ",
  "source_dropbox_rev": "01651a8d0d8cffe00000003549f4393",
  "multi_invoice_count": 1,
  "multi_invoice_index": 1,
  "source_content_hash": "41aaa31e1f0f9dc18fb35508e17d12d8e06827c82b89f3058912d63dcdccb69d",
  "processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/DLG Lakeview Invoice_VALIDATION-FAILED.pdf",
  "multi_invoice_group_id": "bill_f009957106e4425b9554b02f559a4a1d",
  "processing_dropbox_rev": "01651a8d62eba3900000003549f4393",
  "multi_invoice_source_payload": {
    "notes": "Single handwritten invoice on a pre-printed Adams 5840 invoice form. Invoice number 738982 is printed in red at top right. No date field is filled in. Sold to: DLG Painting LLC, 6236 Scott Ave N, Brooklyn Center 55429. Ship to: Stealth Desing Build, 3919 East 49th St, Minneapolis, MN 55406. Total is ambiguous due to handwriting; primary printed total of $13,175.00 used. Human review recommended for line item reconciliation and missing invoice date.",
    "invoices": [
      {
        "tax": 0,
        "notes": "No invoice date is printed on this handwritten invoice. The printed total reads '13,175.00' but there is also a handwritten note at the bottom reading 'TOTAL = 3,18' (possibly 3,175 or a partial subtotal for extra work items only). The main printed TOTAL of 13,175.00 has been used as the invoice total. Line item amounts are partially legible from handwriting; some amounts are ambiguous (e.g., '$300' for extra Farrow & Ball paint, '$280' for exterior window, '$750' for exterior porch windows trim). The sum of extracted line items is $13,205 which does not perfectly reconcile to $13,175 — human review recommended. The 'last payment $10,000' appears to be the base contract payment amount, not a prior payment deduction. Ship-to address is 3919 East 49th St, Minneapolis, MN 55406 (Stealth Desing Build). OCR quality is moderate due to handwritten form.",
        "terms": null,
        "total": 13175,
        "due_date": null,
        "shipping": 0,
        "subtotal": 13175,
        "confidence": {
          "total": 0.72,
          "vendor_name": 0.97,
          "invoice_date": 0,
          "project_name": 0.92,
          "invoice_number": 0.95
        },
        "line_items": [
          {
            "qty": null,
            "amount": 10000,
            "unit_price": null,
            "description": "Paint: Windows, Casing, baseboard/shoe, Crown molding, repair same windows, door casing, powder room panel, Sun porch walls/ceilings"
          },
          {
            "qty": null,
            "amount": 550,
            "unit_price": null,
            "description": "Extra work - Stairs walls basement"
          },
          {
            "qty": null,
            "amount": 1000,
            "unit_price": null,
            "description": "Extra work - Fix door stain"
          },
          {
            "qty": null,
            "amount": 325,
            "unit_price": null,
            "description": "Extra paint Farrow & Ball / porch floor"
          },
          {
            "qty": null,
            "amount": 280,
            "unit_price": null,
            "description": "Exterior window"
          },
          {
            "qty": null,
            "amount": 300,
            "unit_price": null,
            "description": "Extra paint Farrow & Ball (additional)"
          },
          {
            "qty": null,
            "amount": 750,
            "unit_price": null,
            "description": "Exterior porch windows trim"
          }
        ],
        "vendor_name": "DLG Painting LLC",
        "invoice_date": null,
        "project_name": "5503 Lakeview, Edina",
        "document_type": "invoice",
        "invoice_number": "738982",
        "is_billable_invoice": true
      }
    ]
  }
}