Invoice Record

05-12-2026-021-INV-001-PART-02

Ferguson Enterprises LLC

Back to run

Bill Created Successfully

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

View Bill in QB View Invoice in Dropbox

Status

Created in QB

Invoice

1065982

Total

$7,202.62

Invoice data

Detected vendor: Ferguson Enterprises LLC
Matched vendor: Ferguson Enterprises LLC
Matched alias: Ferguson Enterprises LLC
Category: Building Materials:Plumbing
Category method: Claude category selection
Invoice date: 01/06/2025
Due date: 02/05/2025
Vendor terms: Net 10th Prox
Jkath terms: Net 30
QB Bill ID: 263

Category reason

All line items on this Ferguson Enterprises invoice are plumbing fixtures, faucets, sinks, toilets, shower components, and related hardware (lavatories, kitchen faucets, pedestal faucets, toilet tanks/bowls, shower arms/heads, valve trims, utility sinks, drain fittings, etc.). Per the vendor-specific notes, Ferguson invoices with construction/job plumbing materials should be categorized as Building Materials plumbing. The only available Building Materials sub-category matching plumbing supplies and fixtures is 'Plumbing' (cat_173f2c1a36d74231bf0b9d9c755c7b0d). The project context 'Shamp - Finish' confirms this is a finish-phase construction project requiring plumbing fixtures. None of the items qualify as appliances.

File result

Final file: FergusonEnterprisesLLC_INV-1065982.pdf
Outcome: processed
Details: QuickBooks Bill created successfully. Source file attached to the Bill.

View Bill in QuickBooks View Invoice in Dropbox

Processing Context

Invoice ID: 05-12-2026-021-INV-001-PART-02
Run ID: 05-12-2026-021
Source folder: /_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed
Source file: 737714_20250108_30020271_13834279693_VALIDATION-FAILED.pdf

Stored payloads

Claude parse payload

