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

Schedule reports display all payments recorded in the transaction schedules during a defined reporting period.

Note: The start date of the schedule report is included in the computation, but the end date of the schedule report is excluded from the computation.

 

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 Schedule Report
  1. Navigate to Reports.
  2. Click Add Report > Schedule 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 payments display, with a payment per row.

Breakdown_Groups_EN.png

Sort by

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

In this example, payments are sorted by payment date in ascending order.

SortBy_EN.png

TermToMaturity_EN.png

Filter by

Display only payments matching the filter criteria.

  1. Start Date of Period: Only payments included in transaction periods starting in the report period display.

StartDateOfPeriod_EN.png

  1. End Date of Period: Only payments included in transaction periods ending in the report period display.

EndDateOfPeriod_EN.png

  1. Payment Date: Only payment dates included in the report period display.

PaymentDate_EN.png

  1. Fixing Date: Only fixing dates included in the report period display.

FixingDate_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 payments 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