{"uid":"cap_MEGRsB_iEZ8oVWyfFBKH6","slug":"foundry-csv-grouped-balance-reconciliation-0e5b3ad4","name":"Foundry CSV Grouped Balance Reconciliation","description":"Pay-per-request evidence and data tools: CSV validation and reconciliation, DNS/email configuration evidence, and bounded official weather, earthquake, vehicle, company and study records. Exact USDC prices, explicit JSON contracts and source provenance. No mailbox, ownership, medical or safety guarantees.","url":"https://foundry-par007-machine-revenue-mainnet.inference-chip-index.workers.dev/v2/data/csv-grouped-balance-reconciliation","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"detail_csv":{"type":"string","maxLength":12000,"minLength":1},"summary_csv":{"type":"string","maxLength":12000,"minLength":1},"detail_group":{"type":"string","maxLength":100,"minLength":1},"detail_amount":{"type":"string","maxLength":100,"minLength":1},"summary_group":{"type":"string","maxLength":100,"minLength":1},"decimal_places":{"type":"integer","maximum":6,"minimum":0},"summary_amount":{"type":"string","maxLength":100,"minLength":1}}},"responseSchema":{"type":"json","example":{"route":"csv-grouped-balance-reconciliation","result":{"status":"MATCH","mismatches":[],"detail_rows":2,"group_count":1,"limitations":["Synthetic example hashes."],"summary_rows":1,"detail_sha256":"0000000000000000000000000000000000000000000000000000000000000000","decimal_places":2,"mismatch_count":0,"summary_sha256":"0000000000000000000000000000000000000000000000000000000000000000","evidence_truncated":false},"observed_at":"2026-09-06T00:00:00Z"}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_P7a7FsGb_Xi4rxx3UoDPb","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Reconciles two CSVs (a detail file and a summary file) by grouping detail rows and comparing summed amounts to summary totals, returning match status, mismatches, and SHA-256 hashes of both inputs.","exampleAgentPrompt":"Can you reconcile my transactions CSV against my monthly summary CSV? The detail file groups by 'account_id' and the amount column is 'transaction_amount'; the summary file groups by 'account_id' and its amount column is 'balance' — use 2 decimal places and tell me if everything matches or flag any discrepancies.","exampleUseCases":[{"title":"AP ledger vs summary audit","prompt":"I have two CSVs — one is my accounts-payable line-item detail with columns 'vendor_id' and 'invoice_amount', and the other is my AP summary with 'vendor_id' and 'total_due'. Can you reconcile them grouped by vendor_id using 2 decimal places and tell me which vendors have mismatches?"},{"title":"Monthly sales rollup check","prompt":"Check whether my daily sales detail CSV sums up correctly to my monthly sales summary CSV. The detail file has 'region' and 'sale_amount' columns; the summary has 'region' and 'monthly_total'. Group by region and use 2 decimal places — I need to know if any regions are off."},{"title":"Payroll detail vs payroll summary verification","prompt":"I need to verify my payroll detail export against the payroll summary report before I submit them. The detail CSV has 'department' and 'gross_pay'; the summary has 'department' and 'total_gross'. Please reconcile them with 2 decimal places and give me the match status and any mismatches."}],"resultDescription":"Returns a JSON object with a 'status' field ('MATCH' or 'MISMATCH'), a list of any mismatches (group key plus detail-sum vs summary-amount), row counts for both CSVs, group count, mismatch count, SHA-256 hashes of both input CSVs for evidence provenance, the number of decimal places used, whether evidence was truncated, any limitations, and an observed_at timestamp.","failureModes":["Missing required fields (detail_csv, summary_csv, detail_group, detail_amount, summary_group, summary_amount) returns an error","CSV content exceeds 12,000-character limit per file, causing rejection","Column name not found in the provided CSV results in an error","Malformed CSV (unquoted commas, mismatched columns) may cause parse failures","Non-numeric amount values in the specified amount column cause computation errors","decimal_places value outside 0–6 range is rejected"],"whenToPreferThis":"Use this endpoint when you need a pay-per-request, auditable reconciliation of two CSVs where one represents granular transaction detail and the other summarizes grouped totals. It is ideal for automated financial auditing pipelines, accounting close processes, and compliance workflows that require SHA-256 evidence hashes and a clear MATCH/MISMATCH verdict with explicit mismatches listed. Prefer it over general-purpose data tools when you need deterministic, reproducible results with provenance — and when CSV sizes fit within the 12,000-character per-file limit.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-14T21:09:17.425Z","isFirstParty":false}