05-12-2026-044-INV-002

{
  "tax": 0,
  "notes": "Invoice includes a credit of -$9,946.80 for a prior payment received against Invoice 2411004. The net balance due is $6,596.20. Project jobsite address is 5503 Lakeview Drive, Edina, MN 55424. Bill-to is Jkath Design Build + Reinvent.",
  "terms": "Net 30",
  "total": 6596.2,
  "due_date": "2025-04-11",
  "shipping": 0,
  "subtotal": 6596.2,
  "confidence": {
    "total": 1,
    "vendor_name": 1,
    "invoice_date": 1,
    "project_name": 0.95,
    "invoice_number": 1
  },
  "line_items": [
    {
      "qty": 34,
      "amount": 833,
      "unit_price": 24.5,
      "description": "Kitchen - New Opening"
    },
    {
      "qty": 5,
      "amount": 125,
      "unit_price": 25,
      "description": "Kitchen - Light Fixture Hanging"
    },
    {
      "qty": 6,
      "amount": 531,
      "unit_price": 88.5,
      "description": "Kitchen - 4\" Wafer Light"
    },
    {
      "qty": 1,
      "amount": 325,
      "unit_price": 325,
      "description": "Kitchen - Fish In Dedicated Circuit to Refrigerator 120V@20A"
    },
    {
      "qty": 1,
      "amount": 325,
      "unit_price": 325,
      "description": "Kitchen - Fish In Dedicated Circuit to Gas Oven 120V@20A"
    },
    {
      "qty": 1,
      "amount": 1400,
      "unit_price": 1400,
      "description": "Kitchen - Demo and Rewire"
    },
    {
      "qty": 9,
      "amount": 1080,
      "unit_price": 120,
      "description": "Kitchen - Arc Fault Protection to Circuit"
    },
    {
      "qty": 1,
      "amount": 445,
      "unit_price": 445,
      "description": "Kitchen - Oven with GFCI Protection"
    },
    {
      "qty": 1,
      "amount": 175,
      "unit_price": 175,
      "description": "Office - Hang New Light Fixture"
    },
    {
      "qty": 1,
      "amount": 75,
      "unit_price": 75,
      "description": "Dining Room - Hang New Light Fixture"
    },
    {
      "qty": 1,
      "amount": 75,
      "unit_price": 75,
      "description": "Living Room - Hang New Light Fixture"
    },
    {
      "qty": 1,
      "amount": 110,
      "unit_price": 110,
      "description": "Porch - Hang New Ceiling Fan"
    },
    {
      "qty": 1,
      "amount": 75,
      "unit_price": 75,
      "description": "Foyer - Hang New Light Fixture"
    },
    {
      "qty": 2,
      "amount": 150,
      "unit_price": 75,
      "description": "Mudroom - Hang New Light Fixture"
    },
    {
      "qty": 1,
      "amount": 75,
      "unit_price": 75,
      "description": "Powder Bathroom - Hang New Light Fixture"
    },
    {
      "qty": 1,
      "amount": 250,
      "unit_price": 250,
      "description": "Upper Staircase - Hang New Light Fixture"
    },
    {
      "qty": 3,
      "amount": 225,
      "unit_price": 75,
      "description": "Upstairs Bedrooms - Hang New Light Fixture"
    },
    {
      "qty": 1,
      "amount": 450,
      "unit_price": 450,
      "description": "Laundry Room - Hang Two New Light Fixture and Rewire"
    },
    {
      "qty": 2,
      "amount": 280,
      "unit_price": 140,
      "description": "Jack and Jill Bathroom - Hang New Light Fixture and Move Fixtures Up"
    },
    {
      "qty": 2,
      "amount": 280,
      "unit_price": 140,
      "description": "Guest Bathroom - Hang New Light Fixture and Rewire"
    },
    {
      "qty": 3,
      "amount": 225,
      "unit_price": 75,
      "description": "Primary Closet - Hang New Light Fixture"
    },
    {
      "qty": 1,
      "amount": 75,
      "unit_price": 75,
      "description": "Primary Bedroom - Hang New Light Fixture"
    },
    {
      "qty": 14,
      "amount": 343,
      "unit_price": 24.5,
      "description": "Primary Bathroom - New Opening"
    },
    {
      "qty": 3,
      "amount": 75,
      "unit_price": 25,
      "description": "Primary Bathroom - Light Fixture Hanging"
    },
    {
      "qty": 4,
      "amount": 354,
      "unit_price": 88.5,
      "description": "Primary Bathroom - 4\" Wafer Light"
    },
    {
      "qty": 1,
      "amount": 600,
      "unit_price": 600,
      "description": "Primary Bathroom - Demo and Rewire"
    },
    {
      "qty": 1,
      "amount": 350,
      "unit_price": 350,
      "description": "Permit and Processing Fee"
    },
    {
      "qty": 12,
      "amount": 564,
      "unit_price": 47,
      "description": "Main Floor - 6\" LED Open Trim Replacement"
    },
    {
      "qty": 1,
      "amount": 250,
      "unit_price": 250,
      "description": "Living Room - Remove Switch and Two Eyeballs by the Fireplace"
    },
    {
      "qty": 2,
      "amount": 240,
      "unit_price": 120,
      "description": "Living Room - Arc Fault Protection to Circuit"
    },
    {
      "qty": 1,
      "amount": 95,
      "unit_price": 95,
      "description": "Living Room - Wire Fireplace"
    },
    {
      "qty": 1,
      "amount": 120,
      "unit_price": 120,
      "description": "Dining Room - Arc Fault Protection to Circuit"
    },
    {
      "qty": 1,
      "amount": 125,
      "unit_price": 125,
      "description": "Dining Room - Move Dining Room Light and Rewire"
    },
    {
      "qty": 1,
      "amount": 250,
      "unit_price": 250,
      "description": "Dining Room - Add 3way Switch for Recess Lighting"
    },
    {
      "qty": 1,
      "amount": 120,
      "unit_price": 120,
      "description": "Office - Arc Fault Protection to Circuit"
    },
    {
      "qty": 1,
      "amount": 515,
      "unit_price": 515,
      "description": "Office - Fish in 3-4\" Wafer Lights and Add 1 switch"
    },
    {
      "qty": 1,
      "amount": 295,
      "unit_price": 295,
      "description": "Office - Fish In LED Undercabinet Light with Switch on Light"
    },
    {
      "qty": 1,
      "amount": 115,
      "unit_price": 115,
      "description": "Kitchen - Island Receptacle"
    },
    {
      "qty": 1,
      "amount": 115,
      "unit_price": 115,
      "description": "Kitchen - Receptacle behind Drawer in Island"
    },
    {
      "qty": 1,
      "amount": 225,
      "unit_price": 225,
      "description": "Mudroom - Demo; Receptacles, Recess Lighting"
    },
    {
      "qty": 1,
      "amount": 120,
      "unit_price": 120,
      "description": "Mudroom - Arc Fault Protection to Circuit"
    },
    {
      "qty": 1,
      "amount": 295,
      "unit_price": 295,
      "description": "Mudroom - Wire Two New Light Fixtures"
    },
    {
      "qty": 1,
      "amount": 315,
      "unit_price": 315,
      "description": "Mudroom - Add Switch and Undercabinet light in Closet"
    },
    {
      "qty": 1,
      "amount": 75,
      "unit_price": 75,
      "description": "Mudroom - Outlet with Type C USB"
    },
    {
      "qty": 1,
      "amount": 120,
      "unit_price": 120,
      "description": "Staircase - Arc Fault Protection to Circuit"
    },
    {
      "qty": 13,
      "amount": 611,
      "unit_price": 47,
      "description": "Second Floor - 6\" LED Open Trim Replacement"
    },
    {
      "qty": 1,
      "amount": 75,
      "unit_price": 75,
      "description": "Primary Bathroom - Outlet with Type C USB"
    },
    {
      "qty": 1,
      "amount": 835,
      "unit_price": 835,
      "description": "Porch Repairs"
    },
    {
      "qty": 53,
      "amount": 1537,
      "unit_price": 29,
      "description": "Change Out Old Device to New Kasa Smart Switch (Home Owner to Provide Switches and Plates from Kasa)"
    },
    {
      "qty": 1,
      "amount": 225,
      "unit_price": 225,
      "description": "Kasa App Setup"
    },
    {
      "qty": 1,
      "amount": -9946.8,
      "unit_price": -9946.8,
      "description": "Payment Received For Invoice 2411004"
    }
  ],
  "vendor_name": "Liberty Electric Minnesota LLC",
  "invoice_date": "2025-03-12",
  "project_name": "5503 Lakeview Drive, Edina, MN 55424",
  "document_type": "invoice",
  "invoice_number": "25305",
  "is_billable_invoice": true
}

