AI news and explainers at 7 AM weekdays, plus a Sunday weekly at 8Get it in your inbox

METAL LAB

Are the Financial Reasoning from LLMs Credible? A Real World Test over Long-Horizon Statements

arXiv:2607.286612026-07-21

Feed AI the full, uncropped financial statements and take away the formula hints, and even top models get numbers wrong half the time

Researchers built FinIndices, a benchmark that tests LLMs on real, uncropped corporate financial statements (up to 32K tokens) instead of cropped table snippets. Models are tested on both single-number calculations and multi-metric table generation, and when explicit formulas are removed, even leading models' accuracy collapses dramatically. On table-generation tasks especially, models lose track of time periods or take accounting shortcuts that break correctness.

METAL LAB explanatory visual

FinIndices construction and evaluation pipeline

Evidence statusMeasured results reported

  1. 1. Statement extractionParses balance sheets, income statements, and cash flow statements from 829 companies' raw reports and randomizes their format.
  2. 2. Context building & trap injectionAligns the exact reporting periods needed and injects distractor periods or deliberately omits required data.
  3. 3. QA generation & expert validationProgrammatically computes ground-truth answers from textbook formulas, then three experts vote to finalize a 640-instance test set.
  4. 4. Hint on/off comparisonEvaluates Single-Index and Table-Index tasks both with and without explicit formula hints to measure the accuracy gap.
  5. 5. SFT recovery attemptFine-tunes a model on Gemini-distilled reasoning trajectories and measures how much hintless accuracy is regained.
An explanatory diagram made by METAL LAB, not a figure supplied by the paper's authors.

What they did

  1. The team built FinIndices, an automatically synthesized and expert-validated benchmark of 68,307 samples drawn from 829 listed companies, 384 financial indices, and 28 reporting periods.
  2. Queries fall into two formats — Single-Index (compute one number) and Table-Index (fill in a multi-metric table) — spanning four capability axes including accounting-domain knowledge, temporal reasoning, and caliber (stock vs. flow) alignment.
  3. The dataset injects adversarial traps: irrelevant extra periods to distract the model, and missing required periods that should force the model to answer 'insufficient information' instead of guessing.
  4. Models were compared under 'With Hint' (formula given) and 'Without Hint' (formula withheld) conditions, and Single-Index vs. Table-Index task difficulty was also compared.
  5. The team also fine-tuned a model on distilled reasoning trajectories to see how much of the lost accuracy under the hintless condition could be recovered.
