100 Best Gemini Month-end Close Prompts for Accountants

Direct Answer

The best Gemini prompts for month-end close for accountants are crafted to guide reconciliations, journal postings, accruals, and reporting with precise roles, tasks, and formats. Use them to standardize closing steps, enforce controls, and speed up audit readiness without guessing. Apply placeholders for organization specifics and verify outputs against policy.

Introduction

This page is a practical prompt library for month-end close workflows using Gemini prompts. It is designed for accountants and finance teams who want ready-to-run prompts that cover reconciliations, accruals, and reporting.

Whether you are a small business accountant or part of a corporate finance group, these Gemini prompts help you close the books faster with consistent documentation and clear outputs.

How to Use These Gemini Prompts

• Replace placeholders like [industry], [audience], [product], [constraints], [data], [tone], and [format] with your specifics.
• Add constraints such as data sources, reporting formats, and approval requirements to tailor prompts to your process.
• Request outputs in multiple formats (table, CSV, narrative) to fit both human readers and downstream systems.
• Run a quick verification step after generation to ensure balances reconcile and supporting documents exist.
• Save and version prompts to reuse for future month-ends based on account materiality.

100 Best Gemini Month-end Close Prompts for Accountants

1. Prepare reconciliations summary: Role: Accounting analyst. Task: Generate a month-end reconciliations summary for all material accounts. Context: Use the general ledger data from the current period and last period. Output format: bullet list with account, opening balance, closing balance, reconciling items, and status. Constraints: no PII, include discrepancy flag if variance > 1% of account balance.
2. Automate journal entries: Role: Journal entry coder. Task: Produce a set of automatic recurring journal entries for month-end close. Context: Include depreciation, amortization, accruals, and prepayments. Output format: CSV and plain text. Constraints: assign GL codes correctly, include memo and source document reference.
3. Accrual calculations guide: Role: Accountant. Task: Create a standardized accrual calculation for revenue and expenses. Context: Use current period estimates and historical trends. Output format: step-by-step calculation with assumptions and supporting data references. Constraints: specify cut-off dates and adjustment impact on P&L and balance sheet.
4. Variance analysis prompts: Role: Financial analyst. Task: Identify material variances between actuals and forecast for month-end. Context: Focus on top five accounts by materiality. Output format: table with account, variance amount, percentage, driver, and recommended action. Constraints: limit to ten lines.
5. Cutover checklist creator: Role: Close lead. Task: Generate a month-end close cutover checklist. Context: Include tasks, owners, deadlines, and dependencies. Output format: ordered list with status markers. Constraints: ensure audit trail readiness.
6. Intercompany reconciliation prompts: Role: Consolidation specialist. Task: Reconcile intercompany balances for month-end. Context: Include all active entities and eliminate intercompany profits. Output format: table with entity pair, balance, eliminations, and variance notes. Constraints: flag items beyond tolerance.
7. Accrual schedule builder: Role: Accountant. Task: Build a quarterly accrual schedule for month-end close. Context: Include revenue and expense lines with timing differences. Output format: calendar-like table with period, recognition date, and amount.
8. Prepaids adjustment prompts: Role: Accountant. Task: Create a prepaid adjustment list for month-end. Context: List all prepaid assets, amortization schedule, and remaining periods. Output format: table with asset, amortization expense, cumulative balance.
9. Depreciation review prompts: Role: Asset controller. Task: Review depreciation calculations for month-end. Context: Validate asset class, useful lives, salvage values. Output format: checklist with pass/fail and notes. Constraints: flag deviations from policy.
10. Cash flow linkage prompts: Role: Analyst. Task: Ensure month-end cash flow ties to close results. Context: Cross-check bank statements, AP, AR, and treasury entries. Output format: narrative plus a reconciliation table. Constraints: identify timing differences.
11. Vendor balance clean-up: Role: AP lead. Task: Identify stale vendor balances at month-end. Context: Cross-check with AP aging and PO receipts. Output format: list with vendor, balance, oldest item, recommended action.
12. AR aging reconciliation: Role: Credit manager. Task: Reconcile accounts receivable aging to subledger. Context: Include dispute items and credits. Output format: table with aging buckets, amounts, and aging reason.
13. GL reconciliation script: Role: Accountant. Task: Generate a columnar GL reconciliation script for month-end. Context: Use a standardized reconciliation template. Output format: script blocks and resulting ledger snapshot.
14. Balance sheet integrity: Role: Controller. Task: Validate balance sheet integrity at month-end. Context: Check for out-of-balance conditions and unusual journal entries. Output format: audit-ready report with explanations.
15. Notes to financial statements: Role: Financial reporting specialist. Task: Draft month-end disclosure notes. Context: Include contingencies, commitments, and risk factors. Output format: structured notes with numbering.
16. Tax provisions prompts: Role: Tax accountant. Task: Prepare month-end tax provision calculations. Context: Include tax rate changes and jurisdictional specifics. Output format: summary with line-item reconciliation.
17. Cutoff verification prompts: Role: Compliance lead. Task: Verify revenue and expense cutoff accuracy. Context: Use supporting documents and date stamps. Output format: verification matrix with pass/fail indicators.
18. Audit readiness prompts: Role: Internal auditor. Task: Compile month-end close evidence pack. Context: Include reconciliations, journal entries, and approvals. Output format: zipped folder manifest with contents.
19. Management reports prompts: Role: FP&A analyst. Task: Generate management close package. Context: Include P&L, balance sheet, and cash flow summaries. Output format: PDF with executive summary.
20. Revenue recognition prompts: Role: Revenue accountant. Task: Validate revenue recognition for month-end. Context: Align with contract terms and ASC/IFRS rules. Output format: reconciliation table with drivers.
21. Expense allocation prompts: Role: Controller. Task: Allocate expenses across departments for month-end. Context: Use driver-based allocation rules. Output format: summary by department and supporting calculations.
22. Depreciation vs impairment: Role: Asset manager. Task: Assess impairment risk at month-end. Context: Review asset condition and market indicators. Output format: decision log with recommendation.
23. Journal posting checks: Role: Accountant. Task: Validate month-end journal postings for accuracy. Context: Check post dates, amounts, and supporting documents. Output format: checklist with pass/fail.
24. Bank reconciliation prompts: Role: Treasury analyst. Task: Reconcile banks for month-end. Context: Include outstanding items and float. Output format: reconciliation table with aging.
25. Credit note review: Role: AP/AR team. Task: Review credit notes issued in month-end. Context: Confirm authorization and impact on balances. Output format: register with references.
26. Interim to month-close: Role: Close lead. Task: Bridge interim close to month-end close. Context: List pending tasks and owners. Output format: dashboard view with status.
27. Consolidation prompts: Role: Consolidation lead. Task: Prepare month-end consolidation adjustments. Context: Eliminate intercompany balances and align equity. Output format: consolidation worksheet.
28. P&L accuracy prompts: Role: FP&A. Task: Check P&L accuracy by account. Context: Compare to forecast and prior period. Output format: variance analysis with explanations.
29. Disclosures prompts: Role: Reporting lead. Task: Draft month-end disclosure items. Context: Include contingent liabilities and risk disclosures. Output format: structured notes.
30. Working paper prompts: Role: Auditor. Task: Create month-end working papers. Context: Attach reconciliations, schedules, and approvals. Output format: folder index with cross-references.
31. PQT prompts: Role: Compliance officer. Task: Prepare month-end performance quality tests. Context: Define KPIs and pass criteria. Output format: test plan and results.
32. Cutoff evidence prompts: Role: Accountant. Task: Gather cutoff evidence for revenue and expenses. Context: Include timestamps, approvals, and sender details. Output format: evidence log.
33. Accrual reversal prompts: Role: Accountant. Task: Identify accrual reversals for month-end. Context: Ensure proper net effect on P&L. Output format: reversal calendar and entries.
34. Expense accrual validation: Role: Controller. Task: Validate expense accrual calculations. Context: Check timing and materiality. Output format: validation matrix.
35. Prepaid amortization prompts: Role: Accountant. Task: Amortize prepaid assets for month-end. Context: Apply straight-line method and remaining period. Output format: amortization schedule.
36. Inventory month-end prompts: Role: Inventory manager. Task: Reconcile inventory for month-end. Context: Include valuation, obsolescence, and cut-off. Output format: reconciliation with variance drivers.
37. Fixed asset roll prompts: Role: Asset controller. Task: Roll forward fixed assets for month-end. Context: Update additions, disposals, and depreciation. Output format: asset register snapshot.
38. Expense allocation validation: Role: Cost controller. Task: Validate cost allocations to projects. Context: Check basis and fairness. Output format: allocation report with review notes.
39. P&L by department prompts: Role: FP&A. Task: Produce month-end P&L by department. Context: Include headcount and overhead allocations. Output format: table with totals and percent of revenue.
40. Cash vs accrual prompts: Role: Accountant. Task: Compare cash vs accrual basis for month-end. Context: Highlight timing differences. Output format: reconciliation notes and table.
41. Journal approval prompts: Role: Approver. Task: Validate journal entries before posting. Context: Check authorization, accuracy, and supporting docs. Output format: approval log with sign-offs.
42. Intercompany timing prompts: Role: Controller. Task: Align intercompany timing differences. Context: Reconcile timing for revenue and costs. Output format: timing mismatch report.
43. SOX control prompts: Role: Compliance lead. Task: Verify SOX controls in month-end close. Context: Include control owner and evidence type. Output format: control map with evidence references.
44. Audit trail prompts: Role: Auditor. Task: Ensure complete audit trail. Context: Attach supporting documents for each entry. Output format: index of docs and summaries.
45. Pivot for close package: Role: FP&A. Task: Pivot data into close package visuals. Context: Include metrics and trends. Output format: dashboard-ready visuals.
46. Revenue cutover prompts: Role: Revenue manager. Task: Prepare cutover steps for revenue close. Context: Map contract milestones to period end. Output format: step-by-step sequence.
47. Expense sanity checks: Role: Controller. Task: Run sanity checks on expenses. Context: Flag duplicates and invalid accounts. Output format: checklist with alerts.
48. Vendor aging prompts: Role: AP analyst. Task: Reconcile vendor aging lines. Context: Cross-check PO receipts and invoices. Output format: aging with anomaly notes.
49. Bad debt assessment prompts: Role: Credit manager. Task: Assess bad debt provisions. Context: Use historical default rates and current conditions. Output format: provision table.
50. Tax provision review: Role: Tax specialist. Task: Review month-end tax provision accuracy. Context: Include jurisdictional notes. Output format: reconciliation and notes.
51. PPE additions prompts: Role: Asset controller. Task: Record PPE additions for month-end. Context: Include details and depreciation start date. Output format: asset addition log.
52. Consolidation interco mapping: Role: Consolidation lead. Task: Map intercompany transactions for consolidation. Context: Include elimination entries. Output format: mapping table.
53. G/L reversals prompts: Role: Accountant. Task: Prepare month-end G/L reversals. Context: Identify prior-period adjustments. Output format: reversal journal packet.
54. Audit evidence catalog: Role: Auditor. Task: Catalog month-end evidence by account. Context: Link to schedules. Output format: evidence catalog with IDs.
55. Variance driver prompts: Role: FP&A. Task: Capture drivers for variances. Context: Attach supporting data. Output format: driver list with links to data.
56. AR collateral checks: Role: Credit analyst. Task: Verify AR collateral impact. Context: Include disputed invoices. Output format: notes and adjustments.
57. P&L forecasting touchpoints: Role: FP&A. Task: Align forecast touchpoints with close. Context: Update assumptions post-close. Output format: revised forecast sheet.
58. Close package storyboard: Role: Close lead. Task: Create storyboard for month-end package. Context: Include sections and owners. Output format: outline with visuals.
59. Non-financial disclosures: Role: Reporting lead. Task: Gather non-financial disclosures for statements. Context: Include regulatory notes. Output format: disclosure appendix.
60. IFRS vs US GAAP prompts: Role: Controller. Task: Compare month-end close treatments. Context: Highlight key differences. Output format: comparison matrix.
61. Audit risk indicators: Role: Auditor. Task: Identify month-end close risk indicators. Context: Focus on high-risk accounts. Output format: risk heatmap.
62. Supporting schedules prompts: Role: Accountant. Task: Create month-end supporting schedules. Context: Link to primary statements. Output format: schedule inventory.
63. Expense cutoff prompts: Role: Accountant. Task: Verify expense cutoff accuracy. Context: Include expense prepayments. Output format: cutoff log.
64. Revenue cut-off checks: Role: Revenue lead. Task: Check revenue cutoff correctness. Context: Include timing and invoicing. Output format: cutoff certifications.
65. Cash reconciliation prompts: Role: Treasury analyst. Task: Reconcile cash to bank. Context: Include outstanding cheques and deposits in transit. Output format: bank reconciliation notes.
66. Tax calendar prompts: Role: Tax accountant. Task: Build tax calendar for month-end. Context: Include filing deadlines. Output format: calendar with reminders.
67. Lease accounting prompts: Role: Accounting specialist. Task: Close leases under relevant standards. Context: Record right-of-use assets and liabilities. Output format: lease close worksheet.
68. Pension liabilities prompts: Role: Accountant. Task: Close pension obligation entries. Context: Include contributions and fair value. Output format: liability roll-forward.
69. Budget vs close prompts: Role: FP&A. Task: Compare budget to close results. Context: Highlight重大 variances and actions. Output format: variance report.
70. Closing memo prompts: Role: Close lead. Task: Draft closing memo for management. Context: Summarize key changes and risks. Output format: memo text.
71. Intercompany eliminations prompts: Role: Consolidation lead. Task: Prepare intercompany eliminations. Context: Include all entities. Output format: elimination journal packet.
72. Month-end dashboards prompts: Role: Analyst. Task: Create dashboards for month-end close. Context: Include critical metrics. Output format: interactive dashboard specs.
73. Audit-ready packet prompts: Role: Auditor. Task: Assemble month-end packet. Context: Attach evidence by account. Output format: zipped packet manifest.
74. Close risk review prompts: Role: Compliance officer. Task: Review risks in close process. Context: Document mitigations. Output format: risk register notes.
75. Asset disposals prompts: Role: Asset manager. Task: Record disposals in month-end close. Context: Include gain/loss calculations. Output format: disposal log.
76. Multi-entity close prompts: Role: Controller. Task: Close multiple entities in one package. Context: Ensure currency translation alignment. Output format: consolidated close workbook.
77. Expense reimbursements prompts: Role: AP analyst. Task: Close reimbursements month-end. Context: Validate approvals and accounts. Output format: reimbursement ledger.
78. P&L trend prompts: Role: FP&A. Task: Analyze month-end P&L trends. Context: Compare to prior year. Output format: trend chart notes.
79. Journal impact prompts: Role: Accountant. Task: Assess journal impact on ratios. Context: Include solvency metrics. Output format: impact matrix.
80. Close communications prompts: Role: Close lead. Task: Draft communications to stakeholders. Context: Include highlights and risks. Output format: email brief.
81. Closing controls prompts: Role: Compliance lead. Task: Verify closing control effectiveness. Context: Test control performance. Output format: control test results.
82. Inventory write-off prompts: Role: Inventory manager. Task: Evaluate write-offs for month-end. Context: Include ageing and quantity on hand. Output format: write-off justification.
83. Payroll close prompts: Role: Payroll lead. Task: Close payroll period. Context: Include accruals and tax withholdings. Output format: payroll close report.
84. Fixed asset revaluation prompts: Role: Asset controller. Task: Revalue major assets for month-end. Context: Apply fair value and impairment checks. Output format: revaluation worksheet.
85. Close reconciliation prompts: Role: Accountant. Task: Reconcile all close schedules. Context: Ensure consistency across documents. Output format: consolidated reconciliation pack.
86. Notes to auditors prompts: Role: Auditor liaison. Task: Prepare notes for auditors. Context: Explain complex entries. Output format: annotation pack.
87. Critical path prompts: Role: Project manager. Task: Identify critical path tasks for month-end close. Context: Assign owners and deadlines. Output format: critical path chart.
88. System reconciliation prompts: Role: IT-auditor. Task: Reconcile ERP data with GL. Context: Flag data quality issues. Output format: reconciliation report.
89. Close calendar prompts: Role: Close lead. Task: Produce calendar for month-end close. Context: Include milestones and owners. Output format: calendar view.
90. Audit trail health prompts: Role: Auditor. Task: Check health of audit trail. Context: Verify completeness and immutability. Output format: trail health report.
91. Compliance checklists prompts: Role: Compliance officer. Task: Generate month-end compliance checklists. Context: Include regulatory requirements. Output format: checklist with status.
92. Revenue disputes prompts: Role: Revenue manager. Task: Resolve revenue disputes before close. Context: Attach dispute docs. Output format: dispute resolution log.
93. Capital expenditures prompts: Role: Capital controller. Task: Close capex projects month-end. Context: Validate capitalization criteria. Output format: capex close sheet.
94. Treasury funding prompts: Role: Treasury analyst. Task: Ensure month-end funding adequacy. Context: Include cash buffers. Output format: funding adequacy report.
95. Currency translation prompts: Role: Controller. Task: Close month-end multi-currency entities. Context: Apply IFRS/US GAAP translation rules. Output format: translation worksheet.
96. Expense variance prompts: Role: FP&A. Task: Analyze expense variances by category. Context: Link to cost centers. Output format: variance notes.
97. Regulatory reporting prompts: Role: Compliance officer. Task: Prepare regulatory close reports. Context: Include deadlines and formats. Output format: regulatory report pack.
98. Close package validation prompts: Role: QA analyst. Task: Validate entire close package. Context: Check completeness and accuracy. Output format: validation checklist.
99. Management commentary prompts: Role: Reporting lead. Task: Draft management commentary for close. Context: Explain drivers and risks. Output format: narrative section.
100. Final sign-off prompts: Role: CFO. Task: Approve month-end close for publication. Context: Confirm all schedules are reconciled. Output format: sign-off memo.

