100 Best ChatGPT Excel Data Analysis Prompts for Accountants

Direct Answer

The best ChatGPT prompts for Excel data analysis for accountants are a curated set of precise, actionable prompts that guide Excel tasks from trend analysis to reconciliations, all tailored for accounting workflows and audit readiness. Use the prompts with your actual dataset placeholders and customize constraints as needed for accuracy and compliance.

Introduction

This page presents a practical prompt library focused on Excel data analysis for accountants. It helps professionals accelerate financial analysis, reporting, and decision making using structured prompts.

Designed for accountants, financial analysts, auditors, and finance managers, the prompts cover reconciliations, budgeting, variance analysis, forecasting, and performance reporting.

How to Use These ChatGPT Prompts

• Replace placeholders like [dataset], [department], [currency], and [date range] with your actual data before running the prompt.
• Add or adjust constraints to fit your accounting policies, such as rounding rules, currency formats, or materiality thresholds.
• Request the output in clearly labeled sections and formats, for example executive summaries, tables, bullet lists, or CSV-ready exports.
• Verify results by cross-checking computed metrics against source data and, where possible, include validation steps in the prompt to catch errors.
• If needed, chain prompts to perform data cleaning before analysis and then run the analytical prompts on the cleaned dataset.

100 Best ChatGPT Excel Data Analysis Prompts for Accountants

