05-12-2026-047-INV-001

{
  "tax": 0,
  "notes": "Per vendor-specific processing notes, the fuel surcharge (FSC @ 31.25% = $112.34) appears both as a line item and again in the invoice footer summary as 'FUEL SURCHARGE $112.34'. The footer instance is ignored to avoid double-counting. The printed PDF subtotal of $624.49 excludes the FSC; however, per financial reconciliation rules, subtotal is set to the sum of all line_items ($736.83) since all charges including FSC are represented in line_items. Order #: V17844, P.O. #: Ethan Bowman. Origin: Mendota Heights, MN 55120. Destination: Ethan Bowman, Nickelsville, VA 24271. Freight class: 100.0, 125.0.",
  "terms": "Net 30 days from invoice date",
  "total": 736.83,
  "due_date": "2025-05-30",
  "shipping": 0,
  "subtotal": 736.83,
  "confidence": {
    "total": 1,
    "vendor_name": 1,
    "invoice_date": 1,
    "project_name": 1,
    "invoice_number": 1
  },
  "line_items": [
    {
      "qty": 2,
      "amount": 359.49,
      "unit_price": null,
      "description": "Base Rate - 2 Pallets, 670 lbs (Bathroom Vanities/Cabinets Without Tops)"
    },
    {
      "qty": 1,
      "amount": 112.34,
      "unit_price": null,
      "description": "Fuel Surcharge (FSC) @ 31.25%"
    },
    {
      "qty": 1,
      "amount": 30,
      "unit_price": 30,
      "description": "Appointment Fee"
    },
    {
      "qty": 1,
      "amount": 95,
      "unit_price": 95,
      "description": "Liftgate Delivery"
    },
    {
      "qty": 1,
      "amount": 45,
      "unit_price": 45,
      "description": "Reweigh"
    },
    {
      "qty": 1,
      "amount": 95,
      "unit_price": 95,
      "description": "Residential Delivery"
    }
  ],
  "vendor_name": "King Solutions Inc.",
  "invoice_date": "2025-04-30",
  "project_name": "Fairmount Murphy",
  "document_type": "invoice",
  "invoice_number": "1816879",
  "is_billable_invoice": true
}

{
  "alias_lookup": {
    "found": true,
    "alias_id": "cmp1abfgk0054agtbv0s4fnqw",
    "vendor_id": "vend_dcf5570c588d4e11a5337df1a05053a0",
    "alias_name": "King Solutions, Inc",
    "canonical_name": "King Solutions Inc.",
    "category_count": 1,
    "category_options": [
      {
        "name": "Carpentry",
        "notes": "Mapped from JKath historical QuickBooks export: Building Services:Carpentry (17).",
        "expense_category_id": "cat_db2397f2decd44ecbd79b1ad8107f459",
        "fully_qualified_name": "Building Services:Carpentry",
        "quickbooks_account_id": "119",
        "vendor_expense_category_id": "cmp1baybg003c13pffdalfc8c"
      }
    ],
    "expense_category_id": "cat_db2397f2decd44ecbd79b1ad8107f459",
    "normalized_alias_key": "king solutions inc",
    "quickbooks_vendor_id": "108",
    "quickbooks_account_id": "119",
    "default_expense_account": "Carpentry",
    "invoice_processing_notes": "This vendor's invoices sometimes has the fuel surcharge listed twice.  both in the itemized list at the top as 'FSC@.....' and then again at the bottom.  ignore the bottom duplicated instance when calculating and verifying the total.",
    "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": "Carpentry",
    "expense_category_id": "cat_db2397f2decd44ecbd79b1ad8107f459",
    "quickbooks_account_id": "119",
    "selected_expense_category_id": "cat_db2397f2decd44ecbd79b1ad8107f459",
    "selected_expense_category_name": "Carpentry"
  }
}

