---
title: How do I build custom reports?
description: Kooltra provides the flexibility to building custom reports for viewing and extracting any data captured in the system. This article explains how to build these reports.
---

[Skip to content](https://help.kooltra.com/knowledge-base/understanding-reportng#main-content)

English

Show submenu for translations

[Customer portal](https://help.kooltra.com/client-portal?hsLang=en)

![Kooltra\_Logo\_Green\_Eggplant\_RGB-1](https://help.kooltra.com/hs-fs/hubfs/Kooltra_Logo_Green_Eggplant_RGB-1.webp?width=200&height=67&name=Kooltra_Logo_Green_Eggplant_RGB-1.webp)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [Customer portal](https://help.kooltra.com/client-portal)
- [Go to Kooltra Platform](https://kooltracore.cloudforce.com/)

[Go to Kooltra Platform](https://kooltracore.cloudforce.com/)

 Search the knowledge base

- There are no suggestions because the search field is empty.

1. [Knowledge Base](https://help.kooltra.com/knowledge-base?hsLang=en)
2. [Reporting](https://help.kooltra.com/knowledge-base/reporting?hsLang=en)
3. [Custom Reports](https://help.kooltra.com/knowledge-base/reporting?hsLang=en#custom-reports)

# How do I build custom reports?

## Kooltra provides the flexibility to building custom reports for viewing and extracting any data captured in the system. This article explains how to build these reports.

### Introduction

As [Kooltra is built on Salesforce](https://help.kooltra.com/knowledge-base/does-kooltra-come-with-salesforce?hsLang=en), this is all possible via Salesforce’s powerful reporting tools that can be used to build, save and organise custom reports around any data captured by the Kooltra application (subject to user permissions in accessing this data).

### **How to Access Custom Reports**

To access the custom reporting functionality from Kooltra, go to *Reporting \> Custom Reports* in the left-hand navigation panel (below). This will launch the Reports module of the Salesforce Lightning Experience.

![custom reports](https://help.kooltra.com/hs-fs/hubfs/custom%20reports.png?width=120&height=310&name=custom%20reports.png)

### **Salesforce Reports & Dashboards**

To learn how to build custom reports within Salesforce, please see the ‘Reports & Dashboards for Lightning Experience’ guide, provided by the Salesforce learning resource ‘Trailhead’ below:

[![](https://trailhead.salesforce.com/favicon-16x16.png)Reports & Dashboards for Lightning Experience](https://trailhead.salesforce.com/en/content/learn/modules/lex_implementation_reports_dashboards)

This guide covers the following topics:

- Introduction to Reports and Dashboards in Lightning Experience
- Create Reports with the Report Builder
- Format Reports
- Visualize Your Data with the Lightning Dashboard Builder

Once you understand how to build reports within Salesforce, the key to creating your report successfully is understanding the Kooltra data model and which Report Types should be used to access what data.

### **Which Report Types to use**

When building a custom report within Salesforce, the first thing you will have to specify is the Report Type.

Which Report Type to select depends on the data you wish to report on; all data captured in Kooltra can be reported on, but using the right Report Type is crucial. 

The main report types used to access key Kooltra data are detailed below:

#### Accounts with Cashflows

Use the *Accounts and Cashflows* Report Type if you wish to report on cash movements and associated counterparty information.

The **Account** object relates to **Counterparties** in Kooltra and is used to store information pertaining to clients or liquidity providers.

The **Cashflow** object is used to store information on trade settlements and cash adjustments. 

#### FxTrades with Counterparty

Use the *FxTrades with Counterparty* report type if you wish to report on trades and the associated counterparty information.

The **FxTrade** object is used to store information on Spot, Forward, Window Forward, NDF and Swap Trades. 

#### Accounts with Cashflows and FxTrade

Use the *Accounts with Cashflows and FxTrade* report type if you wish to report on cash movements and associated trades and counterparty information.

#### Cashflows with Vostro / Cashflows with Nostro

Use the *Cashflows with Vostro* or *Cashflow with Nostro* report type if you wish to report on information relating to cash movements and associated Vostros or Nostros respectively.

The [Nostro](https://help.kooltra.com/knowledge-base/understanding-nostros-and-vostros?hsLang=en) object is used to store information about cash accounts owned by you, either as a balance held with a liquidity provider or a bank.

The [Vostro](https://help.kooltra.com/knowledge-base/understanding-nostros-and-vostros?hsLang=en) object is used to store information about cash accounts belonging to one of your clients or counterparties.

### Report Fields

Once you have selected the Report Type corresponding with the data you want to report on, the next step is adding fields to the report to show the information you are looking for.

The tables below highlight some of the most common fields used when building custom reports

#### FxTrade Fields

| **Field Name** | **Description** |
| --- | --- |
| FxTrade: Trade Name | The ticket number corresponding with the FX trade in Kooltra e.g. 1234.0 |
| Counterparty | The name of the Account the trade has been executed against |
| Type | Type of trade from *FX SPOT*, *FX FORWARD*, *FX SWAP*, *FX NDF*, *FX WINDOW FORWARD* |
| Subtype | Sub Category of the trade.  Used predominantly in swap tickets.  Values include: Rollover, Drawdown |
| Action | Shows Buy / Sell direction of the FX trade |
| DealtCurrency | ‘Traded Currency’. Currency that was bought or sold. |
| Request | Provides the ID of the associated electronic RFQ/RFS request |
| Status | The current status of the FX trade from: Open, Closed, Cancelled |
| TradeDate | Date the FX trade was executed, in the format dd/mm/yyyy |
| ValueDate | Date the FX trade is due for settlement, in the format dd/mm/yyyy |
| Currency1 | First currency in the traded pair. For example for a USDCAD trade, this would show USD |
| Currency2 | Second currency in the traded pair. For example for a USDCAD trade, this would show CAD |
| Currency1Amount | Notional amount of Currency1 on the trade |
| Currency2Amount | Notional amount of Currency2 on the trade |
| CurrencyPair | The currency pair traded |
| Rate | The exchange rate the FX trade was executed at |
| HedgeRate | The market rate used to hedge the FX trade with LPs |
| SpreadPL | P&L in Currency2 resulting from the difference between the Rate (client executed price) and HedgeRate (LP hedge price) |
| SpreadPLInEntityBase | Spread P&L converted back into Entity case currency |
| Fee | Shows any fees associated with the FX trade |
| USDtransactedvalue | DealtCurrency notional amount converted to USD |
| EntitybaseTransactedValue | DealtCurrency notional amount converted to base currency |

 

#### Cashflow Fields

| **Field Name** | **Description** |
| --- | --- |
| Cashflow Name | The Kooltra  cashflow ID number e.g. 1234.C0 |
| Type | Type of Cashflow from: - Wire-In - Wire-Out - Vostro Credit - Vostro Debit - Vostro Transfer - Nostro Credit - Nostro Debit - Nostro Transfer - Settlement |
| Subtype | Subtype of the Cashflow as defined in Kooltra under *System -\> Entity Settings -\> Cashflow tab* |
| Currency | Currency of the cashflow |
| Status | Status of the Cashflow from: - Open - Pending - Closed - Cancelled |
| ProcessTime | This field represents the date and time the cashflow settled into the Nostro/Vostro account. It represents the actual settlement date of the Cashflow. |
| InitialProcessTime | This field represents the date and time that the instruction to release the cashflow was made. This may or may not be the same as Process Date.  For example: Treasury cuts a cheque for a client on 13th Aug and the client deposits the check on 17th Aug. In this case the Initial Process Time would be Aug 13th and the Process Time would be August 17th. |
| ValueDate | Anticipated settlement date of the Cashflow. This is set at the time the cashflow is created and represents the target date for settlement.  When booked during the gross settlement flow (client [Settlement Type](https://help.kooltra.com/knowledge-base/understanding-counterparty-settlement-types?hsLang=en) = Payments), the value date on the cashflow defaults to the value date of the trade. |
| Nostro | Name of the [Nostro](https://help.kooltra.com/knowledge-base/understanding-nostros-and-vostros?hsLang=en) assigned to the cashflow for settlement |
| NostroAmount | Amount to be added / debited from the Nostro when the cashflow is processed |
| NostroBalance | Holds the snapshot of the new Nostro balance after the cashflow is processed |
| Vostro | Name of the [Vostro](https://help.kooltra.com/knowledge-base/understanding-nostros-and-vostros?hsLang=en) account assigned to the cashflow for settlement |
| VostroAmount | Amount to be added / debited from the Vostro when the cashflow is processed |
| VostroBalance | Holds the snapshot of the new Vostro balance as a result of the cashflow being processed |
| Instruction | Name of the [Beneficiary](https://help.kooltra.com/knowledge-base/adding-and-managing-a-beneficiary?hsLang=en) that is the sender or recipient of the cashflow |
| SettlementMethod | The method of settlement assigned to the cashflow from a defined list. Default possible values are: - ACH - Cheque - Draft - Wire - Bill Payment - Cheque (Driver) - Cheque (Drop off / Pick Up) - Cheque (Fedex) - Direct Deposit - Draft (Driver) - Draft (Drop off / Pick Up) - Draft (Fedex) - EFT - E-transfer *See [Understanding Settlement Methods](https://help.kooltra.com/knowledge-base/understanding?hsLang=en) for more details on the cashflow settlement types* |

 

#### Account Fields

| **Field Name** | **Description** |
| --- | --- |
| Status | Status of the counterparty from: - Active - Inactive - Pending - Pending Review - Closed - Suspended |
| Entity | Entity that the counterparty is saved under. Using the entity field as a filter is important if you are managing multiple business lines within Kooltra. |
| CashBalance | Net cash balance on account across the counterparty's assigned [Vostros / Nostros](https://help.kooltra.com/knowledge-base/understanding-nostros-and-vostros?hsLang=en), converted back to the counterparty's base currency |
| Group | Group that the counterparty has been assigned to, if specified |
| SettlementType | [Settlement Type](https://help.kooltra.com/knowledge-base/understanding-counterparty-settlement-types?hsLang=en) assigned to the counterparty. used by the Account. Options are: - Nostro - Payments - Vostro - Give Up - No Settlement |
| Counterparty Type | [Counterparty Type](https://help.kooltra.com/knowledge-base/understanding-counterparty-types?hsLang=en) from: - Individual - Company - Internal |

 

### Report Filters

Once you have built your custom report, you can apply filters to isolate the results to only those relevant to you. Any of the fields described above can be used to filter reports.

Some commonly used report filters are:

#### Dates

When trying to identify records that were created / modified / related to a particular date, various date filters can be applied including:

- Created Date
- ValueDate
- TradeDate
- Last Modified Date
- ProcessDate

For each of these it is possible to filter before / after / on specific dates, or filter based on relative dates such as ‘TODAY’, ‘TOMORROW’, ‘LAST WEEK’ etc by clicking on the link highlighted below:

![a80502c6-9473-4053-9844-17d5a80d26c3](https://help.kooltra.com/hs-fs/hubfs/a80502c6-9473-4053-9844-17d5a80d26c3.png?width=688&height=401&name=a80502c6-9473-4053-9844-17d5a80d26c3.png)

#### Settlement Type

The *Settlement Type* field can be used as a filter in custom reports to separate LP records from client records.

Filter for “*Account: SettlementType* equals *NOSTRO”* to view only LP activity.

Alternatively filtering by “*Account: SettlementType* not equal to *NOSTRO”* will ensure the report only displays client records.

#### Entity

If more than one Entity has been configured within Kooltra it is sometimes necessary to view information relating to just one of these. Use the Entity field as a filter to isolate the records pertaining to the entity/entities in question.

#### Status

Use the ‘Status’ filter on Accounts, Cashflows and FxTrades to view only the records that have the status in question. Examples of where this can be used are in identifying:

- Cancelled FxTrades / Cashflows
- Active Accounts
- Open FxTrades

 

- [Getting started](https://help.kooltra.com/knowledge-base/getting-started?hsLang=en#main-content)

    - [Kooltra Access](https://help.kooltra.com/knowledge-base/getting-started?hsLang=en#kooltra-access)
    - [Knowledge Resources](https://help.kooltra.com/knowledge-base/getting-started?hsLang=en#knowledge-resources)
    - [Entity Setup](https://help.kooltra.com/knowledge-base/getting-started?hsLang=en#entity-setup)
- [Client Journey at a Glance](https://help.kooltra.com/knowledge-base/client-journey-at-a-glance?hsLang=en#main-content)

    - [Onboarding and Client Setup](https://help.kooltra.com/knowledge-base/client-journey-at-a-glance?hsLang=en#onboarding-and-client-setup)
    - [Trading and Settlements](https://help.kooltra.com/knowledge-base/client-journey-at-a-glance?hsLang=en#trading-and-settlements)
- [Counterparty Management](https://help.kooltra.com/knowledge-base/counterparty-management?hsLang=en#main-content)

    - [Counterparty Setup & Management](https://help.kooltra.com/knowledge-base/counterparty-management?hsLang=en#counterparty-setup-management)
    - [Counterparty Overview](https://help.kooltra.com/knowledge-base/counterparty-management?hsLang=en#counterparty-overview)
    - [Beneficiaries](https://help.kooltra.com/knowledge-base/counterparty-management?hsLang=en#beneficiaries)
    - [Data Importing](https://help.kooltra.com/knowledge-base/counterparty-management?hsLang=en#data-importing)
- [Trading & Trade Management](https://help.kooltra.com/knowledge-base/trading-trade-management?hsLang=en#main-content)

    - [Trade Creation & Management](https://help.kooltra.com/knowledge-base/trading-trade-management?hsLang=en#trade-creation-management)
    - [Spread Groups](https://help.kooltra.com/knowledge-base/trading-trade-management?hsLang=en#spread-groups)
    - [Trade Blotters](https://help.kooltra.com/knowledge-base/trading-trade-management?hsLang=en#trade-blotters)
    - [Trade Matching](https://help.kooltra.com/knowledge-base/trading-trade-management?hsLang=en#trade-matching)
    - [Order Creation & Management](https://help.kooltra.com/knowledge-base/trading-trade-management?hsLang=en#order-creation-management)
- [Cash Management](https://help.kooltra.com/knowledge-base/cash-management?hsLang=en#main-content)

    - [Cashflows & Adjustments](https://help.kooltra.com/knowledge-base/cash-management?hsLang=en#cashflows-adjustments)
    - [Account Balances](https://help.kooltra.com/knowledge-base/cash-management?hsLang=en#account-balances)
    - [Settlements](https://help.kooltra.com/knowledge-base/cash-management?hsLang=en#settlements)
    - [Reconciliation](https://help.kooltra.com/knowledge-base/cash-management?hsLang=en#reconciliation)
- [Reporting](https://help.kooltra.com/knowledge-base/reporting?hsLang=en#main-content)

    - [Custom Reports](https://help.kooltra.com/knowledge-base/reporting?hsLang=en#custom-reports)
    - [Confirmations & Documentation](https://help.kooltra.com/knowledge-base/reporting?hsLang=en#confirmations-documentation)
- [Compliance](https://help.kooltra.com/knowledge-base/compliance?hsLang=en#main-content)

    - [Regulatory Reporting](https://help.kooltra.com/knowledge-base/compliance?hsLang=en#regulatory-reporting)
    - [Client Onboarding & KYC](https://help.kooltra.com/knowledge-base/compliance?hsLang=en#client-onboarding-kyc)
    - [Transaction Risk Monitoring](https://help.kooltra.com/knowledge-base/compliance?hsLang=en#transaction-risk-monitoring)
- [Risk Management](https://help.kooltra.com/knowledge-base/risk-management?hsLang=en#main-content)

    - [Client Margin](https://help.kooltra.com/knowledge-base/risk-management?hsLang=en#client-margin)
    - [Trading Limits](https://help.kooltra.com/knowledge-base/risk-management?hsLang=en#trading-limits)
    - [Credit Engine](https://help.kooltra.com/knowledge-base/risk-management?hsLang=en#credit-engine)
- [Payments Portal](https://help.kooltra.com/knowledge-base/payments-portal?hsLang=en#main-content)

    - [Trading & Cash Management](https://help.kooltra.com/knowledge-base/payments-portal?hsLang=en#trading-cash-management)
    - [Beneficiaries](https://help.kooltra.com/knowledge-base/payments-portal?hsLang=en#beneficiaries)
    - [Dealer Intervention](https://help.kooltra.com/knowledge-base/payments-portal?hsLang=en#dealer-intervention)
    - [Blotters & Reports](https://help.kooltra.com/knowledge-base/payments-portal?hsLang=en#blotters-reports)

[![Kooltra\_Logo\_Green\_Eggplant\_RGB-1](https://help.kooltra.com/hs-fs/hubfs/Kooltra_Logo_Green_Eggplant_RGB-1.webp?width=200&height=67&name=Kooltra_Logo_Green_Eggplant_RGB-1.webp "Kooltra_Logo_Green_Eggplant_RGB-1")](https://help.kooltra.com/?hsLang=en)

kooltra.com Help Center

Copyright © 2026, Kooltra, Ltd