05-13-2026-002-INV-001

{
  "tax": 874.32,
  "notes": "Store/location suffix #1657 omitted from vendor_name. Delivery, haul away, and USETAX line items were $0.00 and excluded from line_items. Tax is Hennepin Co $874.32. Customer #550191.",
  "terms": "NET 10TH PROX",
  "total": 11130.32,
  "due_date": null,
  "shipping": 0,
  "subtotal": 10256,
  "confidence": {
    "total": 1,
    "vendor_name": 1,
    "invoice_date": 1,
    "project_name": 0.95,
    "invoice_number": 1
  },
  "line_items": [
    {
      "qty": 1,
      "amount": 7679,
      "unit_price": 7679,
      "description": "30\" Panel-Ready Fridge - BB30IB905SP (Serial: 224070518360006826)"
    },
    {
      "qty": 1,
      "amount": 1049,
      "unit_price": 1049,
      "description": "CCY BI DW PARE 24 5CYC - BSHV53CM3N (Serial: 104090529714021401)"
    },
    {
      "qty": 1,
      "amount": 1329,
      "unit_price": 1329,
      "description": "CCY LF CUST PNL BVRG CNTR 6 24 - ZPRB24C01CPG (Serial: 1305905JYK)"
    },
    {
      "qty": 1,
      "amount": 199,
      "unit_price": 199,
      "description": "*CVR* SOLID PNL RDY DR COMPACT - ZPRPNLC24A"
    }
  ],
  "vendor_name": "Ferguson Enterprises LLC",
  "invoice_date": "2025-02-28",
  "project_name": "LODEWYKS - 8701 BENTWOOD DR",
  "document_type": "invoice",
  "invoice_number": "0820348",
  "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": "All four line items are appliances: a panel-ready refrigerator (BB30IB905SP), a built-in dishwasher (BSHV53CM3N), a beverage center (ZPRB24C01CPG), and a solid panel cover for a compact door-ready unit (ZPRPNLC24A). These are appliance products, not plumbing supplies, fixtures, pipes, or valves. The Appliances category (mapped from Building Materials:Appliances) is the correct match over Plumbing.",
    "confidence": 0.97,
    "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": "11130.32",
    "due_date": "2025-03-30",
    "doc_number": "0820348",
    "vendor_ref": "6",
    "account_ref": "104",
    "jkath_terms": "Net 30",
    "vendor_terms": "NET 10TH PROX",
    "quickbooks_bill_id": "425",
    "resolved_expense_category_id": "cat_6815fb48c53f4221ad0130eaa34c6238"
  },
  "attachment_uploaded": {
    "path": "multi_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "425"
  }
}

