05-12-2026-031-INV-003

{
  "tax": 30.36,
  "notes": "Freight of $10.00 is listed as a separate line outside subtotal and is captured in the shipping field. Transportation Fee ($7.50) and Laminate Box Fee ($13.00) are additional charges included in the total but outside the subtotal; they are included as line items. Line 40 (NJ109-3959-48) appears to have two unit types (SH at $27.20 and SF at $0.85); the SF row amount appears to be $0.00 or bundled — extracted separately for clarity. No project/job name stated on invoice. Account manager: Dan Sanford. Two deliveries: #8028109368 via UPS Ground from Vernon Hills, and #8028116962 via SpeeDee from Plymouth.",
  "terms": null,
  "total": 416.98,
  "due_date": "2025-04-25",
  "shipping": 10,
  "subtotal": 356.12,
  "confidence": {
    "total": 0.99,
    "vendor_name": 0.99,
    "invoice_date": 0.99,
    "project_name": 0,
    "invoice_number": 0.99
  },
  "line_items": [
    {
      "qty": 3,
      "amount": 81.6,
      "unit_price": 27.2,
      "description": "NJ109-3959-48 BLACK, .039, MATTE 048X096 - SH"
    },
    {
      "qty": 96,
      "amount": 0,
      "unit_price": 0.85,
      "description": "NJ109-3959-48 BLACK, .039, MATTE 048X096 - SF"
    },
    {
      "qty": 500,
      "amount": 205,
      "unit_price": 0.41,
      "description": "WT680MAPLE-7/8PF CVR EDGEBND PREFIN MAPLE 7/8 - LF"
    },
    {
      "qty": 1,
      "amount": 69.52,
      "unit_price": 69.52,
      "description": "RU716041-604 15/16\"X.018\" FINNISH OAK 600FT RL"
    },
    {
      "qty": null,
      "amount": 7.5,
      "unit_price": null,
      "description": "Transportation Fee"
    },
    {
      "qty": null,
      "amount": 13,
      "unit_price": null,
      "description": "Laminate Box Fee"
    }
  ],
  "vendor_name": "Wurth Baer Supply Company",
  "invoice_date": "2025-03-10",
  "project_name": null,
  "document_type": "invoice",
  "invoice_number": "9025154149",
  "is_billable_invoice": true
}

{
  "alias_lookup": {
    "found": true,
    "alias_id": "cmp1abc80002gagtbmydf0e3a",
    "vendor_id": "vend_6e94477adc5349d785d0d21b6aee89f9",
    "alias_name": "Wurth Baer Supply Company",
    "canonical_name": "Wurth Baer Supply",
    "category_count": 2,
    "category_options": [
      {
        "name": "Cabinet Materials",
        "notes": "Mapped from JKath historical QuickBooks export: Building Materials:Cabinet Materials (7).",
        "expense_category_id": "cat_8d2d70e75bdd439fb2060c07463e1a62",
        "fully_qualified_name": "Building Materials:Cabinet Materials",
        "quickbooks_account_id": "105",
        "vendor_expense_category_id": "cmp1bavf2001o13pf1mgb7md5"
      },
      {
        "name": "Hardwood Flooring",
        "notes": "Mapped from JKath historical QuickBooks export: Building Services:Hardwood Flooring (1).",
        "expense_category_id": "cat_d5dace0f278e449ca0384e78e093b5e4",
        "fully_qualified_name": "Building Services:Hardwood Flooring",
        "quickbooks_account_id": "128",
        "vendor_expense_category_id": "cmp1bavhl001q13pfyr3n6ifk"
      }
    ],
    "expense_category_id": null,
    "normalized_alias_key": "wurth baer supply company",
    "quickbooks_vendor_id": "115",
    "quickbooks_account_id": null,
    "default_expense_account": null,
    "invoice_processing_notes": null,
    "missing_category_options": false
  },
  "category_selection": {
    "reason": "Wurth Baer Supply Company is a well-known distributor of cabinet and millwork materials. The line items include black laminate sheets (NJ109-3959-48 BLACK MATTE), prefinished maple edge banding (WT680MAPLE-7/8PF CVR EDGEBND PREFIN MAPLE), and Finnish Oak edge banding roll (RU716041-604 FINNISH OAK), along with a Laminate Box Fee. These are all classic cabinet-making materials — laminate panels and edge banding are core components used in cabinet fabrication and finishing. While Finnish Oak edge banding could theoretically relate to flooring, edge banding in this context (purchased from a cabinet supply vendor alongside laminate sheets and maple edge banding) is overwhelmingly consistent with cabinet construction. Cabinet Materials is the correct category.",
    "confidence": 0.92,
    "category_name": "Cabinet Materials",
    "expense_category_id": "cat_8d2d70e75bdd439fb2060c07463e1a62",
    "quickbooks_account_id": "105",
    "selected_expense_category_id": "cat_8d2d70e75bdd439fb2060c07463e1a62",
    "selected_expense_category_name": "Cabinet Materials"
  }
}