Best Practices

• Map prompts to your close calendar so owners know their duties and deadlines.
• Combine prompts into a single close package to reduce handoffs and errors.
• Keep prompts up to date with policy changes and new accounting standards.
• Test prompts in a sandbox environment before production use to ensure data access and outputs are correct.

Common Mistakes to Avoid

• Using generic prompts that lack audit-relevant details or formats.
• Missing placeholders that require manual data input during execution.
• Posting without validation or approvals captured in prompts.
• Assuming outputs are sufficient without cross-checks against source documents.
• Overloading prompts with too many requirements that reduce clarity.

FAQ

What are Gemini prompts for month-end close used for?

They provide structured, repeatable tasks for reconciliations, journal entries, accruals, and reporting to speed up the closing process and improve accuracy.

How should I customize prompts for my close process?

Replace placeholders with your data sources, GL codes, entity structure, and approval rules. Add constraints and required formats to enforce consistency.

Can prompts replace the human review in month-end close?

Prompts automate repeatable steps but should be complemented by human review for judgments, policy exceptions, and audit evidence.

Which outputs should I require from prompts?

Require reconciliations, journal entry packets, schedules, and an audit trail with sign-offs to ensure completeness.

How do I ensure prompts stay compliant?

Keep prompts aligned with current accounting standards, regulatory requirements, and internal control policies; update them after policy changes.

Are prompts useful for multi-entity closes?

Yes, prompts can be structured to handle intercompany eliminations, currency translations, and consolidated reporting across entities.