JkathBusiness Portal

Invoice Record

05-11-2026-019-INV-001

Ferguson Enterprises LLC
Back to vendor

Bill Created Successfully

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

View Bill in QBView Invoice in Dropbox

Status

Created in QB

Invoice

2023372

Total

$13,227.00

Invoice data

Matched alias
Ferguson Enterprises LLC
Category
Building Materials:Appliances
Category method
Claude category selection
Invoice date
02/19/2026
Due date
03/21/2026
Vendor terms
Net 10th Prox
Jkath terms
Net 30
QB Bill ID
242

Category reason

Both line items are clearly appliances: a 36" Classic French Door Refrigerator (SCL3650UFDO) and a Built-In Panel-Ready Dishwasher (CDW2451). These are appliance products, not plumbing supplies, fixtures, pipes, or valves. The Appliances category (mapped from Building Materials:Appliances in QuickBooks) is the correct match for this Ferguson invoice on the 4432 Derrymoor CT - Bonderud project.

File result

Outcome
processed
Details
QuickBooks Bill created successfully. Source file attached to the Bill.
View Bill in QuickBooksView Invoice in Dropbox

Processing Context

Invoice ID
05-11-2026-019-INV-001
Run ID
05-11-2026-019
Source folder
/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed
Source file
FergusonEnterprisesLLC_INV-2023372_DUPLICATE-BILL.pdf
Stored payloads

Claude parse payload

{
  "tax": 0,
  "notes": "Vendor branch suffix #1657 omitted from vendor_name per rules; full name is Ferguson Enterprises LLC #1657. The CCY 30 SPD Oven Drop-Down Door (WSPO3050PMSP) was ordered but not shipped (qty shipped = 0) and shows $0.00 amount, so it is excluded from line_items. The USETAX and delivery/uncrate line items show $0.00 and are excluded. Invoice date printed as 02/19/26, interpreted as 2026-02-19 consistent with 2026 processing batch. Master account number 737714 noted for reference.",
  "terms": "Net 10th Prox",
  "total": 13227,
  "due_date": null,
  "shipping": 0,
  "subtotal": 13227,
  "confidence": {
    "total": 0.99,
    "vendor_name": 0.99,
    "invoice_date": 0.97,
    "project_name": 0.95,
    "invoice_number": 0.99
  },
  "line_items": [
    {
      "qty": 1,
      "amount": 10774,
      "unit_price": 10774,
      "description": "CCY LF 36 Classic French Door Refrigerator (SCL3650UFDO) - Serial #4970428"
    },
    {
      "qty": 1,
      "amount": 2453,
      "unit_price": 2453,
      "description": "CCY BI Pare DW SS 24 12CYC (CDW2451) - Serial #20196583"
    }
  ],
  "vendor_name": "Ferguson Enterprises LLC",
  "invoice_date": "2026-02-19",
  "project_name": "4432 Derrymoor CT - Bonderud",
  "document_type": "invoice",
  "invoice_number": "2023372",
  "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": "Both line items are clearly appliances: a 36\" Classic French Door Refrigerator (SCL3650UFDO) and a Built-In Panel-Ready Dishwasher (CDW2451). These are appliance products, not plumbing supplies, fixtures, pipes, or valves. The Appliances category (mapped from Building Materials:Appliances in QuickBooks) is the correct match for this Ferguson invoice on the 4432 Derrymoor CT - Bonderud project.",
    "confidence": 0.98,
    "category_name": "Appliances",
    "expense_category_id": "cat_6815fb48c53f4221ad0130eaa34c6238",
    "quickbooks_account_id": "104",
    "selected_expense_category_id": "cat_6815fb48c53f4221ad0130eaa34c6238",
    "selected_expense_category_name": "Appliances"
  }
}

QB payload

{
  "lookup": {
    "quickbooks_vendor_id": "6",
    "quickbooks_account_id": "104",
    "existing_quickbooks_bill_id": "242"
  },
  "duplicate_bill": {
    "path": "multi_category_direct_duplicate",
    "invoice_number": "2023372",
    "existing_quickbooks_bill_id": "242"
  }
}

Raw payload

