05-12-2026-021-INV-003-PART-05

{
  "tax": 80.52,
  "notes": "Vendor branch #1657 omitted from vendor_name. Source Order: 0820348. Customer order: 8701 BENTWOOD DR. Tax jurisdiction: Dakota County. Ship to: JKATH DESIGN BUILD & RIENVENT, 1408 NORTHLAND DRIVE SUITE 304, MENDOTA HEIGHTS MN 55120. Customer number 550191.",
  "terms": "Net 10th Prox",
  "total": 1071.52,
  "due_date": null,
  "shipping": 0,
  "subtotal": 991,
  "confidence": {
    "total": 0.99,
    "vendor_name": 0.99,
    "invoice_date": 0.99,
    "project_name": 0.99,
    "invoice_number": 0.99
  },
  "line_items": [
    {
      "qty": 1,
      "amount": 991,
      "unit_price": 991,
      "description": "*CVR* CCY 34 3/8 300 CFM WM LNR INS (VBH134SLDGS) Serial# XDL363961"
    }
  ],
  "vendor_name": "Ferguson Enterprises LLC",
  "invoice_date": "2025-01-14",
  "project_name": "Lodewyks - Hood",
  "document_type": "invoice",
  "invoice_number": "1260154",
  "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 item 'CCY 34 3/8 300 CFM WM LNR INS (VBH134SLDGS)' with a serial number is a range hood/ventilation appliance (300 CFM hood liner insert), consistent with the project context 'Lodewyks - Hood'. This is an appliance unit rather than raw plumbing supplies, pipes, or valves, making the Appliances category the correct match over Plumbing.",
    "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": "1071.52",
    "due_date": "2025-02-13",
    "doc_number": "1260154",
    "vendor_ref": "6",
    "account_ref": "104",
    "jkath_terms": "Net 30",
    "vendor_terms": "Net 10th Prox",
    "quickbooks_bill_id": "268",
    "resolved_expense_category_id": "cat_6815fb48c53f4221ad0130eaa34c6238"
  },
  "attachment_uploaded": {
    "path": "multi_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "268"
  }
}

