Aggregate Reconciliation

Check that detail rows add up to the totals a summary declares, group by group. Sums are computed exactly on the decimal text, never through floating point: a float sum of 0.10 and 0.20 is 0.30000000000000004, so a tool built on one reports a false mismatch on the group that actually balances. Reports mismatches with the exact difference, groups with detail and no declared total, and totals with no detail at all.

SearchLiveeip155:8453Exactvia cdp
Data qualityReconciliationExact arithmeticFinancePipeline gate
Settlements · 30d
219↓ 38%
No per-endpoint history for this service yet, so this is payments indexed to its PROVIDER's wallet over 30 days.
$25.35
Verified settled volume
256 settlements proven x402 by their on-chain EIP-3009 marker.
$0.180
Listed price
As published in the catalog. Always read the live 402 before paying.
1
Calls · 30d
Upstream's own call count for this endpoint, not ours.
1
Unique payers · 30d
Last called 2026-10-04 08:12Z
—
Upstream on-chain volume
Reported by the source catalog.
Paid to
0x25e8245f07d5e4873987293dad666afbe56a9608

The wallet the 402 directs payment to. Its whole payment record — every payer, every chain — is on the merchant page.

Asset 0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913

Provider

The payTo wallet does not resolve to a registered ERC-8004 agent. That is not a verdict on the service — most of the catalog is unregistered.

Live 402 challenge

Captured by the enrichment pass, not read just now. Prices can change — always read the 402 the endpoint answers with.

{
  "error": "Payment required",
  "accepts": [
    {
      "asset": "0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913",
      "extra": {
        "name": "USD Coin",
        "version": "2"
      },
      "payTo": "0x25e8245f07d5e4873987293dad666afbe56a9608",
      "amount": "180000",
      "scheme": "exact",
      "network": "eip155:8453",
      "maxTimeoutSeconds": 60
    }
  ],
  "resource": {
    "url": "https://api.zfinia.com/x402/v1/aggregate-reconciliation",
    "tags": [
      "data quality",
      "reconciliation",
      "exact arithmetic",
      "finance",
      "pipeline gate"
    ],
    "mimeType": "application/json",
    "description": "Check that detail rows add up to the totals a summary declares, group by group. Sums are computed exactly on the decimal text, never through floating point: a float sum of 0.10 and 0.20 is 0.30000000000000004, so a tool built on one reports a false mismatch on the group that actually balances. Reports mismatches with the exact difference, groups with detail and no declared total, and totals with no detail at all.",
    "serviceName": "Aggregate Reconciliation"
  },
  "extensions": {
    "bazaar": {
      "info": {
        "input": {
          "body": {
            "detail": "region,amount\na,0.10\na,0.20\nb,5.00\nb,5.00\nc,1.00\n",
            "summary": "region,total\na,0.30\nb,10.01\nd,9.00\n",
            "group_by": [
              "region"
            ],
            "tolerance": "0",
            "detail_amount": "amount",
            "summary_amount": "total"
          },
          "type": "http",
          "method": "POST",
          "bodyType": "json"
        },
        "output": {
          "type": "json",
          "example": {
            "groups": [
              {
                "group": "a",
                "matched": true,
                "difference": "0",
                "detail_rows": 2,
                "detail_total": "0.3",
                "declared_total": "0.3",
                "difference_number": 0
              },
              {
                "group": "b",
                "matched": false,
                "difference": "-0.01",
                "detail_rows": 2,
                "detail_total": "10",
                "declared_total": "10.01",
                "difference_number": -0.01
              }
            ],
            "limits": {
              "maxRows": 5000,
              "maxListed": 200,
              "maxColumns": 64,
              "maxCsvBytes": 262144,
              "maxDatasets": 10,
              "maxFindings": 500,
              "maxCategories": 1000,
              "maxKeyColumns": 4
            },
            "passed": false,
            "complete": true,
            "findings": [
              {
                "key": "b",
                "row": 3,
                "code": "GROUP_TOTAL_MISMATCH",
                "detail": "b: 2 detail row(s) sum to 10 and the summary declares 10.01, a difference of -0.01."
              },
              {
                "key": "c",
                "code": "GROUP_NOT_IN_SUMMARY",
                "detail": "c has 1 detail row(s) and no declared total."
              },
              {
                "key": "d",
                "row": 4,
                "code": "SUMMARY_GROUP_HAS_NO_DETAIL",
                "detail": "d declares a total of 9 and has no detail rows at all."
              }
            ],
            "tolerance": "0",
            "reconciled": false,
            "request_id": "example-request",
            "service_id": "aggregate_reconciliation",
            "assumptions": [
              "Sums are computed exactly on the decimal text, never through floating point. A cent of drift across ten thousand rows is what this exists to find, and a float sum would invent or hide one.",
              "An empty amount contributes nothing to a total rather than being treated as zero or as an error, which is what a spreadsheet does.",
              "A group whose detail contains a value that cannot be summed exactly is reported as not compared rather than compared against an incomplete total."
            ],
            "group_count": 2,
            "limitations": [
              "Agreement between the detail and summary supplied. Which side is correct is not assessed.",
              "reconciled is true only when both sides were fully read, every group matched within tolerance, and nothing was left uncompared."
            ],
            "observed_at": "2026-10-02T00:00:00.000Z",
            "not_examined": [],
            "finding_count": 3,
            "service_version": "1.0.0",
            "detail_row_count": 5,
            "findings_by_code": {
              "GROUP_NOT_IN_SUMMARY": 1,
              "GROUP_TOTAL_MISMATCH": 1,
              "SUMMARY_GROUP_HAS_NO_DETAIL": 1
            },
            "summary_row_count": 3,
            "matched_group_count": 1,
            "mismatched_group_count": 1,
            "unsummable_value_count": 0
          }
        }
      },
      "schema": {
        "type": "object",
        "$schema": "https://json-schema.org/draft/2020-12/schema",
        "required": [
          "input"
        ],
        "properties": {
          "input": {
            "type": "object",
            "required": [
              "type",
              "method",
              "bodyType",
              "body"
            ],
            "properties": {
              "body": {
                "type": "object",
                "required": [
                  "detail",
                  "summary",
                  "group_by",
                  "detail_amount",
                  "summary_amount"
                ],
                "properties": {
                  "detail": {
                    "type": "string",
                    "maxLength": 262144
                  },
                  "summary": {
                    "type": "string",
                    "maxLength": 262144
                  },
                  "group_by": {
                    "type": "array",
                    "items": {
                      "type": "string",
                      "maxLength": 256
                    },
                    "maxItems": 4,
                    "minItems": 1
                  },
                  "delimiter": {
                    "type": "string",
                    "maxLength": 1,
                    "minLength": 1
                  },
                  "tolerance": {},
                  "detail_amount": {
                    "type": "string",
                    "maxLength": 256
                  },
                  "summary_amount": {
                    "type": "string",
                    "maxLength": 256
                  }
                },
                "additionalProperties": false
              },
              "type": {
                "type": "string",
                "const": "http"
              },
              "method": {
                "enum": [
                  "POST"
                ],
                "type": "string"
              },
              "bodyType": {
                "enum": [
                  "json",
                  "form-data",
                  "text"
                ],
                "type": "string"
              }
            },
            "additionalProperties": false
          },
          "output": {
            "type": "object",
            "required": [
              "type"
            ],
            "properties": {
              "type": {
                "type": "string"
              },
              "example": {
                "type": "object"
              }
            }
          }
        }
      }
    }
  },
  "x402Version": 2
}

