05-12-2026-023-INV-001

{
  "tax": 278.57,
  "notes": "Vendor branch/store suffix #1657 omitted from vendor_name. Ship-to: Luisa & Erick Peterson, 2258 Saint Clair Ave, Saint Paul, MN 55105. Tax jurisdiction: St Paul. Customer order number: 2258 SAINT CLAIR AVE. Customer number: 199557.",
  "terms": "Net 10th Prox",
  "total": 3099.54,
  "due_date": null,
  "shipping": 0,
  "subtotal": 2820.97,
  "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": 752.06,
      "unit_price": 752.06,
      "description": "31X19 0H 1B UC FRCLY SINK *ALLIA WH (R630700)"
    },
    {
      "qty": 1,
      "amount": 778.88,
      "unit_price": 778.88,
      "description": "CCY LFA 1.8 1HDL LEV PD KITC FCT (D63074LFGL)"
    },
    {
      "qty": 1,
      "amount": 95.36,
      "unit_price": 95.36,
      "description": "DISP & FLG STPR KITC LUGO (D69070GL)"
    },
    {
      "qty": 1,
      "amount": 176.25,
      "unit_price": 176.25,
      "description": "3/4 HP GARBAGE DISP W/ CORD *BADGER (IBADGER5XPWC)"
    },
    {
      "qty": 1,
      "amount": 74.75,
      "unit_price": 74.75,
      "description": "15X12 UC VC LAV *CAXTON WHIT (K2209-0)"
    },
    {
      "qty": 1,
      "amount": 263.97,
      "unit_price": 263.97,
      "description": "LFA MANHATTAN W/SPRD B/ROOM FAUCE (KFSC8920CML)"
    },
    {
      "qty": 1,
      "amount": 184.2,
      "unit_price": 184.2,
      "description": "CCY @ CLST TANK *MEMSTA WHIT 1.28 (K4434-0)"
    },
    {
      "qty": 1,
      "amount": 243.1,
      "unit_price": 243.1,
      "description": "CCY 1.28 12 EB *COMHEI BO (K5626-0)"
    },
    {
      "qty": 1,
      "amount": 45.54,
      "unit_price": 45.54,
      "description": "QC EB SEAT READYLATCH *GLENBU WHIT (K4733-RL-0)"
    },
    {
      "qty": 1,
      "amount": 93.81,
      "unit_price": 93.812,
      "description": "FLUSH LEV *GREYFIELD MB (SHGF100TLMB)"
    },
    {
      "qty": 1,
      "amount": 113.05,
      "unit_price": 113.05,
      "description": "PVT PAPER HLDR *GREYF MB (SHGFTHMB)"
    }
  ],
  "vendor_name": "Ferguson Enterprises LLC",
  "invoice_date": "2025-01-06",
  "project_name": "Peterson - Plumbing",
  "document_type": "invoice",
  "invoice_number": "0873035",
  "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 line items are plumbing fixtures and supplies (kitchen sink, faucets, garbage disposal, lavatory, toilet tank, toilet bowl, toilet seat, flush lever, paper holder) for the 'Peterson - Plumbing' project. The vendor-specific notes direct Ferguson invoices with construction/job materials to Building Materials, and the allowed category that maps to plumbing supplies and fixtures is 'Plumbing' (cat_173f2c1a36d74231bf0b9d9c755c7b0d), which is explicitly mapped from 'Building Materials:Plumbing' in the QuickBooks export.",
    "confidence": 0.97,
    "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": "3099.54",
    "due_date": "2025-02-05",
    "doc_number": "0873035",
    "vendor_ref": "6",
    "account_ref": "113",
    "jkath_terms": "Net 30",
    "vendor_terms": "Net 10th Prox",
    "quickbooks_bill_id": "278",
    "resolved_expense_category_id": "cat_173f2c1a36d74231bf0b9d9c755c7b0d"
  },
  "attachment_uploaded": {
    "path": "multi_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "278"
  }
}

