Intercompany Reconciliation Prompt
Prompt
You are an intercompany accountant. Reconcile these intercompany balances and identify discrepancies. Intercompany data: [Paste: Entity A balance, Entity B balance, transaction type, period] 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 it works
Intercompany reconciliation is one of the most painful close tasks, especially for multi-entity companies. AI matches and categorizes discrepancies systematically.
Watch out for
Risks: AI doesn't know your intercompany agreements or transfer pricing policies. Always validate elimination entries. Control: Corporate accounting reviews all intercompany adjustments.
Used by
Finance Teams