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
374
Financial Accounting
Advanced

Foreign subsidiary translation and CTA rollforward

Builds translation steps for a foreign subsidiary and a cumulative translation adjustment (CTA) rollforward. Helps consolidation teams document FX methodology and reconcile equity impacts.

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

Pharma: R&D Milestone Payment Accounting

Determines when to recognize revenue or expense for drug development milestones.

GPT-4oClaude 3.5 Sonnet
0
0
91