pith. sign in

arxiv: 2605.22664 · v4 · pith:6RVQDMX6new · submitted 2026-05-21 · 💻 cs.AI

MBABench: Evaluating LLM Agents on End-to-End Spreadsheet Tasks in Finance

Pith reviewed 2026-06-30 17:09 UTC · model grok-4.3

classification 💻 cs.AI
keywords LLM agentsspreadsheet tasksfinancial modelingbenchmark evaluationend-to-end workflowsprofessional standards
0
0 comments X

The pith

LLM agents cannot reliably produce professional-quality financial spreadsheets from high-level instructions.

A machine-rendered reading of the paper's core claim, the machinery that carries it, and where it could break.

The paper creates a benchmark for end-to-end spreadsheet construction in finance tasks such as modeling and scenario analysis. It measures agent outputs using three dimensions of quality that match how professionals review deliverables: accuracy of results, correctness and structure of formulas, and adherence to formatting standards for readability and modification. Testing shows that even the strongest agents produce outputs that fall short of these standards and that performance declines sharply once tasks require more than a few linked calculations. This gap matters because finance workflows depend on complete, reviewable spreadsheets rather than isolated answers or single edits. The results indicate that current agents lack the reliability needed for the full complexity of enterprise financial work.

Core claim

Even the strongest agents frequently fall short of professional finance standards and degrade sharply as the difficulty increases beyond a few chained calculations, showing that current agents are not yet able to reliably produce professional-quality spreadsheets at the level of complexity real-world workflows demand.

What carries the argument

A three-dimensional evaluation taxonomy of Accuracy, Formula, and Format, each with fine-grained criteria that reflect how finance deliverables are reviewed and revised by multiple stakeholders.

If this is right

  • Agents require new capabilities for maintaining correctness across chained calculations in financial models.
  • Outputs must meet explicit standards for readability and ease of modification to pass stakeholder review.
  • Benchmarks focused only on question answering or single edits miss the end-to-end construction gap shown here.
  • Finance workflows cannot yet be automated end-to-end at professional quality with existing agent designs.

Where Pith is reading between the lines

These are editorial extensions of the paper, not claims the author makes directly.

  • The taxonomy could be adapted to evaluate agent performance on other structured professional artifacts such as reports or presentations.
  • Agents might benefit from built-in revision loops that incorporate feedback on formula and format issues.
  • Task difficulty scaling in the benchmark could guide training data creation for more complex multi-step workflows.

Load-bearing premise

The three-dimensional taxonomy with its fine-grained criteria accurately reflects the multidimensional professional standards used when finance deliverables are reviewed and revised by multiple stakeholders.

What would settle it

A direct comparison in which the top agent produces complete spreadsheets on complex tasks that receive passing professional review scores across accuracy, formula integrity, and format criteria.

Figures

Figures reproduced from arXiv: 2605.22664 by Adam Shen, Ali Bauyrzhan, Daniel Guetta, Haoyang Liu, Harshith Srinivas Gear, Hongseok Namkoong, Joshua Fan, Julian Poeltl, Siri Du, Thomson Yen, Yili Liu, Yilin Meng.

