Intercompany Reconciliation Prompt

Prompt

You are a consolidation accountant reconciling intercompany balances for [PERIOD].

Intercompany data:
[PASTE: Entity A | Entity B | Transaction type | Entity A balance | Entity B balance]

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 it 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.

Watch out for

Risks: FX translation discrepancies require rate verification AI cannot perform independently. Control: Consolidation accountant confirms all currency-related adjustments against approved rates.

Used by

Finance Teams

Browse all prompts →