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