Accepts

The payment requirements as published to the catalog. Read the live 402 before paying — a price here is a claim, not a quote.

0.18USDC≈ $0.18 USD
on Base · exact scheme

Pay 0.18 USDC on Base to 0x25e8…a9608. The signed payment is good for 1 minute.

USD Coin contract
0x8335…02913
Payment window
1 minute
As published
180000 smallest units
The catalog’s raw entry
[
  {
    "asset": "0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913",
    "extra": {
      "name": "USD Coin",
      "version": "2"
    },
    "payTo": "0x25e8245f07d5e4873987293dad666afbe56a9608",
    "amount": "180000",
    "scheme": "exact",
    "network": "eip155:8453",
    "maxTimeoutSeconds": 60
  }
]

Extensions

{
  "bazaar": {
    "info": {
      "input": {
        "body": {
          "detail": "region,amount\na,0.10\na,0.20\nb,5.00\nb,5.00\nc,1.00\n",
          "summary": "region,total\na,0.30\nb,10.01\nd,9.00\n",
          "group_by": [
            "region"
          ],
          "tolerance": "0",
          "detail_amount": "amount",
          "summary_amount": "total"
        },
        "type": "http",
        "method": "POST",
        "bodyType": "json"
      },
      "output": {
        "type": "json",
        "example": {
          "groups": [
            {
              "group": "a",
              "matched": true,
              "difference": "0",
              "detail_rows": 2,
              "detail_total": "0.3",
              "declared_total": "0.3",
              "difference_number": 0
            },
            {
              "group": "b",
              "matched": false,
              "difference": "-0.01",
              "detail_rows": 2,
              "detail_total": "10",
              "declared_total": "10.01",
              "difference_number": -0.01
            }
          ],
          "limits": {
            "maxRows": 5000,
            "maxListed": 200,
            "maxColumns": 64,
            "maxCsvBytes": 262144,
            "maxDatasets": 10,
            "maxFindings": 500,
            "maxCategories": 1000,
            "maxKeyColumns": 4
          },
          "passed": false,
          "complete": true,
          "findings": [
            {
              "key": "b",
              "row": 3,
              "code": "GROUP_TOTAL_MISMATCH",
              "detail": "b: 2 detail row(s) sum to 10 and the summary declares 10.01, a difference of -0.01."
            },
            {
              "key": "c",
              "code": "GROUP_NOT_IN_SUMMARY",
              "detail": "c has 1 detail row(s) and no declared total."
            },
            {
              "key": "d",
              "row": 4,
              "code": "SUMMARY_GROUP_HAS_NO_DETAIL",
              "detail": "d declares a total of 9 and has no detail rows at all."
            }
          ],
          "tolerance": "0",
          "reconciled": false,
          "request_id": "example-request",
          "service_id": "aggregate_reconciliation",
          "assumptions": [
            "Sums are computed exactly on the decimal text, never through floating point. A cent of drift across ten thousand rows is what this exists to find, and a float sum would invent or hide one.",
            "An empty amount contributes nothing to a total rather than being treated as zero or as an error, which is what a spreadsheet does.",
            "A group whose detail contains a value that cannot be summed exactly is reported as not compared rather than compared against an incomplete total."
          ],
          "group_count": 2,
          "limitations": [
            "Agreement between the detail and summary supplied. Which side is correct is not assessed.",
            "reconciled is true only when both sides were fully read, every group matched within tolerance, and nothing was left uncompared."
          ],
          "observed_at": "2026-10-02T00:00:00.000Z",
          "not_examined": [],
          "finding_count": 3,
          "service_version": "1.0.0",
          "detail_row_count": 5,
          "findings_by_code": {
            "GROUP_NOT_IN_SUMMARY": 1,
            "GROUP_TOTAL_MISMATCH": 1,
            "SUMMARY_GROUP_HAS_NO_DETAIL": 1
          },
          "summary_row_count": 3,
          "matched_group_count": 1,
          "mismatched_group_count": 1,
          "unsummable_value_count": 0
        }
      }
    },
    "schema": {
      "type": "object",
      "$schema": "https://json-schema.org/draft/2020-12/schema",
      "required": [
        "input"
      ],
      "properties": {
        "input": {
          "type": "object",
          "required": [
            "type",
            "method",
            "bodyType",
            "body"
          ],
          "properties": {
            "body": {
              "type": "object",
              "required": [
                "detail",
                "summary",
                "group_by",
                "detail_amount",
                "summary_amount"
              ],
              "properties": {
                "detail": {
                  "type": "string",
                  "maxLength": 262144
                },
                "summary": {
                  "type": "string",
                  "maxLength": 262144
                },
                "group_by": {
                  "type": "array",
                  "items": {
                    "type": "string",
                    "maxLength": 256
                  },
                  "maxItems": 4,
                  "minItems": 1
                },
                "delimiter": {
                  "type": "string",
                  "maxLength": 1,
                  "minLength": 1
                },
                "tolerance": {},
                "detail_amount": {
                  "type": "string",
                  "maxLength": 256
                },
                "summary_amount": {
                  "type": "string",
                  "maxLength": 256
                }
              },
              "additionalProperties": false
            },
            "type": {
              "type": "string",
              "const": "http"
            },
            "method": {
              "enum": [
                "POST"
              ],
              "type": "string"
            },
            "bodyType": {
              "enum": [
                "json",
                "form-data",
                "text"
              ],
              "type": "string"
            }
          },
          "additionalProperties": false
        },
        "output": {
          "type": "object",
          "required": [
            "type"
          ],
          "properties": {
            "type": {
              "type": "string"
            },
            "example": {
              "type": "object"
            }
          }
        }
      }
    }
  }
}

