VANTYX LABS / SPEND INTELLIGENCE

48-Hour LLM Spend Reconciliation

A deterministic, source-linked diagnostic of supplied LLM usage and billing exports.

DEMONSTRATION ONLYSYNTHETIC DATANOT CUSTOMER RESULT

Audit scope

What was analyzed

Analysis ID: diag_108c3507db7c171b256d2b24
Organizationsynthetic-org-001Providersanthropic, openaiPeriod2026-07-01T00:00:00Z — 2026-08-01T00:00:00ZCurrencyUSD

Executive reconciliation

Observed totals

Explicit usage cost$150.000000
Customer-supplied billed amount$154.000000
Customer-supplied billing minus usage$4.000000
Monetary reconciliationSUPPORTED
Customer-supplied billing minus usage is calculated only where every canonical usage row contains explicit cost. Token counts are never repriced from an external or mutable rate card.

Exception register

Reconciliation findings

4 finding rows
ProviderFindingStatusObservedRecordsConfidenceAudit note
anthropicRECONCILIATION_VARIANCEbilling amount minus explicit canonical usage amountVARIANCE-1.000000 USD2CONFIRMED_ARITHMETICLimit: The supplied sources do not establish the cause of a non-zero variance.
Next check: Verify the provider aggregate against the source-owner reporting boundary and mappings.
openaiRECONCILIATION_VARIANCEbilling amount minus explicit canonical usage amountVARIANCE5.000000 USD3CONFIRMED_ARITHMETICLimit: The supplied sources do not establish the cause of a non-zero variance.
Next check: Verify the provider aggregate against the source-owner reporting boundary and mappings.
openaiDUPLICATE_USAGE_RECORD1 exact duplicate usage row(s) excluded; each duplicate_of link remains in normalized_spend.csvEXCLUDED_FROM_USAGE_TOTALN/A1CONFIRMED_EXACT_MATCHLimit: Exact normalized duplication does not establish why the source repeated the record; evidence_refs are capped at 20 rows.
Next check: Confirm the duplicate export row with the source owner before removing it upstream.
anthropicUNMAPPED_DIMENSION2 canonical usage record(s) have no project_id valueREVIEWN/A2CONFIRMED_MISSING_VALUELimit: No monetary amount is assigned to an absent dimension without an explicit cost-bearing mapping.
Next check: Confirm whether the source can be exported or mapped with project_id grouping.

Decision support

Prioritized next checks

Observed data only
1

Verify the anthropic billing-to-usage variance against the supplied source records.

Observed billing-minus-usage variance: -1.000000 USD.

Evidence: sha256:56d8291840c442e32b0538c10f713a0d93cd46235152b03cd8960c377ecb92f2:row:1 | sha256:56d8291840c442e32b0538c10f713a0d93cd46235152b03cd8960c377ecb92f2:row:2 | sha256:64a9c726554f8375b87694b44a1d0f9174de1d786a43d6b11559991d7649db0e:row:2

OBSERVED_DATA
2

Verify the openai billing-to-usage variance against the supplied source records.

Observed billing-minus-usage variance: 5.000000 USD.

Evidence: sha256:9d989497c6bc8f8d4c8ba11ff6462ce328c73af32fa7279d466e7e7a0455c44d:row:2 | sha256:9d989497c6bc8f8d4c8ba11ff6462ce328c73af32fa7279d466e7e7a0455c44d:row:3 | sha256:9d989497c6bc8f8d4c8ba11ff6462ce328c73af32fa7279d466e7e7a0455c44d:row:4 | sha256:a3d1244bcb8ab0d83c82cc5c144f8ddb385a4fa97a2b019379ba18485503881f:row:1

OBSERVED_DATA
3

Confirm whether the source can be exported or mapped with project_id grouping.

2 canonical usage record(s) have no project_id value

Evidence: sha256:56d8291840c442e32b0538c10f713a0d93cd46235152b03cd8960c377ecb92f2:row:1 | sha256:56d8291840c442e32b0538c10f713a0d93cd46235152b03cd8960c377ecb92f2:row:2

OBSERVED_DATA
4

Remove exact duplicate export rows before using usage totals downstream.

1 exact duplicate row(s) were excluded from reconciliation.

Evidence: sha256:9d989497c6bc8f8d4c8ba11ff6462ce328c73af32fa7279d466e7e7a0455c44d:row:5

OBSERVED_DATA
5

Review observed openai retry attempts and confirm whether each retry was necessary.

1 row(s) identify an attempt number greater than one.

Evidence: sha256:9d989497c6bc8f8d4c8ba11ff6462ce328c73af32fa7279d466e7e7a0455c44d:row:4

OBSERVED_DATA

Data lineage

Source coverage

Source fileSHA-256KindProviderSchemaRowsCompleteLimitations
synthetic-anthropic-billing.csv64a9c726554f8375b87694b44a1d0f9174de1d786a43d6b11559991d7649db0ebillinganthropiccanonical_flat_v11YESCustomer-supplied normalized values are not independently repriced.
synthetic-openai-billing.jsona3d1244bcb8ab0d83c82cc5c144f8ddb385a4fa97a2b019379ba18485503881fbillingopenaicanonical_flat_v11YESCustomer-supplied normalized values are not independently repriced.
synthetic-anthropic-usage.json56d8291840c442e32b0538c10f713a0d93cd46235152b03cd8960c377ecb92f2usageanthropiccanonical_flat_v12YESCustomer-supplied normalized values are not independently repriced.
synthetic-openai-usage.csv9d989497c6bc8f8d4c8ba11ff6462ce328c73af32fa7279d466e7e7a0455c44dusageopenaicanonical_flat_v14YESCustomer-supplied normalized values are not independently repriced.

Reliance boundary

Limitations and claims

  • 01

    The diagnostic uses only the supplied exports and cannot establish completeness beyond those sources.

  • 02

    Retry and context observations are reported only where explicit supporting fields exist.

  • 03

    No savings, recovery, causal, customer, or external benchmark claim is made.

  • 04

    This is a technical diagnostic, not accounting, tax, legal, or financial-statement assurance.

  • 05

    anthropic: conversation_id, sequence_number, and input_tokens are not present in every usage source

  • 06

    anthropic: retry_group_id and attempt_number are not present in every usage source

  • 07

    synthetic-anthropic-billing.csv: Customer-supplied normalized values are not independently repriced.

  • 08

    synthetic-anthropic-usage.json: Customer-supplied normalized values are not independently repriced.

  • 09

    synthetic-openai-billing.json: Customer-supplied normalized values are not independently repriced.

  • 10

    synthetic-openai-usage.csv: Customer-supplied normalized values are not independently repriced.

customer result claimed: falseexternal benchmark claimed: falsesavings claimed: false

Official schema references