Invoice Record

05-12-2026-030-INV-006

Horizon Electric

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

J-7207638

Total

$2,676.00

Invoice data

Detected vendor: Horizon Electric
Matched vendor: Horizon Electric
Matched alias: Horizon Electric
Category: Building Services:Electrical
Category method: Claude category selection
Invoice date: 03/25/2025
Due date: 04/24/2025
Vendor terms: Not set
Jkath terms: Net 30
QB Bill ID: 348

Category reason

The vendor is Horizon Electric, an electrical contractor, and the invoice is for a final draw on a construction phase at 8701 Bentwood Drive, Eden Prairie. The only allowed category is Electrical, which directly matches the vendor type and scope of work.

File result

Final file: HorizonElectric_INV-J-7207638.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-030-INV-006
Run ID: 05-12-2026-030
Source folder: /_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed
Source file: Horizon Electric 8701 Bentwood Drive, Eden Prairie.pdf

Stored payloads

Claude parse payload

{
  "tax": 0,
  "notes": "This is a 'Job Invoice To Date' statement showing two phases. The first phase (Rough in draw, $4,971.00, dated 12/31/2024) has a $0.00 balance due (already credited/paid). Only the Final Draw phase ($2,676.00, dated 03/25/2025) is currently unpaid and constitutes the Amount Due. Total contract bid was $7,647.00. Only the unpaid Final Draw line item is included in line_items to avoid double-counting.",
  "terms": null,
  "total": 2676,
  "due_date": null,
  "shipping": 0,
  "subtotal": 2676,
  "confidence": {
    "total": 0.99,
    "vendor_name": 0.97,
    "invoice_date": 0.99,
    "project_name": 0.99,
    "invoice_number": 0.99
  },
  "line_items": [
    {
      "qty": null,
      "amount": 2676,
      "unit_price": null,
      "description": "8701 Bentwood Drive, Final Draw (Phase 18375342)"
    }
  ],
  "vendor_name": "Horizon Electric",
  "invoice_date": "2025-03-25",
  "project_name": "8701 Bentwood Drive, Eden Prairie",
  "document_type": "invoice",
  "invoice_number": "J-7207638",
  "is_billable_invoice": true
}

Vendor match payload

{
  "resolver": {
    "reason": "The extracted vendor name 'Horizon Electric' is an exact match to the approved vendor 'Horizon Electric' in the approved vendor list.",
    "matched": "true",
    "alias_id": "alias_7e6b45063c154db19996874e958a7f8b",
    "vendor_id": "vend_2ba32f9db9004b9c9bc282acdb08c29b",
    "confidence": 1,
    "category_count": 1,
    "suggested_alias": "Horizon Electric",
    "category_options": [
      {
        "name": "Electrical",
        "notes": "Mapped from JKath historical QuickBooks export: Building Services:Electrical (6).",
        "expense_category_id": "cat_ffcb7c9c5585409ba42ca033f3420f00",
        "fully_qualified_name": "Building Services:Electrical",
        "quickbooks_account_id": "124",
        "vendor_expense_category_id": "cmp1bb03z004c13pfptbcroj2"
      }
    ],
    "canonical_vendor_name": "Horizon Electric",
    "default_expense_account": "Subcontractors"
  },
  "alias_lookup": {
    "found": false,
    "vendor_name": "Horizon Electric",
    "normalized_alias_key": "horizon electric"
  },
  "category_selection": {
    "reason": "The vendor is Horizon Electric, an electrical contractor, and the invoice is for a final draw on a construction phase at 8701 Bentwood Drive, Eden Prairie. The only allowed category is Electrical, which directly matches the vendor type and scope of work.",
    "confidence": 0.99,
    "category_name": "Electrical",
    "expense_category_id": "cat_ffcb7c9c5585409ba42ca033f3420f00",
    "quickbooks_account_id": "124",
    "selected_expense_category_id": "cat_ffcb7c9c5585409ba42ca033f3420f00",
    "selected_expense_category_name": "Electrical"
  }
}

QB payload

{
  "bill_created": {
    "path": "resolver_success",
    "total": "2676.00",
    "due_date": "2025-04-24",
    "doc_number": "J-7207638",
    "vendor_ref": "81",
    "account_ref": "124",
    "jkath_terms": "Net 30",
    "vendor_terms": "",
    "quickbooks_bill_id": "348",
    "resolved_expense_category_id": "cat_ffcb7c9c5585409ba42ca033f3420f00"
  },
  "attachment_uploaded": {
    "path": "resolver_success",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "348"
  }
}

Raw payload

