JkathBusiness Portal

Invoice Record

05-12-2026-034-INV-005-PART-02

Ferguson Enterprises LLC
Back to run

Bill Created Successfully

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

Status

Created in QB

Invoice

1530865

Total

$90.71

Invoice data

Matched alias
Ferguson Enterprises LLC
Category
Building Materials:Plumbing
Category method
Claude category selection
Invoice date
04/11/2025
Due date
05/11/2025
Vendor terms
Net 10th Prox
Jkath terms
Net 30
QB Bill ID
365

Category reason

The line item 'PD FCT LEV HDL *ODIN LUGO' (item code DHLK175GL) refers to a faucet lever handle, which is a plumbing fixture/supply. Ferguson vendor notes specify choosing Building Materials for plumbing supplies and fixtures. Among the allowed categories, Plumbing (cat_173f2c1a36d74231bf0b9d9c755c7b0d) is the correct match for this plumbing fixture item on the Delta project.

File result

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

Processing Context

Invoice ID
05-12-2026-034-INV-005-PART-02
Run ID
05-12-2026-034
Source folder
/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed
Source file
Ferguson - only enter Lakeview invoice NOT York (credit coming).pdf
Stored payloads

Claude parse payload

{
  "tax": 8.15,
  "notes": "Vendor branch/store suffix #1657 omitted from vendor_name. Tax jurisdiction: St Paul. Customer order number: YORK CIR HANDLE; job name listed as 'DELTA' — project_name set to 'Delta' accordingly. Salesman: PMH. Ship/Sell Whse: 2009. Shipped from Golden Valley, MN location.",
  "terms": "Net 10th Prox",
  "total": 90.71,
  "due_date": null,
  "shipping": 0,
  "subtotal": 82.56,
  "confidence": {
    "total": 0.99,
    "vendor_name": 0.99,
    "invoice_date": 0.99,
    "project_name": 0.9,
    "invoice_number": 0.99
  },
  "line_items": [
    {
      "qty": 1,
      "amount": 82.56,
      "unit_price": 82.56,
      "description": "PD FCT LEV HDL *ODIN LUGO (Item: DHLK175GL)"
    }
  ],
  "vendor_name": "Ferguson Enterprises LLC",
  "invoice_date": "2025-04-11",
  "project_name": "Delta",
  "document_type": "invoice",
  "invoice_number": "1530865",
  "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": "The line item 'PD FCT LEV HDL *ODIN LUGO' (item code DHLK175GL) refers to a faucet lever handle, which is a plumbing fixture/supply. Ferguson vendor notes specify choosing Building Materials for plumbing supplies and fixtures. Among the allowed categories, Plumbing (cat_173f2c1a36d74231bf0b9d9c755c7b0d) is the correct match for this plumbing fixture item on the Delta project.",
    "confidence": 0.95,
    "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": "90.71",
    "due_date": "2025-05-11",
    "doc_number": "1530865",
    "vendor_ref": "6",
    "account_ref": "113",
    "jkath_terms": "Net 30",
    "vendor_terms": "Net 10th Prox",
    "quickbooks_bill_id": "365",
    "resolved_expense_category_id": "cat_173f2c1a36d74231bf0b9d9c755c7b0d"
  },
  "attachment_uploaded": {
    "path": "multi_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "365"
  }
}

Raw payload

