100 Best Gemini Excel Data Analysis Prompts for Accountants

Direct Answer

The best Gemini prompts for Excel data analysis for accountants are designed to automate ledger data processing, improve accuracy, and accelerate reporting. Use them to clean data, reconcile accounts, and generate audit-ready outputs with clear, structured results.

Introduction

This page is a practical prompt library focused on Excel data analysis for accountants. It provides ready-to-use Gemini prompts that streamline common accounting data tasks.

Designed for accounting professionals, auditors, and finance teams, these prompts help transform raw workbook data into reliable, auditable outputs without guessing or manual formulas.

How to Use These Gemini Prompts

• Replace placeholders like [department], [date], and [currency] with your actual data fields.
• Add constraints such as date ranges, currency, or account scope to tailor prompts.
• Request outputs in a specific format, for example a CSV export, a pivot-ready table, or a structured checklist.
• Run prompts on a clean copy of the workbook to verify outputs before applying changes to production data.
• Iterate prompts by refining descriptions, adjusting filters, and validating results against known benchmarks.

100 Best Gemini Excel Data Analysis Prompts for Accountants

1. Data cleaning plan: You are an accounting analyst. Task: design a data-cleaning workflow for an Excel workbook containing general ledger extracts. Context: available columns include account_number, date, amount, description, debit_credit, currency, and project_code. Output format: bullet list of steps with validation checks. Constraints: span across two worksheets, maintain original data integrity, document every transformation.
2. Duplicate detector: Role: Excel data analyst for an accounting team. Task: identify duplicate transaction rows in a ledger export. Context: columns include transaction_id, date, amount, vendor, and memo. Output: a labeled report with duplicates, their counts, and suggested de-duplication rule. Constraints: work within the given sheet, no data modification in source cells.
3. Month-end reconciliation: You are a finance controller. Task: reconcile bank statement CSV exports with the Excel cashier journal. Context: fields transaction_date, amount, memo, bank_reference, and GL_account. Output: a reconciliation summary showing matched, unmatched, and discrepancies in a table format. Constraints: use a pivot to summarize by account.
4. Variance analysis helper: Role: accounting analyst. Task: compute first-level budget-to-actual variance by department from an Excel workbook. Context: columns include department, budget, actual, variance, percentage. Output: a comparison table with trend indicators and a chart-ready CSV export. Constraints: handle negative variances clearly.
5. Cash flow extractor: You are a financial analyst. Task: derive net cash flow by month from a dataset with inflows, outflows, and starting balance. Context: columns show month, inflows, outflows, starting_balance. Output: a month-by-month cash flow summary and a line chart data table in CSV format. Constraints: exclude non-cash items.
6. Aging report generator: Role: AR analyst. Task: create an aging report from an invoices table. Context: columns include invoice_id, customer, due_date, amount_due, status. Output: aging buckets, total by bucket, and recommended collections actions in bullet form.
7. Revenue by product: You are a revenue analyst. Task: summarize revenue by product across regions in Excel. Context: fields product_id, region, revenue, date. Output: pivot table fields for product, region, and total revenue, plus a CSV export for BI.
8. Expense category mapper: Role: accountant. Task: map raw expense descriptions to standard categories. Context: columns description, amount, date, supplier. Output: a new category column with consistent codes, plus a summary by category.
9. Tax code validator: Role: tax accountant. Task: validate tax codes against a master list in Excel. Context: columns include tax_code, amount, date. Output: report of invalid codes and corrected suggestions in a second sheet.
10. Payroll sanity check: You are a payroll analyst. Task: verify payroll totals against subledger. Context: payroll_date, employee_id, gross_pay, deductions, net_pay. Output: discrepancy list and causes in a structured table.
11. Depreciation sweep: Role: asset accountant. Task: summarize monthly depreciation by asset class. Context: asset_id, class, depreciation_expense, date, method. Output: pivot-ready table and anomaly flags for outliers.
12. Vendor spend clustering: You are a spend analyst. Task: cluster vendor spend into high/medium/low categories by amount and frequency. Context: vendor_id, spend, transactions, month. Output: categorized table and funnel chart data.
13. Credit limit monitor: Role: credit analyst. Task: flag customers approaching credit limits in Excel. Context: customer_id, credit_limit, current_balance, available_credit. Output: alert list and suggested actions.
14. IFRS/GAAP mapping: You are an accounting policy assistant. Task: map local ledger items to IFRS/GAAP classification. Context: item_code, description, amount, currency. Output: classification codes with notes for auditable items.
15. Intercompany eliminations: Role: consolidation accountant. Task: prepare intercompany eliminations from two ledgers. Context: intercompany_id, entity_from, entity_to, amount, date. Output: elimination journal entries in a prepared format.
16. KPI dashboard exporter: You are a financial controller. Task: assemble KPI metrics from various sheets into a single export. Context: sheets contain Revenue, COGS, Net_Income, EBITDA. Output: a single CSV ready for BI ingestion.
17. A/B comparison prompt: Role: data analyst for accountants. Task: compare two periods' key metrics side by side in Excel. Context: period_1 and period_2 columns for revenue, expenses, and profit. Output: side-by-side table with delta percentages.
18. Sensitivity scenario builder: You are a financial planner. Task: build scenario variations for revenue and cost assumptions. Context: base_case_values in a sheet, change_sets defined in a scenarios sheet. Output: table of results and a scenario summary.
19. Audit trail generator: Role: auditor. Task: create an audit trail of changes to key financial rows. Context: change_log with fields row_id, timestamp, user, action, previous_value, new_value. Output: readable narrative plus a changelog table.
20. Bank reconciliation aid: You are an accountant. Task: reconcile bank statement with ledger entries. Context: bank_csv columns date, description, amount; ledger columns date, account, amount. Output: match list, unmatched items, and a reconciliation summary.
21. Forecast vs actual drilldown: Role: FP&A analyst. Task: drill down forecast accuracy by product and channel. Context: forecast_table, actuals_table with date, product, channel, amount. Output: accuracy metrics and a drilldown table.
22. Journal entry generator: You are an accountant. Task: generate standard journal entries from a dataset of transactions. Context: fields date, account_debit, account_credit, amount, description. Output: trial journal in a clean format with supporting explanation.
23. Month-end closing checklist: Role: senior accountant. Task: produce a closing checklist populated from worksheet data. Context: checklist_items with status and owner. Output: ready-to-publish closing report.
24. Inventory aging report: You are an inventory analyst. Task: create aging of stock by SKU. Context: sku, warehouse, quantity, age_days, cost. Output: aging buckets and reserve recommendations.
25. Cost-to-serve analyzer: Role: cost accountant. Task: compute cost-to-serve by customer segment. Context: segment, service_cost, revenue, date. Output: profitability table and visual summary.
26. Tax provision prep: You are a tax controller. Task: prepare a provisional tax provision from balance sheet and P&L items. Context: tax_rate, taxable_income, adjustments. Output: calculated tax provision and notes.
27. Ledger integrity check: Role: internal auditor. Task: validate ledger consistency across months. Context: multiple sheets with month_end_balances. Output: integrity report with mismatches and suggested fixes.
28. Supplier payment timing: You are an AP analyst. Task: analyze payment timing and cash impact. Context: invoices, due_date, payment_terms, cash_balance. Output: recommendations and cashflow impact table.
29. Expense policy conformity: Role: compliance analyst. Task: check expenses against policy thresholds. Context: expense_rows with amount, category, policy_code. Output: violations list and suggested approvals.
30. Revenue leakage detector: You are a revenue ops analyst. Task: identify potential revenue leakage from order data. Context: orders, cancellations, refunds, dates. Output: leakage list with causes and remediation steps.
31. P&L by department: Role: financial controller. Task: split P&L by department from consolidated workbook. Context: revenue, cogs, opex by department. Output: department P&L table and a summary chart.
32. Depreciation forecast: You are a finance planner. Task: forecast depreciation by asset class for next quarters. Context: asset_id, class, purchase_date, cost, depreciation_method. Output: quarterly depreciation forecast and a notes column.
33. Payment mix analysis: Role: treasury analyst. Task: analyze payment method mix by month. Context: payment_method, amount, date. Output: trend table and forecast if trends hold.
34. Currency exposure scan: You are a treasury analyst. Task: identify currency exposure across ledgers. Context: currency, amount, date, entity. Output: exposure list with hedging suggestions.
35. AR aging heatmap: Role: collections analyst. Task: make an AR aging heatmap from overdue invoices. Context: customer, days_outstanding, amount_due. Output: heatmap-ready data with thresholds.
36. Commitment tracker: You are a project accountant. Task: track commitments vs actuals. Context: project_id, committed_amount, actuals, date. Output: variance table and flags for over/under runs.
37. Fixed asset rollforward: Role: asset manager. Task: produce rollforward of fixed assets. Context: asset_id, date, additions, disposals, depreciation. Output: rollforward table for audit.
38. Vendor risk score: You are a procurement analyst. Task: score vendors by risk using spend, delivery performance, and compliance. Context: vendor_id, spend, on_time, compliance. Output: risk score and categorized list.
39. Credit memo tracker: Role: AP analyst. Task: track credit memos and their impact on balances. Context: memo_id, date, amount, customer. Output: reconciliation notes and aging effect.
40. Project profitability view: You are a project accountant. Task: compute profitability by project. Context: project_id, revenue, direct_costs, overhead. Output: profit margin by project and a summary chart.
41. Audit-ready summary: Role: junior auditor. Task: assemble a compact audit-ready summary from workbook data. Context: key_items with description, value, last_updated. Output: narrative plus a data appendix.
42. Cost center drilldown: You are a controller. Task: drill down expenses by cost center. Context: center_id, category, amount, date. Output: table by center and a variance flag.
43. Order-to-cash flow: Role: finance ops. Task: map order data to cash flow timing. Context: orders, invoices, payments, date. Output: cash flow curve and summary.
44. Intercompany reconciliation: You are a group accountant. Task: reconcile intercompany balances across entities. Context: entity_a, entity_b, amount, date. Output: reconciliation table and confirmations.
45. Budget baseline check: Role: budget analyst. Task: verify proposed budget aligns with historical trends. Context: baseline_budget, historical_spend, variance_limit. Output: conformity report.
46. Tax jurisdiction mapping: You are a tax specialist. Task: map transactions to tax jurisdictions for compliance. Context: transaction_id, amount, jurisdiction_code. Output: jurisdiction map and notes.
47. Pension liability summary: Role: pension accountant. Task: summarize pension liabilities from actuarial data. Context: plan_id, liability, discount_rate. Output: liability table and notes.
48. Sales commission calculator: You are a sales finance analyst. Task: compute commissions by rep and product. Context: rep_id, product, sales, commission_rate. Output: commission sheet and payout forecast.
49. Inventory write-down plan: Role: inventory controller. Task: identify slow-moving stock for write-down. Context: sku, location, quantity, cost, book_value. Output: write-down recommendations and impact.
50. Capital vs expense test: You are a finance manager. Task: classify expenditures as capital vs expensed. Context: item_id, description, cost, expected_life. Output: verdict and rationale.
51. Billing accuracy check: Role: billing analyst. Task: verify invoice totals against line items. Context: invoice_id, item, quantity, unit_price, line_total. Output: mismatch report and correction steps.
52. Forecast variance root cause: You are FP&A. Task: identify root causes for forecast misses. Context: forecast_table, actuals_table, drivers. Output: root-cause list with recommended actions.
53. Overhead absorber: Role: cost accountant. Task: allocate overhead to cost centers based on activity. Context: overhead_codes, rate, activity_units. Output: allocated_overhead table and summary.
54. Receivables aging export: You are an AR analyst. Task: export aging data for collections. Context: customers, days_outstanding, balance. Output: age buckets and recommended actions.
55. Fraud indicators scan: Role: internal auditor. Task: flag suspicious patterns in transaction data. Context: transactions table with amount, date, vendor, employee_id. Output: risk flags and justification.
56. Expense trend mosaic: You are a controller. Task: create a mosaic of expense trends by category and month. Context: category, amount, month. Output: grid-ready trends and insights.
57. Vendor payment aging: Role: AP analyst. Task: analyze payment aging by vendor. Context: vendor_id, due_date, paid_date, amount. Output: aging buckets and action plan.
58. P&L heat map: You are a financial analyst. Task: build a P&L heat map by month and line item. Context: month, line_item, amount. Output: heat map data ready for visualization.
59. ROI by project: Role: investment analyst. Task: compute ROI per project. Context: project_id, investment, net_cash_flows, duration. Output: ROI percent and narrative notes.
60. Cash burn planner: You are a treasury planner. Task: forecast cash burn for the next quarter. Context: starting_balance, outflows, inflows, expenses. Output: burn curve and risk flags.
61. Audit evidence pack: Role: junior auditor. Task: assemble evidence pack from workbook data. Context: key_accounts, values, dates. Output: organized evidence list with sources.
62. SKU profitability map: You are a product controller. Task: map SKU profitability across channels. Context: sku, channel, revenue, cost_of_goods_sold, overhead. Output: profitability table and channel insights.
63. Book-to-bank match: Role: accountant. Task: perform book-to-bank reconciliation by item. Context: bank_items, ledger_items, date. Output: match results and discrepancies.
64. Tax provision detail: You are a tax preparer. Task: detail tax provision components. Context: current_tax, deferred_tax, adjustments. Output: line-item tax provision with notes.
65. Labor cost analysis: Role: finance analyst. Task: analyze labor costs by department. Context: employee_hours, wage_rate, department, date. Output: cost per department table.
66. Capital expenditure forecast: You are a capital planner. Task: forecast capex by project. Context: project_id, planned_capex, date, approvals. Output: forecast table and variance notes.
67. Debt covenant monitor: Role: treasury analyst. Task: monitor debt covenants from financials. Context: debt_metric, covenant_limit, actual. Output: status table and alerts.
68. VAT compliance scan: You are a tax compliance officer. Task: scan transactions for VAT compliance. Context: transaction_id, amount, VAT_rate, jurisdiction. Output: flagged items and corrective steps.
69. Directory of financial controls: Role: internal controls specialist. Task: document key controls from workbook data. Context: control_id, control_name, owner, evidence. Output: control catalog.
70. Bank fee analysis: You are a financial analyst. Task: analyze bank fees by account and month. Context: account, fee_type, amount, date. Output: expense summary and recommendations.
71. Revenue adjustment log: Role: revenue accountant. Task: log and explain revenue adjustments. Context: adjustment_id, date, amount, reason. Output: adjustment register with notes.
72. Inventory turnover rate: You are an inventory planner. Task: compute turnover by SKU. Context: sku, beginning_inventory, purchases, ending_inventory, cost_of_goods_sold. Output: turnover rate table.
73. Sales trend forecast: Role: sales analyst. Task: forecast sales using historical data. Context: date, sales, promotions. Output: forecast table and confidence notes.
74. Intercompany chargeback: You are a group accountant. Task: calculate intercompany charges. Context: entities, base_cost, markups, date. Output: chargeback sheet with supporting rationale.
75. Expense categorization guide: Role: accounting mentor. Task: create a helper to categorize expenses consistently. Context: expense_description, policy_codes. Output: mapping guide and example prompts.
76. Fixed asset aging: You are a fixed asset steward. Task: age assets by depreciation period. Context: asset_id, purchase_date, depreciation_end, value. Output: aging report and flags.
77. Commission impact study: Role: finance analyst. Task: study how commissions affect margins. Context: revenue, commission, cost, date. Output: impact table and recommendations.
78. Budget drift detector: You are a budget controller. Task: detect drift between actuals and budget. Context: actuals, budget, date. Output: drift flags and action suggestions.
79. Interperiod reconciliation: Role: accounting clerk. Task: reconcile balances across periods. Context: period_1 balance, period_2 balance, changes. Output: reconciliation notes.
80. Expense forecast rider: You are a financial planner. Task: add forecasted expenses to budget. Context: forecast_expenses, budget_annual. Output: updated_budget with notes.
81. Area profitability view: Role: controller. Task: compute profitability by geographic area. Context: area_id, revenue, costs. Output: area profitability table.
82. Receivable collection plan: You are a collections manager. Task: create a plan to improve collections. Context: customer_age, balance, days_past_due. Output: action plan with owners.
83. Accrual estimation prompt: Role: accountant. Task: estimate accruals from monthly data. Context: revenue, expenses, adjustments. Output: accrual balances and justification.
84. Payroll variance check: You are a payroll analyst. Task: compare payroll totals to HR records. Context: payroll, headcount, rate, date. Output: variance report and fixes.
85. LIability mapping: Role: liability accountant. Task: map liabilities to their sources. Context: liability_type, amount, date. Output: liability map with notes.
86. Revenue by channel: You are a revenue analyst. Task: summarize revenue by channel. Context: channel, amount, date. Output: channel table and trend chart.
87. Cost reconciliation sheet: Role: cost controller. Task: reconcile cost data from multiple sources. Context: source_A, source_B, amount. Output: reconciled sheet and discrepancy notes.
88. Audit sampling plan: You are an internal auditor. Task: design a sampling plan for testing data. Context: population, risk_score, sampling_method. Output: sample list with justification.
89. Year-end prep checklist: Role: senior accountant. Task: build year-end prep checklist from workbook. Context: tasks, due_date, owner. Output: ready-to-use checklist.
90. Project cost baseline: You are a project controller. Task: establish cost baseline from bids and estimates. Context: project_id, bid_cost, estimate_cost, date. Output: baseline table and variance expectations.
91. Refund impact analysis: Role: finance analyst. Task: analyze refunds impact on revenue and margins. Context: refunds, revenue, cost. Output: impact table and policy notes.
92. Inventory reserve plan: You are an inventory controller. Task: propose reserve levels for obsolescence. Context: sku, age, forecast_dall, cost. Output: reserve recommendations and financial impact.
93. Vendor performance scorecard: Role: procurement finance. Task: score vendors on delivery, quality, and cost. Context: vendor_id, on_time, quality, cost. Output: scorecard and improvement plan.
94. Accounts by aging bucket: You are an AR analyst. Task: assign accounts to aging buckets. Context: account_id, balance, days_past_due. Output: bucketed balances and totals.
95. GDPR data minimization: Role: data controller. Task: identify and minimize sensitive data in sheets. Context: dataset columns, data_type. Output: data-minimization plan and sample redacted sheet.
96. Currency revaluation table: You are a treasury specialist. Task: revalue balances in foreign currencies. Context: currency, amount, rate, date. Output: revaluation table and gain/loss notes.
97. Price variance breakdown: Role: pricing analyst. Task: break down price variances by item and region. Context: item_id, region, standard_price, actual_price, quantity. Output: variance table and actions.
98. Capex post-mortem: You are a finance reviewer. Task: summarize post-implementation capex results. Context: project_id, expected_roi, actual_roi, lessons. Output: lessons learned and financial impact.
99. Consolidation mapping: Role: group accountant. Task: map subsidiary accounts to a parent chart of accounts. Context: child_account, parent_account, amount. Output: consolidated chart with notes.
100. Excel data quality rubric: You are a data quality specialist. Task: assess a workbook for accuracy, completeness, and consistency. Context: data_samples, validation_rules. Output: quality rubric and remediation plan.