Figure 1: Three canonical financial analysis workflows motivating FinIndices. Each case follows an input tables → structured reasoning module → tabular output pipeline: cross-entity valuation comparison (BYD / Tesla / Li Auto), longitudinal drift detection (Kweichow Moutai, 2019–2023), and cross-caliber macro reconciliation (China GDP under NBS / World Bank / IMF–PPP). Together they exemplify the three core challenges our benchmark targets: caliber unification, temporal-semantic disambiguation (stock/flow, mtd/ytd/ttm), and cross-indicator alignment with accurate composite computation. The bottom strip contrasts the failure modes of naive pipelines with the guarantees of structured table reasoning.
Figure 1: Three canonical financial analysis workflows motivating FinIndices. Each case follows an input tables → structured reasoning module → tabular output pipeline: cross-entity valuation comparison (BYD / Tesla / Li Auto), longitudinal drift detection (Kweichow Moutai, 2019–2023), and cross-caliber macro reconciliation (China GDP under NBS / World Bank / IMF–PPP). Together they exemplify the three core challenges our benchmark targets: caliber unification, temporal-semantic disambiguation (stock/flow, mtd/ytd/ttm), and cross-indicator alignment with accurate composite computation. The bottom strip contrasts the failure modes of naive pipelines with the guarantees of structured table reasoning.
Table 1: Distribution of FinIndices along the capability axes. Queries are tagged by their dominant required skills, resulting in four mutually exclusive clusters. Proportions remain stable across all data splits.
SplitQuery ParadigmDomainCaliberTemporal + CaliberTemporal + DomainTotal
#%#%#%#%
TrainSingle-Index4,1927.2736,82963.8510,01517.366,64511.5257,681
Table-Index1,13111.755,57957.961,73518.021,18112.279,626
Subtotal5,3237.9142,40863.0111,75017.467,82611.6367,307
DevSingle-Index156.9113863.593817.512611.98217
Table-Index149.798962.242114.691913.29143
Subtotal298.0622763.065916.394512.50360
TestSingle-Index347.0431164.398216.985611.59483
Table-Index2214.018654.783220.381710.83157
Subtotal568.7539762.0311417.817311.41640
Figure 2: Overview of the FinIndices data synthesis pipeline. The workflow consists of three stages: (1) Financial Statement Extraction parses and format-randomizes core tables from raw reports; (2) Context Construction & Index Alignment aligns temporal data and injects adversarial traps (e.g., missing info); and (3) Instruction & QA Pair Generation constructs prompts using canonical formulas and programmatic execution, followed by a rigorous Expert Validation phase employing majority voting to ensure absolute ground-truth fidelity.
Figure 2: Overview of the FinIndices data synthesis pipeline. The workflow consists of three stages: (1) Financial Statement Extraction parses and format-randomizes core tables from raw reports; (2) Context Construction & Index Alignment aligns temporal data and injects adversarial traps (e.g., missing info); and (3) Instruction & QA Pair Generation constructs prompts using canonical formulas and programmatic execution, followed by a rigorous Expert Validation phase employing majority voting to ensure absolute ground-truth fidelity.
Table 2: Context Length and Structural Complexity. FinIndices features an order-of-magnitude increase in context lengths compared to previous datasets. Furthermore, to resolve these queries, models must aggregate data across multiple interconnected reporting periods and, in Table-Index tasks, generate highly structured multi-value outputs.
DatasetSamplesContext Length (Tokens)
MeanMaxMin
FinQA (3)8,2811,003.83,250168
TAT-QA (27)14,883590.74,140113
FinIndices (Ours)68,30716,202.033,12670
Temporal and Structural Complexity in FinIndices
Query ParadigmInput PeriodsOutput PeriodsTarget Values Generated
Single-Index QueriesAvg: 1.95 (Max: 6)Avg: 1.00 (Max: 1)1.00 (Single value)
Table-Index QueriesAvg: 2.89 (Max: 9)Avg: 2.03 (Max: 4)Avg: 7.75 (Range: 2 – 20)
Table 3: Main Results on FinIndices. Models are categorized by weight availability, scale, and domain specificity. For iteratively evaluated general LLMs, Dev and Test results are averaged across 3 independent runs with standard deviations reported as subscripts. The end-to-end accuracy exposes a systemic performance collapse across both Single-Index and Table-Index tasks when explicit formula hints are removed. Top-2 Test results are highlighted in Red (1st) and Blue (2nd).
ModelsWith Hint (w/ Formula)Without Hint (w/o Formula)
Single-IndexTable-IndexSingle-IndexTable-Index
TrainDevTestTrainDevTestTrainDevTestTrainDevTest
Closed-Source Models
Gemini-3.1-Pro (thinking)66.2969.05±0.8779.61±1.0534.5026.57±1.5170.70±0.3055.9558.96±1.2164.90±0.8217.359.09±0.3338.22±0.52
Claude-Opus-4.8 (thinking)66.9172.66±0.7878.46±0.5731.4623.08±0.9965.61±1.3856.6560.62±1.3265.79±0.4616.519.79±0.9938.85±1.38
GPT-5.5 (thinking)65.6974.46±1.0477.29±0.3432.9022.84±0.6666.88±0.5254.4259.17±0.1360.91±1.1015.1211.66±0.3334.18±0.30
GPT-5.4 (thinking)65.8871.58±0.8975.79±0.8133.3825.17±0.7565.61±0.9255.9659.02±0.7857.04±0.8414.7710.49±0.4131.21±0.62
Open-Weight Large Models ( ≥ 200B )
Qwen3.7-Max (thinking)62.5969.51±0.9378.53±0.2835.1026.57±0.0072.82±0.6050.7554.24±0.6758.18±0.9215.4710.02±0.6633.97±0.79
DeepSeek-V4-Pro (thinking)64.7566.00±1.2369.20±0.7925.2815.62±1.7448.20±1.3152.8550.69±0.3252.74±0.389.866.29±0.5722.72±2.10
GLM-5.2 (thinking)51.1457.41±0.6860.50±1.0916.7711.19±0.9936.94±0.5243.1745.05±0.1348.82±1.127.275.59±0.5719.53±1.83
GLM-5 (thinking)51.2850.93±0.6550.85±0.7416.8412.59±0.5235.03±0.6841.2235.21±0.4836.97±0.557.985.59±0.2819.11±0.42
Open-Weight Medium Models ( 50B – 200B )
Qwen3.7-Plus (thinking)61.5365.33±0.6976.16±1.1130.5821.91±0.8763.91±0.6050.3853.77±1.7458.72±1.0113.638.39±1.5129.72±2.86
Qwen3.5-Plus (thinking)61.5660.70±0.7568.78±0.8829.6426.57±0.5563.69±0.7248.9154.19±0.6850.11±0.7412.998.39±0.3526.75±0.65
Open-Weight Small Models ( < 50B )
General
Qwen3.5-35B-A3B-thinking55.1261.85±0.8262.40±0.7614.8511.10±0.4526.50±0.5542.1547.10±0.5848.20±0.616.557.15±0.3112.50±0.38
Domain-Specific Financial
DianJin-R1-32B (28)37.9445.97±0.8141.29±0.755.012.90±0.1811.41±0.4229.4034.00±0.6632.39±0.582.080.74±0.055.33±0.21
Fin-o1-14B24.9422.89±0.4528.16±0.531.120.71±0.082.67±0.1518.6020.87±0.3818.32±0.410.550.00±0.001.97±0.11
XuanYuan-FinX19.156.82±0.2512.45±0.331.260.70±0.051.91±0.105.857.12±0.205.33±0.180.510.00±0.000.64±0.04
Fin-R1 (13)8.214.95±0.1810.87±0.280.080.00±0.000.00±0.004.986.25±0.154.41±0.120.020.00±0.000.00±0.00
Llama-Fin-8B7.924.50±0.1210.15±0.220.000.00±0.000.00±0.004.655.81±0.114.12±0.090.000.00±0.000.00±0.00
Table 4: Improvements via Domain-Specific SFT. Our fine-tuned variant shows steady gains on general knowledge benchmarks and substantial improvements in complex numerical reasoning and tabular generation (Without Hint setting).
ModelsFinance KnowledgeFinance Calc.Finance Table Reasoning
CFinBenchFinEvalFLAMEIn-HouseFinMathSingle-IndexTable-Index
(17)(8)(7)(w/o Hint)(w/o Hint)
Ablation: Impact of Domain-Specific Fine-Tuning
Qwen3.5-35B-A3B-thinking (Base)74.5188.5984.8771.9566.9047.9215.29
Ours (SFT on Base)75.2289.4387.2672.5669.0856.4619.11
Absolute Improvement (Δ)+0.72+0.84+2.39+0.61+2.19+8.54+3.82
Table 5: A Single-Index case testing deep Accounting Domain Understanding. To correctly compute Total Invested Capital, the model must avoid the trap of treating Notes Payable as interest-bearing debt, systematically classifying dozens of balance sheet items strictly according to financial analysis conventions.
Case 1: Single-Index Query for Total Invested Capital (Domain Understanding)
Company & PeriodCompany: 301607, Fute Technology Reporting period: 2024Y. Target values are computed using the ending balance of the 2024Y consolidated balance sheet.
Task ParadigmSingle-Index. The model must return one numerical value: Total Invested Capital (Equity Method). The final answer must be scaled to thousands and rounded to two decimal places.
Capability AxisDomain Understanding. The query provides a high-level formula that subtracts “non-interest-bearing liabilities” from total capital. The model must systematically classify over 30 liability line items. Crucially, it must know that operating liabilities like Notes Payable are generally non-interest-bearing in Chinese accounting, whereas Lease Liabilities and Current Maturities of Non-Current Liabilities are interest-bearing.
Input Statements(1) 2024Y Consolidated Balance Sheet (2) 2024Y Parent-Company Balance Sheet (Distractor)
User Instruction“Calculate Fute Technology’s 2024Y Total Invested Capital (Equity Method), expressed in thousands and rounded to two decimal places.”
Injected Formula∙ Total Invested Capital = Equity Attributable to Parent + Total Liabilities − Non-interest-bearing Current Liabilities − Non-interest-bearing Non-current Liabilities
Extracted ItemsFrom the 2024Y Consolidated Balance Sheet: ∙ Equity Attributable to Parent: 1,000,020,938.49 ∙ Total Liabilities: 1,285,210,565.03 Interest-Bearing Liabilities (to be retained in Capital): ∙ Non-current Liab due within 1 year: 34,943,585.84 ∙ Long-term Borrowings: 48,296,660.07 ∙ Lease Liabilities: 16,566,591.38 ∙ Long-term Payables: 54,160,000.00 (Note: Notes Payable of 215,022,707.38 is correctly identified as an operating non-interest-bearing liability and must be deducted.)
Calculation ProcessStep 1: Simplify the logic via Interest-Bearing Liabilities. Since Total Liab−Non-interest Liab=Interest-bearing Liab, the formula reduces to: Invested Capital=Equity Attributable to Parent+Interest-bearing Liab. Step 2: Sum the Interest-Bearing Liabilities. 34,943,585.84+48,296,660.07+16,566,591.38+54,160,000.00=153,966,837.29 Step 3: Add Equity to compute Total Invested Capital. 1,000,020,938.49+153,966,837.29=1,153,987,775.78 Step 4: Unit conversion and rounding. Divide by 1,000 (thousands): 1,153,987.77578​⋯≈1,153,987.78
Ground Truth1153987.78
Table 6: A Single-Index case requiring Temporal Reasoning and Domain Understanding. The model must navigate six non-sequential reporting periods, identify the correct three tables (Current, Previous Annual, Previous Same-Period), and compute a rolling Trailing Twelve Months (TTM) window while handling negative numbers and specific unit conversions.
Case 2: Single-Index Query for Trailing Twelve Months (TTM) Computation
Company & PeriodCompany: 301183, Dongtian Micro Target Period: TTM ending 2025H1 (2024-07-01 to 2025-06-30).
Task ParadigmSingle-Index. The model must return one numerical value: Operating Expenses (TTM). The final answer must be scaled to ten-thousands and rounded to two decimal places.
Capability AxisTemporal Reasoning + Domain Understanding. The model must aggregate three specific expense lines (Selling, Administrative, and Financial) across non-sequential reporting periods using the TTM rolling-window logic: TTM=Current Period+Previous Annual−Previous Period.
Input StatementsThe prompt provides six distinct financial reporting periods in a randomized, non-chronological order, mixing text tables and Python tuple lists: (1) 2025H1 Consolidated Income Statement (2) 2025Q1 Consolidated Income Statement (Distractor) (3) 2024Y (Annual) Consolidated Income Statement (4) 2024Q3 Consolidated Income Statement (Distractor) (5) 2024H1 Consolidated Income Statement (6) 2024Q1 Consolidated Income Statement (Distractor) In addition to consolidated statements, parent-company statements are provided as distractors.
User Instruction“Calculate Dongtian Micro’s Operating Expenses (TTM) as of 2025-06-30. The TTM baseline date is the statement announcement date. Express the result in ten-thousands and round to two decimal places.”
Injected FormulaOperating Expenses (TTM)=Selling Expenses (TTM)+Administrative Expenses (TTM)+Financial Expenses (TTM) where TTM rule is defined as: ∙ Since the latest period (2025H1) is not an annual report, TTM=Current Period (2025H1)+Last Annual (2024Y)−Same Period Last Year (2024H1).
Extracted ItemsFrom 2025H1 Consolidated Statement: ∙ Selling Expenses: 2,789,101.10 ∙ Administrative Expenses: 16,554,534.56 ∙ Financial Expenses: −2,457,530.39 From 2024Y Consolidated Statement: ∙ Selling Expenses: 4,958,105.99 ∙ Administrative Expenses: 34,543,848.50 ∙ Financial Expenses: −6,779,324.49 From 2024H1 Consolidated Statement: ∙ Selling Expenses: 2,236,714.86 ∙ Administrative Expenses: 12,031,506.74 ∙ Financial Expenses: −3,844,353.30
Calculation ProcessStep 1: Compute TTM for each expense category. ∙ Selling Exp (TTM)=2,789,101.10+4,958,105.99−2,236,714.86=5,510,492.23 ∙ Admin Exp (TTM)=16,554,534.56+34,543,848.50−12,031,506.74=39,066,876.32 ∙ Financial Exp (TTM)=(−2,457,530.39)+(−6,779,324.49)−(−3,844,353.30)=−5,392,501.58 Step 2: Aggregate expenses and apply domain-specific netting adjustments. By substituting the extracted figures and aligning the expense caliber definitions as strictly expected by the ground truth logic, the model derives the net operating expense value. Step 3: Unit conversion and rounding. Convert the final aggregated value to ten-thousands (divide by 10,000) and round to two decimal places: ≈3,606.24
Ground Truth3606.24
Table 7: An Adversarial Single-Index case testing Temporal Reasoning. The model is asked to compute a standalone quarterly growth rate but is only provided with Annual cumulative statements. A robust model must recognize the impossibility of temporal de-cumulation (Annual − Q3 = Q4) without the Q3 data, explicitly refusing to calculate rather than returning a flawed annual growth metric.
Case 3: Adversarial Single-Index Query for Standalone Quarter YoY Growth
Company & PeriodCompany: 301158, Deshi Shares Target Period: 2023Q4 Standalone Quarter (queried via the 2023Y Annual Report).
Task ParadigmSingle-Index (Adversarial). The model is asked to compute the YoY growth rate of a specific standalone quarter’s operating cash flow. Because critical temporal data (Q3 reports) is omitted from the prompt, the model must reject the calculation.
Capability AxisTemporal Reasoning + Complex Caliber Alignment. To find a Q4 standalone flow variable (like Cash Flow), the model must subtract the Q3 cumulative (Year-to-Date) value from the Annual cumulative value. It must execute this temporal de-cumulation for both the current year and the prior year before applying the YoY caliber.
Input StatementsThe prompt provides only the annual reports: (1) 2023Y (Annual) Consolidated Balance Sheet, Income Statement, Cash Flow (2) 2023Y (Annual) Parent-Company Statements (Distractors) Missing Critical Context: The 2023Q3 and 2022Q3 interim reports are deliberately excluded from the input.
User Instruction“Calculate Deshi Shares’ 2023Q4 standalone Net Operating Cash Flow YoY Growth Rate. Express ratio data in percentages rounded to one decimal place.”
Injected Formula∙ Standalone Quarter Net Operating Cash Flow YoY Growth = (Current Standalone Quarter Net Operating Cash Flow − Prior Year Same Standalone Quarter Net Operating Cash Flow) / ABS(Prior Year Same Standalone Quarter Net Operating Cash Flow) ×100%
Extracted ItemsFrom the 2023Y Consolidated Cash Flow Statement: ∙ 2023Y (Cumulative Annual) Net Operating Cash Flow: 105,884,015.27 ∙ 2022Y (Cumulative Annual) Net Operating Cash Flow: 4,610,664.14 Missing Critical Items: ∙ 2023Q3 (First 9 Months) Net Operating Cash Flow: Not found ∙ 2022Q3 (First 9 Months) Net Operating Cash Flow: Not found
Calculation ProcessStep 1: Identify the temporal alignment requirements. The query asks for the standalone quarter growth rate. Since the base period is the 2023Y report, the standalone quarter in question is Q4. Step 2: Attempt temporal de-cumulation. To get 2023Q4 standalone cash flow, the model must calculate: 2023Y Cumulative−2023Q3 Cumulative. Step 3: Recognize information deficiency. The model scans the provided tables and realizes the Q3 (first three quarters) reports are absent. Therefore, the standalone Q4 figures for both the current and prior years cannot be unrolled. Step 4: Reject calculation. The model correctly halts execution instead of erroneously substituting the annual YoY growth rate in place of the standalone quarterly YoY growth rate.
Ground TruthInsufficient information to calculate the final value
Table 8: A Table-Index case requiring Complex Caliber Alignment. To correctly compute operating turnover metrics, the model must align point-in-time stock variables (Balance Sheet) with accumulated flow variables (Income Statement) by averaging beginning and ending balances. Furthermore, it must apply distinct scaling multipliers (90, 270, 360) depending on the semantic length of each specific column’s reporting period.
Case 4: Table-Index Query for Multi-Metric Caliber Alignment (Turnover & Operating Capabilities)
Company & PeriodCompany: 301197, Gongda Keya Target Periods: 2023Q3, 2023Y (Annual), and 2024Q1.
Task ParadigmTable-Index. The model must generate a strictly formatted HTML table containing four derived operating metrics across three different reporting periods. The output must be rounded to one decimal place.
Capability AxisComplex Caliber Alignment. The model must align flow variables (Income Statement metrics like Revenue) with stock variables (Balance Sheet metrics like Assets and Liabilities). This requires averaging the beginning and ending stock balances and correctly applying period-specific annualization multipliers (e.g., 90 days for Q1, 270 days for Q3, 360 days for Annual).
Input StatementsThe prompt provides a massive dump of uncropped financial tables spanning three periods: (1) 2023Q3 Consolidated & Parent Balance Sheets, Income Statements, Cash Flows (2) 2023Y Consolidated & Parent Balance Sheets, Income Statements, Cash Flows (3) 2024Q1 Consolidated & Parent Balance Sheets, Income Statements, Cash Flows (Tens of thousands of tokens containing raw financial grids.)
User Instruction“Extract or calculate the following four metrics for Gongda Keya across 2023Q3, 2023Y, and 2024Q1: Pre-receipts and Contract Liabilities Turnover Days, Cash Conversion Cycle, Net Asset Turnover, and AR & Contract Assets Turnover. Output the results as an HTML table wrapped in <table></table> tags, keeping one decimal place.”
Injected Formula∙ Turnover Days = [360 for Annual, 90 for Q1, 180 for H1, 270 for Q3] / Turnover Rate ∙ Cash Conversion Cycle = Inventory Turnover Days + AR Turnover Days − AP Turnover Days ∙ Net Asset Turnover = Total Operating Revenue × 2 / (Beginning Net Assets + Ending Net Assets), where Net Assets = Total Assets − Total Liabilities ∙ AR & Contract Assets Turnover = Revenue × 2 / (Current AR + Current Contract Assets + Previous Year-end AR + Previous Year-end Contract Assets)
Calculation ProcessStep 1: Metric extraction across periods. The model must extract Total Assets, Total Liabilities, Revenue, Inventory, AR, AP, Contract Assets, and Pre-receipts for the start and end of 2023Q3, 2023Y, and 2024Q1. Step 2: Caliber alignment (Averaging Stocks to match Flows). To compute Net Asset Turnover for 2024Q1, the model extracts 2024Q1 Revenue (flow) and divides it by the average of 2023Y Net Assets (beginning stock) and 2024Q1 Net Assets (ending stock). Step 3: Period-specific multipliers. When computing Turnover Days, the model must dynamically select the numerator: 270 for the 2023Q3 column, 360 for the 2023Y column, and 90 for the 2024Q1 column. Step 4: HTML Table Synthesis. Format the 12 resulting data points into a 2D HTML grid without generation collapse.
Ground Truth<table> <tr><td>Metric</td><td>2023Q3</td><td>2023Y</td><td>2024Q1</td></tr> <tr><td>Pre-receipts & Contract Liab Turnover Days</td><td>51.7</td><td>39.1</td><td>75.6</td></tr> <tr><td>Cash Conversion Cycle</td><td>779.1</td><td>500.6</td><td>1030.5</td></tr> <tr><td>Net Asset Turnover</td><td>0.1</td><td>0.3</td><td>0.0</td></tr> <tr><td>AR & Contract Assets Turnover</td><td>0.4</td><td>0.8</td><td>0.1</td></tr> </table>
Table 9: A Table-Index case testing pure Domain Understanding. While computing Working Capital and Retained Earnings requires simple extraction and addition, computing Total Invested Capital demands an exhaustive, item-by-item classification of the liability structure. The model must apply this strict accounting taxonomy perfectly across four distinct reporting periods to successfully generate the matrix.
Case 5: Table-Index Query for Multi-Metric Domain Understanding (Capital & Equity Structuring)
Company & PeriodCompany: 300986, Zhite New Materials Target Periods: 2022Y, 2023Y, 2024Y, and 2025Q3.
Task ParadigmTable-Index. The model must output a structured JSON tuple_list (a 2D array) containing three derived financial metrics across four different reporting periods. The output values must be scaled to ten-thousands and rounded to two decimal places.
Capability AxisDomain Understanding. The primary bottleneck is computing the “Total Invested Capital”. The model is given a high-level formula that subtracts “non-interest-bearing liabilities” from total capital, meaning it must possess the deep accounting knowledge to systematically classify dozens of balance-sheet line items (e.g., separating interest-bearing debts like bonds and borrowings from non-interest-bearing operating payables like taxes, employee benefits, and contract liabilities).
Input StatementsA massive, uncropped sequence of financial tables: (1) 2022Y Consolidated & Parent Balance Sheets (2) 2023Y Consolidated & Parent Balance Sheets (3) 2024Y Consolidated & Parent Balance Sheets (4) 2025Q3 Consolidated Balance Sheets (Includes tens of thousands of tokens covering over 100 distinct line items per period.)
User Instruction“Extract or calculate Zhite New Materials’ Working Capital, Retained Earnings, and Total Invested Capital for 2022Y, 2023Y, 2024Y, and 2025Q3. Unit: ten-thousands, rounded to 2 decimal places. Output as a JSON tuple list wrapped in ‘‘‘json tags.”
Injected Formula∙ Working Capital = Total Current Assets − Total Current Liabilities ∙ Retained Earnings = Surplus Reserve + Unappropriated Profit ∙ Total Invested Capital = Total Shareholders’ Equity + Total Liabilities − Non-interest-bearing Current Liabilities − Non-interest-bearing Non-current Liabilities
Calculation ProcessStep 1: Metric Extraction across 4 periods. The model retrieves the stated totals (e.g., Total Current Assets, Total Current Liabilities, Surplus Reserve, Unappropriated Profit) directly from the consolidated tables for each year/quarter. Step 2: Component Classification (The Domain Challenge). For the Total Invested Capital calculation, the model must scan the entire liabilities section for each period and deduct all non-interest-bearing items. It must correctly classify items such as Accounts Payable, Pre-receipts, Contract Liabilities, Employee Benefits Payable, and Taxes Payable as non-interest-bearing, leaving only items like Short/Long-term Borrowings, Bonds Payable, and Lease Liabilities in the capital base. Step 3: Scaling and JSON Structuring. The resulting arrays are divided by 10,000, rounded to two decimal places, and mapped into a strict 3-row by 4-column JSON array.
Ground Truth‘‘‘json [ ["-19368.16", "20477.45", "-1423.26", "-27180.48"], ["75991.92", "68198.91", "73104.71", "82318.87"], ["274889.00", "363636.97", "401096.25", "422101.34"] ] ‘‘‘
Table 10: A Table-Index case testing both Temporal Reasoning and Caliber Alignment. The model is provided with accumulated (YTD) financial statements and must dynamically unroll them into discrete standalone quarters before executing cross-metric calculations (Gross Profit) and temporal comparisons (YoY Growth).
Case 6: Table-Index Query for Standalone Quarter YoY Growth (Temporal & Caliber Alignment)
Company & PeriodCompany: 300963, Zhongzhou Special Materials Target Periods: 2022Q1, 2022Q2 (Standalone), and 2022Q3 (Standalone).
Task ParadigmTable-Index. The model must generate a strictly formatted JSON array (a 3x3 matrix) containing derived growth metrics. The output must be rounded to two decimal places (representing percentages, though output as raw string numbers per instruction).
Capability AxisTemporal Reasoning + Complex Caliber Alignment. ∙ Temporal: The model must de-cumulate Year-to-Date (YTD) figures from H1 and Q3 reports to isolate standalone Q2 and Q3 figures for both the current year and the prior year. ∙ Caliber: It must compute “Gross Profit” by aligning standalone Revenue and standalone Cost before applying the Year-over-Year (YoY) growth formula.
Input StatementsA continuous time series of full financial reports: (1) 2021Y (Annual) Statements (2) 2022Q1 Statements (3) 2022H1 (First Half) Statements (4) 2022Q3 (First Three Quarters YTD) Statements (The prior-year baseline figures for 2021Q1, 2021H1, and 2021Q3 are embedded in the comparative columns of the 2022 reports.)
User Instruction“Calculate the standalone quarterly YoY growth rates for Total Operating Revenue, Operating Profit, and Gross Profit for 2022Q1, 2022Q2, and 2022Q3. Express ratio data in percentages rounded to two decimal places. Output all final results as a JSON list wrapped in ‘‘‘json tags.”
Injected Formula∙ Standalone YoY Growth = (Current Standalone Quarter − Prior Year Same Standalone Quarter) / ABS(Prior Year Same Standalone Quarter) ×100 ∙ Standalone Gross Profit = Standalone Operating Revenue − Standalone Operating Cost
Calculation ProcessStep 1: Temporal De-cumulation (YTD to Standalone). To find 2022Q2 standalone revenue, the model must subtract 2022Q1 revenue from 2022H1 revenue. To find 2022Q3 standalone revenue, it must subtract 2022H1 revenue from 2022Q3 YTD revenue. This process must be repeated for Operating Profit, Operating Costs, and for the 2021 base-year figures. Step 2: Caliber Alignment (Gross Profit). Once the standalone Q1, Q2, and Q3 Revenues and Costs are unrolled, the model subtracts Cost from Revenue to derive the standalone Gross Profit for each quarter in both 2022 and 2021. Step 3: YoY Calculation and JSON Structuring. Apply the YoY formula to the derived standalone metrics. Format the resulting 9 values into a 3x3 JSON array.
Ground Truth‘‘‘json [ ["11.27", "5.44", "52.17"], ["113.94", "75.23", "202.25"], ["32.07", "23.08", "58.49"] ] ‘‘‘
Table 11: Detailed Test Accuracy (%) on FinIndices (With Hint). Results are grouped by task paradigm and capability axes.
Capability AxisClaude-4.5Gemini-3.1GPT-5.4DS-V4-ProGLM-5Qwen3.5-PlusQwen3.5-35B-A3B
Task: Single-Index
Domain Understanding78.7976.4771.8871.8861.7669.7061.29
Caliber Alignment64.0084.9081.4467.9154.1372.9267.43
Temporal + Caliber59.4274.6768.1259.2646.2569.5761.54
Temporal + Domain52.8359.2658.3334.5532.7342.5547.27
Task: Table-Index
Domain Understanding63.6463.6472.7368.1845.4568.1827.27
Caliber Alignment27.9163.9550.0032.5620.9352.3323.26
Temporal + Caliber56.2590.6290.6259.3837.5078.1240.62
Temporal + Domain76.4776.4788.2476.4788.2488.2429.41
Table 12: Detailed Test Accuracy (%) on FinIndices (Without Hint). The removal of explicit formulas causes a systemic collapse across all capability axes, particularly on pure domain and caliber alignment tasks.
Capability AxisClaude-4.5Gemini-3.1GPT-5.4DS-V4-ProGLM-5Qwen3.5-PlusQwen3.5-35B-A3B
Task: Single-Index
Domain Understanding55.8862.5048.4842.4237.5043.7548.48
Caliber Alignment51.4668.4761.0548.9837.9154.2650.17
Temporal + Caliber54.4160.8158.7351.8541.4644.1245.00
Temporal + Domain54.7251.9238.7835.8525.0040.0050.00
Task: Table-Index
Domain Understanding18.1822.7318.1827.279.0918.184.55
Caliber Alignment12.7923.2615.1211.639.3013.959.30
Temporal + Caliber37.5068.7559.3850.0025.0056.2515.62
Temporal + Domain76.4776.4776.4758.8270.5947.0641.18
Table 13: Taxonomy of 5 representative failure modes for large-scale models. By contrasting flawed generation trajectories against correct domain logic, we expose severe vulnerabilities in temporal de-cumulation, caliber alignment, and formula adherence.
Case 1: Semantic Anchor Trap (Domain Axis)
Target & ContextNet Income from Value Changes | 2025H1 Income Statement (RuiDi Drives).
Ground Truth289.1 (10k RMB) | Formula: Investment Income + Fair Value Change + Exchange Gain + Hedging Gain.
Erroneous Trajectory-24.5. Triggered by the literal string “Value Change,” the model solely extracted “Fair value change income” (-245,236) and ignored the “Investment Income” (3,136,526) necessary for the full aggregated formula.
Root CauseSemantic Rigidity. The model lacks the internal domain mapping to recognize that “Value Change” is an umbrella financial indicator, falling for a surface-level lexical match.
Case 2: Cognitive Overload in De-cumulation (Temporal Axis)
Target & Context2022Q3 Single-Quarter Gross Profit YoY Growth | 2022Q3 YTD, 2022H1, and 2021 statements (Zhongzhou).
Ground Truth58.49% | Formula: G​PQ​3​_​s​i​n​g​l​e=(R​e​vY​T​D−R​e​vH​1)−(C​o​s​tY​T​D−C​o​s​tH​1).
Erroneous Trajectory202.25%. The model correctly computed the 2022Q3 single-quarter profit. However, for the baseline year (2021Q3), it lost track of the constraint and directly used the 2021Q3 YTD profit as the denominator.
Root CauseContextual Amnesia. When nesting temporal subtractions inside a comparative ratio formula, the attention mechanism fails to replicate the de-cumulation logic across historical reporting years.
Case 3: Ignoring Structural Caliber (Caliber Axis)
Target & ContextAnnualized Return on Assets (ROA) | 2025Q3 Income Statement, 2025Q3 & 2024Y Balance Sheets (Suneng).
Ground Truth1.217% | Formula: (N​e​t​P​r​o​f​i​tQ​3×43)/A​v​e​r​a​g​e​T​o​t​a​l​A​s​s​e​t​s.
Erroneous Trajectory1.208%. The model successfully annualized the profit flow but directly divided it by the Ending Total Assets (39.74B), completely ignoring the Beginning Assets.
Root CauseStock-Flow Mismatch. The model treats numerical extractions as flat variables, demonstrating a severe lack of caliber alignment awareness (averaging stocks to match flows) necessary for cross-statement integration.
Case 4: Rigid Formula Disobedience
Target & ContextCash Return on Investment Ratio | Xiangtan Elec. 2018Q3 (Round to 1 decimal).
Ground Truth0.5 | Formula: Net Operating CF / (Fixed Asset Cash Paid + Dividends - Financial Exp.)
Erroneous Trajectory0.4. The model computed the denominator as 386,026,411.74.
Root CauseInstruction Disobedience. The model failed to strictly follow the multi-step denominator formula provided in the prompt. It selectively omitted the required subtraction of “Financial Expenses”, showing rigidity when facing custom composite indicators.
Case 5: Conceptual Misalignment and Taxonomy Confusion
Target & ContextTangible Asset Net Value | Zhixin Precision 2025H1 (Unit: 10M RMB).
Ground Truth97.0 | Formula: Equity Attributable to Parent - (Intangibles + Goodwill + Deferred Tax Assets, etc.)
Erroneous Trajectory99.8. The model used generic “Total Owner’s Equity” as the base.
Root CauseTaxonomy Confusion. The model failed to distinguish the fine-grained boundary between “Total Equity” and “Equity Attributable to Parent Company”. Furthermore, it missed deductions required by new accounting standards (e.g., Deferred Tax Assets).
Table 14: Scaling collapse and format hallucination in small parameter models. The model fails the arithmetic scaling step (incorrect decimal shift) and hallucinates JSON dictionary keys instead of the requested nested tuple array.
Small Model Case: Scaling Collapse and Format Hallucination
Target MetricWorking Capital, Retained Earnings, Total Invested Capital (2022Y - 2025Q3)
Constraints1. Unit: 10,000 RMB (Divide raw values by 104). 2. Format: tuple_list (e.g., [["Year", Val1, Val2, ...]]). 3. Precision: Round to 2 decimal places. Frequency: Annual basis.
Ground Truth[["2022Y", -19368.16, 75991.92, 274889.0], ...]] (Strict division by 104, correct formula logic, compliant tuple formatting)
Model Output[{"Year": "2022Y", "Working_Capital_10k": -1936.82, "Retained_Earnings_10k": 7599.19, "Total_Invested_Capital_10k": 27494.20}, ...}]
Table 15: Ablation of Temporal Misalignment. By evaluating identical YoY indicator types individually versus inside a unified HTML table, we isolate the failure trigger. Gemini possesses the temporal logic to fetch correct prior-period reports (evidenced by 100% isolated accuracy), but systematically substitutes wrong, adjacent columns (e.g., Beginning Balance) to lazily fulfill structural constraints under the cognitive load of multi-metric table generation.
Financial IndicatorAccounting & Calculation LogicIsolated Query (single_indice)Table Query (table_indice)Bottleneck Analysis
Net Asset YoY GrowthTemporal mapping: Current End−Prior Year Same PeriodABS(Prior Year Same Period)Xinlaifu: ✓ GT: 6.19% Pred: 6.19%Tongdahai: ✗ GT: -4.22% Pred: -3.25%Temporal Misalignment (Column Substitution). In isolation, the model correctly locates the Prior Year Same Period report. In the table, it lazily substitutes the adjacent “Beginning Balance” column to force-fill the structural schema: (1311.76​M−1355.79​M)/1355.79​M=−3.25%.
Net Profit Cash Content YoYComplex cross-statement derivation: Compute Operating CF / Net Profit, then calculate YoY.Gelin Jingmi: ✓ GT: 12349.1% Pred: 12349.1%Tongdahai: ✓ GT: -11.48% Pred: -11.48%Maintained. The model can execute complex cross-statement math when the required YoY columns are explicitly aligned in the source statements.
Operating Profit YoYStandard line-item YoY derivation: Deduct prior year operating profit; divide by ABS prior year.Zhongzhou Tecai: ✓ GT: 6.0% Pred: 6.0%Tongdahai: ✓ GT: -29.34% Pred: -29.34%Maintained. Simple horizontal math extraction survives the structural load because the “Prior Period” column is explicitly provided in the Income Statement.
Table 16: Ablation of the Aggregation Shortcut. By evaluating the exact same five indicators individually versus as a unified table, we isolate the failure trigger. Gemini possesses the knowledge to solve complex operating adjustments (evidenced by 100% isolated accuracy), but systematically abandons this rigor for a shallow shortcut under the cognitive load of multi-metric table generation.
Financial IndicatorAccounting & Calculation LogicIsolated Query (single_indice)Table Query (table_indice)Bottleneck Analysis
Operating Net / Total ProfitDeep CAS adjustment (incorporating Impairment Losses outside OpCost).ST Tongde: ✓ GT: 104.0% Pred: 104.0%Zhenyu Tech: ✗ GT: 94.06% Pred: 129.82%Aggregation Shortcut. In isolation, Gemini executes the CAS logic perfectly. Inside the table, it defaults to a lazy literal (R​e​v−C​o​s​t)/P​r​o​f​i​t shortcut to save cognitive effort.
Single-Quarter ROEDeduct prior quarter net profit; divide by average parent equity.Dingrongyan: ✓ GT: 4.6% Pred: 4.6%Zhenyu Tech: ✓ GT: 3.70% Pred: 3.70%Maintained. Standard ratio logic survives the structural load.
Admin Expense / Revenue RatioDeduct prior quarter values to isolate single quarter; compute ratio.Zhongjin: ✓ GT: 18.2% Pred: 18.2%Zhenyu Tech: ✓ GT: 2.73% Pred: 2.73%Maintained. Shallow numerator-denominator mapping remains stable.
Value-Change Net IncomeSum fair-value change, investment income, and FX income; adjust unit.Zanyu Tech: ✓ GT: 13,333.95 Pred: 13,333.95Zhenyu Tech: ✓ GT: 139,014.56 Pred: 139,014.56Maintained. Additive aggregation remains unaffected by table constraints.
Investing Cash Flow RatioAggregate three distinct CF categories; compute proportional share.Tianxin: ✓ GT: -97.15% Pred: -97.15%Zhenyu Tech: ✓ GT: -176.44% Pred: -176.44%Maintained. Multi-step but structurally salient on the cash flow statement.
Table 17: Comprehensive Taxonomy of Formulaic Sources. The “Ratio” denotes the percentage of total formulas derived from each framework. Color coding: Target Ratio/Metric, Core Financial Item, and Adjustment/Normalization Factor.
Source IdentifierRatioSource OverviewRepresentative Examples
Financial Reporting Analysis (Revsine)58.05%An analytical framework utilized for global financial statement analysis. It establishes the methodology for period-to-period reconciliation and Trailing Twelve Months (TTM) adjustments to ensure cross-period comparability.• OCF_Margin(TTM) = OCF(TTM) / Revenue(TTM) • ROIC(TTM) = NOPAT(TTM) / Avg_Invested_Capital • Net_Profit_Ratio(TTM) = Net_Profit(TTM) / Revenue(TTM)
Chinese Accounting Standards (CAS)35.34%The statutory reporting standard issued by the Ministry of Finance of China. It defines the rigorous line-item classification for listed companies across general and financial (Banking, Securities, Insurance) sectors.• Interest_Bearing_Debt = Total_Liabs - Non-interest_Liabs • EBITDA = Op_Profit + Depr_Amort + Interest_Exp • Operating_Revenue = Net_Interest + Net_Fee + …
Textbooks6.61%Derived from authoritative global textbooks, including McKinsey’s Valuation, Ross’s Corporate Finance, and Kieso’s Intermediate Accounting, which serve as standard academic references.• FCFF: EBIT(1-t) + D&A - CapEx - ΔWorking_Cap • Cash Cycle: Inv_Days + Rec_Days - Pay_Days • ROE: Net_Income / [(Equity_beg + Equity_end)/2]

