05-12-2026-026-INV-024

{
  "tax": 22.16,
  "notes": "Vendor branch #1657 omitted from vendor_name. One line item (PRO RANGE SM UNDER 48 INSTALL, item ;FACPRS) was ordered but not shipped (qty shipped = 0) and shows $0.00 amount; excluded from line_items. Source Order# 0820348. Tax is Hennepin County tax of $22.16. Customer order number: 8701 BENTWOOD DR.",
  "terms": "Net 10th Prox",
  "total": 1407.16,
  "due_date": null,
  "shipping": 0,
  "subtotal": 1385,
  "confidence": {
    "total": 0.99,
    "vendor_name": 0.99,
    "invoice_date": 0.99,
    "project_name": 0.95,
    "invoice_number": 0.99
  },
  "line_items": [
    {
      "qty": 1,
      "amount": 300,
      "unit_price": 300,
      "description": "BI REFRIG 36\" OR SMALLER INSTALL"
    },
    {
      "qty": 2,
      "amount": 300,
      "unit_price": 150,
      "description": "CUSTOM PNL FULL INSTALL"
    },
    {
      "qty": 1,
      "amount": 225,
      "unit_price": 225,
      "description": "DW INSTALL"
    },
    {
      "qty": 1,
      "amount": 150,
      "unit_price": 150,
      "description": "CUSTOM PNL FULL INSTALL"
    },
    {
      "qty": 1,
      "amount": 50,
      "unit_price": 50,
      "description": "FS REFRIG/FREEZER INST"
    },
    {
      "qty": 1,
      "amount": 150,
      "unit_price": 150,
      "description": "CUSTOM PNL FULL INSTALL"
    },
    {
      "qty": 1,
      "amount": 175,
      "unit_price": 175,
      "description": "DOOR REVERSAL PRO"
    },
    {
      "qty": 1,
      "amount": 35,
      "unit_price": 35,
      "description": "DOOR REVERSAL STANDARD"
    }
  ],
  "vendor_name": "Ferguson Enterprises LLC",
  "invoice_date": "2025-03-03",
  "project_name": "Lodewyks - 8701 Bentwood Dr",
  "document_type": "invoice",
  "invoice_number": "1256884",
  "is_billable_invoice": true
}

{
  "alias_lookup": {
    "found": true,
    "alias_id": "alias_1e2f326fecee46f5b955324a2e70975d",
    "vendor_id": "vendor_15ec102255844f479fc29f8cb9362b73",
    "alias_name": "Ferguson Enterprises LLC",
    "canonical_name": "Ferguson Enterprises LLC",
    "category_count": 2,
    "category_options": [
      {
        "name": "Appliances",
        "notes": "Mapped from JKath historical QuickBooks export: Building Materials:Appliances (52).",
        "expense_category_id": "cat_6815fb48c53f4221ad0130eaa34c6238",
        "fully_qualified_name": "Building Materials:Appliances",
        "quickbooks_account_id": "104",
        "vendor_expense_category_id": "cmp1baudl001213pfmu17sj8z"
      },
      {
        "name": "Plumbing",
        "notes": "Mapped from JKath historical QuickBooks export: Building Materials:Plumbing (100).",
        "expense_category_id": "cat_173f2c1a36d74231bf0b9d9c755c7b0d",
        "fully_qualified_name": "Building Materials:Plumbing",
        "quickbooks_account_id": "113",
        "vendor_expense_category_id": "cmp1baug5001413pfbfb4fs2m"
      }
    ],
    "expense_category_id": null,
    "normalized_alias_key": "ferguson enterprises llc",
    "quickbooks_vendor_id": "6",
    "quickbooks_account_id": null,
    "default_expense_account": null,
    "invoice_processing_notes": "For Ferguson invoices, choose Building Materials for construction materials, plumbing supplies, fixtures, pipes, valves, and job materials. Choose Purchases only for general resale or non-project purchase invoices when the line items are not construction/job materials.",
    "missing_category_options": false
  },
  "category_selection": {
    "reason": "The line items describe appliance installation services: built-in refrigerator install, dishwasher install, freestanding refrigerator/freezer install, door reversals, and custom panel full installs. These are all appliance-related installation charges from Ferguson Enterprises on a residential project (Lodewyks - 8701 Bentwood Dr). The Appliances category (mapped from Building Materials:Appliances) is the correct fit over Plumbing, as none of the line items relate to plumbing supplies, pipes, valves, or fixtures.",
    "confidence": 0.92,
    "category_name": "Appliances",
    "expense_category_id": "cat_6815fb48c53f4221ad0130eaa34c6238",
    "quickbooks_account_id": "104",
    "selected_expense_category_id": "cat_6815fb48c53f4221ad0130eaa34c6238",
    "selected_expense_category_name": "Appliances"
  }
}

{
  "lookup": {
    "quickbooks_vendor_id": "6",
    "quickbooks_account_id": "104",
    "existing_quickbooks_bill_id": null
  },
  "bill_created": {
    "path": "multi_category_direct",
    "total": "1407.16",
    "due_date": "2025-04-02",
    "doc_number": "1256884",
    "vendor_ref": "6",
    "account_ref": "104",
    "jkath_terms": "Net 30",
    "vendor_terms": "Net 10th Prox",
    "quickbooks_bill_id": "317",
    "resolved_expense_category_id": "cat_6815fb48c53f4221ad0130eaa34c6238"
  },
  "attachment_uploaded": {
    "path": "multi_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "317"
  }
}

