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

253

Financial Accounting

Intermediate

AP three-way match exceptions and accrual recommendations

Finds exceptions between PO, receiving, and invoice data; recommends resolutions and accruals for goods received not invoiced. Helps AP teams and controllers reduce close surprises.

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

130

Financial Accounting

Intermediate

AR aging review and expected credit loss (ECL/CECL-lite)

Analyzes AR aging, flags collection risks, and proposes an allowance methodology and JE. Useful for controllers in smaller entities who need a practical, supportable approach.

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