Invoice Record

05-10-2026-005-INV-001

Back to bill imports

Validation Error

Subtotal + tax + shipping does not match the invoice total within $0.05.

Status

Validation error

Invoice

INV-9001

Total

$150.00

Invoice data

Detected vendor: Validation Test Supplies LLC
Matched vendor: Unmatched
Matched alias: No alias
Category: Not assigned
Category method: Not selected
Invoice date: 05/09/2026
Due date: 06/08/2026
Vendor terms: Net 30
Jkath terms: Net 30
QB Transaction ID: Not created

File result

Final file: FergusonEnterprisesLLC_INV-2023372_test_VALIDATION-FAILED.pdf
Outcome: validation_failed
Details: Subtotal + tax + shipping does not match the invoice total within $0.05.

Processing Context

Invoice ID: 05-10-2026-005-INV-001
Run ID: 05-10-2026-005
Source folder: /_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 4-10/01 Unprocessed
Source file: FergusonEnterprisesLLC_INV-2023372_test.pdf

Stored payloads

Claude parse payload

{
  "tax": 8,
  "notes": "Total discrepancy: subtotal ($100.00) + tax ($8.00) + shipping ($0.00) = $108.00, but invoice states total as $150.00. The $150.00 total does not reconcile with the listed subtotal, tax, and shipping. Flagging for human review. Delivery surcharge line item has $0.00 amount and was excluded from line_items per rules. Bill-to name 'JKath' appears to be a user/account identifier; 'Portal Automation Test' used as project_name.",
  "terms": "Net 30",
  "total": 150,
  "due_date": "2026-06-08",
  "shipping": 0,
  "subtotal": 100,
  "confidence": {
    "total": 0.7,
    "vendor_name": 0.99,
    "invoice_date": 0.99,
    "project_name": 0.85,
    "invoice_number": 0.99
  },
  "line_items": [
    {
      "qty": 1,
      "amount": 100,
      "unit_price": 100,
      "description": "Test lumber bundle"
    }
  ],
  "vendor_name": "Validation Test Supplies LLC",
  "invoice_date": "2026-05-09",
  "project_name": "Portal Automation Test",
  "invoice_number": "INV-9001"
}

Vendor match payload

No payload stored.

QB payload

No payload stored.

Raw payload

{
  "run_id": "run_39675b719ce64ab0b9ca0cf3ecc04f72",
  "source": "make.com",
  "run_key": "05-10-2026-005",
  "make_trace_id": "make-20260509_225535_550",
  "source_file_name": "FergusonEnterprisesLLC_INV-2023372_test.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 4-10/01 Unprocessed/FergusonEnterprisesLLC_INV-2023372_test.pdf",
  "source_dropbox_id": "id:CHX6_xJiKhAAAAAAAABpIQ",
  "source_dropbox_rev": "016516dc11c472d00000003549f4393",
  "source_content_hash": "88fba9becc84fcaa79c9a81ca133e44bc76cc6c4e1ae4d1850e63bcebc66040f",
  "processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 4-10/02 Processing/FergusonEnterprisesLLC_INV-2023372_test.pdf",
  "processing_dropbox_rev": "016516dc3b10c4200000003549f4393"
}

Invoice Timeline

Time

05/09/2026

Event

FILE CLAIMED

Message

Source file claimed by Make scenario.

Payload

{
  "message": "Claimed invoice file and moved into processing.",
  "source_file_name": "FergusonEnterprisesLLC_INV-2023372_test.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 4-10/01 Unprocessed/FergusonEnterprisesLLC_INV-2023372_test.pdf",
  "processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 4-10/02 Processing/FergusonEnterprisesLLC_INV-2023372_test.pdf"
}

Time

05/09/2026

Event

PARSE COMPLETED

Message

Claude extraction parsed and stored.

Payload

{
  "message": "Claude extraction parsed and stored.",
  "process_key": "05-10-2026-005-INV-001",
  "claude_model": "claude-sonnet-4-6",
  "input_tokens": "2868",
  "make_trace_id": "make-20260509_225535_550",
  "output_tokens": "372",
  "bill_import_id": "bill_352a9905ef72467a93e7e1e6ea56bbf3",
  "source_file_name": "FergusonEnterprisesLLC_INV-2023372_test.pdf",
  "claude_message_id": "msg_01PuWHrFwJtXWC41pi8WNYnN"
}

Time

05/09/2026

Event

VALIDATION FAILED

Message

Subtotal + tax + shipping does not match the invoice total within $0.05.

Payload

{
  "total": "150",
  "message": "Validation failed; moved file to error folder.",
  "process_key": "05-10-2026-005-INV-001",
  "vendor_name": "Validation Test Supplies LLC",
  "invoice_date": "2026-05-09",
  "make_trace_id": "make-20260509_225535_550",
  "bill_import_id": "bill_352a9905ef72467a93e7e1e6ea56bbf3",
  "invoice_number": "INV-9001",
  "final_file_name": "FergusonEnterprisesLLC_INV-2023372_test_VALIDATION-FAILED.pdf",
  "final_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 4-10/04 Error/FergusonEnterprisesLLC_INV-2023372_test_VALIDATION-FAILED.pdf",
  "source_file_name": "FergusonEnterprisesLLC_INV-2023372_test.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 4-10/01 Unprocessed/FergusonEnterprisesLLC_INV-2023372_test.pdf",
  "sidecar_file_name": "FergusonEnterprisesLLC_INV-2023372_test_VALIDATION-FAILED.json",
  "sidecar_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 4-10/04 Error/FergusonEnterprisesLLC_INV-2023372_test_VALIDATION-FAILED.json",
  "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 4-10/02 Processing/FergusonEnterprisesLLC_INV-2023372_test.pdf"
}