Provenance

Seen in the source catalog
2026-10-04 08:12Z
Last indexed by Roundhouse
2026-10-05 00:20Z
Last enriched (probe, favicon, geo)
2026-10-05 00:46Z
x402 version
2
Max timeout
60s
Liveness probe
HTTP 402
Report

Hand this page to an agent

Copy the prompt and paste it into Claude, an MCP client or your own agent — it will vet this service and call it over the free read API. No key, no account.

GET api.roundhouseai.io/v0/endpoints

No per-endpoint history for this service yet, so this is payments indexed to its PROVIDER's wallet over 30 days. Verified volume counts only settlements with an on-chain EIP-3009 marker.

Open skill.md
Show the prompt
Using Roundhouse, look up the x402 service Aggregate Reconciliation and tell me whether it is
worth paying: what a call costs, whether the endpoint answered when last probed, and what
its payment record actually shows.

curl -s 'https://api.roundhouseai.io/v0/endpoints?q=Aggregate%20Reconciliation'
curl -s 'https://api.roundhouseai.io/v0/merchants/<the payTo wallet returned above>'

Then call it: read the price from the live 402 at https://api.zfinia.com/x402/v1/aggregate-reconciliation, never from
a cached figure, and pay with an x402 client.

The /v0 API needs an API key (`authorization: Bearer rh_live_…`) on everything except
/v0/unified* and /v0/endpoints. Either pay over x402 (mint a personal key for $0.01 at
GET https://api.roundhouseai.io/v0/test/x402), or ask me for an organization key, which I create at
https://roundhouseai.io/dashboard/connections. If you have neither, ask before going further.

If you do not have Roundhouse tools or skills installed, read
https://roundhouseai.io/skill.md first — it is the whole procedure.