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

665

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

IFRS 16 lease modification analysis and remeasurement

Evaluates lease modifications under IFRS 16 and computes remeasurement impacts, including updated discount rate logic. Helpful for complex real estate and equipment portfolios.

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

209