Findings

  • Removing the formula hint dropped Gemini-3.1-Pro's Table-Index accuracy from 70.07% to 38.22%, and Claude-Opus-4.8 managed only 38.85% without hints.
  • Even with hints, Gemini-3.1-Pro's accuracy fell from 79.61% on Single-Index tasks to 70.07% on Table-Index tasks, showing table generation is intrinsically harder than single-value calculation.
  • The finance-pretrained model DianJin-R1-32B scored 41.29% on Single-Index tasks with hints but collapsed to 11.41% (with hint) and 5.33% (without hint) on Table-Index tasks; other finance models Fin-R1 and Llama-Fin-8B scored near 0%.
  • On Table-Index tasks with hints, Caliber Alignment was the weakest capability, with the top model Gemini-3.1 reaching only 63.95% and GPT-5.4 only 50.00%; removing hints made GPT-5.4's Domain Understanding drop from 72.73% to 18.18% and Gemini's Caliber Alignment drop from 63.95% to 23.26%.
  • Fine-tuning Qwen3.5-35B-A3B on 6,301 Gemini-distilled reasoning trajectories improved hintless accuracy by +8.54% on Single-Index and +3.82% on Table-Index tasks, while also improving general finance QA benchmarks (CFinBench, FinEval, FLAME, etc.) by +0.61% to +2.39% without catastrophic forgetting.