{
  "alias_lookup": {
    "found": true,
    "alias_id": "cmp1abh90006gagtbnzrnz3wo",
    "vendor_id": "vend_1ed7b0a3c46346b5aba5b77c09824774",
    "alias_name": "Liberty Electric Minnesota LLC",
    "canonical_name": "Liberty Electric Minnesota LLC",
    "category_count": 1,
    "category_options": [
      {
        "name": "Electrical",
        "notes": "Mapped from JKath historical QuickBooks export: Building Services:Electrical (39).",
        "expense_category_id": "cat_ffcb7c9c5585409ba42ca033f3420f00",
        "fully_qualified_name": "Building Services:Electrical",
        "quickbooks_account_id": "124",
        "vendor_expense_category_id": "cmp1bazw6004813pfobwqxvzx"
      }
    ],
    "expense_category_id": "cat_ffcb7c9c5585409ba42ca033f3420f00",
    "normalized_alias_key": "liberty electric minnesota llc",
    "quickbooks_vendor_id": "5",
    "quickbooks_account_id": "124",
    "default_expense_account": "Electrical",
    "invoice_processing_notes": null,
    "missing_category_options": false
  },
  "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": "Electrical",
    "expense_category_id": "cat_ffcb7c9c5585409ba42ca033f3420f00",
    "quickbooks_account_id": "124",
    "selected_expense_category_id": "cat_ffcb7c9c5585409ba42ca033f3420f00",
    "selected_expense_category_name": "Electrical"
  }
}

