JkathBusiness Portal

Invoice Record

05-12-2026-037-INV-006-PART-03

Ferguson Enterprises LLC
Back to vendor

Bill Created Successfully

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

Status

Created in QB

Invoice

SC411176

Total

$4.03

Invoice data

Matched alias
Ferguson Enterprises LLC
Category
Building Materials:Plumbing
Category method
Claude category selection
Invoice date
04/30/2025
Due date
05/30/2025
Vendor terms
Not set
Jkath terms
Net 30
QB Bill ID
402

Category reason

This invoice from Ferguson Enterprises LLC is a service charge (SC411176) for April, not a direct purchase of construction materials, plumbing supplies, or appliances. However, Ferguson is a plumbing/building materials supplier and the vendor-specific notes indicate choosing Building Materials categories for job-related invoices. Between the two allowed categories (Appliances and Plumbing), Plumbing is the more appropriate default for Ferguson invoices tied to a construction project (5503 Lakeview Drive - ZAW), as Ferguson primarily deals in plumbing supplies. The service charge is likely account-related to plumbing purchases. Confidence is moderate because the line item is a service charge rather than a specific material purchase.

File result

Outcome
processed
Details
QuickBooks Bill created successfully. Source file attached to the Bill.

Processing Context

Invoice ID
05-12-2026-037-INV-006-PART-03
Run ID
05-12-2026-037
Source folder
/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed
Source file
737714_20250501_30774808_14287432814.pdf
Stored payloads

Claude parse payload

{
  "tax": 0,
  "notes": "This is a service/finance charge invoice, not a product invoice. Project name inferred from billing address line '5503 LAKEVIEW DRIVE - ZAW'. Customer number 552382. No tax code, salesman, or customer order number listed.",
  "terms": null,
  "total": 4.03,
  "due_date": null,
  "shipping": 0,
  "subtotal": 4.03,
  "confidence": {
    "total": 0.99,
    "vendor_name": 0.99,
    "invoice_date": 0.99,
    "project_name": 0.8,
    "invoice_number": 0.99
  },
  "line_items": [
    {
      "qty": null,
      "amount": 4.03,
      "unit_price": 4.03,
      "description": "Service Charge for April"
    }
  ],
  "vendor_name": "Ferguson Enterprises LLC",
  "invoice_date": "2025-04-30",
  "project_name": "5503 Lakeview Drive - ZAW",
  "document_type": "invoice",
  "invoice_number": "SC411176",
  "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": "This invoice from Ferguson Enterprises LLC is a service charge (SC411176) for April, not a direct purchase of construction materials, plumbing supplies, or appliances. However, Ferguson is a plumbing/building materials supplier and the vendor-specific notes indicate choosing Building Materials categories for job-related invoices. Between the two allowed categories (Appliances and Plumbing), Plumbing is the more appropriate default for Ferguson invoices tied to a construction project (5503 Lakeview Drive - ZAW), as Ferguson primarily deals in plumbing supplies. The service charge is likely account-related to plumbing purchases. Confidence is moderate because the line item is a service charge rather than a specific material purchase.",
    "confidence": 0.55,
    "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": "4.03",
    "due_date": "2025-05-30",
    "doc_number": "SC411176",
    "vendor_ref": "6",
    "account_ref": "113",
    "jkath_terms": "Net 30",
    "vendor_terms": "",
    "quickbooks_bill_id": "402",
    "resolved_expense_category_id": "cat_173f2c1a36d74231bf0b9d9c755c7b0d"
  },
  "attachment_uploaded": {
    "path": "multi_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "402"
  }
}

Raw payload

