JkathBusiness Portal

Invoice Record

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

Ferguson Enterprises LLC
Back to bill imports

Bill Created Successfully

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

Status

Created in QB

Invoice

SC412444

Total

$16.07

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
404

Category reason

This invoice from Ferguson Enterprises LLC is a service charge for April rather than a specific material purchase. Ferguson is a plumbing/HVAC supply vendor, and the vendor-specific notes indicate Building Materials (Plumbing) for plumbing supplies and job materials. Between the two allowed categories (Appliances and Plumbing), Plumbing is the more appropriate default for Ferguson invoices associated with a construction project context (2848 W River Pkwy). Confidence is moderate because the line item is a generic service charge with no specific material description, making definitive categorization difficult.

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

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 for April rather than a specific material purchase. Ferguson is a plumbing/HVAC supply vendor, and the vendor-specific notes indicate Building Materials (Plumbing) for plumbing supplies and job materials. Between the two allowed categories (Appliances and Plumbing), Plumbing is the more appropriate default for Ferguson invoices associated with a construction project context (2848 W River Pkwy). Confidence is moderate because the line item is a generic service charge with no specific material description, making definitive categorization difficult.",
    "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": "16.07",
    "due_date": "2025-05-30",
    "doc_number": "SC412444",
    "vendor_ref": "6",
    "account_ref": "113",
    "jkath_terms": "Net 30",
    "vendor_terms": "",
    "quickbooks_bill_id": "404",
    "resolved_expense_category_id": "cat_173f2c1a36d74231bf0b9d9c755c7b0d"
  },
  "attachment_uploaded": {
    "path": "multi_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "404"
  }
}

Raw payload

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

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-05",
  "vendor_name": "Ferguson Enterprises LLC",
  "make_trace_id": "make-20260512_020557_528",
  "bill_import_id": "bill_13930897804f438ea03b3a9980e35a24",
  "canonical_name": "Ferguson Enterprises LLC",
  "category_count": 2,
  "invoice_number": "SC412444",
  "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-05",
  "vendor_name": "Ferguson Enterprises LLC",
  "category_name": "Plumbing",
  "make_trace_id": "make-20260512_020557_528",
  "bill_import_id": "bill_13930897804f438ea03b3a9980e35a24",
  "source_file_name": "737714_20250501_30774808_14287432814.pdf",
  "selection_payload": {
    "reason": "This invoice from Ferguson Enterprises LLC is a service charge for April rather than a specific material purchase. Ferguson is a plumbing/HVAC supply vendor, and the vendor-specific notes indicate Building Materials (Plumbing) for plumbing supplies and job materials. Between the two allowed categories (Appliances and Plumbing), Plumbing is the more appropriate default for Ferguson invoices associated with a construction project context (2848 W River Pkwy). Confidence is moderate because the line item is a generic service charge with no specific material description, making definitive categorization difficult.",
    "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-05",
  "vendor_name": "Ferguson Enterprises LLC",
  "make_trace_id": "make-20260512_020557_528",
  "bill_import_id": "bill_13930897804f438ea03b3a9980e35a24",
  "invoice_number": "SC412444",
  "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-05",
  "make_trace_id": "make-20260512_020557_528",
  "bill_import_id": "bill_13930897804f438ea03b3a9980e35a24",
  "source_file_name": "737714_20250501_30774808_14287432814.pdf",
  "quickbooks_bill_id": "404",
  "quickbooks_payload": {
    "path": "multi_category_direct",
    "total": "16.07",
    "due_date": "2025-05-30",
    "doc_number": "SC412444",
    "vendor_ref": "6",
    "account_ref": "113",
    "jkath_terms": "Net 30",
    "vendor_terms": "",
    "quickbooks_bill_id": "404"
  },
  "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-05",
  "make_trace_id": "make-20260512_020557_528",
  "bill_import_id": "bill_13930897804f438ea03b3a9980e35a24",
  "source_file_name": "737714_20250501_30774808_14287432814.pdf",
  "attachment_payload": {
    "path": "multi_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "404"
  },
  "quickbooks_bill_id": "404"
}

Time

05/12/2026

Event

FILE MOVED

Message

Final invoice file moved.

Payload
{
  "path": "multi_category_direct",
  "status": "CREATED_IN_QBO",
  "message": "Processed invoice file moved after QuickBooks Bill creation.",
  "outcome": "processed",
  "process_key": "05-12-2026-037-INV-006-PART-05",
  "make_trace_id": "make-20260512_020557_528",
  "bill_import_id": "bill_13930897804f438ea03b3a9980e35a24",
  "final_file_name": "FergusonEnterprisesLLC_INV-SC412444.pdf",
  "source_file_name": "737714_20250501_30774808_14287432814.pdf",
  "dropbox_shared_url": "https://www.dropbox.com/scl/fi/9b6jfzwly8jbbt5mrc6vu/FergusonEnterprisesLLC_INV-SC412444.pdf?rlkey=b3r1k7nhugudxdqkor4vbh3f4&dl=0",
  "quickbooks_bill_id": "404",
  "multi_invoice_group_id": "bill_e636893f60ad4fc38dccc62f31b8bd32"
}