Advanced

Intercompany reconciliation matrix and elimination entry pack

Builds an intercompany matrix across entities, identifies mismatches, and drafts eliminations for consolidation. Great for multi-entity groups and shared service centers.

Prepare an intercompany reconciliation and elimination pack for {consolidation_period}.

Inputs:
- Entity list and currency: {entity_list}
- Intercompany balances by entity pair: {ic_balances}
- Intercompany P&L (sales, COGS, services, interest): {ic_pl}
- Transfer pricing or markup policy: {tp_policy}
- Known disputes/notes: {ic_notes}

Output:
1) IC matrix: From entity, To entity, Account, Amount, Difference, Status, Owner.
2) Root-cause hypotheses for top differences and how to validate.
3) Elimination journal entries: balance sheet and P&L (with memo and support references).
4) Close checklist for IC (confirmations, cut-off, FX, settlements).

Be precise and structured.

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
45
Financial Accounting
Beginner

Vendor statement reconciliation and duplicate payment scan

Reconciles vendor statements to AP subledger and identifies duplicates/credits. Produces a clear recon with recovery actions for AP and treasury.

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
1
63