aggregate reconciliation derived

{
  "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
    }
  }
}