{
  "run_id": "run_cd232df711c741cbb59f61906e54b6f9",
  "source": "make.com",
  "run_key": "05-11-2026-019",
  "make_trace_id": "make-20260511_155703_770",
  "source_file_name": "FergusonEnterprisesLLC_INV-2023372_DUPLICATE-BILL.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/FergusonEnterprisesLLC_INV-2023372_DUPLICATE-BILL.pdf",
  "source_dropbox_id": "id:CHX6_xJiKhAAAAAAAABpUA",
  "source_dropbox_rev": "0165190e93dc6df00000003549f4393",
  "source_content_hash": "5daf00059abc66e6b538ca76962e8a9919a5e616082a61985089c0e5c5982ac9",
  "processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/FergusonEnterprisesLLC_INV-2023372_DUPLICATE-BILL.pdf",
  "processing_dropbox_rev": "0165190fd3d664600000003549f4393"
}

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-2023372_DUPLICATE-BILL.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/FergusonEnterprisesLLC_INV-2023372_DUPLICATE-BILL.pdf",
  "processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/FergusonEnterprisesLLC_INV-2023372_DUPLICATE-BILL.pdf"
}

Time

05/11/2026

Event

PARSE COMPLETED

Message

Claude extraction parsed and stored.

Payload
{
  "message": "Claude extraction parsed and stored.",
  "process_key": "05-11-2026-019-INV-001",
  "claude_model": "claude-sonnet-4-6",
  "input_tokens": "3723",
  "make_trace_id": "make-20260511_155703_770",
  "output_tokens": "528",
  "bill_import_id": "bill_b73e94a91cda43a48140b1ff527f9ce3",
  "source_file_name": "FergusonEnterprisesLLC_INV-2023372_DUPLICATE-BILL.pdf",
  "claude_message_id": "msg_01YaGRPMwRfH8Y1mNGeKpogp"
}

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-11-2026-019-INV-001",
  "vendor_name": "Ferguson Enterprises LLC",
  "make_trace_id": "make-20260511_155703_770",
  "bill_import_id": "bill_b73e94a91cda43a48140b1ff527f9ce3",
  "canonical_name": "Ferguson Enterprises LLC",
  "category_count": 2,
  "invoice_number": "2023372",
  "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-2023372_DUPLICATE-BILL.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-11-2026-019-INV-001",
  "vendor_name": "Ferguson Enterprises LLC",
  "category_name": "Appliances",
  "make_trace_id": "make-20260511_155703_770",
  "bill_import_id": "bill_b73e94a91cda43a48140b1ff527f9ce3",
  "source_file_name": "FergusonEnterprisesLLC_INV-2023372_DUPLICATE-BILL.pdf",
  "selection_payload": {
    "reason": "Both line items are clearly appliances: a 36\" Classic French Door Refrigerator (SCL3650UFDO) and a Built-In Panel-Ready Dishwasher (CDW2451). These are appliance products, not plumbing supplies, fixtures, pipes, or valves. The Appliances category (mapped from Building Materials:Appliances in QuickBooks) is the correct match for this Ferguson invoice on the 4432 Derrymoor CT - Bonderud project.",
    "confidence": 0.98,
    "selected_expense_category_id": "cat_6815fb48c53f4221ad0130eaa34c6238",
    "selected_expense_category_name": "Appliances"
  },
  "expense_category_id": "cat_6815fb48c53f4221ad0130eaa34c6238",
  "quickbooks_account_id": "104"
}

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-11-2026-019-INV-001",
  "vendor_name": "Ferguson Enterprises LLC",
  "make_trace_id": "make-20260511_155703_770",
  "bill_import_id": "bill_b73e94a91cda43a48140b1ff527f9ce3",
  "invoice_number": "2023372",
  "source_file_name": "FergusonEnterprisesLLC_INV-2023372_DUPLICATE-BILL.pdf",
  "quickbooks_vendor_id": "6",
  "quickbooks_account_id": "104",
  "existing_quickbooks_bill_id": "242"
}

Time

05/11/2026

Event

DUPLICATE FOUND

Message

Duplicate QuickBooks Bill found.

Payload
{
  "path": "multi_category_direct_duplicate",
  "message": "Duplicate QuickBooks Bill found; no new Bill was created.",
  "process_key": "05-11-2026-019-INV-001",
  "make_trace_id": "make-20260511_155703_770",
  "bill_import_id": "bill_b73e94a91cda43a48140b1ff527f9ce3",
  "final_file_name": "FergusonEnterprisesLLC_INV-2023372_DUPLICATE-BILL.pdf",
  "source_file_name": "FergusonEnterprisesLLC_INV-2023372_DUPLICATE-BILL.pdf",
  "dropbox_shared_url": "https://www.dropbox.com/scl/fi/pxzpw46oum4oh3muzask7/FergusonEnterprisesLLC_INV-2023372_DUPLICATE-BILL.pdf?rlkey=rp2ilnr1av0mfb8jkfyqfqyhe&dl=0",
  "quickbooks_payload": {
    "path": "multi_category_direct_duplicate",
    "invoice_number": "2023372",
    "existing_quickbooks_bill_id": "242"
  },
  "existing_quickbooks_bill_id": "242"
}