Gemini PromptsGemini prompts catalog100 Prompts

100 Best Gemini Excel Data Analysis Prompts for Bookkeepers

100 Best Gemini Excel Data Analysis Prompts for Bookkeepers: a practical prompt library to streamline Excel data tasks with Google Gemini prompts, Gemini AI prompts, and tailored steps for bookkeeping workflows.

Gemini promptsGoogle Gemini promptsGemini AI promptsExcel data analysisbookkeeping promptsfinancial datadata cleansingpivot analysisreconciliation promptsformatting promptsauditing promptsreporting promptsaccounting automationworkflow promptsprompt libraryfinance promptsbooks promptsdata validation prompts

Best For

Bookkeepers and accounting professionals who use Excel for data analysis

Prompt Use Cases

  • Daily data cleaning in Excel
  • Reconciliation data checks
  • Pivot table and chart analysis
  • Financial data extraction and summarization
  • Audit trail generation
  • Budget variance analysis
  • Accounts receivable/payable data review
  • Error detection and correction in datasets
  • Data validation rule creation
  • Custom reporting templates for Excel

Direct Answer

The best Gemini prompts for Excel data analysis for bookkeepers are tailored, action-oriented prompts that empower bookkeepers to clean, reconcile, analyze, and report financial data in Excel using Gemini prompts. They specify roles, tasks, contexts, outputs, and constraints so you can deploy them directly without creating new instructions. Note that effectiveness depends on accurate placeholders and clear formats.

Introduction

This page is a practical prompt library focused on Excel data analysis for bookkeepers. It provides a curated set of Gemini prompts you can copy-paste into your workflow to speed up routine financial tasks.

Designed for bookkeepers, accountants, and finance professionals who regularly work with Excel data, dashboards, and reconciliations, these prompts help standardize processes and improve accuracy.

How to Use These Gemini Prompts

  • Replace placeholders like [industry], [audience], [product], [constraints], [data], [tone], and [format] with your actual values.
  • Add constraints to tailor outputs, such as word limits, date ranges, or formatting requirements.
  • Request outputs in specific formats like CSV, Excel, or structured tables to simplify downstream use.
  • Verify outputs by spot-checking sample rows and cross-checking totals or reconciliations.
  • Use the prompts as templates and adapt them for different datasets or reporting cycles.