{
  "multi_invoice_count": 6,
  "multi_invoice_index": 5,
  "multi_invoice_group_id": "bill_a6b3d356d77b41aca17b9044f3826dc0",
  "multi_invoice_source_payload": {
    "notes": "PDF contains 6 separate invoices from Ferguson Enterprises LLC (branch #1657, Golden Valley MN). Invoices 1019060, 1066218, 1066218-1, and 1260171 are for customer 552382 (Lakeview/Zawoyski projects). Invoice 1237469 is for customer 554796 (Shamp project, 15890 York Circle NW). Invoice 1260154 is for customer 550191 (Lodewyks project, 8701 Bentwood Dr). All invoices dated January 13-14, 2025 with Net 10th Prox terms. All remit to Ferguson Enterprises LLC #1657, PO Box 802817, Chicago IL 60680-2817 under Master Account 737714.",
    "invoices": [
      {
        "tax": 675.26,
        "notes": "Vendor branch #1657 omitted from vendor_name. Two line items (DD20015008415 and DD23005C000415 first instance) show 0 shipped and $0.00 amount — omitted from line_items as zero-charge rows. Some line items appear duplicated with different unit prices (DD24005A101415, DD35700020150, D35548LFPNMPU) — extracted as shown on invoice. Customer order: 5503 LAKEVIEW DRIVE. Ship to: JKATH - LAKEVIEW, 5503 LAKEVIEW DRIVE, EDINA MN 55424.",
        "terms": "Net 10th Prox",
        "total": 8595.91,
        "due_date": null,
        "shipping": 0,
        "subtotal": 7920.65,
        "confidence": {
          "total": 0.99,
          "vendor_name": 0.99,
          "invoice_date": 0.99,
          "project_name": 0.99,
          "invoice_number": 0.99
        },
        "line_items": [
          {
            "qty": 1,
            "amount": 139.68,
            "unit_price": 139.68,
            "description": "1/2HP GARBAGE DISP W/ CORD *BADGER (IBADGER5WC)"
          },
          {
            "qty": 2,
            "amount": 318.89,
            "unit_price": 159.445,
            "description": "VC VERTICYL RECT UC LAV (K2882-0)"
          },
          {
            "qty": 2,
            "amount": 318.89,
            "unit_price": 159.445,
            "description": "VC VERTICYL RECT UC LAV (K2882-0)"
          },
          {
            "qty": 2,
            "amount": 1214.38,
            "unit_price": 607.188,
            "description": "CCY LFA 1.2 2HDL LEV W/SPRD LAV FCT (K35908-4-2MB)"
          },
          {
            "qty": 1,
            "amount": 778.88,
            "unit_price": 778.88,
            "description": "CCY LFA 1.8 1HDL LEV PD KITC FCT (D63074LFGL)"
          },
          {
            "qty": 1,
            "amount": 186.24,
            "unit_price": 186.24,
            "description": "AIR SWCH W/ DU OUT (D69080GL)"
          },
          {
            "qty": 1,
            "amount": 351.31,
            "unit_price": 351.31,
            "description": "CCY LFA 1.8 1HDL LEV PD KITC FCT (D9113CZDST)"
          },
          {
            "qty": 1,
            "amount": 224.44,
            "unit_price": 224.44,
            "description": "CCY LF 1.2 1HDL LEV 1H LAV FCT PN (H04771830)"
          },
          {
            "qty": 1,
            "amount": 282.6,
            "unit_price": 282.6,
            "description": "CCY 1.28 GPF EB W/ SEAT *CADET III (A3075000020)"
          },
          {
            "qty": 1,
            "amount": 282.6,
            "unit_price": 282.6,
            "description": "CCY 1.28 GPF EB W/ SEAT *CADET III (A3075000020)"
          },
          {
            "qty": 1,
            "amount": 81.6,
            "unit_price": 81.6,
            "description": "CCY 1.28 CLST TANK *CADET III WHIT (A4000101020)"
          },
          {
            "qty": 1,
            "amount": 81.6,
            "unit_price": 81.6,
            "description": "CCY 1.28 CLST TANK *CADET III WHIT (A4000101020)"
          },
          {
            "qty": 2,
            "amount": 625.1,
            "unit_price": 312.55,
            "description": "CCY LFA 1.2 W/SPRD LAV *PENDL PN (SHWSCPT807PN)"
          },
          {
            "qty": 1,
            "amount": 1079.44,
            "unit_price": 1079.44,
            "description": "CONS STND *FITZGE PN (DD21410128008)"
          },
          {
            "qty": 1,
            "amount": 493.58,
            "unit_price": 493.576,
            "description": "CCY 1.28 RH EB BOWL *FITZGE CVWH (DD23005C000415)"
          },
          {
            "qty": 1,
            "amount": 274.39,
            "unit_price": 274.392,
            "description": "CCY 1.28 GPF TANK *FITZGE CVWH (DD24005A101415)"
          },
          {
            "qty": 1,
            "amount": 395.33,
            "unit_price": 395.328,
            "description": "CCY 1.28 GPF TANK *FITZGE CVWH (DD24005A101415)"
          },
          {
            "qty": 1,
            "amount": 274.39,
            "unit_price": 274.392,
            "description": "DECO P-TRAP PN (DD35700020150)"
          },
          {
            "qty": 1,
            "amount": 395.33,
            "unit_price": 395.328,
            "description": "X CCY LFA 2HDL W/SPRD **BOWERY (D35548LFPNMPU)"
          },
          {
            "qty": 1,
            "amount": 73.18,
            "unit_price": 73.184,
            "description": "@ 4-1/2 KITC FLG & STRN STAI (D72010SS)"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-01-13",
        "project_name": "Lakeview - Finish",
        "document_type": "invoice",
        "invoice_number": "1019060",
        "is_billable_invoice": true
      },
      {
        "tax": 65.62,
        "notes": "Vendor branch #1657 omitted from vendor_name. Source Order referenced: 1019060. Section labeled *** PRIMARY BATH ***. Tax jurisdiction: Hennepin Co. Customer order: 5503 LAKEVIEW DRIVE. Ship to: JKATH - LAKEVIEW, 5503 LAKEVIEW DRIVE, EDINA MN 55424. 1 of 2 ordered SHRSB820RGPN shipped here; remaining 1 shipped on invoice 1066218-1.",
        "terms": "Net 10th Prox",
        "total": 835.26,
        "due_date": null,
        "shipping": 0,
        "subtotal": 769.64,
        "confidence": {
          "total": 0.99,
          "vendor_name": 0.99,
          "invoice_date": 0.99,
          "project_name": 0.99,
          "invoice_number": 0.99
        },
        "line_items": [
          {
            "qty": 2,
            "amount": 323.52,
            "unit_price": 161.761,
            "description": "1HDL P/BAL VLV TRIM L/HDL *ELITA PN (SHEL441001PN)"
          },
          {
            "qty": 2,
            "amount": 139.65,
            "unit_price": 69.825,
            "description": "LEV HDL F/ P/BAL TRIM *ELITA PN (SHEL441002PN)"
          },
          {
            "qty": 2,
            "amount": 202.92,
            "unit_price": 101.459,
            "description": "12 SHWR ARM F/ RNSHWR W/ ESC PN (SHRSA123PN)"
          },
          {
            "qty": 1,
            "amount": 103.55,
            "unit_price": 103.547,
            "description": "CCY 1.75 8 RND RNSHWR SHWRHD PN (SHRSB820RGPN)"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-01-13",
        "project_name": "Lakeview - SH Items",
        "document_type": "invoice",
        "invoice_number": "1066218",
        "is_billable_invoice": true
      },
      {
        "tax": 9.35,
        "notes": "Vendor branch #1657 omitted from vendor_name. This is a back-order/partial shipment continuation of invoice 1066218 (Source Order: 1019060). Tax jurisdiction: Edina (MN308) rather than Hennepin Co as on 1066218. Customer order: 5503 LAKEVIEW DRIVE. Ship to: JKATH - LAKEVIEW, 5503 LAKEVIEW DRIVE, EDINA MN 55424.",
        "terms": "Net 10th Prox",
        "total": 112.9,
        "due_date": null,
        "shipping": 0,
        "subtotal": 103.55,
        "confidence": {
          "total": 0.99,
          "vendor_name": 0.99,
          "invoice_date": 0.99,
          "project_name": 0.99,
          "invoice_number": 0.99
        },
        "line_items": [
          {
            "qty": 1,
            "amount": 103.55,
            "unit_price": 103.547,
            "description": "CCY 1.75 8 RND RNSHWR SHWRHD PN (SHRSB820RGPN) - *** PRIMARY BATH ***"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-01-14",
        "project_name": "Lakeview - SH Items",
        "document_type": "invoice",
        "invoice_number": "1066218-1",
        "is_billable_invoice": true
      },
      {
        "tax": 72.23,
        "notes": "Vendor branch #1657 omitted from vendor_name. Source Order: 0971049. Customer order: 15890 YORK CIRCLE NW. Tax jurisdiction: Dakota County. Ship to: JKATH DESIGN BUILD & RIENVENT, 1408 NORTHLAND DRIVE SUITE 304, MENDOTA HEIGHTS MN 55120. Customer number 554796 differs from other invoices (552382).",
        "terms": "Net 10th Prox",
        "total": 961.23,
        "due_date": null,
        "shipping": 0,
        "subtotal": 889,
        "confidence": {
          "total": 0.99,
          "vendor_name": 0.99,
          "invoice_date": 0.99,
          "project_name": 0.99,
          "invoice_number": 0.99
        },
        "line_items": [
          {
            "qty": 1,
            "amount": 889,
            "unit_price": 889,
            "description": "CCY 48 600 CFM SS RNGE HOOD (ZAK9546AS) Serial# 1174559BYU"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-01-14",
        "project_name": "Shamp - Hood",
        "document_type": "invoice",
        "invoice_number": "1237469",
        "is_billable_invoice": true
      },
      {
        "tax": 80.52,
        "notes": "Vendor branch #1657 omitted from vendor_name. Source Order: 0820348. Customer order: 8701 BENTWOOD DR. Tax jurisdiction: Dakota County. Ship to: JKATH DESIGN BUILD & RIENVENT, 1408 NORTHLAND DRIVE SUITE 304, MENDOTA HEIGHTS MN 55120. Customer number 550191.",
        "terms": "Net 10th Prox",
        "total": 1071.52,
        "due_date": null,
        "shipping": 0,
        "subtotal": 991,
        "confidence": {
          "total": 0.99,
          "vendor_name": 0.99,
          "invoice_date": 0.99,
          "project_name": 0.99,
          "invoice_number": 0.99
        },
        "line_items": [
          {
            "qty": 1,
            "amount": 991,
            "unit_price": 991,
            "description": "*CVR* CCY 34 3/8 300 CFM WM LNR INS (VBH134SLDGS) Serial# XDL363961"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-01-14",
        "project_name": "Lodewyks - Hood",
        "document_type": "invoice",
        "invoice_number": "1260154",
        "is_billable_invoice": true
      },
      {
        "tax": 144.71,
        "notes": "Vendor branch #1657 omitted from vendor_name. Source Order: 0882558. Customer order: 5503 LAKEVIEW DR. Tax jurisdiction: Dakota County. Ship to: JKATH DESIGN BUILD & RIENVENT, 1408 NORTHLAND DRIVE SUITE 304, MENDOTA HEIGHTS MN 55120. Customer number 552382.",
        "terms": "Net 10th Prox",
        "total": 1925.71,
        "due_date": null,
        "shipping": 0,
        "subtotal": 1781,
        "confidence": {
          "total": 0.99,
          "vendor_name": 0.99,
          "invoice_date": 0.99,
          "project_name": 0.99,
          "invoice_number": 0.99
        },
        "line_items": [
          {
            "qty": 1,
            "amount": 1781,
            "unit_price": 1781,
            "description": "*CVR* CCY 46 3/8 600 CFM WM LNR INS (VBH246PSLDGS) Serial# XCL356718"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-01-14",
        "project_name": "Zawoyski - Hood",
        "document_type": "invoice",
        "invoice_number": "1260171",
        "is_billable_invoice": true
      }
    ]
  }
}