{
  "tax": 541.27,
  "notes": "Vendor branch/store number #1657 omitted from vendor_name. Ship to: JKATH Design Build - Shamp Jobsite, 15890 York Circle NW, Anoka, MN 55303. Tax jurisdiction: Anoka County. Customer number: 554796. Master account: 737714. Some line items appear duplicated in the invoice (same item number ordered separately, e.g. K20000-0, A3075000020, A4000101020) — extracted as separate line items matching the invoice. Note: the same Batch number (374369) appears on both invoices in this PDF.",
  "terms": "Net 10th Prox",
  "total": 7202.62,
  "due_date": null,
  "shipping": 0,
  "subtotal": 6661.35,
  "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": 94.25,
      "unit_price": 94.25,
      "description": "@ 20-5/16X15-3/4 VC UC LAV WHIT (K20000-0)"
    },
    {
      "qty": 2,
      "amount": 188.5,
      "unit_price": 94.25,
      "description": "@ 20-5/16X15-3/4 VC UC LAV WHIT (K20000-0)"
    },
    {
      "qty": 1,
      "amount": 277.03,
      "unit_price": 277.03,
      "description": "15X15 0H 1B TM QTZ SINK WHIT (EELG1616WH0)"
    },
    {
      "qty": 1,
      "amount": 695.04,
      "unit_price": 695.04,
      "description": "CCY LFA 1.8 1HDL LEV KITC FCT LUGO (D63375LFGLLHP)"
    },
    {
      "qty": 1,
      "amount": 546.56,
      "unit_price": 546.56,
      "description": "CCY LFA 1.8 1HDL PD PREP FCT LUGO (D63975LFGLLHP)"
    },
    {
      "qty": 1,
      "amount": 491.52,
      "unit_price": 491.52,
      "description": "CCN LFA 1.5 2HDL LEV W/SPRD LAV FCT (D65360LFPNLHP)"
    },
    {
      "qty": 1,
      "amount": 152.32,
      "unit_price": 152.32,
      "description": "LAV LEV HDL KIT *ROOK (DHL5360PN)"
    },
    {
      "qty": 1,
      "amount": 79.36,
      "unit_price": 79.36,
      "description": "PD FCT LEV HDL *ODIN LUGO (DHLK175GL)"
    },
    {
      "qty": 1,
      "amount": 79.36,
      "unit_price": 79.36,
      "description": "PD FCT LEV HDL *ODIN LUGO (DHLK175GL)"
    },
    {
      "qty": 2,
      "amount": 404.16,
      "unit_price": 202.08,
      "description": "CCY LFA 1.2 2HDL LEV CC LAV FCT (D2535CZMPUDST)"
    },
    {
      "qty": 1,
      "amount": 249.82,
      "unit_price": 249.82,
      "description": "@ CCY LFA 1.8 1HDL PD KITC FCT (D9113ARDST)"
    },
    {
      "qty": 1,
      "amount": 227.39,
      "unit_price": 227.392,
      "description": "CCY 1HDL LEV WALL VLV TRIM *SAYLOR (DT14435CZ)"
    },
    {
      "qty": 1,
      "amount": 84.96,
      "unit_price": 84.96,
      "description": "16 SHWR ARM *CASSID BRPN (DRP61273PN)"
    },
    {
      "qty": 1,
      "amount": 207.33,
      "unit_price": 207.328,
      "description": "@ CCN 2.5 SHWRHD *CASSID PN (DRP72568PN)"
    },
    {
      "qty": 1,
      "amount": 282.6,
      "unit_price": 282.6,
      "description": "CCY 1.28 GPF EB W/ SEAT *CADET III (A3075000020)"
    },
    {
      "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": 81.6,
      "unit_price": 81.6,
      "description": "CCY 1.28 CLST TANK *CADET III WHIT (A4000101020)"
    },
    {
      "qty": 1,
      "amount": 290.95,
      "unit_price": 290.95,
      "description": "24X19 1H 1B SS UC LDRY UTIL SINK (KKHU10124L)"
    },
    {
      "qty": 2,
      "amount": 958.27,
      "unit_price": 479.136,
      "description": "CCY LFA 2HDL W/SPRD LAV MTL PU (D3597LFPNMPU)"
    },
    {
      "qty": 1,
      "amount": 117.7,
      "unit_price": 117.696,
      "description": "2 LEV RT HDL KIT *CASSID BRPN (DH697PN)"
    },
    {
      "qty": 1,
      "amount": 59.87,
      "unit_price": 59.872,
      "description": "SGL LEV BATH HDL KIT *CASSID B (DH797PN)"
    },
    {
      "qty": 1,
      "amount": 16.93,
      "unit_price": 16.928,
      "description": "2-1/2 SHWR FLG LUMICOAT PN (DRP6025PNPR)"
    },
    {
      "qty": 1,
      "amount": 183.46,
      "unit_price": 183.456,
      "description": "VLV TRIM *CASSID 14 SER BRPN (DT14097PNLHP)"
    },
    {
      "qty": 1,
      "amount": 473.09,
      "unit_price": 473.088,
      "description": "CCY 1.75 BRPN *CASSID RT W/ H/ (DT4797PNLHP)"
    },
    {
      "qty": 1,
      "amount": 55.08,
      "unit_price": 55.08,
      "description": "SINK STRN DRN FTG WHIT (ELKQS35WH)"
    }
  ],
  "vendor_name": "Ferguson Enterprises LLC",
  "invoice_date": "2025-01-06",
  "project_name": "Shamp - Finish",
  "document_type": "invoice",
  "invoice_number": "1065982",
  "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 on this Ferguson Enterprises invoice are plumbing fixtures, faucets, sinks, toilets, shower components, and related hardware (lavatories, kitchen faucets, pedestal faucets, toilet tanks/bowls, shower arms/heads, valve trims, utility sinks, drain fittings, etc.). Per the vendor-specific notes, Ferguson invoices with construction/job plumbing materials should be categorized as Building Materials plumbing. The only available Building Materials sub-category matching plumbing supplies and fixtures is 'Plumbing' (cat_173f2c1a36d74231bf0b9d9c755c7b0d). The project context 'Shamp - Finish' confirms this is a finish-phase construction project requiring plumbing fixtures. None of the items qualify as appliances.",
    "confidence": 0.97,
    "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": "7202.62",
    "due_date": "2025-02-05",
    "doc_number": "1065982",
    "vendor_ref": "6",
    "account_ref": "113",
    "jkath_terms": "Net 30",
    "vendor_terms": "Net 10th Prox",
    "quickbooks_bill_id": "263",
    "resolved_expense_category_id": "cat_173f2c1a36d74231bf0b9d9c755c7b0d"
  },
  "attachment_uploaded": {
    "path": "multi_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "263"
  }
}

Raw payload

