These reports bridge the gap between the account detail sitting in your subsidiary ledgers and the consolidation journal entries JustConsolidate posts to your consolidation entity.
Every row carries the subsidiary's own account alongside the consolidation entity account it maps to, so you can trace a figure on your consolidated financial statements back to the subsidiary accounts that built it.
You'll find this under Transaction Detail in the Consolidation workflow section.
Two reports to choose from
Both reports draw on the same underlying data and show the same account-level detail. What differs is how many subsidiaries you can include and how the file is laid out.
| Option 1 — Multi-Entity | Option 2 — Single-Entity | |
| Subsidiaries | Any number, or all of them at once | One at a time |
| Layout | A flat data table — no headers, groupings or subtotals, so it's pivot-table ready as downloaded | Two tabs — a formatted summary report with subtotals by parent account, plus the same data as a pivot-ready flat table |
| Built for | FP&A analysis, pivot tables, feeding a dataset into an AI tool | Audit support and account reconciliation |
What's in the reports
The reports carry the full set of general ledger fields, plus the subsidiary and consolidation entity account detail and three sets of balance columns.
Balances are presented in separate debit and credit columns for each of opening balance, period activity and ending balance, in the subsidiary's own currency:
| Columns | What they show |
| Parent Account Number, Parent Account Name | The consolidation entity account the balance maps to |
| Subsidiary Name, Sub Account Number, Sub Account Name | Where the balance came from |
| Account Type, Account Status | The subsidiary account's classification, and whether it's active |
| OBAL-Debit, OBAL-Credit | Opening balance for the period |
| Activity-Debit, Activity-Credit | Movement during the period — this is what gets consolidated |
| EBAL-Debit, EBAL-Credit | Ending balance for the period |
| Fiscal Period, transaction date and the remaining general ledger fields | The standard GL detail behind each balance |
Because several subsidiary accounts often map to a single consolidation account, you'll see that parent account repeated across multiple rows. That's what makes the data useful — group by parent account to see the consolidated figure, then expand to see which subsidiary accounts built it.
If you have foreign currency subsidiaries When a subsidiary reports in a currency other than your consolidation entity's, the report adds a second pair of debit and credit columns showing period activity translated into your reporting currency, labelled with that currency so there's no ambiguity about which figures are which. Only period activity is translated. Opening and ending balances stay in the subsidiary's own currency, because period activity is what actually gets consolidated — those translated columns are the figures that end up in the consolidation journal entry. The subsidiary's currency is noted at the top of the report. Between the two sets of columns you can tie the report back to the subsidiary's own books and forward to your consolidated statements without converting anything yourself. |
Option 1 — Multi-Entity data table
This download returns one clean table covering every subsidiary you select, with no headers, groupings or subtotals to strip out first.
It's pivot-table ready as it downloads — select the data, insert a pivot table, and start slicing. The same structure makes it straightforward to hand the whole dataset to an AI tool for analysis.
Select the subsidiaries you want from the drop-down. Tick them individually, or use (Select all) to pull every connected subsidiary into a single file — which saves downloading each one separately and stitching them together.
Option 2 — Single-Entity Transaction Detail Report
This download covers one subsidiary and arrives as a workbook with two tabs, giving you both a presentation-ready report and the raw data behind it.
The summary tab, named for the period it covers, is laid out as a report you can hand to someone else. It opens with a header block identifying the subsidiary, the fiscal period, the subsidiary's currency and the date the report was extracted. Rows are then grouped by consolidation entity account, with a subtotal after each group, so you can see at a glance what each consolidated account is made up of. This is the tab to work from during an audit or an account reconciliation.
The Table tab holds the same information as a pivot-ready flat data table, in the same shape as the Option 1 download. Use it when you want to pivot or analyze a single subsidiary without running the multi-entity report.
The Download Report button stays greyed out until you've chosen a subsidiary, since this report only ever covers one.
How to download a report
- Choose the fiscal year and fiscal period you want to report on. Each option has its own selectors, so you can run them for different periods if you need to.
- Choose your subsidiaries — one or many for Option 1, a single one for Option 2.
- Click Download Report. The file downloads as an Excel workbook.