05-11-2026-014-INV-005

{
  "tax": 0,
  "notes": "Invoice is overdue as of 02/06/2026. A deposit of $1,555.50 has been recorded, leaving a balance due of $1,509.50; however, the total billed on this invoice is $3,065.00 and is used as the 'total' field per instructions. The credit card service charge line item ($46.00) is included in the subtotal and line items. Shipping ($24.00) is listed separately outside the subtotal and is reflected in the shipping field. Line item 5 description shows '2700l' which may be a typo for '2700k'.",
  "terms": "50% down, 50% at delivery",
  "total": 3065,
  "due_date": "2026-02-06",
  "shipping": 24,
  "subtotal": 3041,
  "confidence": {
    "total": 0.99,
    "vendor_name": 0.99,
    "invoice_date": 0.99,
    "project_name": 0.99,
    "invoice_number": 0.99
  },
  "line_items": [
    {
      "qty": 2,
      "amount": 642,
      "unit_price": 321,
      "description": "Bath light - CW1202BBS, Kenyon 24\" Picture Light (Notes: Requires smaller outlet box)"
    },
    {
      "qty": 11,
      "amount": 1881,
      "unit_price": 171,
      "description": "Flush mount - 7579452-848, Morrison Morrison modern 2-light indoor dimmable ceiling flush mount in satin brass gold finish with smooth white glass shade"
    },
    {
      "qty": 22,
      "amount": 264,
      "unit_price": 12,
      "description": "Bulbs - 60 Watt White LED Equiv. A E26 - 2700k, Dimmable"
    },
    {
      "qty": 1,
      "amount": 196,
      "unit_price": 196,
      "description": "Ceiling fixtures - 16-1214, Cally Ceramic Pendant Small"
    },
    {
      "qty": 1,
      "amount": 12,
      "unit_price": 12,
      "description": "Bulbs - 60 Watt White LED Equiv. A E26 - 2700l, Dimmable"
    },
    {
      "qty": 1,
      "amount": 46,
      "unit_price": 46,
      "description": "Credit Card service charge"
    }
  ],
  "vendor_name": "The Brands at Rabbit Creek",
  "invoice_date": "2026-01-26",
  "project_name": "Hidden Creek Trail",
  "invoice_number": "10947"
}

{
  "alias_lookup": {
    "found": true,
    "alias_id": "alias_9c46512b0ff84fbc968c9638e67896ff",
    "vendor_id": "vend_3b6497ef80064fe786570a68637d21fd",
    "alias_name": "The Brands at Rabbit Creek",
    "canonical_name": "The Brands at Rabbit Creek",
    "category_count": 1,
    "category_options": [
      {
        "name": "Lighting",
        "notes": "Mapped from JKath historical QuickBooks export: Building Materials:Lighting (23).",
        "expense_category_id": "cat_2821cbfb508544c695dd3151779fca1c",
        "fully_qualified_name": "Building Materials:Lighting",
        "quickbooks_account_id": "110",
        "vendor_expense_category_id": "cmp1bawns002e13pf9bu7vqmk"
      }
    ],
    "expense_category_id": "cat_2821cbfb508544c695dd3151779fca1c",
    "normalized_alias_key": "the brands at rabbit creek",
    "quickbooks_vendor_id": "84",
    "quickbooks_account_id": "110",
    "default_expense_account": "Lighting",
    "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": "Lighting",
    "expense_category_id": "cat_2821cbfb508544c695dd3151779fca1c",
    "quickbooks_account_id": "110",
    "selected_expense_category_id": "cat_2821cbfb508544c695dd3151779fca1c",
    "selected_expense_category_name": "Lighting"
  }
}

{
  "lookup": {
    "quickbooks_vendor_id": "84",
    "quickbooks_account_id": "110",
    "existing_quickbooks_bill_id": null
  },
  "bill_created": {
    "path": "single_category_direct",
    "total": "3065",
    "doc_number": "10947",
    "vendor_ref": "84",
    "account_ref": "110",
    "quickbooks_bill_id": "240",
    "resolved_expense_category_id": "cat_2821cbfb508544c695dd3151779fca1c"
  },
  "attachment_uploaded": {
    "path": "single_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "240"
  }
}

{
  "run_id": "run_3cc7b33d630f49bf9e305f1e8611ec19",
  "source": "make.com",
  "run_key": "05-11-2026-014",
  "make_trace_id": "make-20260511_113003_374",
  "source_file_name": "TheBrandsatRabbitCreek_INV-10947.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/TheBrandsatRabbitCreek_INV-10947.pdf",
  "source_dropbox_id": "id:CHX6_xJiKhAAAAAAAABpYw",
  "source_dropbox_rev": "016518d4193220d00000003549f4393",
  "source_content_hash": "fd25f6f674ae19fa69ac9b48476cb035002941bb6cc9e708d09c4aebafc0f4f8",
  "processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/TheBrandsatRabbitCreek_INV-10947.pdf",
  "processing_dropbox_rev": "016518d46e349ca00000003549f4393"
}