Figure 1
Figure 1. Figure 1: Compared to prior work that focus on atomic tasks on spreadsheet ( [PITH_FULL_IMAGE:figures/full_fig_p002_1.png] view at source ↗
Figure 2
Figure 2. Figure 2: The rubric (left) and the composite scores of agents on WorkstreamBench (right). The error bar indicates standard error. We found the Claude Web outperforms all others by a clear margin in all three core dimensions separately. However, substantial gap remains in current agents’ capabilities to meet professional standards. • To enable a holistic evaluation of the deliverable expected of end-to-end tasks, we… view at source ↗
Figure 3
Figure 3. Figure 3: Comparison between a unreadable, monolithic function ( [PITH_FULL_IMAGE:figures/full_fig_p004_3.png] view at source ↗
Figure 4
Figure 4. Figure 4: Distribution of difficulty and task types of WorkstreamBench. (Left) Roughly speaking, level 2 (Easy) is generally feasible without deep financial expertise, whereas level 4 (Medium-Hard) is not doable for recent grads without assistance from seasoned modelers. (Right) WorkstreamBench covers a wide variety of tasks. 3-Statement, for example, is the backbone of various financial modeling tasks. 4 Workstream… view at source ↗
Figure 5
Figure 5. Figure 5: An LLM judge output for the formula rubric. Here, the judge correctly identifies that the entries are hardcoded, resulting in a brittle spread￾sheet if model’s start date changes. Note that these mistakes would have other￾wise been difficult to detect with exact￾matching-based verification. Criteria Weighting. To enable quantitative cross-model comparison, we assign weights to the evaluation dimen￾sions an… view at source ↗
Figure 6
Figure 6. Figure 6: Mean attempt completion time (bottom) and mean composite score (top) plotted against task difficulty. (Left) API. (Right) GUI agents. Agents seem to recognize task difficulty, and generally spend more time as difficulty increases. However, their performance nonetheless degrade significantly, suggesting that harder spreadsheet tasks in WorkstreamBench poses difficulty that test-time scaling struggle to over… view at source ↗
Figure 7
Figure 7. Figure 7: Comparison between proper usage of absolute values [PITH_FULL_IMAGE:figures/full_fig_p013_7.png] view at source ↗
Figure 8
Figure 8. Figure 8: Comparison between proper usage of error handling [PITH_FULL_IMAGE:figures/full_fig_p013_8.png] view at source ↗
Figure 9
Figure 9. Figure 9: Comparison between usage of hardcoded values [PITH_FULL_IMAGE:figures/full_fig_p014_9.png] view at source ↗
Figure 10
Figure 10. Figure 10: Comparison between proper usage of dynamic ranges [PITH_FULL_IMAGE:figures/full_fig_p014_10.png] view at source ↗
Figure 11
Figure 11. Figure 11: Referencing the entire column (B:B) forces an awkward layout: the commission rate and [PITH_FULL_IMAGE:figures/full_fig_p015_11.png] view at source ↗
Figure 12
Figure 12. Figure 12: Comparison between three Excel structures that display the same format. The illogical [PITH_FULL_IMAGE:figures/full_fig_p016_12.png] view at source ↗
Figure 13
Figure 13. Figure 13: System architecture of the Playwright Excel Agent, illustrating the integration between [PITH_FULL_IMAGE:figures/full_fig_p027_13.png] view at source ↗
Figure 14
Figure 14. Figure 14: System architecture of the CLI Agent, illustrating the integration between user configs, [PITH_FULL_IMAGE:figures/full_fig_p028_14.png] view at source ↗
Figure 15
Figure 15. Figure 15: Font color switch between two consecutive rows [PITH_FULL_IMAGE:figures/full_fig_p029_15.png] view at source ↗
Figure 16
Figure 16. Figure 16: Hardcoded values instead of formulas Additionally the models often fail to meet industry conventions. These industry conventions include consistent number formatting, the insertion of a separate column for the unit of the respective row, and the display of negative numbers in parentheses instead of a minus sign [PITH_FULL_IMAGE:figures/full_fig_p030_16.png] view at source ↗
Figure 17
Figure 17. Figure 17: Non-compliance with industry conventions such as number formatting [PITH_FULL_IMAGE:figures/full_fig_p030_17.png] view at source ↗
Figure 18
Figure 18. Figure 18: Visual documentation of failure modes for the Playwright Agents, categorized by GUI [PITH_FULL_IMAGE:figures/full_fig_p037_18.png] view at source ↗
read the original abstract

LLM agents are increasingly expected to carry out end-to-end workflows, producing complete artifacts from high-level user instructions. To meet enterprise needs, frontier AI labs have developed agents that can construct entire spreadsheets from scratch. This is especially relevant in finance, where core workflows such as financial modeling, forecasting, and scenario analysis are commonly conducted through spreadsheets. Yet, existing spreadsheet benchmarks do not measure this advanced capability, focusing instead on question-answering or single-formula edits. To address this gap, we provide one of the first evaluations of agents on end-to-end spreadsheet tasks, focusing on economically critical financial workflows such as modeling and scenario analysis. Since deliverables therein are routinely reviewed and revised by multiple stakeholders, judging their quality necessarily involves high-level criteria such as readability or ease of modification. To reflect the multidimensional nature of solution quality, we develop an evaluation taxonomy comprising three dimensions: Accuracy, Formula, and Format, each comprising fine-grained criteria that reflect professional standards. The Claude family leads the benchmark and produces the most professional-looking outputs in our qualitative review, but even the strongest agents frequently fall short of professional finance standards and degrade sharply as the difficulty increases beyond a few chained calculations. This suggests that current agents are not yet able to reliably produce professional-quality spreadsheets at the level of complexity real-world workflows demand.

Editorial analysis

A structured set of objections, weighed in public.

Desk editor's note, referee report, simulated authors' rebuttal, and a circularity audit. Tearing a paper down is the easy half of reading it; the pith above is the substance, this is the friction.

Referee Report

2 major / 1 minor

Summary. The paper introduces MBABench, one of the first benchmarks for LLM agents on end-to-end spreadsheet construction tasks in finance (e.g., modeling, forecasting, scenario analysis). It defines a three-dimensional evaluation taxonomy (Accuracy, Formula, Format) with fine-grained criteria claimed to reflect professional standards, evaluates leading agents, and concludes that even the strongest (Claude family) fall short of professional finance standards with sharp degradation beyond a few chained calculations.

Significance. If the taxonomy and scoring are validated, the work is significant for highlighting a gap between current agent capabilities and real-world finance workflow demands, moving beyond existing QA or single-edit spreadsheet benchmarks. The qualitative review of output professionalism provides additional value.

major comments (2)
  1. [Abstract] Abstract: The claim that the Accuracy-Formula-Format taxonomy's fine-grained criteria 'reflect professional standards' because deliverables are 'routinely reviewed and revised by multiple stakeholders' lacks any described derivation process, expert calibration, inter-rater study, or comparison against actual finance review rubrics. This is load-bearing for the central claim that agents fall short of professional standards.
  2. [Evaluation Methodology] Evaluation section (inferred from abstract): No details are supplied on task construction, number of examples per difficulty level, scoring rubrics, inter-rater reliability, or statistical tests for the reported performance degradation with complexity. These omissions prevent verification that the data support the claims about agent limitations.
minor comments (1)
  1. [Abstract] Abstract: The statement that this is 'one of the first evaluations' would benefit from explicit citations to the 'existing spreadsheet benchmarks' mentioned for context.

Simulated Author's Rebuttal

2 responses · 0 unresolved

We thank the referee for the constructive feedback on our manuscript. We address each major comment below and commit to revisions that improve clarity and transparency without misrepresenting the work.

read point-by-point responses
  1. Referee: [Abstract] Abstract: The claim that the Accuracy-Formula-Format taxonomy's fine-grained criteria 'reflect professional standards' because deliverables are 'routinely reviewed and revised by multiple stakeholders' lacks any described derivation process, expert calibration, inter-rater study, or comparison against actual finance review rubrics. This is load-bearing for the central claim that agents fall short of professional standards.

    Authors: We agree the manuscript would be strengthened by explicitly describing the taxonomy's development. The criteria draw from established financial modeling practices (e.g., emphasis on auditability, modifiability, and readability as discussed in standard references such as financial modeling guides). The multi-stakeholder review rationale follows directly from the nature of professional finance deliverables. However, no formal expert calibration or inter-rater study is reported. In revision we will add a dedicated paragraph detailing the taxonomy construction process with supporting citations and will note the absence of formal validation studies as a limitation. revision: yes

  2. Referee: [Evaluation Methodology] Evaluation section (inferred from abstract): No details are supplied on task construction, number of examples per difficulty level, scoring rubrics, inter-rater reliability, or statistical tests for the reported performance degradation with complexity. These omissions prevent verification that the data support the claims about agent limitations.

    Authors: We acknowledge that additional methodological detail is required for verifiability. The Evaluation section will be expanded to cover: (1) task construction process and how tasks map to real finance workflows, (2) exact counts of examples per difficulty tier, (3) the complete scoring rubrics for Accuracy, Formula, and Format, (4) clarification that evaluation combines rule-based checks with qualitative human review, and (5) any statistical observations on degradation with complexity. We will also state whether formal inter-rater reliability metrics were computed. revision: yes

Circularity Check

0 steps flagged

No significant circularity: empirical benchmark paper with no derivations or fitted predictions

full rationale

This is an empirical benchmark paper that introduces MBABench and evaluates LLM agents on spreadsheet tasks using a custom three-dimensional taxonomy (Accuracy, Formula, Format). The taxonomy is presented as reflecting professional standards without any claimed mathematical derivation, parameter fitting, or prediction step that reduces to the inputs by construction. No equations, self-citation load-bearing arguments, uniqueness theorems, or ansatzes appear in the provided text. The central claims rest on direct evaluation results and qualitative review rather than any self-referential reduction, making the paper self-contained against external benchmarks.

Axiom & Free-Parameter Ledger

0 free parameters · 2 axioms · 0 invented entities

Based on abstract only; no free parameters or invented entities are described. The central claims rest on domain assumptions about what constitutes professional spreadsheet quality.

axioms (2)
  • domain assumption The financial workflows chosen (modeling, forecasting, scenario analysis) are representative of core enterprise spreadsheet tasks.
    The abstract states these are commonly conducted through spreadsheets and are economically critical.
  • domain assumption High-level criteria such as readability and ease of modification are necessary for judging quality because deliverables are routinely reviewed by multiple stakeholders.
    Explicitly invoked to justify the multidimensional taxonomy.

pith-pipeline@v0.9.1-grok · 5803 in / 1442 out tokens · 53122 ms · 2026-06-30T17:09:47.093516+00:00 · methodology

discussion (0)

Sign in with ORCID, Apple, or X to comment. Anyone can read and Pith papers without signing in.

Forward citations

Cited by 2 Pith papers

Reviewed papers in the Pith corpus that reference this work. Sorted by Pith novelty score.

  1. IPO Finance Agent: Benchmark of LLM Financial Analysts Beyond Finance Agent v2, with Automated Rubric Generation, on the SpaceX (SPCX) IPO

    cs.AI 2026-06 unverdicted novelty 6.0

    IPO Finance Agent creates a new LLM benchmark for IPO due diligence on SpaceX S-1 with contextual retrieval and automated rubrics, where Qwen 3.7 Max scores 79.4% at $0.30/query, outperforming Finance Agent v2 on accu...

  2. IPO Finance Agent: Benchmark of LLM Financial Analysts Beyond Finance Agent v2, with Automated Rubric Generation, on the SpaceX (SPCX) IPO

    cs.AI 2026-06 unverdicted novelty 6.0

    IPO Finance Agent benchmarks LLMs on SpaceX S-1 questions with contextual retrieval and auto-generated rubrics, reporting up to 79.8% accuracy and better cost-efficiency than prior Finance Agent v2 entries.

Reference graph

Works this paper leans on

22 extracted references · 8 canonical work pages · cited by 1 Pith paper · 3 internal anchors

  1. [1]

    Use Claude for Excel

    Anthropic. Use Claude for Excel. https://support.claude.com/en/articles/ 12650343-use-claude-for-excel, 2025a. Accessed: 2026-05-01. OpenAI. ChatGPT for Excel and Google Sheets in beta. https://chatgpt.com/apps/ spreadsheets/, 2026a. Accessed: 2026-05-01. CFA Institute. Financial Modeling. https://www.cfainstitute.org/ programs/cfa-program/candidate-resou...

  2. [2]

    Association for Financial Professionals

    Accessed: 2026-05-01. Association for Financial Professionals. 2025 AFP FP&A Benchmarking Survey Report: Technology & Data. https://www.financialprofessionals.org/ training-resources/resources/survey-research-economic-data/Details/ afp-fpa-benchmarking-survey-report-technology,

  3. [3]

    Zeyao Ma, Bohan Zhang, Jing Zhang, Jifan Yu, Xiaokang Zhang, Xiaohan Zhang, Sijia Luo, Xi Wang, and Jie Tang

    Accessed: 2026-05-01. Zeyao Ma, Bohan Zhang, Jing Zhang, Jifan Yu, Xiaokang Zhang, Xiaohan Zhang, Sijia Luo, Xi Wang, and Jie Tang. SpreadsheetBench: Towards Challenging Real World Spreadsheet Manipulation. In A. Globerson, L. Mackey, D. Belgrave, A. Fan, U. Paquet, J. Tomczak, and C. Zhang, editors,Advances in Neural Information Processing Systems, volum...

  4. [4]

    URL https://proceedings.neurips.cc/paper_files/paper/2024/file/ ac840df270ac537dd74530a15c332684-Paper-Datasets_and_Benchmarks_Track.pdf

    doi: 10.52202/079017-3007. URL https://proceedings.neurips.cc/paper_files/paper/2024/file/ ac840df270ac537dd74530a15c332684-Paper-Datasets_and_Benchmarks_Track.pdf. Yibin Chen, Yifu Yuan, Zeyu Zhang, Yan Zheng, Jinyi Liu, Fei Ni, Jianye Hao, Hangyu Mao, and Fuzheng Zhang. SheetAgent: Towards A Generalist Agent for Spreadsheet Reasoning and Manipulation vi...

  5. [5]

    NL2Formula: Generating spreadsheet formulas from natural lan- guage queries

    Wei Zhao, Zhitao Hou, Siyuan Wu, Yan Gao, Haoyu Dong, Yao Wan, Hongyu Zhang, Yulei Sui, and Haidong Zhang. NL2Formula: Generating spreadsheet formulas from natural lan- guage queries. In Yvette Graham and Matthew Purver, editors,Findings of the Association for Computational Linguistics: EACL 2024, pages 2377–2388, St. Julian’s, Malta, March

  6. [6]

    doi: 10.18653/v1/2024.findings-eacl.158

    Association for Computational Linguistics. doi: 10.18653/v1/2024.findings-eacl.158. URL https://aclanthology.org/2024.findings-eacl.158/. Haoyu Dong, Pengkun Zhang, Yan Gao, Xuanyu Dong, Yilin Cheng, Mingzhe Lu, Zikun Zhu, Adina Yakefu, and Shuxin Zheng. Finch: Benchmarking finance & accounting across spreadsheet-centric enterprise workflows,

  7. [7]

    Finch: Benchmarking Finance & Accounting across Spreadsheet-Centric Enterprise Workflows

    URLhttps://arxiv.org/abs/2512.13168. 10 Tejal Patwardhan, Rachel Dias, Elizabeth Proehl, Grace Kim, Michele Wang, Olivia Watkins, Simón Posada Fishman, Marwan Aljubeh, Phoebe Thacker, Laurance Fauconnet, Natalie S. Kim, Patrick Chao, Samuel Miserendino, Gildas Chabot, David Li, Michael Sharman, Alexandra Barr, Amelia Glaese, and Jerry Tworek. GDPval: Eval...

  8. [8]

    URLhttps://arxiv.org/abs/2510.04374. Qianqian Xie, Weiguang Han, Zhengyu Chen, Ruoyu Xiang, Xiao Zhang, Yueru He, Mengxi Xiao, Dong Li, Yongfu Dai, Duanyu Feng, Yijing Xu, Haoqiang Kang, Ziyan Kuang, Chenhan Yuan, Kailai Yang, Zheheng Luo, Tianlin Zhang, Zhiwei Liu, Guojun Xiong, Zhiyang Deng, Yuechen Jiang, Zhiyuan Yao, Haohang Li, Yangyang Yu, Gang Hu, ...

  9. [9]

    ISBN 9798331314385

    Curran Associates Inc. ISBN 9798331314385. Zhihan Zhang, Yixin Cao, and Lizi Liao. XFinBench: Benchmarking LLMs in complex finan- cial problem solving and reasoning. In Wanxiang Che, Joyce Nabende, Ekaterina Shutova, and Mohammad Taher Pilehvar, editors,Findings of the Association for Computational Lin- guistics: ACL 2025, pages 8715–8758, Vienna, Austria, July

  10. [10]

    XFinBench: Benchmarking LLMs in complex financial problem solving and reasoning

    Association for Computa- tional Linguistics. ISBN 979-8-89176-256-5. doi: 10.18653/v1/2025.findings-acl.457. URL https://aclanthology.org/2025.findings-acl.457/. Michael Krumdick, Rik Koncel-Kedziorski, Viet Dac Lai, Varshini Reddy, Charles Lovering, and Chris Tanner. BizBench: A quantitative reasoning benchmark for business and finance. In Lun- Wei Ku, A...

  11. [11]

    Fang, J., Jiang, H., Wang, K., Ma, Y ., Shi, J., Wang, X., He, X., and Chua, T

    Association for Computational Linguistics. doi: 10.18653/v1/ 2024.acl-long.452. URLhttps://aclanthology.org/2024.acl-long.452/. Qianqian Xie, Weiguang Han, Xiao Zhang, Yanzhao Lai, Min Peng, Alejandro Lopez-Lira, and Jimin Huang. PIXIU: A comprehensive benchmark, instruction dataset and large language model for finance. InThirty-seventh Conference on Neur...

  12. [12]

    BizFinBench: A Business-Driven Real-World Financial Benchmark for Evaluating LLMs

    URLhttps://openreview.net/forum?id=vTrRq6vCQH. Guilong Lu, Xuntao Guo, Rongjunchen Zhang, Wenqiao Zhu, and Ji Liu. Bizfinbench: A business- driven real-world financial benchmark for evaluating llms.arXiv preprint arXiv:2505.19457,

  13. [13]

    History of Financial Modeling Competitions

    FMWC. History of Financial Modeling Competitions. https://fmworldcup.com/history/, 2026a. Accessed: 2026-05-01. FMWC. Financial Modeling World Cup. https://fmworldcup.com/, 2026b. Accessed: 2026- 05-01. WSP. Wall Street Prep.https://www.wsp.com/en-us/,

  14. [14]

    Accessed: 2026-05-01. OpenAI. Introducing ChatGPT Agent. https://openai.com/index/ introducing-chatgpt-agent/,

  15. [15]

    Microsoft Corporation

    Accessed: 2026-01-29. Microsoft Corporation. Playwright: A framework for Web Testing and Automation,

  16. [16]

    Accessed: 2026-05-06. OpenAI. ChatGPT.https://chatgpt.com/, 2026b. Accessed: 2026-05-01. Carlos E Jimenez, John Yang, Alexander Wettig, Shunyu Yao, Kexin Pei, Ofir Press, and Karthik R Narasimhan. SWE-bench: Can Language Models Resolve Real-world Github Is- sues? InThe Twelfth International Conference on Learning Representations,

  17. [17]

    SWE-agent: Agent-Computer Interfaces Enable Automated Software Engineering

    URL https://arxiv.org/abs/2405.15793. Shuyan Zhou, Frank F Xu, Hao Zhu, Xuhui Zhou, Robert Lo, Abishek Sridhar, Xianyi Cheng, Yonatan Bisk, Daniel Fried, Uri Alon, et al. Webarena: A realistic web environment for building autonomous agents.arXiv preprint arXiv:2307.13854,

  18. [18]

    Claude Opus 4.5 System Card

    Anthropic. Claude Opus 4.5 System Card. https://assets.anthropic.com/m/ 64823ba7485345a7/Claude-Opus-4-5-System-Card.pdf, 2025b. Accessed: 2026-01-29. A Evaluation Criteria — Sub-dimensions In this section, we provide more examples for the rubric’s subdimensions to illustrate what they capture. A.1 Using Absolute References Consider converting product pri...

  19. [19]

    involved_tasks

    B.6 Task Difficulty Classification — Exemplary Tasks Exemplary Tasks by Difficulty Level Illustrative competition tasks for each difficulty level Very Easy — Task 7 (Accounts Receivable) A single-step task with direct formula application, requiring no finance knowledge and no Excel skills. Easy — Task 380 (First Time Buyer) Involves only a few steps with ...

  20. [20]

    xhigh",max_completion_tokens=128000 • Claude Opus 4.6: anthropic_effort=

    Claude (Excel)An official Anthropic add-in available through the Microsoft Marketplace that embeds a Claude-powered sidebar directly inside Excel for Windows, Mac, and Excel on the web. Users install it via the Excel Add-ins menu, sign in with a qualifying Anthropic account (Pro, Max, Team, or Enterprise), and interact with Claude through a chat panel wit...

  21. [21]

    ERROR: missing Q4_Q5 strike

    is supported by our qualitative investigations. One example of agents’ poorer performance is the change in the font color of the labels. For instance, in one of ChatGPT (Excel)’s attempts, the agent changed the font color in two consecutive rows (see Figure 15). For a client-ready model, this lack of consistency in presentation would be unacceptable. Figu...

  22. [22]

    decision

    This requires reasoning about the spatial structure of the workbook and whether the freeze pane is placed to actually serve its navigational purpose, not simply checking whether one is present. "decision":"Fail", "summary":"The freeze pane on the ’Model’ sheet is set incorrectly, hindering readability as timeline headers do not remain visible when scrolli...