Chart of Accounts Optimizer
Les directeurs financiers et contrôleurs utilisent ce prompt lors de l'implémentation d'un nouveau système comptable, d'une préparation d'audit, ou pour assainir un plan comptable devenu trop complexe au fil du temps.
Prompts
You are a CFO-level accounting systems consultant with deep experience designing chart of accounts (COA) structures for [INDUSTRY] businesses. I will provide you with our current COA and company context, and I need you to perform a comprehensive optimization review. Company context: - Industry: [INDUSTRY] - Company size: [SIZE] (e.g., startup, SMB with $5M revenue, mid-market with 150 employees) - Accounting standard: [ACCOUNTING STANDARD] - Current accounting software: [SOFTWARE] - Number of entities/cost centers: [ENTITY COUNT] Current Chart of Accounts: [CURRENT COA] Perform a full COA optimization review covering: 1. **Structural Assessment** - Evaluate the numbering scheme: is it logical, scalable, and consistent? - Identify gaps in the account number range that could cause future problems - Flag accounts with vague or inconsistent naming conventions 2. **Consolidation Opportunities** - Identify accounts that are redundant or serve the same purpose - Recommend merges while preserving historical data integrity - Calculate estimated reduction in account count 3. **Missing Accounts** - List accounts that are standard for [INDUSTRY] businesses of [SIZE] but absent from the current COA - Prioritize by business risk (e.g., missing accrued liabilities account is high-risk) - Suggest appropriate account numbers following the existing scheme 4. **Naming & Classification Fixes** - Provide a before/after table of recommended name changes - Flag any accounts that appear to be misclassified (e.g., an expense coded as an asset) 5. **Reporting & Segmentation Improvements** - Recommend department, class, or location segments that would improve management reporting - Suggest sub-account structures for key high-volume accounts 6. **Implementation Roadmap** - Phase 1: Quick wins (rename/reclassify, low disruption) - Phase 2: Structural changes (requires mapping of historical data) - Phase 3: New segments and advanced reporting setup Output your findings as a structured report with a prioritized recommendations table.
Variables du Prompt
Remplacez chaque placeholder par vos informations spécifiques :
[INDUSTRY][SIZE][ACCOUNTING STANDARD][SOFTWARE][ENTITY COUNT][CURRENT COA]Ce que vous obtiendrez
Un rapport de recommandations priorisé couvrant les opportunités de consolidation, les comptes manquants, les corrections de nommage, et une feuille de route d'implémentation par phases — avec un tableau avant/après pour les changements de comptes.
💡 Conseil d'Expert
Exportez votre plan comptable en CSV depuis votre logiciel comptable et collez-le directement dans le prompt. Incluez le solde des 12 derniers mois — les comptes à solde zéro inactifs depuis un an sont les principales cibles de consolidation.
Outils IA Compatibles
Claude
Best for complex COA analysis involving multiple entities or industry-specific nuances; Claude can cross-reference your existing structure against industry best practices and produce a phased implementation plan.
ChatGPT
Works well for mid-market COA reviews; paste your COA as a numbered list or CSV. Use GPT-4o for better handling of large account lists exceeding 200 accounts.
Gemini
Good for integrating with Google Sheets — you can reference a Sheets tab containing your COA and ask Gemini to analyze and output recommendations in an adjacent column.