05-12-2026-023-INV-003-PART-02

{
  "tax": 65.62,
  "notes": "Vendor branch #1657 omitted from vendor_name. Source Order #1019060. Primary Bath items. Ship-to: 5503 Lakeview Drive, Edina MN. 1 of 2 SHRSB820RGPN shipped here; the second shipped on invoice 1066218-1. Tax jurisdiction: Hennepin Co.",
  "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
}

{
  "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 plumbing fixtures and supplies: pressure-balance valve trim (SHEL441001PN), lever handle for pressure-balance trim (SHEL441002PN), shower arm with escutcheon (SHRSA123PN), and a round rain showerhead (SHRSB820RGPN). These are classic plumbing fixtures for a construction/renovation project (Lakeview - SH Items). Per the Ferguson vendor-specific notes, construction materials, plumbing supplies, and fixtures map to Building Materials; and among the allowed categories, 'Plumbing' (cat_173f2c1a36d74231bf0b9d9c755c7b0d) is the correct match for plumbing fixtures and supplies.",
    "confidence": 0.98,
    "category_name": "Plumbing",
    "expense_category_id": "cat_173f2c1a36d74231bf0b9d9c755c7b0d",
    "quickbooks_account_id": "113",
    "selected_expense_category_id": "cat_173f2c1a36d74231bf0b9d9c755c7b0d",
    "selected_expense_category_name": "Plumbing"
  }
}

{
  "lookup": {
    "quickbooks_vendor_id": "6",
    "quickbooks_account_id": "113",
    "existing_quickbooks_bill_id": null
  },
  "bill_created": {
    "path": "multi_category_direct",
    "total": "835.26",
    "due_date": "2025-02-12",
    "doc_number": "1066218",
    "vendor_ref": "6",
    "account_ref": "113",
    "jkath_terms": "Net 30",
    "vendor_terms": "Net 10th Prox",
    "quickbooks_bill_id": "281",
    "resolved_expense_category_id": "cat_173f2c1a36d74231bf0b9d9c755c7b0d"
  },
  "attachment_uploaded": {
    "path": "multi_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "281"
  }
}

{
  "multi_invoice_count": 6,
  "multi_invoice_index": 2,
  "multi_invoice_group_id": "bill_83aca42375684eb5a921c45a3f23b6c8",
  "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 project). Invoice 1237469 is for customer 554796 (Shamp project). Invoice 1260154 is for customer 550191 (Lodewyks project). All invoices dated January 13–14, 2025. Master account number 737714 across all invoices.",
    "invoices": [
      {
        "tax": 675.26,
        "notes": "Vendor branch #1657 omitted from vendor_name. Ship-to: 5503 Lakeview Drive, Edina MN. Customer order: 5503 Lakeview Drive. Two line items (DD20015008415 and DD23005C000415 first instance) show 0 shipped and $0.00 amount — omitted from line_items as zero-charge rows. Some unit prices in line_items appear inconsistent with amounts due to partial shipments or invoice layout; amounts reflect values as printed.",
        "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": 359.264,
            "description": "CCY 1.28 RH EB BOWL *FITZGE CVWH (DD23005C000415)"
          },
          {
            "qty": 1,
            "amount": 359.26,
            "unit_price": 274.392,
            "description": "CCY 1.28 GPF TANK *FITZGE CVWH (DD24005A101415)"
          },
          {
            "qty": 1,
            "amount": 359.26,
            "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 #1019060. Primary Bath items. Ship-to: 5503 Lakeview Drive, Edina MN. 1 of 2 SHRSB820RGPN shipped here; the second shipped on invoice 1066218-1. Tax jurisdiction: Hennepin Co.",
        "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. Source Order #1019060. Primary Bath — backorder/second shipment of SHRSB820RGPN. Tax jurisdiction: Edina (different from invoice 1066218 which used Hennepin Co). Tax code MN308 vs MN430 on prior invoices.",
        "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)"
          }
        ],
        "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. Customer #554796 (different from Lakeview invoices). Source Order #0971049. Customer order: 15890 York Circle NW. Tax jurisdiction: Dakota County. Ship-to: JKATH office address (not job site).",
        "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. Customer #550191. Source Order #0820348. Customer order: 8701 Bentwood Dr. Tax jurisdiction: Dakota County. Ship-to: JKATH office address.",
        "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. Customer #552382. Source Order #0882558. Customer order: 5503 Lakeview Dr. Tax jurisdiction: Dakota County. Ship-to: JKATH office address. Note: same customer number (552382) as Lakeview invoices 1019060, 1066218, and 1260171, but job name is Zawoyski - Hood.",
        "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
      }
    ]
  }
}