Transaction Reports - Tips, Tricks and More

This guide will walk you through some hidden tricks to help you better understand and filter reports in Navigator, focusing on the transaction report. By the end of this guide, you’ll be able to utilise various filtering options to make sense of your transaction journals and enhance your report analysis.

1. Accessing the Transaction Report

• Open Navigator and navigate to the transaction report section. This report provides detailed insights into all transaction journals, making it a critical tool for financial analysis.

2. Understanding Filtering Options

• Filter by Date Range: Narrow down your report to specific time periods by adjusting the date range filter. This is useful for focusing on transactions within a particular fiscal quarter or year.
• Filter by Transaction Type: Use this filter to view only specific types of transactions, such as sales, refunds, or adjustments. This allows you to focus on the most relevant data for your analysis.
• Filter by Account: If you manage multiple accounts, use this filter to view transactions associated with a specific account. This helps in isolating account-specific data for a more targeted review.
• Advanced Filters: Explore additional filtering options such as transaction amount, customer ID, or transaction status. These advanced filters allow for a more granular analysis, enabling you to pinpoint specific transactions or trends.

3. Applying Filters

• Once you’ve selected the appropriate filters, apply them to refresh the report. This will display a more focused dataset, making it easier to analyse and draw meaningful conclusions.

4. Analysing the Filtered Data

• Review the filtered report to identify patterns, discrepancies, or areas of interest. The refined data set will help you manage and interpret transaction journals more effectively.

5. Exporting and Sharing Reports

• If you need to share your findings, export the filtered report in your preferred format (e.g., PDF, Excel) and distribute it to relevant stakeholders.

Conclusion

By mastering these filtering options in Navigator, you can significantly enhance your ability to analyse and manage transaction reports. These tips will help you gain deeper insights into your data, making your financial analysis more efficient and effective.