Intercompany eliminations are rebuilt by hand every close
Four entities are consolidated through a spreadsheet that is rebuilt from exports each period. The workbook carries prior-period formulas forward manually, so an error introduced in one cycle can persist undetected into the next.
- Process
- Intercompany elimination & consolidation
- Severity
- High
- Estimated impact
- 14–22 hrs / close
- Confidence
- Medium — questionnaire only
- Complexity
- Medium
- Priority
- 1 of 4
Recommendation. Move eliminations into a defined, version-controlled routine with a reconciliation check before posting. Validate first: the actual entity ownership structure, whether the elimination logic differs by entity pair, and who currently reviews the workbook before posting.