05-12-2026-034-INV-013

{
  "tax": 179.25,
  "notes": "Single 3-page invoice. Customer PO No listed as 'W River Parkway', used as project_name. Taxable subtotal is 2205.58, sales tax 179.25, freight 0.00, misc 0.00, total due 2384.83. Freight is listed as 0.00 on the invoice summary so shipping set to 0. Note on item RS448.TPF58.14.1: 'TRUCK/BREAKDOWN POSSIBLE'.",
  "terms": "1%-10th Net 30",
  "total": 2384.83,
  "due_date": "2025-05-30",
  "shipping": 0,
  "subtotal": 2205.58,
  "confidence": {
    "total": 0.99,
    "vendor_name": 0.99,
    "invoice_date": 0.99,
    "project_name": 0.95,
    "invoice_number": 0.99
  },
  "line_items": [
    {
      "qty": 2,
      "amount": 5.34,
      "unit_price": 2.67,
      "description": "B970.1002 - Blumotion Insert F/Doors End Panel"
    },
    {
      "qty": 2,
      "amount": 2.38,
      "unit_price": 1.19,
      "description": "B970.5701 - Blumotion Sgl FF Adapt Pl/Scr ZINC (2 - 6x58F ZC)"
    },
    {
      "qty": 1,
      "amount": 23,
      "unit_price": 23,
      "description": "FS494938 - Tenons BeechWood 5x19x30mm 300ea"
    },
    {
      "qty": 10,
      "amount": 178.7,
      "unit_price": 17.87,
      "description": "B563H 4570B - 18 Tndm SoftCl 5/8mat Fullext 100lb 6-7X58F NI"
    },
    {
      "qty": 1,
      "amount": 20.22,
      "unit_price": 20.22,
      "description": "B563H 3050B - 12 Tndm SoftCl 5/8mat Fullext 100lb 6-7X58F NI"
    },
    {
      "qty": 17,
      "amount": 312.63,
      "unit_price": 18.39,
      "description": "B563H 5330B - 21 Tndm SoftCl 5/8mat Fullext 100lb 6-7X58F NI"
    },
    {
      "qty": 12,
      "amount": 23.52,
      "unit_price": 1.96,
      "description": "H262.50.322 - Keku PushOn Fit SystemScrw BK asbly (SEND 1 MALE & 1 FEMALE)"
    },
    {
      "qty": 2,
      "amount": 26.16,
      "unit_price": 13.08,
      "description": "B20K1301 - Aventos HK-XS Stay Lift PF 61-112"
    },
    {
      "qty": 2,
      "amount": 2.6,
      "unit_price": 1.3,
      "description": "B20K4101 - Aventos HK-XS Wood/Alum. MT. Plate (2-6x58F NI)"
    },
    {
      "qty": 2,
      "amount": 3.62,
      "unit_price": 1.81,
      "description": "B20K51E1 - Aventos HK-XS CAB MT Plate Expando"
    },
    {
      "qty": 1,
      "amount": 261.46,
      "unit_price": 261.46,
      "description": "RS4WCSC.1835DM.2 - 35Qt Dbl BM/DM Wood SoftCL SLVR Bin"
    },
    {
      "qty": 1,
      "amount": 61.19,
      "unit_price": 61.19,
      "description": "RS4WCT.3 - Maple CutleryTray 20-5/8W to 14.25W"
    },
    {
      "qty": 1,
      "amount": 73.26,
      "unit_price": 73.26,
      "description": "RS4WKB.1 - Maple Knife Block Insert 18.5W x22D"
    },
    {
      "qty": 1,
      "amount": 667.37,
      "unit_price": 667.37,
      "description": "RS448.TPF58.14.1 - 14.5W 6-ShelfPantry SoftCl 58.5-66H (TRUCK/BREAKDOWN POSSIBLE)"
    },
    {
      "qty": 1,
      "amount": 72.88,
      "unit_price": 72.88,
      "description": "RS4SDI.24 - Wood SpiceDrawer Insert 22W"
    },
    {
      "qty": 1,
      "amount": 63.02,
      "unit_price": 63.02,
      "description": "RS4WUT.3 - Maple UtilityTray 24W to 12W"
    },
    {
      "qty": 34,
      "amount": 147.22,
      "unit_price": 4.33,
      "description": "B071B3590 - 110 Full-OL Soft Close Inserta PADS"
    },
    {
      "qty": 38,
      "amount": 97.28,
      "unit_price": 2.56,
      "description": "B071T3590 - 110 Full-OL Self Close Inserta PADS"
    },
    {
      "qty": 72,
      "amount": 61.2,
      "unit_price": 0.85,
      "description": "B175H910 - 0mm Plate No.7wood or SystemScrew (2-7X58F NI)"
    },
    {
      "qty": 112,
      "amount": 11.42,
      "unit_price": 0.102,
      "description": "3MSJ5312 - Bumper Pad 1/8in x 1/2in dia CLEAR"
    },
    {
      "qty": 3,
      "amount": 7.62,
      "unit_price": 2.54,
      "description": "BT51.1801 - Tndm Lock Device Standard L/R ASBLY (L/R & 4-7X12PZC)"
    },
    {
      "qty": 25,
      "amount": 77,
      "unit_price": 3.08,
      "description": "BT51.1901 - Tandm LockDevice Standard L/R ASBLY (L/R & 4-6X58FH NI)"
    },
    {
      "qty": 110,
      "amount": 6.49,
      "unit_price": 0.059,
      "description": "THB6144 - 5mm Spoon Shelf Support NICKEL"
    }
  ],
  "vendor_name": "Hardware Distributors",
  "invoice_date": "2025-04-14",
  "project_name": "W River Parkway",
  "document_type": "invoice",
  "invoice_number": "801037346",
  "is_billable_invoice": true
}

