100 Best ChatGPT Excel Data Analysis Prompts for Banks

Direct Answer

The best ChatGPT prompts for Excel data analysis for banks are designed to help analysts clean, analyze, and report Excel banking data with precise outputs. They guide tasks like reconciliation, risk, customer analytics, and forecasting, delivering structured results you can reproduce. Use them to standardize workflows and improve accuracy across teams.

Introduction

This page provides a focused prompt library for Excel data analysis in banking. It is intended for bank analysts, risk officers, treasury staff, and operations teams who rely on Excel for quantitative insights.

The prompts are crafted to be copyable and actionable, so you can paste them into ChatGPT and immediately start producing reliable analyses and reports.

How to Use These ChatGPT Prompts

• Replace placeholders like [industry], [audience], and [constraints] to fit your bank’s context.
• Add constraints to enforce data governance, accuracy, and privacy requirements.
• Request outputs in specific formats such as tables or bullet lists to match your reporting templates.
• Verify outputs by cross-checking with source data and, when possible, running a quick sanity check on a summary row.
• Save prompts as reusable templates and adapt them for different datasets or regulatory regimes.

100 Best ChatGPT Excel Data Analysis Prompts for Banks

1. Data cleaning standardization: You are a data cleanup assistant for banking datasets. Task: standardize dates, currency formats, and missing value handling across multiple Excel sheets. Context: data from monthly transaction extracts with date fields in various formats and currencies. Output: a cleaned, normalized table with columns: AccountID, Date, Amount, Currency, Description, Category. Constraints: keep original row order, flag records with unresolved dates, provide a audit trail column named AuditNote.
2. Transaction reconciliation checker: Act as a bank reconciliation analyst. Input: two Excel sheets, General Ledger and Bank Statement. Task: identify mismatches, include tolerance of five units, and categorize discrepancies. Output: a reconciliation table with columns: Date, Description, GL_Amount, Bank_Amount, Difference, Status, Notes. Constraints: return a summary row with totals and reconciliation rate.
3. Fraud pattern detector: Role: fraud analytics assistant. Task: scan a bank transactions dataset to flag potential fraud patterns such as unusual large deposits, rapid transfers, or round-number amounts. Output: a flagged dataset with columns: ID, Date, Amount, Origin, Destination, FlagReason, ConfidenceScore. Constraints: ConfidenceScore on a scale of one to five, explain rationale in Notes.
4. Customer churn predictor: You are a customer analytics modeler. Task: build a simple churn risk score using a banking customer dataset. Context: features include account tenure, transactions in last 90 days, product counts, and last interaction. Output: a table with CustomerID, TenureMonths, LastTransactionDays, ProductCount, ChurnRiskScore (0-100), Recommendations. Constraints: provide a brief method note and validation steps.
5. Deposit growth analysis: Role: financial analyst. Task: compare monthly deposit growth across branches for the last year. Input: sheet with BranchID, Month, Deposits, Withdrawals, NetFlow. Output: PivotTable-ready summary: BranchID, Month, Deposits, Withdrawals, NetFlow, GrowthRate(Month over Month). Constraints: exclude branches with missing data; provide a growth trend line description.
6. Loan portfolio heatmap: You are a portfolio analyst. Task: generate a risk heatmap of loan balances by risk rating and product type. Input: LoanID, Balance, RiskRating, ProductType, Branch. Output: a matrix: ProductType x RiskRating with totalBalance. Constraints: describe top risk cells and provide mitigation notes.
7. Interest income forecast: Role: forecasting analyst. Task: forecast quarterly interest income from loans using past quarterly balances. Output: Table with Quarter, ForecastInterestIncome, ConfidenceInterval, Assumptions. Constraints: use simple growth model, specify confidence bounds.
8. Chargeback analysis: Act as chargeback analyst. Task: summarize chargebacks by reason code for the last six months. Output: Table with ReasonCode, Count, TotalAmount, Branch distribution. Constraints: flag top three reasons and provide action items.
9. ATM coverage dashboard: Role: operations analyst. Task: analyze ATM withdrawal volume to optimize coverage. Input: Sheet with ATMID, City, DailyVolume, ActiveHours. Output: Summary by City with TotalVolume, AvgDailyVolume, RecommendedNewATMs. Constraints: include feasibility notes.
10. KYC data quality check: You are a compliance data steward. Task: assess KYC data quality across customers. Output: DataQualityScore per field (Name, DOB, Address, IDType). Provide remediation plan and sample validation checks. Constraints: report any PII risk findings.
11. Regulatory dashboard briefs: Role: regulatory reporting aide. Task: produce concise summaries for monthly regulatory dashboards from Excel data. Output: one-page brief per regulator with KeyMetrics, DataSources, and Assumptions. Constraints: keep under two paragraphs per regulator.
12. Interest rate sensitivity: Act as risk analyst. Task: calculate sensitivity of loan portfolio to a 50 basis point rate change. Input: Balance, Rate, ProductType, Tenor. Output: Table: ProductType, BaseRate, NewRate, DeltaInterest, SensitivityPercent, RecommendedAction. Constraints: provide a one-sentence decision note.
13. Product profitability: You are a profitability analyst. Task: compute product-level profitability using revenue and direct costs per product. Input: ProductType, Revenue, DirectCosts, Branch. Output: ProfitMargin, ContributionMargin, and BreakEvenUnits. Constraints: show top and bottom products with notes.
14. Delinquency trends: Role: credit risk analyst. Task: summarize delinquency counts by cohort and grade over the last eight quarters. Output: Table: Cohort, Grade, Quarter, DelinquencyCount, DelinquencyRate. Constraints: identify rising trends and include recommended mitigations.
15. Fraud case summaries: You are a fraud investigator. Task: generate concise summaries for flagged cases from Excel data. Output: CaseID, Date, Suspect, Amount, FlagReason, NextSteps. Constraints: ensure secure handling and anonymize sensitive details.
16. Liquidity gap watcher: Role: liquidity manager. Task: compute monthly liquidity gap as cash + liquid assets minus liabilities. Output: Month, LiquidityGap, GapRatio, AlertLevel. Constraints: trigger alert when GapRatio exceeds threshold.
17. Operational cost drift: You are a cost analyst. Task: compare monthly operating costs to budget. Output: Table with Month, ActualCost, BudgetedCost, Variance, VariancePct. Constraints: identify months with material variances.
18. Customer segmentation: Role: marketing analyst. Task: segment customers by product holding and activity level. Output: Segments with Count, AvgBalance, Growth; include top segment recommendations. Constraints: ensure privacy-compliant aggregation.
19. Credit utilization analysis: Act as credit risk analyst. Task: analyze utilization of credit lines by customer segment. Output: Segment, AvgUtilization, MedianUtilization, DefaultRisk. Constraints: flag segments with high utilization and risk.
20. Branch performance comparator: Role: performance analyst. Task: compare branches on key metrics: Deposits, Loans, FeeIncome, NPL. Output: Ranked list with Delta vs GlobalMean and Recommendations. Constraints: account for branch size.
21. Cost-to-income insight: You are a financial planner. Task: compute cost-to-income ratio by department. Output: Dept, Revenue, Cost, CtiRatio, Trend, ActionItems. Constraints: presentDeviation from average.
22. Daily cash position: Role: treasury analyst. Task: report end-of-day cash position by currency. Input: Currency, CashAvailable, ClearingReceivables, ClearingPayables. Output: Currency, NetPosition, Status, NextStep. Constraints: highlight liquidity risk.
23. Expense categorization: You are an expense analyst. Task: classify expenses into predefined categories using description text. Output: RowID, Description, Category, Amount, Subcategory. Constraints: maintain original order.
24. Customer value heatmap: Role: CRM data analyst. Task: map customer value by tenure and product mix. Output: HeatmapTable with ValueScore by Tenure and Product. Constraints: explain top value drivers.
25. Reconciliation drumbeat: You are a reconciliation specialist. Task: generate a monthly drumbeat report showing reconciliation status by team. Output: Team, OpenItems, Resolved, AgingDays, NextFollowUp. Constraints: include SLA status.
26. Suspicious patterns alert: Role: anti-fraud analyst. Task: detect suspicious transfer patterns like rapid round trips. Output: AlertID, Pattern, Score, SuggestedAction. Constraints: provide mitigation steps.
27. Loan aging analysis: You are a credit portfolio analyst. Task: analyze loan aging by term bucket. Output: Bucket, AverageBalance, DelinquencyRate, Exposure. Constraints: identify aging risk.
28. Refunds reconciliation: Role: operations analyst. Task: reconcile refunds against merchant receipts. Output: Merchant, RefundCount, RefundAmount, NetRefund. Constraints: flag mismatches.
29. Alerts automation: You are an operations engineer. Task: design a simple Excel-based alert system for thresholds (e.g., high balances, low liquidity). Output: Threshold, Condition, Action, Recipient. Constraints: provide sample rules.
30. Market risk snapshot: Role: risk manager. Task: create a market risk snapshot using Excel data. Output: Scenario, Probability, Impact, Mitigation, Owner. Constraints: keep to four scenarios.
31. Customer onboarding funnel: You are a marketing analytics specialist. Task: analyze onboarding funnel metrics from Excel data. Output: Stage, Count, ConversionRate, DropOff, Recommendations. Constraints: segment by channel.
32. SLA compliance tracker: Role: operations analyst. Task: track service level agreement compliance across processes. Output: Process, TargetTime, ActualTime, ComplianceRate, ActionPlan. Constraints: alert for miss.
33. Product cross-sell scoring: You are a product optimization analyst. Task: score customers for cross-sell potential based on balances and activity. Output: CustomerID, CrossSellScore, RecommendedProduct, Rationale. Constraints: limit to top 10 recommendations.
34. Regulatory data dictionary: Role: data steward. Task: create a dictionary mapping fields to definitions for regulatory reporting. Output: FieldName, Definition, DataType, Source. Constraints: include example values.
35. Cash flow forecast: You are a treasury forecaster. Task: generate a cash flow forecast for next 12 weeks using historical weekly cash balances. Output: Week, NetCashFlow, CumulativeBalance, Assumptions. Constraints: include confidence band.
36. AML watchlist screening: Role: compliance analyst. Task: screen customers against watchlists using Excel. Output: CustomerID, MatchScore, WatchlistName, Action. Constraints: ensure privacy.
37. Debt collection prioritization: You are a collections manager. Task: prioritize accounts for outreach by risk and balance. Output: AccountID, RiskScore, Balance, Priority, NextAction. Constraints: provide contact strategy.
38. Product profitability by region: Role: finance manager. Task: compute product profitability by region. Output: Region, Product, Revenue, DirectCost, Profit, Margin. Constraints: reveal top region.
39. Tax data prep sheet: You are a tax preparer. Task: assemble tax-relevant figures from banking data into a compact sheet. Output: TaxLine, Amount, Category, SupportingDocs. Constraints: maintain audit trail.
40. Cost center benchmarking: Role: finance analyst. Task: benchmark cost centers against peers. Output: CostCenter, Budget, Actual, Variance, BenchmarkRank. Constraints: provide three actionable insights.
41. Chargeback risk filter: You are an risk analyst. Task: flag accounts with high chargeback risk based on past six months. Output: AccountID, RiskScore, LastChargeDate, PotentialCause. Constraints: suggest mitigations.
42. Data quality scorecard: Role: data steward. Task: assign quality scores to fields across datasets. Output: Field, DataQualityScore, IssuesFound, remediationStatus. Constraints: provide sample checks.
43. Expense leakage scan: You are a cost auditor. Task: identify unnecessary recurring expenses. Output: Vendor, Expense, Frequency, PotentialSavings, ActionPlan. Constraints: estimate savings.
44. Counterparty risk matrix: Role: risk analyst. Task: create a counterparty risk matrix by exposure and rating. Output: Counterparty, Exposure, Rating, RiskScore, Mitigation. Constraints: keep matrix readable.
45. Fraud case trend: You are an investigator. Task: summarize fraud cases by month and method. Output: Month, Method, Count, TotalAmount. Constraints: highlight emerging methods.
46. Operational resilience check: Role: risk officer. Task: map critical processes and recovery times. Output: Process, RTO, RPO, Criticality, Owner. Constraints: include dependencies.
47. Accounts aging report: You are a accounts payable analyst. Task: generate aging report by vendor. Output: Vendor, Current, 30Days, 60Days, 90Plus, Total. Constraints: flag overdue vendors.
48. Fee income mix: Role: product manager. Task: analyze fee income by product line. Output: ProductLine, FeeIncome, Share, Trend, Recommendations. Constraints: include price sensitivity note.
49. Budget variance drill: You are a budget analyst. Task: drill into notable variances by department. Output: Department, Budget, Actual, Variance, RootCause, Action.
50. Liquidity guardrails: Role: treasury officer. Task: define liquidity guardrails and monitor. Output: GuardrailName, TriggerValue, Action, Owner. Constraints: provide escalation path.
51. Treasury cash contest: You are a treasury ops lead. Task: propose a daily cash contest to optimize cash usage. Output: ContestName, Rules, Metrics, Reward. Constraints: ensure compliance.
52. Branch risk heatmap: Role: risk analyst. Task: visualize branch risk by score and region. Output: Region x Score heatmap data, TopRisks. Constraints: provide mitigation notes.
53. Credit line exposure: You are a credit risk officer. Task: compute exposure by credit line and utilization. Output: LineID, Exposure, Utilization, Status, Action. Constraints: alert if utilization > 90%.
54. Customer lifecycle map: Role: customer success analyst. Task: map customer lifecycle from onboarding to renewal. Output: Stage, Metrics, DropOff, NextBestAction. Constraints: tie to product usage.
55. Product feature uptake: You are a product analytics lead. Task: analyze feature adoption by segment. Output: Feature, Segment, AdoptionRate, Impact, NextSteps. Constraints: control for seasonality.
56. Cost efficiency audit: Role: internal auditor. Task: identify wasteful spend across departments. Output: Department, Finding, EstimatedSavings, Priority. Constraints: provide remediation steps.
57. AR aging overview: You are an receivables analyst. Task: create aging overview by customer segment. Output: Segment, Current, 30Days, 60Days, 90Plus, Total, ActionNeeded. Constraints: flag high-risk accounts.
58. Treasury funding plan: Role: treasury planner. Task: draft a short-term funding plan. Output: Scenario, FundingNeeded, Source, Cost. Constraints: include risk notes.
59. Regulatory data lineage: You are a data governance lead. Task: document data lineage for regulatory reporting. Output: SourceSystem, FieldMapped, Transformations, Destination, DataOwner. Constraints: include sample lineage diagram notes.
60. Operational KPI tracker: Role: operations manager. Task: track core KPIs in a single sheet. Output: KPI, Target, Actual, Variance, Status. Constraints: auto-highlight late values.
61. Cost center forecast: You are a financial planner. Task: forecast costs by center for next quarter. Output: Center, ForecastedCost, Confidence, Variance. Constraints: provide rationale.
62. Tax compliance prep: Role: tax analyst. Task: prepare data for tax filing by category. Output: Category, Amount, SupportingDocs, DueDate. Constraints: ensure completeness.
63. Data smoothing: You are a data engineer. Task: apply smoothing to noisy time series in banking data. Output: SmoothedSeries, Method, Parameters, Validation. Constraints: document impact on signals.
64. Seasonality adjustment: Role: economist. Task: adjust revenue series for seasonality. Output: AdjustedValue, SeasonalIndex, Rationale. Constraints: report residuals.
65. Account health score: You are a relationship manager. Task: compute health score for accounts based on activity, balance, and aging. Output: AccountID, HealthScore, RiskFlag, Recommendations. Constraints: include action plan.
66. P&L by product: Role: finance analyst. Task: generate P&L by product and region. Output: Product, Region, Revenue, CostOfGoods, GrossProfit. Constraints: show top lines.
67. Unreconciled items drill: You are a reconciliation specialist. Task: drill into unreconciled items by team and reason. Output: ItemID, Team, Reason, Amount, AgeDays, NextAction. Constraints: escalate as needed.
68. Customer risk scoring: Role: risk analyst. Task: assign risk score to customers based on activity and payments. Output: CustomerID, RiskScore, Alerts, Actions. Constraints: flag high-risk accounts.
69. Regulatory checklists: You are a compliance officer. Task: generate checklists for regulatory readiness. Output: Regulation, RequiredDocs, Responsible, Status. Constraints: update quarterly.
70. Data enrichment prompts: Role: data engineer. Task: enrich existing datasets with external data sources. Output: Source, FieldAdded, DataQualityImpact, Usage. Constraints: cite data source.
71. Portfolio diversification: You are a portfolio analyst. Task: analyze diversification across products and regions. Output: Segment, Exposure, ConcentrationRisk, SuggestedDiversification. Constraints: quantify risk reduction.
72. Cost allocation map: Role: financial controller. Task: allocate shared costs to departments. Output: Department, AllocationRate, AllocatedCost, Rationale. Constraints: ensure round numbers.
73. Customer feedback sentiment: You are a voice of the customer analyst. Task: analyze feedback sentiment by product. Output: Product, SentimentScore, TopKeywords, ActionableInsights. Constraints: avoid biased interpretation.
74. Vendor risk review: Role: procurement analyst. Task: assess vendor risk using spend and performance. Output: Vendor, Spend, PerformanceScore, Risk, Mitigation. Constraints: provide contract notes.
75. Returns trend analysis: You are a returns analyst. Task: analyze product returns by region and channel. Output: Region, Channel, ReturnRate, Impact, Mitigation. Constraints: suggest process changes.
76. Billing accuracy check: Role: accounts receivable. Task: verify invoice accuracy against orders. Output: InvoiceID, OrderID, AmountBilled, AmountExpected, Discrepancy, Action. Constraints: supply support notes.
77. Capital structure view: You are a corporate finance analyst. Task: summarize debt and equity mix. Output: Instrument, Amount, CostOfCapital, Maturity, Rating. Constraints: provide overall leverage insight.
78. Scenario planning prompts: Role: strategy analyst. Task: create banking scenario prompts for Excel forecasting. Output: Scenario, Assumptions, KeyMetrics, Triggers. Constraints: keep to four scenarios.
79. Credit committee pack: You are a governance assistant. Task: assemble a concise committee pack from data. Output: Section, KeyFigures, SupportingData, DecisionsNeeded. Constraints: keep under page limit.
80. Product return analysis: Role: product manager. Task: analyze returns by product line and reason. Output: ProductLine, ReturnRate, CommonReasons, Action. Constraints: link to improvement plan.
81. Interest schedule generator: You are a loan operations analyst. Task: generate amortization schedules for selected loans. Output: LoanID, PaymentNumber, Principal, Interest, Balance, DueDate. Constraints: apply fixed rate.
82. Settlement timing analysis: Role: operations planner. Task: analyze settlement times by partner. Output: Partner, AvgSettlementTime, Variance, Bottlenecks. Constraints: propose optimization.
83. Product mix trend: You are a product strategist. Task: track product mix over time. Output: TimePeriod, ProductShare, NetNewSales, Notes. Constraints: highlight shifts.
84. Invoices aging watch: Role: AP analyst. Task: monitor invoice aging by vendor. Output: Vendor, Current, 15Day, 30Day, 60Day, 90Plus, ActionsNeeded. Constraints: flag overdue.
85. Transfer fee analysis: You are a pricing analyst. Task: analyze transfer fees by route and channel. Output: Route, Channel, Fee, Volume, ProfitImpact. Constraints: recommend pricing tweaks.
86. Portfolio yield map: Role: investment analyst. Task: map yield by asset class and duration. Output: AssetClass, DurationBracket, Yield, Risk. Constraints: include caveats.
87. Credit loss projection: You are a credit risk modeler. Task: project expected credit losses under baseline scenario. Output: Stage, ECL, Assumptions, Confidence. Constraints: provide sensitivity notes.
88. Workflow automation prompt: Role: automation engineer. Task: design an Excel-based workflow for monthly close. Output: Step, Owner, Deadline, Inputs, Outputs. Constraints: include checks.
89. Data privacy checklist: You are a compliance data steward. Task: generate privacy checks for banking data. Output: CheckItem, Responsible, Evidence, Status. Constraints: avoid PII exposure.
90. Expense approval routing: Role: finance administrator. Task: route expenses for approval by policy. Output: ExpenseID, Amount, PolicyRule, Approver, Status. Constraints: include escalation path.
91. Recurring revenue forecast: You are a revenue analyst. Task: forecast recurring revenue by product line. Output: ProductLine, Next12WeeksForecast, Confidence, KeyAssumptions. Constraints: show confidence range.
92. Chargeback analysis by merchant: Role: dispute analyst. Task: summarize chargebacks by merchant for the last quarter. Output: Merchant, Chargebacks, Amount, WinRate, Action. Constraints: provide remediation steps.
93. Currency exposure tracker: You are a treasury analyst. Task: track FX exposure by currency pair and region. Output: CurrencyPair, Exposure, HedgingStatus, Action. Constraints: flag uncovered risk.
94. Customer loyalty scoring: Role: customer success analyst. Task: compute loyalty score from activity, tenure, and spend. Output: CustomerID, LoyaltyScore, Tier, RetentionPlan. Constraints: include next best offer.
95. Data anomaly alerts: You are a data quality engineer. Task: configure anomaly alerts for Excel datasets. Output: Metric, Threshold, AlertMethod, Recipients. Constraints: test with sample data.
96. Vendor payment timing: Role: AP manager. Task: analyze payment timing against terms. Output: Vendor, TermsDays, AvgPayDays, Variance, Action. Constraints: recommend terms.
97. Debt covenants monitor: You are a risk officer. Task: monitor covenants using Excel data. Output: CovenantName, Status, TriggerDate, ActionNeeded. Constraints: escalate on breach.
98. Audit trail generator: Role: compliance auditor. Task: create an audit trail forExcel actions. Output: Action, User, Timestamp, ChangeDetails. Constraints: ensure immutability.
99. Scenario variance checker: You are a scenario planner. Task: compare outcomes under multiple scenarios. Output: Scenario, OutcomeMetric, Value, Variance, Note. Constraints: summarize in bullets.
100. Excel data storytelling: Role: data storyteller. Task: craft a data story from banking metrics for leadership. Output: Narrative, KeyFigures, VisualAids, NextSteps. Constraints: keep concise and actionable.

