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

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

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.
  

You can select category for a graph

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.

You can select category for a graph

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.

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 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.

Profit & Loss 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.
   

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:
   
   1. Zero Formatting: Defines how zero values appear (as "0", "-", or blank).
   2. Negative Formatting: Determines how negative numbers are displayed (e.g., with a minus sign or in parentheses).
   3. Rounding: Sets the number of decimal places shown.
   4. Thousands Separator: Chooses how large numbers are formatted (e.g., using an apostrophe, space, or no separator).
   5. Percentage: Decides if numbers should be displayed as percentages and in what format.
   6. Suffix & Prefix: Allows adding custom text before or after numbers (e.g., currency symbols).
   7. Multiplier: Adjusts the scale of numbers (e.g., displaying in thousands or millions).

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. 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.

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:

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 Data into a Workspace via Dashboard (STD Manual Import)