{
  "lookup": {
    "quickbooks_vendor_id": "115",
    "quickbooks_account_id": "105",
    "existing_quickbooks_bill_id": null
  },
  "bill_created": {
    "path": "multi_category_direct",
    "total": "416.98",
    "due_date": "2025-04-09",
    "doc_number": "9025154149",
    "vendor_ref": "115",
    "account_ref": "105",
    "jkath_terms": "Net 30",
    "vendor_terms": "",
    "quickbooks_bill_id": "354",
    "resolved_expense_category_id": "cat_8d2d70e75bdd439fb2060c07463e1a62"
  },
  "attachment_uploaded": {
    "path": "multi_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "354"
  }
}

{
  "run_id": "run_62091358572745b4a9fb86801339837b",
  "source": "make.com",
  "run_key": "05-12-2026-031",
  "make_trace_id": "make-20260512_002952_270",
  "source_file_name": "Wurth 9025154149.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/Wurth 9025154149.pdf",
  "source_dropbox_id": "id:CHX6_xJiKhAAAAAAAABjYQ",
  "source_dropbox_rev": "0165198231f4cf300000003549f4393",
  "multi_invoice_count": 1,
  "multi_invoice_index": 1,
  "source_content_hash": "d66b13d000d690e74b97dfc2696ae5ed86a91d0be8f647e7c031188a42234e55",
  "processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/Wurth 9025154149.pdf",
  "multi_invoice_group_id": "bill_11ecfd7960514efb997c13d391cae7a7",
  "processing_dropbox_rev": "0165198296f30c900000003549f4393",
  "multi_invoice_source_payload": {
    "notes": "Single invoice (9025154149) spanning two pages from Wurth Baer Supply Company (Wurth Holdahl Company division). PDF contained only one invoice.",
    "invoices": [
      {
        "tax": 30.36,
        "notes": "Freight of $10.00 is listed as a separate line outside subtotal and is captured in the shipping field. Transportation Fee ($7.50) and Laminate Box Fee ($13.00) are additional charges included in the total but outside the subtotal; they are included as line items. Line 40 (NJ109-3959-48) appears to have two unit types (SH at $27.20 and SF at $0.85); the SF row amount appears to be $0.00 or bundled — extracted separately for clarity. No project/job name stated on invoice. Account manager: Dan Sanford. Two deliveries: #8028109368 via UPS Ground from Vernon Hills, and #8028116962 via SpeeDee from Plymouth.",
        "terms": null,
        "total": 416.98,
        "due_date": "2025-04-25",
        "shipping": 10,
        "subtotal": 356.12,
        "confidence": {
          "total": 0.99,
          "vendor_name": 0.99,
          "invoice_date": 0.99,
          "project_name": 0,
          "invoice_number": 0.99
        },
        "line_items": [
          {
            "qty": 3,
            "amount": 81.6,
            "unit_price": 27.2,
            "description": "NJ109-3959-48 BLACK, .039, MATTE 048X096 - SH"
          },
          {
            "qty": 96,
            "amount": 0,
            "unit_price": 0.85,
            "description": "NJ109-3959-48 BLACK, .039, MATTE 048X096 - SF"
          },
          {
            "qty": 500,
            "amount": 205,
            "unit_price": 0.41,
            "description": "WT680MAPLE-7/8PF CVR EDGEBND PREFIN MAPLE 7/8 - LF"
          },
          {
            "qty": 1,
            "amount": 69.52,
            "unit_price": 69.52,
            "description": "RU716041-604 15/16\"X.018\" FINNISH OAK 600FT RL"
          },
          {
            "qty": null,
            "amount": 7.5,
            "unit_price": null,
            "description": "Transportation Fee"
          },
          {
            "qty": null,
            "amount": 13,
            "unit_price": null,
            "description": "Laminate Box Fee"
          }
        ],
        "vendor_name": "Wurth Baer Supply Company",
        "invoice_date": "2025-03-10",
        "project_name": null,
        "document_type": "invoice",
        "invoice_number": "9025154149",
        "is_billable_invoice": true
      }
    ]
  }
}