How to Check Balance Report

Prerequisites

We assume you have all the 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
   
5. Must have: to create a new Workspace you must have a License Key (provided by Finmars)
   

Checking Balance Report 

1. Go to the left sidebar. Locate and select the Report section and click on Balance.
   
   
2. Once on the Balance page, adjust the settings according to your reporting needs. Click the Settings icon in the top-right corner to open the configuration panel.
   
   
3. Set the Report Date to define the period for which you want the report (The date should always be set as End of Day). Choose the Currency in which values should be displayed. Select the appropriate Cost Method (such as AVCO or FIFO) and define the Pricing Policy to determine how asset values are calculated (When selecting the Pricing Policy, you are choosing the set of prices and exchange rates to be applied.)
   
   
4. Configure Portfolio Mode and Account Mode to structure the report according to specific requirements. These settings determine how the data is organized and presented. If Independent is selected the report will show separate entries for each portfolio or account, providing a more detailed, segmented view. If Ignore is chosen, the system will aggregate the data, displaying a consolidated view without distinctions between portfolios or accounts. After adjusting these settings, confirm by clicking OK.
   
5. 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.
   
   
6. 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.
7. 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 and save it locally to avoid potential data loss during updates or reinstallation of marketplace modules.
   
8. 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.
   
   
9. 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.
   
   
10. 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 Balance Report. If issues persist, contact the administrator for further assistance.