{
  "multi_invoice_count": 2,
  "multi_invoice_index": 2,
  "multi_invoice_group_id": "bill_5a42935f52394e7097f8959194a68735",
  "multi_invoice_source_payload": {
    "notes": "PDF contains two separate invoices from Ferguson Enterprises LLC: Invoice 0873035 for Peterson - Plumbing project ($3,099.54) and Invoice 1065982 for Shamp - Finish project ($7,202.62). Both dated 2025-01-06 and share the same batch number 374369 but have different invoice numbers, customer numbers, ship-to addresses, and job names. Totals kept separate and not combined.",
    "invoices": [
      {
        "tax": 278.57,
        "notes": "Vendor branch/store number #1657 omitted from vendor_name. Ship to: Luisa & Erick Peterson, 2258 Saint Clair Ave, Saint Paul, MN 55105. Tax jurisdiction: St Paul. Customer number: 199557. Master account: 737714.",
        "terms": "Net 10th Prox",
        "total": 3099.54,
        "due_date": null,
        "shipping": 0,
        "subtotal": 2820.97,
        "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": 752.06,
            "unit_price": 752.06,
            "description": "31X19 0H 1B UC FRCLY SINK *ALLIA WH (R630700)"
          },
          {
            "qty": 1,
            "amount": 778.88,
            "unit_price": 778.88,
            "description": "CCY LFA 1.8 1HDL LEV PD KITC FCT (D63074LFGL)"
          },
          {
            "qty": 1,
            "amount": 95.36,
            "unit_price": 95.36,
            "description": "DISP & FLG STPR KITC LUGO (D69070GL)"
          },
          {
            "qty": 1,
            "amount": 176.25,
            "unit_price": 176.25,
            "description": "3/4 HP GARBAGE DISP W/ CORD *BADGER (IBADGER5XPWC)"
          },
          {
            "qty": 1,
            "amount": 74.75,
            "unit_price": 74.75,
            "description": "15X12 UC VC LAV *CAXTON WHIT (K2209-0)"
          },
          {
            "qty": 1,
            "amount": 263.97,
            "unit_price": 263.97,
            "description": "LFA MANHATTAN W/SPRD B/ROOM FAUCE (KFSC8920CML)"
          },
          {
            "qty": 1,
            "amount": 184.2,
            "unit_price": 184.2,
            "description": "CCY @ CLST TANK *MEMSTA WHIT 1.28 (K4434-0)"
          },
          {
            "qty": 1,
            "amount": 243.1,
            "unit_price": 243.1,
            "description": "CCY 1.28 12 EB *COMHEI BO (K5626-0)"
          },
          {
            "qty": 1,
            "amount": 45.54,
            "unit_price": 45.54,
            "description": "QC EB SEAT READYLATCH *GLENBU WHIT (K4733-RL-0)"
          },
          {
            "qty": 1,
            "amount": 93.81,
            "unit_price": 93.812,
            "description": "FLUSH LEV *GREYFIELD MB (SHGF100TLMB)"
          },
          {
            "qty": 1,
            "amount": 113.05,
            "unit_price": 113.05,
            "description": "PVT PAPER HLDR *GREYF MB (SHGFTHMB)"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-01-06",
        "project_name": "Peterson - Plumbing",
        "document_type": "invoice",
        "invoice_number": "0873035",
        "is_billable_invoice": true
      },
      {
        "tax": 541.27,
        "notes": "Vendor branch/store number #1657 omitted from vendor_name. Ship to: JKATH Design Build - Shamp Jobsite, 15890 York Circle NW, Anoka, MN 55303. Tax jurisdiction: Anoka County. Customer number: 554796. Master account: 737714. Some line items appear duplicated in the invoice (same item number ordered separately, e.g. K20000-0, A3075000020, A4000101020) — extracted as separate line items matching the invoice. Note: the same Batch number (374369) appears on both invoices in this PDF.",
        "terms": "Net 10th Prox",
        "total": 7202.62,
        "due_date": null,
        "shipping": 0,
        "subtotal": 6661.35,
        "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": 94.25,
            "unit_price": 94.25,
            "description": "@ 20-5/16X15-3/4 VC UC LAV WHIT (K20000-0)"
          },
          {
            "qty": 2,
            "amount": 188.5,
            "unit_price": 94.25,
            "description": "@ 20-5/16X15-3/4 VC UC LAV WHIT (K20000-0)"
          },
          {
            "qty": 1,
            "amount": 277.03,
            "unit_price": 277.03,
            "description": "15X15 0H 1B TM QTZ SINK WHIT (EELG1616WH0)"
          },
          {
            "qty": 1,
            "amount": 695.04,
            "unit_price": 695.04,
            "description": "CCY LFA 1.8 1HDL LEV KITC FCT LUGO (D63375LFGLLHP)"
          },
          {
            "qty": 1,
            "amount": 546.56,
            "unit_price": 546.56,
            "description": "CCY LFA 1.8 1HDL PD PREP FCT LUGO (D63975LFGLLHP)"
          },
          {
            "qty": 1,
            "amount": 491.52,
            "unit_price": 491.52,
            "description": "CCN LFA 1.5 2HDL LEV W/SPRD LAV FCT (D65360LFPNLHP)"
          },
          {
            "qty": 1,
            "amount": 152.32,
            "unit_price": 152.32,
            "description": "LAV LEV HDL KIT *ROOK (DHL5360PN)"
          },
          {
            "qty": 1,
            "amount": 79.36,
            "unit_price": 79.36,
            "description": "PD FCT LEV HDL *ODIN LUGO (DHLK175GL)"
          },
          {
            "qty": 1,
            "amount": 79.36,
            "unit_price": 79.36,
            "description": "PD FCT LEV HDL *ODIN LUGO (DHLK175GL)"
          },
          {
            "qty": 2,
            "amount": 404.16,
            "unit_price": 202.08,
            "description": "CCY LFA 1.2 2HDL LEV CC LAV FCT (D2535CZMPUDST)"
          },
          {
            "qty": 1,
            "amount": 249.82,
            "unit_price": 249.82,
            "description": "@ CCY LFA 1.8 1HDL PD KITC FCT (D9113ARDST)"
          },
          {
            "qty": 1,
            "amount": 227.39,
            "unit_price": 227.392,
            "description": "CCY 1HDL LEV WALL VLV TRIM *SAYLOR (DT14435CZ)"
          },
          {
            "qty": 1,
            "amount": 84.96,
            "unit_price": 84.96,
            "description": "16 SHWR ARM *CASSID BRPN (DRP61273PN)"
          },
          {
            "qty": 1,
            "amount": 207.33,
            "unit_price": 207.328,
            "description": "@ CCN 2.5 SHWRHD *CASSID PN (DRP72568PN)"
          },
          {
            "qty": 1,
            "amount": 282.6,
            "unit_price": 282.6,
            "description": "CCY 1.28 GPF EB W/ SEAT *CADET III (A3075000020)"
          },
          {
            "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": 81.6,
            "unit_price": 81.6,
            "description": "CCY 1.28 CLST TANK *CADET III WHIT (A4000101020)"
          },
          {
            "qty": 1,
            "amount": 290.95,
            "unit_price": 290.95,
            "description": "24X19 1H 1B SS UC LDRY UTIL SINK (KKHU10124L)"
          },
          {
            "qty": 2,
            "amount": 958.27,
            "unit_price": 479.136,
            "description": "CCY LFA 2HDL W/SPRD LAV MTL PU (D3597LFPNMPU)"
          },
          {
            "qty": 1,
            "amount": 117.7,
            "unit_price": 117.696,
            "description": "2 LEV RT HDL KIT *CASSID BRPN (DH697PN)"
          },
          {
            "qty": 1,
            "amount": 59.87,
            "unit_price": 59.872,
            "description": "SGL LEV BATH HDL KIT *CASSID B (DH797PN)"
          },
          {
            "qty": 1,
            "amount": 16.93,
            "unit_price": 16.928,
            "description": "2-1/2 SHWR FLG LUMICOAT PN (DRP6025PNPR)"
          },
          {
            "qty": 1,
            "amount": 183.46,
            "unit_price": 183.456,
            "description": "VLV TRIM *CASSID 14 SER BRPN (DT14097PNLHP)"
          },
          {
            "qty": 1,
            "amount": 473.09,
            "unit_price": 473.088,
            "description": "CCY 1.75 BRPN *CASSID RT W/ H/ (DT4797PNLHP)"
          },
          {
            "qty": 1,
            "amount": 55.08,
            "unit_price": 55.08,
            "description": "SINK STRN DRN FTG WHIT (ELKQS35WH)"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-01-06",
        "project_name": "Shamp - Finish",
        "document_type": "invoice",
        "invoice_number": "1065982",
        "is_billable_invoice": true
      }
    ]
  }
}