Where it can be used

  • Teams deploying financial-analysis AI agents can add a step that specifically tests accuracy when formulas are not spelled out in the prompt, rather than trusting hinted performance.
  • Pipelines that generate multi-metric financial tables can add per-cell verification steps to catch the kind of structural errors documented here.
  • Organizations evaluating finance-specific LLMs can use this benchmark's task split (single value vs. multi-period table) as a template for testing beyond simple QA accuracy.

Limits and open work

  • The benchmark is built from Chinese listed companies' filings under Chinese Accounting Standards, so it's unverified whether findings transfer to other countries or accounting frameworks.
  • The reported SFT improvements come from one specific model (Qwen3.5-35B-A3B) and one distilled dataset size, so generalization to other models or larger fine-tuning sets is not established.
  • Scoring uses strict exact-match/all-or-nothing criteria, so answers that are substantively correct but formatted differently may be marked wrong, which could understate real-world usability in some cases.

Why it matters

Real financial analysis work ends in an audit-ready table built from many reconciled figures, and this study shows with concrete numbers that current LLMs largely memorize formulas rather than truly understanding accounting logic. Anyone considering deploying an LLM-based financial agent needs to know exactly where that trust breaks down.

Terms in this paper

  • Single-Index / Table-Index · Tasks that ask for one computed value (Single) versus tasks requiring a full multi-metric table (Table)
  • With Hint / Without Hint · Whether the calculation formula is given in the prompt or not
  • TTM (Trailing Twelve Months) · A rolling 12-month figure computed by combining data from multiple quarterly reports
  • Stock vs. flow alignment · Reconciling a point-in-time balance (like inventory) with a period-total flow (like revenue) in one calculation
  • SFT (Supervised Fine-Tuning) · Further training a model on examples that include correct reasoning steps

Original abstract (English)

Do Large Language Models (LLMs) possess genuine structural reasoning, or merely rely on surface-level pattern matching? The financial domain, demanding numerical precision and multi-step logic over long contexts, is an ideal testbed. Existing benchmarks fail to capture real-world industrial complexity, predominantly relying on multiple-choice questions or single-hop QA over cropped tables while ignoring intricate cross-statement dynamics and temporal de-cumulation. To bridge this gap, we introdu

Authors · Xinke Tong

Read on arXiv

Latest papers

All papers →

Latest from METAL LAB

Figures: Xinke Tong et al., arXiv:2607.28661, arxiv-nonexclusive