Drill down to source accrual data in GL reports for Consolidation books

You can drill down to source transactions in the General Ledger (GL) report for consolidation reporting books. The transaction amount column in the report lists a linked amount for each transaction where you can drill down for details about the source journal entry. Drilling down to the accrual data from the consolidation book enables reviewing and verifying your numbers, which can be helpful during the audit process.

You can use the drill-down feature in any General Ledger report you run with a consolidation book as the selected reporting book. Select the detailed view of the report to drill down to transaction details from the transaction amount column.

The drill-down feature provides the following benefits: 

• It enables drilling down to accrual data from the consolidation book to confirm transaction amounts.
• Drill-down also improves traceability and audit by including a transaction amount column.
• You can export the report in summary to CSV, PDF, and Excel formats.
• The drill-down feature applies to companies with subscriptions to Domestic Consolidation, Global Consolidation, or Advanced Ownership Consolidation.

1. Go to General Ledger > All > Reports, then select General Ledger.
2. For the reporting book, select the relevant consolidation book.
3. Under Format, select Details for Show transaction presentation.
4. Select View to examine the report.
5. Select a transaction and drill down to the source journal entries.