# User Quick Start

# Get Access to Finmars

## Prerequisites

<span style="white-space: pre-wrap;">No specific prerequisites are needed. </span>

## Getting Access to Finmars

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

1. [Community Edition (simple)](https://docs.finmars.com/books/installation-guide-with-aws-simple)
2. [Community Edition (advanced)](https://docs.finmars.com/books/installation-guide-with-aws-advanced)
3. [Cloud or Enterprise](https://docs.finmars.com/shelves/cloudenterprise-get-access "Cloud or Enterprise")

# Link with Finmars ID

## Prerequisites

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

1. [Get Access to Finmars](https://docs.finmars.com/books/user-quick-start/page/get-access-to-finmars)
2. You have the internet access

# Linking with Finmars ID

****Step 1:**** Go to marketplace

[![image.png](https://docs.finmars.com/uploads/images/gallery/2025-08/scaled-1680-/9Azimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-08/9Azimage.png)

****Step 2:****<span style="white-space: pre-wrap;"> Click on "Link with Finmars ID" button</span>

[![image.png](https://docs.finmars.com/uploads/images/gallery/2025-08/scaled-1680-/kyjimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-08/kyjimage.png)

****Step 3:****<span style="white-space: pre-wrap;"> 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. </span>

[![image.png](https://docs.finmars.com/uploads/images/gallery/2025-08/scaled-1680-/ECRimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-08/ECRimage.png)

****Step 4:****<span style="white-space: pre-wrap;"> 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. </span>

[![image.png](https://docs.finmars.com/uploads/images/gallery/2025-08/scaled-1680-/BScimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-08/BScimage.png)

****Step 5:****<span style="white-space: pre-wrap;"> Additionally you will have your License key added to the Default settings which will be used to unlock paid modules in the marketplace</span>

[![image.png](https://docs.finmars.com/uploads/images/gallery/2025-08/scaled-1680-/JLoimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-08/JLoimage.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](https://docs.finmars.com/books/user-quick-start/page/get-access-to-finmars)
2. [Link with Finmars ID](https://docs.finmars.com/books/user-quick-start/page/link-with-finmars-id "https://docs.finmars.com/books/user-quick-start/page/link-with-finmars-id")
3. You have the internet access

## About PMS Core and PMS Plus add-ons

<span style="white-space: pre-wrap;">The </span>****Portfolio Management Solution (PMS)****<span style="white-space: pre-wrap;"> is a core Finmars add-on that enables asset managers, investors, and partners to manage, track, and analyze portfolios in one place.</span>

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.

<u>****For whom?****</u>

- ****Asset Managers**** <span style="white-space: pre-wrap;">finding insights for their portfolios </span>
- ****Investors**** having control over their assets
- ****Partners****<span style="white-space: pre-wrap;"> developing and providing their solutions</span>

<u>****What's Inside?****</u>

- ****Fully functional**** <span style="white-space: pre-wrap;">and </span>****Developer friendly FREE Version**** <span style="white-space: pre-wrap;">with </span>****Paid Advanced options****
- ****Configurable reports**** <span style="white-space: pre-wrap;">Dashboards, Performance, PnL, Balance with </span>****drill down into Transactions****
- •****Comprehensive Layouts****<span style="white-space: pre-wrap;"> for dashboards, reports and data view</span>
- ****Smart Import data via Excel**** in Standard Format
- <span style="white-space: pre-wrap;">Helper functions to </span>****analyze gaps in valuation data****<span style="white-space: pre-wrap;"> and more</span>
- Standard ****Transaction**** and ****Instrument Types**** support
- <span style="white-space: pre-wrap;">Extensive </span>****Python Functions**** for developers

<span style="white-space: pre-wrap;">For more technical details see: </span>[PMS Core and Plus](https://docs.finmars.com/books/pms-core-and-plus "https://docs.finmars.com/books/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](https://docs.finmars.com/uploads/images/gallery/2025-08/scaled-1680-/uPNimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-08/uPNimage.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****](https://docs.finmars.com/books/pms-core-and-plus "PMS Core and Plus") - Fully functional and Developer friendly FREE version which is subset of [****PMS Plus****](https://docs.finmars.com/books/pms-core-and-plus "PMS Core and Plus")

[![image.png](https://docs.finmars.com/uploads/images/gallery/2025-08/scaled-1680-/G7Cimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-08/G7Cimage.png)

<span style="white-space: pre-wrap;">By clicking </span>****Install****<span style="white-space: pre-wrap;"> you will get the latest version of the PMS Core add-on. For details on the installation process follow </span>[How to Install/Update add-on from Marketplace](https://docs.finmars.com/books/configurator-quick-start/page/how-to-installupdate-add-on-from-marketplace).

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

[![image.png](https://docs.finmars.com/uploads/images/gallery/2025-08/scaled-1680-/4ydimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-08/4ydimage.png)

[![image.png](https://docs.finmars.com/uploads/images/gallery/2025-08/scaled-1680-/HxJimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-08/HxJimage.png)

<span style="white-space: pre-wrap;">After the installation finished refresh the page and you can go to the sidebar menu </span>****Add-ons****<span style="white-space: pre-wrap;"> and see the "</span>****PMS****<span style="white-space: pre-wrap;">" appeared in there. </span>

[![image.png](https://docs.finmars.com/uploads/images/gallery/2025-08/scaled-1680-/3noimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-08/3noimage.png)

## Installing PMS Plus add-on

<span style="white-space: pre-wrap;">PMS Plus add-on </span>****requires access by your license****<span style="white-space: pre-wrap;"> for installation. Without it for paid add-ons you will see "License Required" button instead of the active "Install" button. To obtain license: </span>[Get License for add-on](https://docs.finmars.com/books/user-quick-start/page/get-license-for-add-on-to-be-updated "https://docs.finmars.com/books/user-quick-start/page/get-license-for-add-on")<span style="white-space: pre-wrap;">. </span>

[![image.png](https://docs.finmars.com/uploads/images/gallery/2025-08/scaled-1680-/oltimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-08/oltimage.png)

<span style="white-space: pre-wrap;">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. </span>

[![image.png](https://docs.finmars.com/uploads/images/gallery/2025-08/scaled-1680-/mTkimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-08/mTkimage.png)

[![image.png](https://docs.finmars.com/uploads/images/gallery/2025-08/scaled-1680-/22Pimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-08/22Pimage.png)

[![image.png](https://docs.finmars.com/uploads/images/gallery/2025-08/scaled-1680-/IwQimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-08/IwQimage.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](https://docs.finmars.com/books/user-quick-start/page/get-access-to-finmars)
2. [Link with Finmars ID](https://docs.finmars.com/books/user-quick-start/page/link-with-finmars-id "https://docs.finmars.com/books/user-quick-start/page/link-with-finmars-id")
3. [Install PMS Core or PMS Plus add-on](https://docs.finmars.com/books/user-quick-start/page/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 &gt;** **PMS.

[![image.png](https://docs.finmars.com/uploads/images/gallery/2025-08/scaled-1680-/t0Rimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-08/t0Rimage.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](https://docs.finmars.com/uploads/images/gallery/2025-08/scaled-1680-/hH6image.png)](https://docs.finmars.com/uploads/images/gallery/2025-08/hH6image.png)

[![image.png](https://docs.finmars.com/uploads/images/gallery/2025-08/scaled-1680-/IOqimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-08/IOqimage.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](https://docs.finmars.com/uploads/images/gallery/2025-08/scaled-1680-/KtVimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-08/KtVimage.png)

*PMS Plus version*

[![image.png](https://docs.finmars.com/uploads/images/gallery/2025-08/scaled-1680-/OyVimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-08/OyVimage.png)

*PMS Core version (marked differences)*

<details id="bkmrk-overview-of-the-elem"><summary>Overview of the elements on the Excel Import tab</summary>

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.

</details>**Step 4:** To import Excel files you need to:

- [Prepare Your Data in Finmars Excel Format](https://docs.finmars.com/books/user-quick-start/page/prepare-data-in-finmars-excel-format)
- or use DEMO data from "Download Excel Examples" button -&gt; "Excel Import Templates and Excel Demo Data.zip" archive -&gt; "excel\_demo\_data"

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](https://docs.finmars.com/uploads/images/gallery/2025-08/scaled-1680-/i8Gimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-08/i8Gimage.png)

[![image.png](https://docs.finmars.com/uploads/images/gallery/2025-08/scaled-1680-/yQOimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-08/yQOimage.png)

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

- *Parse Simple Entities* - if you didn't create/provided in files simple entities like currencies, accounts, ..., Responsibles, they will be created from provided data with user codes as names.
- *Parse Instruments* - if you didn't create/provided in files it will try to import data from FinmarsDB (not implemented as of 2025-08-20) or will create a Dummy instrument that you can edit later.
- *Calculate Metrics* - will run calculations for reports and dashboards based on the files you provided, you can override calculation setting in "*Advanced Settings"* section.

**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](https://docs.finmars.com/uploads/images/gallery/2025-08/scaled-1680-/UCFimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-08/UCFimage.png)

[![image.png](https://docs.finmars.com/uploads/images/gallery/2025-08/scaled-1680-/18Bimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-08/18Bimage.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](https://docs.finmars.com/uploads/images/gallery/2025-08/scaled-1680-/hWnimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-08/hWnimage.png)

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

[![image.png](https://docs.finmars.com/uploads/images/gallery/2025-08/scaled-1680-/qUPimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-08/qUPimage.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.**

<details id="bkmrk-expected-steps-in-lo"><summary>Expected Steps in Log</summary>

1. <div><div>parse_import_currencies</div></div>
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

</details>[![image.png](https://docs.finmars.com/uploads/images/gallery/2025-08/scaled-1680-/Klsimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-08/Klsimage.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](https://docs.finmars.com/books/user-quick-start/page/check-balance-report) and continue with further guides.

[![image.png](https://docs.finmars.com/uploads/images/gallery/2025-08/scaled-1680-/u0dimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-08/u0dimage.png)

# Prepare Data in Finmars Excel Format

## Prerequisites

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

1. [Get Access to Finmars](https://docs.finmars.com/books/user-quick-start/page/get-access-to-finmars)
2. [Link with Finmars ID](https://docs.finmars.com/books/user-quick-start/page/link-with-finmars-id "https://docs.finmars.com/books/user-quick-start/page/link-with-finmars-id")
3. [Install PMS Core or PMS Plus add-on](https://docs.finmars.com/books/user-quick-start/page/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** &amp; **FX Rates**.

To import this files follow instruction: [How to Import Files in PMS Core and PMS Plus](https://docs.finmars.com/books/user-quick-start/page/import-files-in-pms-core-and-pms-plus "How to Import Files in PMS Core and PMS Plus")

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

**General Requirements**:

- <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="345"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Files **MUST** be of "**.xlsx**" extension
- <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="345"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Files **MUST** be structured in accordance with templates (same columns and formatting).

### Transactions<button aria-hidden="false" aria-label="Copy link to heading" class="cc-1r0b9w7" data-testid="anchor-button" tabindex="-1" type="button"></button>

- To book a transaction in the system you can import it from a file.
- One transaction is one row of data in the file.
- You should enter a transaction in the file for import in accordance with the instructions below for supported standard transaction/position types.
- Supported **Standard transaction types** list (case-sensitive): 
    - **Transactions**
        
        
        - `Deposit`
        - `Withdraw`
        - `Expense (Non-instrument)`
        - `Income (Non-instrument)`
        - `Coupon`
        - `Dividend`
        - `Expense (Instrument)`
        - `Other Income (Instrument)`
        - `Buy`
        - `Sell`
        - `FX Trade`
        - `FX Forward (Open)`
        - `FX Forward (Expiration)`
        - `Transfer Cash (In)`
        - `Transfer Cash (Out)`
        - `Transfer Instrument`
        - `Transfer Instrument (In)`
        - `Transfer Instrument (Out)`
        - `Split`
        - `Reverse Split`

#### Deposit/Withdraw

- **Transaction ID**
    
    
    - Text field. Case-sensitive.
    - A unique complex transaction identifier (only one in the workspace).
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="1417"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Transactions with repeated ID will be overwritten.
- **Transaction Type**
    
    
    - Text field. Case-sensitive.
    - Type of a transaction.
    - Should be a value from Standard transaction types for Transactions.
    - For Deposit/Withdraw transactions values should be:
        
        
        - `Deposit`
        - `Withdraw`
- **Reverse**
    
    
    - Text field.
    - Indicator for a reverse transaction.
    - Valid values:
        
        
        - `True`
        - `False`
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="1826"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> This field has only indicative meaning and will NOT invert any signs in other fields.
- **Date (Accounting)**
    
    
    - Date field.
    - A date on which a particular financial transaction was entered into the source system.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="2034"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Trade)**
    
    
    - Date field.
    - A date on which a particular financial transaction is executed or agreed upon.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="2034"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Value)**
    
    
    - Date field.
    - A date when cash or funds are expected to be received or paid as part of a financial transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="2225"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Portfolio**
    
    
    - Text field. Case-sensitive.
    - A collection of financial assets or investments held by an individual or organization.
- **Account (Cash)**
    
    
    - Text field. Case-sensitive.
    - An account that is specifically designated for managing and tracking cash transactions.
- **Currency (Settlement)**
    
    
    - Text field. Case-sensitive.
    - A currency in which the payment or transfer of funds takes place to fulfil the terms of the transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="2816"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be an alphabetic code of a currency alphabetic code (e.g. `USD`, `EUR`, `CHF`).
- **Cash Consideration**
    
    
    - Numeric field.
    - A monetary value or payment made in the form of cash for a particular transaction or asset.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="3039"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for income
        - “`-`" (minus sign) is for expenses
- **Amount (Charges)**
    
    
    - Numeric field.
    - For Deposit/Withdraw transactions values should be “`0`" (zero).
- **Account (Position)**
    
    
    - Text field. Case-sensitive.
    - For Deposit/Withdraw transactions values should be “`-`" (dash).
- **Instrument**
    
    
    - Text field. Case-sensitive.
    - For Deposit/Withdraw transactions values should be “`-`" (dash).
- **Allocation (PL)**
    
    
    - Text field. Case-sensitive.
    - For Deposit/Withdraw transactions values should be “`-`" (dash).
- **Position size**
    
    
    - Numeric field.
    - For Deposit/Withdraw transactions values should be “`0`" (zero).
- **Principal/Share price**
    
    
    - Numeric field.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="3560"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> For Deposit/Withdraw transactions:
        
        
        - The share price of the open-end fund.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="3645"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> For Deposit/Withdraw transactions values should be “`0`" (zero) for default.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for standard prices
        - “`-`" (minus sign) is for special prices (e.g. for exotic derivatives)
- **Amount (Carry)**
    
    
    - Numeric field.
    - For Deposit/Withdraw transactions values should be “`0`" (zero).
- **Notes**
    
    
    - Text field.
    - Additional comments, instructions, or relevant information associated with a particular transaction.
    - If there are no notes enter “`-`" (dash).
- **Payment Purpose (for Income/Expense)**
    
    
    - Text field. Case-sensitive.
    - For Deposit/Withdraw transactions values should be “`-`" (dash).
- **Reference transaction code**
    
    
    - Text field. Case-sensitive.
    - A reference to related transactions' unique identifiers.
    - For reverse transaction you can specify a transaction ID of the reversed transaction.
- **Counterparty**
    
    
    - Text field. Case-sensitive.
- **Responsible**
    
    
    - Text field. Case-sensitive.
- **Strategy1**
    
    
    - Text field. Case-sensitive.
- **Portfolio To**
    
    
    - Text field. Case-sensitive.
    - For Deposit/Withdraw transactions values should be “`-`" (dash).
- **Account To (Cash)**
    
    
    - Text field. Case-sensitive.
    - For Deposit/Withdraw transactions values should be “`-`" (dash).
- **Account To (Position)**
    
    
    - Text field. Case-sensitive.
    - For Deposit/Withdraw transactions values should be “`-`" (dash).
- **Position size New**
    
    
    - Numeric field.
    - For Deposit/Withdraw transactions values should be “`0`" (zero).
- **Principal/Share price New**
    
    
    - Numeric field.
    - For Deposit/Withdraw transactions values should be “`0`" (zero).

#### Expense/Income (Non-instrument)

- **Transaction ID**
    
    
    - Text field. Case-sensitive.
    - A unique complex transaction identifier (only one in the workspace).
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="5273"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Transactions with repeated ID will be overwritten.
- **Transaction Type**
    
    
    - Text field. Case-sensitive.
    - Type of a transaction.
    - Should be a value from Standard transaction types for Transactions.
    - For Income/Expense (Non-instrument) transactions values should be:
        
        
        - `Income (Non-instrument)`
        - `Expense (Non-instrument)`
- **Reverse**
    
    
    - Text field.
    - Indicator for a reverse transaction.
    - Valid values:
        
        
        - `True`
        - `False`
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="5729"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> This field has only indicative meaning and will NOT invert any signs in other fields.
- **Date (Accounting)**
    
    
    - Date field.
    - A date on which a particular financial transaction was entered into the source system.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="2034"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Trade)**
    
    
    - Date field.
    - A date on which a particular financial transaction is executed or agreed upon.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="5937"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Value)**
    
    
    - Date field.
    - A date when cash or funds are expected to be received or paid as part of a financial transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="6128"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Portfolio**
    
    
    - Text field. Case-sensitive.
    - A collection of financial assets or investments held by an individual or organization.
- **Account (Cash)**
    
    
    - Text field. Case-sensitive.
    - An account that is specifically designated for managing and tracking cash transactions.
- **Currency (Settlement)**
    
    
    - Text field. Case-sensitive.
    - A currency in which the payment or transfer of funds takes place to fulfil the terms of the transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="6629"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be an alphabetic code of a currency alphabetic code (e.g. `USD`, `EUR`, `CHF`).
- **Cash Consideration**
    
    
    - Numeric field.
    - A monetary value or payment made in the form of cash for a particular transaction or asset.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="6852"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for income
        - “`-`" (minus sign) is for expenses
- **Amount (Charges)**
    
    
    - Numeric field.
    - Costs or fees associated with a transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="7797"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for income
        - “`-`" (minus sign) is for expenses
- **Account (Position)**
    
    
    - Text field. Case-sensitive.
    - For Income/Expense (Non-instrument) transactions values should be “`-`" (dash).
- **Instrument**
    
    
    - Text field. Case-sensitive.
    - For Income/Expense (Non-instrument) transactions values should be “`-`" (dash).
- **Allocation (PL)**
    
    
    - Text field. Case-sensitive.
    - For Income/Expense (Non-instrument) transactions values should be “`-`" (dash).
- **Position size**
    
    
    - Numeric field.
    - For Income/Expense (Non-instrument) transactions values should be “`0`" (zero).
- **Principal/Share price**
    
    
    - Numeric field.
    - For Income/Expense (Non-instrument) transactions values should be “`0`" (zero).
- **Amount (Carry)**
    
    
    - Numeric field.
    - An amount of an Income/Expense.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="7574"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for income
        - “`-`" (minus sign) is for expenses
- **Notes**
    
    
    - Text field.
    - Additional comments, instructions, or relevant information associated with a particular transaction.
    - If there are no notes enter “`-`" (dash).
- **Payment Purpose (for Income/Expense)**
    
    
    - Text field. Case-sensitive.
    - A type of Income/Expense associated with a transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="8240"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Used for grouping in reports for non-instrument transactions.
- **Reference transaction code**
    
    
    - Text field. Case-sensitive.
    - A reference to related transactions' unique identifiers.
    - For reverse transaction you can specify a transaction ID of the reversed transaction.
- **Counterparty**
    
    
    - Text field. Case-sensitive.
- **Responsible**
    
    
    - Text field. Case-sensitive.
- **Strategy1**
    
    
    - Text field. Case-sensitive.
- **Portfolio To**
    
    
    - Text field. Case-sensitive.
    - For Expense/Income (Non-instrument) transactions values should be “`-`" (dash).
- **Account To (Cash)**
    
    
    - Text field. Case-sensitive.
    - For Expense/Income (Non-instrument) transactions values should be “`-`" (dash).
- **Account To (Position)**
    
    
    - Text field. Case-sensitive.
    - For Expense/Income (Non-instrument) transactions values should be “`-`" (dash).
- **Position size New**
    
    
    - Numeric field.
    - For Expense/Income (Non-instrument) transactions values should be “`0`" (zero).
- **Principal/Share price New**
    
    
    - Numeric field.
    - For Expense/Income (Non-instrument) transactions values should be “`0`" (zero).

#### Coupon/Dividend

- **Transaction ID**
    
    
    - Text field. Case-sensitive.
    - A unique complex transaction identifier (only one in the workspace).
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="9213"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Transactions with repeated ID will be overwritten.
- **Transaction Type**
    
    
    - Text field. Case-sensitive.
    - Type of a transaction.
    - Should be a value from Standard transaction types for Transactions.
    - For Coupon/Dividend transactions values should be:
        
        
        - `Coupon`
        - `Dividend`
- **Reverse**
    
    
    - Text field.
    - Indicator for a reverse transaction.
    - Valid values:
        
        
        - `True`
        - `False`
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="9620"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> This field has only indicative meaning and will NOT invert any signs in other fields.
- **Date (Accounting)**
    
    
    - Date field.
    - A date on which a particular financial transaction was entered into the source system.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="2034"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Trade)**
    
    
    - Date field.
    - A date on which a particular financial transaction is executed or agreed upon.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="9828"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Value)**
    
    
    - Date field.
    - A date when cash or funds are expected to be received or paid as part of a financial transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="10019"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Portfolio**
    
    
    - Text field. Case-sensitive.
    - A collection of financial assets or investments held by an individual or organization.
- **Account (Cash)**
    
    
    - Text field. Case-sensitive.
    - An account that is specifically designated for managing and tracking cash transactions.
- **Currency (Settlement)**
    
    
    - Text field.
    - A currency in which the payment or transfer of funds takes place to fulfil the terms of the transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="10505"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be an alphabetic code of a currency alphabetic code (e.g. `USD`, `EUR`, `CHF`).
- **Cash Consideration**
    
    
    - Numeric field.
    - A monetary value or payment made in the form of cash for a particular transaction or asset.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="10728"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for income
        - “`-`" (minus sign) is for expenses
- **Amount (Charges)**
    
    
    - Numeric field.
    - Costs or fees associated with a transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="11785"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for income
        - “`-`" (minus sign) is for expenses
- **Account (Position)**
    
    
    - Text field. Case-sensitive.
    - An account that tracks and records the positions or holdings of assets.
- **Instrument**
    
    
    - Text field. Case-sensitive.
    - A financial asset or security involved in a transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="11100"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Value must be:
        
        
        - ISIN (e.g. `GB00BFZNLB60`) to import Instrument from Finmars Database
        - user\_code - for instruments without ISIN or already created instruments.
- **Allocation (PL)**
    
    
    - Text field. Case-sensitive.
    - An instrument to which the financial outcome of a transaction is attributed or allocated.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="11100"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Value must be:
        
        
        - ISIN (e.g. `GB00BFZNLB60`) to import Instrument from Finmars Database
        - user\_code - for instruments without ISIN or already created instruments.
- **Position size**
    
    
    - Numeric field.
    - For Coupon/Dividend transactions values should be “`0`" (zero).
- **Principal/Share price**
    
    
    - Numeric field.
    - For Coupon/Dividend transactions values should be “`0`" (zero).
- **Amount (Carry)**
    
    
    - Numeric field.
    - An amount of a Coupon/Dividend.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="11562"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for income
        - “`-`" (minus sign) is for expenses
- **Notes**
    
    
    - Text field.
    - Additional comments, instructions, or relevant information associated with a particular transaction.
    - If there are no notes enter “`-`" (dash).
- **Payment Purpose (for Income/Expense)**
    
    
    - Text field. Case-sensitive.
    - For Coupon/Dividend transactions values should be “`-`" (dash).
- **Reference transaction code**
    
    
    - Text field. Case-sensitive.
    - A reference to related transactions' unique identifiers.
    - For reverse transaction you can specify a transaction ID of the reversed transaction.
- **Counterparty**
    
    
    - Text field. Case-sensitive.
- **Responsible**
    
    
    - Text field. Case-sensitive.
- **Strategy1**
    
    
    - Text field. Case-sensitive.
- **Portfolio To**
    
    
    - Text field. Case-sensitive.
    - For Coupon/Dividend transactions values should be “`-`" (dash).
- **Account To (Cash)**
    
    
    - Text field. Case-sensitive.
    - For Coupon/Dividend transactions values should be “`-`" (dash).
- **Account To (Position)**
    
    
    - Text field. Case-sensitive.
    - For Coupon/Dividend transactions values should be “`-`" (dash).
- **Position size New**
    
    
    - Numeric field.
    - For Coupon/Dividend transactions values should be “`0`" (zero).
- **Principal/Share price New**
    
    
    - Numeric field.
    - For Coupon/Dividend transactions values should be “`0`" (zero).

#### Expense/Other Income (Instrument)

- **Transaction ID**
    
    
    - Text field. Case-sensitive.
    - A unique complex transaction identifier (only one in the workspace).
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="13109"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Transactions with repeated ID will be overwritten.
- **Transaction Type**
    
    
    - Text field. Case-sensitive.
    - Type of a transaction.
    - Should be a value from Standard transaction types for Transactions.
    - For Other Income/Expense (Instrument) transactions values should be:
        
        
        - `Other Income (Instrument)`
        - `Expense (Instrument)`
- **Reverse**
    
    
    - Text field.
    - Indicator for a reverse transaction.
    - Valid values:
        
        
        - `True`
        - `False`
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="13565"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> This field has only indicative meaning and will NOT invert any signs in other fields.
- **Date (Accounting)**
    
    
    - Date field.
    - A date on which a particular financial transaction was entered into the source system.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="2034"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Trade)**
    
    
    - Date field.
    - A date on which a particular financial transaction is executed or agreed upon.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="13773"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Value)**
    
    
    - Date field.
    - A date when cash or funds are expected to be received or paid as part of a financial transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="13964"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Portfolio**
    
    
    - Text field.
    - A collection of financial assets or investments held by an individual or organization.
- **Account (Cash)**
    
    
    - Text field. Case-sensitive.
    - An account that is specifically designated for managing and tracking cash transactions.
- **Currency (Settlement)**
    
    
    - Text field. Case-sensitive.
    - A currency in which the payment or transfer of funds takes place to fulfil the terms of the transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="14449"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be an alphabetic code of a currency alphabetic code (e.g. `USD`, `EUR`, `CHF`).
- **Cash Consideration**
    
    
    - Numeric field.
    - A monetary value or payment made in the form of cash for a particular transaction or asset.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="14672"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for income
        - “`-`" (minus sign) is for expenses
- **Amount (Charges)**
    
    
    - Numeric field.
    - Costs or fees associated with a transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="15764"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for income
        - “`-`" (minus sign) is for expenses
- **Account (Position)**
    
    
    - Text field. Case-sensitive.
    - An account that tracks and records the positions or holdings of assets.
- **Instrument**
    
    
    - Text field. Case-sensitive.
    - A financial asset or security involved in a transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="15044"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Value must be:
        
        
        - ISIN (e.g. `GB00BFZNLB60`) to import Instrument from Finmars Database
        - user\_code - for instruments without ISIN or already created instruments.
- **Allocation (PL)**
    
    
    - Text field. Case-sensitive.
    - An instrument to which the financial outcome of a transaction is attributed or allocated.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="11100"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Value must be:
        
        
        - ISIN (e.g. `GB00BFZNLB60`) to import Instrument from Finmars Database
        - user\_code - for instruments without ISIN or already created instruments.
- **Position size**
    
    
    - Numeric field.
    - For Other Income/Expense (Instrument) transactions values should be “`0`" (zero).
- **Principal/Share price**
    
    
    - Numeric field.
    - For Other Income/Expense (Instrument) transactions values should be “`0`" (zero).
- **Amount (Carry)**
    
    
    - Numeric field.
    - An amount of an Income/Expense.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="15541"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for income
        - “`-`" (minus sign) is for expenses
- **Notes**
    
    
    - Text field.
    - Additional comments, instructions, or relevant information associated with a particular transaction.
    - If there are no notes enter “`-`" (dash).
- **Payment Purpose (for Income/Expense)**
    
    
    - Text field. Case-sensitive.
    - A type of Income/Expense associated with a transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="16207"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Used for grouping in reports for non-instrument transactions.
- **Reference transaction code**
    
    
    - Text field. Case-sensitive.
    - A reference to related transactions' unique identifiers.
    - For reverse transaction you can specify a transaction ID of the reversed transaction.
- **Counterparty**
    
    
    - Text field. Case-sensitive.
- **Responsible**
    
    
    - Text field. Case-sensitive.
- **Strategy1**
    
    
    - Text field. Case-sensitive.
- **Portfolio To**
    
    
    - Text field. Case-sensitive.
    - For Expense/Other Income (Instrument) transactions values should be “`-`" (dash).
- **Account To (Cash)**
    
    
    - Text field. Case-sensitive.
    - For Expense/Other Income (Instrument) transactions values should be “`-`" (dash).
- **Account To (Position)**
    
    
    - Text field. Case-sensitive.
    - For Expense/Other Income (Instrument) transactions values should be “`-`" (dash).
- **Position size New**
    
    
    - Numeric field.
    - For Expense/Other Income (Instrument) transactions values should be “`0`" (zero).
- **Principal/Share price New**
    
    
    - Numeric field.
    - For Expense/Other Income (Instrument) transactions values should be “`0`" (zero).

#### Buy/Sell

- **Transaction ID**
    
    
    - Text field. Case-sensitive.
    - A unique complex transaction identifier (only one in the workspace).
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="17179"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Transactions with repeated ID will be overwritten.
- **Transaction Type**
    
    
    - Text field. Case-sensitive.
    - Type of a transaction.
    - Should be a value from Standard transaction types for Transactions.
    - For Buy/Sell transactions values should be:
        
        
        - `Buy`
        - `Sell`
- **Reverse**
    
    
    - Text field.
    - Indicator for a reverse transaction.
    - Valid values:
        
        
        - `True`
        - `False`
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="17572"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> This field has only indicative meaning and will NOT invert any signs in other fields.
- **Date (Accounting)**
    
    
    - Date field.
    - A date on which a particular financial transaction was entered into the source system.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="2034"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Trade)**
    
    
    - Date field.
    - A date on which a particular financial transaction is executed or agreed upon.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="17780"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Value)**
    
    
    - Date field.
    - A date when cash or funds are expected to be received or paid as part of a financial transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="17971"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Portfolio**
    
    
    - Text field. Case-sensitive.
    - A collection of financial assets or investments held by an individual or organization.
- **Account (Cash)**
    
    
    - Text field. Case-sensitive.
    - An account that is specifically designated for managing and tracking cash transactions.
- **Currency (Settlement)**
    
    
    - Text field. Case-sensitive.
    - A currency in which the payment or transfer of funds takes place to fulfil the terms of the transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="18472"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be an alphabetic code of a currency alphabetic code (e.g. `USD`, `EUR`, `CHF`).
- **Cash Consideration**
    
    
    - Numeric field.
    - A monetary value or payment made in the form of cash for a particular transaction or asset.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="18695"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for income
        - “`-`" (minus sign) is for expenses
- **Amount (Charges)**
    
    
    - Numeric field.
    - Costs or fees associated with a transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="20336"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for income
        - “`-`" (minus sign) is for expenses
- **Account (Position)**
    
    
    - Text field. Case-sensitive.
    - An account that tracks and records the positions or holdings of assets.
- **Instrument**
    - Text field. Case-sensitive.
    - A financial asset or security involved in a transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="19067"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Value must be:
        
        
        - ISIN (e.g. `GB00BFZNLB60`) to import Instrument from Finmars Database
        - user\_code - for instruments without ISIN or already created instruments.
- **Allocation (PL)**
    
    
    - Text field. Case-sensitive.
    - An instrument to which the financial outcome of a transaction is attributed or allocated.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="11100"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Value must be:
        
        
        - ISIN (e.g. `GB00BFZNLB60`) to import Instrument from Finmars Database
        - user\_code - for instruments without ISIN or already created instruments.
- **Position size**
    
    
    - Numeric field.
    - An adjusted position of the asset after all alterations or corrections (e.g. adjusted for a factor).
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for position increase
        - “`-`" (minus sign) is for position decrease
- **Principal/Share price**
    
    
    - Numeric field.
    - For Buy/Sell transactions this field is a Principal price:
        
        
        - A unit price or value of a financial instrument, excluding any accrued interest or additional earnings.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="19718"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="19755"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Multipliers will be applied automatically in accordance with an instrument of the transaction.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for standard prices
        - “`-`" (minus sign) is for special prices (e.g. for exotic derivatives)
- **Amount (Carry)**
    
    
    - Numeric field.
    - An amount or expense that has been incurred but not yet paid or settled.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="20113"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for income
        - “`-`" (minus sign) is for expenses
- **Notes**
    
    
    - Text field.
    - Additional comments, instructions, or relevant information associated with a particular transaction.
    - If there are no notes enter “-” (dash).
- **Payment Purpose (for Income/Expense)**
    
    
    - Text field. Case-sensitive.
    - For Buy/Sell transactions values should be “-" (dash).
- **Reference transaction code**
    
    
    - Text field. Case-sensitive.
    - A reference to related transactions' unique identifiers.
    - For reverse transaction you can specify a transaction ID of the reversed transaction.
- **Counterparty**
    
    
    - Text field. Case-sensitive.
- **Responsible**
    
    
    - Text field. Case-sensitive.
- **Strategy1**
    
    
    - Text field. Case-sensitive.
- **Portfolio To**
    
    
    - Text field. Case-sensitive.
    - For Buy/Sell transactions values should be “`-`" (dash).
- **Account To (Cash)**
    
    
    - Text field. Case-sensitive.
    - For Buy/Sell transactions values should be “`-`" (dash).
- **Account To (Position)**
    
    
    - Text field. Case-sensitive.
    - For Buy/Sell transactions values should be “`-`" (dash).
- **Position size New**
    
    
    - Numeric field.
    - For Buy/Sell transactions values should be “`0`" (zero).
- **Principal/Share price New**
    
    
    - Numeric field.
    - For Buy/Sell transactions values should be “`0`" (zero).

#### FX Trade

- **Transaction ID**
    
    
    - Text field. Case-sensitive.
    - A unique complex transaction identifier (only one in the workspace).
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="21607"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Transactions with repeated ID will be overwritten.
- **Transaction Type**
    
    
    - Text field. Case-sensitive.
    - Type of a transaction.
    - Should be a value from Standard transaction types for Transactions.
    - For FX Trade transactions values should be:
        
        
        - `FX Trade`
- **Reverse**
    
    
    - Text field.
    - Indicator for a reverse transaction.
    - Valid values:
        
        
        - `True`
        - `False`
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="21997"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> This field has only indicative meaning and will NOT invert any signs in other fields.
- **Date (Accounting)**
    
    
    - Date field.
    - A date on which a particular financial transaction was entered into the source system.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="2034"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Trade)**
    
    
    - Date field.
    - A date on which a particular financial transaction is executed or agreed upon.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="22205"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Value)**
    
    
    - Date field.
    - A date when cash or funds are expected to be received or paid as part of a financial transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="22396"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Portfolio**
    
    
    - Text field. Case-sensitive.
    - A collection of financial assets or investments held by an individual or organization.
- **Account (Cash)**
    
    
    - Text field. Case-sensitive.
    - An account that is specifically designated for managing and tracking cash transactions.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="22844"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png) </span></span></span>For FX Trade transactions:
        
        
        - An account for the quote currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
- **Currency (Settlement)**
    
    
    - Text field. Case-sensitive.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="22844"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png) </span></span></span>For FX Trade transactions:
        
        
        - A quote currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="24516"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be an alphabetic code of a currency alphabetic code (e.g. `USD`, `EUR`, `CHF`).
- **Cash Consideration**
    
    
    - Numeric field.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="24067"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> For FX Trade transactions:
        
        
        - An amount of a quote currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
    - A sign of the number:
        
        
        - “+” (plus sign) is for position increase
        - “-” (minus sign) is for position decrease
- **Amount (Charges)**
    
    
    - Numeric field.
    - For FX Trade transactions values should be “`0`" (zero).
- **Account (Position)**
    
    
    - Text field. Case-sensitive.
    - An account that is specifically designated for managing and tracking cash transactions.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="22844"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png) </span></span></span>For FX Trade transactions:
        
        
        - An account for the base currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
- **Instrument**
    
    
    - Text field.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="22844"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> For FX Trade transactions:
        
        
        - A base currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="22973"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be an alphabetic code of a currency alphabetic code (e.g. `USD`, `EUR`, `CHF`).
- **Allocation (PL)**
    
    
    - Text field. Case-sensitive.
    - An instrument to which the financial outcome of a transaction is attributed or allocated.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="11100"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Value must be:
        
        
        - ISIN (e.g. `GB00BFZNLB60`) to import Instrument from Finmars Database
        - user\_code - for instruments without ISIN or already created instruments.
- **Position size**
    
    
    - Numeric field.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="23096"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> For FX Trade transactions:
        
        
        - An amount of a base currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for position increase
        - “`-`" (minus sign) is for position decrease
- **Principal/Share price**
    
    
    - Numeric field.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="48294"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png) </span></span></span>For FX Trade transactions:
        
        
        - An exchange rate used for a contract’s foreign exchange transaction, where Sell currency is the Quote currency and Buy currency is the Base currency (e.g. we sell 110 USD and buy 100 EUR, then the field’s value should be 1.1 EUR/USD).
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for standard prices
        - “`-`" (minus sign) is for special prices (e.g. for exotic derivatives)
- **Amount (Carry)**
    
    
    - Numeric field.
    - For FX Trade transactions values should be “`0`" (zero).
- **Notes**
    
    
    - Text field.
    - Additional comments, instructions, or relevant information associated with a particular transaction.
    - If there are no notes enter “`-`" (dash).
- **Payment Purpose (for Income/Expense)**
    
    
    - Text field. Case-sensitive.
    - For FX Trade transactions values should be “`-`" (dash).
- **Reference transaction code**
    
    
    - Text field. Case-sensitive.
    - A reference to related transactions' unique identifiers.
    - For reverse transaction you can specify a transaction ID of the reversed transaction.
- **Counterparty**
    
    
    - Text field. Case-sensitive.
- **Responsible**
    
    
    - Text field. Case-sensitive.
- **Strategy1**
    
    
    - Text field. Case-sensitive.
- **Portfolio To**
    
    
    - Text field. Case-sensitive.
    - For FX Trade transactions values should be “`-`" (dash).
- **Account To (Cash)**
    
    
    - Text field. Case-sensitive.
    - For FX Trade transactions values should be “`-`" (dash).
- **Account To (Position)**
    
    
    - Text field. Case-sensitive.
    - For FX Trade transactions values should be “`-`" (dash).
- **Position size New**
    
    
    - Numeric field.
    - For FX Trade transactions values should be “`0`" (zero).
- **Principal/Share price New**
    
    
    - Numeric field.
    - For FX Trade transactions values should be “`0`" (zero).

#### Transfer Cash

- **Transaction ID**
    
    
    - Text field. Case-sensitive.
    - A unique complex transaction identifier (only one in the workspace).
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="25743"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Transactions with repeated ID will be overwritten.
- **Transaction Type**
    
    
    - Text field. Case-sensitive.
    - Type of a transaction.
    - Should be a value from Standard transaction types for Transactions.
    - For Transfer Cash transactions values should be:
        
        
        - `Transfer Cash`
- **Reverse**
    
    
    - Text field.
    - Indicator for a reverse transaction.
    - Valid values:
        
        
        - `True`
        - `False`
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="26143"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> This field has only indicative meaning and will NOT invert any signs in other fields.
- **Date (Accounting)**
    
    
    - Date field.
    - A date on which a particular financial transaction was entered into the source system.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="2034"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Trade)**
    
    
    - Date field.
    - A date on which a particular financial transaction is executed or agreed upon.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="26351"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Value)**
    
    
    - Date field.
    - A date when cash or funds are expected to be received or paid as part of a financial transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="26542"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Portfolio**
    
    
    - Text field. Case-sensitive.
    - A collection of financial assets or investments held by an individual or organization.
- **Account (Cash)**
    
    
    - Text field. Case-sensitive.
    - An account that is specifically designated for managing and tracking cash transactions.
- **Currency (Settlement)**
    
    
    - Text field. Case-sensitive.
    - A currency in which the payment or transfer of funds takes place to fulfil the terms of the transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="27133"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be an alphabetic code of a currency alphabetic code (e.g. `USD`, `EUR`, `CHF`).
- **Cash Consideration**
    
    
    - Numeric field.
    - A monetary value or payment made in the form of cash for a particular transaction or asset.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="27356"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for income
        - “`-`" (minus sign) is for expenses
- **Amount (Charges)**
    
    
    - Numeric field.
    - For Transfer Cash transactions values should be “`0`" (zero).
- **Account (Position)**
    
    
    - Text field. Case-sensitive.
    - For Transfer Cash transactions values should be “`-`" (dash).
- **Instrument**
    
    
    - Text field. Case-sensitive.
    - For Transfer Cash transactions values should be “`-`" (dash).
- **Allocation (PL)**
    
    
    - Text field. Case-sensitive.
    - For Transfer Cash transactions values should be “`-`" (dash).
- **Position size**
    
    
    - Numeric field.
    - For Transfer Cash transactions values should be “`0`" (zero).
- **Principal/Share price**
    
    
    - Numeric field.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="27868"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> For Transfer Cash transactions values should be “`0`" (zero) for default.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for standard prices
        - “`-`" (minus sign) is for special prices (e.g. for exotic derivatives)
- **Amount (Carry)**
    
    
    - Numeric field.
    - For Transfer Cash transactions values should be “`0`" (zero).
- **Notes**
    
    
    - Text field.
    - Additional comments, instructions, or relevant information associated with a particular transaction.
    - If there are no notes enter “`-`" (dash).
- **Payment Purpose (for Income/Expense)**
    
    
    - Text field. Case-sensitive.
    - For Transfer Cash transactions values should be “`-`" (dash).
- **Reference transaction code**
    
    
    - Text field. Case-sensitive.
    - A reference to related transactions' unique identifiers.
    - For reverse transaction you can specify a transaction ID of the reversed transaction.
- **Counterparty**
    
    
    - Text field. Case-sensitive.
- **Responsible**
    
    
    - Text field. Case-sensitive.
- **Strategy1**
    
    
    - Text field. Case-sensitive.
- **Portfolio To**
    
    
    - Text field. Case-sensitive.
    - A collection of financial assets or investments held by an individual or organization where the transaction transfer to.
- **Account To (Cash)**
    
    
    - Text field. Case-sensitive.
    - An account that is specifically designated for managing and tracking cash transactions where the transaction transfer to.
- **Account To (Position)**
    
    
    - Text field. Case-sensitive.
    - For Transfer Cash transactions values should be “`-`" (dash).
- **Position size New**
    
    
    - Numeric field.
    - For Transfer Cash transactions values should be “`0`" (zero).
- **Principal/Share price New**
    
    
    - Numeric field.
    - For Transfer Cash transactions values should be “`0`" (zero).

#### Transfer Cash (In/Out)

- **Transaction ID**
    
    
    - Text field. Case-sensitive.
    - A unique complex transaction identifier (only one in the workspace).
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="25743"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Transactions with repeated ID will be overwritten.
- **Transaction Type**
    
    
    - Text field. Case-sensitive.
    - Type of a transaction.
    - Should be a value from Standard transaction types for Transactions.
    - For Transfer Cash (In/Out) transactions values should be:
        
        
        - `Transfer Cash (In)`
        - `Transfer Cash (Out)`
- **Reverse**
    
    
    - Text field.
    - Indicator for a reverse transaction.
    - Valid values:
        
        
        - `True`
        - `False`
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="26143"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> This field has only indicative meaning and will NOT invert any signs in other fields.
- **Date (Accounting)**
    
    
    - Date field.
    - A date on which a particular financial transaction was entered into the source system.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="2034"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Trade)**
    
    
    - Date field.
    - A date on which a particular financial transaction is executed or agreed upon.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="26351"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Value)**
    
    
    - Date field.
    - A date when cash or funds are expected to be received or paid as part of a financial transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="26542"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Portfolio**
    
    
    - Text field. Case-sensitive.
    - A collection of financial assets or investments held by an individual or organization.
- **Account (Cash)**
    
    
    - Text field. Case-sensitive.
    - An account that is specifically designated for managing and tracking cash transactions.
- **Currency (Settlement)**
    
    
    - Text field. Case-sensitive.
    - A currency in which the payment or transfer of funds takes place to fulfil the terms of the transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="27133"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be an alphabetic code of a currency alphabetic code (e.g. `USD`, `EUR`, `CHF`).
- **Cash Consideration**
    
    
    - Numeric field.
    - A monetary value or payment made in the form of cash for a particular transaction or asset.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="27356"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for income
        - “`-`" (minus sign) is for expenses
- **Amount (Charges)**
    
    
    - Numeric field.
    - For Transfer Cash (In/Out) transactions values should be “`0`" (zero).
- **Account (Position)**
    
    
    - Text field. Case-sensitive.
    - For Transfer Cash (In/Out) transactions values should be “`-`" (dash).
- **Instrument**
    
    
    - Text field. Case-sensitive.
    - For Transfer Cash (In/Out) transactions values should be “`-`" (dash).
- **Allocation (PL)**
    
    
    - Text field. Case-sensitive.
    - For Transfer Cash (In/Out) transactions values should be “`-`" (dash).
- **Position size**
    
    
    - Numeric field.
    - For Transfer Cash (In/Out) transactions values should be “`0`" (zero).
- **Principal/Share price**
    
    
    - Numeric field.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="27868"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> For Transfer Cash (In/Out) transactions values should be “`0`" (zero) for default.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for standard prices
        - “`-`" (minus sign) is for special prices (e.g. for exotic derivatives)
- **Amount (Carry)**
    
    
    - Numeric field.
    - For Transfer Cash (In/Out) transactions values should be “`0`" (zero).
- **Notes**
    
    
    - Text field.
    - Additional comments, instructions, or relevant information associated with a particular transaction.
    - If there are no notes enter “`-`" (dash).
- **Payment Purpose (for Income/Expense)**
    
    
    - Text field. Case-sensitive.
    - For Transfer Cash (In/Out) transactions values should be “`-`" (dash).
- **Reference transaction code**
    
    
    - Text field. Case-sensitive.
    - A reference to related transactions' unique identifiers.
    - For reverse transaction you can specify a transaction ID of the reversed transaction.
- **Counterparty**
    
    
    - Text field. Case-sensitive.
- **Responsible**
    
    
    - Text field. Case-sensitive.
- **Strategy1**
    
    
    - Text field. Case-sensitive.
- **Portfolio To**
    
    
    - Text field. Case-sensitive.
    - For Transfer Cash (In/Out) transactions values should be “`-`" (dash).
- **Account To (Cash)**
    
    
    - Text field. Case-sensitive.
    - For Transfer Cash (In/Out) transactions values should be “`-`" (dash).
- **Account To (Position)**
    
    
    - Text field. Case-sensitive.
    - For Transfer Cash (In/Out) transactions values should be “`-`" (dash).
- **Position size New**
    
    
    - Numeric field.
    - For Transfer Cash (In/Out) transactions values should be “`0`" (zero).
- **Principal/Share price New**
    
    
    - Numeric field.
    - For Transfer Cash (In/Out) transactions values should be “`0`" (zero).

#### Transfer Instrument

- **Transaction ID**
    
    
    - Text field. Case-sensitive.
    - A unique complex transaction identifier (only one in the workspace).
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="29585"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Transactions with repeated ID will be overwritten.
- **Transaction Type**
    
    
    - Text field. Case-sensitive.
    - Type of a transaction.
    - Should be a value from Standard transaction types for Transactions.
    - For Transfer Instrument transactions values should be:
        
        
        - `Transfer Instrument`
- **Reverse**
    
    
    - Text field.
    - Indicator for a reverse transaction.
    - Valid values:
        
        
        - `True`
        - `False`
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="29997"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> This field has only indicative meaning and will NOT invert any signs in other fields.
- **Date (Accounting)**
    
    
    - Date field.
    - A date on which a particular financial transaction was entered into the source system.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="2034"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Trade)**
    
    
    - Date field.
    - A date on which a particular financial transaction is executed or agreed upon.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="30205"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Value)**
    
    
    - Date field.
    - A date when cash or funds are expected to be received or paid as part of a financial transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="30396"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Portfolio**
    
    
    - Text field. Case-sensitive.
    - A collection of financial assets or investments held by an individual or organization.
- **Account (Cash)**
    
    
    - Text field. Case-sensitive.
    - An account that is specifically designated for managing and tracking cash transactions.
- **Currency (Settlement)**
    
    
    - Text field. Case-sensitive.
    - A currency in which the payment or transfer of funds takes place to fulfil the terms of the transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="30897"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be an alphabetic code of a currency alphabetic code (e.g. `USD`, `EUR`, `CHF`).
- **Cash Consideration**
    
    
    - Numeric field.
    - A monetary value or payment made in the form of cash for a particular transaction or asset.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="31120"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for income
        - “`-`" (minus sign) is for expenses
- **Amount (Charges)**
    
    
    - Numeric field.
    - Costs or fees associated with a transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="32772"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for income
        - “`-`" (minus sign) is for expenses
- **Account (Position)**
    
    
    - Text field. Case-sensitive.
    - An account that tracks and records the positions or holdings of assets.
- **Instrument**
    - Text field. Case-sensitive.
    - A financial asset or security involved in a transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="31492"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Value must be:
        
        
        - ISIN (e.g. `GB00BFZNLB60`) to import Instrument from Finmars Database
        - user\_code - for instruments without ISIN or already created instruments.
- **Allocation (PL)**
    
    
    - Text field. Case-sensitive.
    - For Transfer Instrument transactions values should be “`-`" (dash).
- **Position size**
    
    
    - Numeric field.
    - An adjusted position of the asset after all alterations or corrections (e.g. adjusted for a factor).
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for position increase
        - “`-`" (minus sign) is for position decrease
- **Principal/Share price**
    
    
    - Numeric field.
    - For Transfer Instrument transactions this field is a Principal price:
        
        
        - A unit price or value of a financial instrument, excluding any accrued interest or additional earnings.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="32154"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="32191"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Multipliers will be applied automatically in accordance with an instrument of the transaction.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for standard prices
        - “`-`" (minus sign) is for special prices (e.g. for exotic derivatives)
- **Amount (Carry)**
    
    
    - Numeric field.
    - An amount or expense that has been incurred but not yet paid or settled.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="32549"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for income
        - “`-`" (minus sign) is for expenses
- **Notes**
    
    
    - Text field.
    - Additional comments, instructions, or relevant information associated with a particular transaction.
    - If there are no notes enter “-” (dash).
- **Payment Purpose (for Income/Expense)**
    
    
    - Text field. Case-sensitive.
    - For Transfer Instrument transactions values should be “-" (dash).
- **Reference transaction code**
    
    
    - Text field. Case-sensitive.
    - A reference to related transactions' unique identifiers.
    - For reverse transaction you can specify a transaction ID of the reversed transaction.
- **Counterparty**
    
    
    - Text field. Case-sensitive.
- **Responsible**
    
    
    - Text field. Case-sensitive.
- **Strategy1**
    
    
    - Text field. Case-sensitive.
- **Portfolio To**
    
    
    - Text field. Case-sensitive.
    - A collection of financial assets or investments held by an individual or organization where the transaction transfer to.
- **Account To (Cash)**
    
    
    - Text field. Case-sensitive.
    - For Transfer Instrument transactions values should be “`-`" (dash).
- **Account To (Position)**
    
    
    - Text field. Case-sensitive.
    - An account that tracks and records the positions or holdings of assets where the transaction transfer to.
- **Position size New**
    
    
    - Numeric field.
    - For Transfer Instrument transactions values should be “`0`" (zero).
- **Principal/Share price New**
    
    
    - Numeric field.
    - For Transfer Instrument transactions values should be “`0`" (zero).

#### Transfer Instrument (In/Out)

- **Transaction ID**
    
    
    - Text field. Case-sensitive.
    - A unique complex transaction identifier (only one in the workspace).
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="29585"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Transactions with repeated ID will be overwritten.
- **Transaction Type**
    
    
    - Text field. Case-sensitive.
    - Type of a transaction.
    - Should be a value from Standard transaction types for Transactions.
    - For Transfer Instrument (In/Out) transactions values should be:
        
        
        - `Transfer Instrument (In)`
        - `Transfer Instrument (Out)`
- **Reverse**
    
    
    - Text field.
    - Indicator for a reverse transaction.
    - Valid values:
        
        
        - `True`
        - `False`
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="29997"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> This field has only indicative meaning and will NOT invert any signs in other fields.
- **Date (Accounting)**
    
    
    - Date field.
    - A date on which a particular financial transaction was entered into the source system.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="2034"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Trade)**
    
    
    - Date field.
    - A date on which a particular financial transaction is executed or agreed upon.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="30205"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Value)**
    
    
    - Date field.
    - A date when cash or funds are expected to be received or paid as part of a financial transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="30396"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Portfolio**
    
    
    - Text field. Case-sensitive.
    - A collection of financial assets or investments held by an individual or organization.
- **Account (Cash)**
    
    
    - Text field. Case-sensitive.
    - An account that is specifically designated for managing and tracking cash transactions.
- **Currency (Settlement)**
    
    
    - Text field. Case-sensitive.
    - A currency in which the payment or transfer of funds takes place to fulfil the terms of the transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="30897"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be an alphabetic code of a currency alphabetic code (e.g. `USD`, `EUR`, `CHF`).
- **Cash Consideration**
    
    
    - Numeric field.
    - A monetary value or payment made in the form of cash for a particular transaction or asset.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="31120"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for income
        - “`-`" (minus sign) is for expenses
- **Amount (Charges)**
    
    
    - Numeric field.
    - Costs or fees associated with a transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="32772"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for income
        - “`-`" (minus sign) is for expenses
- **Account (Position)**
    
    
    - Text field. Case-sensitive.
    - An account that tracks and records the positions or holdings of assets.
- **Instrument**
    - Text field. Case-sensitive.
    - A financial asset or security involved in a transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="31492"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Value must be:
        
        
        - ISIN (e.g. `GB00BFZNLB60`) to import Instrument from Finmars Database
        - user\_code - for instruments without ISIN or already created instruments.
- **Allocation (PL)**
    
    
    - Text field. Case-sensitive.
    - For Transfer Instrument (In/Out) transactions values should be “`-`" (dash).
- **Position size**
    
    
    - Numeric field.
    - An adjusted position of the asset after all alterations or corrections (e.g. adjusted for a factor).
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for position increase
        - “`-`" (minus sign) is for position decrease
- **Principal/Share price**
    
    
    - Numeric field.
    - For Transfer Instrument (In/Out) transactions this field is a Principal price:
        
        
        - A unit price or value of a financial instrument, excluding any accrued interest or additional earnings.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="32154"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="32191"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Multipliers will be applied automatically in accordance with an instrument of the transaction.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for standard prices
        - “`-`" (minus sign) is for special prices (e.g. for exotic derivatives)
- **Amount (Carry)**
    
    
    - Numeric field.
    - An amount or expense that has been incurred but not yet paid or settled.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="32549"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for income
        - “`-`" (minus sign) is for expenses
- **Notes**
    
    
    - Text field.
    - Additional comments, instructions, or relevant information associated with a particular transaction.
    - If there are no notes enter “-” (dash).
- **Payment Purpose (for Income/Expense)**
    
    
    - Text field. Case-sensitive.
    - For Transfer Instrument (In/Out) transactions values should be “-" (dash).
- **Reference transaction code**
    
    
    - Text field. Case-sensitive.
    - A reference to related transactions' unique identifiers.
    - For reverse transaction you can specify a transaction ID of the reversed transaction.
- **Counterparty**
    
    
    - Text field. Case-sensitive.
- **Responsible**
    
    
    - Text field. Case-sensitive.
- **Strategy1**
    
    
    - Text field. Case-sensitive.
- **Portfolio To**
    
    
    - Text field. Case-sensitive.
    - For Transfer Instrument (In/Out) transactions values should be “`-`" (dash).
- **Account To (Cash)**
    
    
    - Text field. Case-sensitive.
    - For Transfer Instrument (In/Out) transactions values should be “`-`" (dash).
- **Account To (Position)**
    
    
    - Text field. Case-sensitive.
    - For Transfer Instrument (In/Out) transactions values should be “`-`" (dash).
- **Position size New**
    
    
    - Numeric field.
    - For Transfer Instrument (In/Out) transactions values should be “`0`" (zero).
- **Principal/Share price New**
    
    
    - Numeric field.
    - For Transfer Instrument (In/Out) transactions values should be “`0`" (zero).

#### FX Forward (Open)/FX Forward (Expiration)

- **Transaction ID**
    
    
    - Text field. Case-sensitive.
    - A unique complex transaction identifier (only one in the workspace).
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="34215"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Transactions with repeated ID will be overwritten.
- **Transaction Type**
    
    
    - Text field. Case-sensitive.
    - Type of a transaction.
    - Should be a value from Standard transaction types for Transactions.
    - For FX Forward (Open)/FX Forward (Expiration) transactions values should be:
        
        
        - `FX Forward (Open)`
        - `FX Forward (Expiration)`
- **Reverse**
    
    
    - Text field.
    - Indicator for a reverse transaction.
    - Valid values:
        
        
        - `True`
        - `False`
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="34674"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> This field has only indicative meaning and will NOT invert any signs in other fields.
- **Date (Accounting)**
    
    
    - Date field.
    - A date on which a particular financial transaction was entered into the source system.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="2034"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Trade)**
    
    
    - Date field.
    - A date on which a particular financial transaction is executed or agreed upon.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="34882"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Value)**
    
    
    - Date field.
    - A date when cash or funds are expected to be received or paid as part of a financial transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="35073"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Portfolio**
    
    
    - Text field. Case-sensitive.
    - A collection of financial assets or investments held by an individual or organization.
- **Account (Cash)**
    
    
    - Text field. Case-sensitive.
    - An account that is specifically designated for managing and tracking cash transactions.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="37342"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png) </span></span></span>For FX Forward (Open)/FX Forward (Expiration) transactions:
        
        
        - An account for the quote currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
- **Currency (Settlement)**
    
    
    - Text field. Case-sensitive.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="37342"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png) </span></span></span>For FX Forward (Open)/FX Forward (Expiration) transactions:
        
        
        - A quote currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="37342"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be an alphabetic code of a currency alphabetic code (e.g. `USD`, `EUR`, `CHF`).
- **Cash Consideration**
    
    
    - Numeric field.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="36827"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> For FX Forward (Open)/FX Forward (Expiration) transactions:
        
        
        - An amount of a quote currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
    - A sign of the number:
        
        
        - “+” (plus sign) is for position increase
        - “-” (minus sign) is for position decrease
- **Amount (Charges)**
    
    
    - Numeric field.
    - For FX Forward (Open)/FX Forward (Expiration) transactions values should be “`0`" (zero).
- **Account (Position)**
    
    
    - Text field. Case-sensitive.
    - An account that is specifically designated for managing and tracking cash transactions.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="35439"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> For FX Forward (Open)/FX Forward (Expiration) transactions:
        
        
        - An account for the base currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
- **Instrument**
    
    
    - Text field.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="35439"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> For FX Forward (Open)/FX Forward (Expiration) transactions:
        
        
        - A base currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="35601"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be an alphabetic code of a currency alphabetic code (e.g. `USD`, `EUR`, `CHF`).
- **Allocation (PL)**
    
    
    - Text field. Case-sensitive.
    - An instrument to which the financial outcome of a transaction is attributed or allocated.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="11100"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Value must be:
        
        
        - ISIN (e.g. `GB00BFZNLB60`) to import Instrument from Finmars Database
        - user\_code - for instruments without ISIN or already created instruments.
- **Position size**
    
    
    - Numeric field.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="35724"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> For FX Forward (Open)/FX Forward (Expiration) transactions:
        
        
        - An amount of a base currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for position increase
        - “`-`" (minus sign) is for position decrease
- **Principal/Share price**
    
    
    - Numeric field.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="48294"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png) </span></span></span>For FX Forward (Open)/FX Forward (Expiration) transactions:
        
        
        - An exchange rate used for a contract’s foreign exchange transaction, where Sell currency is the Quote currency and Buy currency is the Base currency (e.g. we sell 110 USD and buy 100 EUR, then the field’s value should be 1.1 EUR/USD).
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for standard prices
        - “`-`" (minus sign) is for special prices (e.g. for exotic derivatives)
- **Amount (Carry)**
    
    
    - Numeric field.
    - For FX Forward (Open)/FX Forward (Expiration) transactions values should be “`0`" (zero).
- **Notes**
    
    
    - Text field.
    - Additional comments, instructions, or relevant information associated with a particular transaction.
    - If there are no notes enter “`-`" (dash).
- **Payment Purpose (for Income/Expense)**
    
    
    - Text field. Case-sensitive.
    - For FX Forward (Open)/FX Forward (Expiration) transactions values should be “`-`" (dash).
- **Reference transaction code**
    
    
    - Text field. Case-sensitive.
    - A reference to related transactions' unique identifiers.
    - For reverse transaction you can specify a transaction ID of the reversed transaction.
- **Counterparty**
    
    
    - Text field. Case-sensitive.
- **Responsible**
    
    
    - Text field. Case-sensitive.
- **Strategy1**
    
    
    - Text field. Case-sensitive.
- **Portfolio To**
    
    
    - Text field. Case-sensitive.
    - For FX Forward (Open)/FX Forward (Expiration) transactions values should be “`-`" (dash).
- **Account To (Cash)**
    
    
    - Text field. Case-sensitive.
    - For FX Forward (Open)/FX Forward (Expiration) transactions values should be “`-`" (dash).
- **Account To (Position)**
    
    
    - Text field. Case-sensitive.
    - For FX Forward (Open)/FX Forward (Expiration) transactions values should be “`-`" (dash).
- **Position size New**
    
    
    - Numeric field.
    - For FX Forward (Open)/FX Forward (Expiration) transactions values should be “`0`" (zero).
- **Principal/Share price New**
    
    
    - Numeric field.
    - For FX Forward (Open)/FX Forward (Expiration) transactions values should be “`0`" (zero).

#### Split/Reverse Split

- **Transaction ID**
    
    
    - Text field. Case-sensitive.
    - A unique complex transaction identifier (only one in the workspace).
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="17179"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Transactions with repeated ID will be overwritten.
- **Transaction Type**
    
    
    - Text field. Case-sensitive.
    - Type of a transaction.
    - Should be a value from Standard transaction types for Transactions.
    - For Split/Reverse Split transactions values should be:
        
        
        - `Split`
        - `Reverse Split`
- **Reverse**
    
    
    - Text field.
    - Indicator for a reverse transaction.
    - Valid values:
        
        
        - `True`
        - `False`
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="17572"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> This field has only indicative meaning and will NOT invert any signs in other fields.
- **Date (Accounting)**
    
    
    - Date field.
    - A date on which a particular financial transaction was entered into the source system.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="2034"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Trade)**
    
    
    - Date field.
    - A date on which a particular financial transaction is executed or agreed upon.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="17780"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Value)**
    
    
    - Date field.
    - A date when cash or funds are expected to be received or paid as part of a financial transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="17971"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Portfolio**
    
    
    - Text field. Case-sensitive.
    - A collection of financial assets or investments held by an individual or organization.
- **Account (Cash)**
    
    
    - Text field. Case-sensitive.
    - An account that is specifically designated for managing and tracking cash transactions.
- **Currency (Settlement)**
    
    
    - Text field. Case-sensitive.
    - A currency in which the payment or transfer of funds takes place to fulfil the terms of the transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="18472"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be an alphabetic code of a currency alphabetic code (e.g. `USD`, `EUR`, `CHF`).
- **Cash Consideration**
    
    
    - Numeric field.
    - A monetary value or payment made in the form of cash for a particular transaction or asset.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="18695"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for income
        - “`-`" (minus sign) is for expenses
- **Amount (Charges)**
    
    
    - Numeric field.
    - Costs or fees associated with a transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="20336"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for income
        - “`-`" (minus sign) is for expenses
- **Account (Position)**
    
    
    - Text field. Case-sensitive.
    - An account that tracks and records the positions or holdings of assets.
- **Instrument**
    - Text field. Case-sensitive.
    - A financial asset or security involved in a transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="19067"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Value must be:
        
        
        - ISIN (e.g. `GB00BFZNLB60`) to import Instrument from Finmars Database
        - user\_code - for instruments without ISIN or already created instruments.
- **Allocation (PL)**
    
    
    - Text field. Case-sensitive.
    - An instrument to which the financial outcome of a transaction is attributed or allocated.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="11100"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Value must be:
        
        
        - ISIN (e.g. `GB00BFZNLB60`) to import Instrument from Finmars Database
        - user\_code - for instruments without ISIN or already created instruments.
- **Position size**
    
    
    - Numeric field.
    - An adjusted position of the asset after all alterations or corrections (e.g. adjusted for a factor).
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for position increase
        - “`-`" (minus sign) is for position decrease
- **Principal/Share price**
    
    
    - Numeric field.
    - For Split/Reverse Split transactions this field is a Principal price:
        
        
        - A unit price or value of a financial instrument, excluding any accrued interest or additional earnings.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="19718"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="19755"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Multipliers will be applied automatically in accordance with an instrument of the transaction.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for standard prices
        - “`-`" (minus sign) is for special prices (e.g. for exotic derivatives)
- **Amount (Carry)**
    
    
    - Numeric field.
    - An amount or expense that has been incurred but not yet paid or settled.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="20113"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for income
        - “`-`" (minus sign) is for expenses
- **Notes**
    
    
    - Text field.
    - Additional comments, instructions, or relevant information associated with a particular transaction.
    - If there are no notes enter “-” (dash).
- **Payment Purpose (for Income/Expense)**
    
    
    - Text field. Case-sensitive.
    - For Split/Reverse Split transactions values should be “-" (dash).
- **Reference transaction code**
    
    
    - Text field. Case-sensitive.
    - A reference to related transactions' unique identifiers.
    - For reverse transaction you can specify a transaction ID of the reversed transaction.
- **Counterparty**
    
    
    - Text field. Case-sensitive.
- **Responsible**
    
    
    - Text field. Case-sensitive.
- **Strategy1**
    
    
    - Text field. Case-sensitive.
- **Portfolio To**
    
    
    - Text field. Case-sensitive.
    - For Split/Reverse Split transactions values should be “`-`" (dash).
- **Account To (Cash)**
    
    
    - Text field. Case-sensitive.
    - For Split/Reverse Split transactions values should be “`-`" (dash).
- **Account To (Position)**
    
    
    - Text field. Case-sensitive.
    - For Split/Reverse Split transactions values should be “`-`" (dash).
- **Position size New**
    
    
    - Numeric field.
    - A new (e.g. after Corporate Action) quantity or size of an asset or instrument after any changes or corrections made to the nominal position. With sign of instrument movement (+ is for increase, - is for decrese).
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for position increase
        - “`-`" (minus sign) is for position decrease
- **Principal/Share price New**
    
    
    - Numeric field.
    - For Split/Reverse Split transactions this field is a Principal price:
        
        
        - A new (e.g. after Corporate Action) unit price or value of a financial instrument, excluding any accrued interest or additional earnings.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="19718"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="19755"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Multipliers will be applied automatically in accordance with an instrument of the transaction.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for standard prices
        - “`-`" (minus sign) is for special prices (e.g. for exotic derivatives)

### Positions Initial/Daily

- To book a position in the system you can import it from a file, what differentiate Initial from Daily is Import Schemes, use corresponding.
- One position is one row of data in the file.
- You should enter a position in the file for import in accordance with the instructions below for supported standard transaction types.
- Supported **Standard transaction types for Positions Initial/Daily** list (case-sensitive): 
    - **Positions Initial/Daily (different schemes use the same selectors):**
        
        
        - `Position Cash`
        - `Position Instrument`
        - `Position FX Forward`

#### Position Cash

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

- **Transaction ID**
    
    
    - Text field. Case-sensitive.
    - A unique complex transaction identifier (only one in the workspace).
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="39379"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Transactions with repeated ID will be overwritten.
- **Transaction Type**
    
    
    - Text field. Case-sensitive.
    - Type of a transaction.<mark aria-disabled="true" class="cc-4skef7" data-has-focus="false" data-id="272e32f9-d381-4711-b565-dc4e6de3cfa6" data-is-hovered="false" data-mark-annotation-state="resolved" data-mark-annotation-type="inlineComment" data-mark-type="annotation" data-renderer-mark="true" id="bkmrk-.-2"></mark>
    - Should be a value from Standard transaction types for Positions.
    - For Position Cash transactions values should be:
        
        
        - `Position Cash`
- **Date (Accounting)**
    
    
    - Date field.
    - A date on which a particular financial transaction was entered into the source system.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="2034"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Trade)**
    
    
    - Date field.
    - A date on which a particular financial transaction is executed or agreed upon.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="39984"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Value)**
    
    
    - Date field.
    - A date when cash or funds are expected to be received or paid as part of a financial transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="40175"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="40231"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> For Position Cash transactions:
        
        
        - `Date (Value)` should be equal to `Date (Trade)`
- **Portfolio**
    
    
    - Text field. Case-sensitive.
    - A collection of financial assets or investments held by an individual or organization.
- **Account (Cash)**
    
    
    - Text field. Case-sensitive.
    - An account that is specifically designated for managing and tracking cash transactions.
- **Currency (Settlement)**
    
    
    - Text field. Case-sensitive.
    - A currency in which the payment or transfer of funds takes place to fulfil the terms of the transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="40763"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be an alphabetic code of a currency alphabetic code (e.g. `USD`, `EUR`, `CHF`).
- **Cash Consideration**
    
    
    - Numeric field.
    - A monetary value or payment made in the form of cash for a particular transaction or asset.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="40986"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for income
        - “`-`" (minus sign) is for expenses
- **Account (Position)**
    
    
    - Text field. Case-sensitive.
    - For Position Cash transactions values should be “`-`" (dash).
- **Instrument**
    
    
    - Text field. Case-sensitive.
    - For Position Cash transactions values should be “`-`" (dash).
- **Position size**
    
    
    - Numeric field.
    - For Position Cash transactions values should be “`0`" (zero).
- **Principal/Share price**
    
    
    - Numeric field.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="41498"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> For Position Cash transactions:
        
        
        - The share price of the open-end fund.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="41580"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> For Position Cash transactions values should be “`0`" (zero) for default.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for standard prices
        - “`-`" (minus sign) is for special prices (e.g. for exotic derivatives)
- **Amount (Carry)**
    
    
    - Numeric field.
    - For Position Cash transactions values should be “`0`" (zero).
- **Notes**
    
    
    - Text field.
    - Additional comments, instructions, or relevant information associated with a particular transaction.
    - If there are no notes enter “`-`" (dash).

#### Position Instrument

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

- **Transaction ID**
    
    
    - Text field. Case-sensitive.
    - A unique complex transaction identifier (only one in the workspace).
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="42768"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Transactions with repeated ID will be overwritten.
- **Transaction Type**
    
    
    - Text field. Case-sensitive.
    - Type of a transaction.
    - Should be a value from Standard transaction types for Positions.
    - For Position Instrument transactions values should be:
        
        
        - `Position Instrument`
- **Date (Accounting)**
    
    
    - Date field.
    - A date on which a particular financial transaction was entered into the source system.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="2034"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Trade)**
    
    
    - Date field.
    - A date on which a particular financial transaction is executed or agreed upon.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="43385"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Value)**
    
    
    - Date field.
    - A date when cash or funds are expected to be received or paid as part of a financial transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="43576"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="43632"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> For Position Instrument transactions:
        
        
        - `Date (Value)` should be equal to `Date (Trade)`
- **Portfolio**
    
    
    - Text field. Case-sensitive.
    - A collection of financial assets or investments held by an individual or organization.
- **Account (Cash)**
    
    
    - Text field. Case-sensitive.
    - An account that is specifically designated for managing and tracking cash transactions.
- **Currency (Settlement)**
    
    
    - Text field. Case-sensitive.
    - A currency in which the payment or transfer of funds takes place to fulfil the terms of the transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="44170"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be an alphabetic code of a currency alphabetic code (e.g. `USD`, `EUR`, `CHF`).
- **Cash Consideration**
    
    
    - Numeric field.
    - A monetary value or payment made in the form of cash for a particular transaction or asset.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="44393"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for income
        - “`-`" (minus sign) is for expenses
- **Account (Position)**
    
    
    - Text field. Case-sensitive.
    - An account that tracks and records the positions or holdings of assets.
- **Instrument**
    - Text field. Case-sensitive.
    - A financial asset or security involved in a transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="44765"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Value must be:
        
        
        - ISIN (e.g. `GB00BFZNLB60`) to import Instrument from Finmars Database
        - user\_code - for instruments without ISIN or already created instruments.
- **Position size**
    
    
    - Numeric field.
    - An adjusted position of the asset after all alterations or corrections (e.g. adjusted for a factor).
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for position increase
        - “`-`" (minus sign) is for position decrease
- **Principal/Share price**
    
    
    - Numeric field.
    - For Position Instrument transactions this field is a Principal price:
        
        
        - A unit price or value of a financial instrument, excluding any accrued interest or additional earnings.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="45427"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="45464"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Multipliers will be applied automatically in accordance with an instrument of the transaction.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for standard prices
        - “`-`" (minus sign) is for special prices (e.g. for exotic derivatives)
- **Amount (Carry)**
    
    
    - Numeric field.
    - An amount or expense that has been incurred but not yet paid or settled.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="45822"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **Settlement Currency**.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for income
        - “`-`" (minus sign) is for expenses
- **Notes**
    
    
    - Text field.
    - Additional comments, instructions, or relevant information associated with a particular transaction.
    - If there are no notes enter “-” (dash).

#### Position FX Forward

- **Transaction ID**
    
    
    - Text field. Case-sensitive.
    - A unique complex transaction identifier (only one in the workspace).
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="46857"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Transactions with repeated ID will be overwritten.
- **Transaction Type**
    
    
    - Text field. Case-sensitive.
    - Type of a transaction.<mark aria-disabled="true" class="cc-4skef7" data-has-focus="false" data-id="272e32f9-d381-4711-b565-dc4e6de3cfa6" data-is-hovered="false" data-mark-annotation-state="resolved" data-mark-annotation-type="inlineComment" data-mark-type="annotation" data-renderer-mark="true" id="bkmrk-.-4"></mark>
    - Should be a value from Standard transaction types for Positions.
    - For Position FX Forward transactions values should be:
        
        
        - `Position FX Forward`
- **Date (Accounting)**
    
    
    - Date field.
    - A date on which a particular financial transaction was entered into the source system.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="2034"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Trade)**
    
    
    - Date field.
    - A date on which a particular financial transaction is executed or agreed upon.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="47474"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Date (Value)**
    
    
    - Date field.
    - A date when cash or funds are expected to be received or paid as part of a financial transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="47665"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Portfolio**
    
    
    - Text field. Case-sensitive.
    - A collection of financial assets or investments held by an individual or organization.
- **Account (Cash)**
    
    
    - Text field. Case-sensitive.
    - An account that is specifically designated for managing and tracking cash transactions.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="37342"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png) For Position FX Forward transactions:</span></span></span>
        
        
        - An account for the quote currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
- **Currency (Settlement)**
    
    
    - Text field. Case-sensitive.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="49309"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> For Position FX Forward transactions:
        
        
        - A quote currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="49780"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be an alphabetic code of a currency alphabetic code (e.g. `USD`, `EUR`, `CHF`).
- **Cash Consideration**
    
    
    - Numeric field.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="49309"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> For Position FX Forward transactions:
        
        
        - An amount of a quote currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
    - A sign of the number:
        
        
        - “+” (plus sign) is for position increase
        - “-” (minus sign) is for position decrease
- **Account (Position)**
    
    
    - Text field. Case-sensitive.
    - An account that is specifically designated for managing and tracking cash transactions.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="37342"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png) For Position FX Forward transactions:</span></span></span>
        
        
        - An account for the base currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
- **Instrument**
    
    
    - Text field.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="48031"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> For Position FX Forward transactions:
        
        
        - A base currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="48171"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be an alphabetic code of a currency alphabetic code (e.g. `USD`, `EUR`, `CHF`).
- **Position size**
    
    
    - Numeric field.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="48294"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> For Position FX Forward transactions:
        
        
        - An amount of a base currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for position increase
        - “`-`" (minus sign) is for position decrease
- **Principal/Share price**
    
    
    - Numeric field.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="48294"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png) </span></span></span>For Position FX Forward transactions:
        
        
        - An exchange rate used for a contract’s foreign exchange transaction, where Sell currency is the Quote currency and Buy currency is the Base currency (e.g. we sell 110 USD and buy 100 EUR, then the field’s value should be 1.1 EUR/USD).
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for standard prices
        - “`-`" (minus sign) is for special prices (e.g. for exotic derivatives)
- **Amount (Carry)**
    
    
    - Numeric field.
    - For Position FX Forward transactions values should be “`0`" (zero).
- **Notes**
    
    
    - Text field.
    - Additional comments, instructions, or relevant information associated with a particular transaction.
    - If there are no notes enter “`-`" (dash).

### Instruments

#### Instruments

- **Instrument ID**
    
    
    - Text field. Case-sensitive.
    - A unique user\_code for a financial asset or security involved in a transaction.
- **ISIN**
    
    
    - Text field. Case-sensitive.
    - An identification code assigned to a financial instrument (e.g. `GB00BFZNLB60`).
- **Pricing Currency**
    
    
    - Text field. Case-sensitive.
    - A currency in which the valuation or pricing of a financial instrument is expressed.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="51485"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be an alphabetic code of a currency alphabetic code (e.g. `USD`, `EUR`, `CHF`).
- **Instrument Type**
    - Text field. Case-sensitive.
    - A user-friendly name for a instrument type of financial asset or security involved in a transaction (may influence view forms).
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="50693"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Valid values:
        
        
        - `Bond`
        - `CDS`
        - `CFD`
        - `Deposit`
        - `Derivative`
        - `Forward`
        - `FX Forward Leg`
        - `Loan`
        - `Option`
        - `Other`
        - `Portfolio`
        - `Stock`
        - `T-Bill`
- **Asset Type**
    
    
    - Text field. Case-sensitive.
    - A user-friendly name for an asset type financial asset or security involved in a transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="50693"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Valid values:
        
        
        - `Alternative Investments`
        - `Cash & Equivalents`
        - `Commodities`
        - `Crypto`
        - `Debt`
        - `Derivatives`
        - `Equipment`
        - `Equity`
        - `Other`
        - `Real Estate`
        - `Transport`
- **Name**
    
    
    - Text field. Case-sensitive.
    - A name of the entity.
- **Short Name**
    
    
    - Text field. Case-sensitive.
    - A short name of the entity.
- **Public Name**
    
    
    - Text field. Case-sensitive.
    - A public name of the entity. Will be shown instead of Name if user has no right to see this entity.
- **Description**
    - Text field. Case-sensitive.
    - Additional comments, instructions, or relevant information associated with a particular instrument.
    - If there are no notes enter “`-`" (dash).
- **Country**
    
    
    - Text field. Case-sensitive.
    - A country of a financial instrument.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="51269"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be iso 3 symbols country alphabetic code (e.g. `LUX`, `GBR`, `USA`).
- **Price Multiplier**
    
    
    - Numeric field.
    - A factor applied to adjust the nominal value of certain assets. For example, in the context of bonds, a price multiplier of 0.01 is used to convert the quoted price to its actual value.
- **Maturity Date**
    
    
    - Date field.
    - A date on which a financial instrument (e.g. bond or certificate of deposit) reaches the end of its term.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="51953"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Maturity Price**
    - Numeric field.
    - A unit price or value of a financial instrument, excluding any accrued interest or additional earnings effective after and including **Maturity Date**.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="55459"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **instrument Pricing Currency**.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="55496"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Multipliers will be applied automatically in accordance with an instrument of the transaction.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for standard prices
        - “`-`" (minus sign) is for special prices (e.g. for exotic derivatives)
- **FIGI (ex. BBGID)**
    
    
    - Text field. Case-sensitive.
    - An identification code assigned to a financial instrument (e.g. `BBG000C6K6G9`).
- **CUSIP**
    
    
    - Text field. Case-sensitive.
    - An identification code assigned to a financial instrument (e.g. `02079K107`).
- **SEDOL**
    
    
    - Text field. Case-sensitive.
    - An identification code assigned to a financial instrument (e.g. `0540528`).
- **ISIN 144A**
    
    
    - Text field. Case-sensitive.
    - An identification code assigned to a financial instrument (e.g. `US89855VAA89`).
- **Accrued Currency**
    
    
    - Text field. Case-sensitive.
    - A currency in which the accrued of a financial instrument is expressed.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="51485"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be an alphabetic code of a currency alphabetic code (e.g. `USD`, `EUR`, `CHF`).
- **Accrued Multiplier**
    
    
    - Numeric field.
    - A factor applied to adjust the nominal accrued value of certain assets. For example, in the context of bonds, an accrued multiplier of 0.01 is used to convert the quoted accrued price to its actual value.
- **Exposure Currency (Codirectional)**
    
    
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="51485"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png) Not implemented.</span></span></span>
    - Text field. Case-sensitive.
    - A currency in which the codirectional exposure of a financial instrument is expressed.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="51485"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be an alphabetic code of a currency alphabetic code (e.g. `USD`, `EUR`, `CHF`).
- **Exposure Currency (Counterdirectional)**
    
    
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="51485"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png) Not implemented.</span></span></span>
    - Text field. Case-sensitive.
    - A currency in which the counterdirectional exposure of a financial instrument is expressed.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="51485"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be an alphabetic code of a currency alphabetic code (e.g. `USD`, `EUR`, `CHF`).
- **Default Price**
    - Numeric field.
    - A unit price or value of a financial instrument, excluding any accrued interest or additional earnings which is used for creating Price History entity for this instrument if the price is not specified (None).
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="55459"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **instrument Pricing Currency**.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="55496"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Multipliers will be applied automatically in accordance with an instrument of the transaction.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for standard prices
        - “`-`" (minus sign) is for special prices (e.g. for exotic derivatives)
- **Last Update Date**
    
    
    - Date field.
    - A date on which was a financial instrument's last update.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="51953"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")

#### Instruments Accrual Schedules

- **Instrument ID**
    
    
    - Text field. Case-sensitive.
    - A unique user\_code for a financial asset or security involved in a transaction.
- **Accrual ID**
    
    
    - Text field. Case-sensitive.
    - ID of accrual schedule entries (unique in one Instrument, may repeat for different instruments).
- **Accrual Start Date**
    
    
    - Date field.
    - A date on which a financial instrument starts accrual.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="52478"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **First Payment Date**
    
    
    - Date field.
    - A date on which a financial instrument has its first accrual payment.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="52647"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Accrual Calculation Model**
    
    
    - Text field. Case-sensitive.
    - A user code of the Day Count Convention a.k.a. Accrual Calculation Model (drop-down valid values in Excel).
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="52877"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Valid values (as per 2024-07-19 see reference in Finmars API like *https://ADDRESS/REALM\_CODE/SPACE\_CODE/api/v1/instruments/accrual-calculation-model/*):
        
        
        - `DAY_COUNT_30_360_ISDA`
        - `DAY_COUNT_30_360_ISMA`
        - `DAY_COUNT_30_360_GERMAN`
        - `DAY_COUNT_30_360_US`
        - `DAY_COUNT_30_365`
        - `DAY_COUNT_30E_PLUS_360`
        - `DAY_COUNT_30E_360`
        - `DAY_COUNT_ACT_360`
        - `DAY_COUNT_ACT_364`
        - `DAY_COUNT_ACT_365`
        - `DAY_COUNT_ACT_365A`
        - `DAY_COUNT_ACT_365_FIXED`
        - `DAY_COUNT_ACT_365L`
        - `DAY_COUNT_ACT_366`
        - `DAY_COUNT_ACT_ACT_AFB`
        - `DAY_COUNT_ACT_ACT_ICMA`
        - `DAY_COUNT_ACT_ACT_ISDA`
        - `DAY_COUNT_BD_252`
        - `DAY_COUNT_NL_365`
        - `NONE`
        - `DAY_COUNT_SIMPLE`
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="53514"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> `NONE` is only applicable for Periodicity with defined N for example:
        
        
        - `Periodicity=N_DAY` and `Periodicity N=35`
- **Periodicity**
    
    
    - Text field. Case-sensitive.
    - A user code of the Periodicity (drop-down valid values in Excel).
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="53764"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Valid values (as per 2024-07-19 see reference in Finmars API like *https://ADDRESS/REALM\_CODE/SPACE\_CODE/api/v1/instruments/periodicity/*):
        
        
        - `-`
        - `ANNUALLY`
        - `BIMONTHLY`
        - `MONTHLY`
        - `N_DAY`
        - `N_MONTH_EOM`
        - `N_MONTH_SAME_DAY`
        - `N_WEEK_EOBW`
        - `N_YEAR_EOY`
        - `N_YEAR_SAME_DAY`
        - `QUARTERLY`
        - `SEMI_ANNUALLY`
        - `WEEKLY`
- **Periodicity N**
    
    
    - Numeric field.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="54131"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Only applicable for Periodicity with defined N, for example:
        
        
        - `Accrual Calculation Model=N_DAY` and `Periodicity N=35`.
- **Accrual Size, %**
    
    
    - Numeric field.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="54297"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Accrual size is in %, so that you need to input 5 for 5% and NOT 0.05.
- **End of Month**
    
    
    - Text field.
    - Indicator for a payment in the End of Month.
    - Valid values:
        
        
        - `True`
        - `False`
- **Notes**
    
    
    - Text field.
    - Additional comments, instructions, or relevant information.
    - If there are no notes enter “`-`" (dash).

#### Instruments Factor Schedules

- **Instrument ID**
    
    
    - Text field. Case-sensitive.
    - A unique user\_code for a financial asset or security involved in a transaction.
- **Factor ID**
    
    
    - Text field. Case-sensitive.
    - ID of factor schedule entries (unique in one Instrument, may repeat for different instruments).
- **Date**
    
    
    - Date field.
    - A date on which a financial instrument set the factor.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="54886"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Factor**
    
    
    - Numeric field.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="54973"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Factor size is of float type, so that you need to input 0.5 for 50% and NOT 50.

### Prices<span class="heading-anchor-wrapper" role="presentation"><button aria-hidden="false" aria-label="Copy link to heading" class="cc-1r0b9w7" data-testid="anchor-button" tabindex="-1" type="button"><span aria-label="Copy" class="cc-1afrefi" data-vc="icon-undefined" role="img"><svg height="24" role="presentation" viewbox="0 0 24 24" width="24"><g fill="currentcolor" fill-rule="evenodd"><path d="m12.856 5.457-.937.92a1 1 0 0 0 0 1.437 1.047 1.047 0 0 0 1.463 0l.984-.966c.967-.95 2.542-1.135 3.602-.288a2.54 2.54 0 0 1 .203 3.81l-2.903 2.852a2.646 2.646 0 0 1-3.696 0l-1.11-1.09L9 13.57l1.108 1.089c1.822 1.788 4.802 1.788 6.622 0l2.905-2.852a4.558 4.558 0 0 0-.357-6.82c-1.893-1.517-4.695-1.226-6.422.47"></path><path d="m11.144 19.543.937-.92a1 1 0 0 0 0-1.437 1.047 1.047 0 0 0-1.462 0l-.985.966c-.967.95-2.542 1.135-3.602.288a2.54 2.54 0 0 1-.203-3.81l2.903-2.852a2.646 2.646 0 0 1 3.696 0l1.11 1.09L15 11.43l-1.108-1.089c-1.822-1.788-4.802-1.788-6.622 0l-2.905 2.852a4.558 4.558 0 0 0 .357 6.82c1.893 1.517 4.695 1.226 6.422-.47"></path></g></svg></span></button></span>

- **Date**
    
    
    - Date field.
    - A date of valuation.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="55121"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Instrument ID**
    
    
    - Text field. Case-sensitive.
    - A unique user\_code for a financial asset or security involved in a transaction.
- **Principal Price**
    
    
    - Numeric field.
    - A unit price or value of a financial instrument, excluding any accrued interest or additional earnings.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="55459"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **instrument Pricing Currency**.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="55496"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Multipliers will be applied automatically in accordance with an instrument of the transaction.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for standard prices
        - “`-`" (minus sign) is for special prices (e.g. for exotic derivatives)
- **Accrued Price**
    
    
    - Numeric field.
    - A unit price or value of accrued interest or other earnings of a financial instrument.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="55867"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **accrued currency**.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="55901"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Multipliers will be applied automatically in accordance with an instrument of the transaction.
    - A sign of the number:
        
        
        - “`+`" (plus sign) is for standard prices
        - “`-`" (minus sign) is for special prices (e.g. for exotic derivatives)
- **Factor**
    
    
    - Numeric field.
    - A multiplicative factor applied to the nominal or face value of a security, such as bonds or other financial instruments to adjust its value for various purposes.
    - Must NOT be negative.
- **YTM**
    
    
    - Numeric field.
    - Yield to maturity.
- **Modified Duration**
    
    
    - Numeric field.
- **Pricing Policy**
    
    
    - Text field. Case-sensitive.
    - A unique user\_code for a container which determines what set of prices and fx rates to use for valuation.
- **is\_temporary\_price**
    - Text field.
    - Indicator for a modified price (e.g. or auto populated by rolling).
    - Valid values:
        
        
        - `True`
        - `False`
- **long\_delta**
    
    
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="51485"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png) Not implemented.</span></span></span>
- **short\_delta**
    
    
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="51485"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png) Not implemented.</span></span></span>

### FX Rates

- **Date**
    
    
    - Date field.
    - A date of valuation.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="56581"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Format should be: “YYYY-MM-DD” (e.g. “`2000-12-31`")
- **Currency ID**
    
    
    - Text field. Case-sensitive.
    - A currency that is being purchased in a foreign exchange transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="56758"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be an alphabetic code of a currency alphabetic code (e.g. `USD`, `EUR`, `CHF`).
- **FX Rate**
    
    
    - Numeric field.
    - An exchange rate used for a foreign exchange transaction.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="56937"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **USD** (USD must be quoted currency).
    - Must NOT be negative.
- **Pricing Policy**
    
    
    - Text field. Case-sensitive.
    - A unique user\_code for a container which determines what set of prices and fx rates to use for valuation.

### Other Entities

#### Currencies

- **Currency ID**
    
    
    - Text field. Case-sensitive.
    - Unique user code of the entity.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="17179"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Entities with repeated ID will be overwritten.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="56758"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be an alphabetic code of a currency alphabetic code (e.g. `USD`, `EUR`, `CHF`).
- **Name**
    
    
    - Text field. Case-sensitive.
    - A name of the entity.
- **Short Name**
    
    
    - Text field. Case-sensitive.
    - A short name of the entity.
- **Public Name**
    
    
    - Text field. Case-sensitive.
    - A public name of the entity. Will be shown instead of Name if user has no right to see this entity.
- **Country**
    
    
    - Text field. Case-sensitive.
    - A currency's country of origin.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="51269"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be iso 3 symbols country alphabetic code (e.g. `LUX`, `GBR`, `USA`).
- **Notes**
    
    
    - Text field.
    - Additional comments, instructions, or relevant information.
    - If there are no notes enter “`-`" (dash).
- **Pricing Reference**
    
    
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="51485"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png) Not implemented.</span></span></span>
- **Pricing Condition**
    
    
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="51485"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png) Not implemented.</span></span></span>
- **Default FX Rate**
    - Numeric field.
    - A unit fx rate or value of a currency which is used for creating Currency History entity for this currency if the fx rate is not specified (None).
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="56937"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Must be in **USD** (USD must be quoted currency).
    - Must NOT be negative.

#### Accounts

- **Account ID**
    
    
    - Text field. Case-sensitive.
    - Unique user code of the entity.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="17179"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Entities with repeated ID will be overwritten.
- **Name**
    
    
    - Text field. Case-sensitive.
    - A name of the entity.
- **Short Name**
    
    
    - Text field. Case-sensitive.
    - A short name of the entity.
- **Public Name**
    
    
    - Text field. Case-sensitive.
    - A public name of the entity. Will be shown instead of Name if user has no right to see this entity.
- **Notes**
    
    
    - Text field.
    - Additional comments, instructions, or relevant information.
    - If there are no notes enter “`-`" (dash).
- **Account Type ID**
    
    
    - Text field. Case-sensitive.
    - Unique user code of the entity's type which is used for aggregation, no functional impact.

#### Portfolios

- **Portfolio ID**
    
    
    - Text field. Case-sensitive.
    - Unique user code of the entity.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="17179"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Entities with repeated ID will be overwritten.
- **Name**
    
    
    - Text field. Case-sensitive.
    - A name of the entity.
- **Short Name**
    
    
    - Text field. Case-sensitive.
    - A short name of the entity.
- **Public Name**
    
    
    - Text field. Case-sensitive.
    - A public name of the entity. Will be shown instead of Name if user has no right to see this entity.
- **Notes**
    
    
    - Text field.
    - Additional comments, instructions, or relevant information.
    - If there are no notes enter “`-`" (dash).
- **Portfolio Type ID**
    
    
    - Text field. Case-sensitive.
    - Unique user code of the entity's type which is used to classify portfolios between: 
        - General (`com.finmars.standard-other:portfolios.portfoliotype:general`)
        - Manual (`com.finmars.standard-other:portfolios.portfoliotype:manual`)
        - Positional (`com.finmars.standard-other:portfolios.portfoliotype:position`)
- **Register Pricing Policy**
    
    
    - Text field. Case-sensitive.
    - A unique user\_code for a container which determines what set of prices and fx rates to use for valuation.
- **Register Currency**
    
    
    - Text field. Case-sensitive.
    - A user code of a currency that is being used in portfolio valuation.
- **Register Instrument Type**
    - Text field. Case-sensitive.
    - A user code for an instrument type of a register.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="50693"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Recommended and default is: `com.finmars.standard-instrument-type:portfolio` .

#### Counterparties

- **Counterparty ID**
    
    
    - Text field. Case-sensitive.
    - Unique user code of the entity.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="17179"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Entities with repeated ID will be overwritten.
- **Name**
    
    
    - Text field. Case-sensitive.
    - A name of the entity.
- **Short Name**
    
    
    - Text field. Case-sensitive.
    - A short name of the entity.
- **Public Name**
    
    
    - Text field. Case-sensitive.
    - A public name of the entity. Will be shown instead of Name if user has no right to see this entity.
- **Notes**
    
    
    - Text field.
    - Additional comments, instructions, or relevant information.
    - If there are no notes enter “`-`" (dash).
- **Counterparty Type ID**
    
    
    - Text field. Case-sensitive.
    - Unique user code of the entity's type which is used for aggregation, no functional impact.

#### Responsibles

- **Responsible ID**
    
    
    - Text field. Case-sensitive.
    - Unique user code of the entity.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="17179"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Entities with repeated ID will be overwritten.
- **Name**
    
    
    - Text field. Case-sensitive.
    - A name of the entity.
- **Short Name**
    
    
    - Text field. Case-sensitive.
    - A short name of the entity.
- **Public Name**
    
    
    - Text field. Case-sensitive.
    - A public name of the entity. Will be shown instead of Name if user has no right to see this entity.
- **Notes**
    
    
    - Text field.
    - Additional comments, instructions, or relevant information.
    - If there are no notes enter “`-`" (dash).
- **Responsible Type ID**
    
    
    - Text field. Case-sensitive.
    - Unique user code of the entity's type which is used for aggregation, no functional impact.

#### Strategies

- **Strategy ID**
    
    
    - Text field. Case-sensitive.
    - Unique user code of the entity.
    - <span data-annotation-inline-node="true" data-annotation-mark="true" data-renderer-start-pos="17179"><span data-emoji-id="atlassian-warning" data-emoji-short-name=":warning:" data-emoji-text=":warning:"><span class="emoji-common-main-styles emoji-common-node   emoji-common-emoji-image   cc-9fkst0" data-emoji-type="image" data-testid="image-emoji-:warning:" title=":warning:">![Warning](https://pf-emoji-service--cdn.us-east-1.prod.public.atl-paas.net/atlassian/productivityEmojis/exclamation-32px.png)</span></span></span> Entities with repeated ID will be overwritten.
- **Name**
    
    
    - Text field. Case-sensitive.
    - A name of the entity.
- **Short Name**
    
    
    - Text field. Case-sensitive.
    - A short name of the entity.
- **Public Name**
    
    
    - Text field. Case-sensitive.
    - A public name of the entity. Will be shown instead of Name if user has no right to see this entity.
- **Notes**
    
    
    - Text field.
    - Additional comments, instructions, or relevant information.
    - If there are no notes enter “`-`" (dash).
- **Strategy Type ID**
    
    
    - Text field. Case-sensitive.
    - Unique user code of the entity's type which is used for aggregation, no functional impact.

# Check Transaction Report

## Prerequisites

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

1. [Get Access to Finmars](https://docs.finmars.com/books/user-quick-start/page/get-access-to-finmars)
2. [Link with Finmars ID](https://docs.finmars.com/books/user-quick-start/page/link-with-finmars-id "https://docs.finmars.com/books/user-quick-start/page/link-with-finmars-id")
3. [Install PMS Core or PMS Plus add-on](https://docs.finmars.com/books/user-quick-start/page/install-pms-core-or-pms-plus-add-on)
4. [How to Import Files in PMS Core and PMS Plus](https://docs.finmars.com/books/user-quick-start/page/import-files-in-pms-core-and-pms-plus "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](https://docs.finmars.com/uploads/images/gallery/2025-04/scaled-1680-/snimok-ekrana-2025-04-02-135648.png)](https://docs.finmars.com/uploads/images/gallery/2025-04/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-04/scaled-1680-/snimok-ekrana-2025-04-02-140342.png)](https://docs.finmars.com/uploads/images/gallery/2025-04/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-04/scaled-1680-/snimok-ekrana-2025-04-02-141545.png)](https://docs.finmars.com/uploads/images/gallery/2025-04/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-04/scaled-1680-/snimok-ekrana-2025-04-02-154903.png)](https://docs.finmars.com/uploads/images/gallery/2025-04/snimok-ekrana-2025-04-02-154903.png)
5. After adjusting these settings, confirm by clicking OK.  
    [![Снимок экрана 2025-04-02 190428.png](https://docs.finmars.com/uploads/images/gallery/2025-04/scaled-1680-/snimok-ekrana-2025-04-02-190428.png)](https://docs.finmars.com/uploads/images/gallery/2025-04/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-04/scaled-1680-/snimok-ekrana-2025-04-02-190639.png)](https://docs.finmars.com/uploads/images/gallery/2025-04/snimok-ekrana-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](https://docs.finmars.com/books/user-quick-start/page/duplicate-the-layout "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](https://docs.finmars.com/uploads/images/gallery/2025-04/scaled-1680-/snimok-ekrana-2025-04-02-190927.png)](https://docs.finmars.com/uploads/images/gallery/2025-04/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-04/scaled-1680-/snimok-ekrana-2025-04-02-191103.png)](https://docs.finmars.com/uploads/images/gallery/2025-04/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-04/scaled-1680-/snimok-ekrana-2025-04-02-191213.png)](https://docs.finmars.com/uploads/images/gallery/2025-04/snimok-ekrana-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](https://docs.finmars.com/books/user-quick-start/page/get-access-to-finmars)
2. [Link with Finmars ID](https://docs.finmars.com/books/user-quick-start/page/link-with-finmars-id "https://docs.finmars.com/books/user-quick-start/page/link-with-finmars-id")
3. [Install PMS Core or PMS Plus add-on](https://docs.finmars.com/books/user-quick-start/page/install-pms-core-or-pms-plus-add-on)
4. [How to Import Files in PMS Core and PMS Plus](https://docs.finmars.com/books/user-quick-start/page/import-files-in-pms-core-and-pms-plus "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 -&gt; PMS** here go to the **Helper** tab and open **Calculate Price History** section.  
    [![image.png](https://docs.finmars.com/uploads/images/gallery/2025-09/scaled-1680-/gFUimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-09/gFUimage.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](https://docs.finmars.com/uploads/images/gallery/2025-09/scaled-1680-/FoEimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-09/FoEimage.png)
5. In the right frame you will have execution info, click **Refresh** to get updates.  
    [![image.png](https://docs.finmars.com/uploads/images/gallery/2025-09/scaled-1680-/tDDimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-09/tDDimage.png)
6. **Refresh** and read **Log** and wait for **Result**. See successful run example below:   
    [![image.png](https://docs.finmars.com/uploads/images/gallery/2025-09/scaled-1680-/8vJimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-09/8vJimage.png)

# Check Balance Report

## Prerequisites

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

1. [Get Access to Finmars](https://docs.finmars.com/books/user-quick-start/page/get-access-to-finmars)
2. [Link with Finmars ID](https://docs.finmars.com/books/user-quick-start/page/link-with-finmars-id "https://docs.finmars.com/books/user-quick-start/page/link-with-finmars-id")
3. [Install PMS Core or PMS Plus add-on](https://docs.finmars.com/books/user-quick-start/page/install-pms-core-or-pms-plus-add-on)
4. [How to Import Files in PMS Core and PMS Plus](https://docs.finmars.com/books/user-quick-start/page/import-files-in-pms-core-and-pms-plus "How to Import Files in PMS Core and PMS Plus")
5. [How to Do Calculations for YTM and Modified Duration](https://docs.finmars.com/books/user-quick-start/page/calculate-ytm-and-modified-duration "How to Do Calculations for YTM and Modified Duration") (if you need YTM &amp; 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](https://docs.finmars.com/uploads/images/gallery/2025-02/scaled-1680-/snimok-ekrana-2025-02-07-171212.png)](https://docs.finmars.com/uploads/images/gallery/2025-02/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-02/scaled-1680-/snimok-ekrana-2025-02-20-221302.png)](https://docs.finmars.com/uploads/images/gallery/2025-02/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-02/scaled-1680-/snimok-ekrana-2025-02-10-202249.png)](https://docs.finmars.com/uploads/images/gallery/2025-02/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-02/scaled-1680-/snimok-ekrana-2025-02-10-202438.png)](https://docs.finmars.com/uploads/images/gallery/2025-02/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-02/scaled-1680-/snimok-ekrana-2025-02-10-202818.png)](https://docs.finmars.com/uploads/images/gallery/2025-02/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-02/scaled-1680-/vvv.png)](https://docs.finmars.com/uploads/images/gallery/2025-02/vvv.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](https://docs.finmars.com/books/user-quick-start/page/duplicate-the-layout "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](https://docs.finmars.com/uploads/images/gallery/2025-02/scaled-1680-/snimok-ekrana-2025-02-13-174438.png)](https://docs.finmars.com/uploads/images/gallery/2025-02/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-02/scaled-1680-/snimok-ekrana-2025-02-11-144520.png)](https://docs.finmars.com/uploads/images/gallery/2025-02/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-02/scaled-1680-/snimok-ekrana-2025-02-11-144637.png)](https://docs.finmars.com/uploads/images/gallery/2025-02/snimok-ekrana-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](https://docs.finmars.com/books/user-quick-start/page/get-access-to-finmars)
2. [Link with Finmars ID](https://docs.finmars.com/books/user-quick-start/page/link-with-finmars-id "https://docs.finmars.com/books/user-quick-start/page/link-with-finmars-id")
3. [Install PMS Core or PMS Plus add-on](https://docs.finmars.com/books/user-quick-start/page/install-pms-core-or-pms-plus-add-on)
4. [Import Files in PMS Core and PMS Plus](https://docs.finmars.com/books/user-quick-start/page/import-files-in-pms-core-and-pms-plus "Import Files in PMS Core and PMS Plus")
5. [How to Do Calculations for YTM and Modified Duration](https://docs.finmars.com/books/user-quick-start/page/calculate-ytm-and-modified-duration "How to Do Calculations for YTM and Modified Duration") (if you need YTM &amp; Modified Duration)

## Check the Profit and Loss Report

1. Go to the left sidebar. Locate and select the **Report** section and click on **P&amp;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](https://docs.finmars.com/uploads/images/gallery/2025-02/scaled-1680-/snimok-ekrana-2025-02-12-172029.png)](https://docs.finmars.com/uploads/images/gallery/2025-02/snimok-ekrana-2025-02-12-172029.png)
2. Once on the **P&amp;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&amp;L report for Week To Date you need to select Report Date: Previous Week End -&gt; 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](https://docs.finmars.com/uploads/images/gallery/2025-02/scaled-1680-/snimok-ekrana-2025-02-22-143842.png)](https://docs.finmars.com/uploads/images/gallery/2025-02/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-02/scaled-1680-/snimok-ekrana-2025-02-12-172457.png)](https://docs.finmars.com/uploads/images/gallery/2025-02/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-02/scaled-1680-/snimok-ekrana-2025-02-12-172715.png)](https://docs.finmars.com/uploads/images/gallery/2025-02/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-02/scaled-1680-/snimok-ekrana-2025-02-12-173011.png)](https://docs.finmars.com/uploads/images/gallery/2025-02/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-02/scaled-1680-/snimok-ekrana-2025-02-22-150347.png)](https://docs.finmars.com/uploads/images/gallery/2025-02/snimok-ekrana-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](https://docs.finmars.com/books/user-quick-start/page/duplicate-the-layout "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](https://docs.finmars.com/uploads/images/gallery/2025-02/scaled-1680-/snimok-ekrana-2025-02-13-183836.png)](https://docs.finmars.com/uploads/images/gallery/2025-02/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-02/scaled-1680-/snimok-ekrana-2025-02-13-184705.png)](https://docs.finmars.com/uploads/images/gallery/2025-02/snimok-ekrana-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&amp;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](https://docs.finmars.com/books/user-quick-start/page/get-access-to-finmars)
2. [Link with Finmars ID](https://docs.finmars.com/books/user-quick-start/page/link-with-finmars-id "https://docs.finmars.com/books/user-quick-start/page/link-with-finmars-id")
3. [Install PMS Core or PMS Plus add-on](https://docs.finmars.com/books/user-quick-start/page/install-pms-core-or-pms-plus-add-on)
4. [How to Import Files in PMS Core and PMS Plus](https://docs.finmars.com/books/user-quick-start/page/import-files-in-pms-core-and-pms-plus "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 -&gt; PMS** here go to the **Helper** tab and open **Calculate Register Records** section.  
    [![image.png](https://docs.finmars.com/uploads/images/gallery/2025-09/scaled-1680-/3jQimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-09/3jQimage.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](https://docs.finmars.com/uploads/images/gallery/2025-09/scaled-1680-/Bhzimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-09/Bhzimage.png)
5. In the right frame you will have execution info, click **Refresh** to get updates.  
    [![image.png](https://docs.finmars.com/uploads/images/gallery/2025-09/scaled-1680-/Fnsimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-09/Fnsimage.png)
6. **Refresh** and read **Log** and wait for **Result**. See successful run example below:   
    [![image.png](https://docs.finmars.com/uploads/images/gallery/2025-09/scaled-1680-/FgHimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-09/FgHimage.png)

# Check Performance Report

## Prerequisites

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

1. [Get Access to Finmars](https://docs.finmars.com/books/user-quick-start/page/get-access-to-finmars)
2. [Link with Finmars ID](https://docs.finmars.com/books/user-quick-start/page/link-with-finmars-id "https://docs.finmars.com/books/user-quick-start/page/link-with-finmars-id")
3. [Install PMS Core or PMS Plus add-on](https://docs.finmars.com/books/user-quick-start/page/install-pms-core-or-pms-plus-add-on)
4. [How to Import Files in PMS Core and PMS Plus](https://docs.finmars.com/books/user-quick-start/page/import-files-in-pms-core-and-pms-plus "How to Import Files in PMS Core and PMS Plus")
5. [How to Do Calculations for YTM and Modified Duration](https://docs.finmars.com/books/user-quick-start/page/calculate-ytm-and-modified-duration "How to Do Calculations for YTM and Modified Duration") (if you need YTM &amp; Modified Duration)
6. [How to Do Calculations for Performance (Modified Dietz)](https://docs.finmars.com/books/user-quick-start/page/calculate-performance-modified-dietz "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](https://docs.finmars.com/uploads/images/gallery/2025-02/scaled-1680-/snimok-ekrana-2025-02-28-162745.png)](https://docs.finmars.com/uploads/images/gallery/2025-02/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-02/scaled-1680-/snimok-ekrana-2025-02-28-162911.png)](https://docs.finmars.com/uploads/images/gallery/2025-02/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-02/scaled-1680-/snimok-ekrana-2025-02-28-163009.png)](https://docs.finmars.com/uploads/images/gallery/2025-02/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-02/scaled-1680-/snimok-ekrana-2025-02-28-163146.png)](https://docs.finmars.com/uploads/images/gallery/2025-02/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-02/scaled-1680-/snimok-ekrana-2025-02-28-163306.png)](https://docs.finmars.com/uploads/images/gallery/2025-02/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-02/scaled-1680-/snimok-ekrana-2025-02-28-163422.png)](https://docs.finmars.com/uploads/images/gallery/2025-02/snimok-ekrana-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](https://docs.finmars.com/books/user-quick-start/page/get-access-to-finmars)
2. [Link with Finmars ID](https://docs.finmars.com/books/user-quick-start/page/link-with-finmars-id "https://docs.finmars.com/books/user-quick-start/page/link-with-finmars-id")
3. [Install PMS Core or PMS Plus add-on](https://docs.finmars.com/books/user-quick-start/page/install-pms-core-or-pms-plus-add-on)
4. [How to Import Files in PMS Core and PMS Plus](https://docs.finmars.com/books/user-quick-start/page/import-files-in-pms-core-and-pms-plus "How to Import Files in PMS Core and PMS Plus")
5. [How to Do Calculations for YTM and Modified Duration](https://docs.finmars.com/books/user-quick-start/page/calculate-ytm-and-modified-duration "How to Do Calculations for YTM and Modified Duration")
6. [How to Do Calculations for Performance (Modified Dietz)](https://docs.finmars.com/books/user-quick-start/page/calculate-performance-modified-dietz "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 -&gt; PMS** here go to the **Helper** tab and open **Calculate Portfolio History** section.  
    [![image.png](https://docs.finmars.com/uploads/images/gallery/2025-09/scaled-1680-/eiwimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-09/eiwimage.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](https://docs.finmars.com/uploads/images/gallery/2025-09/scaled-1680-/HrQimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-09/HrQimage.png)
5. In the right frame you will have execution info, click **Refresh** to get updates.  
    [![image.png](https://docs.finmars.com/uploads/images/gallery/2025-09/scaled-1680-/oqqimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-09/oqqimage.png)
6. **Refresh** and read **Log** and wait for **Result**. See successful run example below:   
    [![image.png](https://docs.finmars.com/uploads/images/gallery/2025-09/scaled-1680-/GPfimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-09/GPfimage.png)

# Check Standard Dashboards

## Prerequisites

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

1. [Get Access to Finmars](https://docs.finmars.com/books/user-quick-start/page/get-access-to-finmars)
2. [Link with Finmars ID](https://docs.finmars.com/books/user-quick-start/page/link-with-finmars-id "https://docs.finmars.com/books/user-quick-start/page/link-with-finmars-id")
3. [Install PMS Core or PMS Plus add-on](https://docs.finmars.com/books/user-quick-start/page/install-pms-core-or-pms-plus-add-on)
4. [How to Import Files in PMS Core and PMS Plus](https://docs.finmars.com/books/user-quick-start/page/import-files-in-pms-core-and-pms-plus "How to Import Files in PMS Core and PMS Plus")
5. [How to Do Calculations for YTM and Modified Duration](https://docs.finmars.com/books/user-quick-start/page/calculate-ytm-and-modified-duration "How to Do Calculations for YTM and Modified Duration")
6. [How to Do Calculations for Performance (Modified Dietz)](https://docs.finmars.com/books/user-quick-start/page/calculate-performance-modified-dietz "How to Do Calculations for Performance (Modified Dietz)")
7. [Calculate data for Mobile/Dashboards](https://docs.finmars.com/books/user-quick-start/page/calculate-data-for-mobiledashboards "Calculate data for Mobile/Dashboards")

## Check Standard Dashboards

1. Go to the **Dashboard** tab in the left-side menu.  
    [![Снимок экрана 2025-02-24 220143.png](https://docs.finmars.com/uploads/images/gallery/2025-02/scaled-1680-/snimok-ekrana-2025-02-24-220143.png)](https://docs.finmars.com/uploads/images/gallery/2025-02/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-02/scaled-1680-/snimok-ekrana-2025-02-24-215900.png)](https://docs.finmars.com/uploads/images/gallery/2025-02/snimok-ekrana-2025-02-24-215900.png)
3. From this dropdown, select the standard dashboard you want to check.   
    [![image.png](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/ujMimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/ujMimage.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&amp;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&amp;L YTD, Return YTD, Cash Inflow/Outflow YTD**

#### Cards

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

- NAV YTD
- P&amp;L YTD
- Return YTD (showed only for 1 selected Portfolio)
- Cash Inflow YTD
- Cash Outflow YTD

#### Balance by Category

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

[![111.png](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/111.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/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](https://docs.finmars.com/uploads/images/gallery/2025-04/scaled-1680-/snimok-ekrana-2025-04-10-014945.png)](https://docs.finmars.com/uploads/images/gallery/2025-04/snimok-ekrana-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&amp;L by Category

 Displays a bar chart showing the profit and loss distribution across different accounts.  
[![Снимок экрана 2025-03-12 125612.png](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/snimok-ekrana-2025-03-12-125612.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-04/scaled-1680-/snimok-ekrana-2025-04-10-015524.png)](https://docs.finmars.com/uploads/images/gallery/2025-04/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/snimok-ekrana-2025-03-12-152155.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-04/scaled-1680-/snimok-ekrana-2025-04-10-020109.png)](https://docs.finmars.com/uploads/images/gallery/2025-04/snimok-ekrana-2025-04-10-020109.png)

You can select category for a graph.

[![Снимок экрана 2025-04-10 020123.png](https://docs.finmars.com/uploads/images/gallery/2025-04/scaled-1680-/snimok-ekrana-2025-04-10-020123.png)](https://docs.finmars.com/uploads/images/gallery/2025-04/snimok-ekrana-2025-04-10-020123.png)

**Chart Type Options:**

1. **Column Chart** – Displays historical balances as bar charts.  
    [![image.png](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/1mkimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/1mkimage.png)
2. **Line Chart** (default) – Shows trends over time with connected data points.  
    [![image.png](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/sWsimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/sWsimage.png)
3. **Table** – Converts the visual chart into a tabular format for numerical analysis.  
    [![image.png](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/mxpimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/mxpimage.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&amp;L History by Category

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

[![Снимок экрана 2025-03-12 152949.png](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/snimok-ekrana-2025-03-12-152949.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/snimok-ekrana-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&amp;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](https://docs.finmars.com/uploads/images/gallery/2025-04/scaled-1680-/snimok-ekrana-2025-04-10-015707.png)](https://docs.finmars.com/uploads/images/gallery/2025-04/snimok-ekrana-2025-04-10-015707.png)

You can select category for a graph.

[![Снимок экрана 2025-04-10 015932.png](https://docs.finmars.com/uploads/images/gallery/2025-04/scaled-1680-/snimok-ekrana-2025-04-10-015932.png)](https://docs.finmars.com/uploads/images/gallery/2025-04/snimok-ekrana-2025-04-10-015932.png)

**Chart Type Options:**

1. **Column Chart** – Represents P&amp;L data using vertical bars.  
    [![image.png](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/bzQimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/bzQimage.png)
2. **Line Chart** (default) – Shows P&amp;L trends over time using connected data points.  
    [![image.png](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/wTAimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/wTAimage.png)
3. **Table** – Converts the graph into a tabular format for numerical analysis.  
    [![image.png](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/KKWimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/KKWimage.png)

**Download Options:**

1. **Download PNG** – Saves the chart as an image file for reporting purposes.
2. **Download CSV** – Exports the P&amp;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](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/a9Zimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/a9Zimage.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](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/d4gimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/d4gimage.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](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/frrimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/frrimage.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](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/snimok-ekrana-2025-03-12-222155.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-04/scaled-1680-/image.png)](https://docs.finmars.com/uploads/images/gallery/2025-04/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](https://docs.finmars.com/books/user-quick-start/page/check-balance-report "How to Check Balance Report").

[![Снимок экрана 2025-04-01 182917.png](https://docs.finmars.com/uploads/images/gallery/2025-04/scaled-1680-/snimok-ekrana-2025-04-01-182917.png)](https://docs.finmars.com/uploads/images/gallery/2025-04/snimok-ekrana-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 &amp; 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](https://docs.finmars.com/books/user-quick-start/page/check-transaction-report "How To Check Transaction Report")[ Report](https://docs.finmars.com/books/user-quick-start/page/check-transaction-report "How To Check Transaction Report").

[![Снимок экрана 2025-04-01 183135.png](https://docs.finmars.com/uploads/images/gallery/2025-04/scaled-1680-/snimok-ekrana-2025-04-01-183135.png)](https://docs.finmars.com/uploads/images/gallery/2025-04/snimok-ekrana-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 &amp; Loss (P&amp;S) Layout

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

#### Filter Panel

At the top of the **P&amp;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&amp;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](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/XYeimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/XYeimage.png)

#### Matrix Component Editor (P&amp;L)

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

[![Снимок экрана 2025-03-12 223408.png](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/snimok-ekrana-2025-03-12-223408.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-04/scaled-1680-/8YUimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-04/8YUimage.png)

#### P&amp;L Report

Linked to Matrix, if you click on a P&amp;L Item, it will show related P&amp;L items. For usage details, refer to [How to Check Profit and Loss Report](https://docs.finmars.com/books/user-quick-start/page/check-profit-and-loss-report "How to Check Profit and Loss Report").

[![Снимок экрана 2025-04-01 182119.png](https://docs.finmars.com/uploads/images/gallery/2025-04/scaled-1680-/snimok-ekrana-2025-04-01-182119.png)](https://docs.finmars.com/uploads/images/gallery/2025-04/snimok-ekrana-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&amp;L details in the selected pricing currency.
7. **Instrument Type** – Filters results by specific instrument categories.

#### P&amp;L Transactions Report 

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

[![Снимок экрана 2025-04-01 182142.png](https://docs.finmars.com/uploads/images/gallery/2025-04/scaled-1680-/snimok-ekrana-2025-04-01-182142.png)](https://docs.finmars.com/uploads/images/gallery/2025-04/snimok-ekrana-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. 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](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/FVDimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/FVDimage.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](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/nYIimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/nYIimage.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](https://docs.finmars.com/books/user-quick-start/page/import-files-in-pms-core-and-pms-plus "How to Import Files in PMS Core and PMS Plus")

[![image.png](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/cQ4image.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/cQ4image.png)

# Use Mobile App [TO BE UPDATED]

## Prerequisites

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

1. [Get Access to Finmars](https://docs.finmars.com/books/user-quick-start/page/get-access-to-finmars)
2. [Link with Finmars ID](https://docs.finmars.com/books/user-quick-start/page/link-with-finmars-id "https://docs.finmars.com/books/user-quick-start/page/link-with-finmars-id")
3. [Install PMS Core or PMS Plus add-on](https://docs.finmars.com/books/user-quick-start/page/install-pms-core-or-pms-plus-add-on)
4. [How to Import Files in PMS Core and PMS Plus](https://docs.finmars.com/books/user-quick-start/page/import-files-in-pms-core-and-pms-plus "How to Import Files in PMS Core and PMS Plus")
5. [How to Do Calculations for YTM and Modified Duration](https://docs.finmars.com/books/user-quick-start/page/calculate-ytm-and-modified-duration "How to Do Calculations for YTM and Modified Duration")
6. [How to Do Calculations for Performance (Modified Dietz)](https://docs.finmars.com/books/user-quick-start/page/calculate-performance-modified-dietz "How to Do Calculations for Performance (Modified Dietz)")
7. [Calculate data for Mobile/Dashboards](https://docs.finmars.com/books/user-quick-start/page/calculate-data-for-mobiledashboards "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](https://eu-central.finmars.com).

[![image.png](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/Touimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/Touimage.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](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/snimok-ekrana-2025-03-24-152911.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/jeTimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/jeTimage.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](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/tcRimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/tcRimage.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](https://docs.finmars.com/uploads/images/gallery/2025-04/scaled-1680-/4aUimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-04/4aUimage.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](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/MHCimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/MHCimage.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](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/w74image.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/w74image.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](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/qpeimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/qpeimage.png)

1. **Date Selection**- choose a specific date for generating financial reports.
2. **Period Type- s**elect 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** **&amp; 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.

##### **<span class="is-markup" data-markup="markup-bold" dir="auto">The Balance Tab</span>**

[![image.png](https://docs.finmars.com/uploads/images/gallery/2025-04/scaled-1680-/i2Aimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-04/i2Aimage.png)

The <span class="is-markup" data-markup="markup-bold" dir="auto">Balance</span> tab consists of the following sections:

1. <span class="is-markup" data-markup="markup-bold" dir="auto">Net Asset Value (NAV)- </span>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)](https://docs.finmars.com/books/user-quick-start/page/calculate-performance-modified-dietz)
        2. [How to Do Calculations for Mobile](https://docs.finmars.com/books/user-quick-start/page/calculate-data-for-mobiledashboards)
2. <span class="is-markup" data-markup="markup-bold" dir="auto">Instrument Type Breakdown- </span>categorizes your portfolio into different investment types: 
    1. <span class="is-markup" data-markup="markup-bold" dir="auto">Cash &amp; Equivalents</span> – Liquid assets such as cash or money market funds.
    2. <span class="is-markup" data-markup="markup-bold" dir="auto">Bonds</span> – Fixed-income securities.
    3. <span class="is-markup" data-markup="markup-bold" dir="auto">Stocks</span> – Equities or shares in companies.
    4. <span class="is-markup" data-markup="markup-bold" dir="auto">Other</span> – Any additional investment instruments.
3. If you scroll down within the <span class="is-markup" data-markup="markup-bold" dir="auto">Balance</span> 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](https://docs.finmars.com/uploads/images/gallery/2025-04/scaled-1680-/9c7image.png)](https://docs.finmars.com/uploads/images/gallery/2025-04/9c7image.png)

##### **<span class="is-markup" data-markup="markup-bold" dir="auto">The P&amp;L Tab</span>**

[![image.png](https://docs.finmars.com/uploads/images/gallery/2025-04/scaled-1680-/nq2image.png)](https://docs.finmars.com/uploads/images/gallery/2025-04/nq2image.png)

After you can navigate to the <span class="is-markup" data-markup="markup-bold" dir="auto">P&amp;L (Profit &amp; Loss)</span> 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 &amp; 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](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/ktKimage.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/ktKimage.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 &amp; 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](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/hH3image.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/hH3image.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.

- It enables users to enter keywords such as **asset names, portfolio IDs, account numbers, or transaction types**.
- As you type, results dynamically update to match your query.

# Duplicate the Layout

## Prerequisites

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

1. [Get Access to Finmars](https://docs.finmars.com/books/user-quick-start/page/get-access-to-finmars)
2. [Link with Finmars ID](https://docs.finmars.com/books/user-quick-start/page/link-with-finmars-id "https://docs.finmars.com/books/user-quick-start/page/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](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/snimok-ekrana-2025-03-04-061527.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/snimok-ekrana-2025-03-04-061756.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/snimok-ekrana-2025-03-04-062415.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/snimok-ekrana-2025-03-04-061909.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/snimok-ekrana-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](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/snimok-ekrana-2025-03-13-123409.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/snimok-ekrana-2025-03-13-123409.png)
6. After choosing a new name, click **Save** to confirm the changes.  
    [![Снимок экрана 2025-03-13 123717.png](https://docs.finmars.com/uploads/images/gallery/2025-03/scaled-1680-/snimok-ekrana-2025-03-13-123717.png)](https://docs.finmars.com/uploads/images/gallery/2025-03/snimok-ekrana-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](https://docs.finmars.com/books/user-quick-start/page/get-access-to-finmars)
2. You have the internet access

## Getting License for add-ons

1. <span style="white-space: pre-wrap;">As of now contact </span>**sales@finmars.com**