{
  "run_id": "run_6092f96a7725437c8df731d125a7b07c",
  "source": "make.com",
  "run_key": "05-12-2026-023",
  "make_trace_id": "make-20260511_214451_732",
  "source_file_name": "FergusonEnterprisesLLC_INV-1065982.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/FergusonEnterprisesLLC_INV-1065982.pdf",
  "source_dropbox_id": "id:CHX6_xJiKhAAAAAAAABp-A",
  "source_dropbox_rev": "0165195cbd0ab0600000003549f4393",
  "multi_invoice_count": 2,
  "multi_invoice_index": 1,
  "source_content_hash": "76ea5836c52d0b23939ef4a7563d8589c32af7ca0179c9a3b9c6c0f45d1c3781",
  "processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/FergusonEnterprisesLLC_INV-1065982.pdf",
  "multi_invoice_group_id": "bill_574f1833f6c44257965171ad324ffc40",
  "processing_dropbox_rev": "0165195d90ecab100000003549f4393",
  "multi_invoice_source_payload": {
    "notes": "PDF contains two separate invoices from Ferguson Enterprises LLC: Invoice 0873035 (Peterson - Plumbing, $3,099.54) and Invoice 1065982 (Shamp - Finish, $7,202.62), both dated 2025-01-06. Both share Master Account Number 737714 and Batch IO 374369 but are distinct invoices with different invoice numbers, customers, ship-to addresses, and totals.",
    "invoices": [
      {
        "tax": 278.57,
        "notes": "Vendor branch/store suffix #1657 omitted from vendor_name. Ship-to: Luisa & Erick Peterson, 2258 Saint Clair Ave, Saint Paul, MN 55105. Tax jurisdiction: St Paul. Customer order number: 2258 SAINT CLAIR AVE. Customer number: 199557.",
        "terms": "Net 10th Prox",
        "total": 3099.54,
        "due_date": null,
        "shipping": 0,
        "subtotal": 2820.97,
        "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": 752.06,
            "unit_price": 752.06,
            "description": "31X19 0H 1B UC FRCLY SINK *ALLIA WH (R630700)"
          },
          {
            "qty": 1,
            "amount": 778.88,
            "unit_price": 778.88,
            "description": "CCY LFA 1.8 1HDL LEV PD KITC FCT (D63074LFGL)"
          },
          {
            "qty": 1,
            "amount": 95.36,
            "unit_price": 95.36,
            "description": "DISP & FLG STPR KITC LUGO (D69070GL)"
          },
          {
            "qty": 1,
            "amount": 176.25,
            "unit_price": 176.25,
            "description": "3/4 HP GARBAGE DISP W/ CORD *BADGER (IBADGER5XPWC)"
          },
          {
            "qty": 1,
            "amount": 74.75,
            "unit_price": 74.75,
            "description": "15X12 UC VC LAV *CAXTON WHIT (K2209-0)"
          },
          {
            "qty": 1,
            "amount": 263.97,
            "unit_price": 263.97,
            "description": "LFA MANHATTAN W/SPRD B/ROOM FAUCE (KFSC8920CML)"
          },
          {
            "qty": 1,
            "amount": 184.2,
            "unit_price": 184.2,
            "description": "CCY @ CLST TANK *MEMSTA WHIT 1.28 (K4434-0)"
          },
          {
            "qty": 1,
            "amount": 243.1,
            "unit_price": 243.1,
            "description": "CCY 1.28 12 EB *COMHEI BO (K5626-0)"
          },
          {
            "qty": 1,
            "amount": 45.54,
            "unit_price": 45.54,
            "description": "QC EB SEAT READYLATCH *GLENBU WHIT (K4733-RL-0)"
          },
          {
            "qty": 1,
            "amount": 93.81,
            "unit_price": 93.812,
            "description": "FLUSH LEV *GREYFIELD MB (SHGF100TLMB)"
          },
          {
            "qty": 1,
            "amount": 113.05,
            "unit_price": 113.05,
            "description": "PVT PAPER HLDR *GREYF MB (SHGFTHMB)"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-01-06",
        "project_name": "Peterson - Plumbing",
        "document_type": "invoice",
        "invoice_number": "0873035",
        "is_billable_invoice": true
      },
      {
        "tax": 541.27,
        "notes": "Vendor branch/store suffix #1657 omitted from vendor_name. Ship-to: JKATH Design Build - Shamp Jobsite, 15890 York Circle NW, Anoka, MN 55303. Tax jurisdiction: Anoka County. Customer order number: 15890 YORK CIR NW. Customer number: 554796. Note: same item number K20000-0 appears on two separate lines (qty 1 and qty 2) as ordered/shipped; extracted as two separate line items matching the invoice. Some unit prices have more than 2 decimal places as printed on invoice.",
        "terms": "Net 10th Prox",
        "total": 7202.62,
        "due_date": null,
        "shipping": 0,
        "subtotal": 6661.35,
        "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": 94.25,
            "unit_price": 94.25,
            "description": "@ 20-5/16X15-3/4 VC UC LAV WHIT (K20000-0)"
          },
          {
            "qty": 2,
            "amount": 188.5,
            "unit_price": 94.25,
            "description": "@ 20-5/16X15-3/4 VC UC LAV WHIT (K20000-0)"
          },
          {
            "qty": 1,
            "amount": 277.03,
            "unit_price": 277.03,
            "description": "15X15 0H 1B TM QTZ SINK WHIT (EELG1616WH0)"
          },
          {
            "qty": 1,
            "amount": 695.04,
            "unit_price": 695.04,
            "description": "CCY LFA 1.8 1HDL LEV KITC FCT LUGO (D63375LFGLLHP)"
          },
          {
            "qty": 1,
            "amount": 546.56,
            "unit_price": 546.56,
            "description": "CCY LFA 1.8 1HDL PD PREP FCT LUGO (D63975LFGLLHP)"
          },
          {
            "qty": 1,
            "amount": 491.52,
            "unit_price": 491.52,
            "description": "CCN LFA 1.5 2HDL LEV W/SPRD LAV FCT (D65360LFPNLHP)"
          },
          {
            "qty": 1,
            "amount": 152.32,
            "unit_price": 152.32,
            "description": "LAV LEV HDL KIT *ROOK (DHL5360PN)"
          },
          {
            "qty": 1,
            "amount": 79.36,
            "unit_price": 79.36,
            "description": "PD FCT LEV HDL *ODIN LUGO (DHLK175GL)"
          },
          {
            "qty": 1,
            "amount": 79.36,
            "unit_price": 79.36,
            "description": "PD FCT LEV HDL *ODIN LUGO (DHLK175GL)"
          },
          {
            "qty": 2,
            "amount": 404.16,
            "unit_price": 202.08,
            "description": "CCY LFA 1.2 2HDL LEV CC LAV FCT (D2535CZMPUDST)"
          },
          {
            "qty": 1,
            "amount": 249.82,
            "unit_price": 249.82,
            "description": "@ CCY LFA 1.8 1HDL PD KITC FCT (D9113ARDST)"
          },
          {
            "qty": 1,
            "amount": 227.39,
            "unit_price": 227.392,
            "description": "CCY 1HDL LEV WALL VLV TRIM *SAYLOR (DT14435CZ)"
          },
          {
            "qty": 1,
            "amount": 84.96,
            "unit_price": 84.96,
            "description": "16 SHWR ARM *CASSID BRPN (DRP61273PN)"
          },
          {
            "qty": 1,
            "amount": 207.33,
            "unit_price": 207.328,
            "description": "@ CCN 2.5 SHWRHD *CASSID PN (DRP72568PN)"
          },
          {
            "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": 1,
            "amount": 290.95,
            "unit_price": 290.95,
            "description": "24X19 1H 1B SS UC LDRY UTIL SINK (KKHU10124L)"
          },
          {
            "qty": 2,
            "amount": 958.27,
            "unit_price": 479.136,
            "description": "CCY LFA 2HDL W/SPRD LAV MTL PU (D3597LFPNMPU)"
          },
          {
            "qty": 1,
            "amount": 117.7,
            "unit_price": 117.696,
            "description": "2 LEV RT HDL KIT *CASSID BRPN (DH697PN)"
          },
          {
            "qty": 1,
            "amount": 59.87,
            "unit_price": 59.872,
            "description": "SGL LEV BATH HDL KIT *CASSID B (DH797PN)"
          },
          {
            "qty": 1,
            "amount": 16.93,
            "unit_price": 16.928,
            "description": "2-1/2 SHWR FLG LUMICOAT PN (DRP6025PNPR)"
          },
          {
            "qty": 1,
            "amount": 183.46,
            "unit_price": 183.456,
            "description": "VLV TRIM *CASSID 14 SER BRPN (DT14097PNLHP)"
          },
          {
            "qty": 1,
            "amount": 473.09,
            "unit_price": 473.088,
            "description": "CCY 1.75 BRPN *CASSID RT W/ H/ (DT4797PNLHP)"
          },
          {
            "qty": 1,
            "amount": 55.08,
            "unit_price": 55.08,
            "description": "SINK STRN DRN FTG WHIT (ELKQS35WH)"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-01-06",
        "project_name": "Shamp - Finish",
        "document_type": "invoice",
        "invoice_number": "1065982",
        "is_billable_invoice": true
      }
    ]
  }
}