Can I combine trial balance sheets from multiple entities into one pre-consolidation dataset?

Yes. Upload each entity's trial balance workbook and enable 'Include source file name.' Each trial balance row is tagged with its entity file, giving you a combined dataset ready for consolidation journal entries or intercompany elimination.

Does the tool handle entities with different charts of accounts?

Yes — Deliteful outputs the union of all column names. Accounts unique to one entity appear as columns for all rows, with empty cells for entities that don't use that account. This is the expected sparse structure for cross-entity consolidation before remapping to a standard COA.

Is the output suitable for import into ERP consolidation modules?

The output is a clean flat .xlsx. Whether it matches your ERP's required import schema depends on that ERP's requirements. You may need to reformat column names or order to match your consolidation module's import template.

Can I combine quarterly reports across multiple years into one historical dataset for audit purposes?

Yes. Upload all period files at once. With 'Include source file name' enabled and consistent file naming conventions (e.g. 'entity-Q3-2024.xlsx'), every row retains its period and entity attribution — suitable for multi-year audit workpapers.

Combine Multi-Entity and Multi-Period Excel Sheets for Financial Consolidation

Financial consolidation for multi-entity organizations means pulling trial balances, expense reports, and P&Ls from separate Excel files for each subsidiary, cost center, or reporting period. Before any consolidation journal entry or intercompany elimination can be performed, all of that data needs to be in one place. Deliteful's Excel Combine Sheets tool handles the pre-consolidation merge step.

Create free account

A holding company consolidating financials across five subsidiaries may receive separate Excel workbooks from each entity — each with their own chart of accounts column layout, currency columns, or segment coding. The first step in any consolidation workflow is stacking these into a single flat dataset before applying elimination entries or running the consolidation model. Doing this manually for five entities across 12 periods is 60 file-copy operations per year.

Deliteful reads headers from the first row of every sheet across all uploaded workbooks and outputs the column union in a single combined worksheet. Entity-specific columns appear for all rows; missing columns get empty cells. Enable 'Include source file name' and each row retains its entity identifier — essential for intercompany elimination matching and audit trail documentation.

How it works

1
Collect entity or period workbooks
Gather .xlsx files from each subsidiary, cost center, or reporting period that feeds into the consolidation.
2
Upload all workbooks
Drop all entity files into Deliteful at once; all sheets across all files are combined in one job.
3
Enable entity tagging
Turn on 'Include source file name' so each row retains its entity or period identifier for consolidation and audit purposes.
4
Load into your consolidation model
Import the combined sheet into your Excel consolidation template, ERP import, or audit workpaper.

Frequently asked questions

Can I combine trial balance sheets from multiple entities into one pre-consolidation dataset?: Yes. Upload each entity's trial balance workbook and enable 'Include source file name.' Each trial balance row is tagged with its entity file, giving you a combined dataset ready for consolidation journal entries or intercompany elimination.
Does the tool handle entities with different charts of accounts?: Yes — Deliteful outputs the union of all column names. Accounts unique to one entity appear as columns for all rows, with empty cells for entities that don't use that account. This is the expected sparse structure for cross-entity consolidation before remapping to a standard COA.
Is the output suitable for import into ERP consolidation modules?: The output is a clean flat .xlsx. Whether it matches your ERP's required import schema depends on that ERP's requirements. You may need to reformat column names or order to match your consolidation module's import template.
Can I combine quarterly reports across multiple years into one historical dataset for audit purposes?: Yes. Upload all period files at once. With 'Include source file name' enabled and consistent file naming conventions (e.g. 'entity-Q3-2024.xlsx'), every row retains its period and entity attribution — suitable for multi-year audit workpapers.

Create your free Deliteful account with Google and run your pre-consolidation Excel merge in seconds before your next close cycle.