User Quick Start


Get Access to Finmars

Prerequisites

No specific prerequisites are needed.

Getting Access to Finmars

Based on your desired deployment type you can get access to Finmars in following ways:

  1. Community Edition (simple)
  2. Community Edition (advanced)
  3. Cloud or Enterprise

Link with Finmars ID

Prerequisites

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

  1. Get Access to Finmars
  2. You have the internet access

Linking with Finmars ID

Step 1: Go to marketplace

image.png

Step 2: Click on "Link with Finmars ID" button

image.png

Step 3: You will be redirected to FinmarsID sign-in/register page: you need to either sign-in or register in FinmarsID, depending on your choice you select what you need.

image.png

Step 4: After register/sign-in you will be redirected back to the marketplace page, refresh the page and you will see that instead of "Link with Finmars ID" button you now have "Linked with Finmars ID" label and "Unlink" button.

image.png

Step 5: Additionally you will have your License key added to the Default settings which will be used to unlock paid modules in the marketplace

image.png

Install PMS Core or PMS Plus add-on

Prerequisites

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

  1. Get Access to Finmars
  2. Link with Finmars ID
  3. You have the internet access

About PMS Core and PMS Plus add-ons

The Portfolio Management Solution (PMS) is a core Finmars add-on that enables asset managers, investors, and partners to manage, track, and analyze portfolios in one place.

It provides all essential tools for portfolio monitoring, transaction tracking, and performance reporting — available in a fully functional free version, with optional paid features for advanced analytics and automation.

For whom?

What's Inside?

For more technical details see: PMS Core and Plus

Installing PMS Core or PMS Plus add-on

After getting access to Finmars Space in the beginning you won't have any add-ons installed. As of now add-ons are distributed via Marketplace which requires the Internet access.

Go to the Marketplace page in the sidebar menu
image.png

Then depending on your choice you can:

  1. Install PMS Core add-on
  2. Install PMS Plus add-on

Installing PMS Core add-on

To install Free PMS Core add-on: Search "PMS Core" in the search bar and you will see PMS Core - Fully functional and Developer friendly FREE version which is subset of PMS Plus

image.png

By clicking Install you will get the latest version of the PMS Core add-on. For details on the installation process follow How to Install/Update add-on from Marketplace.

You will get progress window which will show you the progress and finish:

image.png

image.png

After the installation finished refresh the page and you can go to the sidebar menu Add-ons and see the "PMS" appeared in there.

image.png

Installing PMS Plus add-on

PMS Plus add-on requires access by your license for installation. Without it for paid add-ons you will see "License Required" button instead of the active "Install" button. To obtain license: Get License for add-on.

image.png

After you obtain the license for PMS Plus you can go to the marketplace page, search for "PMS Plus" and click Install button as usual. The installation process will be the same as for PMS Core. And you can install PMS Plus over existing PMS Core.

image.png

image.png

image.png

Import Files in PMS Core and PMS Plus

Prerequisites

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

  1. Get Access to Finmars
  2. Link with Finmars ID
  3. Install PMS Core or PMS Plus add-on

Import Files in PMS Core and PMS Plus

In this guide we will demonstrate how to import excel files in PMS Plus add-on, while commenting what is available to PMS Plus only and absent in PMS Core (which is the subset of PMS Plus). 

Step 1: Go to the sidebar menu Add-ons > PMS. 

image.png

Step 2: You will see the PMS add-on page which provide the access to the Excel Import (1) interface and Helper (2) they both have similar structure of 2 panes: left pane - run page where you configure what to do, and right pane - execution info page where you can see logs and result.

image.png

image.png

In this guide we will go through how to use Excel Import tab of PMS add-on. 

Step 3: Go to Excel Import tab of PMS add-on.

image.png

PMS Plus version

image.png

PMS Core version (marked differences)