{
  "run_id": "run_d3dcb6acd0044649867411b977067fec",
  "source": "make.com",
  "run_key": "05-12-2026-026",
  "make_trace_id": "make-20260511_230756_287",
  "source_file_name": "737714_20250305_30393977_14043903045.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/737714_20250305_30393977_14043903045.pdf",
  "source_dropbox_id": "id:CHX6_xJiKhAAAAAAAABinA",
  "source_dropbox_rev": "0165196d22e4d1500000003549f4393",
  "multi_invoice_count": 2,
  "multi_invoice_index": 1,
  "source_content_hash": "f1f5f4a2ddf8bd961003640af7029b76383203b6c462ad0c5798a8d55b5657d9",
  "processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/737714_20250305_30393977_14043903045.pdf",
  "multi_invoice_group_id": "bill_323d8007228e41e38e5e178a79987948",
  "processing_dropbox_rev": "016519718b4b3f500000003549f4393",
  "multi_invoice_source_payload": {
    "notes": "PDF contains two separate invoices from Ferguson Enterprises LLC (branch #1657), both dated 2025-03-03. Invoice 1256884 is for the Lodewyks project at 8701 Bentwood Dr, Eden Prairie MN. Invoice 1311869 is for the Zawoyski project at 5503 Lakeview Drive, Edina MN. Totals are kept separate and not combined.",
    "invoices": [
      {
        "tax": 22.16,
        "notes": "Vendor branch #1657 omitted from vendor_name. One line item (PRO RANGE SM UNDER 48 INSTALL, item ;FACPRS) was ordered but not shipped (qty shipped = 0) and shows $0.00 amount; excluded from line_items. Source Order# 0820348. Tax is Hennepin County tax of $22.16. Customer order number: 8701 BENTWOOD DR.",
        "terms": "Net 10th Prox",
        "total": 1407.16,
        "due_date": null,
        "shipping": 0,
        "subtotal": 1385,
        "confidence": {
          "total": 0.99,
          "vendor_name": 0.99,
          "invoice_date": 0.99,
          "project_name": 0.95,
          "invoice_number": 0.99
        },
        "line_items": [
          {
            "qty": 1,
            "amount": 300,
            "unit_price": 300,
            "description": "BI REFRIG 36\" OR SMALLER INSTALL"
          },
          {
            "qty": 2,
            "amount": 300,
            "unit_price": 150,
            "description": "CUSTOM PNL FULL INSTALL"
          },
          {
            "qty": 1,
            "amount": 225,
            "unit_price": 225,
            "description": "DW INSTALL"
          },
          {
            "qty": 1,
            "amount": 150,
            "unit_price": 150,
            "description": "CUSTOM PNL FULL INSTALL"
          },
          {
            "qty": 1,
            "amount": 50,
            "unit_price": 50,
            "description": "FS REFRIG/FREEZER INST"
          },
          {
            "qty": 1,
            "amount": 150,
            "unit_price": 150,
            "description": "CUSTOM PNL FULL INSTALL"
          },
          {
            "qty": 1,
            "amount": 175,
            "unit_price": 175,
            "description": "DOOR REVERSAL PRO"
          },
          {
            "qty": 1,
            "amount": 35,
            "unit_price": 35,
            "description": "DOOR REVERSAL STANDARD"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-03-03",
        "project_name": "Lodewyks - 8701 Bentwood Dr",
        "document_type": "invoice",
        "invoice_number": "1256884",
        "is_billable_invoice": true
      },
      {
        "tax": 0,
        "notes": "Vendor branch #1657 omitted from vendor_name. Tax code MNI with job name 'ZAWOYSKI NO TAX' — no tax applied. Source Orders #0882558 and #0882593. Customer order number: 5503 LAKEVIEW DR.",
        "terms": "Net 10th Prox",
        "total": 1925,
        "due_date": null,
        "shipping": 0,
        "subtotal": 1925,
        "confidence": {
          "total": 0.99,
          "vendor_name": 0.99,
          "invoice_date": 0.99,
          "project_name": 0.95,
          "invoice_number": 0.99
        },
        "line_items": [
          {
            "qty": 1,
            "amount": 225,
            "unit_price": 225,
            "description": "DW INSTALL"
          },
          {
            "qty": 1,
            "amount": 350,
            "unit_price": 350,
            "description": "BI REFRIG 42\" OR LARGER INSTALL"
          },
          {
            "qty": 4,
            "amount": 600,
            "unit_price": 150,
            "description": "CUSTOM PNL FULL INSTALL"
          },
          {
            "qty": 1,
            "amount": 200,
            "unit_price": 200,
            "description": "BI MWAVE W/ TRIM KIT INSTALL"
          },
          {
            "qty": 1,
            "amount": 550,
            "unit_price": 550,
            "description": "PRO RANGE LG 48"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-03-03",
        "project_name": "Zawoyski - 5503 Lakeview Drive",
        "document_type": "invoice",
        "invoice_number": "1311869",
        "is_billable_invoice": true
      }
    ]
  }
}