100 Best Gemini Financial Statement Analysis Prompts for Accountants

Direct Answer

The best Gemini prompts for financial statement analysis for accountants are designed to extract precise insights from balance sheets, income statements, and cash flow data. Each prompt assigns a clear role, a concrete task, a realistic context, and explicit output formats to produce audit-ready results. Use placeholders to tailor outputs, and verify results against source data before sharing.

Introduction

This page is a practical prompt library focused on financial statement analysis for accountants. It provides ready-to-use Gemini prompts to analyze, interpret, and report on financial statements with high accuracy.

Designed for accountants, FP&A professionals, auditors, and finance managers, the prompts help standardize analysis workflows, improve consistency, and accelerate financial decision making.

How to Use These Gemini Prompts

• Replace placeholders like [industry], [company], or [data] with your actual figures and context.
• Add constraints or formats to force the desired output, such as a 1-page memo or a CSV table.
• Ask for comparison against benchmarks or prior periods to gain actionable insights.
• Require outputs to be audit-ready with clear data sources and assumptions.
• Run prompts in batches and review outputs for data gaps before dissemination.
• Adjust tone and format to fit internal reports or external communications.

100 Best Gemini Financial Statement Analysis Prompts for Accountants

1. Balance sheet ratio check: Adopt the persona of a senior accountant analyst. Task: evaluate the latest balance sheet for liquidity and solvency. Context: company X with provided figures: current assets, current liabilities, long-term debt, equity, and cash. Output format: bullet-point summary with computed Current Ratio, Quick Ratio, Debt-to-Equity, and Cash Burn rate, plus a one-page action memo. Constraints: use at most two decimal places, cite assumptions, identify data gaps.
2. Cash flow impact analysis: Act as a financial analyst in an audit team. Task: assess how operating cash flow changes affect overall liquidity. Context: cash flow statement sections, tax payments, depreciation, and working capital shifts. Output format: structured report with executive summary, 5 bullet insights, and 2 recommended adjustments. Constraints: avoid projections beyond current fiscal year unless specified by the user.
3. Revenue quality review: You are a revenue analyst. Task: evaluate revenue recognition quality from the income statement. Context: revenue by product line, term of sales, returns, and channel mix. Output: table of revenue by line with recognition risk score (low/medium/high) and 3 remediation steps. Constraints: rely on publicly stated policies and common accounting standards.
4. Expense trend comparison: Assume a management accountant role. Task: compare operating expenses year-over-year and identify anomalies. Context: by department, fixed versus variable costs, seasonality. Output: narrative with 5 key trends and 4 cost-containment ideas. Constraints: provide numeric examples where possible.
5. Working capital forecast: Serve as a financial planner. Task: forecast short-term working capital needs for the next 6 quarters. Context: receivables collection period, payables terms, inventory turnover. Output: quarterly forecast with sensitivity analysis for two scenarios. Constraints: include at least one best-case and one worst-case scenario.
6. Ratio benchmarking vs peers: Role: benchmarking analyst. Task: compute and compare key liquidity and profitability ratios to a peer group. Context: company X vs peers Y and Z. Output: side-by-side table with explanations and action items. Constraints: use publicly disclosed peer data and note data gaps.
7. Account reconciliations prep: Act as an internal auditor assistant. Task: prepare a reconciliation checklist for bank and cash accounts. Context: trial balance, bank statements, outstanding checks, deposits in transit. Output: checklist with 12 steps and risk notes. Constraints: align with internal control frameworks.
8. Inventory valuation check: Role: inventory analyst. Task: assess valuation method appropriateness and impact on cost of goods sold. Context: FIFO vs LIFO vs weighted average, obsolescence, scrap. Output: decision matrix with recommended method and impact on margins. Constraints: consider tax implications.
9. Debt covenant review: Act as a compliance analyst. Task: analyze debt covenants and potential breach indicators. Context: covenant tests, debt terms, financial ratios. Output: risk alert list with remediation plan and escalation steps. Constraints: be precise about trigger levels.
10. Tax impact estimation: Role: tax planner. Task: estimate tax expense impact from year-end adjustments. Context: taxable income, credits, deferrals, rate changes. Output: calculation sheet summary and two optimization recommendations. Constraints: show calculations and assumptions.
11. Cash vs accrual comparison: Position: accounting policy consultant. Task: contrast cash flow vs accrual basis effects on reported profitability. Context: income statement and cash flow statement items. Output: concise memo with 4 contrasting points and 2 policy recommendations. Constraints: avoid projections beyond current year.
12. Fixed asset impairment review: Role: asset management analyst. Task: evaluate indicators of impairment for fixed assets. Context: asset age, carrying value, undiscounted cash flows. Output: impairment indicator score and recommended action plan. Constraints: follow IFRS or relevant standards.
13. Accounts receivable aging: Act as credit controller. Task: analyze accounts receivable aging report and collection risk. Context: days sales outstanding by customer segment, bad debt history. Output: risk matrix with 5 action items and target collection date estimates. Constraints: focus on high-risk customers.
14. Capital expenditure ROI: Role: investment analyst. Task: assess ROI for a proposed capex project. Context: project cost, depreciation, cash inflows, payback period. Output: ROI calculation with sensitivity to discount rate and occupancy. Constraints: present a break-even analysis.
15. Expense budgeting scenario: Act as a budget analyst. Task: generate a budget scenario for next year with three variants. Context: fixed costs, variable costs, revenue projections. Output: spreadsheet-style summary with variance analysis and risk notes. Constraints: include at least three contingency items.
16. Financial statement notes: Role: financial reporter. Task: draft concise notes explaining unusual items on the financial statements. Context: one-off gains, impairment, policy changes. Output: 1-page notes suitable for external report. Constraints: avoid legal risk language.
17. Revenue leakage audit: Position: internal auditor. Task: identify potential revenue leakage points in billing. Context: pricing, discounts, rebates, channel partners. Output: audit findings with 6 recommendations and 2 control improvements. Constraints: be audit-ready.
18. Liquidity crisis scenario: Role: crisis analyst. Task: model a liquidity stress scenario and mitigation. Context: cash reserves, borrowing capacity, supplier terms. Output: scenario report with 4 stress indicators and 3 response steps. Constraints: assume a 6-week shock.
19. Break-even by product: Act as product accounting analyst. Task: determine break-even units for top-selling product. Context: variable cost per unit, fixed costs, price per unit. Output: break-even chart description and 2 margin improvement ideas. Constraints: provide exact break-even point.
20. Depreciation method impact: Role: accounting policy advisor. Task: compare depreciation methods and effect on profits. Context: asset class mix, useful life, salvage value. Output: side-by-side comparison with 3 recommendations. Constraints: cite standards.
21. Cross-period reconciliations: Position: financial controller. Task: ensure cross-period consistency for revenue and expenses. Context: prior-year comparisons, restatements. Output: reconciliation plan with 8 steps and data requirements. Constraints: maintain audit trail.
22. Gross margin analysis: Role: margin analyst. Task: dissect gross margin by product line. Context: COGS variances, pricing, discounts. Output: 4 insights and 2 optimization actions. Constraints: avoid guesswork; base on data.
23. Scenario planning prompts: Act as strategist. Task: create three forward-looking financial scenarios. Context: revenue, costs, inflation, exchange rates. Output: narrative scenarios with key drivers and risk notes. Constraints: keep to three scenarios.
24. Audit inquiry ready: Role: audit liaison. Task: generate responses to typical external questions. Context: company policies, controls, financial statements. Output: a concise Q&A pack of 6 items. Constraints: align with standard audit expectations.
25. Intercompany reconciliation: Position: intercompany accountant. Task: reconcile intercompany balances. Context: intercompany receivables/payables, currency effects. Output: reconciliation file with 6 exception items and resolution steps. Constraints: ensure elimination entries are prepared.
26. Expense reclassification: Role: financial analyst. Task: classify ambiguous expenses correctly. Context: mixed categories, supporting documents. Output: reclassification plan with 5 lines and impact on P&L. Constraints: justify each change.
27. P&L by region: Act as regional analyst. Task: break down income statement by geographic region. Context: revenue by region, cost allocation. Output: regional P&L with 3 insights and 2 regional recommendations. Constraints: ensure accurate currency handling.
28. Intangible asset review: Role: asset accountant. Task: assess impairment risk for intangibles. Context: useful life, market multiples, impairment indicators. Output: risk rating and remediation plan. Constraints: reference accounting standards.
29. Earnings quality check: Position: financial analyst. Task: assess earnings quality using accruals, cash flow, and one-time items. Context: last four quarters. Output: quality score with 4 actionable notes. Constraints: avoid speculation.
30. Revenue by channel: Role: channel analyst. Task: analyze revenue by channel performance. Context: direct, wholesale, online, and partnerships. Output: channel performance memo with 5 recommendations. Constraints: base on documented data.
31. Cost of capital view: Act as finance strategist. Task: assess cost of capital impact on project decisions. Context: WACC, project cash flows, risk. Output: decision memo with 3 scenarios. Constraints: avoid external factors beyond scope.
32. GAAP vs IFRS impact: Role: standards advisor. Task: compare impact of GAAP and IFRS on reported figures. Context: revenue, depreciation, leasing. Output: summary chart and 2 practical implications. Constraints: stay within topic.
33. Period-end close checklist: Position: close coordinator. Task: produce a period-end close checklist. Context: journal entries, reconciliations, disclosures. Output: 14-step checklist with owners and due dates. Constraints: align with internal controls.
34. Disclosures drafting: Role: financial writer. Task: draft mandatory disclosures succinctly. Context: unusual items, risks, uncertainties. Output: disclosure paragraph per topic with bullet points. Constraints: avoid legal risk.
35. Currency translation impact: Act as forex analyst. Task: assess translation effects on consolidated statements. Context: foreign subsidiaries, exchange rate movements. Output: summary with 3 impact notes and hedging recommendations. Constraints: use consistent rates.
36. Segment profitability: Role: business analytics. Task: compute segment profitability and ROI by unit. Context: revenue, costs, allocation method. Output: segment scorecard with 4 actions. Constraints: ensure fair allocation.
37. Acquisition integration: Position: financial integration lead. Task: forecast financial impact of an acquisition. Context: purchase price, synergies, integration costs. Output: synergy realization plan with 6 milestones. Constraints: include integration risks.
38. Dividend capability check: Role: treasury analyst. Task: evaluate ability to pay dividends under covenants. Context: cash, debt obligations, free cash flow. Output: dividend readiness report with 3 scenarios. Constraints: respect covenants.
39. Non-GAAP reconciliation: Act as financial officer. Task: prepare reconciliation of non-GAAP to GAAP measures. Context: adjustments, anti-dilutive items. Output: reconciled numbers with disclosures. Constraints: be precise.
40. Interim reporting prompts: Role: reporting specialist. Task: generate prompts for interim financial statements. Context: condensed disclosures, performance metrics. Output: interim report outline with 8 sections. Constraints: align with regulatory expectations.
41. Lease accounting analysis: Position: lease specialist. Task: analyze lease impact on balance sheet. Context: right-of-use assets, lease liabilities, classifications. Output: impact summary with 5 recommendations. Constraints: reference standards.
42. Audit trail creation: Role: compliance officer. Task: create a robust audit trail for financial data. Context: data lineage, versioning, approvals. Output: audit trail specification with 12 fields. Constraints: ensure traceability.
43. Cash forecast accuracy: Act as treasury modeler. Task: measure cash forecast accuracy. Context: forecast vs actual cash flows over 8 periods. Output: accuracy metrics and improvement plan. Constraints: show variance sources.
44. Consolidation prompts: Role: consolidation analyst. Task: guide group-wide consolidation process. Context: intercompany eliminations, currency translation. Output: step-by-step consolidation prompts with checks. Constraints: maintain consistency.
45. Profitability by product: Position: product finance analyst. Task: analyze profitability by product line. Context: revenue, COGS, marketing spend. Output: 6 actionable profitability insights. Constraints: include margin impact.
46. Accounts payable aging: Role: AP manager. Task: analyze payables aging report and liquidity risk. Context: vendor terms, early payment discounts. Output: risk-based action plan with 5 items. Constraints: focus on high-risk vendors.
47. Capital structure options: Act as corporate finance advisor. Task: compare financing options. Context: debt vs equity, cost, control implications. Output: decision matrix with 4 scenarios. Constraints: assume standard terms.
48. Expense leakage fix: Role: controller. Task: identify and fix expense leakage. Context: frequent overruns, approval bottlenecks. Output: 5 fixes and expected impact. Constraints: quantify savings.
49. Pension obligation impact: Position: actuarial analyst. Task: evaluate pension obligations on statements. Context: discount rate, plan assets, funding status. Output: impact summary with 3 risk notes. Constraints: align with standards.
50. Tax provision prompts: Role: tax accountant. Task: prepare deferred tax provision prompts. Context: temporary differences, tax rates. Output: calculation steps and disclosure notes. Constraints: ensure accuracy.
51. Inventory turnover prompts: Act as inventory strategist. Task: analyze turnover and aging. Context: SKU mix, obsolescence risk. Output: turnover ratios with 4 improvement ideas. Constraints: base on data.
52. Impairment indicators: Role: impairment reviewer. Task: identify indicators across assets. Context: market conditions, carrying values, recoverable amount. Output: impairment risk chart with actions. Constraints: follow standards.
53. Revenue mix optimization: Position: revenue strategist. Task: optimize revenue mix for margin. Context: product lines, pricing, promotions. Output: 4 mix scenarios and impact estimates. Constraints: data-backed.
54. Disclosures automation: Role: disclosure automation engineer. Task: automate standard disclosures drafting. Context: quarterly and annual requirements. Output: automation blueprint with 6 steps. Constraints: maintain accuracy.
55. Cost cut benchmarking: Act as cost analyst. Task: benchmark costs against industry peers. Context: departmental spend, SG&A. Output: benchmark report with 5 cuts and 2 risks. Constraints: use public data.
56. Liquidity ratio drill: Role: finance trainer. Task: generate drill prompts to practice liquidity ratios. Context: current ratio, quick ratio, cash ratio. Output: 6 drill prompts with answers. Constraints: include explanations.
57. Forecast vs budget check: Position: forecasting lead. Task: compare forecast to budget and explain variances. Context: revenue, expenses, timing. Output: variance report with 5 drivers. Constraints: focus on material items.
58. Accounts receivable policy: Role: policy writer. Task: draft receivables policy update. Context: credit terms, allowance for doubtful accounts. Output: policy document with 7 sections. Constraints: align with standards.
59. Vendor contract accounting: Act as vendor accounting advisor. Task: analyze how contracts affect revenue and expenses. Context: pricing, rebates, terms. Output: contract accounting notes with 4 items. Constraints: ensure compliance.
60. Disaster recovery prompts: Role: risk analyst. Task: prepare prompts for financial impact of disasters. Context: liquidity, insurance, operations. Output: 5 prompts with expected outputs. Constraints: realistic scenarios.
61. Audit readiness digest: Position: internal auditor. Task: summarize key evidence for audits. Context: control tests, reconciliations, approvals. Output: digest with 8 items. Constraints: concise.
62. Audit risk indicators: Role: risk auditor. Task: identify high-risk areas for audits. Context: revenue, cash, inventory. Output: risk map with mitigations. Constraints: map to controls.
63. Cash conversion cycle: Act as financial analyst. Task: compute and optimize CCC. Context: DIO, DSO, DPO. Output: CCC breakdown with 3 improvement actions. Constraints: data-driven.
64. Consolidated KPIs: Role: performance analyst. Task: define KPIs for consolidated statements. Context: liquidity, profitability, efficiency. Output: KPI set with targets and data sources. Constraints: actionable.
65. Expense timing analysis: Position: cost controller. Task: analyze timing of expenses versus revenue. Context: accruals, prepaids, timing differences. Output: impact report with 4 recommendations. Constraints: tie to cash flow.
66. Share-based compensation: Role: compensation analyst. Task: model accounting impact of stock-based pay. Context: vesting, fair value, expense recognition. Output: accounting entries and disclosures with 3 notes. Constraints: align with standards.
67. Leases vs buys prompt: Act as finance advisor. Task: evaluate lease vs buy for asset. Context: cost of capital, tax, depreciation. Output: decision memo with 3 scenarios. Constraints: include sensitivity.
68. Nonfinancial disclosures: Role: ESG finance analyst. Task: draft nonfinancial disclosures related to finance. Context: governance, risk, compliance. Output: concise ESG note with 4 bullets. Constraints: link to metrics.
69. Intercompany eliminations: Position: consolidation accountant. Task: prepare eliminations schedule. Context: intercompany transactions, currency effects. Output: elimination journal entries plan with 6 items. Constraints: ensure accuracy.
70. Forecast bias check: Role: FP&A analyst. Task: detect bias in forecasts. Context: historical accuracy, consensus, adjustments. Output: bias report with 4 corrective steps. Constraints: use data-driven methods.
71. Credit risk prompts: Act as credit risk manager. Task: assess customer credit risk impact on financials. Context: aging, default history, concentration. Output: risk rating with mitigations in 5 bullets. Constraints: evidence-based.
72. Liquidity funding plan: Role: treasury planner. Task: design a liquidity funding plan. Context: cash reserves, debt facilities, covenant limits. Output: stepwise funding plan with 4 options. Constraints: safe and compliant.
73. Impairment walkthrough: Position: impairment specialist. Task: walk through impairment tests for assets. Context: cash-generating units, discount rates. Output: narrative walkthrough with 4 conclusions. Constraints: align with standards.
74. PPE impairment prompts: Role: asset analyst. Task: assess PPE impairment indicators. Context: market data, usage, obsolescence. Output: impairment likelihood and action list. Constraints: justify each item.
75. Deferred tax prompts: Act as tax accountant. Task: model deferred tax assets and liabilities. Context: timing differences, future tax rates. Output: deferred tax schedule with 6 notes. Constraints: accurate classifications.
76. Valuation adjustments: Role: valuation specialist. Task: propose adjustments to fair value measurements. Context: observable inputs, unobservable inputs. Output: adjustment rationale and 3 impacts. Constraints: document assumptions.
77. Audit evidence prompts: Position: audit assistant. Task: generate evidence prompts for tests. Context: controls, substantive tests, sampling. Output: 7 evidence prompts with expected artifacts. Constraints: align with standards.
78. Revenue timing prompts: Role: revenue controller. Task: examine timing of revenue recognition. Context: performance obligations, delivery. Output: timing conclusions with 4 recommendations. Constraints: cite policy.
79. Audit trail standards: Act as compliance auditor. Task: specify required audit trail features. Context: data lineage, approvals, versions. Output: standards list with 10 items. Constraints: clear traceability.
80. Materiality prompts: Role: audit planner. Task: define materiality thresholds for audits. Context: financial statements, user needs. Output: materiality framework with rules and examples. Constraints: transparency.
81. P&L restoration prompts: Position: restoration analyst. Task: reconstruct missing P&L elements from footnotes. Context: incomplete data, notes. Output: reconstructed P&L with 2 caveats. Constraints: conservative assumptions.
82. FinOps prompts: Role: financial operations lead. Task: optimize finance operations workflows. Context: approval cycles, automation tools. Output: workflow map with 6 improvements. Constraints: measurable impact.
83. Bank covenants prompt: Act as covenant manager. Task: monitor covenant compliance. Context: covenant tests, triggers, remedies. Output: monitoring schedule with 4 alerts. Constraints: timely reporting.
84. Sales commission prompts: Role: compensation finance. Task: calculate sales commissions accurately. Context: revenue data, targets, payout rules. Output: commission calculation worksheet and payout memo. Constraints: align with contract terms.
85. Disclosures risk prompts: Position: risk disclosure writer. Task: identify disclosure risks for investors. Context: uncertainties, forward-looking statements. Output: risk disclosures with 4 bullets. Constraints: avoid misstatement.
86. Cost center prompts: Role: cost controller. Task: allocate costs to centers. Context: overhead, activity-based costing. Output: cost center allocations with 6 notes. Constraints: consistent data.
87. Pension sensitivity: Act as pension analyst. Task: sensitivity of pension metrics to rate changes. Context: discount rate, plan assets, funding. Output: sensitivity table with 3 scenarios. Constraints: precise calculations.
88. Shareholder return prompts: Role: investor relations analyst. Task: quantify shareholder return metrics. Context: dividends, stock buybacks, earnings. Output: return profile with 4 metrics. Constraints: reportable.
89. Cost optimization prompts: Position: cost optimization lead. Task: identify optimization opportunities. Context: fixed and variable costs, efficiency. Output: 5 optimization ideas with impact estimates. Constraints: data-backed.
90. Capital budgeting prompts: Role: capital planning analyst. Task: evaluate capital projects. Context: NPV, IRR, payback. Output: project evaluation template with 4 fields. Constraints: standard assumptions.
91. Fraud risk prompts: Act as fraud examiner. Task: spot red flags in financials. Context: unusual entries, pressure points. Output: risk list with 6 indicators and controls. Constraints: evidence-based.
92. Cost behavior prompts: Role: cost analyst. Task: classify costs by behavior. Context: fixed, variable, mixed. Output: cost behavior matrix with 4 actions. Constraints: use data.
93. Financial policy prompts: Position: policy architect. Task: draft finance policies. Context: controls, approvals, documentation. Output: policy pack with 7 items. Constraints: implementable.
94. Journal entry prompts: Act as junior accountant. Task: draft standard journal entries for common events. Context: accruals, depreciation, accrual reversals. Output: entry templates with notes. Constraints: standard formatting.
95. Disclosures checklist: Role: reporting lead. Task: produce a disclosures checklist for the annual report. Context: required sections, accuracy. Output: 12-item checklist with owners. Constraints: auditable.
96. Financial statement prep: Position: financial preparer. Task: assemble inputs for statements. Context: trial balance, notes, schedules. Output: 1-page prep guide with 9 steps. Constraints: complete data requirements.
97. Audit package prompts: Role: audit liaison. Task: assemble audit package prompts for auditors. Context: evidence, controls, policies. Output: package outline with 8 sections. Constraints: accessible.
98. External reporting prompts: Act as external reporter. Task: prepare prompts for external reporting. Context: regulatory requirements, accuracy. Output: external report prompts with 6 items. Constraints: consistent with standards.
99. Disclosure comparison: Role: financial writer. Task: compare multiple disclosure options. Context: phrasing, risk statements. Output: comparison matrix with 4 criteria. Constraints: clarity.
100. Closing process prompts: Position: close process owner. Task: generate prompts for month-end close. Context: timing, responsibilities, checks. Output: closing playbook with 10 steps. Constraints: ensure completeness.