Invoice Timeline

Time

05/11/2026

Event

PARSE COMPLETED

Message

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

Payload

{
  "total": "7202.62",
  "message": "Claude extraction parsed and stored.",
  "due_date": "2025-02-05",
  "jkath_terms": "Net 30",
  "process_key": "05-12-2026-021-INV-001",
  "vendor_name": "Ferguson Enterprises LLC",
  "claude_model": "claude-sonnet-4-6",
  "input_tokens": "7233",
  "invoice_date": "2025-01-06",
  "vendor_terms": "Net 10th Prox",
  "make_trace_id": "make-20260511_212027_340",
  "output_tokens": "2953",
  "bill_import_id": "bill_5a42935f52394e7097f8959194a68735",
  "invoice_number": "1065982",
  "vendor_due_date": null,
  "source_file_name": "737714_20250108_30020271_13834279693_VALIDATION-FAILED.pdf",
  "claude_message_id": "msg_015CJm2AUspM2jbtHALahYmc",
  "multi_invoice_count": 2,
  "multi_invoice_index": 2
}

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-021-INV-001-PART-02",
  "vendor_name": "Ferguson Enterprises LLC",
  "make_trace_id": "make-20260511_212027_340",
  "bill_import_id": "bill_fa4497565b5242539d4708a6a550f94a",
  "canonical_name": "Ferguson Enterprises LLC",
  "category_count": 2,
  "invoice_number": "1065982",
  "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_20250108_30020271_13834279693_VALIDATION-FAILED.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-021-INV-001-PART-02",
  "vendor_name": "Ferguson Enterprises LLC",
  "category_name": "Plumbing",
  "make_trace_id": "make-20260511_212027_340",
  "bill_import_id": "bill_fa4497565b5242539d4708a6a550f94a",
  "source_file_name": "737714_20250108_30020271_13834279693_VALIDATION-FAILED.pdf",
  "selection_payload": {
    "reason": "All line items on this Ferguson Enterprises invoice are plumbing fixtures, faucets, sinks, toilets, shower components, and related hardware (lavatories, kitchen faucets, pedestal faucets, toilet tanks/bowls, shower arms/heads, valve trims, utility sinks, drain fittings, etc.). Per the vendor-specific notes, Ferguson invoices with construction/job plumbing materials should be categorized as Building Materials plumbing. The only available Building Materials sub-category matching plumbing supplies and fixtures is 'Plumbing' (cat_173f2c1a36d74231bf0b9d9c755c7b0d). The project context 'Shamp - Finish' confirms this is a finish-phase construction project requiring plumbing fixtures. None of the items qualify as appliances.",
    "confidence": 0.97,
    "selected_expense_category_id": "cat_173f2c1a36d74231bf0b9d9c755c7b0d",
    "selected_expense_category_name": "Plumbing"
  },
  "expense_category_id": "cat_173f2c1a36d74231bf0b9d9c755c7b0d",
  "quickbooks_account_id": "113"
}

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-021-INV-001-PART-02",
  "vendor_name": "Ferguson Enterprises LLC",
  "make_trace_id": "make-20260511_212027_340",
  "bill_import_id": "bill_fa4497565b5242539d4708a6a550f94a",
  "invoice_number": "1065982",
  "source_file_name": "737714_20250108_30020271_13834279693_VALIDATION-FAILED.pdf",
  "quickbooks_vendor_id": "6",
  "quickbooks_account_id": "113",
  "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-021-INV-001-PART-02",
  "make_trace_id": "make-20260511_212027_340",
  "bill_import_id": "bill_fa4497565b5242539d4708a6a550f94a",
  "source_file_name": "737714_20250108_30020271_13834279693_VALIDATION-FAILED.pdf",
  "quickbooks_bill_id": "263",
  "quickbooks_payload": {
    "path": "multi_category_direct",
    "total": "7202.62",
    "due_date": "2025-02-05",
    "doc_number": "1065982",
    "vendor_ref": "6",
    "account_ref": "113",
    "jkath_terms": "Net 30",
    "vendor_terms": "Net 10th Prox",
    "quickbooks_bill_id": "263"
  },
  "quickbooks_account_id": "113",
  "resolved_expense_category_id": "cat_173f2c1a36d74231bf0b9d9c755c7b0d"
}

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-021-INV-001-PART-02",
  "make_trace_id": "make-20260511_212027_340",
  "bill_import_id": "bill_fa4497565b5242539d4708a6a550f94a",
  "source_file_name": "737714_20250108_30020271_13834279693_VALIDATION-FAILED.pdf",
  "attachment_payload": {
    "path": "multi_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "263"
  },
  "quickbooks_bill_id": "263"
}

Time

05/11/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-021-INV-001-PART-02",
  "make_trace_id": "make-20260511_212027_340",
  "bill_import_id": "bill_fa4497565b5242539d4708a6a550f94a",
  "final_file_name": "FergusonEnterprisesLLC_INV-1065982.pdf",
  "source_file_name": "737714_20250108_30020271_13834279693_VALIDATION-FAILED.pdf",
  "dropbox_shared_url": "https://www.dropbox.com/scl/fi/7iht9g6ptbf1zk0vfp2jm/FergusonEnterprisesLLC_INV-1065982.pdf?rlkey=fj134zcz0n9ecq7ltsteqvdrr&dl=0",
  "quickbooks_bill_id": "263",
  "multi_invoice_group_id": "bill_5a42935f52394e7097f8959194a68735"
}