{
  "alias_lookup": {
    "found": true,
    "alias_id": "cmp1abb7c001uagtbk30htlml",
    "vendor_id": "vend_36536bc3a7254b41ac0081eab30ee4d2",
    "alias_name": "Hardware Distributors",
    "canonical_name": "Hardware Distributors Ltd",
    "category_count": 1,
    "category_options": [
      {
        "name": "Cabinet Materials",
        "notes": "Mapped from JKath historical QuickBooks export: Building Materials:Cabinet Materials (104).",
        "expense_category_id": "cat_8d2d70e75bdd439fb2060c07463e1a62",
        "fully_qualified_name": "Building Materials:Cabinet Materials",
        "quickbooks_account_id": "105",
        "vendor_expense_category_id": "cmp1bauq8001a13pfeqelj5gn"
      }
    ],
    "expense_category_id": "cat_8d2d70e75bdd439fb2060c07463e1a62",
    "normalized_alias_key": "hardware distributors",
    "quickbooks_vendor_id": "2",
    "quickbooks_account_id": "105",
    "default_expense_account": "Cabinet Materials",
    "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": "Cabinet Materials",
    "expense_category_id": "cat_8d2d70e75bdd439fb2060c07463e1a62",
    "quickbooks_account_id": "105",
    "selected_expense_category_id": "cat_8d2d70e75bdd439fb2060c07463e1a62",
    "selected_expense_category_name": "Cabinet Materials"
  }
}

{
  "lookup": {
    "quickbooks_vendor_id": "2",
    "quickbooks_account_id": "105",
    "existing_quickbooks_bill_id": null
  },
  "bill_created": {
    "path": "single_category_direct",
    "total": "2384.83",
    "due_date": "2025-05-14",
    "doc_number": "801037346",
    "vendor_ref": "2",
    "account_ref": "105",
    "jkath_terms": "Net 30",
    "vendor_terms": "1%-10th Net 30",
    "quickbooks_bill_id": "371",
    "resolved_expense_category_id": "cat_8d2d70e75bdd439fb2060c07463e1a62"
  },
  "attachment_uploaded": {
    "path": "single_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "371"
  }
}

