05-12-2026-026-INV-008

{
  "tax": 0,
  "notes": "This is the remaining balance invoice referencing original Bid 1321 with a total bid amount of $10,898.00. Job address is 2258 St Clair Ave, MN 55105. An 8% late fee applies after 30 days from billing date. Billed to Jkath, 1408 Northland Drive, Suite 304, Mendota Heights, MN 55120.",
  "terms": "Net 15",
  "total": 2179.6,
  "due_date": "2025-02-12",
  "shipping": 0,
  "subtotal": 2179.6,
  "confidence": {
    "total": 1,
    "vendor_name": 1,
    "invoice_date": 1,
    "project_name": 1,
    "invoice_number": 1
  },
  "line_items": [
    {
      "qty": null,
      "amount": 2179.6,
      "unit_price": null,
      "description": "Bid 1321 – Remaining balance of original bid amount of $10,898.00 for materials and services provided. Everything is installed and working as it should be. Final inspection has been completed."
    }
  ],
  "vendor_name": "DLM Plumbing",
  "invoice_date": "2025-01-28",
  "project_name": "St. Clair Ave",
  "document_type": "invoice",
  "invoice_number": "1723",
  "is_billable_invoice": true
}

{
  "alias_lookup": {
    "found": true,
    "alias_id": "alias_46f2641117bd4272a26bb9af561884d4",
    "vendor_id": "vend_32904b9a2da2434fb34f07c541e1995a",
    "alias_name": "DLM Plumbing",
    "canonical_name": "DLM Plumbing",
    "category_count": 2,
    "category_options": [
      {
        "name": "Plumbing",
        "notes": "Mapped from JKath historical QuickBooks export: Building Services:Plumbing (35).",
        "expense_category_id": "cat_f04b0af5b00a42c3a31351bad4d75f5d",
        "fully_qualified_name": "Building Services:Plumbing",
        "quickbooks_account_id": "136",
        "vendor_expense_category_id": "cmp1bax47002o13pfimzofqof"
      },
      {
        "name": "Plumbing",
        "notes": "Mapped from JKath historical QuickBooks export: Building Materials:Plumbing (1).",
        "expense_category_id": "cat_173f2c1a36d74231bf0b9d9c755c7b0d",
        "fully_qualified_name": "Building Materials:Plumbing",
        "quickbooks_account_id": "113",
        "vendor_expense_category_id": "cmp1bax1s002m13pfs5gclly7"
      }
    ],
    "expense_category_id": null,
    "normalized_alias_key": "dlm plumbing",
    "quickbooks_vendor_id": "19",
    "quickbooks_account_id": null,
    "default_expense_account": null,
    "invoice_processing_notes": null,
    "missing_category_options": false
  },
  "category_selection": {
    "reason": "The invoice from DLM Plumbing covers materials and services (installation, final inspection) for the St. Clair Ave project. The line item references a bid for both materials and services, but the dominant nature of the charge is labor/services (installation completed, inspection passed), making the Building Services:Plumbing category (quickbooks_account_id=136, 35 historical mappings) the stronger fit over the Building Materials:Plumbing category (quickbooks_account_id=113, only 1 historical mapping). The higher historical frequency of cat_f04b0af5b00a42c3a31351bad4d75f5d further supports this selection.",
    "confidence": 0.82,
    "category_name": "Plumbing",
    "expense_category_id": "cat_f04b0af5b00a42c3a31351bad4d75f5d",
    "quickbooks_account_id": "136",
    "selected_expense_category_id": "cat_f04b0af5b00a42c3a31351bad4d75f5d",
    "selected_expense_category_name": "Plumbing"
  }
}

{
  "lookup": {
    "quickbooks_vendor_id": "19",
    "quickbooks_account_id": "136",
    "existing_quickbooks_bill_id": null
  },
  "bill_created": {
    "path": "multi_category_direct",
    "total": "2179.60",
    "due_date": "2025-02-27",
    "doc_number": "1723",
    "vendor_ref": "19",
    "account_ref": "136",
    "jkath_terms": "Net 30",
    "vendor_terms": "Net 15",
    "quickbooks_bill_id": "304",
    "resolved_expense_category_id": "cat_f04b0af5b00a42c3a31351bad4d75f5d"
  },
  "attachment_uploaded": {
    "path": "multi_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "304"
  }
}

{
  "run_id": "run_d3dcb6acd0044649867411b977067fec",
  "source": "make.com",
  "run_key": "05-12-2026-026",
  "make_trace_id": "make-20260511_230756_287",
  "source_file_name": "Invoice_1723_from_DLM_Plumbing.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/Invoice_1723_from_DLM_Plumbing.pdf",
  "source_dropbox_id": "id:CHX6_xJiKhAAAAAAAABirA",
  "source_dropbox_rev": "0165196d21873e500000003549f4393",
  "multi_invoice_count": 1,
  "multi_invoice_index": 1,
  "source_content_hash": "cbcb788d9162e85f3e3a8f7471b1c31e2d5c2fa2f2005b9ce8734c823e9468a7",
  "processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/Invoice_1723_from_DLM_Plumbing.pdf",
  "multi_invoice_group_id": "bill_69948be8a1284fe3a653d76c724973e8",
  "processing_dropbox_rev": "0165197095638f600000003549f4393",
  "multi_invoice_source_payload": {
    "notes": "Single invoice PDF. No unusual issues detected. Clear, high-quality document.",
    "invoices": [
      {
        "tax": 0,
        "notes": "This is the remaining balance invoice referencing original Bid 1321 with a total bid amount of $10,898.00. Job address is 2258 St Clair Ave, MN 55105. An 8% late fee applies after 30 days from billing date. Billed to Jkath, 1408 Northland Drive, Suite 304, Mendota Heights, MN 55120.",
        "terms": "Net 15",
        "total": 2179.6,
        "due_date": "2025-02-12",
        "shipping": 0,
        "subtotal": 2179.6,
        "confidence": {
          "total": 1,
          "vendor_name": 1,
          "invoice_date": 1,
          "project_name": 1,
          "invoice_number": 1
        },
        "line_items": [
          {
            "qty": null,
            "amount": 2179.6,
            "unit_price": null,
            "description": "Bid 1321 – Remaining balance of original bid amount of $10,898.00 for materials and services provided. Everything is installed and working as it should be. Final inspection has been completed."
          }
        ],
        "vendor_name": "DLM Plumbing",
        "invoice_date": "2025-01-28",
        "project_name": "St. Clair Ave",
        "document_type": "invoice",
        "invoice_number": "1723",
        "is_billable_invoice": true
      }
    ]
  }
}