How to Check Standard Dashboards

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 Standard Dashboards

1. Go to the Dashboard tab in the left-side menu.
   
   
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.
   
3. From this dropdown, select the standard dashboard you want to check. 
   

   

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

LayoutFilter OverviewPanel

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

Balance by category 

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

Categories: 

1. Currencies – Groups balances by currency.
2. Instrument Types – Categorizes balances by financial instrument type (e.g., bonds, equities).
3. Portfolios – Displays balances for different investment portfolios.
4. Accounts – Shows balances at the individual account level (default setting).
5. Countries – Groups balances by geographical region.
   

P&L by Accounts – Displays a bar chart showing the profit and loss distribution across different accounts.

Categories: 

1. PL Types – Filters P&L by different types of profit/loss (e.g., realized, unrealized).
2. Currencies – Groups P&L by currency.
3. Instrument Types – Categorizes P&L by financial instrument type (e.g., bonds, equities).
4. Portfolios – Displays P&L for different investment portfolios.
5. Accounts – Shows P&L at the individual account level (default setting).
6. Countries – Groups P&L data by geographical region.

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

Categories:You can select category for a graph

1. Currencies – Displays historical balance movements grouped by currency.
2. Instrument Types – Shows changes in balances based on financial instrument types (e.g., bonds, equities).
3. Portfolios – Allows users to filter balance history by portfolio.
4. Accounts – Default view displaying individual account balances over time.
5. Countries – Organizes historical balances by geographical region.
   

Chart Type Options:

1. Column Chart – Displays historical balances as bar charts.
2. Line Chart (default) – Shows trends over time with connected data points.
3. Table – Converts the visual chart into a tabular format for numerical analysis.

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 Accounts – This module visualizes the historical changes in profit and loss (P&L) over time, allowing users to track financial performance trends across different accounts.

Categories:You can select category for a graph

1. Currencies – Groups profit and loss data by currency.
2. Instrument Types – Organizes P&L trends based on different financial instruments (e.g., stocks, bonds).
3. Portfolios – Displays profit and loss trends per portfolio.
4. Accounts – Default setting, showing historical P&L data at the account level.
5. Countries – Groups profit and loss information based on geographical regions.
   

Chart Type Options:

1. Column Chart – Represents P&L data using vertical bars.
2. Line Chart (default) – Shows P&L trends over time using connected data points.
3. Table – Converts the graph into a tabular format for numerical analysis.

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 – Lists the best-performing holdings by total value.

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 weakest-performing assets, highlighting losses.

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.

LayoutFilter OverviewPanel

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. -> Need to change in future for Periods like YTD, MTD etc
4. Pricing Policy – Determines the valuation method for instruments.

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.

Customization Options:

1. Column (X-Axis) – Defines the grouping criteria (e.g., Asset Type, Country).
2. Category (Y-Axis) – Selects the secondary grouping level (e.g., Country, CCY).
3. Values – Defines the key metric displayed in the table (e.g., Market Value - MV).
4. Calculation Method – Determines how values are calculated:
   1. Sum – Aggregates total values.
   2. Weighted Market Value – Adjusts MV based on weighting.
   3. Weighted Market Value Percent – Displays MV as a percentage.
   4. Weighted Exposure – Adjusts exposure levels.
   5. Weighted Exposure Percent – Displays exposure as a percentage.
5. Format Settings

Profit & Loss Layout

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

LayoutFilter OverviewPanel

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. -> Need to change in future for Periods like YTD, MTD etc
   
4. Pricing Policy – Determines the valuation method for instruments.
   

The main P&L table presents financial performance per region:

1. PnL Total – Displays total profit or loss per region.
2. FX Variations – Reflects changes due to currency fluctuations.
3. FX Trades – Captures executed foreign exchange transactions.
4. Total – Summarizes the overall P&L per region

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.

Customization Options:

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 – Defines how values are calculated:
   1. Sum – Total aggregation.
   2. Weighted Market Value – Adjusts MV by weighting.
   3. Weighted Market Value Percent – MV as a percentage.
   4. Weighted Exposure – Adjusted exposure levels.
5. Format Settings

Maturity Layout

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

LayoutFilter OverviewPanel

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

1. 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. -> Need to change in future for Periods like YTD, MTD etc
      
   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.

Configuration Helper Layout

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

LayoutGeneral OverviewTab

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

1. Workflow v2 – Contains options for managing workflow templates.
   1. Transfer Workflow Templates
   2. Delete Workflow Templates
      
2. Import & Download – Facilitates importing and downloading various types of financial data.
   1. Import Instruments from FinmarsDB
   2. Import Prices from FinmarsDB 
   3. Download Prices
   4. Download FX Rates 
      
3. Finmars Analytics – Provides tools for analyzing imports and checking data completeness.
   1. Finmars Import Task IDs Analysis
   2. Finmars Price FX-Rate Completeness Report 
      
4. Calculations – Performs various financial calculations.
   1. Calculate Register Records
   2. Calculate Portfolio Price History
   3. Calculate Portfolio History 
5. Bloomberg – Integrates with Bloomberg API for data retrieval.
   1. Download Instrument Data
   2. Download Prices 
6. CleanUp – Allows deletion of different types of data from the workspace.
   
7. Roll – Handles rolling forward pricing and FX rate data.
   1. Collect FX Rate 
   2. Roll FX Rate 
   3. Collect Price
   4. Roll Price 

STD Manual Import Layout

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

Layout Overview

Below is an description of its sections:

1. Workflow Selection – Defines the import process to be used. The dropdown allows selecting different predefined import pipelines. See How to Import Data into a Workspace via Dashboard (STD Manual Import)
2. Download Documentation – Provides a reference guide for file format requirements and upload instructions.
3. File Upload Fields – Users can manually upload different data files.

After selecting the layout, verify once again that the information displayed is correct and accurately reflects the current data status. If any discrepancies occur, refresh the data and layout by clicking the Refresh button in the top-right corner to ensure you're viewing the latest information.