JkathBusiness Portal

Invoice Record

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

Ferguson Enterprises LLC
Back to run

Bill Created Successfully

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

Status

Created in QB

Invoice

SC412226

Total

$320.31

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
403

Category reason

Ferguson Enterprises LLC is a plumbing and building materials supplier. The invoice contains only a 'Service Charge for April' line item with no specific material description, making categorization uncertain. However, given Ferguson's primary business as a plumbing supply distributor, the project context (8701 Bentwood Dr - Lodewyks), and the vendor-specific notes directing Ferguson invoices toward Building Materials categories for job-related charges, Plumbing is the most appropriate available category. Confidence is moderate because the line item is a service charge rather than an explicitly described plumbing material or fixture.

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-04
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 '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
}

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": "Ferguson Enterprises LLC is a plumbing and building materials supplier. The invoice contains only a 'Service Charge for April' line item with no specific material description, making categorization uncertain. However, given Ferguson's primary business as a plumbing supply distributor, the project context (8701 Bentwood Dr - Lodewyks), and the vendor-specific notes directing Ferguson invoices toward Building Materials categories for job-related charges, Plumbing is the most appropriate available category. Confidence is moderate because the line item is a service charge rather than an explicitly described plumbing material or fixture.",
    "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": "320.31",
    "due_date": "2025-05-30",
    "doc_number": "SC412226",
    "vendor_ref": "6",
    "account_ref": "113",
    "jkath_terms": "Net 30",
    "vendor_terms": "",
    "quickbooks_bill_id": "403",
    "resolved_expense_category_id": "cat_173f2c1a36d74231bf0b9d9c755c7b0d"
  },
  "attachment_uploaded": {
    "path": "multi_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "403"
  }
}

Raw payload

{
  "multi_invoice_count": 5,
  "multi_invoice_index": 4,
  "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": "320.31",
  "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": "SC412226",
  "vendor_due_date": null,
  "source_file_name": "737714_20250501_30774808_14287432814.pdf",
  "claude_message_id": "msg_01LkQDMVsSXRsYFNWVktorL3",
  "multi_invoice_count": 5,
  "multi_invoice_index": 4
}

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-04",
  "vendor_name": "Ferguson Enterprises LLC",
  "make_trace_id": "make-20260512_020557_528",
  "bill_import_id": "bill_a2c2c038796141d9910c53bbe0260b1c",
  "canonical_name": "Ferguson Enterprises LLC",
  "category_count": 2,
  "invoice_number": "SC412226",
  "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-04",
  "vendor_name": "Ferguson Enterprises LLC",
  "category_name": "Plumbing",
  "make_trace_id": "make-20260512_020557_528",
  "bill_import_id": "bill_a2c2c038796141d9910c53bbe0260b1c",
  "source_file_name": "737714_20250501_30774808_14287432814.pdf",
  "selection_payload": {
    "reason": "Ferguson Enterprises LLC is a plumbing and building materials supplier. The invoice contains only a 'Service Charge for April' line item with no specific material description, making categorization uncertain. However, given Ferguson's primary business as a plumbing supply distributor, the project context (8701 Bentwood Dr - Lodewyks), and the vendor-specific notes directing Ferguson invoices toward Building Materials categories for job-related charges, Plumbing is the most appropriate available category. Confidence is moderate because the line item is a service charge rather than an explicitly described plumbing material or fixture.",
    "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-04",
  "vendor_name": "Ferguson Enterprises LLC",
  "make_trace_id": "make-20260512_020557_528",
  "bill_import_id": "bill_a2c2c038796141d9910c53bbe0260b1c",
  "invoice_number": "SC412226",
  "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-04",
  "make_trace_id": "make-20260512_020557_528",
  "bill_import_id": "bill_a2c2c038796141d9910c53bbe0260b1c",
  "source_file_name": "737714_20250501_30774808_14287432814.pdf",
  "quickbooks_bill_id": "403",
  "quickbooks_payload": {
    "path": "multi_category_direct",
    "total": "320.31",
    "due_date": "2025-05-30",
    "doc_number": "SC412226",
    "vendor_ref": "6",
    "account_ref": "113",
    "jkath_terms": "Net 30",
    "vendor_terms": "",
    "quickbooks_bill_id": "403"
  },
  "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-04",
  "make_trace_id": "make-20260512_020557_528",
  "bill_import_id": "bill_a2c2c038796141d9910c53bbe0260b1c",
  "source_file_name": "737714_20250501_30774808_14287432814.pdf",
  "attachment_payload": {
    "path": "multi_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "403"
  },
  "quickbooks_bill_id": "403"
}