How To Check Transaction Report

Prerequisites

We assume you have all prerequisites you may need, including:

1. If needed: the VPN is configured to access the Finmars resources
2. If needed: access to the Virtual Machine to work with the sensitive information
3. Must have: registered in Finmars in the needed region environment (self-registered or registered by Finmars)
4. Must have: having permissions set to allow continue with the Action in the Guide
   

Checking Trasaction Report

1. Go to the left sidebar. Locate and select the Report section and click on Transaction. Ensure that the correct layout is selected from the dropdown in the upper-left corner. If the wrong layout is selected, change it before proceeding.
   
   
2. Once on the Transaction page, ensure the Report Date is set correctly. You can select predefined periods like YTD, MTD, QTD, or choose a custom date range for more precise reporting. The system displays data as of the end of the selected day. After choosing click Save.
   
   
3. If you want to configure more detailed report settings, click on the gear icon in the top-right corner to open the settings panel. 
   
   
4. In the Report Settings, you can configure is:
   1. Report Date - defines the date range for the report. Users can select a specific date range or predefined periods (e.g., YTD, MTD). The system displays the transactions on the end of the selected day.
   2. Table Font Size - adjusts the text size within the report (Small, Medium, Large).
   3. Expression Iterations Count - defines how many times the system applies calculations for custom columns in the report. Set to "1" for most reports. Increase only if your report data has dependencies between diferent custom columns, and is not calculated  with one iteration.
   4. Date Field - lets users choose which date type to apply in the report (e.g., Transaction Date, Accounting Date, Cash Date, etc.)
   5. Custom Fields - this option allows users to enable additional user-defined fields (with expression formulas) in the report for more detailed or specific reporting needs. Not recommended to use due its high resource consumption. 
   6. Depth Level - defines the level of detail in the report, with options: 
      1. Complex Transaction - shows the transaction as a whole, without breaking it down into internal actions or money movements. Best for a quick overview of operations.
      2. Base Transaction - shows the internal actions within the transaction (for example, different steps of execution), but without splitting it into cash or position movements.
      3. Entry - shows the most detailed view with all accounting records. Here the transaction is fully broken down into cash flows and position changes.
   7. Filters – Allows users to refine the displayed data by using multi-selectors for Portfolios, Accounts, and Strategies.
      
5.  After adjusting these settings, confirm by clicking OK.
   
   
6. To apply the selected settings and view the updated report, simply refresh the page. Once refreshed, the report will be displayed with the updated parameters, reflecting the selected configurations.
   
   
7. Once the report has been prepared, verify the displayed information to ensure that the Grand Total and individual portfolio data are correct. If mistakes are discovered, review the imported data to ensure that all relevant files were included through the import process. If changes are required, return to the Report Settings, alter the settings, and reload the page to update the report.
8. After verifying the report, you can either save it within the system for future reference or export it for external use. To do this, locate the Save button, which is positioned in the upper-left corner of the report interface. Clicking this button will store the current report layout and data for future access. It’s important to use the standard settings whenever possible to maintain consistency. If changes are needed, create a duplicate of the layout (see How to Duplicate the Layout) and save it locally to avoid potential data loss during updates or reinstallation of marketplace modules.
   
   
9. The Export option is located in the top-right corner, providing multiple formats for downloading the report. You can choose to Export to PDF, Export to CSV, or Export to Excel, depending on the preferred format for further analysis.
   
   
10. Additionally, there are options to Copy all to buffer or Copy selected to buffer, allowing you to quickly copy report data for use in other applications. Ensure that the exported or copied data accurately reflects the report before using it for financial reporting or analysis.
    
    
11. In case of any errors or missing data warnings, check that the required Import has been successfully completed. Ensure that all necessary financial and transactional data has been imported into the system before running the Transaction Report. If issues persist, contact the administrator for further assistance.