JkathBusiness Portal

Invoice Record

05-12-2026-037-INV-024

Installed Building Solutions
Back to run

Bill Created Successfully

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

Status

Created in QB

Invoice

J-7384746

Total

$975.00

Invoice data

Matched alias
Installed Building Solutions II
Category
Building Services:Insulation
Category method
Claude category selection
Invoice date
04/30/2025
Due date
05/30/2025
Vendor terms
Not set
Jkath terms
Net 30
QB Bill ID
414

Category reason

The project context explicitly states 'INSULATION', the vendor is 'Installed Building Solutions II' (a known insulation contractor), and the line items reference attic and batt insulation phases. This maps directly to the Insulation category (quickbooks_account_id=131).

File result

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

Processing Context

Invoice ID
05-12-2026-037-INV-024
Run ID
05-12-2026-037
Source folder
/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed
Source file
Installed Bldg Sol.pdf
Stored payloads

Claude parse payload

{
  "tax": 0,
  "notes": "Vendor suffix '(450)' omitted from vendor_name; included in original document. Two line items listed (ATTIC and BATT) but individual amounts per line are not broken out on the invoice; the combined total is $975.00. Line item amounts set to 0 due to no per-line pricing provided. Job address is 5107 Arden Ave, Edina, MN 55424. Customer is J Kath, customer code JKAT01, sales rep Bret Juenke.",
  "terms": null,
  "total": 975,
  "due_date": null,
  "shipping": 0,
  "subtotal": 975,
  "confidence": {
    "total": 0.97,
    "vendor_name": 0.95,
    "invoice_date": 0.99,
    "project_name": 0.99,
    "invoice_number": 0.99
  },
  "line_items": [
    {
      "qty": null,
      "amount": 0,
      "unit_price": null,
      "description": "5107 Arden Ave - ATTIC (Phase 18523984)"
    },
    {
      "qty": null,
      "amount": 0,
      "unit_price": null,
      "description": "5107 Arden Ave - BATT (Phase 18524030)"
    }
  ],
  "vendor_name": "Installed Building Solutions II",
  "invoice_date": "2025-04-30",
  "project_name": "5107 Arden Ave - INSULATION",
  "document_type": "invoice",
  "invoice_number": "J-7384746",
  "is_billable_invoice": true
}

Vendor match payload

{
  "alias_lookup": {
    "found": true,
    "alias_id": "alias_1df640577351457383354b8c3d75994b",
    "vendor_id": "vend_21a716507cf54e9383fae2756da68d89",
    "alias_name": "Installed Building Solutions II",
    "canonical_name": "Installed Building Solutions",
    "category_count": 2,
    "category_options": [
      {
        "name": "Cabinet Materials",
        "notes": "Mapped from JKath historical QuickBooks export: Building Materials:Cabinet Materials (1).",
        "expense_category_id": "cat_8d2d70e75bdd439fb2060c07463e1a62",
        "fully_qualified_name": "Building Materials:Cabinet Materials",
        "quickbooks_account_id": "105",
        "vendor_expense_category_id": "cmp1bavlg001s13pfkvnygjqk"
      },
      {
        "name": "Insulation",
        "notes": "Mapped from JKath historical QuickBooks export: Building Services:Insulation (11).",
        "expense_category_id": "cat_aaaf5d30b249460183ffa2582b6e3767",
        "fully_qualified_name": "Building Services:Insulation",
        "quickbooks_account_id": "131",
        "vendor_expense_category_id": "cmp1bavo0001u13pf80lfv3eq"
      }
    ],
    "expense_category_id": null,
    "normalized_alias_key": "installed building solutions ii",
    "quickbooks_vendor_id": "70",
    "quickbooks_account_id": null,
    "default_expense_account": null,
    "invoice_processing_notes": null,
    "missing_category_options": false
  },
  "category_selection": {
    "reason": "The project context explicitly states 'INSULATION', the vendor is 'Installed Building Solutions II' (a known insulation contractor), and the line items reference attic and batt insulation phases. This maps directly to the Insulation category (quickbooks_account_id=131).",
    "confidence": 0.99,
    "category_name": "Insulation",
    "expense_category_id": "cat_aaaf5d30b249460183ffa2582b6e3767",
    "quickbooks_account_id": "131",
    "selected_expense_category_id": "cat_aaaf5d30b249460183ffa2582b6e3767",
    "selected_expense_category_name": "Insulation"
  }
}

QB payload