Best Practices

• Keep prompts specific to banking data domains to avoid generic results.
• Include exact column names and data types to ensure consistent outputs.
• Use output formats that align with your existing Excel templates to reduce manual reformatting.
• Validate results with a quick data sanity check and, if needed, expose the underlying logic in Notes.
• Clone and customize prompts for different product lines, regions, and regulatory contexts.

Common Mistakes to Avoid

• Using vague prompts that invite broad interpretations rather than concrete outputs.
• Overlooking data privacy and compliance constraints when handling customer data.
• Failing to specify output formats or required columns, causing misaligned results.
• Neglecting to include validation steps or audit trails for reproducibility.
• Assuming perfect data without addressing gaps or errors in the source files.

FAQ

What makes these prompts effective for banking Excel data analysis?

They are explicit, role-based, and field-focused, producing structured outputs that fit Excel workflows and regulatory needs.

Do I need to modify prompts for different banks?

Yes, replace placeholders with your bank’s data fields, products, and regions, and adjust constraints to fit governance rules.

How should I verify the results from ChatGPT prompts?

Cross-check outputs with source sheets, run quick reconciliation checks, and validate key metrics with colleagues.

Can these prompts handle large banking datasets?

They work well for typical Excel datasets; for very large datasets consider chunking data or using pivot-driven summaries.

Are there risks with automating banking analysis in Excel?

Be mindful of data security, version control, and auditability; always keep a changelog and restrict access to sensitive data.

How do I adapt prompts for regulatory reporting?

Add field mappings, data source notes, and assumptions to align with the exact regulatory requirements.