JkathBusiness Portal

Invoice Record

05-12-2026-050-INV-001

Blue Water Plumbing
Back to bill imports

Invoice Error

Make scenario ended before finalizing this run; stale RUNNING run marked failed during cleanup.

Status

Error

Invoice

110463160

Total

$3,740.00

Invoice data

Detected vendor
Blue Water Plumbing
Matched vendor
Blue Water Plumbing
Matched alias
Blue Water Plumbing
Category
Building Services:Plumbing
Category method
single assignable category after resolver
Invoice date
02/18/2025
Due date
03/20/2025
Vendor terms
Net 30
Jkath terms
Net 30
QB Transaction ID
Not created

Category reason

Resolver matched the vendor, and the vendor has exactly one assignable expense category.

File result

Final file
Not finalized
Outcome
failed
Details
Make scenario ended before finalizing this run; stale RUNNING run marked failed during cleanup.

Processing Context

Invoice ID
05-12-2026-050-INV-001
Run ID
05-12-2026-050
Source folder
/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed
Source file
Blue Water Plumbing Invoice 110463160.pdf
Stored payloads

Claude parse payload

{
  "tax": 0,
  "notes": "Vendor normalized to matched portal display name 'Blue Water Plumbing'. Bill to contact is Jesse Kath / Jkath Design. Ship to and project address both listed as 15890 York Circle NW, Anoka, MN 55303. No separate tax or shipping; subtotal equals sum of line items equals total.",
  "terms": "Net 30",
  "total": 3740,
  "due_date": "2025-03-20",
  "shipping": 0,
  "subtotal": 3740,
  "confidence": {
    "total": 1,
    "vendor_name": 0.97,
    "invoice_date": 1,
    "project_name": 0.95,
    "invoice_number": 1
  },
  "line_items": [
    {
      "qty": null,
      "amount": 3660,
      "unit_price": null,
      "description": "Pipe, fittings, misc material and labor to complete (Kitchen: leave existing sink plumbing for new prep sink, add new plumbing in island for main sink; Powder Bath: update lines for new sink, toilet rough in to remain; Hall Bathroom: update bathroom, set new tub and valve, new shut off valves for sink and toilet, set new fixtures; Laundry Room: update lines for new sink and faucet, rough in to remain in same location; Master Bath: update lines for new master tub and faucet, loop water lines for mixing valve, new tile drain and shower faucet, new shut off valves for sink and toilets)"
    },
    {
      "qty": null,
      "amount": 80,
      "unit_price": null,
      "description": "Permit allowance"
    }
  ],
  "vendor_name": "Blue Water Plumbing",
  "invoice_date": "2025-02-18",
  "project_name": "15890 York Circle NW",
  "document_type": "invoice",
  "invoice_number": "110463160",
  "is_billable_invoice": true
}

Vendor match payload

{
  "resolver": {
    "reason": "The extracted vendor 'Blue Water Plumbing' is an exact match to the approved vendor 'Blue Water Plumbing', confirmed by the full company name 'Blue Water Plumbing Inc' on the invoice, matching address, phone, and email details.",
    "matched": "true",
    "alias_id": "alias_89d34e6a1414417db643932bf46650db",
    "vendor_id": "vend_3c6ffab81af143d3a55b596f928ca6f6",
    "confidence": 0.99,
    "category_count": 1,
    "suggested_alias": "Blue Water Plumbing",
    "category_options": [
      {
        "name": "Plumbing",
        "notes": "Mapped from JKath historical QuickBooks export: Building Services:Plumbing (2).",
        "expense_category_id": "cat_f04b0af5b00a42c3a31351bad4d75f5d",
        "fully_qualified_name": "Building Services:Plumbing",
        "quickbooks_account_id": "136",
        "vendor_expense_category_id": "cmp1bb26b005e13pfr3kx7r2b"
      }
    ],
    "canonical_vendor_name": "Blue Water Plumbing",
    "default_expense_account": "Subcontractors"
  },
  "alias_lookup": {
    "found": false,
    "vendor_name": "Blue Water Plumbing",
    "normalized_alias_key": "blue water plumbing"
  },
  "category_selection": {
    "method": "single_assignable_category_after_resolver",
    "reason": "Resolver matched the vendor, and the vendor has exactly one assignable expense category.",
    "confidence": 1,
    "category_name": "Plumbing",
    "expense_category_id": "cat_f04b0af5b00a42c3a31351bad4d75f5d",
    "quickbooks_account_id": "136"
  }
}

QB payload

No payload stored.

Raw payload

