100 Best Gemini Year-end Close Prompts for Bookkeepers

Direct Answer

The best Gemini prompts for year-end close for bookkeepers are a practical, field-tested set of prompts designed to guide every step of the year end close. They cover cutoffs, reconciliations, disclosures, audits, and controls, enabling accurate financial reporting and smooth audit readiness. Expectations are clear, outputs are actionable, and constraints ensure compliance with standards.

Introduction

This page curates 100 Gemini prompts tailored to year-end close tasks for bookkeepers and accounting teams. It helps you standardize processes, automate repetitive checks, and prepare complete documentation for audits.

Whether you close books monthly or only at year end, these prompts provide concrete instructions, placeholders, and formats you can adapt to your chart of accounts and policies.

How to Use These Gemini Prompts

• Replace placeholders like [period], [account], and [entity] with your data context. Add constraints such as timing, variances, or materiality thresholds to tighten outputs. Specify required formats like tables, bullet lists, or journal entries. Request step by step reasoning when needed and verify outputs against your source documents. Always run a quick human review of final results before filing.

100 Best Gemini Year-end Close Prompts for Bookkeepers

1. Prepare year-end cutoff checklist: Act as a senior bookkeeper project lead. You have a dataset containing all transactions for the fiscal year. Create a year-end cutoff checklist by date, account, and document type. Include validation steps, responsible party, and due dates. Output: numbered checklist in plain text with comments for each item.
2. Reconcile all AR balances: You are a bookkeeping auditor assistant. Given accounts receivable aging and the general ledger AR control totals, generate a reconciliation report showing timing differences, stale items, and aging bucket matches. Output format: bullet list with issue, cause, action, owner, and deadline.
3. Close AP with cutoffs: Role: AP close coordinator. Using vendor invoices, purchase orders, and receiving reports, produce a week by week AP close plan, identify items to exclude or include in year-end, and document materiality thresholds. Output: structured steps and responsible owners.
4. Bank reconciliation wrap-up: Act as senior accountant. Review the bank reconciliation for all accounts for the final month. Highlight outstanding checks, deposits in transit, and any book errors. Provide remediation steps and a compliant audit trail.
5. Inventory year end counts: Role: inventory control lead. Generate a count plan for year-end inventory, map to GL, identify obsolescence, and propose adjustments. Output: table with item, location, count date, and adjustment reason.
6. Deferred items review: You are a finance analyst. List all deferrals impacting the year-end close, categorize by revenue or expense, and propose recognition timing. Output: summary with recommended JE adjustments and rationale.
7. Depreciation and amortization review: Act as fixed asset manager. Reconcile depreciation schedules to GL totals, identify missing assets, and propose adjustments. Output: reconciled schedule with aging and impairment notes.
8. Accruals and prepaids check: Role: accruals supervisor. Review all accruals and prepaids for accuracy, completeness, and cutoffs. Provide a checklist of items requiring manual adjustment before year-end.
9. Expense deferral summary: You are a close reviewer. Create a deferral summary by department, project, and account. Recommend which items should be deferred or recognized this year and the justification.
10. Intercompany elimination: Role: intercompany accountant. Prepare eliminations for all intercompany balances, including cross charges, unrealized profits, and intercompany sales. Output: elimination journal entries and supporting rationale.
11. Revenue cutoff testing: Act as revenue close specialist. Compare revenue recognition records to delivery dates and invoicing, identify cutoff risks, and propose correcting entries. Output: risk list with impact and remediation.
12. Profitability by product: You are a financial analyst. Produce product line profitability by comparing cost of goods sold with revenue, and flag over or under performance for year-end reporting.
13. Journal entry template: Role: close accountant. Create a standardized year-end journal entry template with fields for date, account, description, debit, credit, supporting document, and approval. Output: copyable template.
14. Audit readiness pack: Act as internal audit liaison. Compile a year-end close pack with policy references, control narratives, change logs, and supporting schedules. Output: checklist of required documents.
15. Cash flow adjustments: Role: treasury liaison. Identify year-end cash flow adjustments needed for accurate disclosures, and prepare a corresponding journal entry and note.
16. GAPs and controls heatmap: You are a controls analyst. Build a heatmap of gaps in year-end processes, assign risk rating, and propose remediation owners and timelines.
17. Tax provision alignment: Act as tax advisor. Align year-end tax provisions with financial statements, flag timing differences, and prepare a reconciliation schedule.
18. PEP compliance check: Role: compliance reviewer. Verify year-end close against PEP, SOX, or other control frameworks; list artifacts required for audit.
19. Financial statement drafting: You are an accounting reporter. Draft draft financial statements with notes covering year-end adjustments, significant policies, and contingencies.
20. Notes to financial statements: Act as disclosure specialist. Prepare notes for year-end disclosures including accounting policies, estimates, and contingencies.
21. Expense allocation review: Role: cost accountant. Validate expense allocations by department and project, adjust for year-end accuracy, and document methodology.
22. Revenue by contract analysis: You are a revenue analyst. Analyze revenue by contract and identify long-term versus short-term services for disclosure and cutoffs.
23. Inventory write-down triggers: Act as inventory controller. Identify indicators that inventory may be impaired and propose write-down journal entries with supporting calculations.
24. Fixed asset roll-forward: Role: asset accountant. Create a roll-forward schedule linking opening balances, acquisitions, disposals, and depreciation for year-end.
25. Accrued liabilities schedule: You are a close team lead. Compile a detailed schedule of accrued liabilities with rationale, due dates, and responsible owner.
26. Cutoff testing plan: Act as audit planner. Design a year-end cutoff testing plan covering revenue, expenses, and liabilities with sampling and documentation requirements.
27. Unbilled revenue review: Role: revenue controller. List unbilled revenue balances, assess collectability, and propose adjustments or disclosures.
28. Vendor master cleanup: You are a vendor master auditor. Identify duplicate or invalid vendors affecting year-end, propose clean-up steps and controls.
29. Payroll liabilities reconciliation: Act as payroll accountant. Reconcile payroll liabilities with payroll reports, tax withholdings, and benefits, and propose year-end adjustments.
30. Allowance for doubtful debts: Role: credit manager. Calculate bad debt allowance using historical data and forecast assumptions; adjust GL accordingly.
31. Capitalization vs expense: You are a policy specialist. Review capitalization thresholds and classify expenditures as asset or expense for year-end.
32. Interest calculations verification: Act as treasury analyst. Verify interest accruals across debt instruments, and adjust for any variances before reporting.
33. Intercompany loan reconciliation: Role: IC accountant. Reconcile intercompany loan balances and interest to ensure accurate elimination and disclosures.
34. Currency translation review: You are a financial translator. Validate currency translation adjustments and ensure consistent FX impact in statements.
35. Lease accounting close: Act as lease administrator. Close off right-of-use asset and lease liability balances, verify disclosures and amortization.
36. Noncash adjustments log: Role: close facilitator. Maintain a log of noncash adjustments with justifications and note references.
37. Disclosures checklist: You are a disclosure specialist. Prepare year-end disclosure checklist aligning with standards and policy requirements.
38. Management commentary draft: Act as financial writer. Draft management discussion and analysis highlights focusing on year-end results and key drivers.
39. Audit trail reconstruction: Role: auditor assistant. Reconstruct the audit trail for year-end adjustments with document paths and reviewer sign-offs.
40. Cost center accuracy review: You are a cost accountant. Validate cost center assignments across GL and project codes for year-end correctness.
41. Bank fees reconciliation: Act as bank reconciliation clerk. Reconcile bank service charges and interest with GL, noting discrepancies.
42. VAT/GST reconciliation: Role: tax specialist. Reconcile VAT or GST with local filings and GL to ensure accurate tax reporting.
43. Depreciation policy audit: You are an asset policy auditor. Confirm depreciation methods and useful lives align with policy and asset entries.
44. Audit evidence pack: Act as audit manager. Assemble evidence pack with source documents, reconciliations, and approvals for year-end close.
45. Revenue recognition notes: Role: revenue specialist. Prepare notes describing revenue recognition methods and any changes for the year-end.
46. Expense leakage review: You are a cost control analyst. Identify areas of waste or overstatements in year-end expenses and propose corrections.
47. G/L reconciliation pivot: Act as data analyst. Create a pivot friendly G/L reconciliation showing reconciled, unmatched, and timing difference items.
48. Key controls map: Role: internal controls lead. Map key financial close controls, owners, and testing frequency for SOX readiness.
49. Note disclosures enhancements: You are a disclosures consultant. Propose enhancements to notes for clarity and compliance in year-end filings.
50. Close timeline planning: Act as project manager. Create a day by day year-end close calendar with milestones and owners.
51. Bad debt aging review: Role: credit controller. Analyze aging of receivables and set the appropriate allowance with rationale.
52. Inventory counting variance: You are inventory auditor. Investigate variances between counts and GL balances, propose adjustments and documenting evidence.
53. Open items and suspense: Act as close supervisor. List open suspense items, assign owners, and set completion deadlines.
54. Pension and benefits accruals: Role: benefits accountant. Reconcile pension and benefit accruals to disclosures and contribution schedules.
55. Transfer pricing notes: You are a tax and accounting specialist. Prepare notes about transfer pricing impacts in year end disclosures.
56. Audit risk register: Act as audit liaison. Create an annual close risk register focused on year-end procedures and mitigation steps.
57. Share-based payment review: Role: compensation accountant. Reconcile and disclose share-based payment accruals and related tax impacts.
58. Inventory obsolescence plan: You are inventory planner. Identify obsolete stock, propose write-downs, and document approvals.
59. Prepaid amortization schedule: Act as prepaid specialist. Schedule amortization of prepaids with dates, balances, and impact on P&L.
60. Fixed asset disposals: Role: asset administrator. Reconcile disposed assets, remove from books, and adjust depreciation.
61. Cash bank reconciliations: You are a treasury clerk. Reconcile cash with bank statements and highlight timing differences.
62. Lease disclosures check: Act as lease auditor. Verify lease disclosures align with lease accounting standards.
63. Revenue by channel: Role: revenue analyst. Break down revenue by sales channel, ensure channel data aligns with GL and notes.
64. Contract assets review: You are a contract accountant. Review contract assets and liabilities and adjust recognition timing.
65. Note to payroll specifics: Act as payroll note writer. Document payroll related assumptions and estimation methods for disclosures.
66. Tax compliance sweep: Role: tax compliance officer. Perform a year-end tax compliance sweep and flag unresolved items.
67. Currency risk notes: You are risk analyst. Prepare notes outlining currency risks and hedging results in year end.
68. Audit committee briefing: Act as corporate secretary. Draft a concise year-end close briefing for the audit committee.
69. Expense reclassification: Role: close accountant. Reclassify misposted expenses to correct accounts with justification.
70. Deferred revenue review: You are revenue controller. Validate deferred revenue balances and recognize as earned where appropriate.
71. Expense accrual justification: Act as close reviewer. Provide justification for each expense accrual with supporting documents.
72. Disaster recovery notes: Role: risk manager. Include year-end close contingencies and DR plan references in notes.
73. Cumulative effect entries: You are journal specialist. Document cumulative effect adjustments and ensure proper disclosure.
74. Capital expenditure capex: Act as capital planner. Track capex additions and link to depreciation schedules for year-end.
75. Insurance accruals check: Role: treasury accountant. Reconcile insurance accruals with premium schedules and statements.
76. Tax provision reconciliation: You are tax provision analyst. Reconcile the current tax provision to statutory tax rates.
77. Noncontrolling interest: Act as consolidation accountant. Allocate NCI to earnings and ensure correct presentation in statements.
78. Interest rate hedging: Role: risk controller. Document hedge effectiveness and reflect in year-end disclosures.
79. Share issuances close: You are equity administrator. Close out share issuances and update related cap table notes.
80. Interim close alignment: Act as process harmonizer. Align interim close results with final year-end close and resolve variances.
81. Disposal proceeds check: Role: asset disposal specialist. Reconcile proceeds from disposed assets with GL and asset register.
82. Audit sampling plan: You are audit sample expert. Design year-end audit sampling plans with confidence intervals and tolerances.
83. Vendor compliance review: Act as vendor compliance auditor. Check year-end vendor data against contracts and approvals.
84. Expense approvals trace: Role: close controller. Trace major year-end expenses to approvals and supporting documents.
85. Customer rebates review: You are revenue controller. Reconcile customer rebates and discounts against contracts and GL.
86. Inventory aging report: Act as inventory analyst. Produce aging report for finished goods and raw materials.
87. Tax credits tracking: Role: tax specialist. Track eligible tax credits and capture disclosures in notes.
88. PBC list preparation: You are auditor liaison. Prepare a PBC list with requested documents for year-end audit.
89. Consolidation pack: Act as group controller. Assemble consolidation worksheets, intercompany eliminations, and minority interests note.
90. Financial ratios summary: Role: financial analyst. Compute key ratios for year end and prepare brief interpretation notes.
91. Pension funding impact: You are pension accountant. Estimate funding impact on year-end results and disclosures.
92. Treasury management report: Act as treasury chief. Summarize year-end cash, debt, and liquidity metrics for reporting.
93. Audit trail clean-up: Role: close administrator. Remove outdated supports and reorganize file paths for year-end access.
94. Regulatory reporting prep: You are corporate accountant. Prepare numbers for regulatory reports tied to year-end close.
95. Consolidation adjustments: Act as group accountant. Apply consolidation adjustments and verify elimination accuracy.
96. G/L data quality check: Role: data steward. Run data quality checks on GL balances and fix anomalies.
97. Note disclosure review: You are disclosure reviewer. Validate that all required disclosures are present and accurate.
98. Close results presentation: Act as finance communicator. Prepare a concise year-end close summary for leadership with highlights.
99. Process improvement ideas: Role: continuous improvement analyst. Propose actionable improvements to the year-end close process for next year.
100. Final sign-off package: You are close lead. Compile final sign-off package with approvals, dates, and responsible owners for year-end close.

