Intercompany Balance Elimination Check
=SUMIFS($C:$C,$A:$A,E$1,$B:$B,"Intercompany")ADVERTISEMENT - IN-ARTICLE
Implementation Guide
This task supports accountants in identifying and validating intercompany balances that must be eliminated during consolidation. By summing intercompany transactions by entity or counterparty, discrepancies become visible before close. The formula-driven approach improves transparency and reduces last-minute reconciliation issues. It is especially useful in multi-entity groups where intercompany activity is frequent and complex. Accountants can extend the model to flag mismatches between sending and receiving entities. This structured check strengthens consolidation controls and audit readiness without requiring specialized consolidation software.
💡 Expert Q&A Insights
Q: Can this compare both sides of an intercompany pair?
Yes, add entity-to-entity matching logic. |
Q: Is this used before or after consolidation?
Typically before, as a validation step.