Invoice Record

05-12-2026-034-INV-018

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

1533428

Total

$1,788.60

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: 04/15/2025
Due date: 05/15/2025
Vendor terms: Net 10th Prox
Jkath terms: Net 30
QB Bill ID: 375

Category reason

The invoice is from Ferguson Enterprises LLC for a project explicitly named 'Burkhart - Faucet'. The single line item is a lever bridge kitchen faucet (LFA 1.8 2HDL LEV BRIDGE KITC FCT), which is a plumbing fixture. Per the vendor-specific notes, Ferguson invoices for plumbing supplies and fixtures should be categorized as Building Materials (plumbing). The Plumbing category (cat_173f2c1a36d74231bf0b9d9c755c7b0d) maps directly to Building Materials:Plumbing and is the correct match for this faucet purchase.

File result

Final file: FergusonEnterprisesLLC_INV-1533428.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-034-INV-018
Run ID: 05-12-2026-034
Source folder: /_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed
Source file: 737714_20250417_30684918_14232169476.pdf

Stored payloads

Claude parse payload

{
  "tax": 134.4,
  "notes": "Vendor branch/store suffix #1657 omitted from vendor_name per rules. Tax jurisdiction is Dakota County. Customer order number: N 1119 375TH ST. Master account number: 737714. Customer ID: 561627.",
  "terms": "Net 10th Prox",
  "total": 1788.6,
  "due_date": null,
  "shipping": 0,
  "subtotal": 1654.2,
  "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": 1654.2,
      "unit_price": 1654.2,
      "description": "LFA 1.8 2HDL LEV BRIDGE KITC FCT (Item: RU4549HTULB2, Source Order#: 1533408)"
    }
  ],
  "vendor_name": "Ferguson Enterprises LLC",
  "invoice_date": "2025-04-15",
  "project_name": "Burkhart - Faucet",
  "document_type": "invoice",
  "invoice_number": "1533428",
  "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 invoice is from Ferguson Enterprises LLC for a project explicitly named 'Burkhart - Faucet'. The single line item is a lever bridge kitchen faucet (LFA 1.8 2HDL LEV BRIDGE KITC FCT), which is a plumbing fixture. Per the vendor-specific notes, Ferguson invoices for plumbing supplies and fixtures should be categorized as Building Materials (plumbing). The Plumbing category (cat_173f2c1a36d74231bf0b9d9c755c7b0d) maps directly to Building Materials:Plumbing and is the correct match for this faucet purchase.",
    "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": "1788.60",
    "due_date": "2025-05-15",
    "doc_number": "1533428",
    "vendor_ref": "6",
    "account_ref": "113",
    "jkath_terms": "Net 30",
    "vendor_terms": "Net 10th Prox",
    "quickbooks_bill_id": "375",
    "resolved_expense_category_id": "cat_173f2c1a36d74231bf0b9d9c755c7b0d"
  },
  "attachment_uploaded": {
    "path": "multi_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "375"
  }
}

Raw payload

{
  "run_id": "run_9439f1b0f66f4d91979fe2e03399dbfd",
  "source": "make.com",
  "run_key": "05-12-2026-034",
  "make_trace_id": "make-20260512_004507_068",
  "source_file_name": "737714_20250417_30684918_14232169476.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/737714_20250417_30684918_14232169476.pdf",
  "source_dropbox_id": "id:CHX6_xJiKhAAAAAAAABjSg",
  "source_dropbox_rev": "01651985d97ec6700000003549f4393",
  "multi_invoice_count": 1,
  "multi_invoice_index": 1,
  "source_content_hash": "1ce0d83467c1677833f3d84e6c7f988904999552920acbab2e01a304c8c04d68",
  "processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/737714_20250417_30684918_14232169476.pdf",
  "multi_invoice_group_id": "bill_f68100f82ca84369b1bedd25bed77e65",
  "processing_dropbox_rev": "016519872f54a0c00000003549f4393",
  "multi_invoice_source_payload": {
    "notes": "Single invoice PDF. Ferguson Enterprises LLC branch #1657 noted in remit-to address. Job name on invoice listed as 'BURKHART - FAUCET'.",
    "invoices": [
      {
        "tax": 134.4,
        "notes": "Vendor branch/store suffix #1657 omitted from vendor_name per rules. Tax jurisdiction is Dakota County. Customer order number: N 1119 375TH ST. Master account number: 737714. Customer ID: 561627.",
        "terms": "Net 10th Prox",
        "total": 1788.6,
        "due_date": null,
        "shipping": 0,
        "subtotal": 1654.2,
        "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": 1654.2,
            "unit_price": 1654.2,
            "description": "LFA 1.8 2HDL LEV BRIDGE KITC FCT (Item: RU4549HTULB2, Source Order#: 1533408)"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-04-15",
        "project_name": "Burkhart - Faucet",
        "document_type": "invoice",
        "invoice_number": "1533428",
        "is_billable_invoice": true
      }
    ]
  }
}

