The Transaction Detail Report bridges the gap between the transaction-level detail in your subsidiary QBO companies and the account-level journal entries posted to your consolidation parent.
What's in the report
The report downloads as an Excel file containing every individual transaction line for the selected accounting period, with all GL fields included. Each transaction line also shows the mapped parent account, which lets you reconcile directly from the transaction level up to your consolidated financial statements.
Why it's useful for FP&A
The report is structured as a clean data table — meaning you can easily combine reports from multiple subsidiaries into a single Excel workbook to build one pivot-ready dataset covering all subsidiaries, with both subsidiary and parent COA detail. This makes the Transaction Detail Report a strong complement to your higher-level consolidated financial reporting, providing the granularity needed for deeper FP&A analysis.
Where to find it
This is the same report that's available during the review step of the Single Period Consolidation workflow. We've simply added it here as a standalone, on-demand workflow.
Coming soon
For users consolidating foreign currency subsidiaries, we're adding a column to display transaction balances in both the local currency and the translated reporting currency.