Invoice Record

05-12-2026-024-INV-004

Ferguson Enterprises LLC

Back to vendor

Bill Created Successfully

QuickBooks Bill created successfully. Source file attached to the Bill.

View Bill in QB View Invoice in Dropbox

Status

Created in QB

Invoice

1019060

Total

$8,595.91

Invoice data

Detected vendor: Ferguson Enterprises LLC
Matched vendor: Ferguson Enterprises LLC
Matched alias: Ferguson Enterprises LLC
Category: Building Materials:Plumbing
Category method: Claude category selection
Invoice date: 01/13/2025
Due date: 02/12/2025
Vendor terms: Net 10th Prox
Jkath terms: Net 30
QB Bill ID: 291

Category reason

All line items on this Ferguson invoice are plumbing fixtures and supplies for the Lakeview - Finish project, including toilets (Cadet III, Fitzgerald), lavatory sinks (Verticyl rectangular under-counter lavs), faucets (kitchen and lavatory faucets in multiple finishes), a garbage disposal (Badger 5), a P-trap, a kitchen flange/strainer, and an air switch. These are construction/job plumbing materials, and the vendor-specific notes direct Ferguson invoices with plumbing supplies and fixtures to Building Materials. Among the two allowed categories, 'Plumbing' (cat_173f2c1a36d74231bf0b9d9c755c7b0d) is the correct match as it maps to Building Materials:Plumbing, which precisely covers all items on this invoice. The 'Appliances' category could apply to the garbage disposal, but the overwhelming majority of items are plumbing fixtures and faucets, making Plumbing the best single category.

File result

Final file: FergusonEnterprisesLLC_INV-1260171.pdf
Outcome: processed
Details: QuickBooks Bill created successfully. Source file attached to the Bill.

View Bill in QuickBooks View Invoice in Dropbox

Processing Context

Invoice ID: 05-12-2026-024-INV-004
Run ID: 05-12-2026-024
Source folder: /_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed
Source file: FergusonEnterprisesLLC_INV-1260171.pdf

Stored payloads

Claude parse payload

{
  "tax": 675.26,
  "notes": "Vendor branch #1657 omitted from vendor_name. Items DD20015008415 (28X21-3/4 3H PED FRCLY LAV *FITZGE, qty 0 shipped, $0.00) and DD23005C000415 first instance (qty 0 shipped, $0.00) were skipped as zero-amount lines. Some unit prices in line_items appear inconsistent with amounts due to partial shipments or invoice formatting; amounts reflect values as printed. 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": 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
}

Vendor match payload

{
  "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 on this Ferguson invoice are plumbing fixtures and supplies for the Lakeview - Finish project, including toilets (Cadet III, Fitzgerald), lavatory sinks (Verticyl rectangular under-counter lavs), faucets (kitchen and lavatory faucets in multiple finishes), a garbage disposal (Badger 5), a P-trap, a kitchen flange/strainer, and an air switch. These are construction/job plumbing materials, and the vendor-specific notes direct Ferguson invoices with plumbing supplies and fixtures to Building Materials. Among the two allowed categories, 'Plumbing' (cat_173f2c1a36d74231bf0b9d9c755c7b0d) is the correct match as it maps to Building Materials:Plumbing, which precisely covers all items on this invoice. The 'Appliances' category could apply to the garbage disposal, but the overwhelming majority of items are plumbing fixtures and faucets, making Plumbing the best single category.",
    "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"
  }
}

QB payload

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

Raw payload

