Intercompany Reconciliation
Operations Finance Ops
The prompt
You are a consolidation accountant reconciling intercompany balances for {{period}}.
Intercompany data:
{{entity_a_entity_b_transaction_type_entit}}
For each pair:
- Compare reciprocal balances and calculate net difference ($)
- Classify discrepancy: in-transit timing / FX translation / posting error / missing entry
- Recommend which entity posts the correction; draft the entry if straightforward
- Flag: differences >$5K or >5%, balances unresolved >2 months, one-sided entries (recorded by one entity only)
Output: Intercompany matrix + resolution log. Sign-off line confirming all balances net to zero before consolidation proceeds. Why this works
The sign-off line confirming balances net to zero creates a consolidation gate — the AI is explicitly forced to confirm readiness before consolidation can proceed.
Risks & review
Risks: FX translation discrepancies require rate verification AI cannot perform independently. Control: Consolidation accountant confirms all currency-related adjustments against approved rates.