100 Best Gemini Excel Data Analysis Prompts for Bookkeepers

  1. Data clean and flag duplicates: Role: Bookkeeper Analyst. Task: Clean and normalize a dataset of invoices in Excel and identify duplicates. Context: The dataset contains columns InvoiceID, CustomerName, Amount, Date, and Status. Output: A clean data table with duplicates flagged in a new column DuplicateFlag, plus a summary of duplicates by InvoiceID. Constraints: Do not modify original data; provide a separate cleaned sheet.
  2. Cash receipt reconciliation: Role: Reconciliation Specialist. Task: Reconcile cash receipts to bank statements in Excel. Context: Use columns Date, ReceiptID, Customer, Amount, BankCleared, and Notes. Output: A reconciliation table showing matched receipts, unmatched items, and a reconciliation status per item. Format: CSV-friendly, with clear column headers.
  3. Month-end variance analysis: Role: Financial Analyst. Task: Analyze Month-end variances between actuals and budget using Excel. Context: Include ActualAmount, BudgetAmount, Variance, VariancePct, and Department. Output: A dashboard-ready summary with top variances and drill-down by department. Constraints: Use at most three visualization types.
  4. Aging report automation: Role: A/R Specialist. Task: Generate an aging report from an Accounts Receivable table in Excel. Context: Columns: Customer, InvoiceDate, DueDate, Amount, Status. Output: An aging table with buckets (0-30, 31-60, 61-90, >90) and total outstanding by bucket. Constraints: Include conditional formatting cues.
  5. Currency conversion consistency: Role: Controller Assistant. Task: Normalize currency amounts across multiple currencies in Excel. Context: Columns: Amount, Currency, ExchangeRate, Date. Output: A single USD column with converted amounts, plus a report flag for unusual exchange-rate values. Constraints: Use latest rate from a provided range.
  6. Trendline revenue forecast: Role: Analyst. Task: Create a simple revenue forecast from historical data in Excel. Context: Date, Revenue, ProductLine. Output: Forecasted quarterly revenue for the next four quarters with a confidence band. Constraints: Use a linear or exponential smoothing model and explain choice.
  7. Top customers by revenue: Role: BI Analyst. Task: Identify top customers by revenue from a transactional dataset in Excel. Context: Fields: CustomerName, InvoiceAmount, InvoiceDate. Output: List of top 10 customers with total revenue and share of total.
  8. Cost center profitability: Role: Finance Analyst. Task: Assess profitability by cost center in Excel. Context: CostCenter, Revenue, CostOfGoodsSold, OperatingExpense. Output: Profit by center with margins and an executive summary.
  9. Vendor spend analysis: Role: Purchasing Analyst. Task: Analyze vendor spend from a procurement dataset in Excel. Context: VendorName, PurchaseDate, Amount, Category. Output: Category-wise spend, top vendors, and spend trend visuals.
  10. Data validation checklist: Role: Data Steward. Task: Create a data validation checklist for a workbook. Context: List of critical fields: AccountCode, Date, Amount, Description. Output: A validation plan with rules, sample errors, and remediation steps.
  11. Invoice aging heatmap: Role: Accountant. Task: Build a heatmap of invoice aging in Excel. Context: Aging buckets and total outstanding. Output: Heatmap visualization and interpretation notes. Constraints: Use conditional color scale.
  12. Treasury forecast vs actual: Role: Treasury Analyst. Task: Compare forecast cash flow to actual receipts in Excel. Context: Columns: Date, ForecastCash, ActualCash. Output: Gap analysis with percent variance and recommended actions.
  13. Debt service coverage: Role: Financial Planner. Task: Assess debt service capacity from cash flow data in Excel. Context: CashFlow, DebtService, CoverageRatio. Output: Coverage ratio by period and a summary of risks.
  14. Payroll data sanity check: Role: Payroll Specialist. Task: Validate payroll dataset for errors in Excel. Context: EmployeeID, PayDate, GrossPay, Taxes, NetPay. Output: Debrief of inconsistencies and suggested corrections.
  15. Vendor payment aging: Role: AP Clerk. Task: Analyze vendor payments by aging in Excel. Context: PayDate, Net30, Net60, Net90 amounts. Output: Aging bucket totals and recommended early-pay opportunities.
  16. Balance sheet reconciliation: Role: Accountant. Task: Reconcile balance sheet accounts in Excel. Context: Asset, Liability, ReconciliationDate, Amount. Output: Reconciled items with status and pull-through to adjustments.
  17. VAT/GST reconciliation: Role: Tax Specialist. Task: Reconcile VAT/GST by period in Excel. Context: TaxCode, TaxRate, TaxAmount, Date. Output: Reconciliation summary and flagged anomalies.
  18. Inventory value check: Role: Inventory Analyst. Task: Validate inventory valuation in Excel. Context: SKU, QuantityOnHand, UnitCost, Value. Output: Reconciliation against ledger; highlight discrepancies.
  19. Sales mix by product: Role: Sales Analyst. Task: Analyze sales mix by product in Excel. Context: ProductLine, UnitsSold, Revenue. Output: Percentage mix by product and a top-contributing list.
  20. Balance sheet trend: Role: Financial Analyst. Task: Plot balance sheet line items over time in Excel. Context: Date, Assets, Liabilities, Equity. Output: Time-series charts with trend notes.
  21. Expense categorization: Role: Controller. Task: Reclassify mixed expense lines into categories in Excel. Context: Description, Amount, Category. Output: Cleaned expense table and category variance.
  22. Bank reconciliation checks: Role: Reconciliation Clerk. Task: Verify bank recon lines in Excel. Context: BankDate, StatementAmount, ClearedAmount. Output: Discrepancy report and remediation steps.
  23. Project profitability: Role: Project Accountant. Task: Compute profitability by project in Excel. Context: ProjectID, Revenue, Costs, Hours. Output: Profit and margin by project with a summary.
  24. Sales vs refunds: Role: Revenue Analyst. Task: Compare sales to refunds in Excel. Context: Date, NetSales, Refunds. Output: Net trend with variance and notes.
  25. Forecast accuracy scoring: Role: FP&A Analyst. Task: Score forecast accuracy in Excel. Context: Forecast, Actuals, Date. Output: Accuracy score by period and remediation plan.
  26. A/P aging insights: Role: AP Analyst. Task: Analyze accounts payable aging in Excel. Context: Vendor, DueDate, Amount, Status. Output: Aging buckets, late-payment risk, and cash optimization tips.
  27. Customer cohort analysis: Role: Marketing Analyst. Task: Analyze customer cohorts from invoices in Excel. Context: CohortMonth, Revenue, Retention. Output: Cohort table and retention curve.
  28. Tax base calculation: Role: Tax Clerk. Task: Calculate tax bases from revenue data in Excel. Context: TaxCode, TaxRate, TaxableAmount. Output: Taxable base by code and total taxes.
  29. Intercompany reconciliation: Role: Controller. Task: Reconcile intercompany balances in Excel. Context: IntercompanyID, Amount, Date. Output: Reconciliation status and variance by entity.
  30. Allowance and write-off review: Role: Accountant. Task: Review allowances in Excel. Context: ProductLine, AllowanceAmount, WriteOff. Output: Adjusted P&L impact and summary.
  31. Payroll variance analysis: Role: Payroll Accountant. Task: Compare expected vs actual payroll expenses in Excel. Context: Employee, ExpectedPay, ActualPay, Variance. Output: Variance analysis and root cause notes.
  32. Expense policy conformity: Role: Compliance Auditor. Task: Check expense lines against policy in Excel. Context: PolicyRule, Amount, Category. Output: Violations list and remediation steps.
  33. Recurring journal prep: Role: Accountant. Task: Prepare recurring journal entries from transactional data in Excel. Context: Date, Account, Debit, Credit. Output: Journal batch ready for posting with summaries.
  34. Fraud detection checks: Role: Auditor. Task: Detect anomalies in accounting data in Excel. Context: TransactionID, Amount, Date, Vendor. Output: Anomaly flags and recommended investigations.
  35. Date normalization: Role: Data steward. Task: Normalize date formats in Excel workbook. Context: DateColumn, SourceFormat, TargetFormat. Output: Clean date column and a log of changes.
  36. Description standardization: Role: Data Steward. Task: Standardize transaction descriptions in Excel. Context: Description, StandardForm. Output: Standardized description column and rule summary.
  37. Conditional formatting guide: Role: Excel Ops. Task: Create a formatting guide for dashboards. Context: Key metrics, Thresholds. Output: A rules list and examples of visual cues.
  38. Data extraction blueprint: Role: BI Engineer. Task: Define a blueprint to extract key metrics from Excel data. Context: SourceSheet, MetricsList. Output: Extraction steps, formulas, and sample outputs.
  39. Audit trail generator: Role: Auditor. Task: Generate an audit trail from transactions in Excel. Context: TransactionID, ChangeDate, User. Output: Audit log with change summaries and timestamps.
  40. Revenue recognition rule: Role: Accountant. Task: Apply revenue recognition rules to a dataset in Excel. Context: Revenue, Date, RecognitionPolicy. Output: Recognized revenue by period and note on estimations.
  41. Discount impact analysis: Role: Pricing Analyst. Task: Analyze discount effects on revenue in Excel. Context: ListPrice, DiscountRate, Quantity, Revenue. Output: Net revenue impact and recommendations.
  42. Billing cycle optimization: Role: Controller. Task: Analyze billing cycles for efficiency in Excel. Context: Customer, BillingDate, Amount, Terms. Output: Recommended cycle changes with impact estimates.
  43. Tax compliance checks: Role: Tax Manager. Task: Validate tax calculations in Excel. Context: TaxCode, TaxRate, TaxAmount, Date. Output: Compliance flags and audit notes.
  44. Supplier risk scoring: Role: Procurement Analyst. Task: Score supplier risk from transaction data in Excel. Context: SupplierID, LateDeliveries, QualityScore, Amount. Output: Risk score and mitigation plan.
  45. Invoice mismatch finder: Role: AP Clerk. Task: Detect invoice mismatches in Excel. Context: PO, Receipt, InvoiceAmount. Output: Mismatch report with suggested corrections.
  46. Client profitability by project: Role: Project Accountant. Task: Compute client profitability per project in Excel. Context: ClientID, Revenue, Costs, Hours. Output: Profit by client and project summary.
  47. Forecast vs actual by category: Role: FP&A Analyst. Task: Compare forecast vs actual by category in Excel. Context: Category, Forecast, Actual, Date. Output: Variance report and action plan.
  48. Inventory spoilage alert: Role: Inventory Analyst. Task: Identify spoilage risk in Excel. Context: SKU, Location, OnHand, SpoilageRate. Output: Spoilage alerts and recommended actions.
  49. Accounts receivable pulse: Role: AR Analyst. Task: Create a weekly AR health check in Excel. Context: Customer, DaysOutstanding, NetAR. Output: Health score and aging hot spots.
  50. Cash flow scenario matrix: Role: Treasurer. Task: Build scenario matrix for cash flow in Excel. Context: Scenario, Inflow, Outflow, Timing. Output: Scenario comparison with recommended actions.
  51. Transaction categorization map: Role: Data Architect. Task: Create a category map for transactions in Excel. Context: RawCategory, TargetCategory. Output: Mapping table and usage notes.
  52. Payment term analysis: Role: Financial Analyst. Task: Analyze payment terms impact on cash cycle in Excel. Context: Terms, InvoiceDate, DueDate, Amount. Output: Cash cycle insights and optimization suggestions.
  53. Bad debt estimation: Role: Credit Analyst. Task: Estimate bad debt reserve from aging data in Excel. Context: AgingBucket, Amount, ProbabilityOfDefault. Output: Reserve estimate and notes.
  54. Vendor performance dashboard: Role: Procurement Manager. Task: Build vendor performance metrics in Excel. Context: Vendor, DeliveryOnTime, QualityScore, Spend. Output: Dashboard with SLA highlights.
  55. Working capital drilldown: Role: CFO. Task: Drill down working capital components in Excel. Context: Receivables, Payables, Inventory. Output: Net working capital drivers and trend chart.
  56. COGS vs revenue analysis: Role: Accountant. Task: Compare COGS to revenue by product in Excel. Context: Product, COGS, Revenue. Output: Gross margin by product with notes.
  57. Capital expenditure forecast: Role: Finance Planner. Task: Forecast capex from project data in Excel. Context: ProjectID, PlannedCapex, ActualCapex. Output: Capex forecast with variance notes.
  58. Payroll tax reconciliation: Role: Tax Accountant. Task: Reconcile payroll tax with payroll data in Excel. Context: Employee, TaxWithheld, TaxRate. Output: Reconciliation summary and anomalies.
  59. Interest expense tracking: Role: Finance Analyst. Task: Track interest expenses in Excel. Context: Debt, InterestRate, PaymentDate, Amount. Output: Interest expense ledger and trend.
  60. Depreciation ledger: Role: Accountant. Task: Build a depreciation ledger in Excel. Context: AssetID, PurchaseDate, Cost, Salvage, UsefulLife. Output: Depreciation schedule and book value.
  61. Credit limit utilization: Role: Credit Analyst. Task: Monitor credit limit utilization in Excel. Context: Customer, CreditLimit, CurrentBalance, UsagePct. Output: Alerts and recommendations.
  62. Payroll compliance check: Role: Compliance Auditor. Task: Verify payroll compliance in Excel. Context: Jurisdiction, Employee, PayDate, GrossPay. Output: Compliance status and remediation steps.
  63. Revenue concentration risk: Role: Risk Manager. Task: Assess revenue concentration by customer in Excel. Context: Customer, Revenue. Output: Concentration risk score and mitigation ideas.
  64. Prototype profitability test: Role: Product Controller. Task: Run profitability test on a new product in Excel. Context: Product, Revenue, Cost, LaunchDate. Output: Profitability result and break-even point.
  65. Tax received tracking: Role: Tax Administrator. Task: Track tax payments and receipts in Excel. Context: TaxPeriod, Received, Due. Output: Payment status and aging.
  66. Customer lifetime value: Role: Marketing Analyst. Task: Compute CLV from invoices in Excel. Context: Customer, Revenue, Costs, Retention. Output: CLV by customer and takeaway notes.
  67. Economic scenario analysis: Role: FP&A Lead. Task: Model macro scenarios in Excel. Context: ScenarioName, GDP, Unemployment, Inflation. Output: Scenario impacts on cash and profits.
  68. Currency risk dashboard: Role: Treasury Analyst. Task: Build a currency risk dashboard in Excel. Context: CurrencyPair, Exposure, Rate. Output: Risk indicators and mitigation actions.
  69. Audit sampling plan: Role: Auditor. Task: Define a sampling plan for tests in Excel. Context: Population, Confidence, Margin. Output: Sampling method, sample size, and justification.
  70. Data lineage map: Role: Data Manager. Task: Create data lineage for workbook inputs in Excel. Context: Source, Transform, Destination. Output: Visual data lineage and glossary.
  71. Error trend detection: Role: Data Quality Analyst. Task: Detect error trends in Excel data. Context: Field, ErrorFlag, Date. Output: Trending errors and remediation plan.
  72. Month-end closing checklist: Role: Bookkeeper. Task: Produce a month-end closing checklist in Excel. Context: Tasks, DueDate, Status. Output: Completed checklist with notes for each step.
  73. Intercompany balance test: Role: Controller. Task: Test intercompany balances in Excel. Context: Intercompany, Amount, Date. Output: Reconciliation results and adjustments.
  74. Revenue leakage audit: Role: Auditor. Task: Identify revenue leakage in Excel. Context: SourceData, Revenue, Discounts. Output: Leak detection report and corrective actions.
  75. Refunds trend analysis: Role: Revenue Controller. Task: Analyze refunds by period in Excel. Context: Period, RefundAmount, NetSales. Output: Refund trend with root-cause notes.
  76. Rounding error check: Role: Data Quality Lead. Task: Find rounding discrepancies in Excel datasets. Context: Amount, DecimalPlaces. Output: Rounding error report and fix list.
  77. Seasonality adjustment: Role: FP&A Analyst. Task: Adjust seasonal effects in revenue data in Excel. Context: Month, Revenue, SeasonalityIndex. Output: Adjusted revenue series and notes.
  78. Customer churn flags: Role: Customer Success Analyst. Task: Flag potential churn signals in invoicing data in Excel. Context: Customer, LastPurchase, Frequency. Output: Churn risk list and recommended actions.
  79. Expense forecasting model: Role: Controller. Task: Build a basic expense forecast model in Excel. Context: Category, HistoricalExpense, GrowthRate. Output: Forecast by category and summary.
  80. Vendor merit ranking: Role: Procurement Lead. Task: Rank vendors by merit using spend and delivery metrics in Excel. Context: Vendor, Spend, OnTimeDelivery, Quality. Output: Ranked list and rationale.
  81. Spot check data integrity: Role: Auditor. Task: Perform spot checks on a workbook in Excel. Context: KeyFields, RecordsChecked. Output: Integrity score and issues.
  82. Date range summary: Role: Data Analyst. Task: Summarize data within a date range in Excel. Context: StartDate, EndDate, Data. Output: Summary metrics and a compact chart.
  83. Client billing reconciliation: Role: Billing Specialist. Task: Reconcile client invoices with billing records in Excel. Context: ClientID, InvoiceID, Amount. Output: Reconciled list and dispute notes.
  84. Null value remediation: Role: Data Steward. Task: Identify and remediate null values in critical fields in Excel. Context: FieldList, DataSet. Output: Null report and remediation steps.
  85. Chart-ready dashboard: Role: BI Developer. Task: Build a chart-ready Excel dashboard for finance metrics. Context: Metrics, Timeframe. Output: Dashboard with slicers and export options.
  86. Tax payable forecast: Role: Tax Planner. Task: Forecast tax payable from revenue data in Excel. Context: TaxCode, Revenue, Rate. Output: Tax payable forecast by period.
  87. Audit log summary: Role: Auditor. Task: Summarize an Excel workbook audit log. Context: ChangeDate, User, Action. Output: Summary of changes and risk insights.
  88. Credit risk scoring: Role: Risk Analyst. Task: Score customer credit risk from payment history in Excel. Context: Customer, PastDues, AmountOwed. Output: Risk score and action plan.
  89. Tax code harmonization: Role: Tax Specialist. Task: Harmonize tax codes across datasets in Excel. Context: SourceCode, TargetCode. Output: Mapping and notes.
  90. Payroll headcount analysis: Role: HR Finance Analyst. Task: Link payroll costs to headcount metrics in Excel. Context: Employee, Dept, Cost, Hours. Output: Cost per employee and department insights.
  91. Receivables aging trend: Role: AR Manager. Task: Track aging trend over time in Excel. Context: Date, AgingBucket, Amount. Output: Trend line and interpretation notes.
  92. Pricing model validation: Role: Pricing Analyst. Task: Validate pricing assumptions in Excel. Context: Product, ListPrice, Cost, Margin. Output: Validation report and issues.
  93. Journal entry rehearsal: Role: Accountant. Task: Rehearse journal entries from data in Excel. Context: Date, Account, Debit, Credit. Output: Pre-posting journal pack and notes.
  94. Receipts vs invoices match: Role: AP Clerk. Task: Match receipts to invoices in Excel. Context: ReceiptID, InvoiceID, Amount. Output: Match table and exceptions.
  95. Discount leakage report: Role: Finance Analyst. Task: Identify discount leakage in Excel. Context: Price, Discount, Quantity, Revenue. Output: Leakage amount and fix plan.
  96. GL reconciliation trace: Role: Accountant. Task: Trace general ledger entries in Excel. Context: GLAccount, EntryDate, Amount. Output: Traceability report and anomalies.
  97. Audit readiness checklist: Role: Compliance Officer. Task: Create an audit readiness checklist in Excel. Context: Area, RequiredDocs, Status. Output: Readiness score and next steps.
  98. Data anomaly detective: Role: Data Scientist. Task: Detect anomalies in financial dataset in Excel. Context: DataColumns, Threshold. Output: Anomaly list with confidence levels.
  99. Workbook consolidation plan: Role: Data Engineer. Task: Consolidate multiple sheets into a single workbook in Excel. Context: SourceSheets, TargetSheet. Output: Consolidated data and validation run.
  100. Excel export for reporting: Role: Reporting Specialist. Task: Prepare a clean export-ready dataset for external reports. Context: DataColumns, FormatRequirements. Output: CSV/Excel export ready with metadata notes.