Best Practices

• Use consistent terminology across prompts to simplify reuse. Tag prompts by task type (reconciliation, journal entries, disclosures) for quick filtering. Keep outputs audit-ready with clear ownership, dates, and supporting documents. Validate prompts against your own close policies and SOX controls. Store completed prompts and results in a centralized evidence pack.

Common Mistakes to Avoid

• Relying on prompts without providing data context or supporting documents. Missing materiality thresholds in accruals and cutoffs. Overusing generic phrases instead of specific account details. Skipping validation steps before journal entries. Failing to align notes with applicable accounting standards.

FAQ

What makes a Gemini prompt effective for year-end close?

An effective prompt is specific, assigns responsibility, defines required output format, and includes data placeholders and constraints to ensure auditable results.

How should I customize prompts for my chart of accounts?

Replace generic accounts with your actual GL accounts, adjust thresholds, and specify your department structure and entity details in placeholders.

Can these prompts produce journal entries automatically?

They can generate structured journal entry templates and supporting notes, but you should review and approve entries before posting.

How do I verify outputs from prompts?

Cross-check generated outputs against source documents, reconciliations, and trial balances, and perform sample testing as you would in a real close.

Are the prompts adaptable for multiple entities?

Yes, replace entity placeholders and tailor intercompany and consolidation steps to each entity's structure and policies.

Do prompts cover audit readiness and SOX controls?

Yes, many prompts focus on control evidences, disclosures, and audit trail reconstruction aligned with common frameworks.