---
title: Key Reports
description: This article explains how to run and use the FX Blotter for daily trade tracking and the Reconciliation Report for month-end data verification in CNS Treasury.
---

[Skip to content](https://kb.cnstreasury.com/cns-treasury-knowledge-base/key-reports#main-content)

English

Show submenu for translations

![Primary Logo png-Dec-18-2023-02-56-38-8732-AM.png\]](https://kb.cnstreasury.com/hs-fs/hubfs/Primary%20Logo%20png-Dec-18-2023-02-56-38-8732-AM.png?height=50&name=Primary%20Logo%20png-Dec-18-2023-02-56-38-8732-AM.png)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- Go to cnstreasury.com

 Go to cnstreasury.com

 Hello. How can we help you?

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

1. [CNS Treasury Knowledge Base](https://kb.cnstreasury.com/cns-treasury-knowledge-base?hsLang=en)
2. [Getting Started With CNS](https://kb.cnstreasury.com/cns-treasury-knowledge-base/getting-started-with-cns?hsLang=en)

# Key Reports

## This article explains how to run and use the FX Blotter for daily trade tracking and the Reconciliation Report for month-end data verification in CNS Treasury.

<iframe src="https://www.loom.com/embed/f7758bf02acd47db93249fdc2c52b0fb?sid=9ca07cd9-2682-4d19-a35e-91895f7a5787" frameborder="0" webkitallowfullscreen="" mozallowfullscreen="" allowfullscreen style="position: absolute; top: 0; left: 0; width: 100%; height: 100%;"></iframe>

 

#### **1. Overview**

While CNS Treasury provides a wide range of reports, the **FX Blotter** and **Reconciliation Report** are the core reports most users will run regularly.

- The FX Blotter acts as a “to-do list” for treasurers and CFOs.
- The Reconciliation Report is used at month-end to verify deal data before journal entries.

---

#### **2. FX Blotter Report**

**Purpose:**

- Track settlements, positions, orders, and overall FX exposure.
- Monitor order fills and their impact on your position.

**How to Run:**

1. Navigate to **View Reports → FX Blotter**.
2. Select the desired date or range.
3. Click **Run Report**.

**Key Features:**

- **Settlements:**
  
    - Lists trades settling on the selected date(s).
    - “Days to Maturity” column highlights upcoming settlements.
- **Positions:**
  
    - Displays overall position split by business unit and currency pair.
    - Distinguishes between Buy and Sell positions.
- **Order Tracking:**
  
    - Shows orders that have been filled.
    - CNS automation captures these orders and manages the full trade lifecycle.
- **Distance to Next Order Fill:**
  
    - Displays how far current rates are from your next order trigger.
- **Colour Coding:**
  
    - Highlights transactions in or out of the money.

**Recommended Frequency:**

- Once per day or at least several times a week.

---

#### **3. Reconciliation Report**

**Purpose:**

- Verify that deals in CNS match bank Mark-to-Market (MTM) records.
- Ensure all deal data is accurate before posting journal entries.

**When to Run:**

- At the end of each month, after receiving an email from CNS Operations confirming your reconciliation is ready.

**How to Run:**

1. Navigate to **View Reports → Reconciliation Report**.
2. Set **Start Date** and **End Date** to the same day (as specified in the CNS email).
3. Run the report.
4. Export to PDF or Excel if needed.

**What’s Checked:**

- Deal data from CNS against MTM files from your banks (e.g., ANZ, BNZ).
- Delivery dates, buy/sell currencies, amounts, and rates.

---

#### **4. Exporting Reports**

- All reports can be exported to Excel or PDF for sharing, archiving, or board reporting.

---

#### **5. Support**

For more details on available reports, see the CNS Knowledge Base or contact **support@cnstreasury.com**

- [Getting Started With CNS](https://kb.cnstreasury.com/cns-treasury-knowledge-base/getting-started-with-cns?hsLang=en)
- [User Guides](https://kb.cnstreasury.com/cns-treasury-knowledge-base/user-guides?hsLang=en#main-content)

    - [Bulk Upload](https://kb.cnstreasury.com/cns-treasury-knowledge-base/user-guides?hsLang=en#bulk-upload)
    - [CNS Treasury Dashboards](https://kb.cnstreasury.com/cns-treasury-knowledge-base/user-guides?hsLang=en#cns-treasury-dashboards)
    - [Entering Foreign Exchange Data](https://kb.cnstreasury.com/cns-treasury-knowledge-base/user-guides?hsLang=en#entering-foreign-exchange-data)
    - [Navigating our FX Hedge Accounting](https://kb.cnstreasury.com/cns-treasury-knowledge-base/user-guides?hsLang=en#navigating-our-fx-hedge-accounting)
- [FAQs](https://kb.cnstreasury.com/cns-treasury-knowledge-base/faqs?hsLang=en#main-content)

    - [Understanding Calculations in CNS](https://kb.cnstreasury.com/cns-treasury-knowledge-base/faqs?hsLang=en#understanding-calculations-in-cns)
    - [Hedge Accounting Workflows](https://kb.cnstreasury.com/cns-treasury-knowledge-base/faqs?hsLang=en#hedge-accounting-workflows)
    - [How to's?](https://kb.cnstreasury.com/cns-treasury-knowledge-base/faqs?hsLang=en#how-tos)
- [Foreign Exchange Module](https://kb.cnstreasury.com/cns-treasury-knowledge-base/foreign-exchange-module?hsLang=en#main-content)

    - [FX Instruments](https://kb.cnstreasury.com/cns-treasury-knowledge-base/foreign-exchange-module?hsLang=en#fx-instruments)
    - [Exposure Handling](https://kb.cnstreasury.com/cns-treasury-knowledge-base/foreign-exchange-module?hsLang=en#exposure-handling)
    - [Connectivity](https://kb.cnstreasury.com/cns-treasury-knowledge-base/foreign-exchange-module?hsLang=en#connectivity)
    - [FX Dashboard](https://kb.cnstreasury.com/cns-treasury-knowledge-base/foreign-exchange-module?hsLang=en#fx-dashboard)
    - [Pre-Trade Tools](https://kb.cnstreasury.com/cns-treasury-knowledge-base/foreign-exchange-module?hsLang=en#pre-trade-tools)
    - [FX Reporting](https://kb.cnstreasury.com/cns-treasury-knowledge-base/foreign-exchange-module?hsLang=en#fx-reporting)
    - [FX Hedge Accounting](https://kb.cnstreasury.com/cns-treasury-knowledge-base/foreign-exchange-module?hsLang=en#fx-hedge-accounting)
    - [Audit](https://kb.cnstreasury.com/cns-treasury-knowledge-base/foreign-exchange-module?hsLang=en#audit)
- [Hedge Accounting IFRS9 Compliance](https://kb.cnstreasury.com/cns-treasury-knowledge-base/hedge-accounting-ifrs9-compliance?hsLang=en#main-content)

    - [FX Hedge Accounting](https://kb.cnstreasury.com/cns-treasury-knowledge-base/hedge-accounting-ifrs9-compliance?hsLang=en#fx-hedge-accounting)
    - [Money Markets Hedge Accounting](https://kb.cnstreasury.com/cns-treasury-knowledge-base/hedge-accounting-ifrs9-compliance?hsLang=en#money-markets-hedge-accounting)
    - [Commodities Hedge Accounting](https://kb.cnstreasury.com/cns-treasury-knowledge-base/hedge-accounting-ifrs9-compliance?hsLang=en#commodities-hedge-accounting)
- [CNS Freemium](https://kb.cnstreasury.com/cns-treasury-knowledge-base/cns-freemium?hsLang=en#main-content)

    - [CNS Freemium User Assistance](https://kb.cnstreasury.com/cns-treasury-knowledge-base/cns-freemium?hsLang=en#cns-freemium-user-assistance)
- [Money Markets Module](https://kb.cnstreasury.com/cns-treasury-knowledge-base/money-markets-module?hsLang=en#main-content)

    - [Money Market Instruments](https://kb.cnstreasury.com/cns-treasury-knowledge-base/money-markets-module?hsLang=en#money-market-instruments)
    - [Money Market Exposure](https://kb.cnstreasury.com/cns-treasury-knowledge-base/money-markets-module?hsLang=en#money-market-exposure)
    - [Money Market Reporting](https://kb.cnstreasury.com/cns-treasury-knowledge-base/money-markets-module?hsLang=en#money-market-reporting)
- [Commodities Module](https://kb.cnstreasury.com/cns-treasury-knowledge-base/commodities-module?hsLang=en#main-content)

    - [Commodity Swaps](https://kb.cnstreasury.com/cns-treasury-knowledge-base/commodities-module?hsLang=en#commodity-swaps)
    - [Commodities Reporting](https://kb.cnstreasury.com/cns-treasury-knowledge-base/commodities-module?hsLang=en#commodities-reporting)
- [Product Workflows](https://kb.cnstreasury.com/cns-treasury-knowledge-base/product-workflows?hsLang=en#main-content)

    - [Foreign Exchange Module](https://kb.cnstreasury.com/cns-treasury-knowledge-base/product-workflows?hsLang=en#foreign-exchange-module)
    - [Money Markets Module](https://kb.cnstreasury.com/cns-treasury-knowledge-base/product-workflows?hsLang=en#money-markets-module)
    - [Commodities Module](https://kb.cnstreasury.com/cns-treasury-knowledge-base/product-workflows?hsLang=en#commodities-module)

[![](https://kb.cnstreasury.com/hubfs/CNS%20Logo%20Primary%20RGB-01.svg)](http://www.cnstreasury.com?hsLang=en)

cnstreasury.com Help Center

Copyright © 2026, CNS Treasury Limited