Intercompany Eliminations That Actually Eliminate

Intercompany should be boring. When it is not, the entity structure or the matching key is wrong.

Matching keys beat heroics

Agree one key across AP, AR, and consolidation:

• Trading partner + document ID, or
• Trading partner + period + amount bucket (worse, but explicit)

SELECT a.entity, a.partner, a.amount, b.amount AS counterparty
FROM ic_ar a
FULL OUTER JOIN ic_ap b
  ON a.partner = b.entity
 AND a.entity = b.partner
 AND a.doc_id = b.doc_id
WHERE COALESCE(a.amount, 0) <> -COALESCE(b.amount, 0);

FCCS patterns that help

• Plug accounts with owners who get paged
• Separate management vs. statutory elim members when policies diverge
• Never “fix” elim with a manual journal that lacks a reversing control

Eliminations are a design problem first. Journals are the last mile.