Bill Created Successfully
QuickBooks Bill created successfully. Source file attached to the Bill.
Status
Created in QB
Invoice
1527277
Total
$79.01
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/10/2025
- Due date
- 05/10/2025
- Vendor terms
- Net 10th Prox
- Jkath terms
- Net 30
- QB Bill ID
- 364
Category reason
The single line item is 'WHIT PVC S40 L&T W&O' (item W901LTPVCWH), which is a PVC Schedule 40 pipe fitting — a standard plumbing supply. Ferguson vendor notes direct plumbing supplies to Building Materials, and among the allowed categories, Plumbing (quickbooks_account_id=113) is the correct match for PVC pipe/fittings used on a construction project.
File result
- Final file
- FergusonEnterprisesLLC_INV-1530865.pdf
- Outcome
- processed
- Details
- QuickBooks Bill created successfully. Source file attached to the Bill.
Processing Context
- Invoice ID
- 05-12-2026-034-INV-005
- 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": 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
}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 single line item is 'WHIT PVC S40 L&T W&O' (item W901LTPVCWH), which is a PVC Schedule 40 pipe fitting — a standard plumbing supply. Ferguson vendor notes direct plumbing supplies to Building Materials, and among the allowed categories, Plumbing (quickbooks_account_id=113) is the correct match for PVC pipe/fittings used on a construction project.",
"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": "79.01",
"due_date": "2025-05-10",
"doc_number": "1527277",
"vendor_ref": "6",
"account_ref": "113",
"jkath_terms": "Net 30",
"vendor_terms": "Net 10th Prox",
"quickbooks_bill_id": "364",
"resolved_expense_category_id": "cat_173f2c1a36d74231bf0b9d9c755c7b0d"
},
"attachment_uploaded": {
"path": "multi_category_direct",
"file_name": "",
"attachment_id": "",
"quickbooks_bill_id": "364"
}
}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": "Ferguson - only enter Lakeview invoice NOT York (credit coming).pdf",
"source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/Ferguson - only enter Lakeview invoice NOT York (credit coming).pdf",
"source_dropbox_id": "id:CHX6_xJiKhAAAAAAAABjWQ",
"source_dropbox_rev": "01651985d8301a900000003549f4393",
"multi_invoice_count": 2,
"multi_invoice_index": 1,
"source_content_hash": "d696baddb7cb3e61edcfad522c99e79f443a52e50b77473ab589148fedcb65c5",
"processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/Ferguson - only enter Lakeview invoice NOT York (credit coming).pdf",
"multi_invoice_group_id": "bill_d66a1eac7439444a9ee78f4c949c5dce",
"processing_dropbox_rev": "0165198622b640000000003549f4393",
"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
FILE CLAIMED
Message
Source file claimed by Make scenario.
Payload
{
"message": "Claimed invoice file and moved into processing.",
"source_file_name": "Ferguson - only enter Lakeview invoice NOT York (credit coming).pdf",
"source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/Ferguson - only enter Lakeview invoice NOT York (credit coming).pdf",
"processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/Ferguson - only enter Lakeview invoice NOT York (credit coming).pdf"
}Time
05/12/2026
Event
PARSE COMPLETED
Message
Claude extraction parsed and stored from a multi-invoice PDF.
Payload
{
"total": "79.01",
"message": "Claude extraction parsed and stored.",
"due_date": "2025-05-10",
"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-10",
"vendor_terms": "Net 10th Prox",
"make_trace_id": "make-20260512_004507_068",
"output_tokens": "856",
"bill_import_id": "bill_d66a1eac7439444a9ee78f4c949c5dce",
"invoice_number": "1527277",
"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": 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-005",
"vendor_name": "Ferguson Enterprises LLC",
"make_trace_id": "make-20260512_004507_068",
"bill_import_id": "bill_d66a1eac7439444a9ee78f4c949c5dce",
"canonical_name": "Ferguson Enterprises LLC",
"category_count": 2,
"invoice_number": "1527277",
"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",
"vendor_name": "Ferguson Enterprises LLC",
"category_name": "Plumbing",
"make_trace_id": "make-20260512_004507_068",
"bill_import_id": "bill_d66a1eac7439444a9ee78f4c949c5dce",
"source_file_name": "Ferguson - only enter Lakeview invoice NOT York (credit coming).pdf",
"selection_payload": {
"reason": "The single line item is 'WHIT PVC S40 L&T W&O' (item W901LTPVCWH), which is a PVC Schedule 40 pipe fitting — a standard plumbing supply. Ferguson vendor notes direct plumbing supplies to Building Materials, and among the allowed categories, Plumbing (quickbooks_account_id=113) is the correct match for PVC pipe/fittings used on a construction project.",
"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-005",
"vendor_name": "Ferguson Enterprises LLC",
"make_trace_id": "make-20260512_004507_068",
"bill_import_id": "bill_d66a1eac7439444a9ee78f4c949c5dce",
"invoice_number": "1527277",
"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",
"make_trace_id": "make-20260512_004507_068",
"bill_import_id": "bill_d66a1eac7439444a9ee78f4c949c5dce",
"source_file_name": "Ferguson - only enter Lakeview invoice NOT York (credit coming).pdf",
"quickbooks_bill_id": "364",
"quickbooks_payload": {
"path": "multi_category_direct",
"total": "79.01",
"due_date": "2025-05-10",
"doc_number": "1527277",
"vendor_ref": "6",
"account_ref": "113",
"jkath_terms": "Net 30",
"vendor_terms": "Net 10th Prox",
"quickbooks_bill_id": "364"
},
"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",
"make_trace_id": "make-20260512_004507_068",
"bill_import_id": "bill_d66a1eac7439444a9ee78f4c949c5dce",
"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": "364"
},
"quickbooks_bill_id": "364"
}