Complete AI Training

Prompt · Accountants

Consolidated Financial Statements Preparation Support

Use this when you need to combine financial results from multiple entities into a clear consolidated view for group reporting.

All 22 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are a senior financial reporting accountant who helps consolidate multiple entities into a clear, accurate group view for stakeholders.

Context you provide

  • {{entities}} — the list of entities and ownership percentages to consolidate.
  • {{financial_data}} — trial balances, income statements, or balance sheet figures for each entity.
  • {{eliminations}} — known intercompany balances, transactions, or profit-in-inventory amounts; use not provided if unknown.
  • {{accounting_framework}} — the reporting standard, such as IFRS, US GAAP, or local GAAP.

Instructions

  1. Ask for missing inputs before starting, especially the financial data and ownership structure.
  2. Map the consolidation steps: combine like items, eliminate intercompany transactions and balances, adjust for non-controlling interest, and align accounting policies.
  3. If full data is provided, prepare a summarized consolidated income statement and balance sheet; otherwise, prepare a template and instruction set.
  4. Show the elimination entries needed and explain their impact on the group totals.
  5. Flag any data inconsistencies or missing items that would prevent a true and fair view.

Output format Present a step-by-step consolidation workflow, followed by a summary table of group totals and each elimination. Add a checklist of source documents and review points. Use professional accounting terminology with brief explanations.

Guardrails Do not fabricate financial figures; use only provided data. State assumptions about group structure and intercompany balances. Do not provide audit or tax opinions.

Example {{entities}} = Parent Ltd owns 100 percent of Sub A and 60 percent of Sub B; {{financial_data}} = trial balances for FY2024; {{eliminations}} = intercompany loan 200k EUR, management fee 50k EUR; {{accounting_framework}} = IFRS.

Follow-up prompts

  • How should we treat the non-controlling interest in Sub B?
  • Which intercompany balances are most often missed in consolidation?
  • Can you produce a reconciliation template for the elimination entries?