Consolidation Entry Template
Template for recording consolidation eliminations and adjustments. Standardize consolidation entries across periods.
How to use this template
Identify consolidation adjustments
List all consolidation entries needed: eliminate intercompany sales and profit, adjust equity method investments, record purchase accounting adjustments.
Document entry structure
For each consolidation entry, document the GL accounts affected, debit/credit amounts, and the business purpose.
Build formula-based template
Create spreadsheet template where consolidation amounts link to underlying schedules (e.g., intercompany sales total, intercompany profit).
Test consolidation entries
Verify that consolidated trial balance balances after all consolidation entries. Test that subsidiary balances eliminate appropriately.
Document and file
Prepare summary of all consolidation entries with supporting detail. File in close documentation for external auditors.
Why use this template
- Ensures consolidation entries are consistent and complete
- Reduces consolidation errors and adjustment cycles
- Creates clear record of consolidation methodology
- Streamlines multi-period consolidation process
Related templates
Journal Entry Tracker
Track all manual journal entries posted during the period. Maintain a centralized log with descriptions, approvals, and GL impact.
Journal EntriesRecurring Journal Entry Template
Document all recurring journal entries that post in each period. Include formulas and logic to ensure consistency and reduce manual entry errors.
Journal EntriesManual Adjustment Log
Log and track all manual GL adjustments made during the close period. Maintain history of what was adjusted and why.
Ready to streamline your close?
Vergo turns templates into automated workflows with real-time collaboration, integrations, and AI built in.