{
  "run_id": "run_dd32242617bc4ddfa5672d1b4634d912",
  "source": "make.com",
  "run_key": "05-12-2026-030",
  "make_trace_id": "make-20260512_001839_243",
  "source_file_name": "Horizon Electric 8701 Bentwood Drive, Eden Prairie.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/Horizon Electric 8701 Bentwood Drive, Eden Prairie.pdf",
  "source_dropbox_id": "id:CHX6_xJiKhAAAAAAAABimA",
  "source_dropbox_rev": "0165197fdc101d500000003549f4393",
  "multi_invoice_count": 1,
  "multi_invoice_index": 1,
  "source_content_hash": "3466c3286622e67a0e387d843549a97d347ab48200cc707ed006fbd298ed6631",
  "processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/Horizon Electric 8701 Bentwood Drive, Eden Prairie.pdf",
  "multi_invoice_group_id": "bill_2be3c932b8074c939440bfd85e993e4f",
  "processing_dropbox_rev": "01651980451c35d00000003549f4393",
  "multi_invoice_source_payload": {
    "notes": "PDF contains a single 'Job Invoice To Date' document (Ref # J-7207638) from Horizon Electric for job at 8701 Bentwood Drive, Eden Prairie. The document shows cumulative job history with two phases; only the Final Draw phase is currently outstanding at $2,676.00.",
    "invoices": [
      {
        "tax": 0,
        "notes": "This is a 'Job Invoice To Date' statement showing two phases. The first phase (Rough in draw, $4,971.00, dated 12/31/2024) has a $0.00 balance due (already credited/paid). Only the Final Draw phase ($2,676.00, dated 03/25/2025) is currently unpaid and constitutes the Amount Due. Total contract bid was $7,647.00. Only the unpaid Final Draw line item is included in line_items to avoid double-counting.",
        "terms": null,
        "total": 2676,
        "due_date": null,
        "shipping": 0,
        "subtotal": 2676,
        "confidence": {
          "total": 0.99,
          "vendor_name": 0.97,
          "invoice_date": 0.99,
          "project_name": 0.99,
          "invoice_number": 0.99
        },
        "line_items": [
          {
            "qty": null,
            "amount": 2676,
            "unit_price": null,
            "description": "8701 Bentwood Drive, Final Draw (Phase 18375342)"
          }
        ],
        "vendor_name": "Horizon Electric",
        "invoice_date": "2025-03-25",
        "project_name": "8701 Bentwood Drive, Eden Prairie",
        "document_type": "invoice",
        "invoice_number": "J-7207638",
        "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": "Horizon Electric 8701 Bentwood Drive, Eden Prairie.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/Horizon Electric 8701 Bentwood Drive, Eden Prairie.pdf",
  "processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/Horizon Electric 8701 Bentwood Drive, Eden Prairie.pdf"
}

Time

05/12/2026

Event

PARSE COMPLETED

Message

Claude extraction parsed and stored.

Payload

{
  "total": "2676.00",
  "message": "Claude extraction parsed and stored.",
  "due_date": "2025-04-24",
  "jkath_terms": "Net 30",
  "process_key": "05-12-2026-030-INV-006",
  "vendor_name": "Horizon Electric",
  "claude_model": "claude-sonnet-4-6",
  "input_tokens": "3340",
  "invoice_date": "2025-03-25",
  "vendor_terms": null,
  "make_trace_id": "make-20260512_001839_243",
  "output_tokens": "489",
  "bill_import_id": "bill_2be3c932b8074c939440bfd85e993e4f",
  "invoice_number": "J-7207638",
  "vendor_due_date": null,
  "source_file_name": "Horizon Electric 8701 Bentwood Drive, Eden Prairie.pdf",
  "claude_message_id": "msg_01THnAYGDxXuYStTqFY7cLRE",
  "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-030-INV-006",
  "vendor_name": "Horizon Electric",
  "make_trace_id": "make-20260512_001839_243",
  "bill_import_id": "bill_2be3c932b8074c939440bfd85e993e4f",
  "canonical_name": null,
  "category_count": 0,
  "invoice_number": "J-7207638",
  "category_options": [],
  "source_file_name": "Horizon Electric 8701 Bentwood Drive, Eden Prairie.pdf",
  "expense_category_id": null,
  "normalized_alias_key": "horizon electric",
  "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 name 'Horizon Electric' is an exact match to the approved vendor 'Horizon Electric' in the approved vendor list.",
  "message": "Vendor resolver matched a portal vendor and alias was recorded.",
  "alias_id": "alias_7e6b45063c154db19996874e958a7f8b",
  "vendor_id": "vend_2ba32f9db9004b9c9bc282acdb08c29b",
  "confidence": 1,
  "process_key": "05-12-2026-030-INV-006",
  "make_trace_id": "make-20260512_001839_243",
  "bill_import_id": "bill_2be3c932b8074c939440bfd85e993e4f",
  "category_count": 1,
  "suggested_alias": "Horizon Electric",
  "category_options": [
    {
      "name": "Electrical",
      "notes": "Mapped from JKath historical QuickBooks export: Building Services:Electrical (6).",
      "expense_category_id": "cat_ffcb7c9c5585409ba42ca033f3420f00",
      "fully_qualified_name": "Building Services:Electrical",
      "quickbooks_account_id": "124",
      "vendor_expense_category_id": "cmp1bb03z004c13pfptbcroj2"
    }
  ],
  "resolver_payload": {
    "reason": "The extracted vendor name 'Horizon Electric' is an exact match to the approved vendor 'Horizon Electric' in the approved vendor list.",
    "matched": "true",
    "confidence": "1",
    "suggested_alias": "Horizon Electric",
    "canonical_vendor_name": "Horizon Electric",
    "default_expense_account": "Subcontractors"
  },
  "source_file_name": "Horizon Electric 8701 Bentwood Drive, Eden Prairie.pdf",
  "canonical_vendor_name": "Horizon Electric",
  "extracted_vendor_name": "Horizon Electric"
}

Time

05/12/2026

Event

CATEGORY SELECTION COMPLETED

Message

Expense category selected for bill import.

Payload

{
  "path": "resolver_portal_category_selection",
  "message": "Claude selected an expense category from allowed portal options after vendor resolver.",
  "process_key": "05-12-2026-030-INV-006",
  "vendor_name": "Horizon Electric",
  "category_name": "Electrical",
  "make_trace_id": "make-20260512_001839_243",
  "bill_import_id": "bill_2be3c932b8074c939440bfd85e993e4f",
  "source_file_name": "Horizon Electric 8701 Bentwood Drive, Eden Prairie.pdf",
  "selection_payload": {
    "reason": "The vendor is Horizon Electric, an electrical contractor, and the invoice is for a final draw on a construction phase at 8701 Bentwood Drive, Eden Prairie. The only allowed category is Electrical, which directly matches the vendor type and scope of work.",
    "confidence": 0.99,
    "selected_expense_category_id": "cat_ffcb7c9c5585409ba42ca033f3420f00",
    "selected_expense_category_name": "Electrical"
  },
  "expense_category_id": "cat_ffcb7c9c5585409ba42ca033f3420f00",
  "quickbooks_account_id": "124"
}

Time

05/12/2026

Event

QB BILL CREATED

Message

QuickBooks Bill created.

Payload

{
  "path": "resolver_success",
  "message": "QuickBooks Bill created from invoice import.",
  "process_key": "05-12-2026-030-INV-006",
  "make_trace_id": "make-20260512_001839_243",
  "bill_import_id": "bill_2be3c932b8074c939440bfd85e993e4f",
  "source_file_name": "Horizon Electric 8701 Bentwood Drive, Eden Prairie.pdf",
  "quickbooks_bill_id": "348",
  "quickbooks_payload": {
    "path": "resolver_success",
    "total": "2676.00",
    "due_date": "2025-04-24",
    "doc_number": "J-7207638",
    "vendor_ref": "81",
    "account_ref": "124",
    "jkath_terms": "Net 30",
    "vendor_terms": "",
    "quickbooks_bill_id": "348"
  },
  "quickbooks_account_id": "124",
  "resolved_expense_category_id": "cat_ffcb7c9c5585409ba42ca033f3420f00"
}

Time

05/12/2026

Event

ATTACHMENT UPLOADED

Message

Source file attached to the QuickBooks Bill.

Payload

{
  "path": "resolver_success",
  "message": "Source file uploaded to QuickBooks Bill.",
  "process_key": "05-12-2026-030-INV-006",
  "make_trace_id": "make-20260512_001839_243",
  "bill_import_id": "bill_2be3c932b8074c939440bfd85e993e4f",
  "source_file_name": "Horizon Electric 8701 Bentwood Drive, Eden Prairie.pdf",
  "attachment_payload": {
    "path": "resolver_success",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "348"
  },
  "quickbooks_bill_id": "348"
}

Time

05/12/2026

Event

FILE MOVED

Message

Final invoice file moved.

Payload

{
  "path": "resolver_success",
  "status": "CREATED_IN_QBO",
  "message": "Processed invoice file moved after QuickBooks Bill creation.",
  "outcome": "processed",
  "process_key": "05-12-2026-030-INV-006",
  "make_trace_id": "make-20260512_001839_243",
  "bill_import_id": "bill_2be3c932b8074c939440bfd85e993e4f",
  "final_file_name": "HorizonElectric_INV-J-7207638.pdf",
  "source_file_name": "Horizon Electric 8701 Bentwood Drive, Eden Prairie.pdf",
  "dropbox_shared_url": "https://www.dropbox.com/scl/fi/0u96sjo2czhavhv9ffpdm/HorizonElectric_INV-J-7207638.pdf?rlkey=8y73it0yhuf4oijcfsuct0vbt&dl=0",
  "quickbooks_bill_id": "348",
  "multi_invoice_group_id": "bill_2be3c932b8074c939440bfd85e993e4f"
}