Markdown Template

100 Best Gemini Excel Data Analysis Prompts for Bookkeepers

# 100 Best Gemini Excel Data Analysis Prompts for Bookkeepers

**Data clean and flag duplicates**: Role: Bookkeeper Analyst. Task: Clean and normalize a dataset of invoices in Excel and identify duplicates. Context: The dataset contains columns InvoiceID, CustomerName, Amount, Date, and Status. Output: A clean data table with duplicates flagged in a new column DuplicateFlag, plus a summary of duplicates by InvoiceID. Constraints: Do not modify original data; provide a separate cleaned sheet.
**Cash receipt reconciliation**: Role: Reconciliation Specialist. Task: Reconcile cash receipts to bank statements in Excel. Context: Use columns Date, ReceiptID, Customer, Amount, BankCleared, and Notes. Output: A reconciliation table showing matched receipts, unmatched items, and a reconciliation status per item. Format: CSV-friendly, with clear column headers.
**Month-end variance analysis**: Role: Financial Analyst. Task: Analyze Month-end variances between actuals and budget using Excel. Context: Include ActualAmount, BudgetAmount, Variance, VariancePct, and Department. Output: A dashboard-ready summary with top variances and drill-down by department. Constraints: Use at most three visualization types.
**Aging report automation**: Role: A/R Specialist. Task: Generate an aging report from an Accounts Receivable table in Excel. Context: Columns: Customer, InvoiceDate, DueDate, Amount, Status. Output: An aging table with buckets (0-30, 31-60, 61-90, >90) and total outstanding by bucket. Constraints: Include conditional formatting cues.
**Currency conversion consistency**: Role: Controller Assistant. Task: Normalize currency amounts across multiple currencies in Excel. Context: Columns: Amount, Currency, ExchangeRate, Date. Output: A single USD column with converted amounts, plus a report flag for unusual exchange-rate values. Constraints: Use latest rate from a provided range.
**Trendline revenue forecast**: Role: Analyst. Task: Create a simple revenue forecast from historical data in Excel. Context: Date, Revenue, ProductLine. Output: Forecasted quarterly revenue for the next four quarters with a confidence band. Constraints: Use a linear or exponential smoothing model and explain choice.
**Top customers by revenue**: Role: BI Analyst. Task: Identify top customers by revenue from a transactional dataset in Excel. Context: Fields: CustomerName, InvoiceAmount, InvoiceDate. Output: List of top 10 customers with total revenue and share of total.
**Cost center profitability**: Role: Finance Analyst. Task: Assess profitability by cost center in Excel. Context: CostCenter, Revenue, CostOfGoodsSold, OperatingExpense. Output: Profit by center with margins and an executive summary.
**Vendor spend analysis**: Role: Purchasing Analyst. Task: Analyze vendor spend from a procurement dataset in Excel. Context: VendorName, PurchaseDate, Amount, Category. Output: Category-wise spend, top vendors, and spend trend visuals.
**Data validation checklist**: Role: Data Steward. Task: Create a data validation checklist for a workbook. Context: List of critical fields: AccountCode, Date, Amount, Description. Output: A validation plan with rules, sample errors, and remediation steps.
**Invoice aging heatmap**: Role: Accountant. Task: Build a heatmap of invoice aging in Excel. Context: Aging buckets and total outstanding. Output: Heatmap visualization and interpretation notes. Constraints: Use conditional color scale.
**Treasury forecast vs actual**: Role: Treasury Analyst. Task: Compare forecast cash flow to actual receipts in Excel. Context: Columns: Date, ForecastCash, ActualCash. Output: Gap analysis with percent variance and recommended actions.
**Debt service coverage**: Role: Financial Planner. Task: Assess debt service capacity from cash flow data in Excel. Context: CashFlow, DebtService, CoverageRatio. Output: Coverage ratio by period and a summary of risks.
**Payroll data sanity check**: Role: Payroll Specialist. Task: Validate payroll dataset for errors in Excel. Context: EmployeeID, PayDate, GrossPay, Taxes, NetPay. Output: Debrief of inconsistencies and suggested corrections.
**Vendor payment aging**: Role: AP Clerk. Task: Analyze vendor payments by aging in Excel. Context: PayDate, Net30, Net60, Net90 amounts. Output: Aging bucket totals and recommended early-pay opportunities.
**Balance sheet reconciliation**: Role: Accountant. Task: Reconcile balance sheet accounts in Excel. Context: Asset, Liability, ReconciliationDate, Amount. Output: Reconciled items with status and pull-through to adjustments.
**VAT/GST reconciliation**: Role: Tax Specialist. Task: Reconcile VAT/GST by period in Excel. Context: TaxCode, TaxRate, TaxAmount, Date. Output: Reconciliation summary and flagged anomalies.
**Inventory value check**: Role: Inventory Analyst. Task: Validate inventory valuation in Excel. Context: SKU, QuantityOnHand, UnitCost, Value. Output: Reconciliation against ledger; highlight discrepancies.
**Sales mix by product**: Role: Sales Analyst. Task: Analyze sales mix by product in Excel. Context: ProductLine, UnitsSold, Revenue. Output: Percentage mix by product and a top-contributing list.
**Balance sheet trend**: Role: Financial Analyst. Task: Plot balance sheet line items over time in Excel. Context: Date, Assets, Liabilities, Equity. Output: Time-series charts with trend notes.
**Expense categorization**: Role: Controller. Task: Reclassify mixed expense lines into categories in Excel. Context: Description, Amount, Category. Output: Cleaned expense table and category variance.
**Bank reconciliation checks**: Role: Reconciliation Clerk. Task: Verify bank recon lines in Excel. Context: BankDate, StatementAmount, ClearedAmount. Output: Discrepancy report and remediation steps.
**Project profitability**: Role: Project Accountant. Task: Compute profitability by project in Excel. Context: ProjectID, Revenue, Costs, Hours. Output: Profit and margin by project with a summary.
**Sales vs refunds**: Role: Revenue Analyst. Task: Compare sales to refunds in Excel. Context: Date, NetSales, Refunds. Output: Net trend with variance and notes.
**Forecast accuracy scoring**: Role: FP&A Analyst. Task: Score forecast accuracy in Excel. Context: Forecast, Actuals, Date. Output: Accuracy score by period and remediation plan.
**A/P aging insights**: Role: AP Analyst. Task: Analyze accounts payable aging in Excel. Context: Vendor, DueDate, Amount, Status. Output: Aging buckets, late-payment risk, and cash optimization tips.
**Customer cohort analysis**: Role: Marketing Analyst. Task: Analyze customer cohorts from invoices in Excel. Context: CohortMonth, Revenue, Retention. Output: Cohort table and retention curve.
**Tax base calculation**: Role: Tax Clerk. Task: Calculate tax bases from revenue data in Excel. Context: TaxCode, TaxRate, TaxableAmount. Output: Taxable base by code and total taxes.
**Intercompany reconciliation**: Role: Controller. Task: Reconcile intercompany balances in Excel. Context: IntercompanyID, Amount, Date. Output: Reconciliation status and variance by entity.
**Allowance and write-off review**: Role: Accountant. Task: Review allowances in Excel. Context: ProductLine, AllowanceAmount, WriteOff. Output: Adjusted P&L impact and summary.
**Payroll variance analysis**: Role: Payroll Accountant. Task: Compare expected vs actual payroll expenses in Excel. Context: Employee, ExpectedPay, ActualPay, Variance. Output: Variance analysis and root cause notes.
**Expense policy conformity**: Role: Compliance Auditor. Task: Check expense lines against policy in Excel. Context: PolicyRule, Amount, Category. Output: Violations list and remediation steps.
**Recurring journal prep**: Role: Accountant. Task: Prepare recurring journal entries from transactional data in Excel. Context: Date, Account, Debit, Credit. Output: Journal batch ready for posting with summaries.
**Fraud detection checks**: Role: Auditor. Task: Detect anomalies in accounting data in Excel. Context: TransactionID, Amount, Date, Vendor. Output: Anomaly flags and recommended investigations.
**Date normalization**: Role: Data steward. Task: Normalize date formats in Excel workbook. Context: DateColumn, SourceFormat, TargetFormat. Output: Clean date column and a log of changes.
**Description standardization**: Role: Data Steward. Task: Standardize transaction descriptions in Excel. Context: Description, StandardForm. Output: Standardized description column and rule summary.
**Conditional formatting guide**: Role: Excel Ops. Task: Create a formatting guide for dashboards. Context: Key metrics, Thresholds. Output: A rules list and examples of visual cues.
**Data extraction blueprint**: Role: BI Engineer. Task: Define a blueprint to extract key metrics from Excel data. Context: SourceSheet, MetricsList. Output: Extraction steps, formulas, and sample outputs.
**Audit trail generator**: Role: Auditor. Task: Generate an audit trail from transactions in Excel. Context: TransactionID, ChangeDate, User. Output: Audit log with change summaries and timestamps.
**Revenue recognition rule**: Role: Accountant. Task: Apply revenue recognition rules to a dataset in Excel. Context: Revenue, Date, RecognitionPolicy. Output: Recognized revenue by period and note on estimations.
**Discount impact analysis**: Role: Pricing Analyst. Task: Analyze discount effects on revenue in Excel. Context: ListPrice, DiscountRate, Quantity, Revenue. Output: Net revenue impact and recommendations.
**Billing cycle optimization**: Role: Controller. Task: Analyze billing cycles for efficiency in Excel. Context: Customer, BillingDate, Amount, Terms. Output: Recommended cycle changes with impact estimates.
**Tax compliance checks**: Role: Tax Manager. Task: Validate tax calculations in Excel. Context: TaxCode, TaxRate, TaxAmount, Date. Output: Compliance flags and audit notes.
**Supplier risk scoring**: Role: Procurement Analyst. Task: Score supplier risk from transaction data in Excel. Context: SupplierID, LateDeliveries, QualityScore, Amount. Output: Risk score and mitigation plan.
**Invoice mismatch finder**: Role: AP Clerk. Task: Detect invoice mismatches in Excel. Context: PO, Receipt, InvoiceAmount. Output: Mismatch report with suggested corrections.
**Client profitability by project**: Role: Project Accountant. Task: Compute client profitability per project in Excel. Context: ClientID, Revenue, Costs, Hours. Output: Profit by client and project summary.
**Forecast vs actual by category**: Role: FP&A Analyst. Task: Compare forecast vs actual by category in Excel. Context: Category, Forecast, Actual, Date. Output: Variance report and action plan.
**Inventory spoilage alert**: Role: Inventory Analyst. Task: Identify spoilage risk in Excel. Context: SKU, Location, OnHand, SpoilageRate. Output: Spoilage alerts and recommended actions.
**Accounts receivable pulse**: Role: AR Analyst. Task: Create a weekly AR health check in Excel. Context: Customer, DaysOutstanding, NetAR. Output: Health score and aging hot spots.
**Cash flow scenario matrix**: Role: Treasurer. Task: Build scenario matrix for cash flow in Excel. Context: Scenario, Inflow, Outflow, Timing. Output: Scenario comparison with recommended actions.
**Transaction categorization map**: Role: Data Architect. Task: Create a category map for transactions in Excel. Context: RawCategory, TargetCategory. Output: Mapping table and usage notes.
**Payment term analysis**: Role: Financial Analyst. Task: Analyze payment terms impact on cash cycle in Excel. Context: Terms, InvoiceDate, DueDate, Amount. Output: Cash cycle insights and optimization suggestions.
**Bad debt estimation**: Role: Credit Analyst. Task: Estimate bad debt reserve from aging data in Excel. Context: AgingBucket, Amount, ProbabilityOfDefault. Output: Reserve estimate and notes.
**Vendor performance dashboard**: Role: Procurement Manager. Task: Build vendor performance metrics in Excel. Context: Vendor, DeliveryOnTime, QualityScore, Spend. Output: Dashboard with SLA highlights.
**Working capital drilldown**: Role: CFO. Task: Drill down working capital components in Excel. Context: Receivables, Payables, Inventory. Output: Net working capital drivers and trend chart.
**COGS vs revenue analysis**: Role: Accountant. Task: Compare COGS to revenue by product in Excel. Context: Product, COGS, Revenue. Output: Gross margin by product with notes.
**Capital expenditure forecast**: Role: Finance Planner. Task: Forecast capex from project data in Excel. Context: ProjectID, PlannedCapex, ActualCapex. Output: Capex forecast with variance notes.
**Payroll tax reconciliation**: Role: Tax Accountant. Task: Reconcile payroll tax with payroll data in Excel. Context: Employee, TaxWithheld, TaxRate. Output: Reconciliation summary and anomalies.
**Interest expense tracking**: Role: Finance Analyst. Task: Track interest expenses in Excel. Context: Debt, InterestRate, PaymentDate, Amount. Output: Interest expense ledger and trend.
**Depreciation ledger**: Role: Accountant. Task: Build a depreciation ledger in Excel. Context: AssetID, PurchaseDate, Cost, Salvage, UsefulLife. Output: Depreciation schedule and book value.
**Credit limit utilization**: Role: Credit Analyst. Task: Monitor credit limit utilization in Excel. Context: Customer, CreditLimit, CurrentBalance, UsagePct. Output: Alerts and recommendations.
**Payroll compliance check**: Role: Compliance Auditor. Task: Verify payroll compliance in Excel. Context: Jurisdiction, Employee, PayDate, GrossPay. Output: Compliance status and remediation steps.
**Revenue concentration risk**: Role: Risk Manager. Task: Assess revenue concentration by customer in Excel. Context: Customer, Revenue. Output: Concentration risk score and mitigation ideas.
**Prototype profitability test**: Role: Product Controller. Task: Run profitability test on a new product in Excel. Context: Product, Revenue, Cost, LaunchDate. Output: Profitability result and break-even point.
**Tax received tracking**: Role: Tax Administrator. Task: Track tax payments and receipts in Excel. Context: TaxPeriod, Received, Due. Output: Payment status and aging.
**Customer lifetime value**: Role: Marketing Analyst. Task: Compute CLV from invoices in Excel. Context: Customer, Revenue, Costs, Retention. Output: CLV by customer and takeaway notes.
**Economic scenario analysis**: Role: FP&A Lead. Task: Model macro scenarios in Excel. Context: ScenarioName, GDP, Unemployment, Inflation. Output: Scenario impacts on cash and profits.
**Currency risk dashboard**: Role: Treasury Analyst. Task: Build a currency risk dashboard in Excel. Context: CurrencyPair, Exposure, Rate. Output: Risk indicators and mitigation actions.
**Audit sampling plan**: Role: Auditor. Task: Define a sampling plan for tests in Excel. Context: Population, Confidence, Margin. Output: Sampling method, sample size, and justification.
**Data lineage map**: Role: Data Manager. Task: Create data lineage for workbook inputs in Excel. Context: Source, Transform, Destination. Output: Visual data lineage and glossary.
**Error trend detection**: Role: Data Quality Analyst. Task: Detect error trends in Excel data. Context: Field, ErrorFlag, Date. Output: Trending errors and remediation plan.
**Month-end closing checklist**: Role: Bookkeeper. Task: Produce a month-end closing checklist in Excel. Context: Tasks, DueDate, Status. Output: Completed checklist with notes for each step.
**Intercompany balance test**: Role: Controller. Task: Test intercompany balances in Excel. Context: Intercompany, Amount, Date. Output: Reconciliation results and adjustments.
**Revenue leakage audit**: Role: Auditor. Task: Identify revenue leakage in Excel. Context: SourceData, Revenue, Discounts. Output: Leak detection report and corrective actions.
**Refunds trend analysis**: Role: Revenue Controller. Task: Analyze refunds by period in Excel. Context: Period, RefundAmount, NetSales. Output: Refund trend with root-cause notes.
**Rounding error check**: Role: Data Quality Lead. Task: Find rounding discrepancies in Excel datasets. Context: Amount, DecimalPlaces. Output: Rounding error report and fix list.
**Seasonality adjustment**: Role: FP&A Analyst. Task: Adjust seasonal effects in revenue data in Excel. Context: Month, Revenue, SeasonalityIndex. Output: Adjusted revenue series and notes.
**Customer churn flags**: Role: Customer Success Analyst. Task: Flag potential churn signals in invoicing data in Excel. Context: Customer, LastPurchase, Frequency. Output: Churn risk list and recommended actions.
**Expense forecasting model**: Role: Controller. Task: Build a basic expense forecast model in Excel. Context: Category, HistoricalExpense, GrowthRate. Output: Forecast by category and summary.
**Vendor merit ranking**: Role: Procurement Lead. Task: Rank vendors by merit using spend and delivery metrics in Excel. Context: Vendor, Spend, OnTimeDelivery, Quality. Output: Ranked list and rationale.
**Spot check data integrity**: Role: Auditor. Task: Perform spot checks on a workbook in Excel. Context: KeyFields, RecordsChecked. Output: Integrity score and issues.
**Date range summary**: Role: Data Analyst. Task: Summarize data within a date range in Excel. Context: StartDate, EndDate, Data. Output: Summary metrics and a compact chart.
**Client billing reconciliation**: Role: Billing Specialist. Task: Reconcile client invoices with billing records in Excel. Context: ClientID, InvoiceID, Amount. Output: Reconciled list and dispute notes.
**Null value remediation**: Role: Data Steward. Task: Identify and remediate null values in critical fields in Excel. Context: FieldList, DataSet. Output: Null report and remediation steps.
**Chart-ready dashboard**: Role: BI Developer. Task: Build a chart-ready Excel dashboard for finance metrics. Context: Metrics, Timeframe. Output: Dashboard with slicers and export options.
**Tax payable forecast**: Role: Tax Planner. Task: Forecast tax payable from revenue data in Excel. Context: TaxCode, Revenue, Rate. Output: Tax payable forecast by period.
**Audit log summary**: Role: Auditor. Task: Summarize an Excel workbook audit log. Context: ChangeDate, User, Action. Output: Summary of changes and risk insights.
**Credit risk scoring**: Role: Risk Analyst. Task: Score customer credit risk from payment history in Excel. Context: Customer, PastDues, AmountOwed. Output: Risk score and action plan.
**Tax code harmonization**: Role: Tax Specialist. Task: Harmonize tax codes across datasets in Excel. Context: SourceCode, TargetCode. Output: Mapping and notes.
**Payroll headcount analysis**: Role: HR Finance Analyst. Task: Link payroll costs to headcount metrics in Excel. Context: Employee, Dept, Cost, Hours. Output: Cost per employee and department insights.
**Receivables aging trend**: Role: AR Manager. Task: Track aging trend over time in Excel. Context: Date, AgingBucket, Amount. Output: Trend line and interpretation notes.
**Pricing model validation**: Role: Pricing Analyst. Task: Validate pricing assumptions in Excel. Context: Product, ListPrice, Cost, Margin. Output: Validation report and issues.
**Journal entry rehearsal**: Role: Accountant. Task: Rehearse journal entries from data in Excel. Context: Date, Account, Debit, Credit. Output: Pre-posting journal pack and notes.
**Receipts vs invoices match**: Role: AP Clerk. Task: Match receipts to invoices in Excel. Context: ReceiptID, InvoiceID, Amount. Output: Match table and exceptions.
**Discount leakage report**: Role: Finance Analyst. Task: Identify discount leakage in Excel. Context: Price, Discount, Quantity, Revenue. Output: Leakage amount and fix plan.
**GL reconciliation trace**: Role: Accountant. Task: Trace general ledger entries in Excel. Context: GLAccount, EntryDate, Amount. Output: Traceability report and anomalies.
**Audit readiness checklist**: Role: Compliance Officer. Task: Create an audit readiness checklist in Excel. Context: Area, RequiredDocs, Status. Output: Readiness score and next steps.
**Data anomaly detective**: Role: Data Scientist. Task: Detect anomalies in financial dataset in Excel. Context: DataColumns, Threshold. Output: Anomaly list with confidence levels.
**Workbook consolidation plan**: Role: Data Engineer. Task: Consolidate multiple sheets into a single workbook in Excel. Context: SourceSheets, TargetSheet. Output: Consolidated data and validation run.
**Excel export for reporting**: Role: Reporting Specialist. Task: Prepare a clean export-ready dataset for external reports. Context: DataColumns, FormatRequirements. Output: CSV/Excel export ready with metadata notes.

