Create a Periodic 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.

Periodic reports display a series of periods. You define the start and end dates, and the frequency of the periods.

 

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 Periodic Report
  1. Navigate to Reports.
  2. Click Add Report.
  3. Click Periodic 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_EN.png

Summary_Groups_EN.png

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

Breakdown_Groups_EN.png

Data display:

  • By Period: Each period of the selected frequency (e.g. a month) displays on different pages, with all indicators on the same page.

ByPeriod_EN.png

  1. By Indicator: Indicators display in different tabs, with all the periods in each tab.

ByIndicator_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

TermToMaturity_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

Currency Exportation

When exporting data to Excel:

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

Currency_With_EN.png

  1. Without Currency: Hide currencies.

Currency_Without_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_Report_EN.png

Columns

Order items to display from left to right.

Columns_EN.png

Columns_Report_EN.png

  1. Click Apply to create the report.

Report_Add_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