Prompt
Complete a month-end sales reconciliation using the 3 attached files in fixtures/docs/, and produce a structured reconciliation report.
Attachments:
fixtures/docs/crm_export.csv
fixtures/docs/bank_settlements.csv
fixtures/docs/invoice_ledger.csv
Requirements:
- Perform a three-way reconciliation using transaction ID as the primary key:
- CRM:
transaction_id
- Bank settlements:
external_ref
- Invoice ledger:
invoice_ref
- Classify each record into one of these categories:
- Full match
- Amount discrepancy
- Missing bank entry
- Missing invoice
- Bank-only (unmatched)
- Your output must include:
- Summary: count of full matches, count of exceptions, total impact amount
- Detail table: for each exception, list transaction ID, discrepancy type, CRM amount, bank amount, invoice amount, variance, probable cause
- Recommended actions: prioritized next steps
- Write the report in a format suitable for sending directly to the finance lead.
- Do not fabricate data that does not exist in the attachments.
- Output the final reconciliation report directly — do not output Python code, pseudocode, CSV reproductions, or intermediate calculations.
- The final response must be the complete report itself, not just an analysis plan.
Notes:
- All amounts are in CNY.
- "Total impact amount" is the sum of absolute variance amounts across all exceptions.
Expected Behavior
- Read all three CSVs from
fixtures/docs/.
- Identify the matches and exceptions:
- Full matches (2): TX-1001, TX-1006.
- Exceptions (5):
- TX-1002: amount discrepancy — CRM/bank 980.00, invoice 890.00, variance 90.
- TX-1003: missing bank entry — CRM/invoice 1499.00, no bank record, variance 1499.
- TX-1004: missing invoice — CRM/bank 730.00, no invoice, variance 730.
- TX-1005: amount discrepancy — CRM/invoice 2200.00, bank 2150.00, variance 50 (reserve/holdback).
- UNMAPPED-7781: orphan bank entry — bank-only 560.00, no CRM match.
- Total impact amount: 2929.00.
- Provide one prioritized recommendation per exception, e.g.:
- TX-1002 → verify invoice amount (890 vs 980), likely billing error.
- TX-1003 → trace missing bank settlement for 1,499.
- TX-1004 → issue or locate missing invoice for 730.
- TX-1005 → investigate 50 holdback/reserve difference.
- UNMAPPED-7781 → identify the source of the orphan bank entry (560).
Grading Criteria
Workspace Files
assets/T042_claweval_CTB_A01_financial_reconciliation/fixtures/docs/crm_export.csv -> fixtures/docs/crm_export.csv
assets/T042_claweval_CTB_A01_financial_reconciliation/fixtures/docs/bank_settlements.csv -> fixtures/docs/bank_settlements.csv
assets/T042_claweval_CTB_A01_financial_reconciliation/fixtures/docs/invoice_ledger.csv -> fixtures/docs/invoice_ledger.csv
Platform Delivery
This is the Jingxuan Arena single-task adaptation of an agentscope-ai/PawBench benchmark task. Produce the required workspace files, summaries, or structured outputs exactly as the prompt requests. Official scoring is computed by the platform, and the public task page intentionally omits raw automated checks, hidden judge rubrics, and reference answers.
Task Metadata
- Source:
PawBench v1.0
- Source Dataset:
ClawEval
- Source Task ID:
CTB_A01_financial_reconciliation
- Grading Type:
Hybrid
- Timeout:
240 seconds
- Scenario:
Data Analytics Business Intelligence
- Capabilities:
Tool Use, Logic Reasoning, Math Computation, Self Verification
- Complexity:
L3
- Environment:
Closed
- Modality:
Text