{
  "lookup": {
    "quickbooks_vendor_id": "70",
    "quickbooks_account_id": "131",
    "existing_quickbooks_bill_id": null
  },
  "bill_created": {
    "path": "multi_category_direct",
    "total": "975.00",
    "due_date": "2025-05-30",
    "doc_number": "J-7384746",
    "vendor_ref": "70",
    "account_ref": "131",
    "jkath_terms": "Net 30",
    "vendor_terms": "",
    "quickbooks_bill_id": "414",
    "resolved_expense_category_id": "cat_aaaf5d30b249460183ffa2582b6e3767"
  },
  "attachment_uploaded": {
    "path": "multi_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "414"
  }
}

Raw payload

{
  "run_id": "run_d117948ad0ec46ec87f05b9be67f78c8",
  "source": "make.com",
  "run_key": "05-12-2026-037",
  "make_trace_id": "make-20260512_020557_528",
  "source_file_name": "Installed Bldg Sol.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/Installed Bldg Sol.pdf",
  "source_dropbox_id": "id:CHX6_xJiKhAAAAAAAABg9A",
  "source_dropbox_rev": "01651997e8bb04600000003549f4393",
  "multi_invoice_count": 1,
  "multi_invoice_index": 1,
  "source_content_hash": "e38db317fd36ee382177391ee72890bf0279bae24e2b3063258a73fd9cc86882",
  "processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/Installed Bldg Sol.pdf",
  "multi_invoice_group_id": "bill_43045263c9c34cdb8d4a8c2137504231",
  "processing_dropbox_rev": "016519996411ca800000003549f4393",
  "multi_invoice_source_payload": {
    "notes": "Single invoice PDF. Vendor branch/account suffix '(450)' noted in document header but omitted from vendor_name per rules. Individual line item amounts are not itemized; only a combined total of $975.00 is shown.",
    "invoices": [
      {
        "tax": 0,
        "notes": "Vendor suffix '(450)' omitted from vendor_name; included in original document. Two line items listed (ATTIC and BATT) but individual amounts per line are not broken out on the invoice; the combined total is $975.00. Line item amounts set to 0 due to no per-line pricing provided. Job address is 5107 Arden Ave, Edina, MN 55424. Customer is J Kath, customer code JKAT01, sales rep Bret Juenke.",
        "terms": null,
        "total": 975,
        "due_date": null,
        "shipping": 0,
        "subtotal": 975,
        "confidence": {
          "total": 0.97,
          "vendor_name": 0.95,
          "invoice_date": 0.99,
          "project_name": 0.99,
          "invoice_number": 0.99
        },
        "line_items": [
          {
            "qty": null,
            "amount": 0,
            "unit_price": null,
            "description": "5107 Arden Ave - ATTIC (Phase 18523984)"
          },
          {
            "qty": null,
            "amount": 0,
            "unit_price": null,
            "description": "5107 Arden Ave - BATT (Phase 18524030)"
          }
        ],
        "vendor_name": "Installed Building Solutions II",
        "invoice_date": "2025-04-30",
        "project_name": "5107 Arden Ave - INSULATION",
        "document_type": "invoice",
        "invoice_number": "J-7384746",
        "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": "Installed Bldg Sol.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/Installed Bldg Sol.pdf",
  "processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/Installed Bldg Sol.pdf"
}

Time

05/12/2026

Event

PARSE COMPLETED

Message

Claude extraction parsed and stored.

Payload
{
  "total": "975.00",
  "message": "Claude extraction parsed and stored.",
  "due_date": "2025-05-30",
  "jkath_terms": "Net 30",
  "process_key": "05-12-2026-037-INV-024",
  "vendor_name": "Installed Building Solutions II",
  "claude_model": "claude-sonnet-4-6",
  "input_tokens": "3338",
  "invoice_date": "2025-04-30",
  "vendor_terms": null,
  "make_trace_id": "make-20260512_020557_528",
  "output_tokens": "524",
  "bill_import_id": "bill_43045263c9c34cdb8d4a8c2137504231",
  "invoice_number": "J-7384746",
  "vendor_due_date": null,
  "source_file_name": "Installed Bldg Sol.pdf",
  "claude_message_id": "msg_01BZPRxgWQ3ZXYV1DnXyF4BX",
  "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_1df640577351457383354b8c3d75994b",
  "vendor_id": "vend_21a716507cf54e9383fae2756da68d89",
  "process_key": "05-12-2026-037-INV-024",
  "vendor_name": "Installed Building Solutions II",
  "make_trace_id": "make-20260512_020557_528",
  "bill_import_id": "bill_43045263c9c34cdb8d4a8c2137504231",
  "canonical_name": "Installed Building Solutions",
  "category_count": 2,
  "invoice_number": "J-7384746",
  "category_options": [
    {
      "name": "Cabinet Materials",
      "notes": "Mapped from JKath historical QuickBooks export: Building Materials:Cabinet Materials (1).",
      "expense_category_id": "cat_8d2d70e75bdd439fb2060c07463e1a62",
      "fully_qualified_name": "Building Materials:Cabinet Materials",
      "quickbooks_account_id": "105",
      "vendor_expense_category_id": "cmp1bavlg001s13pfkvnygjqk"
    },
    {
      "name": "Insulation",
      "notes": "Mapped from JKath historical QuickBooks export: Building Services:Insulation (11).",
      "expense_category_id": "cat_aaaf5d30b249460183ffa2582b6e3767",
      "fully_qualified_name": "Building Services:Insulation",
      "quickbooks_account_id": "131",
      "vendor_expense_category_id": "cmp1bavo0001u13pf80lfv3eq"
    }
  ],
  "source_file_name": "Installed Bldg Sol.pdf",
  "expense_category_id": null,
  "normalized_alias_key": "installed building solutions ii",
  "quickbooks_vendor_id": "70",
  "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-037-INV-024",
  "vendor_name": "Installed Building Solutions",
  "category_name": "Insulation",
  "make_trace_id": "make-20260512_020557_528",
  "bill_import_id": "bill_43045263c9c34cdb8d4a8c2137504231",
  "source_file_name": "Installed Bldg Sol.pdf",
  "selection_payload": {
    "reason": "The project context explicitly states 'INSULATION', the vendor is 'Installed Building Solutions II' (a known insulation contractor), and the line items reference attic and batt insulation phases. This maps directly to the Insulation category (quickbooks_account_id=131).",
    "confidence": 0.99,
    "selected_expense_category_id": "cat_aaaf5d30b249460183ffa2582b6e3767",
    "selected_expense_category_name": "Insulation"
  },
  "expense_category_id": "cat_aaaf5d30b249460183ffa2582b6e3767",
  "quickbooks_account_id": "131"
}

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-037-INV-024",
  "vendor_name": "Installed Building Solutions",
  "make_trace_id": "make-20260512_020557_528",
  "bill_import_id": "bill_43045263c9c34cdb8d4a8c2137504231",
  "invoice_number": "J-7384746",
  "source_file_name": "Installed Bldg Sol.pdf",
  "quickbooks_vendor_id": "70",
  "quickbooks_account_id": "131",
  "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-037-INV-024",
  "make_trace_id": "make-20260512_020557_528",
  "bill_import_id": "bill_43045263c9c34cdb8d4a8c2137504231",
  "source_file_name": "Installed Bldg Sol.pdf",
  "quickbooks_bill_id": "414",
  "quickbooks_payload": {
    "path": "multi_category_direct",
    "total": "975.00",
    "due_date": "2025-05-30",
    "doc_number": "J-7384746",
    "vendor_ref": "70",
    "account_ref": "131",
    "jkath_terms": "Net 30",
    "vendor_terms": "",
    "quickbooks_bill_id": "414"
  },
  "quickbooks_account_id": "131",
  "resolved_expense_category_id": "cat_aaaf5d30b249460183ffa2582b6e3767"
}

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-037-INV-024",
  "make_trace_id": "make-20260512_020557_528",
  "bill_import_id": "bill_43045263c9c34cdb8d4a8c2137504231",
  "source_file_name": "Installed Bldg Sol.pdf",
  "attachment_payload": {
    "path": "multi_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "414"
  },
  "quickbooks_bill_id": "414"
}

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-037-INV-024",
  "make_trace_id": "make-20260512_020557_528",
  "bill_import_id": "bill_43045263c9c34cdb8d4a8c2137504231",
  "final_file_name": "InstalledBuildingSolutions_INV-J-7384746.pdf",
  "source_file_name": "Installed Bldg Sol.pdf",
  "dropbox_shared_url": "https://www.dropbox.com/scl/fi/tlyfc66t9kgzthgvdzbwd/InstalledBuildingSolutions_INV-J-7384746.pdf?rlkey=nyzen1xhj5ertbiqbwbu5g41j&dl=0",
  "quickbooks_bill_id": "414",
  "multi_invoice_group_id": "bill_43045263c9c34cdb8d4a8c2137504231"
}