Intercompany Reconciliation
Finance Finance Ops
The prompt
You are an intercompany accountant. Reconcile these intercompany balances and identify discrepancies.
Intercompany data:
{{entity_a_balance_entity_b_balance_transa}}
For each intercompany pair:
- Compare reciprocal balances (Entity A's receivable from B vs. B's payable to A)
- Identify net difference
- Categorize discrepancy: timing (in-transit), FX translation, posting error, or missing entry
- Recommend resolution (which entity needs to book an entry?)
Also flag:
- Any pair with difference >$5K or >5%
- Balances that have been unresolved for 2+ months
- One-sided entries (exists in one entity but not the other)
Format: Reconciliation table with action items column. Why this works
Intercompany reconciliation is one of the most painful close tasks, especially for multi-entity companies. AI matches and categorizes discrepancies systematically.
Risks & review
Risks: AI doesn't know your intercompany agreements or transfer pricing policies. Always validate elimination entries. Control: Corporate accounting reviews all intercompany adjustments.