Best Practices

  • Keep prompts granular and task-focused to reduce ambiguity.
  • Reuse prompts with consistent contexts to build a reliable automation baseline.
  • Validate outputs against trusted sources before sharing or posting.
  • Add guardrails for data privacy and sensitivity when handling client data.
  • Document the exact inputs and assumptions used in each prompt for auditability.

Common Mistakes to Avoid

  • Using vague tasks like analyze data without specifying the data fields or expected outputs.
  • Neglecting to define output formats or validation steps, leading to unclear results.
  • Assuming latest data without providing a data refresh plan.
  • Ignoring data quality issues that should be addressed before analysis.
  • Overcomplicating prompts with too many optional constraints that confuse Gemini prompts.

FAQ

What makes a Gemini prompt effective for Excel data analysis in bookkeeping?

An effective Gemini prompt clearly defines role, task, data context, expected outputs, and constraints so the model can produce ready-to-use results without guesswork.

How should I format outputs for Excel data tasks?

Request outputs as structured tables, CSV, or Excel-ready ranges with explicit column headers and example rows to ease import.

Can I use these prompts for different datasets?

Yes, adapt placeholders and constraints to fit your dataset, keeping the core task and output format consistent.

How do I verify Gemini outputs?

Spot-check sample rows, compare totals to known figures, and validate with a secondary calculation or a manual audit.

Are there prompts for monthly close and year-end reporting?

Yes, there are prompts designed to support month-end closings, variance analysis, and year-end reporting workflows.

Do these prompts protect client data privacy?

Yes, prompts can be configured to avoid exposing sensitive identifiers and to use anonymized data where appropriate.