Best Practices

• Keep prompts specific to a single financial objective to reduce ambiguity.
• Require outputs to include data sources, assumptions, and rationale for each conclusion.
• Reuse prompts by varying context (e.g., different products, regions, or time periods) while preserving structure.
• Test prompts with small data samples first to ensure formatting and calculations are correct.
• Guard against over-reliance on a single model by cross-checking with your own calculations and notes.

Common Mistakes to Avoid

• Using vague goals like analyze the financials without specifying which aspects or time period.
• Omitting data sources or assumptions, making outputs hard to audit.
• Asking for outputs in an overly broad format, leading to inconsistent results.
• Ignoring currency, rate, or accounting policy details that affect comparability.
• Failing to verify outputs against the actual trial balance or schedule data.

FAQ

What are Gemini prompts for financial statement analysis used for?

They provide structured, repeatable instructions for Gemini to analyze financial statements, produce ratios, identify anomalies, and prepare audit-ready summaries.

How should I tailor prompts to my company data?

Replace placeholders with your actual financial figures, policies, and periods, and specify output format and any constraints needed for your reporting process.

Can these prompts help with audits?

Yes, many prompts generate audit-ready artifacts, reconciliations, and disclosures or notes that support external and internal audits.

How do I ensure accuracy of outputs?

Cross-check Gemini outputs against source schedules, use explicit data sources in prompts, and validate calculations manually when needed.

What output formats work best?

Concise narratives, bullet summaries, and structured tables (CSV or Markdown-like formats) that align with your reporting templates.

Are these prompts suitable for GAAP and IFRS?

Prompts can be tailored to reflect the applicable standards; specify the standard in the context to ensure relevant treatment.