Drill Down from Reports to Transactions
Investigate specific balances by drilling down from reports to transactions.
Drill Down from Reports to Transactions
Click on any line item in a report (P&L, Balance Sheet, Trial Balance) to see the individual transactions that make up that amount. This helps you quickly investigate specific balances.
Overview
Propio's reports are interactive — every line item amount is clickable. When you click on a number in a Profit & Loss, Balance Sheet, or Trial Balance report, Propio takes you directly to a filtered view of the individual transactions that make up that amount. This drill-down capability lets you quickly investigate any balance, verify accuracy, and answer client questions without manually searching through the transaction list.
Steps
1. Open Any Report
Navigate to Reports in the left sidebar and open the report you want to investigate. This works with the Profit & Loss, Balance Sheet, and Trial Balance reports. Make sure you've set the appropriate date range for the period you want to review.
2. Click on a Line Item Amount
Find the line item you want to investigate in the report. Click directly on the amount (the dollar figure) for that line item. The amount is clickable and will be visually indicated as a link or interactive element. For example, you might click the total for "Office Supplies" in a P&L report to see exactly which transactions are included in that figure.
3. View the Filtered Transactions
After clicking, Propio displays a filtered transactions table showing only the transactions that contribute to the selected line item amount. This view includes all standard transaction details — date, description, amount, vendor, and category — but is pre-filtered to the specific account or category you selected from the report.
4. Review Individual Transactions
Scroll through the filtered transactions to review each one. You can click on any individual transaction to open its detail panel for more information, including its full categorization, vendor details, memo, and audit history. This is useful for identifying specific transactions that may need correction or that a client has questions about.
5. Navigate Back to the Report
When you're done reviewing the transactions, use the back button or navigation breadcrumb to return to the report you were viewing. The report will remain at the same state and date range you had selected, allowing you to continue your review or drill into other line items.
Summary
Drilling down from reports to transactions is one of the fastest ways to investigate specific balances and verify the accuracy of your client's books. Simply click any amount in a P&L, Balance Sheet, or Trial Balance report to see the underlying transactions. This interactive reporting feature eliminates the need to manually filter and search, making report review and client inquiries significantly faster.