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
1
75
Financial Accounting
Advanced

Impairment indicator screen and impairment test outline

Screens for impairment indicators and outlines an impairment test approach with documentation steps. Useful for controllers and advisors supporting annual impairment reviews.

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

Hedge Accounting Effectiveness Memo

Drafts the technical justification for designating a derivative as a hedge.

GPT-4oClaude 3.5 Sonnet
0
0
7