{
  "run_id": "run_9439f1b0f66f4d91979fe2e03399dbfd",
  "source": "make.com",
  "run_key": "05-12-2026-034",
  "make_trace_id": "make-20260512_004507_068",
  "source_file_name": "HDLInvoice 801037346.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/HDLInvoice 801037346.pdf",
  "source_dropbox_id": "id:CHX6_xJiKhAAAAAAAABjSw",
  "source_dropbox_rev": "01651985d8eaa9000000003549f4393",
  "multi_invoice_count": 1,
  "multi_invoice_index": 1,
  "source_content_hash": "f3de64e32ac90ee0ee8cfbec1990fc5fb90293751874b609eb6b967a3969be98",
  "processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/HDLInvoice 801037346.pdf",
  "multi_invoice_group_id": "bill_b38e525441d345e78ee9ee2f32f49e53",
  "processing_dropbox_rev": "01651986b48924d00000003549f4393",
  "multi_invoice_source_payload": {
    "notes": "PDF contains a single 3-page invoice (Invoice No. 801037346) from Hardware Distributors Ltd to J Kath LLC. All pages belong to the same invoice. No multiple invoices detected.",
    "invoices": [
      {
        "tax": 179.25,
        "notes": "Single 3-page invoice. Customer PO No listed as 'W River Parkway', used as project_name. Taxable subtotal is 2205.58, sales tax 179.25, freight 0.00, misc 0.00, total due 2384.83. Freight is listed as 0.00 on the invoice summary so shipping set to 0. Note on item RS448.TPF58.14.1: 'TRUCK/BREAKDOWN POSSIBLE'.",
        "terms": "1%-10th Net 30",
        "total": 2384.83,
        "due_date": "2025-05-30",
        "shipping": 0,
        "subtotal": 2205.58,
        "confidence": {
          "total": 0.99,
          "vendor_name": 0.99,
          "invoice_date": 0.99,
          "project_name": 0.95,
          "invoice_number": 0.99
        },
        "line_items": [
          {
            "qty": 2,
            "amount": 5.34,
            "unit_price": 2.67,
            "description": "B970.1002 - Blumotion Insert F/Doors End Panel"
          },
          {
            "qty": 2,
            "amount": 2.38,
            "unit_price": 1.19,
            "description": "B970.5701 - Blumotion Sgl FF Adapt Pl/Scr ZINC (2 - 6x58F ZC)"
          },
          {
            "qty": 1,
            "amount": 23,
            "unit_price": 23,
            "description": "FS494938 - Tenons BeechWood 5x19x30mm 300ea"
          },
          {
            "qty": 10,
            "amount": 178.7,
            "unit_price": 17.87,
            "description": "B563H 4570B - 18 Tndm SoftCl 5/8mat Fullext 100lb 6-7X58F NI"
          },
          {
            "qty": 1,
            "amount": 20.22,
            "unit_price": 20.22,
            "description": "B563H 3050B - 12 Tndm SoftCl 5/8mat Fullext 100lb 6-7X58F NI"
          },
          {
            "qty": 17,
            "amount": 312.63,
            "unit_price": 18.39,
            "description": "B563H 5330B - 21 Tndm SoftCl 5/8mat Fullext 100lb 6-7X58F NI"
          },
          {
            "qty": 12,
            "amount": 23.52,
            "unit_price": 1.96,
            "description": "H262.50.322 - Keku PushOn Fit SystemScrw BK asbly (SEND 1 MALE & 1 FEMALE)"
          },
          {
            "qty": 2,
            "amount": 26.16,
            "unit_price": 13.08,
            "description": "B20K1301 - Aventos HK-XS Stay Lift PF 61-112"
          },
          {
            "qty": 2,
            "amount": 2.6,
            "unit_price": 1.3,
            "description": "B20K4101 - Aventos HK-XS Wood/Alum. MT. Plate (2-6x58F NI)"
          },
          {
            "qty": 2,
            "amount": 3.62,
            "unit_price": 1.81,
            "description": "B20K51E1 - Aventos HK-XS CAB MT Plate Expando"
          },
          {
            "qty": 1,
            "amount": 261.46,
            "unit_price": 261.46,
            "description": "RS4WCSC.1835DM.2 - 35Qt Dbl BM/DM Wood SoftCL SLVR Bin"
          },
          {
            "qty": 1,
            "amount": 61.19,
            "unit_price": 61.19,
            "description": "RS4WCT.3 - Maple CutleryTray 20-5/8W to 14.25W"
          },
          {
            "qty": 1,
            "amount": 73.26,
            "unit_price": 73.26,
            "description": "RS4WKB.1 - Maple Knife Block Insert 18.5W x22D"
          },
          {
            "qty": 1,
            "amount": 667.37,
            "unit_price": 667.37,
            "description": "RS448.TPF58.14.1 - 14.5W 6-ShelfPantry SoftCl 58.5-66H (TRUCK/BREAKDOWN POSSIBLE)"
          },
          {
            "qty": 1,
            "amount": 72.88,
            "unit_price": 72.88,
            "description": "RS4SDI.24 - Wood SpiceDrawer Insert 22W"
          },
          {
            "qty": 1,
            "amount": 63.02,
            "unit_price": 63.02,
            "description": "RS4WUT.3 - Maple UtilityTray 24W to 12W"
          },
          {
            "qty": 34,
            "amount": 147.22,
            "unit_price": 4.33,
            "description": "B071B3590 - 110 Full-OL Soft Close Inserta PADS"
          },
          {
            "qty": 38,
            "amount": 97.28,
            "unit_price": 2.56,
            "description": "B071T3590 - 110 Full-OL Self Close Inserta PADS"
          },
          {
            "qty": 72,
            "amount": 61.2,
            "unit_price": 0.85,
            "description": "B175H910 - 0mm Plate No.7wood or SystemScrew (2-7X58F NI)"
          },
          {
            "qty": 112,
            "amount": 11.42,
            "unit_price": 0.102,
            "description": "3MSJ5312 - Bumper Pad 1/8in x 1/2in dia CLEAR"
          },
          {
            "qty": 3,
            "amount": 7.62,
            "unit_price": 2.54,
            "description": "BT51.1801 - Tndm Lock Device Standard L/R ASBLY (L/R & 4-7X12PZC)"
          },
          {
            "qty": 25,
            "amount": 77,
            "unit_price": 3.08,
            "description": "BT51.1901 - Tandm LockDevice Standard L/R ASBLY (L/R & 4-6X58FH NI)"
          },
          {
            "qty": 110,
            "amount": 6.49,
            "unit_price": 0.059,
            "description": "THB6144 - 5mm Spoon Shelf Support NICKEL"
          }
        ],
        "vendor_name": "Hardware Distributors",
        "invoice_date": "2025-04-14",
        "project_name": "W River Parkway",
        "document_type": "invoice",
        "invoice_number": "801037346",
        "is_billable_invoice": true
      }
    ]
  }
}