Intermediate

Consolidation worksheet template (trial balance to consolidated FS)

Creates a consolidation worksheet structure including eliminations, reclasses, and mapping to FS lines. Useful for building a first-time consolidation model in Excel.

Design a consolidation worksheet template.

Inputs:
- Entities and ownership %: {ownership_structure}
- Trial balances by entity: {entity_trial_balances}
- FS line mapping: {fs_line_mapping}
- Known eliminations/reclasses: {known_elims_reclasses}
- Reporting currency: {reporting_currency}

Deliver:
1) Recommended worksheet tabs and column structure (entity TB → adjustments → consolidated).
2) Mapping table schema (account → FS line, sign conventions).
3) Standard adjustment categories (IC, equity, NCI, FX, reclasses).
4) Validation checks (balance, rollforward, cash flow link, intercompany net to zero).

Output in a step-by-step build plan.

Related Prompts

Financial Accounting
Beginner

Month-End Close Checklist Generator

Generates a comprehensive month-end close checklist tailored to your company type and size.

ChatGPT-4oClaude Sonnet 4.5Gemini 2.5 Pro
0
0
6
Financial Accounting
Advanced

ASC 606 contract intake: performance obligations & allocation

Analyzes a customer contract under ASC 606/IFRS 15: identifies performance obligations, determines transaction price, and allocates consideration. Produces a concise memo and a revenue schedule outline.

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
2
Financial Accounting
Advanced

IFRS 15 variable consideration constraint assessment

Evaluates variable consideration and the constraint, documenting probability-weighted outcomes and recognition impacts. Helps controllers defend judgments and build consistent templates across contracts.

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
2