{
  "multi_invoice_count": 2,
  "multi_invoice_index": 2,
  "multi_invoice_group_id": "bill_d66a1eac7439444a9ee78f4c949c5dce",
  "multi_invoice_source_payload": {
    "notes": "PDF contains two separate Ferguson Enterprises LLC invoices: Invoice #1527277 (dated 2025-04-10, $79.01) for project 5503 Lakeview Drive - ZAW, and Invoice #1530865 (dated 2025-04-11, $90.71) for project Delta. Both are standard unpaid vendor invoices. Master account number for both: 737714. Bill-to entity: JKATH Design Build & Reinvent.",
    "invoices": [
      {
        "tax": 7.1,
        "notes": "Vendor branch/store suffix #1657 omitted from vendor_name. Tax jurisdiction: St Paul. Customer order number: 5503. Salesman: PMH. Ship/Sell Whse: 1648.",
        "terms": "Net 10th Prox",
        "total": 79.01,
        "due_date": null,
        "shipping": 0,
        "subtotal": 71.91,
        "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": 71.91,
            "unit_price": 71.909,
            "description": "WHIT PVC S40 L&T W&O (Item: W901LTPVCWH)"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-04-10",
        "project_name": "5503 Lakeview Drive - ZAW",
        "document_type": "invoice",
        "invoice_number": "1527277",
        "is_billable_invoice": true
      },
      {
        "tax": 8.15,
        "notes": "Vendor branch/store suffix #1657 omitted from vendor_name. Tax jurisdiction: St Paul. Customer order number: YORK CIR HANDLE; job name listed as 'DELTA' — project_name set to 'Delta' accordingly. Salesman: PMH. Ship/Sell Whse: 2009. Shipped from Golden Valley, MN location.",
        "terms": "Net 10th Prox",
        "total": 90.71,
        "due_date": null,
        "shipping": 0,
        "subtotal": 82.56,
        "confidence": {
          "total": 0.99,
          "vendor_name": 0.99,
          "invoice_date": 0.99,
          "project_name": 0.9,
          "invoice_number": 0.99
        },
        "line_items": [
          {
            "qty": 1,
            "amount": 82.56,
            "unit_price": 82.56,
            "description": "PD FCT LEV HDL *ODIN LUGO (Item: DHLK175GL)"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-04-11",
        "project_name": "Delta",
        "document_type": "invoice",
        "invoice_number": "1530865",
        "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": "90.71",
  "message": "Claude extraction parsed and stored.",
  "due_date": "2025-05-11",
  "jkath_terms": "Net 30",
  "process_key": "05-12-2026-034-INV-005",
  "vendor_name": "Ferguson Enterprises LLC",
  "claude_model": "claude-sonnet-4-6",
  "input_tokens": "5694",
  "invoice_date": "2025-04-11",
  "vendor_terms": "Net 10th Prox",
  "make_trace_id": "make-20260512_004507_068",
  "output_tokens": "856",
  "bill_import_id": "bill_d66a1eac7439444a9ee78f4c949c5dce",
  "invoice_number": "1530865",
  "vendor_due_date": null,
  "source_file_name": "Ferguson - only enter Lakeview invoice NOT York (credit coming).pdf",
  "claude_message_id": "msg_01KNVuF4M5gaZqv7gCaRNqiz",
  "multi_invoice_count": 2,
  "multi_invoice_index": 2
}

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-034-INV-005-PART-02",
  "vendor_name": "Ferguson Enterprises LLC",
  "make_trace_id": "make-20260512_004507_068",
  "bill_import_id": "bill_ee6a2d2fed364c4db270484d49240e90",
  "canonical_name": "Ferguson Enterprises LLC",
  "category_count": 2,
  "invoice_number": "1530865",
  "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": "Ferguson - only enter Lakeview invoice NOT York (credit coming).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-034-INV-005-PART-02",
  "vendor_name": "Ferguson Enterprises LLC",
  "category_name": "Plumbing",
  "make_trace_id": "make-20260512_004507_068",
  "bill_import_id": "bill_ee6a2d2fed364c4db270484d49240e90",
  "source_file_name": "Ferguson - only enter Lakeview invoice NOT York (credit coming).pdf",
  "selection_payload": {
    "reason": "The line item 'PD FCT LEV HDL *ODIN LUGO' (item code DHLK175GL) refers to a faucet lever handle, which is a plumbing fixture/supply. Ferguson vendor notes specify choosing Building Materials for plumbing supplies and fixtures. Among the allowed categories, Plumbing (cat_173f2c1a36d74231bf0b9d9c755c7b0d) is the correct match for this plumbing fixture item on the Delta project.",
    "confidence": 0.95,
    "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-034-INV-005-PART-02",
  "vendor_name": "Ferguson Enterprises LLC",
  "make_trace_id": "make-20260512_004507_068",
  "bill_import_id": "bill_ee6a2d2fed364c4db270484d49240e90",
  "invoice_number": "1530865",
  "source_file_name": "Ferguson - only enter Lakeview invoice NOT York (credit coming).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-034-INV-005-PART-02",
  "make_trace_id": "make-20260512_004507_068",
  "bill_import_id": "bill_ee6a2d2fed364c4db270484d49240e90",
  "source_file_name": "Ferguson - only enter Lakeview invoice NOT York (credit coming).pdf",
  "quickbooks_bill_id": "365",
  "quickbooks_payload": {
    "path": "multi_category_direct",
    "total": "90.71",
    "due_date": "2025-05-11",
    "doc_number": "1530865",
    "vendor_ref": "6",
    "account_ref": "113",
    "jkath_terms": "Net 30",
    "vendor_terms": "Net 10th Prox",
    "quickbooks_bill_id": "365"
  },
  "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-034-INV-005-PART-02",
  "make_trace_id": "make-20260512_004507_068",
  "bill_import_id": "bill_ee6a2d2fed364c4db270484d49240e90",
  "source_file_name": "Ferguson - only enter Lakeview invoice NOT York (credit coming).pdf",
  "attachment_payload": {
    "path": "multi_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "365"
  },
  "quickbooks_bill_id": "365"
}

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-034-INV-005-PART-02",
  "make_trace_id": "make-20260512_004507_068",
  "bill_import_id": "bill_ee6a2d2fed364c4db270484d49240e90",
  "final_file_name": "FergusonEnterprisesLLC_INV-1530865.pdf",
  "source_file_name": "Ferguson - only enter Lakeview invoice NOT York (credit coming).pdf",
  "dropbox_shared_url": "https://www.dropbox.com/scl/fi/7xo5s2sen7ugcln72nxal/FergusonEnterprisesLLC_INV-1530865.pdf?rlkey=40maq2uaui3aachqjay7vv5uw&dl=0",
  "quickbooks_bill_id": "365",
  "multi_invoice_group_id": "bill_d66a1eac7439444a9ee78f4c949c5dce"
}