{
  "run_id": "run_0a915e17aae14b60a4148e1401bc68d7",
  "source": "make.com",
  "run_key": "05-13-2026-002",
  "make_trace_id": "make-20260512_192608_318",
  "source_file_name": "Ferguson - only enter BENTWOOD invoices perKK_REVIEW.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/Ferguson - only enter BENTWOOD invoices perKK_REVIEW.pdf",
  "source_dropbox_id": "id:CHX6_xJiKhAAAAAAAABing",
  "source_dropbox_rev": "01651a806240da200000003549f4393",
  "multi_invoice_count": 6,
  "multi_invoice_index": 1,
  "source_content_hash": "548721bdff6024181aa877eda3945fdd85d93914df87fcbbbf8139923decb433",
  "processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/Ferguson - only enter BENTWOOD invoices perKK_REVIEW.pdf",
  "multi_invoice_group_id": "bill_29c8e1e6e1584ee0af21451fda2f6546",
  "processing_dropbox_rev": "01651a806c58dc500000003549f4393",
  "multi_invoice_source_payload": {
    "notes": "PDF contains 6 separate invoices from Ferguson Enterprises LLC (store #1657, Golden Valley MN). Two invoices relate to the LODEWYKS job at 8701 Bentwood Dr, Eden Prairie (customer 550191); two relate to the ZAWOYSKI job at 5503 Lakeview Dr, Edina (customer 552382); and two are zero-dollar JOB PRE SITE invoices (one per job). All invoices dated 02/28/25, Batch IO 379407, Salesman PMH. Line items classified as Building Materials per vendor-specific processing notes.",
    "invoices": [
      {
        "tax": 874.32,
        "notes": "Store/location suffix #1657 omitted from vendor_name. Delivery, haul away, and USETAX line items were $0.00 and excluded from line_items. Tax is Hennepin Co $874.32. Customer #550191.",
        "terms": "NET 10TH PROX",
        "total": 11130.32,
        "due_date": null,
        "shipping": 0,
        "subtotal": 10256,
        "confidence": {
          "total": 1,
          "vendor_name": 1,
          "invoice_date": 1,
          "project_name": 0.95,
          "invoice_number": 1
        },
        "line_items": [
          {
            "qty": 1,
            "amount": 7679,
            "unit_price": 7679,
            "description": "30\" Panel-Ready Fridge - BB30IB905SP (Serial: 224070518360006826)"
          },
          {
            "qty": 1,
            "amount": 1049,
            "unit_price": 1049,
            "description": "CCY BI DW PARE 24 5CYC - BSHV53CM3N (Serial: 104090529714021401)"
          },
          {
            "qty": 1,
            "amount": 1329,
            "unit_price": 1329,
            "description": "CCY LF CUST PNL BVRG CNTR 6 24 - ZPRB24C01CPG (Serial: 1305905JYK)"
          },
          {
            "qty": 1,
            "amount": 199,
            "unit_price": 199,
            "description": "*CVR* SOLID PNL RDY DR COMPACT - ZPRPNLC24A"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-02-28",
        "project_name": "LODEWYKS - 8701 BENTWOOD DR",
        "document_type": "invoice",
        "invoice_number": "0820348",
        "is_billable_invoice": true
      },
      {
        "tax": 2.99,
        "notes": "Store/location suffix #1657 omitted from vendor_name. Source Order# 0820348. Items not shipped (36\" Induction Range FOR36SCI6B1, FPBUILDERVF, PRD628204L) had $0.00 amount and are excluded. Delivery line was $0.00 and excluded. Tax is Hennepin Co $2.99. Customer #550191.",
        "terms": "NET 10TH PROX",
        "total": 37.99,
        "due_date": null,
        "shipping": 0,
        "subtotal": 35,
        "confidence": {
          "total": 1,
          "vendor_name": 1,
          "invoice_date": 1,
          "project_name": 0.95,
          "invoice_number": 1
        },
        "line_items": [
          {
            "qty": 1,
            "amount": 15,
            "unit_price": 15,
            "description": "LFA 1/4 X 1/4 C 60 SS IM CONN - PFX146205"
          },
          {
            "qty": 1,
            "amount": 20,
            "unit_price": 20,
            "description": "LF 3/8X3/8 C 72 DW CONN W/ FHT ELL - PFXSD6C72ET"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-02-28",
        "project_name": "LODEWYKS - 8701 BENTWOOD DR",
        "document_type": "invoice",
        "invoice_number": "0820397",
        "is_billable_invoice": true
      },
      {
        "tax": 0,
        "notes": "Store/location suffix #1657 omitted from vendor_name. Tax code MNI - no tax applied (ZAWOYSKI NO TAX). Delivery line was $0.00 and excluded. Rebate lines are negative amounts reducing the total. Customer #552382.",
        "terms": "NET 10TH PROX",
        "total": 12925,
        "due_date": null,
        "shipping": 0,
        "subtotal": 12925,
        "confidence": {
          "total": 1,
          "vendor_name": 1,
          "invoice_date": 1,
          "project_name": 0.95,
          "invoice_number": 1
        },
        "line_items": [
          {
            "qty": 1,
            "amount": 1999,
            "unit_price": 1999,
            "description": "*CVR* CCY LFA 24 CUST PNL SAPPHIRE - TDWHD660EPR (Serial: 104080201222004172)"
          },
          {
            "qty": 1,
            "amount": -1499,
            "unit_price": -1499,
            "description": "THERMADOR BUY 1-2 GET 1 FREE REBATE - THERMADORREBTEVF"
          },
          {
            "qty": 1,
            "amount": 11625,
            "unit_price": 11625,
            "description": "*CVR* CCY LF 42 INTEG FD 2DWR E-ST - TT42IT100NP (Serial: 224050201101001469)"
          },
          {
            "qty": 1,
            "amount": 3149,
            "unit_price": 3149,
            "description": "*CVR* CCY PRO SPEED OVEN 30 208-240 - TMC30WP (Serial: 904095941989778094)"
          },
          {
            "qty": 1,
            "amount": -2349,
            "unit_price": -2349,
            "description": "THERMADOR BUY 1-2 GET 1 FREE REBATE - THERMADORREBTEVF"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-02-28",
        "project_name": "ZAWOYSKI - 5503 LAKEVIEW DR",
        "document_type": "invoice",
        "invoice_number": "0882558",
        "is_billable_invoice": true
      },
      {
        "tax": 1032.37,
        "notes": "Store/location suffix #1657 omitted from vendor_name. Tax is Edina $1032.37. Delivery line was $0.00 and excluded. Job name ZAWOYSKI TAX ITEMS. Customer #552382.",
        "terms": "NET 10TH PROX",
        "total": 12471.37,
        "due_date": null,
        "shipping": 0,
        "subtotal": 11439,
        "confidence": {
          "total": 1,
          "vendor_name": 1,
          "invoice_date": 1,
          "project_name": 0.95,
          "invoice_number": 1
        },
        "line_items": [
          {
            "qty": 1,
            "amount": 11439,
            "unit_price": 11439,
            "description": "CCY FS RNGE SS 48 NAT 6 BRNR W/ GRD - TPRG486WDG (Serial: 394100296957000531)"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-02-28",
        "project_name": "ZAWOYSKI - 5503 LAKEVIEW DR",
        "document_type": "invoice",
        "invoice_number": "0882593",
        "is_billable_invoice": true
      },
      {
        "tax": 0,
        "notes": "Zero-dollar invoice for JOB PRE SITE service. Source Order# 0820348. Total is $0.00 - needs human review. Set is_billable_invoice to false due to zero balance. Customer #550191.",
        "terms": "NET 10TH PROX",
        "total": 0,
        "due_date": null,
        "shipping": 0,
        "subtotal": 0,
        "confidence": {
          "total": 1,
          "vendor_name": 1,
          "invoice_date": 1,
          "project_name": 0.95,
          "invoice_number": 1
        },
        "line_items": [],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-02-28",
        "project_name": "LODEWYKS - 8701 BENTWOOD DR",
        "document_type": "invoice",
        "invoice_number": "1257061",
        "is_billable_invoice": false
      },
      {
        "tax": 0,
        "notes": "Zero-dollar invoice for JOB PRE SITE service. Source Order# 1311869. Total is $0.00 - needs human review. Set is_billable_invoice to false due to zero balance. Tax code MNI - ZAWOYSKI NO TAX. Customer #552382.",
        "terms": "NET 10TH PROX",
        "total": 0,
        "due_date": null,
        "shipping": 0,
        "subtotal": 0,
        "confidence": {
          "total": 1,
          "vendor_name": 1,
          "invoice_date": 1,
          "project_name": 0.95,
          "invoice_number": 1
        },
        "line_items": [],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-02-28",
        "project_name": "ZAWOYSKI - 5503 LAKEVIEW DR",
        "document_type": "invoice",
        "invoice_number": "1311904",
        "is_billable_invoice": false
      }
    ]
  }
}