JkathBusiness Portal

Invoice Record

05-12-2026-026-INV-013-PART-03

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

0882558

Total

$12,925.00

Invoice data

Matched alias
Ferguson Enterprises LLC
Category
Building Materials:Appliances
Category method
Claude category selection
Invoice date
02/28/2025
Due date
03/30/2025
Vendor terms
NET 10TH PROX
Jkath terms
Net 30
QB Bill ID
310

Category reason

All line items are Thermador branded kitchen appliances: a custom panel dishwasher (TDWHD660EPR), an integrated refrigerator with two drawers (TT42IT100NP), and a pro speed oven (TMC30WP), along with associated Thermador rebates. These are clearly appliances for a residential construction/remodel project (ZAWOYSKI - 5503 LAKEVIEW DR), matching the Appliances category rather than the Plumbing category.

File result

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

Processing Context

Invoice ID
05-12-2026-026-INV-013-PART-03
Run ID
05-12-2026-026
Source folder
/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed
Source file
Ferguson - only enter BENTWOOD invoices perKK.pdf
Stored payloads

Claude parse payload

{
  "tax": 0,
  "notes": "Vendor branch #1657 omitted from vendor_name. Tax code MNI indicates tax-exempt (no tax). Two Thermador rebate line items appear as negative amounts reducing the total. Delivery line item was $0.00 and excluded.",
  "terms": "NET 10TH PROX",
  "total": 12925,
  "due_date": null,
  "shipping": 0,
  "subtotal": 12925,
  "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": 1999,
      "unit_price": 1999,
      "description": "*CVR* CCY LFA 24 CUST PNL SAPPHIRE - TDWHD660EPR (Serial: 104080201222004172)"
    },
    {
      "qty": 1,
      "amount": -1499,
      "unit_price": 1499,
      "description": "THERMADOR BUY 1-2 GET 1 FREE REBATE - THERMADORREBTEVF"
    },
    {
      "qty": 1,
      "amount": 11625,
      "unit_price": 11625,
      "description": "*CVR* CCY LF 42 INTEG FD 2DWR E-ST - TT42IT100NP (Serial: 224050201101001469)"
    },
    {
      "qty": 1,
      "amount": 3149,
      "unit_price": 3149,
      "description": "*CVR* CCY PRO SPEED OVEN 30 208-240 - TMC30WP (Serial: 904095941989778094)"
    },
    {
      "qty": 1,
      "amount": -2349,
      "unit_price": 2349,
      "description": "THERMADOR BUY 1-2 GET 1 FREE REBATE - THERMADORREBTEVF"
    }
  ],
  "vendor_name": "Ferguson Enterprises LLC",
  "invoice_date": "2025-02-28",
  "project_name": "ZAWOYSKI - 5503 LAKEVIEW DR",
  "document_type": "invoice",
  "invoice_number": "0882558",
  "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": "All line items are Thermador branded kitchen appliances: a custom panel dishwasher (TDWHD660EPR), an integrated refrigerator with two drawers (TT42IT100NP), and a pro speed oven (TMC30WP), along with associated Thermador rebates. These are clearly appliances for a residential construction/remodel project (ZAWOYSKI - 5503 LAKEVIEW DR), matching the Appliances category rather than the Plumbing category.",
    "confidence": 0.97,
    "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": null
  },
  "bill_created": {
    "path": "multi_category_direct",
    "total": "12925.00",
    "due_date": "2025-03-30",
    "doc_number": "0882558",
    "vendor_ref": "6",
    "account_ref": "104",
    "jkath_terms": "Net 30",
    "vendor_terms": "NET 10TH PROX",
    "quickbooks_bill_id": "310",
    "resolved_expense_category_id": "cat_6815fb48c53f4221ad0130eaa34c6238"
  },
  "attachment_uploaded": {
    "path": "multi_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "310"
  }
}

Raw payload