{
  "multi_invoice_count": 5,
  "multi_invoice_index": 3,
  "multi_invoice_group_id": "bill_e636893f60ad4fc38dccc62f31b8bd32",
  "multi_invoice_source_payload": {
    "notes": "PDF contains 5 separate invoices from Ferguson Enterprises LLC (branch #1657). Invoices 1282032 and 1579192 are standard product invoices for the Shukarey project. Invoices SC411176, SC412226, and SC412444 are service/finance charge invoices for April for three different projects. All invoices share master account number 737714 and remit-to address PO Box 802817, Chicago, IL 60680-2817.",
    "invoices": [
      {
        "tax": 71.41,
        "notes": "Vendor branch #1657 omitted from vendor_name. Ship to: 2908 43rd Ave S, Minneapolis, MN 55406. Customer order number: 2908 43RD AVE S. Tax jurisdiction: Minneapolis.",
        "terms": "Net 10th Prox",
        "total": 862.73,
        "due_date": null,
        "shipping": 0,
        "subtotal": 791.32,
        "confidence": {
          "total": 0.99,
          "vendor_name": 0.99,
          "invoice_date": 0.99,
          "project_name": 0.95,
          "invoice_number": 0.99
        },
        "line_items": [
          {
            "qty": 1,
            "amount": 87,
            "unit_price": 87,
            "description": "@ 18X13 VC UC LAV WHIT (K20000-0)"
          },
          {
            "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": 340.12,
            "unit_price": 340.119,
            "description": "CCY LF 1.2 W/SPRD LAV *BEASL PN (SHWSCBE807PN)"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-04-29",
        "project_name": "Shukarey - Plumb",
        "document_type": "invoice",
        "invoice_number": "1282032",
        "is_billable_invoice": true
      },
      {
        "tax": 53.63,
        "notes": "Vendor branch #1657 omitted from vendor_name. Freight of $41.07 is listed as a separate line outside subtotal and is set in shipping field. Tax jurisdiction: Dakota County. Ship to: JKATH Design Build & Reinvent, 1408 Northland Drive Suite 304, Mendota Heights, MN 55120.",
        "terms": "Net 10th Prox",
        "total": 713.7,
        "due_date": null,
        "shipping": 41.07,
        "subtotal": 619,
        "confidence": {
          "total": 0.99,
          "vendor_name": 0.99,
          "invoice_date": 0.99,
          "project_name": 0.95,
          "invoice_number": 0.99
        },
        "line_items": [
          {
            "qty": 1,
            "amount": 619,
            "unit_price": 619,
            "description": "*CVR* CCY MINI 30IN SS RNGE HOOD (ZAK9128BS) - Source Order#: 1248509, Serial# 1187218BYW"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-04-28",
        "project_name": "Shukarey",
        "document_type": "invoice",
        "invoice_number": "1579192",
        "is_billable_invoice": true
      },
      {
        "tax": 0,
        "notes": "This is a service/finance charge invoice, not a product invoice. Project name inferred from billing address line '5503 LAKEVIEW DRIVE - ZAW'. Customer number 552382. No tax code, salesman, or customer order number listed.",
        "terms": null,
        "total": 4.03,
        "due_date": null,
        "shipping": 0,
        "subtotal": 4.03,
        "confidence": {
          "total": 0.99,
          "vendor_name": 0.99,
          "invoice_date": 0.99,
          "project_name": 0.8,
          "invoice_number": 0.99
        },
        "line_items": [
          {
            "qty": null,
            "amount": 4.03,
            "unit_price": 4.03,
            "description": "Service Charge for April"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-04-30",
        "project_name": "5503 Lakeview Drive - ZAW",
        "document_type": "invoice",
        "invoice_number": "SC411176",
        "is_billable_invoice": true
      },
      {
        "tax": 0,
        "notes": "This is a service/finance charge invoice, not a product invoice. Project name inferred from billing address line '8701 BENTWOOD DR (LODEWYKS)'. Customer number 550191. No tax code, salesman, or customer order number listed. This is a notably large service charge ($320.31) which may warrant human review.",
        "terms": null,
        "total": 320.31,
        "due_date": null,
        "shipping": 0,
        "subtotal": 320.31,
        "confidence": {
          "total": 0.99,
          "vendor_name": 0.99,
          "invoice_date": 0.99,
          "project_name": 0.85,
          "invoice_number": 0.99
        },
        "line_items": [
          {
            "qty": null,
            "amount": 320.31,
            "unit_price": 320.31,
            "description": "Service Charge for April"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-04-30",
        "project_name": "8701 Bentwood Dr (Lodewyks)",
        "document_type": "invoice",
        "invoice_number": "SC412226",
        "is_billable_invoice": true
      },
      {
        "tax": 0,
        "notes": "This is a service/finance charge invoice, not a product invoice. Project name inferred from billing address line '2848 W RIVER PKWY'. Customer number 564458. No tax code, salesman, or customer order number listed.",
        "terms": null,
        "total": 16.07,
        "due_date": null,
        "shipping": 0,
        "subtotal": 16.07,
        "confidence": {
          "total": 0.99,
          "vendor_name": 0.99,
          "invoice_date": 0.99,
          "project_name": 0.8,
          "invoice_number": 0.99
        },
        "line_items": [
          {
            "qty": null,
            "amount": 16.07,
            "unit_price": 16.07,
            "description": "Service Charge for April"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-04-30",
        "project_name": "2848 W River Pkwy",
        "document_type": "invoice",
        "invoice_number": "SC412444",
        "is_billable_invoice": true
      }
    ]
  }
}

Invoice Timeline

Time

05/12/2026

Event

PARSE COMPLETED

Message

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

Payload
{
  "total": "4.03",
  "message": "Claude extraction parsed and stored.",
  "due_date": "2025-05-30",
  "jkath_terms": "Net 30",
  "process_key": "05-12-2026-037-INV-006",
  "vendor_name": "Ferguson Enterprises LLC",
  "claude_model": "claude-sonnet-4-6",
  "input_tokens": "11820",
  "invoice_date": "2025-04-30",
  "vendor_terms": null,
  "make_trace_id": "make-20260512_020557_528",
  "output_tokens": "1952",
  "bill_import_id": "bill_e636893f60ad4fc38dccc62f31b8bd32",
  "invoice_number": "SC411176",
  "vendor_due_date": null,
  "source_file_name": "737714_20250501_30774808_14287432814.pdf",
  "claude_message_id": "msg_01LkQDMVsSXRsYFNWVktorL3",
  "multi_invoice_count": 5,
  "multi_invoice_index": 3
}

Time

05/12/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-037-INV-006-PART-03",
  "vendor_name": "Ferguson Enterprises LLC",
  "make_trace_id": "make-20260512_020557_528",
  "bill_import_id": "bill_cb654bcc9c114751b3c356de2d79eafc",
  "canonical_name": "Ferguson Enterprises LLC",
  "category_count": 2,
  "invoice_number": "SC411176",
  "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": "737714_20250501_30774808_14287432814.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/12/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-037-INV-006-PART-03",
  "vendor_name": "Ferguson Enterprises LLC",
  "category_name": "Plumbing",
  "make_trace_id": "make-20260512_020557_528",
  "bill_import_id": "bill_cb654bcc9c114751b3c356de2d79eafc",
  "source_file_name": "737714_20250501_30774808_14287432814.pdf",
  "selection_payload": {
    "reason": "This invoice from Ferguson Enterprises LLC is a service charge (SC411176) for April, not a direct purchase of construction materials, plumbing supplies, or appliances. However, Ferguson is a plumbing/building materials supplier and the vendor-specific notes indicate choosing Building Materials categories for job-related invoices. Between the two allowed categories (Appliances and Plumbing), Plumbing is the more appropriate default for Ferguson invoices tied to a construction project (5503 Lakeview Drive - ZAW), as Ferguson primarily deals in plumbing supplies. The service charge is likely account-related to plumbing purchases. Confidence is moderate because the line item is a service charge rather than a specific material purchase.",
    "confidence": 0.55,
    "selected_expense_category_id": "cat_173f2c1a36d74231bf0b9d9c755c7b0d",
    "selected_expense_category_name": "Plumbing"
  },
  "expense_category_id": "cat_173f2c1a36d74231bf0b9d9c755c7b0d",
  "quickbooks_account_id": "113"
}

Time

05/12/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-037-INV-006-PART-03",
  "vendor_name": "Ferguson Enterprises LLC",
  "make_trace_id": "make-20260512_020557_528",
  "bill_import_id": "bill_cb654bcc9c114751b3c356de2d79eafc",
  "invoice_number": "SC411176",
  "source_file_name": "737714_20250501_30774808_14287432814.pdf",
  "quickbooks_vendor_id": "6",
  "quickbooks_account_id": "113",
  "existing_quickbooks_bill_id": null
}

Time

05/12/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-037-INV-006-PART-03",
  "make_trace_id": "make-20260512_020557_528",
  "bill_import_id": "bill_cb654bcc9c114751b3c356de2d79eafc",
  "source_file_name": "737714_20250501_30774808_14287432814.pdf",
  "quickbooks_bill_id": "402",
  "quickbooks_payload": {
    "path": "multi_category_direct",
    "total": "4.03",
    "due_date": "2025-05-30",
    "doc_number": "SC411176",
    "vendor_ref": "6",
    "account_ref": "113",
    "jkath_terms": "Net 30",
    "vendor_terms": "",
    "quickbooks_bill_id": "402"
  },
  "quickbooks_account_id": "113",
  "resolved_expense_category_id": "cat_173f2c1a36d74231bf0b9d9c755c7b0d"
}

Time

05/12/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-037-INV-006-PART-03",
  "make_trace_id": "make-20260512_020557_528",
  "bill_import_id": "bill_cb654bcc9c114751b3c356de2d79eafc",
  "source_file_name": "737714_20250501_30774808_14287432814.pdf",
  "attachment_payload": {
    "path": "multi_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "402"
  },
  "quickbooks_bill_id": "402"
}