05-12-2026-036-INV-011

{
  "tax": 47.44,
  "notes": "Delivery is included as a line item in the subtotal, so shipping is set to 0. Project name is listed as 'Craig' under the 'For:' field, likely a contact or project name. Sold to: J Kath Design Build, 1308 Northland Drive #304, Mendota Heights 55120. Sales tax rate is 8.125%.",
  "terms": "1% 10 Net 30",
  "total": 631.24,
  "due_date": null,
  "shipping": 0,
  "subtotal": 583.8,
  "confidence": {
    "total": 0.99,
    "vendor_name": 0.99,
    "invoice_date": 0.99,
    "project_name": 0.85,
    "invoice_number": 0.99
  },
  "line_items": [
    {
      "qty": 48,
      "amount": 379.2,
      "unit_price": 7.9,
      "description": "Rift Sawn White Oak"
    },
    {
      "qty": 40,
      "amount": 79.6,
      "unit_price": 1.99,
      "description": "Rift Sawn White Oak (Rift White Oak)"
    },
    {
      "qty": 1,
      "amount": 100,
      "unit_price": 100,
      "description": "Set up fee"
    },
    {
      "qty": 1,
      "amount": 25,
      "unit_price": 25,
      "description": "Delivery"
    }
  ],
  "vendor_name": "Great Lakes Millwork",
  "invoice_date": "2025-04-01",
  "project_name": "Craig",
  "document_type": "invoice",
  "invoice_number": "86016",
  "is_billable_invoice": true
}

{
  "alias_lookup": {
    "found": true,
    "alias_id": "cmp1abblw001yagtbnd53ndq2",
    "vendor_id": "vend_f4b7985cdc774cd090bbc71737c72ca2",
    "alias_name": "Great Lakes Millwork",
    "canonical_name": "Great Lakes Millwork LLC",
    "category_count": 2,
    "category_options": [
      {
        "name": "Cabinet Materials",
        "notes": "Mapped from JKath historical QuickBooks export: Building Materials:Cabinet Materials (2).",
        "expense_category_id": "cat_8d2d70e75bdd439fb2060c07463e1a62",
        "fully_qualified_name": "Building Materials:Cabinet Materials",
        "quickbooks_account_id": "105",
        "vendor_expense_category_id": "cmp1bauxn001e13pf3811ch4p"
      },
      {
        "name": "Millwork",
        "notes": "Mapped from JKath historical QuickBooks export: Building Materials:Millwork (21).",
        "expense_category_id": "cat_ac5e83e1f2fd4f32aa161f489b7b8631",
        "fully_qualified_name": "Building Materials:Millwork",
        "quickbooks_account_id": "112",
        "vendor_expense_category_id": "cmp1bav05001g13pf6kodm4kl"
      }
    ],
    "expense_category_id": null,
    "normalized_alias_key": "great lakes millwork",
    "quickbooks_vendor_id": "8",
    "quickbooks_account_id": null,
    "default_expense_account": null,
    "invoice_processing_notes": null,
    "missing_category_options": false
  },
  "category_selection": {
    "reason": "The vendor is 'Great Lakes Millwork LLC', a millwork supplier, and the line items consist of Rift Sawn White Oak lumber/wood materials — classic millwork products. The Millwork category has 21 historical mappings from QuickBooks and directly aligns with both the vendor type and the materials purchased. Cabinet Materials is less appropriate as there are no cabinet-specific components listed.",
    "confidence": 0.97,
    "category_name": "Millwork",
    "expense_category_id": "cat_ac5e83e1f2fd4f32aa161f489b7b8631",
    "quickbooks_account_id": "112",
    "selected_expense_category_id": "cat_ac5e83e1f2fd4f32aa161f489b7b8631",
    "selected_expense_category_name": "Millwork"
  }
}

{
  "lookup": {
    "quickbooks_vendor_id": "8",
    "quickbooks_account_id": "112",
    "existing_quickbooks_bill_id": null
  },
  "bill_created": {
    "path": "multi_category_direct",
    "total": "631.24",
    "due_date": "2025-05-01",
    "doc_number": "86016",
    "vendor_ref": "8",
    "account_ref": "112",
    "jkath_terms": "Net 30",
    "vendor_terms": "1% 10 Net 30",
    "quickbooks_bill_id": "389",
    "resolved_expense_category_id": "cat_ac5e83e1f2fd4f32aa161f489b7b8631"
  },
  "attachment_uploaded": {
    "path": "multi_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "389"
  }
}

{
  "run_id": "run_cb99da4433154d8a89bd42b68c985da8",
  "source": "make.com",
  "run_key": "05-12-2026-036",
  "make_trace_id": "make-20260512_015845_054",
  "source_file_name": "Inv_86016_from_Great_Lakes_Millwork_LLC_13996.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/Inv_86016_from_Great_Lakes_Millwork_LLC_13996.pdf",
  "source_dropbox_id": "id:CHX6_xJiKhAAAAAAAABjiQ",
  "source_dropbox_rev": "016519964a4594200000003549f4393",
  "multi_invoice_count": 1,
  "multi_invoice_index": 1,
  "source_content_hash": "868b1061056d31849925e9b392f4733a4d6ae44785a85f9112cb7adab0b2ce0f",
  "processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/Inv_86016_from_Great_Lakes_Millwork_LLC_13996.pdf",
  "multi_invoice_group_id": "bill_14d229d4db96494c90bae7356691daaf",
  "processing_dropbox_rev": "01651996f01a5e900000003549f4393",
  "multi_invoice_source_payload": {
    "notes": "Single invoice in this PDF. Subtotal calculated as sum of line items: 379.20 + 79.60 + 100.00 + 25.00 = 583.80. Tax of 47.44 at 8.125% applied to taxable items. Total 631.24 matches printed invoice total.",
    "invoices": [
      {
        "tax": 47.44,
        "notes": "Delivery is included as a line item in the subtotal, so shipping is set to 0. Project name is listed as 'Craig' under the 'For:' field, likely a contact or project name. Sold to: J Kath Design Build, 1308 Northland Drive #304, Mendota Heights 55120. Sales tax rate is 8.125%.",
        "terms": "1% 10 Net 30",
        "total": 631.24,
        "due_date": null,
        "shipping": 0,
        "subtotal": 583.8,
        "confidence": {
          "total": 0.99,
          "vendor_name": 0.99,
          "invoice_date": 0.99,
          "project_name": 0.85,
          "invoice_number": 0.99
        },
        "line_items": [
          {
            "qty": 48,
            "amount": 379.2,
            "unit_price": 7.9,
            "description": "Rift Sawn White Oak"
          },
          {
            "qty": 40,
            "amount": 79.6,
            "unit_price": 1.99,
            "description": "Rift Sawn White Oak (Rift White Oak)"
          },
          {
            "qty": 1,
            "amount": 100,
            "unit_price": 100,
            "description": "Set up fee"
          },
          {
            "qty": 1,
            "amount": 25,
            "unit_price": 25,
            "description": "Delivery"
          }
        ],
        "vendor_name": "Great Lakes Millwork",
        "invoice_date": "2025-04-01",
        "project_name": "Craig",
        "document_type": "invoice",
        "invoice_number": "86016",
        "is_billable_invoice": true
      }
    ]
  }
}