Invoice Timeline

Time

05/12/2026

Event

FILE CLAIMED

Message

Source file claimed by Make scenario.

Payload

{
  "message": "Claimed invoice file and moved into processing.",
  "source_file_name": "737714_20250417_30684918_14232169476.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/737714_20250417_30684918_14232169476.pdf",
  "processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/737714_20250417_30684918_14232169476.pdf"
}

Time

05/12/2026

Event

PARSE COMPLETED

Message

Claude extraction parsed and stored.

Payload

{
  "total": "1788.60",
  "message": "Claude extraction parsed and stored.",
  "due_date": "2025-05-15",
  "jkath_terms": "Net 30",
  "process_key": "05-12-2026-034-INV-018",
  "vendor_name": "Ferguson Enterprises LLC",
  "claude_model": "claude-sonnet-4-6",
  "input_tokens": "3607",
  "invoice_date": "2025-04-15",
  "vendor_terms": "Net 10th Prox",
  "make_trace_id": "make-20260512_004507_068",
  "output_tokens": "431",
  "bill_import_id": "bill_f68100f82ca84369b1bedd25bed77e65",
  "invoice_number": "1533428",
  "vendor_due_date": null,
  "source_file_name": "737714_20250417_30684918_14232169476.pdf",
  "claude_message_id": "msg_013F9k5W4kixV44qpQfBPz4Y",
  "multi_invoice_count": 1,
  "multi_invoice_index": 1
}

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-018",
  "vendor_name": "Ferguson Enterprises LLC",
  "make_trace_id": "make-20260512_004507_068",
  "bill_import_id": "bill_f68100f82ca84369b1bedd25bed77e65",
  "canonical_name": "Ferguson Enterprises LLC",
  "category_count": 2,
  "invoice_number": "1533428",
  "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_20250417_30684918_14232169476.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-018",
  "vendor_name": "Ferguson Enterprises LLC",
  "category_name": "Plumbing",
  "make_trace_id": "make-20260512_004507_068",
  "bill_import_id": "bill_f68100f82ca84369b1bedd25bed77e65",
  "source_file_name": "737714_20250417_30684918_14232169476.pdf",
  "selection_payload": {
    "reason": "The invoice is from Ferguson Enterprises LLC for a project explicitly named 'Burkhart - Faucet'. The single line item is a lever bridge kitchen faucet (LFA 1.8 2HDL LEV BRIDGE KITC FCT), which is a plumbing fixture. Per the vendor-specific notes, Ferguson invoices for plumbing supplies and fixtures should be categorized as Building Materials (plumbing). The Plumbing category (cat_173f2c1a36d74231bf0b9d9c755c7b0d) maps directly to Building Materials:Plumbing and is the correct match for this faucet purchase.",
    "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/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-018",
  "vendor_name": "Ferguson Enterprises LLC",
  "make_trace_id": "make-20260512_004507_068",
  "bill_import_id": "bill_f68100f82ca84369b1bedd25bed77e65",
  "invoice_number": "1533428",
  "source_file_name": "737714_20250417_30684918_14232169476.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-018",
  "make_trace_id": "make-20260512_004507_068",
  "bill_import_id": "bill_f68100f82ca84369b1bedd25bed77e65",
  "source_file_name": "737714_20250417_30684918_14232169476.pdf",
  "quickbooks_bill_id": "375",
  "quickbooks_payload": {
    "path": "multi_category_direct",
    "total": "1788.60",
    "due_date": "2025-05-15",
    "doc_number": "1533428",
    "vendor_ref": "6",
    "account_ref": "113",
    "jkath_terms": "Net 30",
    "vendor_terms": "Net 10th Prox",
    "quickbooks_bill_id": "375"
  },
  "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-018",
  "make_trace_id": "make-20260512_004507_068",
  "bill_import_id": "bill_f68100f82ca84369b1bedd25bed77e65",
  "source_file_name": "737714_20250417_30684918_14232169476.pdf",
  "attachment_payload": {
    "path": "multi_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "375"
  },
  "quickbooks_bill_id": "375"
}

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-018",
  "make_trace_id": "make-20260512_004507_068",
  "bill_import_id": "bill_f68100f82ca84369b1bedd25bed77e65",
  "final_file_name": "FergusonEnterprisesLLC_INV-1533428.pdf",
  "source_file_name": "737714_20250417_30684918_14232169476.pdf",
  "dropbox_shared_url": "https://www.dropbox.com/scl/fi/1x8l67cr9y1j638cjb852/FergusonEnterprisesLLC_INV-1533428.pdf?rlkey=kp9arqf97008dl8qhtna72c1m&dl=0",
  "quickbooks_bill_id": "375",
  "multi_invoice_group_id": "bill_f68100f82ca84369b1bedd25bed77e65"
}