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
1
4
264
Financial Accounting
Intermediate

ASC 606 Five-Step Compliance Checker

Analyzes a described revenue arrangement against each of the 5 steps of ASC 606. Flags potential issues and recommends documentation.

ChatGPT-4oClaude Sonnet 4.5
0
0
437
⭐ Featured
Financial Accounting
Advanced

ASC 606 disclosure checklist mapped to data sources

Generates an ASC 606/IFRS 15 disclosure checklist and maps each disclosure to internal data sources and owners. Ideal for SEC reporting teams and controllers improving disclosure readiness.

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