Create a Cash Flow 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.

Cash flow reports compute and display data from transaction cash flows.

 

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 Cash Flow Report
  1. Navigate to Reports.
  2. Click Add Report > Cash Flow 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 cash flows display, with a cash flow per row.

Breakdown_Groups_EN.png

Sort by

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

In this example, the cash flows are sorted by maturity date in ascending order.

SortBy_EN.png

TermToMaturity_EN.png

Aggregate Cash Flows
  1. Enable to group identical cash flows (same transaction, same currency, same day, same type) in the same row.

CashFlow_Aggregated_EN.png

  1. Disable to split all cash flows into multiple rows.

CashFlow_Split_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 cash flows 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