Best Practices

• Test prompts on small sample datasets before applying to full ledgers to avoid unintended edits.
• Document every transformation step to preserve data lineage for audits.
• Reuse prompts with consistent field names to build a reliable automation library.
• Limit prompts to one primary objective per run to minimize errors.
• Incorporate data validation rules within prompts to catch anomalies early.

Common Mistakes to Avoid

• Using vague descriptions that require readers to invent missing context.
• Forgetting to specify output format or destination sheet, causing unclear results.
• Overloading prompts with multiple goals, leading to partial or conflicting outputs.
• Neglecting data privacy and sensitive information handling in prompts.
• Assuming capabilities that exceed the current model, like real-time data access without integration.

FAQ

What makes Gemini prompts effective for Excel data analysis in accounting?

They provide precise role-driven tasks, clear contexts, and defined outputs, reducing guesswork and speeding up financial reporting.

Can I adapt prompts for different ERP exports?

Yes. Replace placeholders with your ERP column names and export formats; ensure data types align with the prompt constraints.

Do prompts require external tools besides Gemini?

No. They operate within Excel data management, but you can export outputs to BI tools if needed.

How do I verify prompt results?

Cross-check outputs against known balances, run spot checks on samples, and compare with existing ledgers or reports.

Are these prompts suitable for auditors?

Yes. They generate auditable outputs, document transformations, and produce reconciliations and evidence packs.

How should I handle sensitive financial data?

Use data minimization, limit prompt scope, and apply access controls and masking where appropriate.