1. Trend analysis of expenses: You are an Excel data analyst for accountants. Analyze the provided [dataset] containing monthly expense lines with columns: Date, Category, Amount, Department, and Vendor. Identify 12-month expense trends by category, calculate CAGR for each category, and highlight any seasonality with a summary report. Output the findings in a structured format: Section 1: Top five expense categories by total spend; Section 2: Monthly trend charts as ASCII tables; Section 3: Key insights and actions for cost control. Include total annual spend and variance versus prior year.
2. Revenue vs. budget variance: Act as an Excel data analyst for accountants. Given [dataset] with columns: Month, RevenueActual, RevenueBudget, Department, and Region, compute variance by department and region, identify drivers of variance, and propose corrective actions. Provide a variance heatmap in text form, and a bullet list of recommended adjustments for next quarter. Ensure calculations are precise to two decimals and show percentage variance where applicable.
3. Cash flow forecast model: You are a financial analyst in Excel for accountants. Build a cash flow forecast model from [dataset] that includes columns: Date, OperatingCash, InvestingCash, FinancingCash, NetCash, and OpeningBalance. Project 6 quarters ahead using a simple growth rate assumption and seasonality by month. Output a clear forecast table and a narrative summary with 3 to 5 action steps for liquidity management.
4. Aging accounts receivable: Role: Excel data analyst for accountants. Use [dataset] containing CustomerID, InvoiceDate, DueDate, Amount, and PaidStatus. Compute aging buckets by days outstanding (0-30, 31-60, 61-90, 91+), show aging distribution by customer segment, and recommend collection actions. Include a pie chart data in text form and a brief recommended follow-up plan.
5. Vendor spend clustering: Prompt as an Excel data analyst for accountants. From [dataset] with Vendor, Category, Amount, and Date, cluster vendors by spend and frequency, then output the top 10 vendors by spend with associated risk flags. Provide a CSV-ready summary and a one-page executive brief of insights and recommended negotiations.
6. Inventory valuation analysis: Act as an Excel data analyst for accountants. Given [dataset] with ItemID, UnitCost, OnHand, AvgSellPrice, and InventoryValue, compute ABC analysis, gross margin per item, and days of inventory on hand. Produce a ranked list of top items to review for obsolescence and a concise audit-ready note.
7. Depreciation schedule check: You are an Excel data analyst for accountants. Validate a fixed asset register in [dataset] with AssetID, AcquisitionDate, UsefulLife, SalvageValue, and DepreciationMethod. Recalculate depreciation using straight-line and accelerated methods, flag mismatches, and propose corrections. Output a reconciliation report and an adjustment table.
8. Tax expense alignment: Prompt as an Excel data analyst for accountants. Using [dataset] containing TaxCode, TaxRate, TaxBase, and TaxExpense, verify alignment between tax expense by jurisdiction and statutory rates. Identify discrepancies, propose corrections, and generate a reconciled tax ledger snapshot.
9. Forecast vs actual by department: Role: Excel data analyst for accountants. For [dataset] with Department, Month, ForecastRevenue, ActualRevenue, and Variance, calculate period-over-period variance, identify departments underperforming, and allocate corrective actions. Output an executive summary and a department-by-department detail table.
10. Cash conversion cycle: You are an Excel data analyst for accountants. With [dataset] containing InventoryDays, APDays, ARDays, and CostOfGoodsSold, compute the cash conversion cycle, compare to prior period, and suggest process improvements. Provide a 1-page performance brief and a KPI dashboard table.
11. Payroll cost split: Act as an Excel data analyst for accountants. From [dataset] with EmployeeID, Salary, Benefits, and Overtime, allocate payroll costs across cost centers, compute total payroll by department, and flag any anomalies. Produce a summary and a detailed table suitable for journal entries.
12. GL reconciliation prompts: You are an Excel data analyst for accountants. Given [dataset] with GLAccount, Date, Debit, Credit, and JournalNarrative, validate balance sheet accounts by month, detect mismatches, and propose journal entries. Output a reconciliation log and a risk flag list.
13. Expense policy compliance: Role: Excel data analyst for accountants. Use [dataset] containing ExpenseAccount, EmployeeID, Amount, Date, and PolicyFlag. Check compliance with company policy, categorize non-compliant items, and generate a remediation plan and audit-ready report.
14. Bank reconciliation prompt: Act as an Excel data analyst for accountants. From [dataset] with BankDate, BankStatementAmount, GLAmount, and ReconciliationStatus, perform a bank reconciliation, identify timing issues, and produce a reconciliation summary with exception details.
15. Scenario-based budgeting: You are an Excel data analyst for accountants. Build a scenario-based budget model from [dataset] including assumptions for revenue, COGS, and opex. Create best/worst/most-likely scenarios, and output an annotated forecast workbook with sensitivity checks.
16. Revenue concentration risk: Role: Excel data analyst for accountants. Analyze [dataset] with CustomerID, Revenue, Region, and Industry to identify concentration risk. Output top 5 customers by revenue, a concentration graph data, and recommendations for diversification.
17. Cost-to-serve analysis: You are an Excel data analyst for accountants. Using [dataset] with CustomerID, ServiceType, Cost, and Revenue, compute cost-to-serve by service and customer, highlight high-cost cases, and propose pricing adjustments.
18. Break-even analysis: Act as an Excel data analyst for accountants. From [dataset] with FixedCosts, VariableCosts, and RevenueScenarios, calculate break-even points under several scenarios and present a decision-ready chart and notes.
19. Capital expenditure planning: Role: Excel data analyst for accountants. Given [dataset] containing CapexItem, Cost, UsefulLife, and ExpectedSavings, compute NPV and IRR for proposed projects, rank projects, and generate a decision memo.
20. Scenario-based tax estimates: You are an Excel data analyst for accountants. Use [dataset] with TaxRates, Deductions, Credits, and Income to simulate tax outcomes under different scenarios. Output a summary, a table of effective tax rate by scenario, and actionable notes.
21. Audit trail creation: Act as an Excel data analyst for accountants. From [dataset] with TransactionID, Date, Amount, Category, and User, generate an auditable trail suitable for an internal audit, including checksums and change-log sections.
22. Vendor risk scoring: Role: Excel data analyst for accountants. Using [dataset] with VendorID, Spend, ComplianceFlag, and IncidentCount, compute a risk score per vendor, flag high-risk vendors, and propose mitigations. Output a risk matrix and a summary report.
23. Intercompany reconciliation: You are an Excel data analyst for accountants. With [dataset] containing Entity, IntercompanyAmount, Elimination, and Date, perform intercompany reconciliation, identify mismatches, and prepare a consolidation-ready journal list.
24. Variance analysis by product: Prompt as an Excel data analyst for accountants. From [dataset] with ProductID, PlanSales, ActualSales, and Margin, compute variance by product, highlight top deviations, and propose product mix adjustments.
25. Debit/credit aging: You are an Excel data analyst for accountants. Using [dataset] with SourceDocument, DebitTotal, CreditTotal, and AgeDays, produce aging analysis for journal entries, identify aging risk, and suggest corrections.
26. Debit trend by account: Act as an Excel data analyst for accountants. Given [dataset] with Account, Date, Debit, Credit, and Balance, analyze debit trends by account over time, and report unusual spikes with possible causes.
27. Recurring payment tracker: Role: Excel data analyst for accountants. From [dataset] containing PaymentID, Vendor, Amount, DueDate, and Status, build a tracker for recurring payments, flag overdue items, and summarize cash impact.
28. Tax liability calendar: You are an Excel data analyst for accountants. Using [dataset] with TaxDate, TaxType, Amount, and Jurisdiction, generate a tax calendar with due dates, reminders, and a summary of outstanding liabilities.
29. Depreciation vs tax: Prompt as an Excel data analyst for accountants. From [dataset] with AssetID, DepreciationMethod, BookDepreciation, and TaxDepreciation, compare methods, flag differences, and propose timing for adjustments.
30. Sales channel profitability: Role: Excel data analyst for accountants. Using [dataset] with Channel, Revenue, COGS, and Margin, compute profitability by channel, identify the most profitable channels, and propose optimizations.
31. Process automation checklist: You are an Excel data analyst for accountants. From [dataset] with TaskID, ProcessName, TimeToComplete, and ErrorRate, rate process efficiency, flag bottlenecks, and outline automation steps with expected impact.
32. Credit risk scoring: Act as an Excel data analyst for accountants. Given [dataset] with CustomerID, CreditLimit, Balance, and PaymentHistory, compute a credit risk score, categorize customers, and propose credit decisions.
33. Expense variance drilldown: You are an Excel data analyst for accountants. From [dataset] with ExpenseLine, AmountActual, AmountBudget, and Category, drill into top variance drivers, suggest corrective actions, and provide a concise executive summary.
34. Payroll variance analysis: Role: Excel data analyst for accountants. Using [dataset] with EmployeeID, SalaryBudget, SalaryActual, and Variance, identify payroll overruns, explain drivers, and recommend reallocation of headcount.
35. Balance sheet stress test: You are an Excel data analyst for accountants. From [dataset] with Assets, Liabilities, and Equity, create scenarios to test balance sheet resilience, show impact on key ratios, and propose remediation plans.
36. Accounts payable aging: Act as an Excel data analyst for accountants. With [dataset] containing Vendor, InvoiceDate, DueDate, Amount, and Status, compute aging and payment status distribution, and develop a payables optimization plan.
37. Revenue by product family: Prompt as an Excel data analyst for accountants. Using [dataset] with ProductFamily, Revenue, UnitCost, and Units sold, analyze revenue by family, compute margins, and recommend product mix changes.
38. EBITDA reconciliation: Role: Excel data analyst for accountants. From [dataset] with NetIncome, Interest, Taxes, Depreciation, and Amortization, compute EBITDA and reconcile to operating cash flow, noting adjustments.
39. Fraud detection prompts: You are an Excel data analyst for accountants. Given [dataset] with Transactions, AnomalyFlag, and Approved, identify unusual patterns, flag potential fraud indicators, and propose investigations.
40. Month-end close checklist: Act as an Excel data analyst for accountants. Build a month-end close checklist from [dataset] with tasks, owners, due dates, and completion status, plus a risk flag for delays.
41. Tax provision prompts: You are an Excel data analyst for accountants. From [dataset] containing TaxProvision, DeferredTax, and IncomeTaxExpense, prepare a tax provision roll forward and reconcile to statutory tax expense.
42. Cash reconciliations prompt: Role: Excel data analyst for accountants. Using [dataset] with CashAccount, BankBalance, and ReconciledBalance, perform cash reconciliations, identify timing differences, and generate a reconciliation note.
43. Inventory aging analysis: You are an Excel data analyst for accountants. From [dataset] with ItemID, AgeDays, OnHand, and Turns, calculate inventory aging buckets, turns per item, and propose slow-moving items for decommission.
44. Cost per unit math: Act as an Excel data analyst for accountants. Given [dataset] with ItemID, Cost, Overhead, and Volume, compute cost per unit with allocated overhead, and compare to sale price to identify margin gaps.
45. Audit-ready journal entries: Role: Excel data analyst for accountants. From [dataset] with JournalID, Account, Amount, and Narrative, generate a set of audit-ready journal entries with supporting explanations.
46. Profit margin trends: You are an Excel data analyst for accountants. Using [dataset] with Period, Revenue, CostOfGoodsSold, and OperatingExpenses, compute gross and net margins over time, and annotate drivers.
47. Capital budgeting heatmap: Prompt as an Excel data analyst for accountants. From [dataset] with Project, NPV, IRR, and Payback, create a heatmap of investment attractiveness and a concise prioritization memo.
48. Consolidation data prep: You are an Excel data analyst for accountants. Using [dataset] with Entity, Intercompany, and Elimination, prepare a consolidation-ready dataset with clear mapping and a reconciliation note.
49. Debt covenant tracking: Act as an Excel data analyst for accountants. From [dataset] with CovenantID, Threshold, CurrentRatio, and ComplianceFlag, monitor debt covenants and flag potential breaches with recommended actions.
50. Cost-to-serve by client: Role: Excel data analyst for accountants. Using [dataset] with ClientID, ServiceLine, Cost, Revenue, compute cost-to-serve by client, rank clients by profitability, and suggest pricing adjustments.
51. Forecast accuracy metrics: You are an Excel data analyst for accountants. From [dataset] with Forecast, Actual, and Variance, compute accuracy metrics (MAD, MAPE, RMSE), rank forecast quality, and propose improvements.
52. Vendor discount optimization: Act as an Excel data analyst for accountants. Using [dataset] with VendorID, InvoiceDate, Amount, and Discount, calculate total discounts captured and missed, and propose negotiation targets.
53. Tax reconciliation prompts: Role: Excel data analyst for accountants. From [dataset] with Tax codes, Jurisdiction, and TaxAmount, reconcile tax lines to statutory filings and list discrepancies.
54. Sales tax nexus mapping: You are an Excel data analyst for accountants. Using [dataset] with Jurisdiction, TaxRate, and Sales, map nexus locations, calculate tax obligations, and highlight high-risk regions.
55. Scenario planning workbook: Prompt as an Excel data analyst for accountants. Build a scenario planning workbook from [dataset] including variables for revenue, cost, and volume; produce multiple scenario outputs and sensitivity checks.
56. Expense amortization: You are an Excel data analyst for accountants. From [dataset] with AssetID, AmortizationPeriod, and AmortizationMethod, compute amortization schedule and align with expense recognition.
57. Receivables collection plan: Act as an Excel data analyst for accountants. Using [dataset] with Customer, Balance, daysOutstanding, and LastPaymentDate, generate a targeted collection plan by customer tier.
58. Profit by region: Role: Excel data analyst for accountants. From [dataset] with Region, Revenue, COGS, and Margin, compute regional profitability and create a recommendation brief.
59. Cost variance by project: You are an Excel data analyst for accountants. Using [dataset] with ProjectID, BudgetCost, ActualCost, and Variance, identify largest cost variances by project and suggest corrective actions.
60. Receipts matching prompts: Act as an Excel data analyst for accountants. From [dataset] with ReceiptID, InvoiceID, Amount, and Date, verify receipts against invoices, flag mismatches, and produce a match report.
61. Payroll tax changes: You are an Excel data analyst for accountants. Using [dataset] with TaxRate, Salary, and Department, assess impact of tax changes on payroll and propose adjustments.
62. Depreciation schedule audit: Role: Excel data analyst for accountants. From [dataset] with AssetID, BookDep, TaxDep, and UsefulLife, perform a depreciation audit and create an adjustment log.
63. Audit sampling prompts: You are an Excel data analyst for accountants. Using [dataset] with TransactionID, Amount, Date, and Category, generate statistically valid audit samples and summarize findings.
64. Budget vs actual drilldown: Act as an Excel data analyst for accountants. From [dataset] with Area, Budget, Actual, and Variance, drill into root causes of variance by area and present actionable insights.
65. Fraud risk indicators: Role: Excel data analyst for accountants. Using [dataset] with Transactions, AnalystFlag, and Jurisdiction, identify common fraud indicators and suggest investigation steps.
66. Intercompany payoff schedule: You are an Excel data analyst for accountants. From [dataset] with IntercompanyID, Amount, Date, and Status, plan payoff schedules and reconciliation impacts for group entities.
67. Tax credits pipeline: Prompt as an Excel data analyst for accountants. Using [dataset] with CreditType, Amount, and Year, forecast tax credit realizations and prepare a tracking sheet.
68. Inventory reorder points: You are an Excel data analyst for accountants. From [dataset] with ItemID, OnHand, LeadTime, and SafetyStock, calculate reorder points and generate a replenishment plan.
69. Expense hot-hand analysis: Act as an Excel data analyst for accountants. Using [dataset] with Category, Month, and Amount, identify months with unusually high expense bursts and attribute causes.
70. Credit limit utilization: Role: Excel data analyst for accountants. From [dataset] with CustomerID, CreditLimit, CurrentBalance, and CreditUsed, assess utilization, flag risk, and propose credit line adjustments.
71. Audit evidence pack: You are an Excel data analyst for accountants. Using [dataset] with SupportingDocs, JournalEntries, and Approvals, assemble a compact audit evidence pack with summaries.
72. Liquidity stress test: Act as an Excel data analyst for accountants. From [dataset] with CashFlow, DebtMaturity, and Revenue, perform a liquidity stress test under adverse conditions and present a mitigation plan.
73. Sales pipeline forecast: Role: Excel data analyst for accountants. Using [dataset] with Opportunity, Stage, Value, and CloseDate, forecast quarterly sales and map pipeline to revenue projections.
74. Compliance indicators: You are an Excel data analyst for accountants. From [dataset] with Regulation, Requirement, and Status, track compliance indicators and generate a red-amber-green dashboard summary.
75. Productivity metrics: Prompt as an Excel data analyst for accountants. Using [dataset] with EmployeeID, TaskCompleted, TimeToComplete, and QualityFlag, compute productivity metrics and recommend staffing changes.
76. Tax basis reconciliation: You are an Excel data analyst for accountants. From [dataset] with TaxBasis, TaxRate, and TaxAmount, reconcile tax basis calculations to filings and flag discrepancies.
77. Expense trend seasonality: Act as an Excel data analyst for accountants. From [dataset] with Month, Category, and Amount, analyze seasonality patterns and provide a quarterly trend narrative.
78. Cost center profitability: Role: Excel data analyst for accountants. Using [dataset] with CostCenter, Revenue, and Expenses, compute profitability by cost center and propose reallocations.
79. Forecast variance explanation: You are an Excel data analyst for accountants. From [dataset] with Forecast, Actual, and KeyDrivers, produce a narrative explaining variance and list data gaps.
80. Tax liability by jurisdiction: Act as an Excel data analyst for accountants. Using [dataset] with Jurisdiction, TaxRate, and TaxBase, compute jurisdictional tax liabilities and prepare a summary report.
81. Journal entry integrity: You are an Excel data analyst for accountants. From [dataset] with EntryID, Account, Debit, Credit, and ValidationFlag, ensure journal entry integrity and flag inconsistent entries.
82. Client profitability by project: Role: Excel data analyst for accountants. Using [dataset] with ClientID, ProjectID, Revenue, and Cost, calculate project profitability and highlight high-value projects.
83. Capital efficiency metrics: You are an Excel data analyst for accountants. From [dataset] with AssetID, ROI, and Utilization, compute capital efficiency indicators and present a management summary.
84. Ledger aging report: Act as an Excel data analyst for accountants. From [dataset] with Ledger, Date, Amount, and Status, generate a ledger aging report and flag stale entries.
85. Linked data clean-up: Role: Excel data analyst for accountants. Using [dataset] with DuplicatesFlag, Source, and CleanedFlag, deduplicate records across ledgers and produce a clean data sheet.
86. Cash healing plan: You are an Excel data analyst for accountants. From [dataset] with CashBalance, Receivables, and Payables, propose a cash healing plan to improve liquidity and reduce risk.
87. Sales commission model: Act as an Excel data analyst for accountants. Using [dataset] with SalesPerson, Revenue, and CommissionRate, build a commission model and ensure payout accuracy.
88. Costing by activity: Role: Excel data analyst for accountants. From [dataset] with ActivityID, ActivityCost, and ActivityRevenue, calculate activity-based costing and map to products.
89. Balance sheet ratios: You are an Excel data analyst for accountants. Using [dataset] with Assets, Liabilities, and Equity, compute key ratios (current ratio, debt-to-equity) and provide interpretation.
90. Journal reversal prompts: You are an Excel data analyst for accountants. From [dataset] with ReversalDate, OriginalEntry, and Reason, produce journal reversal prompts and a reversal log.
91. Customer churn analysis: Act as an Excel data analyst for accountants. From [dataset] with CustomerID, LastPurchaseDate, and ChurnFlag, analyze churn risk and propose retention actions.
92. Overhead absorption: Role: Excel data analyst for accountants. Using [dataset] with OverheadRates, ActivityVolumes, and CostPool, allocate overhead to cost centers and verify absorption accuracy.
93. Accounts receivable forecast: You are an Excel data analyst for accountants. From [dataset] with CustomerID, HistoricalDaysToPay, and InvoiceAmount, forecast receivables receipts and propose collection actions.
94. Pricing optimization prompts: Act as an Excel data analyst for accountants. Using [dataset] with Price, Demand, and Elasticity, simulate pricing scenarios and identify optimal price points.
95. Audit committee briefing: Role: Excel data analyst for accountants. From [dataset] with KeyMetrics, prepare a concise briefing for the audit committee highlighting financial control improvements.
96. Weekly financial snapshot: You are an Excel data analyst for accountants. From [dataset] with Week, Revenue, Expenses, and NetIncome, generate a weekly snapshot with trend arrows and a one-page summary.
97. Bank fee analysis: Act as an Excel data analyst for accountants. Using [dataset] with Bank, FeeType, and Amount, categorize fees, identify unnecessary charges, and propose savings.
98. Currency exposure prompt: You are an Excel data analyst for accountants. From [dataset] with Currency, Amount, and FXRate, compute net exposure by currency and suggest hedging actions.
99. Inventory shrinkage prompt: Role: Excel data analyst for accountants. Using [dataset] with ItemID, PhysicalCount, SystemCount, and Variance, calculate shrinkage, investigate causes, and recommend controls.
100. Consolidated dashboard prompts: You are an Excel data analyst for accountants. From [dataset] containing multiple entities, build a consolidated dashboard with key metrics, pivot views, and drill-down paths for executives.