{
  "lookup": {
    "quickbooks_vendor_id": "5",
    "quickbooks_account_id": "124",
    "existing_quickbooks_bill_id": null
  },
  "bill_created": {
    "path": "single_category_direct",
    "total": "6596.20",
    "due_date": "2025-04-11",
    "doc_number": "25305",
    "vendor_ref": "5",
    "account_ref": "124",
    "jkath_terms": "Net 30",
    "vendor_terms": "Net 30",
    "quickbooks_bill_id": "419",
    "resolved_expense_category_id": "cat_ffcb7c9c5585409ba42ca033f3420f00"
  },
  "attachment_uploaded": {
    "path": "single_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "419"
  }
}

{
  "run_id": "run_e2833fbe37f94c778334fc63f61797bd",
  "source": "make.com",
  "run_key": "05-12-2026-044",
  "make_trace_id": "make-20260512_095327_769",
  "source_file_name": "Liberty Electric Minnesota LLC Invoice 25305_VALIDATION-FAILED.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/Liberty Electric Minnesota LLC Invoice 25305_VALIDATION-FAILED.pdf",
  "source_dropbox_id": "id:CHX6_xJiKhAAAAAAAABijw",
  "source_dropbox_rev": "01651a005eec6b900000003549f4393",
  "multi_invoice_count": 1,
  "multi_invoice_index": 1,
  "source_content_hash": "063a76e5ff4ebfadf57c59d8d2cfe08a076510c060953e07b87697e65d7f17c5",
  "processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/Liberty Electric Minnesota LLC Invoice 25305_VALIDATION-FAILED.pdf",
  "multi_invoice_group_id": "bill_88729de8f0544d90b4e0457e1b859f81",
  "processing_dropbox_rev": "01651a007eac8de00000003549f4393",
  "multi_invoice_source_payload": {
    "notes": "Single invoice document. Invoice #25305 from Liberty Electric Minnesota LLC dated 03/12/2025. A prior payment of $9,946.80 (Invoice 2411004) is credited on this invoice, resulting in a balance due of $6,596.20.",
    "invoices": [
      {
        "tax": 0,
        "notes": "Invoice includes a credit of -$9,946.80 for a prior payment received against Invoice 2411004. The net balance due is $6,596.20. Project jobsite address is 5503 Lakeview Drive, Edina, MN 55424. Bill-to is Jkath Design Build + Reinvent.",
        "terms": "Net 30",
        "total": 6596.2,
        "due_date": "2025-04-11",
        "shipping": 0,
        "subtotal": 6596.2,
        "confidence": {
          "total": 1,
          "vendor_name": 1,
          "invoice_date": 1,
          "project_name": 0.95,
          "invoice_number": 1
        },
        "line_items": [
          {
            "qty": 34,
            "amount": 833,
            "unit_price": 24.5,
            "description": "Kitchen - New Opening"
          },
          {
            "qty": 5,
            "amount": 125,
            "unit_price": 25,
            "description": "Kitchen - Light Fixture Hanging"
          },
          {
            "qty": 6,
            "amount": 531,
            "unit_price": 88.5,
            "description": "Kitchen - 4\" Wafer Light"
          },
          {
            "qty": 1,
            "amount": 325,
            "unit_price": 325,
            "description": "Kitchen - Fish In Dedicated Circuit to Refrigerator 120V@20A"
          },
          {
            "qty": 1,
            "amount": 325,
            "unit_price": 325,
            "description": "Kitchen - Fish In Dedicated Circuit to Gas Oven 120V@20A"
          },
          {
            "qty": 1,
            "amount": 1400,
            "unit_price": 1400,
            "description": "Kitchen - Demo and Rewire"
          },
          {
            "qty": 9,
            "amount": 1080,
            "unit_price": 120,
            "description": "Kitchen - Arc Fault Protection to Circuit"
          },
          {
            "qty": 1,
            "amount": 445,
            "unit_price": 445,
            "description": "Kitchen - Oven with GFCI Protection"
          },
          {
            "qty": 1,
            "amount": 175,
            "unit_price": 175,
            "description": "Office - Hang New Light Fixture"
          },
          {
            "qty": 1,
            "amount": 75,
            "unit_price": 75,
            "description": "Dining Room - Hang New Light Fixture"
          },
          {
            "qty": 1,
            "amount": 75,
            "unit_price": 75,
            "description": "Living Room - Hang New Light Fixture"
          },
          {
            "qty": 1,
            "amount": 110,
            "unit_price": 110,
            "description": "Porch - Hang New Ceiling Fan"
          },
          {
            "qty": 1,
            "amount": 75,
            "unit_price": 75,
            "description": "Foyer - Hang New Light Fixture"
          },
          {
            "qty": 2,
            "amount": 150,
            "unit_price": 75,
            "description": "Mudroom - Hang New Light Fixture"
          },
          {
            "qty": 1,
            "amount": 75,
            "unit_price": 75,
            "description": "Powder Bathroom - Hang New Light Fixture"
          },
          {
            "qty": 1,
            "amount": 250,
            "unit_price": 250,
            "description": "Upper Staircase - Hang New Light Fixture"
          },
          {
            "qty": 3,
            "amount": 225,
            "unit_price": 75,
            "description": "Upstairs Bedrooms - Hang New Light Fixture"
          },
          {
            "qty": 1,
            "amount": 450,
            "unit_price": 450,
            "description": "Laundry Room - Hang Two New Light Fixture and Rewire"
          },
          {
            "qty": 2,
            "amount": 280,
            "unit_price": 140,
            "description": "Jack and Jill Bathroom - Hang New Light Fixture and Move Fixtures Up"
          },
          {
            "qty": 2,
            "amount": 280,
            "unit_price": 140,
            "description": "Guest Bathroom - Hang New Light Fixture and Rewire"
          },
          {
            "qty": 3,
            "amount": 225,
            "unit_price": 75,
            "description": "Primary Closet - Hang New Light Fixture"
          },
          {
            "qty": 1,
            "amount": 75,
            "unit_price": 75,
            "description": "Primary Bedroom - Hang New Light Fixture"
          },
          {
            "qty": 14,
            "amount": 343,
            "unit_price": 24.5,
            "description": "Primary Bathroom - New Opening"
          },
          {
            "qty": 3,
            "amount": 75,
            "unit_price": 25,
            "description": "Primary Bathroom - Light Fixture Hanging"
          },
          {
            "qty": 4,
            "amount": 354,
            "unit_price": 88.5,
            "description": "Primary Bathroom - 4\" Wafer Light"
          },
          {
            "qty": 1,
            "amount": 600,
            "unit_price": 600,
            "description": "Primary Bathroom - Demo and Rewire"
          },
          {
            "qty": 1,
            "amount": 350,
            "unit_price": 350,
            "description": "Permit and Processing Fee"
          },
          {
            "qty": 12,
            "amount": 564,
            "unit_price": 47,
            "description": "Main Floor - 6\" LED Open Trim Replacement"
          },
          {
            "qty": 1,
            "amount": 250,
            "unit_price": 250,
            "description": "Living Room - Remove Switch and Two Eyeballs by the Fireplace"
          },
          {
            "qty": 2,
            "amount": 240,
            "unit_price": 120,
            "description": "Living Room - Arc Fault Protection to Circuit"
          },
          {
            "qty": 1,
            "amount": 95,
            "unit_price": 95,
            "description": "Living Room - Wire Fireplace"
          },
          {
            "qty": 1,
            "amount": 120,
            "unit_price": 120,
            "description": "Dining Room - Arc Fault Protection to Circuit"
          },
          {
            "qty": 1,
            "amount": 125,
            "unit_price": 125,
            "description": "Dining Room - Move Dining Room Light and Rewire"
          },
          {
            "qty": 1,
            "amount": 250,
            "unit_price": 250,
            "description": "Dining Room - Add 3way Switch for Recess Lighting"
          },
          {
            "qty": 1,
            "amount": 120,
            "unit_price": 120,
            "description": "Office - Arc Fault Protection to Circuit"
          },
          {
            "qty": 1,
            "amount": 515,
            "unit_price": 515,
            "description": "Office - Fish in 3-4\" Wafer Lights and Add 1 switch"
          },
          {
            "qty": 1,
            "amount": 295,
            "unit_price": 295,
            "description": "Office - Fish In LED Undercabinet Light with Switch on Light"
          },
          {
            "qty": 1,
            "amount": 115,
            "unit_price": 115,
            "description": "Kitchen - Island Receptacle"
          },
          {
            "qty": 1,
            "amount": 115,
            "unit_price": 115,
            "description": "Kitchen - Receptacle behind Drawer in Island"
          },
          {
            "qty": 1,
            "amount": 225,
            "unit_price": 225,
            "description": "Mudroom - Demo; Receptacles, Recess Lighting"
          },
          {
            "qty": 1,
            "amount": 120,
            "unit_price": 120,
            "description": "Mudroom - Arc Fault Protection to Circuit"
          },
          {
            "qty": 1,
            "amount": 295,
            "unit_price": 295,
            "description": "Mudroom - Wire Two New Light Fixtures"
          },
          {
            "qty": 1,
            "amount": 315,
            "unit_price": 315,
            "description": "Mudroom - Add Switch and Undercabinet light in Closet"
          },
          {
            "qty": 1,
            "amount": 75,
            "unit_price": 75,
            "description": "Mudroom - Outlet with Type C USB"
          },
          {
            "qty": 1,
            "amount": 120,
            "unit_price": 120,
            "description": "Staircase - Arc Fault Protection to Circuit"
          },
          {
            "qty": 13,
            "amount": 611,
            "unit_price": 47,
            "description": "Second Floor - 6\" LED Open Trim Replacement"
          },
          {
            "qty": 1,
            "amount": 75,
            "unit_price": 75,
            "description": "Primary Bathroom - Outlet with Type C USB"
          },
          {
            "qty": 1,
            "amount": 835,
            "unit_price": 835,
            "description": "Porch Repairs"
          },
          {
            "qty": 53,
            "amount": 1537,
            "unit_price": 29,
            "description": "Change Out Old Device to New Kasa Smart Switch (Home Owner to Provide Switches and Plates from Kasa)"
          },
          {
            "qty": 1,
            "amount": 225,
            "unit_price": 225,
            "description": "Kasa App Setup"
          },
          {
            "qty": 1,
            "amount": -9946.8,
            "unit_price": -9946.8,
            "description": "Payment Received For Invoice 2411004"
          }
        ],
        "vendor_name": "Liberty Electric Minnesota LLC",
        "invoice_date": "2025-03-12",
        "project_name": "5503 Lakeview Drive, Edina, MN 55424",
        "document_type": "invoice",
        "invoice_number": "25305",
        "is_billable_invoice": true
      }
    ]
  }
}