{
  "multi_invoice_count": 6,
  "multi_invoice_index": 3,
  "multi_invoice_group_id": "bill_6f4fa2d5883f4d2db8a5475c0ef10dbf",
  "multi_invoice_source_payload": {
    "notes": "PDF contained 6 separate invoices from Ferguson Enterprises LLC (branch #1657, Golden Valley MN). All dated 2025-02-28. Two jobs represented: LODEWYKS (8701 Bentwood Dr, Eden Prairie MN) and ZAWOYSKI (5503 Lakeview Dr, Edina MN). Invoices 1257061 and 1311904 are zero-dollar pre-site service records and are flagged for human review. Invoice 0882558 is tax-exempt (Thermador appliances with rebates). Invoice 0882593 covers taxable items for the same Zawoyski job.",
    "invoices": [
      {
        "tax": 874.32,
        "notes": "Vendor branch #1657 omitted from vendor_name. Delivery/haul-away line items were $0.00 and excluded from line_items. Tax is Hennepin Co $874.32.",
        "terms": "NET 10TH PROX",
        "total": 11130.32,
        "due_date": null,
        "shipping": 0,
        "subtotal": 10256,
        "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": 7679,
            "unit_price": 7679,
            "description": "30\" Panel-Ready Fridge - BB30IB905SP (Serial: 224070518360006826)"
          },
          {
            "qty": 1,
            "amount": 1049,
            "unit_price": 1049,
            "description": "*CVR* LF 30 BENCHMARK BI BOT FRZR R - BSHV53CM3N (Serial: 104090529714021401)"
          },
          {
            "qty": 1,
            "amount": 1329,
            "unit_price": 1329,
            "description": "CCY BI DW PARE 24 5CYC - ZPRB24C01CPG (Serial: 1305905JYK)"
          },
          {
            "qty": 1,
            "amount": 199,
            "unit_price": 199,
            "description": "*CVR* SOLID PNL RDY DR COMPACT - ZPRPNLC24A"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-02-28",
        "project_name": "LODEWYKS - 8701 BENTWOOD DR",
        "document_type": "invoice",
        "invoice_number": "0820348",
        "is_billable_invoice": true
      },
      {
        "tax": 2.99,
        "notes": "Vendor branch #1657 omitted from vendor_name. Source Order references 0820348. Items FOR36SCI6B1 (36\" Induction Range), FPBUILDERVF (F&P Discount Builder Code), and PRD628204L (4FT 4 Wire Range Cord) were ordered but not shipped (qty shipped = 0) and had $0.00 amounts; excluded from line_items. Delivery line item was $0.00 and excluded. Tax is Hennepin Co $2.99.",
        "terms": "NET 10TH PROX",
        "total": 37.99,
        "due_date": null,
        "shipping": 0,
        "subtotal": 35,
        "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": 15,
            "unit_price": 15,
            "description": "LFA 1/4 X 1/4 C 60 SS IM CONN - PFX146205"
          },
          {
            "qty": 1,
            "amount": 20,
            "unit_price": 20,
            "description": "LF 3/8X3/8 C 72 DW CONN W/ FHT ELL - PFXSD6C72ET"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-02-28",
        "project_name": "LODEWYKS - 8701 BENTWOOD DR",
        "document_type": "invoice",
        "invoice_number": "0820397",
        "is_billable_invoice": true
      },
      {
        "tax": 0,
        "notes": "Vendor branch #1657 omitted from vendor_name. Tax code MNI indicates tax-exempt (no tax). Two Thermador rebate line items appear as negative amounts reducing the total. Delivery line item was $0.00 and excluded.",
        "terms": "NET 10TH PROX",
        "total": 12925,
        "due_date": null,
        "shipping": 0,
        "subtotal": 12925,
        "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": 1999,
            "unit_price": 1999,
            "description": "*CVR* CCY LFA 24 CUST PNL SAPPHIRE - TDWHD660EPR (Serial: 104080201222004172)"
          },
          {
            "qty": 1,
            "amount": -1499,
            "unit_price": 1499,
            "description": "THERMADOR BUY 1-2 GET 1 FREE REBATE - THERMADORREBTEVF"
          },
          {
            "qty": 1,
            "amount": 11625,
            "unit_price": 11625,
            "description": "*CVR* CCY LF 42 INTEG FD 2DWR E-ST - TT42IT100NP (Serial: 224050201101001469)"
          },
          {
            "qty": 1,
            "amount": 3149,
            "unit_price": 3149,
            "description": "*CVR* CCY PRO SPEED OVEN 30 208-240 - TMC30WP (Serial: 904095941989778094)"
          },
          {
            "qty": 1,
            "amount": -2349,
            "unit_price": 2349,
            "description": "THERMADOR BUY 1-2 GET 1 FREE REBATE - THERMADORREBTEVF"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-02-28",
        "project_name": "ZAWOYSKI - 5503 LAKEVIEW DR",
        "document_type": "invoice",
        "invoice_number": "0882558",
        "is_billable_invoice": true
      },
      {
        "tax": 1032.37,
        "notes": "Vendor branch #1657 omitted from vendor_name. Tax is Edina $1032.37. Delivery line item was $0.00 and excluded. This is a separate invoice from 0882558 for the same job but covers taxable items (job name: ZAWOYSKI TAX ITEMS).",
        "terms": "NET 10TH PROX",
        "total": 12471.37,
        "due_date": null,
        "shipping": 0,
        "subtotal": 11439,
        "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": 11439,
            "unit_price": 11439,
            "description": "CCY FS RNGE SS 48 NAT 6 BRNR W/ GRD - TPRG486WDG (Serial: 394100296957000531)"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-02-28",
        "project_name": "ZAWOYSKI - 5503 LAKEVIEW DR",
        "document_type": "invoice",
        "invoice_number": "0882593",
        "is_billable_invoice": true
      },
      {
        "tax": 0,
        "notes": "Zero-dollar invoice for JOB PRE SITE service referencing Source Order 0820348. Total is $0.00; needs human review. is_billable_invoice set to false due to zero balance. Vendor branch #1657 omitted from vendor_name.",
        "terms": "NET 10TH PROX",
        "total": 0,
        "due_date": null,
        "shipping": 0,
        "subtotal": 0,
        "confidence": {
          "total": 0.99,
          "vendor_name": 0.99,
          "invoice_date": 0.99,
          "project_name": 0.95,
          "invoice_number": 0.99
        },
        "line_items": [],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-02-28",
        "project_name": "LODEWYKS - 8701 BENTWOOD DR",
        "document_type": "invoice",
        "invoice_number": "1257061",
        "is_billable_invoice": false
      },
      {
        "tax": 0,
        "notes": "Zero-dollar invoice for JOB PRE SITE service referencing Source Order 1311869. Total is $0.00; needs human review. is_billable_invoice set to false due to zero balance. Vendor branch #1657 omitted from vendor_name.",
        "terms": "NET 10TH PROX",
        "total": 0,
        "due_date": null,
        "shipping": 0,
        "subtotal": 0,
        "confidence": {
          "total": 0.99,
          "vendor_name": 0.99,
          "invoice_date": 0.99,
          "project_name": 0.95,
          "invoice_number": 0.99
        },
        "line_items": [],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-02-28",
        "project_name": "ZAWOYSKI - 5503 LAKEVIEW DR",
        "document_type": "invoice",
        "invoice_number": "1311904",
        "is_billable_invoice": false
      }
    ]
  }
}