Best Practices

• Keep prompts focused on a single analytical objective to reduce ambiguity.
• Use precise data placeholders and clear output formats to improve reproducibility.
• Test prompts on a small sample dataset before scaling to full datasets.
• Incorporate audit-friendly outputs, such as reconciliation notes and supporting summaries.
• Store and version-control prompt outputs to track analysis history.

Common Mistakes to Avoid

• Assuming a single dataset fits all prompts; always tailor placeholders to your data schema.
• Omitting data cleaning steps, which can lead to misleading results.
• Using vague constraints or outputs that are hard to parse for auditing.
• Ignoring data governance and privacy considerations when handling financial data.
• Not validating outputs against source records or last period benchmarks.

FAQ

What is the best way to start using these prompts for Excel data analysis?

Begin by selecting prompts that match your current task, replace placeholders with your data, and run in a test workbook before applying to production data.

How do I ensure results are audit-ready?

Include explicit reconciliation notes, date stamps, source data references, and a clear explanation of calculations in your outputs.

Can I adapt prompts for different accounting standards?

Yes. Adjust assumptions, tax and depreciation methods, and reporting formats to align with the relevant standards and regulatory requirements.

What outputs should I export for management reporting?

Executive summary, key metrics by area, tabular data exports (CSV/Excel), and a concise narrative with action items.

How can I improve prompt reliability across datasets?

Use consistent column names, enforce data validation steps in prompts, and test prompts on multiple datasets to ensure stability.

Are these prompts suitable for real-time analysis?

They’re designed for monthly or quarterly analyses with standard Excel data; real-time requires linked data sources and automation.