{
  "run_id": "run_b11b54f91b05478bb61155a036ec6e6a",
  "source": "make.com",
  "run_key": "05-12-2026-024",
  "make_trace_id": "make-20260511_215348_692",
  "source_file_name": "FergusonEnterprisesLLC_INV-1260171.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/FergusonEnterprisesLLC_INV-1260171.pdf",
  "source_dropbox_id": "id:CHX6_xJiKhAAAAAAAABp-Q",
  "source_dropbox_rev": "0165195f2d5239800000003549f4393",
  "multi_invoice_count": 6,
  "multi_invoice_index": 1,
  "source_content_hash": "9a2aede22b33caf366d96258620fafef27210f063478743de8250ed8c55520c6",
  "processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/FergusonEnterprisesLLC_INV-1260171.pdf",
  "multi_invoice_group_id": "bill_e2ca9185a530455193b065e2c3fce664",
  "processing_dropbox_rev": "0165195fe1e55bf00000003549f4393",
  "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 relate to customer 552382 (5503 Lakeview Drive project). Invoice 1237469 relates to customer 554796 (15890 York Circle NW / Shamp project). Invoice 1260154 relates to customer 550191 (8701 Bentwood Dr / Lodewyks project). All invoices are dated January 13-14, 2025 with Net 10th Prox terms. All are billable vendor invoices payable to Ferguson Enterprises LLC, PO Box 802817, Chicago IL 60680-2817.",
    "invoices": [
      {
        "tax": 675.26,
        "notes": "Vendor branch #1657 omitted from vendor_name. Items DD20015008415 (28X21-3/4 3H PED FRCLY LAV *FITZGE, qty 0 shipped, $0.00) and DD23005C000415 first instance (qty 0 shipped, $0.00) were skipped as zero-amount lines. Some unit prices in line_items appear inconsistent with amounts due to partial shipments or invoice formatting; amounts reflect values as printed. 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": 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 referenced. Primary Bath items. Tax jurisdiction: Hennepin Co. Note: 2 ordered but only 1 shipped for SHRSB820RGPN; remaining 1 unit fulfilled 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. Source Order #1019060 referenced. This is a follow-on shipment to invoice 1066218 for the remaining 1 unit of SHRSB820RGPN. Tax jurisdiction: Edina (MN308). Customer order: 5503 LAKEVIEW DRIVE.",
        "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. Customer number 554796 differs from other invoices (552382). Ship to: JKATH DESIGN BUILD & RIENVENT, 1408 NORTHLAND DRIVE SUITE 304, MENDOTA HEIGHTS MN 55120.",
        "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. Customer number 550191 differs from other invoices. Ship to: JKATH DESIGN BUILD & RIENVENT, 1408 NORTHLAND DRIVE SUITE 304, MENDOTA HEIGHTS MN 55120.",
        "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. Customer number 552382. Ship to: JKATH DESIGN BUILD & RIENVENT, 1408 NORTHLAND DRIVE SUITE 304, MENDOTA HEIGHTS MN 55120. Note: ship-to address is the firm's office, not the Lakeview project site.",
        "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
      }
    ]
  }
}

Invoice Timeline

Time

05/11/2026

Event

FILE CLAIMED

Message

Source file claimed by Make scenario.

Payload

{
  "message": "Claimed invoice file and moved into processing.",
  "source_file_name": "FergusonEnterprisesLLC_INV-1260171.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/FergusonEnterprisesLLC_INV-1260171.pdf",
  "processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/FergusonEnterprisesLLC_INV-1260171.pdf"
}

Time

05/11/2026

Event

PARSE COMPLETED

Message

Claude extraction parsed and stored from a multi-invoice PDF.

Payload

{
  "total": "8595.91",
  "message": "Claude extraction parsed and stored.",
  "due_date": "2025-02-12",
  "jkath_terms": "Net 30",
  "process_key": "05-12-2026-024-INV-004",
  "vendor_name": "Ferguson Enterprises LLC",
  "claude_model": "claude-sonnet-4-6",
  "input_tokens": "15711",
  "invoice_date": "2025-01-13",
  "vendor_terms": "Net 10th Prox",
  "make_trace_id": "make-20260511_215348_692",
  "output_tokens": "3815",
  "bill_import_id": "bill_e2ca9185a530455193b065e2c3fce664",
  "invoice_number": "1019060",
  "vendor_due_date": null,
  "source_file_name": "FergusonEnterprisesLLC_INV-1260171.pdf",
  "claude_message_id": "msg_01WHrABDiT6oaGVAeaJnzMmB",
  "multi_invoice_count": 6,
  "multi_invoice_index": 1
}

Time

05/11/2026

Event

ALIAS LOOKUP COMPLETED

Message

Vendor alias lookup matched a portal vendor.

Payload

{
  "found": true,
  "message": "Looked up parsed vendor name against portal aliases.",
  "alias_id": "alias_1e2f326fecee46f5b955324a2e70975d",
  "vendor_id": "vendor_15ec102255844f479fc29f8cb9362b73",
  "process_key": "05-12-2026-024-INV-004",
  "vendor_name": "Ferguson Enterprises LLC",
  "make_trace_id": "make-20260511_215348_692",
  "bill_import_id": "bill_e2ca9185a530455193b065e2c3fce664",
  "canonical_name": "Ferguson Enterprises LLC",
  "category_count": 2,
  "invoice_number": "1019060",
  "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"
    }
  ],
  "source_file_name": "FergusonEnterprisesLLC_INV-1260171.pdf",
  "expense_category_id": null,
  "normalized_alias_key": "ferguson enterprises llc",
  "quickbooks_vendor_id": "6",
  "default_expense_account": null,
  "missing_category_options": false
}