Overview of the elements on the Excel Import tab
  1. "Plus" badge - indicator that you are using PMS Plus version. If you have PMS Core, there will be "Core" badge and "Upgrade" button that will link you to the PMS Plus add-on. 
  2. "Download excel Example" the button allows you to download Excel files for import, there are 2 set of them:
    1. excel_demo_data - ready to import data that will allows you to check Finmars platform in action;
    2. excel_import_file_templates - templates how to populate the excel file in Finmars format and you still can import them as well but they won't give you nice values in reports. 
  3. Next to some labels in file select, input or checkboxes elements you will see Info icon - click on it to see description of the element. 
  4. You will see Multiple File Select input and Text Input elements where your input required.
  5. "Reset" button allows to reset selected files. 
  6. "File Fields (Advanced Import)" section is only for "PMS Plus" and contains Multiple File Select inputs for: 
    1. Simple entities (more control over creation): currencies, accounts, portfolios, counterparties, responsibles, strategies;
    2. Instruments: Factor and Accrual schedules;
    3. Positions: Daily (one day living snapshot), Initial (starting positions in case you can't import historical transactions).
  7. "Checkboxes" inputs have similar structure as other inputs with info and label. 
  8. "Advanced Settings" section is optional and contains additional inputs for debug mode (show more logs info) and more flexible calculations. 
  9. "Run" button is active only when at least one file has been selected for import, when you click it you will see confirmation modal window with workflow user code and payload info.
  10. "Refresh" button - click on it to refresh the right pane with execution info, update is manual. 
  11. "Open Workflow" button - you can go to the exact workflow running in the workflow service of the Finmars Platform. 
  12. Status badge will show current status of the workflow, it can be: Not Started, Queued, In Progress, Completed, Canceled, Failed, - if add-on encounter some other statuses it will show "Unknown status:" label with the exact status received. 
  13. Log - text area showing the logs of execution, don't forget to refresh data. 
  14. Result - text area showing the final result of execution ({} - is when no result received or empty result, check status).
  15. "Workflow Details" section is additional technical information about workflow and its tasks. 

Step 4: To import Excel files you need to:

Let's assume that you have the data ready, I will use DEMO data. 

Step 5: Select corresponding files in the left pane:

  1. Core files: Instruments, Transactions, FX Rates, Prices,
  2. Plus files in "File Fields (Advanced Import)" section: Currencies, Accounts, Portfolios, Counterparties, Responsibles, Strategies, Instrument Factor Schedules, Instrument Accrual Schedules, Positions Daily, Positions Initial. 

image.png

image.png

Step 6: Check checkboxes, it's recommended to keep ticked:

Step 7: Click "Run" button and you will see:

  1. uploading progress window showing your selected files (it will disappear when finished uploading)
  2. then confirmation window, you can check that everything is ok and click run button to start executing

image.png

image.png

Step 8: After clicking "Run" button if everything is ok, the first thing you will see is that status badge changed to "Queued" and "Refresh" and "Open Workflow" buttons are active now. 

image.png

Step 9: Click Refresh button to see the progress. Logs will show what's going on. 

image.png

Step 10: You need to wait for:

  1. the status change from "In-progress" to the next transition "Completed" or "Error" (see label #1 below in the screenshot)
  2. the result text area will give you summary of execution (see label #2 below in the screenshot)

If you use DEMO data: you will need to wait around 40 minutes for a full pipeline. 

Expected Steps in Log
  1. parse_import_currencies
  2. parse_import_accounts
  3. parse_import_portfolios
  4. parse_import_counterparties
  5. parse_import_responsibles
  6. parse_import_strategies1
  7. parse_import_instruments
  8. import_instr_factor_schedules
  9. import_instr_accrual_schedules
  10. import_transactions
  11. import_positions_initial
  12. import_positions_daily
  13. import_fx_rates
  14. import_prices
  15. if you ticked "Calculate Metrics" checkbox
    1. calculate_price_history
    2. calculate_register_records
    3. calculate_portfolio_price_history
    4. calculate_portfolio_history

image.png

Step 11: If you see status completed and no errors in Result or Log you can go check your data:

  1. Go to Dashboard
  2. Select "PMS: 1 Overview" layout
  3. Set "Date From" according to your Data or for DEMO use "2022-12-01"
  4. Set "Report Date" according to your Data or for DEMO use "2025-03-31"

To further explore your data and to learn how to use reports, start with: How to Check Balance Report and continue with further guides.

image.png

Prepare Data in Finmars Excel Format

Prerequisites

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

  1. Get Access to Finmars
  2. Link with Finmars ID
  3. Install PMS Core or PMS Plus add-on

Prepare Standard Template Files for Import

Standard Configuration supports importing from Excel files:

Currencies, Accounts, Portfolios, Instruments, Instruments Factor Schedules, Instruments Accrual Schedules, Counterparties, Responsibles, Strategies1, Transactions, Positions, Prices & FX Rates.

To import this files follow instruction: How to Import Files in PMS Core and PMS Plus

Below you can find instructions on how to fill in templates.

General Requirements:

Transactions

Deposit/Withdraw

Expense/Income (Non-instrument)

Coupon/Dividend

Expense/Other Income (Instrument)

Buy/Sell

FX Trade

Transfer Cash

Transfer Cash (In/Out)

Transfer Instrument

Transfer Instrument (In/Out)

FX Forward (Open)/FX Forward (Expiration)

Split/Reverse Split

Positions Initial/Daily

Position Cash

Daily transaction type is valid only on the trade date then position will be nullified.

Position Instrument

Daily transaction type is valid only on the trade date then position will be nullified.

Position FX Forward

Instruments

Instruments

Instruments Accrual Schedules

Instruments Factor Schedules

Prices

FX Rates

Other Entities

Currencies

Accounts

Portfolios

Counterparties

Responsibles

Strategies

Check Transaction Report

Prerequisites

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

  1. Get Access to Finmars
  2. Link with Finmars ID
  3. Install PMS Core or PMS Plus add-on
  4. How to Import Files in PMS Core and PMS Plus

Check Transaction 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.
    Снимок экрана 2025-04-02 135648.png
  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.
    Снимок экрана 2025-04-02 140342.png
  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. 
    Снимок экрана 2025-04-02 141545.png
  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.
      Снимок экрана 2025-04-02 154903.png
  5.  After adjusting these settings, confirm by clicking OK.
    Снимок экрана 2025-04-02 190428.png
  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.
    Снимок экрана 2025-04-02 190639.png
  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.
    Снимок экрана 2025-04-02 190927.png
  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.
    Снимок экрана 2025-04-02 191103.png
  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.
    Снимок экрана 2025-04-02 191213.png
  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.

Calculate YTM and Modified Duration

Prerequisites

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

  1. Get Access to Finmars
  2. Link with Finmars ID
  3. Install PMS Core or PMS Plus add-on
  4. How to Import Files in PMS Core and PMS Plus

When to use

It's expected that all calculations are run by respected workflows and or pipelines, but sometimes there is a time you need to run it manually, the most frequent cases are:

  1. You made manual edits in the data that will affect YTM and Modified Duration - this WILL NOT be automatically recalculated;
  2. You unchecked calculation options in the PMS Core/PMS Plus and/or other add-ons and/or pipelines; 

Calculate YTM and Modified Duration

  1. Go to Add-ons -> PMS here go to the Helper tab and open Calculate Price History section.

    image.png

  2. Fill in parameters according to their info ("i" icon close to the parameter's name). 
  3. Click Run.
  4. Confirm parameters and click Run again.

    image.png

  5. In the right frame you will have execution info, click Refresh to get updates.

    image.png

  6. Refresh and read Log and wait for Result. See successful run example below: 

    image.png



Check Balance Report

Prerequisites

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

  1. Get Access to Finmars
  2. Link with Finmars ID
  3. Install PMS Core or PMS Plus add-on
  4. How to Import Files in PMS Core and PMS Plus
  5. How to Do Calculations for YTM and Modified Duration (if you need YTM & Modified Duration)

Check Balance Report 

  1. Go to the left sidebar. Locate and select the Report section and click on Balance. 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.
    2025-02-07 171212.png
  2. Once on the Balance page, adjust the settings according to your reporting needs. Сonfirm the Calculation method, Pricing policy, and Currency in the top panel. Also, verify that the Report Date is set correctly. The system displays the balance as of the end of the selected day. This setting should always be used to reflect accurate financial data.
    Снимок экрана 2025-02-20 221302.png
  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. 
    Снимок экрана 2025-02-10 202249.png
  4. In detailed report settings you can set the Report Date, Currency, and Cost Method (such as AVCO or FIFO) as well.
  5. 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 used.)
    Снимок экрана 2025-02-10 202438.png
  6. Configure Portfolio Mode and Account Mode to define how data is displayed.
    1. Independent – Shows separate entries for each portfolio or account for a detailed view.
    2. Ignore – Aggregates data into a consolidated report without portfolio or account distinctions.
      For Example: If Portfolio Mode is set to Ignore, all portfolios will be merged into a single row. However, if Account Mode is set to Independent, accounts will still be displayed as separate rows.
  7.  After adjusting these settings, confirm by clicking OK.Снимок экрана 2025-02-10 202818.png
  8. 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.
    ввв.png
  9. 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.
  10. 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.
    Снимок экрана 2025-02-13 174438.png
  11. 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.
    Снимок экрана 2025-02-11 144520.png
  12. 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.
    Снимок экрана 2025-02-11 144637.png
  13. 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.

Check Profit and Loss Report

Prerequisites

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

  1. Get Access to Finmars
  2. Link with Finmars ID
  3. Install PMS Core or PMS Plus add-on
  4. Import Files in PMS Core and PMS Plus
  5. How to Do Calculations for YTM and Modified Duration (if you need YTM & Modified Duration)

Check the Profit and Loss Report

  1. Go to the left sidebar. Locate and select the Report section and click on P&L. 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.
    Снимок экрана 2025-02-12 172029.png
  2. Once on the P&L page, adjust the settings according to your reporting needs. Сonfirm the Calculation method, Pricing policy, and Currency in the top panel. Also, verify that the Report Date is set correctly.
    The system displays the balance as of the end of the selected day. This setting should always be used to reflect accurate financial data.
    For example if you want to get P&L report for Week To Date you need to select Report Date: Previous Week End -> This Week End. It means that you need to select date range FROM the END of the PREVIOUS period to the END of the CURRENT period. 
    Снимок экрана 2025-02-22 143842.png
  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. 
    Снимок экрана 2025-02-12 172457.png
  4. In detailed report settings set the Report Date, Currency, and 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.)
  5. Configure Portfolio Mode and Account Mode to define how data is displayed.
    1. Independent – Shows separate entries for each portfolio or account for a detailed view.
    2. Ignore – Aggregates data into a consolidated report without portfolio or account distinctions.
      For Example: If Portfolio Mode is set to Ignore, all portfolios will be merged into a single row. However, if Account Mode is set to Independent, accounts will still be displayed as separate rows.
  6. Click OK to apply the settings once all the necessary parameters are selected.
    Снимок экрана 2025-02-12 172715.png

  7. 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.
    Снимок экрана 2025-02-12 173011.png

  8. If the data has changed, simply refreshing the page is not enough. You need to use the Recalculate Report (Clear Cache) option, found in the three-dot menu at the top-right corner next to the export icon. If the data hasn’t changed, clearing the cache is not required.
    Снимок экрана 2025-02-22 150347.png
  9. 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.
  10. 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.
    Снимок экрана 2025-02-13 183836.png
  11. 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. 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.
    Снимок экрана 2025-02-13 184705.png
  12. 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 P&L Report. If issues persist, contact the administrator for further assistance.

Calculate Performance (Modified Dietz)

Prerequisites

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

  1. Get Access to Finmars
  2. Link with Finmars ID
  3. Install PMS Core or PMS Plus add-on
  4. How to Import Files in PMS Core and PMS Plus

When to use

It's expected that all calculations are run by respected workflows and or pipelines, but sometimes there is a time you need to run it manually, the most frequent cases are:

  1. You made manual edits in the data that will affect performance - this WILL NOT be automatically recalculated;
  2. You unchecked calculation options in the PMS Core/PMS Plus and/or other add-ons and/or pipelines; 

Calculations for Performance

  1. Go to Add-ons -> PMS here go to the Helper tab and open Calculate Register Records section.

    image.png


  2. Fill in parameters according to their info ("i" icon close to the parameter's name). 
  3. Click Run.
  4. Confirm parameters and click Run again.

    image.png

  5. In the right frame you will have execution info, click Refresh to get updates.

    image.png


  6. Refresh and read Log and wait for Result. See successful run example below: 

    image.png


Check Performance Report

Prerequisites

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

  1. Get Access to Finmars
  2. Link with Finmars ID
  3. Install PMS Core or PMS Plus add-on
  4. How to Import Files in PMS Core and PMS Plus
  5. How to Do Calculations for YTM and Modified Duration (if you need YTM & Modified Duration)
  6. How to Do Calculations for Performance (Modified Dietz)

Check Performance Report 

  1. Go to the left sidebar. Locate and select the Report section and click on Performance. 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.
    Снимок экрана 2025-02-28 162745.png
  2. Once on the Performance page, adjust the settings according to your reporting needs. Сonfirm the Currency in the top panel. Also, verify that the Report Date is set correctly. The system displays the balance as of the end of the selected day. This setting should always be used to reflect accurate financial data.
    Снимок экрана 2025-02-28 162911.png
  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. 
    Снимок экрана 2025-02-28 163009.png
    1. Set the Cost Method (such as AVCO or FIFO).
    2. 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.) 
    3. In the Performance Unit, select whether you want the report to display performance in Percent or Absolute terms.
    4. Choose the method for return calculations by selecting Modified Dietz.
    5. Set the Time grain to define the period for performance calculations, such as daily or monthly.
    6. If you need to filter the report to specific portfolios or bundles, click on the Portfolios and Bundles field and select the relevant items.
    7. In the Sections area, select the components you want to include in the report, such as:
      1. Period Returns ( Displays performance returns for different periods such as Daily, MTD, QTD, YTD, and historical years), 
      2. Monthly Returns (Breaks down performance data into monthly periods for more granular analysis.).
      3. Graphs (Enables visual representation of performance).
  4.  After adjusting these settings, confirm by clicking OK.Снимок экрана 2025-02-28 163146.png
  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.
    Снимок экрана 2025-02-28 163306.png
  6. After verifying the report, you can either save it within the system for future reference. 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.
    Снимок экрана 2025-02-28 163422.png

Calculate data for Mobile/Dashboards

Prerequisites

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

  1. Get Access to Finmars
  2. Link with Finmars ID
  3. Install PMS Core or PMS Plus add-on
  4. How to Import Files in PMS Core and PMS Plus
  5. How to Do Calculations for YTM and Modified Duration
  6. How to Do Calculations for Performance (Modified Dietz)

When to use

It's expected that all calculations are run by respected workflows and or pipelines, but sometimes there is a time you need to run it manually, the most frequent cases are:

  1. You made manual edits in the data - this WILL NOT be automatically recalculated;
  2. You unchecked calculation options in the PMS Core/PMS Plus and/or other add-ons and/or pipelines; 

Calculate data for Mobile/Dashboards

  1. Go to Add-ons -> PMS here go to the Helper tab and open Calculate Portfolio History section.

    image.png

  2. Fill in parameters according to their info ("i" icon close to the parameter's name). 
  3. Click Run.
  4. Confirm parameters and click Run again.

    image.png

  5. In the right frame you will have execution info, click Refresh to get updates.

    image.png

  6. Refresh and read Log and wait for Result. See successful run example below: 

    image.png



Check Standard Dashboards

Prerequisites

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

  1. Get Access to Finmars
  2. Link with Finmars ID
  3. Install PMS Core or PMS Plus add-on
  4. How to Import Files in PMS Core and PMS Plus
  5. How to Do Calculations for YTM and Modified Duration
  6. How to Do Calculations for Performance (Modified Dietz)
  7. Calculate data for Mobile/Dashboards

Check Standard Dashboards

  1. Go to the Dashboard tab in the left-side menu.
    Снимок экрана 2025-02-24 220143.png
  2. At the top of the page (next to the save icon), you will see the current dashboard layout name (it can differ from user settings). Click on this name to open the dropdown menu listing all available layouts.
    Снимок экрана 2025-02-24 215900.png
  3. From this dropdown, select the standard dashboard you want to check. 

    image.png

  4. Below you can find an overview of Standard Dashboard Layouts

Overview Layout

Overview – Displays a high-level summary of key financial metrics like NAV, P&L, cash flows, and balance trends

Filter Panel

At the top of the Overview layout, you'll find the filter panel where you can adjust key parameters:

  1. Portfolios – Select which portfolios to display data for.
  2. Currency – Choose the reporting currency.
  3. Date From / Report Date – Define the time period for analysis. The Report Date will always display the balance as of the end of the selected day. 
  4. Pricing Policy – Set the method for asset valuation.
    Below the filter panel, there is a summary section displaying key financial metrics: NAV YTD, P&L YTD, Return YTD, Cash Inflow/Outflow YTD

Cards

Cards values are based on calculated Portfolio History for selected parameters in Filter Panel. 

Balance by Category

Displays a bar chart of the portfolio's asset balances by account. 

111.png

You can change the category of data displayed in the chart by clicking on the dropdown menu next to the window title. Select the desired option (e.g., Currencies, Instrument Types, Portfolios, Accounts, Countries) depending on how you want the data to be shown.
Снимок экрана 2025-04-10 014945.png

Elements:

The chart always displays up to six values. If there are more than six positions, the chart will show the top five values, and the sixth value will be labeled "Other", which aggregates all remaining positions beyond the first five.

The X-axis always represents numerical values, typically amounts or prices, while the Y-axis represents elements.

P&L by Category

 Displays a bar chart showing the profit and loss distribution across different accounts.
Снимок экрана 2025-03-12 125612.png

You can change the category of data displayed in the chart by clicking on the dropdown menu next to the window title. Select the desired option (e.g., Currencies, Instrument Types, Portfolios, Accounts, Countries) depending on how you want the data to be shown.

Снимок экрана 2025-04-10 015524.png

Elements:

The chart always displays up to six values. If there are more than six positions, the chart will show the top five values, and the sixth value will be labeled "Other", which aggregates all remaining positions beyond the first five.

The X-axis always represents numerical values, typically amounts or prices, while the Y-axis represents elements.

Balance History by Category

This section visualizes the historical changes in asset balances over time. The chart helps track trends in portfolio values, showing fluctuations across different accounts.

Снимок экрана 2025-03-12 152155.png

Elements:

  1. Time Axis (X-Axis) – Displays a timeline, illustrating changes in balances over time.
  2. Value Axis (Y-Axis) – Represents balance amounts, showing increases or decreases across different accounts.
  3. Colored Lines – Each account has a unique color, distinguishing different balance trends.
  4. Solid and Dotted Lines – Solid lines represent total balances or major accounts, while dotted lines indicate smaller accounts.
  5. Legend – Located at the bottom, mapping each color to its corresponding account.
  6. Trend Patterns – Some accounts show gradual changes, while others exhibit sharp declines, indicating significant balance shifts.

You can change the category of data displayed in the chart by clicking on the dropdown menu next to the window title.

Снимок экрана 2025-04-10 020109.png

You can select category for a graph.

Снимок экрана 2025-04-10 020123.png

Chart Type Options:

  1. Column Chart – Displays historical balances as bar charts.

    image.png

  2. Line Chart (default) – Shows trends over time with connected data points.

    image.png

  3. Table – Converts the visual chart into a tabular format for numerical analysis.

    image.png

Download Options:

  1. Download PNG – Saves the chart as an image file.
  2. Download CSV – Exports balance history data as a CSV file for further analysis.

P&L History by Category

This module visualizes the historical changes in profit and loss (P&L) over time, allowing users to track financial performance trends across different accounts.

Снимок экрана 2025-03-12 152949.png

Elements:

  1. Time Axis (X-Axis) – Displays a timeline, illustrating changes in profit and loss over time.
  2. Value Axis (Y-Axis) – Represents profit and loss values, indicating financial performance across different accounts.
  3. Colored Lines – Each account is assigned a distinct color to differentiate financial trends.
  4. Solid and Dotted Lines – Solid lines represent total P&L movements, while dotted lines indicate individual accounts.
  5. Legend – Located at the bottom, linking each color to its corresponding account.
  6. Trend Patterns – Some accounts show steady performance, while others display sharp fluctuations, highlighting significant changes in financial results.

You can change the category of data displayed in the chart by clicking on the dropdown menu next to the window title.

Снимок экрана 2025-04-10 015707.png

You can select category for a graph.

Снимок экрана 2025-04-10 015932.png

Chart Type Options:

  1. Column Chart – Represents P&L data using vertical bars.

    image.png

  2. Line Chart (default) – Shows P&L trends over time using connected data points.

    image.png

  3. Table – Converts the graph into a tabular format for numerical analysis.

    image.png

Download Options:

  1. Download PNG – Saves the chart as an image file for reporting purposes.
  2. Download CSV – Exports the P&L history in a CSV format for further analysis in spreadsheets.

Top Positions

Displays the largest holdings based on their total position value, ranked from highest to lowest.

image.png

  1. Name – The name of the financial instrument.
  2. Position – The number of units held.
  3. Total – The total market value of the position.

Worst Positions

Displays the worst-performing positions sorted by total value (from lowest to highest).

image.png

  1. Name – The name of the financial instrument.
  2. Position – The number of units held.
  3. Total – The total market value of the position, often displayed in red to indicate negative performance.

Balance Sheet (BS) Layout

The Balance Sheet (BS) layout provides an overview of asset distribution by different categories, such as countries, accounts, or asset types.

Filter Panel

At the top of the BS layout, the filter panel allows for the adjustment of key parameters:

  1. Portfolios – Select which portfolios to analyze.
  2. Currency – Choose the reporting currency.
  3. Report Date – will always display the balance as of the end of the selected day.
  4. Pricing Policy – Determines the valuation method for instruments.

Matrix

This section represents a Matrix Table where data is organized by category. This table is structured to analyze the distribution of value indicators  across different regions.

image.png

Matrix Component Editor

To customize the BS matrix, users can access the Matrix Component Editor by clicking on the settings  icon in the top-right corner. The editor allows modifications to the data structure.

Снимок экрана 2025-03-12 222155.png

Customization Options:

  1. Main Tab
    1. Chart Label
    2. Column (X-Axis) – Defines default grouping criteria.
    3. Category (Y-Axis) – Selects default secondary grouping level.
    4. Values – Defines the key metric displayed in the table.
    5. Calculation Method – determines how the selected Value field (such as market value, exposure, or return) is calculated and displayed in the report. It defines whether the data will be shown as a simple sum, a weighted result based on the asset’s share in the portfolio, or as an average. For each method, there is also a corresponding percentage-based calculation, which expresses the result as a proportion of the total portfolio (e.g., total value or total exposure).
      1. Sum – a simple total of the selected value (e.g., market value or exposure), without considering weights.
      2. Weighted Market Value / Weighted Exposure – calculates the selected value (e.g., market value or exposure) multiplied by its weight (Market Value/Exposure).
      3. Weighted Market Value Percent / Weighted Exposure Percent – same as the weighted, but the result is expressed as a percentage of the resulting total value.
      4. Weighted Average Market Value / Weighted Average Exposure – the selected value weighted average (Market Value/Exposure fraction of their total).
      5. Weighted Average Market Value Percent / Weighted Average Exposure Percent – same as the weighted average, but the result is expressed as a percentage of the resulting total value.
  2. Advanced Settings Tab

    1. Empty Data Handling – allows hiding empty columns, rows, or both to optimize matrix display.

    2. Cell Text Alignment – supports alignment options such as right, center, and left.

    3. Scale Matrix – ensures the matrix adjusts proportionally to fit the available space.

    4. Auto Width for Name Column – automatically adjusts the width of the column containing names for better readability.

image.png

Balance Report

Linked to Matrix, if you click on matrix cell it will show related Balance Items. Details on use see in How to Check Balance Report.

Снимок экрана 2025-04-01 182917.png

Linked Filters:

  1. Portfolio Short Name – filters results by specific portfolio identifiers.

  2. Exposure CCY – limits data to a particular exposure currency.

  3. Country – shows results only for selected countries.

  4. Asset Type – restricts the view to specific asset categories, such as "Cash & Equivalents."

  5. Account Short Name – filters data by account identifiers.

Transaction Report

Linked to Balance Report, if you click on Balance Item it will show related Transactions. Details on use see in How To Check Transaction Report.

Снимок экрана 2025-04-01 183135.png

Linked Filters:

  1. Portfolio User Code – filters transactions by specific portfolio identifiers.

  2. Transaction Entry Item User Code – limits data to specific transaction entry items.

  3. Transaction Entry Account – filters transactions based on specific accounts.

Profit & Loss (P&S) Layout

The P&L layout provides an overview of financial performance across different regions

Filter Panel

At the top of the P&L layout, you'll find the filter panel where you can adjust key parameters:

  1. Portfolios – Select which portfolios to analyze.
  2. Currency – Choose the reporting currency.
  3. Date From / Report Date – Define the time period for analysis. The Report Date will always display the balance as of the end of the selected day.
  4. Pricing Policy – Determines the valuation method for instruments.

Matrix

This section represents a P&L Matrix where data is presented by categories. The matrix is structured to provide a clear view of profit and loss results across different regions and financial instruments.

image.png

Matrix Component Editor (P&L)

To customize the P&L matrix, click the settings icon in the top-right corner. This editor allows modifications to the displayed data.

Снимок экрана 2025-03-12 223408.png

Customization Options:

  1. Main Tab
    1. Column (X-Axis) – Groups data by Asset Type, Country, Account, Portfolio, or PL Group.
    2. Category (Y-Axis) – Secondary grouping by Country, CCY, Account, Asset Type, or Portfolio.
    3. Values – Displays PnL Total (profit and loss) or MV (Market Value).
    4. Calculation Method – determines how the selected Value field (such as market value, exposure, or return) is calculated and displayed in the report. It defines whether the data will be shown as a simple sum, a weighted result based on the asset’s share in the portfolio, or as an average. For each method, there is also a corresponding percentage-based calculation, which expresses the result as a proportion of the total portfolio (e.g., total value or total exposure).
      1. Sum – a simple total of the selected value (e.g., market value or exposure), without considering weights.
      2. Weighted Market Value / Weighted Exposure – calculates the selected value (e.g., market value or exposure) multiplied by its weight (Market Value/Exposure).
      3. Weighted Market Value Percent / Weighted Exposure Percent – same as the weighted, but the result is expressed as a percentage of the resulting total value.
      4. Weighted Average Market Value / Weighted Average Exposure – the selected value weighted average (Market Value/Exposure fraction of their total).
      5. Weighted Average Market Value Percent / Weighted Average Exposure Percent – same as the weighted average, but the result is expressed as a percentage of the resulting total value.
  2. Advanced Settings Tab

    1. Empty Data Handling – allows hiding empty columns, rows, or both to optimize matrix display.

    2. Cell Text Alignment – supports alignment options such as right, center, and left.

    3. Scale Matrix – ensures the matrix adjusts proportionally to fit the available space.

    4. Auto Width for Name Column – automatically adjusts the width of the column containing names for better readability.

image.png

P&L Report

Linked to Matrix, if you click on a P&L Item, it will show related P&L items. For usage details, refer to How to Check Profit and Loss Report.

Снимок экрана 2025-04-01 182119.png

Linked Filters:

  1. Country – Filters results based on the selected country.

  2. Asset Type – Restricts the view to specific asset categories.

  3. PL Type – Filters data by profit and loss type.

  4. Portfolio Short Name – Filters results by specific portfolio identifiers.

  5. Account Short Name – Limits the view to transactions within a selected account.

  6. Balance Pricing Currency – Displays P&L details in the selected pricing currency.

  7. Instrument Type – Filters results by specific instrument categories.

P&L Transactions Report 

Linked to P&L Report, if you click on a P&L item, it will show related transactions.

Снимок экрана 2025-04-01 182142.png

Linked Filters:

  1. Portfolio User Code – Filters transactions by specific portfolio identifiers.

  2. Transaction Entry Item User Code – Limits data to specific transaction entry items.

  3. Transaction Entry Account Position User Code – Filters transactions based on specific account positions.

Maturity Layout

Maturity layout provides insights into financial instruments based on their maturity dates.

Filter Panel

At the top of the Maturity layout, you'll find the filter panel where you can adjust key parameters:

    1. Portfolios – Select which portfolios to analyze.
    2. Currency – Choose the reporting currency.
    3. Report Date – will always display the balance as of the end of the selected day.
    4. Pricing Policy – Determines the valuation method for instruments.
    5. Upper Section – Displays instruments sorted by maturity, including days to maturity, date, type, market value, price, position, and FX rate.
    6. Lower Section – Similar to the upper table but filtered by portfolio.

image.png

Configuration Helper Layout

The Configuration Helper layout provides various system tools for managing workflows, performing calculations, importing/exporting data, and running analytics.

General Tab

The Configuration Helper layout contains sections with workflows. Each workflow includes a description and tooltips for fields. Below is an overview of its sections:

image.png

STD Manual Import Layout

The STD Manual Import layout provides a structured interface for manually uploading key financial data files into the system.

See How to Import Files in PMS Core and PMS Plus

image.png

      Use Mobile App [TO BE UPDATED]

      Prerequisites

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

      1. Get Access to Finmars
      2. Link with Finmars ID
      3. Install PMS Core or PMS Plus add-on
      4. How to Import Files in PMS Core and PMS Plus
      5. How to Do Calculations for YTM and Modified Duration
      6. How to Do Calculations for Performance (Modified Dietz)
      7. Calculate data for Mobile/Dashboards

      Use Mobile App

      Step 1. Download the Finmars App. The Finmars app is available on both the Google Play Store (for Android) and the App Store (for iOS). Download and install the app on your mobile device.

      To use the app, you need to have an account on EU Central. You can sign up or log in at  Central Finmars.

      image.png

      Step 2. Once you have an account, open the Finmars app, and you will see a "Welcome to Finmars" screen. Make sure to select "Europe (eu-central)" as your region. Then, tap the "LOGIN" button to proceed.
      Снимок экрана 2025-03-24 152911.png

      Step 3. After selecting the region, you will be redirected to the login page. Enter the Username and Password you used during registration. (Optional) Check "Remember me" if you want to stay logged in. Click the "LOGIN TO YOUR ACCOUNT" button to proceed.

      image.png

      Step 4. After logging in, you will be redirected to the space selection page. Here, you will see a list of spaces that you have created in your workspace. Select the desired space from the list and click the "Start" button to proceed.

      image.png

      Step 5. After successfully logging in and selecting your workspace, you will be directed to the Balance tab. This is the main dashboard where you can view an overview of your investment portfolio and its distribution across different asset classes.

      Main Page

      After registering in Finmars, you will land on the main page, where you can find key information about your investment portfolio.

      image.png

      1. In the top-right corner, you can adjust the report settings:

        1. Report Date – Select the date for which you want to view data.

        2. Currency – Choose the currency in which data will be displayed (USD, EUR, etc.).

        3. Time Range Options:

          1. YTD – Year-to-date

          2. MTD – Month-to-date

          3. QTD – Quarter-to-date

          4. Daily – Current day

          5. All time – Entire history

          6. Custom – Set your own period

      2. "Total" Section-displays the total value of all your assets.
      3. "Portfolios" Section-lists all your active portfolios along with their current value.
      4. "Worst Performers" Section-highlights the investments that have performed the worst over the selected period. Each position includes:

        1. Asset name (e.g., Pinduoduo Inc, Palladium USD, etc.)

        2. Current loss (negative value)

        3. Position size (e.g., 7,500 shares)

        4. Depository or account type

        5. Unique position identifier

      image.png

      1.  "Best Performers" Section. This section showcases the assets that have generated the highest returns.

        1. Asset name

        2. Current profit (positive value)

        3. Position size

        4. Depository or account type

        5. Unique position identifier

      image.png

      Settings Menu

      The Settings menu, accessible via the gear icon in the top-left corner, allows users to customize their reporting preferences and portfolio settings.

      image.png

      1. Date Selection- choose a specific date for generating financial reports.
      2. Period Type- select reporting periods such as YTD (Year-to-Date), MTD (Month-to-Date), QTD (Quarter-to-Date), Daily or All-Time.
      3. Pricing policy- define how asset pricing is calculated (Master or other policies).
      4. Reporting Currency- set the preferred currency for displaying portfolio values (USD, EUR, etc.).
      5. Portfolio & Accounts Management:

        1. View and manage multiple portfolios and accounts in one place.

        2. Option to consolidate accounts for an aggregated financial view.

      6. Additional Settings- more customization options available via the “More” button.
      The Balance Tab

      image.png

      The Balance tab consists of the following sections:

      1. Net Asset Value (NAV)- provides a summary of your total portfolio value, which can be displayed in USD or other available currencies.
        1. You can adjust the currency, the reporting date, and the reporting period using the options in the top-right corner of the screen.
        2. If you see "No Data," this means that you haven't yet completed the required calculations. To enable data display, complete the calculation process as described in:
          1.  How to Do Calculations for Performance (Modified Dietz)
          2. How to Do Calculations for Mobile
      2. Instrument Type Breakdown- categorizes your portfolio into different investment types:
        1. Cash & Equivalents – Liquid assets such as cash or money market funds.
        2.  Bonds – Fixed-income securities.
        3.  Stocks – Equities or shares in companies.
        4. Other – Any additional investment instruments.
      3. If you scroll down within the Balance tab, you will see a more detailed breakdown of your holdings. This includes:
        1.  Individual asset values Account details, such as account numbers or holding depositories
        2. Owner information (if applicable) Each listed entry represents a specific holding, showing its value and where it is stored. 

      image.png

      The P&L Tab

      image.png

      After you can navigate to the P&L (Profit & Loss) tab using the bottom navigation bar. This section provides insights into your portfolio's performance over a selected period.

      1. Portfolio Overview- displays a list of portfolios along with their respective Profit & Loss values.
      2. Metrics Section- shows key performance indicators for the selected date.

      At the top of the screen, you can modify:

      1. Date of the report – Adjust to a different reporting period.

      2. Currency – Change the display currency (e.g., USD, EUR, etc.).

      3. Performance period – Adjust the timeframe (e.g., YTD - Year to Date).

      Transactions Tab

      image.png

      The Transactions tab in Finmars provides a detailed history of all financial activities within your investment portfolios. This section helps you track every expense, income, dividend, or trade in a structured format.

      At the top of the screen, you will find a search bar that allows you to filter transactions based on keywords such as:

      1. Asset name (e.g., "Tesla Model S", "PINDUODUO INC")

      2. Transaction type (e.g., "Dividend", "Buy", "Expense")

      3. Portfolio or account numbers

      Transaction Type:

      1. E (Blue) – Expense (e.g., fees, withdrawals, asset depreciation)

      2. O (Orange) – Other Income (e.g., interest payments, refunds)

      3. D (Green) – Dividend (profit distribution from stocks)

      4. B (Brown) – Buy (purchase of an asset)

       Detailed Transaction Information:

      1. Instrument (Asset Name) – The name of the stock, bond, or other financial instrument (e.g., "Tesla Model S", "PINDUODUO INC (ADR)").

      2. Amount – The transaction amount, including the currency (e.g., -1,340.00 EUR, 13.00 USD).

      3. Portfolio & Account Number – The unique identifiers for the portfolio and account associated with the transaction.

      4. Date – The date the transaction was executed (e.g., "2023-06-08").

      Search Tab

      image.png

      The Search tab in Finmars allows users to quickly find specific assets, transactions, or reports across their portfolios. This feature provides an efficient way to navigate large datasets and locate relevant financial details.

      Duplicate the Layout

      Prerequisites

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

      1. Get Access to Finmars
      2. Link with Finmars ID

      Duplicate the Layout

      1. Go to the layout list. Click on the layout name to open the dropdown menu. Choose the layout you want to duplicate (for example, Profit and Loss).
        Снимок экрана 2025-03-04 061527.png
      2. In the dropdown menu, select "Make a Copy" to create a duplicate of the selected layout.
        Снимок экрана 2025-03-04 061756.png
      3. To confirm that the copy was successfully created, check the selected layout name at the top. It should indicate that it is a copy (e.g., Profit and Loss_copy).
        Снимок экрана 2025-03-04 062415.png
      4.  After copying, you can Rename the new layout for clarity and organization. Click on the Rename option.
        Снимок экрана 2025-03-04 061909.png
      5. A dialog box will appear where you can enter any desired name for the copied layout. Also, you can change configuration and user code.Снимок экрана 2025-03-13 123409.png
      6. After choosing a new name, click Save to confirm the changes.
        Снимок экрана 2025-03-13 123717.png

      Get License for add-on [TO BE UPDATED]

      Prerequisites

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

      1. Get Access to Finmars
      2. You have the internet access

      Getting License for add-ons

      1. As of now contact sales@finmars.com