Invoice Record
05-12-2026-027-INV-010
Validation Error
Subtotal + tax + shipping does not match the invoice total within $0.05.
Status
Validation error
Invoice
25305
Total
$6,596.20
Invoice data
- Detected vendor
- Liberty Electric Minnesota LLC
- Matched vendor
- Unmatched
- Matched alias
- No alias
- Category
- Not assigned
- Category method
- Not selected
- Invoice date
- 03/12/2025
- Due date
- 04/11/2025
- Vendor terms
- Net 30
- Jkath terms
- Net 30
- QB Transaction ID
- Not created
File result
- Outcome
- validation_failed
- Details
- Subtotal + tax + shipping does not match the invoice total within $0.05.
Processing Context
- Invoice ID
- 05-12-2026-027-INV-010
- Run ID
- 05-12-2026-027
- Source folder
- /_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed
- Source file
- Liberty Electric Minnesota LLC Invoice 25305.pdf
Stored payloads
Claude parse payload
{
"tax": 0,
"notes": "Invoice includes a credit of -$9,946.80 for a prior payment received (Invoice 2411004), resulting in a balance due of $6,596.20. The gross total before the payment credit is $16,543.00. The total field reflects the net balance due as printed on the invoice. Jobsite address used as project name since no named project was listed.",
"terms": "Net 30",
"total": 6596.2,
"due_date": "2025-04-11",
"shipping": 0,
"subtotal": 16543,
"confidence": {
"total": 0.99,
"vendor_name": 0.99,
"invoice_date": 0.99,
"project_name": 0.95,
"invoice_number": 0.99
},
"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
}Vendor match payload
No payload stored.
QB payload
No payload stored.
Raw payload
{
"run_id": "run_594bd3eabfc6479e8864a025f93b86a9",
"source": "make.com",
"run_key": "05-12-2026-027",
"make_trace_id": "make-20260511_232719_376",
"source_file_name": "Liberty Electric Minnesota LLC Invoice 25305.pdf",
"source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/Liberty Electric Minnesota LLC Invoice 25305.pdf",
"source_dropbox_id": "id:CHX6_xJiKhAAAAAAAABijw",
"source_dropbox_rev": "016519746b8c4f200000003549f4393",
"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.pdf",
"multi_invoice_group_id": "bill_0ffc83e5be4c4406b1f8b2558bedace0",
"processing_dropbox_rev": "016519752213e7600000003549f4393",
"multi_invoice_source_payload": {
"notes": "Single invoice document. Invoice #25305 from Liberty Electric Minnesota LLC dated 03/12/2025. Contains a prior payment credit of -$9,946.80 applied against a gross amount of $16,543.00, yielding a balance due of $6,596.20.",
"invoices": [
{
"tax": 0,
"notes": "Invoice includes a credit of -$9,946.80 for a prior payment received (Invoice 2411004), resulting in a balance due of $6,596.20. The gross total before the payment credit is $16,543.00. The total field reflects the net balance due as printed on the invoice. Jobsite address used as project name since no named project was listed.",
"terms": "Net 30",
"total": 6596.2,
"due_date": "2025-04-11",
"shipping": 0,
"subtotal": 16543,
"confidence": {
"total": 0.99,
"vendor_name": 0.99,
"invoice_date": 0.99,
"project_name": 0.95,
"invoice_number": 0.99
},
"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
}
]
}
}Invoice Timeline
Time
05/11/2026
Event
FILE CLAIMED
Message
Source file claimed by Make scenario.
Payload
{
"message": "Claimed invoice file and moved into processing.",
"source_file_name": "Liberty Electric Minnesota LLC Invoice 25305.pdf",
"source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/Liberty Electric Minnesota LLC Invoice 25305.pdf",
"processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/Liberty Electric Minnesota LLC Invoice 25305.pdf"
}Time
05/11/2026
Event
PARSE COMPLETED
Message
Claude extraction parsed and stored.
Payload
{
"total": "6596.20",
"message": "Claude extraction parsed and stored.",
"due_date": "2025-04-11",
"jkath_terms": "Net 30",
"process_key": "05-12-2026-027-INV-010",
"vendor_name": "Liberty Electric Minnesota LLC",
"claude_model": "claude-sonnet-4-6",
"input_tokens": "7540",
"invoice_date": "2025-03-12",
"vendor_terms": "Net 30",
"make_trace_id": "make-20260511_232719_376",
"output_tokens": "2664",
"bill_import_id": "bill_0ffc83e5be4c4406b1f8b2558bedace0",
"invoice_number": "25305",
"vendor_due_date": "2025-04-11",
"source_file_name": "Liberty Electric Minnesota LLC Invoice 25305.pdf",
"claude_message_id": "msg_01PKawneFh4vs5yF4yNb2Ddk",
"multi_invoice_count": 1,
"multi_invoice_index": 1
}Time
05/11/2026
Event
VALIDATION FAILED
Message
Subtotal + tax + shipping does not match the invoice total within $0.05.
Payload
{
"total": "6596.20",
"message": "Validation failed; moved file to error folder.",
"process_key": "05-12-2026-027-INV-010",
"vendor_name": "Liberty Electric Minnesota LLC",
"invoice_date": "2025-03-12",
"make_trace_id": "make-20260511_232719_376",
"bill_import_id": "bill_0ffc83e5be4c4406b1f8b2558bedace0",
"invoice_number": "25305",
"final_file_name": "Liberty Electric Minnesota LLC Invoice 25305_VALIDATION-FAILED.pdf",
"final_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/04 Error/Liberty Electric Minnesota LLC Invoice 25305_VALIDATION-FAILED.pdf",
"source_file_name": "Liberty Electric Minnesota LLC Invoice 25305.pdf",
"source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/Liberty Electric Minnesota LLC Invoice 25305.pdf",
"dropbox_shared_url": "https://www.dropbox.com/scl/fi/jvkdrdm4lm4wpumm2i23c/Liberty-Electric-Minnesota-LLC-Invoice-25305_VALIDATION-FAILED.pdf?rlkey=x840tsvs9bcm6baln1xq839yd&dl=0",
"validation_details": "Subtotal + tax + shipping does not match the invoice total within $0.05.",
"processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/Liberty Electric Minnesota LLC Invoice 25305.pdf"
}