{
  "run_id": "run_e3fc33806f8c484fa47b8866e8eb3f36",
  "source": "make.com",
  "run_key": "05-12-2026-050",
  "run_error": {
    "source": "manual_stale_run_cleanup",
    "message": "Make scenario ended before finalizing this run; stale RUNNING run marked failed during cleanup.",
    "run_key": "05-12-2026-050",
    "recorded_at": "2026-05-13T00:37:59.275103+00:00"
  },
  "make_trace_id": "make-20260512_143650_173",
  "source_file_name": "Blue Water Plumbing Invoice 110463160.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/Blue Water Plumbing Invoice 110463160.pdf",
  "source_dropbox_id": "id:CHX6_xJiKhAAAAAAAABg3g",
  "source_dropbox_rev": "01651a3f9dda3dc00000003549f4393",
  "multi_invoice_count": 1,
  "multi_invoice_index": 1,
  "source_content_hash": "8466de9677c80719036890ea8f943711790d1b667470ce0a5cc30c0652bcd33d",
  "processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/Blue Water Plumbing Invoice 110463160.pdf",
  "multi_invoice_group_id": "bill_d8011af1a80a4c97ac0d67bcaae83a27",
  "processing_dropbox_rev": "01651a3fc2a83fd00000003549f4393",
  "multi_invoice_source_payload": {
    "notes": "Single invoice PDF. Vendor matched to portal as 'Blue Water Plumbing' (QuickBooks vendor id: 40). Invoice covers plumbing updates across five areas: Kitchen, Powder Bath, Hall Bathroom, Laundry Room, and Master Bath.",
    "invoices": [
      {
        "tax": 0,
        "notes": "Vendor normalized to matched portal display name 'Blue Water Plumbing'. Bill to contact is Jesse Kath / Jkath Design. Ship to and project address both listed as 15890 York Circle NW, Anoka, MN 55303. No separate tax or shipping; subtotal equals sum of line items equals total.",
        "terms": "Net 30",
        "total": 3740,
        "due_date": "2025-03-20",
        "shipping": 0,
        "subtotal": 3740,
        "confidence": {
          "total": 1,
          "vendor_name": 0.97,
          "invoice_date": 1,
          "project_name": 0.95,
          "invoice_number": 1
        },
        "line_items": [
          {
            "qty": null,
            "amount": 3660,
            "unit_price": null,
            "description": "Pipe, fittings, misc material and labor to complete (Kitchen: leave existing sink plumbing for new prep sink, add new plumbing in island for main sink; Powder Bath: update lines for new sink, toilet rough in to remain; Hall Bathroom: update bathroom, set new tub and valve, new shut off valves for sink and toilet, set new fixtures; Laundry Room: update lines for new sink and faucet, rough in to remain in same location; Master Bath: update lines for new master tub and faucet, loop water lines for mixing valve, new tile drain and shower faucet, new shut off valves for sink and toilets)"
          },
          {
            "qty": null,
            "amount": 80,
            "unit_price": null,
            "description": "Permit allowance"
          }
        ],
        "vendor_name": "Blue Water Plumbing",
        "invoice_date": "2025-02-18",
        "project_name": "15890 York Circle NW",
        "document_type": "invoice",
        "invoice_number": "110463160",
        "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": "Blue Water Plumbing Invoice 110463160.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/Blue Water Plumbing Invoice 110463160.pdf",
  "processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/Blue Water Plumbing Invoice 110463160.pdf"
}

Time

05/12/2026

Event

ALIAS LOOKUP COMPLETED

Message

Vendor alias lookup matched a portal vendor.

Payload
{
  "found": true,
  "phase": "early_vendor_resolution",
  "message": "Early vendor lookup before full invoice extraction.",
  "alias_id": "cmp1abk2m008magtbb4qdutip",
  "vendor_id": "vend_3c6ffab81af143d3a55b596f928ca6f6",
  "process_key": "05-12-2026-050-INV-001",
  "vendor_name": "Blue Water Plumbing Inc",
  "make_trace_id": "make-20260512_143650_173",
  "bill_import_id": "bill_d8011af1a80a4c97ac0d67bcaae83a27",
  "canonical_name": "Blue Water Plumbing",
  "category_count": 1,
  "category_options": [
    {
      "name": "Plumbing",
      "notes": "Mapped from JKath historical QuickBooks export: Building Services:Plumbing (2).",
      "expense_category_id": "cat_f04b0af5b00a42c3a31351bad4d75f5d",
      "fully_qualified_name": "Building Services:Plumbing",
      "quickbooks_account_id": "136",
      "vendor_expense_category_id": "cmp1bb26b005e13pfr3kx7r2b"
    }
  ],
  "source_file_name": "Blue Water Plumbing Invoice 110463160.pdf",
  "category_selection": {
    "method": "single_assignable_category",
    "reason": "Vendor has exactly one assignable expense category, so the category was assigned without a Claude category-selection call.",
    "confidence": 1,
    "category_name": "Plumbing",
    "expense_category_id": "cat_f04b0af5b00a42c3a31351bad4d75f5d",
    "quickbooks_account_id": "136",
    "selected_expense_category_id": "cat_f04b0af5b00a42c3a31351bad4d75f5d",
    "selected_expense_category_name": "Plumbing"
  },
  "expense_category_id": "cat_f04b0af5b00a42c3a31351bad4d75f5d",
  "normalized_alias_key": "blue water plumbing inc",
  "quickbooks_vendor_id": "40",
  "default_expense_account": "Plumbing",
  "preliminary_vendor_name": "Blue Water Plumbing Inc",
  "missing_category_options": false,
  "preliminary_vendor_notes": "Vendor name clearly stated in the header and logo of the invoice.",
  "preliminary_vendor_confidence": "0.99"
}

Time

05/12/2026

Event

PARSE COMPLETED

Message

Claude extraction parsed and stored.

Payload
{
  "total": "3740.00",
  "message": "Claude extraction parsed and stored.",
  "due_date": "2025-03-20",
  "jkath_terms": "Net 30",
  "process_key": "05-12-2026-050-INV-001",
  "vendor_name": "Blue Water Plumbing",
  "claude_model": "claude-sonnet-4-6",
  "input_tokens": "3722",
  "invoice_date": "2025-02-18",
  "vendor_terms": "Net 30",
  "make_trace_id": "make-20260512_143650_173",
  "output_tokens": "617",
  "bill_import_id": "bill_d8011af1a80a4c97ac0d67bcaae83a27",
  "invoice_number": "110463160",
  "vendor_due_date": "2025-03-20",
  "source_file_name": "Blue Water Plumbing Invoice 110463160.pdf",
  "claude_message_id": "msg_01Akcn2EXPcDcPM9kCUzbiuX",
  "multi_invoice_count": 1,
  "multi_invoice_index": 1
}

Time

05/12/2026

Event

ALIAS LOOKUP COMPLETED

Message

Vendor alias lookup did not match a portal vendor.

Payload
{
  "found": false,
  "message": "Looked up parsed vendor name against portal aliases.",
  "alias_id": null,
  "vendor_id": null,
  "process_key": "05-12-2026-050-INV-001",
  "vendor_name": "Blue Water Plumbing",
  "make_trace_id": "make-20260512_143650_173",
  "bill_import_id": "bill_d8011af1a80a4c97ac0d67bcaae83a27",
  "canonical_name": null,
  "category_count": 0,
  "invoice_number": "110463160",
  "category_options": [],
  "source_file_name": "Blue Water Plumbing Invoice 110463160.pdf",
  "expense_category_id": null,
  "normalized_alias_key": "blue water plumbing",
  "quickbooks_vendor_id": null,
  "default_expense_account": null,
  "missing_category_options": false
}

Time

05/12/2026

Event

RESOLVER COMPLETED

Message

Vendor resolver matched a portal vendor.

Payload
{
  "reason": "The extracted vendor 'Blue Water Plumbing' is an exact match to the approved vendor 'Blue Water Plumbing', confirmed by the full company name 'Blue Water Plumbing Inc' on the invoice, matching address, phone, and email details.",
  "message": "Vendor resolver matched a portal vendor and alias was recorded.",
  "alias_id": "alias_89d34e6a1414417db643932bf46650db",
  "vendor_id": "vend_3c6ffab81af143d3a55b596f928ca6f6",
  "confidence": 0.99,
  "process_key": "05-12-2026-050-INV-001",
  "make_trace_id": "make-20260512_143650_173",
  "bill_import_id": "bill_d8011af1a80a4c97ac0d67bcaae83a27",
  "category_count": 1,
  "suggested_alias": "Blue Water Plumbing",
  "category_options": [
    {
      "name": "Plumbing",
      "notes": "Mapped from JKath historical QuickBooks export: Building Services:Plumbing (2).",
      "expense_category_id": "cat_f04b0af5b00a42c3a31351bad4d75f5d",
      "fully_qualified_name": "Building Services:Plumbing",
      "quickbooks_account_id": "136",
      "vendor_expense_category_id": "cmp1bb26b005e13pfr3kx7r2b"
    }
  ],
  "resolver_payload": {
    "reason": "The extracted vendor 'Blue Water Plumbing' is an exact match to the approved vendor 'Blue Water Plumbing', confirmed by the full company name 'Blue Water Plumbing Inc' on the invoice, matching address, phone, and email details.",
    "matched": "true",
    "confidence": "0.99",
    "suggested_alias": "Blue Water Plumbing",
    "canonical_vendor_name": "Blue Water Plumbing",
    "default_expense_account": "Subcontractors"
  },
  "source_file_name": "Blue Water Plumbing Invoice 110463160.pdf",
  "canonical_vendor_name": "Blue Water Plumbing",
  "extracted_vendor_name": "Blue Water Plumbing"
}

Time

05/12/2026

Event

FAILED

Message

Make scenario ended before finalizing this run; stale RUNNING run marked failed during cleanup.

Payload
{
  "run_id": "run_e3fc33806f8c484fa47b8866e8eb3f36",
  "source": "mark_bill_import_run_failed",
  "run_key": "05-12-2026-050",
  "recorded_at": "2026-05-13T00:37:59.275103+00:00"
}