Time

05/11/2026

Event

CATEGORY SELECTION COMPLETED

Message

Expense category selected for bill import.

Payload

{
  "message": "Claude selected an expense category from allowed portal options.",
  "process_key": "05-12-2026-024-INV-004",
  "vendor_name": "Ferguson Enterprises LLC",
  "category_name": "Plumbing",
  "make_trace_id": "make-20260511_215348_692",
  "bill_import_id": "bill_e2ca9185a530455193b065e2c3fce664",
  "source_file_name": "FergusonEnterprisesLLC_INV-1260171.pdf",
  "selection_payload": {
    "reason": "All line items on this Ferguson invoice are plumbing fixtures and supplies for the Lakeview - Finish project, including toilets (Cadet III, Fitzgerald), lavatory sinks (Verticyl rectangular under-counter lavs), faucets (kitchen and lavatory faucets in multiple finishes), a garbage disposal (Badger 5), a P-trap, a kitchen flange/strainer, and an air switch. These are construction/job plumbing materials, and the vendor-specific notes direct Ferguson invoices with plumbing supplies and fixtures to Building Materials. Among the two allowed categories, 'Plumbing' (cat_173f2c1a36d74231bf0b9d9c755c7b0d) is the correct match as it maps to Building Materials:Plumbing, which precisely covers all items on this invoice. The 'Appliances' category could apply to the garbage disposal, but the overwhelming majority of items are plumbing fixtures and faucets, making Plumbing the best single category.",
    "confidence": 0.97,
    "selected_expense_category_id": "cat_173f2c1a36d74231bf0b9d9c755c7b0d",
    "selected_expense_category_name": "Plumbing"
  },
  "expense_category_id": "cat_173f2c1a36d74231bf0b9d9c755c7b0d",
  "quickbooks_account_id": "113"
}

Time

05/11/2026

Event

QB LOOKUP COMPLETED

Message

QuickBooks vendor, account, and duplicate bill lookup completed.

Payload

{
  "path": "multi_category_direct",
  "message": "QuickBooks lookup completed before create-or-duplicate routing.",
  "process_key": "05-12-2026-024-INV-004",
  "vendor_name": "Ferguson Enterprises LLC",
  "make_trace_id": "make-20260511_215348_692",
  "bill_import_id": "bill_e2ca9185a530455193b065e2c3fce664",
  "invoice_number": "1019060",
  "source_file_name": "FergusonEnterprisesLLC_INV-1260171.pdf",
  "quickbooks_vendor_id": "6",
  "quickbooks_account_id": "113",
  "existing_quickbooks_bill_id": null
}

Time

05/11/2026

Event

QB BILL CREATED

Message

QuickBooks Bill created.

Payload

{
  "path": "multi_category_direct",
  "message": "QuickBooks Bill created from invoice import.",
  "process_key": "05-12-2026-024-INV-004",
  "make_trace_id": "make-20260511_215348_692",
  "bill_import_id": "bill_e2ca9185a530455193b065e2c3fce664",
  "source_file_name": "FergusonEnterprisesLLC_INV-1260171.pdf",
  "quickbooks_bill_id": "291",
  "quickbooks_payload": {
    "path": "multi_category_direct",
    "total": "8595.91",
    "due_date": "2025-02-12",
    "doc_number": "1019060",
    "vendor_ref": "6",
    "account_ref": "113",
    "jkath_terms": "Net 30",
    "vendor_terms": "Net 10th Prox",
    "quickbooks_bill_id": "291"
  },
  "quickbooks_account_id": "113",
  "resolved_expense_category_id": "cat_173f2c1a36d74231bf0b9d9c755c7b0d"
}

Time

05/11/2026

Event

ATTACHMENT UPLOADED

Message

Source file attached to the QuickBooks Bill.

Payload

{
  "path": "multi_category_direct",
  "message": "Source file uploaded to QuickBooks Bill.",
  "process_key": "05-12-2026-024-INV-004",
  "make_trace_id": "make-20260511_215348_692",
  "bill_import_id": "bill_e2ca9185a530455193b065e2c3fce664",
  "source_file_name": "FergusonEnterprisesLLC_INV-1260171.pdf",
  "attachment_payload": {
    "path": "multi_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "291"
  },
  "quickbooks_bill_id": "291"
}