This report is designed to bridge the transaction level of detail that exists in your subsidiary QBO company to the chart-of-account balance level that is posted via journal entry to your parent / consolidation company.
This excel download report is loaded with all the individual transaction lines for the selected accounting period with all the GL fields displayed. The report also contains the mapped to parent account to enable reconciliation to consolidated financial statement level. A separate data table format enables you to easily aggregate reports across all subsidiary companies into one excel sheet to enable one large pivot table ready data table with GL level transaction detail across all subsidiary companies with COA detail of sub and parent. This report is a great complement your higher level consolidated financial reporting with detail to support additional FP&A.
The report is the same report that is available for download in the review step of the Single Period Consolidation workflow, we are simply adding this as a new on-demand workflow now.
For users who consolidate foreign currency subsidiaries, an enhancement to this workflow is coming soon to add an additional column to display transaction balances in both local and translated reporting currency.