Create a Spot Report

Fairways Debt offers a comprehensive environment, enabling you to build and customize template-based reports.

A report is a set of predefined settings used to export a user-specific table, where all the transactions or cash flows in the current portfolio display in groups, aggregated indicators, and any number of columns.

Spot reports run on the analysis date provided by the current context, and only displays spot indicators.

 

Navigate to the Analysis & Reporting Application
  1. Log in to your Fairways Debt account, e.g. https://login.financeactive.com/login, and select a customer account and an organization, if relevant.
  2. Navigate to Applications Applications.png > Analysis & Reporting.

Dashboard_EN.png

 

Create a Spot Report
  1. Navigate to Reports.
  2. Click Add Report.
  3. Click Spot Report.

Reports_AddReport_EN.png

  1. Complete the form with all relevant details.

Field

Description

Name

Report name.

Description

Additional details about the report.

Description_EN.png

Overall Configuration

How transactions display:

  • Summary: Groups display, with a group per row. Select the group type(s) in the Groups field.

In this example, groups display by borrower name.

Summary_Groups_EN.png

Summary_EN.png

  1. Breakdown: All transactions display, with a transaction per row.

Breakdown_EN.png

Sort by

Select an item among the Columns items to sort the transactions by that item.

In this example, the transactions are sorted by term to maturity in ascending order.

SortBy_EN.png

Sort_EN.png

Swap Split Configuration

Display swaps:

  • Swap: As single transactions.

Swap_EN.png

  1. Swap Legs: Split into the two legs.

SwapLegs_EN.png

Lease Split Configuration

Display financial leases:

  • Lease: As single transactions.

Lease_EN.png

  1. Lease/DP: With downpayments split.

LeaseDP_EN.png

Guarantee Split Configuration

Display guarantees:

  • Guarantee: As single transactions.

Guarantee.png

  1. Collaterals: Split into collaterals.

Collaterals.png

Currency Exportation

When exporting data to Excel:

  1. With Currency: Show currencies in an adjacent column.

WithCurrency_EN.png

  1. Without Currency: Hide currencies.

WithoutCurrency_EN.png

Groups

Group transactions using selected items.

The first item is the main group, the following items are subgroups.

In this example, the first level is Transaction Category and the second level is Transaction Type, i.e. Transaction Type is the subgroup of Transaction Category.

Groups_EN.png

Groups_Display_EN.png

Columns

Order items to display from left to right.

Columns_EN.png

Columns_Display_EN.png

  1. Click Apply to create the report.

Report_Create_EN.png

The report displays in the Reports list.

Report_Added_EN.png

 

What's Next?
Was this article helpful?
0 out of 0 found this helpful