Invoice Timeline

Time

05/11/2026

Event

PARSE COMPLETED

Message

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

Payload
{
  "total": "12925.00",
  "message": "Claude extraction parsed and stored.",
  "due_date": "2025-03-30",
  "jkath_terms": "Net 30",
  "process_key": "05-12-2026-026-INV-013",
  "vendor_name": "Ferguson Enterprises LLC",
  "claude_model": "claude-sonnet-4-6",
  "input_tokens": "15296",
  "invoice_date": "2025-02-28",
  "vendor_terms": "NET 10TH PROX",
  "make_trace_id": "make-20260511_230756_287",
  "output_tokens": "2755",
  "bill_import_id": "bill_6f4fa2d5883f4d2db8a5475c0ef10dbf",
  "invoice_number": "0882558",
  "vendor_due_date": null,
  "source_file_name": "Ferguson - only enter BENTWOOD invoices perKK.pdf",
  "claude_message_id": "msg_01BdimYsEQDo6835yG8UW1cd",
  "multi_invoice_count": 6,
  "multi_invoice_index": 3
}

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-12-2026-026-INV-013-PART-03",
  "vendor_name": "Ferguson Enterprises LLC",
  "make_trace_id": "make-20260511_230756_287",
  "bill_import_id": "bill_04da1d0e3e6b4a01b4a89855dbb6f142",
  "canonical_name": "Ferguson Enterprises LLC",
  "category_count": 2,
  "invoice_number": "0882558",
  "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 BENTWOOD invoices perKK.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-12-2026-026-INV-013-PART-03",
  "vendor_name": "Ferguson Enterprises LLC",
  "category_name": "Appliances",
  "make_trace_id": "make-20260511_230756_287",
  "bill_import_id": "bill_04da1d0e3e6b4a01b4a89855dbb6f142",
  "source_file_name": "Ferguson - only enter BENTWOOD invoices perKK.pdf",
  "selection_payload": {
    "reason": "All line items are Thermador branded kitchen appliances: a custom panel dishwasher (TDWHD660EPR), an integrated refrigerator with two drawers (TT42IT100NP), and a pro speed oven (TMC30WP), along with associated Thermador rebates. These are clearly appliances for a residential construction/remodel project (ZAWOYSKI - 5503 LAKEVIEW DR), matching the Appliances category rather than the Plumbing category.",
    "confidence": 0.97,
    "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-12-2026-026-INV-013-PART-03",
  "vendor_name": "Ferguson Enterprises LLC",
  "make_trace_id": "make-20260511_230756_287",
  "bill_import_id": "bill_04da1d0e3e6b4a01b4a89855dbb6f142",
  "invoice_number": "0882558",
  "source_file_name": "Ferguson - only enter BENTWOOD invoices perKK.pdf",
  "quickbooks_vendor_id": "6",
  "quickbooks_account_id": "104",
  "existing_quickbooks_bill_id": null
}

Time

05/11/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-026-INV-013-PART-03",
  "make_trace_id": "make-20260511_230756_287",
  "bill_import_id": "bill_04da1d0e3e6b4a01b4a89855dbb6f142",
  "source_file_name": "Ferguson - only enter BENTWOOD invoices perKK.pdf",
  "quickbooks_bill_id": "310",
  "quickbooks_payload": {
    "path": "multi_category_direct",
    "total": "12925.00",
    "due_date": "2025-03-30",
    "doc_number": "0882558",
    "vendor_ref": "6",
    "account_ref": "104",
    "jkath_terms": "Net 30",
    "vendor_terms": "NET 10TH PROX",
    "quickbooks_bill_id": "310"
  },
  "quickbooks_account_id": "104",
  "resolved_expense_category_id": "cat_6815fb48c53f4221ad0130eaa34c6238"
}

Time

05/11/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-026-INV-013-PART-03",
  "make_trace_id": "make-20260511_230756_287",
  "bill_import_id": "bill_04da1d0e3e6b4a01b4a89855dbb6f142",
  "source_file_name": "Ferguson - only enter BENTWOOD invoices perKK.pdf",
  "attachment_payload": {
    "path": "multi_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "310"
  },
  "quickbooks_bill_id": "310"
}