{
  "lookup": {
    "quickbooks_vendor_id": "108",
    "quickbooks_account_id": "119",
    "existing_quickbooks_bill_id": null
  },
  "bill_created": {
    "path": "single_category_direct",
    "total": "736.83",
    "due_date": "2025-05-30",
    "doc_number": "1816879",
    "vendor_ref": "108",
    "account_ref": "119",
    "jkath_terms": "Net 30",
    "vendor_terms": "Net 30 days from invoice date",
    "quickbooks_bill_id": "420",
    "resolved_expense_category_id": "cat_db2397f2decd44ecbd79b1ad8107f459"
  },
  "attachment_uploaded": {
    "path": "single_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "420"
  }
}

{
  "run_id": "run_23ed689aff964c8196bc251ed51ba3af",
  "source": "make.com",
  "run_key": "05-12-2026-047",
  "make_trace_id": "make-20260512_130325_277",
  "source_file_name": "INV_1816879_VALIDATION-FAILED.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/INV_1816879_VALIDATION-FAILED.pdf",
  "source_dropbox_id": "id:CHX6_xJiKhAAAAAAAABg_w",
  "source_dropbox_rev": "01651a2381393f100000003549f4393",
  "multi_invoice_count": 1,
  "multi_invoice_index": 1,
  "source_content_hash": "bd753672a45d81770c31861e775df16bc2fa15806c3de04177f8d61fc16849d8",
  "processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/INV_1816879_VALIDATION-FAILED.pdf",
  "multi_invoice_group_id": "bill_402bacd3612843a5ba4220217534d878",
  "processing_dropbox_rev": "01651a2ae16e5db00000003549f4393",
  "multi_invoice_source_payload": {
    "notes": "Single invoice PDF from King Solutions Inc. Fuel surcharge duplication handled per vendor-specific instructions.",
    "invoices": [
      {
        "tax": 0,
        "notes": "Per vendor-specific processing notes, the fuel surcharge (FSC @ 31.25% = $112.34) appears both as a line item and again in the invoice footer summary as 'FUEL SURCHARGE $112.34'. The footer instance is ignored to avoid double-counting. The printed PDF subtotal of $624.49 excludes the FSC; however, per financial reconciliation rules, subtotal is set to the sum of all line_items ($736.83) since all charges including FSC are represented in line_items. Order #: V17844, P.O. #: Ethan Bowman. Origin: Mendota Heights, MN 55120. Destination: Ethan Bowman, Nickelsville, VA 24271. Freight class: 100.0, 125.0.",
        "terms": "Net 30 days from invoice date",
        "total": 736.83,
        "due_date": "2025-05-30",
        "shipping": 0,
        "subtotal": 736.83,
        "confidence": {
          "total": 1,
          "vendor_name": 1,
          "invoice_date": 1,
          "project_name": 1,
          "invoice_number": 1
        },
        "line_items": [
          {
            "qty": 2,
            "amount": 359.49,
            "unit_price": null,
            "description": "Base Rate - 2 Pallets, 670 lbs (Bathroom Vanities/Cabinets Without Tops)"
          },
          {
            "qty": 1,
            "amount": 112.34,
            "unit_price": null,
            "description": "Fuel Surcharge (FSC) @ 31.25%"
          },
          {
            "qty": 1,
            "amount": 30,
            "unit_price": 30,
            "description": "Appointment Fee"
          },
          {
            "qty": 1,
            "amount": 95,
            "unit_price": 95,
            "description": "Liftgate Delivery"
          },
          {
            "qty": 1,
            "amount": 45,
            "unit_price": 45,
            "description": "Reweigh"
          },
          {
            "qty": 1,
            "amount": 95,
            "unit_price": 95,
            "description": "Residential Delivery"
          }
        ],
        "vendor_name": "King Solutions Inc.",
        "invoice_date": "2025-04-30",
        "project_name": "Fairmount Murphy",
        "document_type": "invoice",
        "invoice_number": "1816879",
        "is_billable_invoice": true
      }
    ]
  }
}